Oracle Database Administrator

Position : Oracle Database Administrator

Experience : 3+ Years

Location : As per company discretion

Job Type : Full-time

Job Summary :

We are seeking a skilled Oracle Database Administrator (DBA) to join our end-to-end Database Delivery team.

The ideal candidate will have at least 3+ years of total IT experience, with a minimum of 2+ years of relevant experience in Oracle database implementation and support.

This role is crucial for ensuring the security, performance, and optimization of our enterprise-wide database systems.

You will work in a collaborative environment, providing technical expertise and support for a variety of Oracle versions while also working closely with Application Development, Infrastructure Engineering, and Operations Support teams.

Key Responsibilities :

Database Administration & Support :

- Provide technical support for and resolve issues related to Oracle databases ranging from version 11g to 19c (CDB/PDB and Standalone) on Linux/AIX Operating Systems.

- Maintain and administer data infrastructure security policies by managing roles and privileges.

- You will be responsible for evaluating existing security procedures and identifying new areas of risk to safeguard enterprise information.

Performance & Optimization :

- Utilize basic database analytical skills to improve application performance.

- Manage database elements, including the creation, alteration, and deletion of schemas, tables, views, indexes, stored procedures, and triggers.

- You will also perform data replication and management tasks.

Collaboration & Communication :

- Work closely with cross-functional teams to deliver and support secured and optimized database solutions.

- Communicate technical and functional issues clearly to stakeholders and provide recommendations.

Troubleshooting & Tools :

- Identify and resolve problems using structured tools and techniques.

- You should have working knowledge of a ticketing system like ServiceNow, and be familiar with key Oracle utilities such as SQLPLUS, RMAN, OEM, and Data Pump.

Required Skills & Qualifications :

Education : A Bachelors degree in Computer Science, Information Systems, or a related field.

Experience : 3+ years of total IT experience, with 2+ years of relevant experience in Oracle database administration.

Technical Skills :

- 2+ years of experience with application database implementation.

- Hands-on experience with Oracle versions 11g to 19c.

- Expertise in Unix and Linux operating systems.

- Knowledge of Oracle utilities like RMAN, OEM, and Data Pump.

- Experience with backup and recovery methods (Data Pump, RMAN).

- Hands-on experience with performance tuning using AWR, ADDM, and SQLTRPT.

- Experience in Data Guard configuration for disaster recovery.

- Experience with database switchover and failover procedures.

- Basic experience with automation tools and scripting (Shell, Python, Ansible).

- Experience with monitoring tools like Oracle Enterprise Manager (OEM) and Elastic.

Work Environment :

- The ability to work in a 24/7 rotational shift to support production, development, and test databases.

Preferred Skills :

- Limited experience with Oracle GoldenGate for data replication.

- Experience with cloud computing platforms like Azure or OCI.

- Understanding of modern IT infrastructure such as Cloud Architecture and Agile DevOps Framework.

- Experience with geographically distributed and culturally diverse teams