Senior Oracle Database Administrator

Overview

The Database Engineer plays a critical role within the Processing Service Delivery organization. This individual will lead large initiatives, be responsible for gathering requirements through feature requests from our development partners, perform analysis and implementation of database designs, provide consulting, and drive the best practice, governance, and standards of Database Engineering in Mastercard.

Responsibilities

• Oracle database administration with RAC.
• Oracle Data Guard.
• Oracle OEM.
• Oracle patching and upgrades.
• Oracle backups and restores.
• Oracle performance tuning.
• Oracle GoldenGate replication.
• Oracle Exadata.
• Manage a wide variety of databases, with strong experience in backup/recovery, performance tuning, and high-availability configurations. Technologies include Oracle, PostgreSQL, NoSQL (added advantage); experience in more than one database technology is preferred.
• Forward-thinking infrastructure automation and scripting skills.
• Lead in managing client expectations and communicate proactively.
• Require little supervision while identifying tasks within responsibilities.
• Collaborate with other DBAs, participate in internal projects, and lead some initiatives.
• Provide DBA input on the direction for database domain strategy.
• Guide and provide direction for use of best practices and application database solutions to Mastercard's development teams.
• Review new tools and products that enhance database support and services.
• Plan and coordinate data migrations between systems.

Education (preferred)

Bachelor's Degree in Information systems or equivalent experience.

Knowledge/Experience (preferred)

• In-depth knowledge of database management (installation, creation of new instances, space management, database reorganization and internals, backup and recovery, replication, performance monitoring and troubleshooting, identification of bottlenecks in locks, waits).
• Strong working knowledge of RDBMS and NoSQL databases with relevant certifications.
• Good understanding of security standards and best practices around database platforms.
• Hands-on database tuning and troubleshooting experience.
• Intermediate knowledge of Oracle replication (GoldenGate/Data Guard).
• Intermediate knowledge of Oracle internals.
• Intermediate knowledge of Oracle middleware (OEM).
• Intermediate knowledge of Oracle physical database tuning.
• Intermediate knowledge of SQL tuning.
• Working knowledge of backup/recovery using RMAN for Oracle.
• Working PL/SQL coding background.
• Intermediate knowledge of partitioning and/or sharding concepts.
• Working knowledge of Oracle RAC, Cluster Resource software, and Oracle features.
• Knowledge of multiple database technologies (including Oracle, PostgreSQL, NoSQL). Experience in more than one technology is preferred.
• Understanding of CAP theorem and its implementation in NoSQL technologies.
• Understanding of logical and physical data models on structured and unstructured data patterns.
• Demonstrates understanding of Database Engineering's role in supporting business processes.
• Demonstrates ability to participate in cross-functional teams for estimating, application designs, and implementation strategies.

Skills/Abilities

• Uses strong verbal and written communication skills to promote DBA positions in support of sound database structures, data governance, and other corporate strategies.
• Ability to multi-task and prioritize efforts.
• Ability to quickly learn new technologies.
• Ability to work with team members located in multiple geographies.
• Demonstrates excellent collaboration with cross-functional teams.
• Provides positive customer service to internal business partners.

Corporate Security Responsibility

• Abide by Mastercard's security policies and practices.
• Ensure the confidentiality and integrity of information accessed.
• Report any suspected information security violation or breach.
• Complete all periodic mandatory security trainings in accordance with Mastercard's guidelines.

Seniority level

• Mid-Senior level

Employment type

• Full-time

Job function

• Information Technology

Industries

• Financial Services, IT Services and IT Consulting, and Technology, Information and Internet

Location: Dublin, Ireland

#J-18808-Ljbffr

---