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 [PostgreS 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