Oracle Database Administrator

Genpact; Ciudad de México; Presencial; MXN 1.117.734 - 2.235.469; Jornada completa

Descripción de la vacante

Join a forward-thinking company as a Principal Consultant specializing in Oracle DBA. This role involves designing and implementing cutting-edge database technologies to enhance operational efficiency. You'll be responsible for ensuring database performance, security, and availability while collaborating with cross-functional teams. If you thrive in a dynamic environment and have a passion for innovative solutions, this position offers an exciting opportunity to make a significant impact. Your expertise in Oracle technologies and cloud infrastructure will be essential in driving success for leading enterprises. Embrace this chance to advance your career in a supportive and growth-oriented workplace.

Formación

• 8+ years of experience in Oracle database technologies required.
• Proficient in PL/SQL triggers and procedures preferred.
• Experience with cloud database infrastructure is a plus.

Responsabilidades

• Design and implement highly available production systems.
• Manage database performance and security issues.
• Participate in functional testing and troubleshooting.

Conocimientos

Oracle Database Technologies

PL/SQL

Database Tuning

Ansible Playbooks

Cloud Database Infrastructure

LINUX

Shell Scripting

Database Backup and Recovery

Oracle GoldenGate

High Availability Systems

Educación

Bachelor's Degree

Herramientas

Oracle Enterprise Manager

RMAN

Network Appliance Snapshots

Descripción del empleo

Get AI-powered advice on this job and more exclusive features.

Genpact (NYSE: G) is a global professional services and solutions firm delivering outcomes that shape the future. Our 125,000+ people across 30+ countries are driven by our innate curiosity, entrepreneurial agility, and desire to create lasting value for clients. Powered by our purpose – the relentless pursuit of a world that works better for people – we serve and transform leading enterprises, including the Fortune Global 500, with our deep business and industry knowledge, digital operations services, and expertise in data, technology, and AI.

Welcome to the relentless pursuit of better.

Inviting applications for the role of Principal Consultant – Oracle DBA

Job Description:

The Senior Database Administrator (DBA) is responsible for designing, developing, and implementing new technologies, as required, to support the technical capabilities at Cox Automotive. To be successful in this role, one must be able to work effectively in a fluid, fast-paced environment. This role requires good communication skills, both with team members and business contacts. In addition, the successful Database Administrator must be able to work with minimal supervision on multiple concurrent projects.

Responsibilities (including but not limited to):

1. Participate in functional test planning and testing for the assigned application(s), functional area(s) or project(s).
2. Participate in problem solving and troubleshooting for the assigned application(s), functional area(s) or project(s).
3. Share knowledge by effectively documenting work.
4. Respond quickly and effectively to production issues and taking responsibility for seeing those issues through resolution.
5. Resolve database performance issues, database capacity issues, replication, and other distributed data issues.
6. Install and maintain database software.
7. Manage backup and recovery of databases using RMAN and/or Network Appliance Snapshots.
8. Manage security of database structures and corporate data held within databases.
9. Develop database procedures, triggers, and SQL scripts for development teams.
10. Assist in the definition and implementation of database standards.
11. Review scripts submitted by the Development team to ensure that all standards are met.
12. Monitor databases for errors and perform problem determination when necessary.
13. Design and implement highly available production systems using the following technologies: Hot Standby/Data Guard, Oracle Goldengate, Advanced Queuing, Real Application Cluster (RAC), and Oracle Enterprise Manager.
14. Participate in on-call rotations.

Qualifications we seek in you!

Minimum Qualifications / Skills:

1. Bachelors degree or equivalent work experience.
2. 8+ years of experience in Oracle database technologies.

Preferred Qualifications/ Skills:

1. Prior experience writing PL/SQL triggers and/or procedures.
2. Experience with Database SQL and Database tuning.
3. Experience with Oracle GoldenGate.
4. Experience developing ansible playbooks is a plus.
5. Experience supporting Database infrastructure in the cloud (OCI, AWS, Azure).
6. Ability to work with minimal direction, yet also able to work in a team environment.
7. Working knowledge of LINUX and shell scripting.
8. Experience configuring database network connectivity.
9. Understanding of database backup and recovery techniques using RMAN and Network Appliance filers.
10. Experience with high volume websites that use multi-tier architectures is a significant plus.
11. Understanding or experience using Oracle Real Application Cluster’s and implementation best-practices.
12. Ability to analyze existing systems and make recommendations on which technology best suits the business requirement for high availability, Disaster Recovery or high performance.
13. Experience setting up and managing OEM 13c.

Genpact is an Equal Opportunity Employer and considers applicants for all positions without regard to race, color, religion or belief, sex, age, national origin, citizenship status, marital status, military/veteran status, genetic information, sexual orientation, gender identity, physical or mental disability or any other characteristic protected by applicable laws. Genpact is committed to creating a dynamic work environment that values respect and integrity, customer focus, and innovation. For more information, visit www.genpact.com.