Search for Lead SQL DBA positions in O'Fallon, MO, requiring at least 5 years of experience, with skills in SQL Server, disaster recovery, and database security best practices. I would prefer full-time roles with benefits.

Okay, I've searched for Lead SQL DBA positions in O'Fallon, MO, that require a minimum of 5 years of experience, emphasizing SQL Server, disaster recovery, and database security best practices. I have found 45 positions that match your criteria, all offering full-time roles with benefits. You can explore them now.

Lead SQL DBA

O'Fallon, MO

5 years + Experience

SQL Server

disaster recovery

database security

Full Time

Can you help me to analyze the job description and company culture?

Sure. Here's the analysis:

Job Analysis:

The Lead SQL DBA role at Mastercard is fundamentally about overseeing and optimizing database management systems to enhance customer experiences. This means not only ensuring the technical performance and reliability of SQL Server databases but also playing a vital role in how these systems support the broader organizational goals of powering a digital economy. Key responsibilities include configuring, patching, upgrading, and optimizing database software, as well as collaborating with cross-functional teams to meet data requirements. Candidates may face challenges related to database security, performance tuning, and handling disaster recovery scenarios, requiring them to be adaptive and resourceful. Success in this role encompasses ensuring data integrity, effectively communicating technical solutions in business terms, and maintaining best practices to support the dynamic environment of Mastercard's database architecture.

Company Analysis:

Mastercard occupies a leading position within the global payments industry, aspiring to create an inclusive digital economy that benefits a wide array of stakeholders—from individuals to governments. This positioning suggests that the Lead SQL DBA will have considerable influence over critical systems that enhance customer and business experiences. Mastercard’s culture is articulated through its commitment to a 'decency quotient,' prioritizing ethical practices and security, which ultimately shapes the working environment. The Database Engineering team is likely to be collaborative and global, emphasizing the need for strong communication skills. This role plays a strategic part in tackling the company's tech challenges, supporting technological innovation that directly aligns with Mastercard's goals of enhancing transaction safety and accessibility. Given that this is a senior position, the Lead SQL DBA will be expected not only to contribute technically but also to mentor and guide other team members, making the role pivotal in shaping the future direction of database management within the organization.

Mock up some interview questions based on the job description.

Absolutely. Here are some mock interview questions that could come up:

Tell me about a time when you had to resolve a major performance issue in a database. What steps did you take, and what was the outcome?
Can you describe your experience with SQL Server Always On? How have you used it in previous roles?
Describe a project where you had to collaborate with cross-functional teams to meet specific data requirements. How did you facilitate communication?
How do you approach keeping up with database best practices and industry standards?
Explain your process for configuring and optimizing a SQL Server database. What tools do you commonly use?
What methods do you employ for database backup and recovery? Can you detail a situation where you successfully executed these methods?
Imagine you're handling a database that suddenly goes down. How would you diagnose the problem, and what steps would you take to restore functionality?
You are on call when a critical database system fails. Describe how you would manage the incident from start to finish.
Why are you interested in working at Mastercard specifically, and how does your background align with our mission?
In your opinion, what role does data security play in a database engineer's responsibilities, particularly in the payments industry?
What challenges do you foresee with cloud database management versus on-prem databases, and how have you navigated these in the past?
What insights have you gained from your previous work with data governance that you believe would be valuable at Mastercard?
How would you describe your leadership style, and how does it manifest in a collaborative team environment?
What questions do you have about Mastercard's approach to technology innovation and customer experience?

Job Details

Overview Company

Lead SQL DBA

$112k/y-$187k/y

Lensa

a day ago

Highlight

OnsiteFull-timeSenior

Summary

Mastercard is seeking a Lead SQL DBA to join their team in O'Fallon, MO. The role involves providing SQL Server Database support for Mastercard Application databases in both On-Prem and Cloud environments.

About the Role

As a Lead SQL DBA, you will drive customer experience strategy by innovating and problem-solving. Responsibilities include configuring, patching, upgrading, and optimizing database software, understanding database security, and resolving database issues. You will collaborate with cross-functional teams to optimize database performance and ensure data integrity and security. The role requires SQL Server Always On knowledge and the ability to handle disaster scenarios.

About You

Required:

Bachelor's degree in Computer Science, Information Technology, or related field.
Proven work experience as a Database Engineer or similar role with expertise in managing SQL Server databases.
Strong understanding of database management systems (DBMS), especially SQL Server.
Proficiency in working with Windows and Linux based operating systems.
Experience with database design, normalization, and optimization techniques.
Advanced skills in monitoring and reporting tools such as Dynatrace and Splunk.
Familiarity with database security best practices such as implementation of SSL/TLS, TDE, and access management principles.

Preferred:

Additional scripting knowledge.

Benefits

Competitive base salary of $112k–$187k based on location, experience, and qualifications.
Eligibility for an annual bonus or commissions.
Comprehensive benefits package including medical, prescription drug, dental, vision, disability, and life insurance.
Flexible spending account and health savings account.
Paid leaves including 16 weeks new parent leave and up to 20 paid days bereavement leave.
10 annual paid sick days and 10 or more annual paid vacation days based on level.
5 personal days and 10 annual paid U.S. observed holidays.
401k with a best-in-class company match.
Deferred compensation for eligible roles.
Fitness reimbursement or on-site fitness facilities.
Eligibility for tuition reimbursement and gender-inclusive benefits.

Lensa

What if we could take the search out of job search? This is the question Lensa has been answering since launching in San Francisco, California in August 2016. Using machine learning, we instantly provide companies with candidates and match professionals with positions that fit their skills, goals, personalities, and needs. How does it work? Lensa applies complex algorithms that identify the skills needed to succeed on a given job. Candidates can play computer games that assess their work style, thus gaining insight into their strengths while unlocking career opportunities. The result: job search that puts people first while reducing the time and cost of talent acquisition.

Lensa passed 10 million job seeker registrations in 2019, making the com- pany one of the premier career platforms.

With teams in multiple U.S. locations and a 60-strong crew of developers and data scientists at its R & D headquarters in Europe, Lensa is working every day to share its transformative career technology with the world.

O'Fallon, MO