Database Administrator - Oracle DB/MongoDB (8-10 yrs)

Job Description :

- Strong experience min 8 years in Oracle, Maria DB, Mongo DB, PostgreSQL and any other additional Database.

- Manage, maintain, and optimize Oracle databases (including versions 11g onwards up to 19c).

- Migrating data to SQL AND NOSQL DATABASES.

- Good to have knowledge in Administration, configuration, deployment, management, architecture, security of NOSQL Databases like REDIS, KEYDB, COUCH DATABASE.

- Install, configure, and upgrade Oracle database software, patches, and tools.

- Knowledge of regular database backups and implement robust disaster recovery solutions.

- Monitor database performance and take necessary actions to improve performance and scalability.

- Provide expert support in database troubleshooting, performance tuning, and query optimization.

- Implement and maintain database security policies, user access management, and auditing.

- Ensure compliance with internal security policies and external regulations.

- Tune database queries, optimize SQL performance, and improve indexing strategies.

- Monitor database resource usage and implement measures for optimal performance.

- Implement, Manage, maintain, and ensure high availability and manage Oracle Real Application Clusters (RAC).

- Implement, Manage, maintain, and ensure high availability and manage Oracle Data Guard, Oracle Golden Gate.

- Work closely with development teams to optimize database queries, applications, and configurations.

- Provide support to application teams for database-related issues and troubleshooting.

- Create and maintain documentation related to database architecture, standards, and procedures.

- Work on database consolidation and cloud database migration as required.

- Develop and maintain shell scripts and PL/SQL procedures for automation of database tasks.

- Lead database-related projects and ensure timely delivery of deliverables.

- Provide regular reports on database performance, health, and capacity.

Required Qualifications :

- Education : Bachelor's or Master's degree in Computer Science, Information Technology, or related field.

Experience :

- Minimum of 8 years of hands-on experience as an DBA.

- Understanding of cloud databases (AWS RDS, Oracle Cloud, etc.) is a plus.

- Oracle Certified Professional (OCP) or Oracle Certified Master (OCM) certification.

- Mandatory Certified (Any one) :

1) MONGODB/REDIS/CouchDB Certification from MONGODB University/REDIS University/ CouchBase

2) MARIADB or MYSQL Certification from OEM

Soft Skills :

- Excellent problem-solving and troubleshooting skills.

- Strong communication skills to interact with various teams and stakeholders.

- Ability to work under pressure and manage multiple tasks in a fast-paced environment.

- Strong attention to detail and organizational skills.

- Knowledge of ITIL practices and database management best practices.