
Senior Oracle Database Administrator
- Dublin
- Permanent
- Full-time
The Processing Service Delivery team is looking for a candidate who can help us solve problems, build and maintain our databases, and lead Mastercard in Database automation and best practices.
- Are you a born problem solver who loves to figure out how something works?
- Do you have a low tolerance for manual work and look to automate everything you can?
- Are you interested in leading the database realm for a high-functioning Engineering team?
- Have you worked in global teams across differing geographies?
- Do you an entrepreneurial spirit and embrace critical questioning, innovation, customer service and continuous improvement?
- Oracle database administrator with RAC.
- Oracle data guard.
- Oracle OEM.
- Oracle patching and upgrades.
- Oracle backups and restores.
- Oracle performance tuning.
- Oracle Golden gate replication.
- Oracle Exadata.
- Managing wide variety databases, particularly must be highly experienced in database backup and recovery, performance tuning, and high availability configuration. Database technologies include (but are not limited to): Oracle, PostgreSQL, NoSQL [added advantage]. The ideal candidate should have experience in more than one database technology.
- Forward thinking infrastructure automation and scripting skills.
- Leads in managing client’s expectations and communicates proactively.
- Requires little supervision while identifying tasks associated with responsibilities
- Collaborates with other DBAs, participates in internal projects and leads some initiatives.
- Provide DBA suggestions and input on direction for database domain strategy.
- Guides and provides direction for use of best practices and application database solutions to Mastercard’s development teams.
- Reviews new tools and products that assist in providing database support and services.
- Plans and coordinates data migrations between systems.
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 implementation (Golden Gate/DataGuard).
- Intermediate knowledge of Oracle internals.
- Intermediate knowledge of Oracle middleware (OEM).
- Intermediate knowledge of Oracle physical database tuning.
- Intermediate knowledge of SQL tuning background.
- Working knowledge of backup/recovery using RMAN for Oracle.
- Working PL/SQL coding background.
- Intermediate implementation knowledge of partitioning and/or sharding concepts.
- Working knowledge of Oracle RAC, Cluster Resource software and Oracle features.
- Knowledge of multiple database technologies (including but not limited to): Oracle, PostgreSQL, NoSQL. The ideal candidate should have experience in more than one database technology.
- Understanding of CAP theorem and its implementation in NoSQL Technologies.
- Understanding of logical and physical data models on structured and unstructured data patterns.
- Demonstrates an understanding of Database Engineering’s role in supporting business processes.
- Demonstrates the ability to participate in cross functional teams for estimating, application designs, and implementation strategies.
- Uses strong verbal and written communication skills to build awareness and to proactively promote DBA’s position in support of sound database structures, data governance and other Corporate strategies.
- Ability to multi-task and prioritize efforts.
- Ability to pick up new technologies at a quick pace.
- Ability to work with team members located in multiple geographies
- Displays excellent collaborative skills with cross-functional teams.
- Provide positive customer service to internal business partners.