Senior Oracle Administrator - Oracle Administration,PostgreSQL,MYSQL, MS SQL

Job Summary

Oracle DB Administrator:

Total Experiecnce - 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 Postgre

S Enterprise Manager:

• Managing, Configuring, setting up alerts and troubleshooting

Other Requirements

Relevant technology domains:PostgreSQL

• Oracle Certified professional

• 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