Senior Oracle Administrator

Experience: 8 to Not Available years

Location: Chennai, India

Skills: PostgreSQL, Oracle, OCI, Azure, AWS, EDB PostgreSQL, PEM, Oracle Certified professional, Oracle Databases 12c, Oracle Databases 19c, Oracle RAC, Data Guard, OEM, Golden Gate, Unix, RHEL

Job Summary
Oracle DB Administrator
Total Experience -8+ Years
Relevant Experience -> 8 Years
PostgreSQL*. 8+ year of hands-on experience working on PostgreSQL database technologies.*. Certification -Postgresql Professional [Essential]

Key Responsibilities
Oracle DB
Use considerable technical expertise and judgement to define and implement technical database solutions that support the business needs.
Provide optimization and design skills, including deployment and support in the oracle database systems both on-premise and cloud.
Provisioning and administration of oracle in cloud - OCI, Azure, AWS.
Refine / Develop database strategies and capacity planning.
Ensure database system desired performance and security baselines are met as per business need.
Ensure HA / DR database environments are operational and consistent as per business requirements.
Perform housekeeping tasks to maintain the database environment.
Identify opportunities for continuous improvement in work practices.
Participate in after-hours changes and patching.
Provide strategic input to design and quality assurance of database technology solutions.
Confer with systems users to develop areas of change in requirements, which permit greater efficiency, systems integration, or cost reduction.
Provide effective and efficient database system support to customers meeting all ticket / requests / Change SLAs.
Assist application support teams with performance tuning and troubleshooting.
Contribute to the creation of technical strategies.




Continually evaluate working practices and procedures to help the implementation of cost-effective database methodologies.
Mentoring / Training Team Members.
Handling tickets / requests.
Perform root cause analysis.
Troubleshooting technical issues.
Defining processes [SOP/MOP's] and ensuring that the processes are adhered to.
Oversees and is responsible for successful completion of database tasks.
Responsible for maintaining customer database standards.
Responsible for strategizing a backup plan and test plan for failure scenario.
Improves and maintains customer satisfaction.
Suggests Database environment Gaps, Improvements and new technologies.
Monitoring and maintaining SLA requirements by the team members.
Identify Skill gaps and plan for training / knowledge updating.
Ensure Oracle database system desired performance and security baselines are met as per business need.
Ensure HA / DR database environments are operational and consistent as per business requirements.
Identify opportunities for continuous improvement in work practices.

Additional responsibilities include:
Provide strategic inputs / advice on end to end Database Solutions for Technology projects.
Research and drive long term database strategies and solutions.
Availability for out of hours scheduled work such as change implementation and Disaster Recovery tests.
Liaison with customers and vendors.
Provide consultancy to other technical and project teams regarding technical issues pertaining to database environments.




Develop and maintain installation, configuration and maintenance policies and standards.
Participate in disk space management.
Execution of major and minor database work requests.

Skill Requirements
Responsibilities: - (PostgreSQL)
• Adhering to SLAs.
• Mentoring / Training Team Members.
• Handling tickets / requests.
• Perform root cause analysis.
• Troubleshooting technical issues.
• Creating [SOP/MOP's] and ensuring that the processes are adhered to.
• Oversees and is responsible for successful completion of database tasks.
• Responsible for maintaining customer database standards.
• Responsible for strategizing a backup plan and test plan for failure scenario.
• Improves and maintains customer satisfaction.
• Suggests Database environment Gaps, Improvements and new technologies.
• Monitoring and maintaining SLA requirements by the team members.
• Identify Skill gaps and plan for training / knowledge updating.
• Escalating P1/P2 to L3/Customer to maintain SLA’s.

Technical Requirements
(PostgreSQL)
• Proficient in managing EDB PostgreSQL databases [HADR and replication] - installation, configuration, upgrade, patching, maintenance, security, sysadmin functions and administration.
• Proficient in managing PostgreSQL DR [Replication] - installation, configuration, upgrade, patching, maintenance, DR Drills.
• Knowledge of PEM [PostgreS Enterprise Manager] - Managing, Configuring, setting up alerts and troubleshooting.

Other Requirements
Relevant technology domains:
PostgreSQL
Oracle Certified skilled
Knowledge of other cloud environment – OCI, AWS, Azure
Oracle Databases – 12c, 19c and above.
Oracle RAC and Data Guard Setup
Tools: OEM, Golden Gate
Operating System: Unix, RHEL

📌 Senior Oracle Administrator (Chennai)
🏢 HCL Technologies
📍 Chennai