Senior Oracle DBA

$94,000 - $157,000/Yr

Mastercard - O'Fallon, MO

Part-time - Senior

O'Fallon, MO

Credit Intermediation and Related Activities

About the position

The Senior Oracle DBA plays a critical role within the Digital Service Delivery organization at Mastercard. This individual will lead large initiatives, gathering requirements through feature requests from development partners, performing analysis and implementation of database designs, providing consulting, and driving best practices, governance, and standards of Database Engineering within the company. The Digital Service Delivery team is looking for a candidate who can help solve problems, build and maintain databases, and lead Mastercard in database automation and best practices. The ideal candidate is a born problem solver with a low tolerance for manual work, seeking to automate processes wherever possible. They should have experience working in global teams across different geographies and possess an entrepreneurial spirit that embraces critical questioning, innovation, customer service, and continuous improvement. As a Senior Engineer in the Digital Service Delivery team, you will leverage your knowledge and skills to deploy and manage various database technologies in both Test and Production environments for global products, including Developer APIs, Digital Checkout, and Card Tokenization. The role requires managing a wide variety of databases, with a strong emphasis on database backup and recovery, performance tuning, and high availability configuration. The candidate should be highly experienced in multiple database technologies, including but not limited to Oracle, MS-SQL Server, PostgreSQL, DB2, Cassandra, and Redis. The position also involves forward-thinking infrastructure automation and scripting skills, managing client expectations, collaborating with other DBAs, and providing direction for best practices and application database solutions to Mastercard's development teams. Additionally, the role includes reviewing new tools and products that assist in providing database support and services, as well as planning and coordinating data migrations between systems.

Responsibilities

• Lead large database initiatives and manage various database technologies.
• Gather requirements through feature requests from development partners.
• Perform analysis and implementation of database designs.
• Provide consulting and drive best practices, governance, and standards in Database Engineering.
• Manage a wide variety of databases, focusing on backup and recovery, performance tuning, and high availability configuration.
• Collaborate with other DBAs and participate in internal projects.
• Provide DBA suggestions and input on database domain strategy.
• Guide and provide direction for best practices and application database solutions to development teams.
• Review new tools and products for database support and services.
• Plan and coordinate data migrations between systems.

Requirements

• Bachelor's Degree in Information Systems or equivalent experience.
• In-depth knowledge of database management including installation, creation of new instances, space management, backup and recovery, and performance monitoring.
• Strong working knowledge of RDBMS and NoSQL databases with relevant certifications.
• Hands-on database tuning and troubleshooting experience.
• Intermediate knowledge of Oracle replication implementation (Golden Gate/DataGuard).
• Intermediate knowledge of Oracle internals and middleware (OEM).
• Working knowledge of backup/recovery using RMAN for Oracle and Mongo OpsManager for Mongo.
• Working PL/SQL coding background.
• Understanding of logical and physical data models on structured and unstructured data patterns.

Nice-to-haves

• Experience in more than one database technology (Oracle, MS-SQL Server, PostgreSQL, DB2, Cassandra, Redis).
• Understanding of CAP theorem and its implementation in NoSQL Technologies.
• MongoDB design principles and cluster connectivity.
• Expertise in managing Redis cache.

Benefits

• Medical, prescription drug, dental, and vision insurance.
• 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.
• Gender-inclusive benefits.