Sql Dba jobs

• Bachelor's degree or equivalent practical experience.
  
• 8 years of experience in software development.
  
• 5 years of experience with design and architecture; and testing/launching software products.
• Experience with relational databases, including open source MySQL or Postgres.

• Master’s degree or PhD in Engineering, Computer Science, or a related technical field.
  
• 8 years of experience with data structures/algorithms.
• 5 years of experience in a technical leadership role leading project teams and setting technical direction.
  
• 3 years of experience working in an organization involving cross-functional, or cross-business projects.

• Bachelor's degree or equivalent practical experience.
  
• 8 years of experience in software development.
  
• 5 years of experience testing, and launching software products.
  
• 5 years of experience building and developing large-scale infrastructure, distributed systems or networks, or experience with compute technologies, storage, or hardware architecture.
  
• Experience with relational databases and building cloud database services.
• Experience with AI/ML technologies or infrastructure.

• Master’s degree or PhD in Engineering, Computer Science, or a related technical field.
  
• 8 years of experience with data structures/algorithms.
• 3 years of experience in a technical leadership role leading project teams and setting technical direction.
  
• 3 years of experience working in a complex, matrixed organization involving cross-functional, or cross-business projects.

As a Quant analytics senior associate within the Consumer and Community Banking Data & Analytics organization, you will support advanced analytics projects across various functions, channels, and products. You will play a crucial role in generating actionable insights to drive portfolio growth, inform product design and marketing tactics and enhance the customer experience. Additionally, you will consult with internal business partners, develop valuable business analyses, and promote strategic insights throughout the organization.

Job Responsibilities:

• Collaborate with team of analysts responsible for analyzing, measuring, and optimizing our existing customer marketing investments and tactics across multiple channels
• Leverage our data to scale our ability to optimize the entire customer lifecycle, with a focus on spend engagement, deepening and retention for co-brand partners
• Understand and master a broad range of analytics capabilities (Test design, Modeling, NLP analysis, etc.) and how to best apply them to business problems
• Drive excellent practices and technical standards to support the development KPIs and goals for the card business, developing information suites (Dashboards, reports, visualizations) fit for C-level consumption
• Present findings and recommendations for action to senior leaders of the company, and support the individual contributors on your team to do the same for their work
• Partner closely with co-brand internal/external team to drive understanding of the data and its use in their business area and across line of business

Required qualifications, capabilities, and skills:

• Bachelors in Science in a quantitative discipline - Statistics, Math, Finance, Economics, Operations Research, etc.
• 2+ years of analytical and industry experience in credit card, T&E retail, direct marketing, financial or other consumer orientated businesses, that capture and leverage a large transactional database
• 2+ years Knowledge of SQL and SAS required.
• Exceptional analytical, technical, and statistical skill. Ability to synthesize/analyze diverse information, develop and recommend strategies, and make decisions.
• Excellent written and oral communication skills; possessing the ability to convey complex information - simply and clearly - to senior business leaders.
• Strong financial and reporting acumen with specific understanding of key drivers of credit card profit and loss.
• Ability to work in a fast-paced, dynamic environment.
• Ability to manage multiple projects and prioritize work requirements across a multi-disciplinary team setting.

Preferred qualifications, capabilities, and skills

• Masters in Science in quantitative discipline or MBA preferred.
• Considerable background in consumer segmentation, customer profiling, and data mining

Job responsibilities

• Executes software solutions, design, development, and technical troubleshooting with ability to think beyond routine or conventional approaches to build solutions or break down technical problems
• Creates secure and high-quality production code and maintains algorithms that run synchronously with appropriate systems
• Produces architecture and design artifacts for complex applications while being accountable for ensuring design constraints are met by software code development
• Gathers, analyzes, synthesizes, and develops visualizations and reporting from large, diverse data sets in service of continuous improvement of software applications and systems
• Proactively identifies hidden problems and patterns in data and uses these insights to drive improvements to coding hygiene and system architecture
• Contributes to software engineering communities of practice and events that explore new and emerging technologies
• Adds to team culture of diversity, opportunity, inclusion, and respect

Required qualifications, capabilities, and skills

• Formal training or certification on software engineering concepts and 3+ years applied experience
• Hands-on practical experience in system design, application development, testing, and operational stability

• Extensive experience and expertise in SQL Server development, including proficiency in creating stored procedures, functions, triggers, views, and performance tuning of stored procedures

• Strong knowledge of one or more scripting languages, particularly T-SQL and PowerShell

• Experience in building applications using Python

• Experience with integrated development environments such as IntelliJ and VSCode

• Knowledge and experience with automation and version control tools such as Ansible, Jenkins, SaltStack, Bitbucket, and GitHub

• Strong knowledge of one or more infrastructure disciplines, including hardware, networking terminology, databases, storage engineering, deployment practices, integration, automation, scaling, resilience, and performance assessments.

• Experience with multiple cloud technologies, with the ability to operate in and migrate across public and private clouds.

• Overall knowledge of the Software Development Life Cycle
• Solid understanding of agile methodologies such as CI/CD, Application Resiliency, and Security

Preferred qualifications, capabilities, and skills

• Experience with JavaScript and JSON and troubleshooting complex database problems
• Exposure to Micro service architecture, REST API design/development
• Exposure on Database High Availability solutions like Log-Shipping, Database Mirroring, Replication, Clustering and AlwaysON
• Exposure to using PerfMon/Profiler, solved low-level SQL Server bottlenecks like Dead Locks/Long running queries

Job responsibilities

• Administer, design, implement and support highly available and scalable Mainframe DB2 & IMS database solutions
• Implement data models, database designs, data access and table maintenance codes.
• Implement and maintaining the DB2/IMS Databases with High Availability features using Data Partitioning and Database replications.
• Resolve database performance issues, database capacity issues, replication and other data issues.
• Work with Information Architects and Database Designers to implement the physical data model.
• Develop the database performance monitoring process and analyze data for optimization opportunities.
• Provide up to Level 2 on call support for the 24/7 DB2/IMS database environment.
• Manage on-site backup and recovery process.
• Plan for and execute required database upgrades or migrations.
• Work with database admin tools like CA Platinum/ BMC/ IBM Admin tools, Mainview, IBM Data Studio, BMC Recovery management etc.

Required qualifications, capabilities, and skills

• Formal training or certification on software engineering concepts and 5+ years applied experience
• Database design/development, integration, performance monitoring & tuning, systems re-engineering and Operations support.
• Knowledge of DB2 for z/OS along with mainframe related tools such as BMC, CA Platinum for monitoring, SMPE, ISPF, SMS, SMF.
• Expertise with IMS Full Function/Fast Path database implementation, REXX programming and MQ
• Experience in IBM Replication CDC , QREP.
• Capable of creating the roadmap, processes, best practices, standards, and strategies for continuous improvement, resiliency, and scalability.
• Experience with Atlassian tools like Jira, Confluence.
• Proven background on database engineering, automation, monitoring, performance engineering design and implementations.
• Strong execution mind-set to manage and track progress against transformation goals.
• Knowledge of industry-wide technology trends and best practices.

Preferred qualifications, capabilities, and skills

• Experience providing 24x7 rotational support.
• Understanding of Distributed and Static SQL workloads
• Familiar with IDAA (Data Analytics Accelerators)