Job Details
Experience Needed:
Career Level:
Education Level:
Salary:
Job Categories:
Skills And Tools:
Job Description
- Manage PostgreSQL DBs through multiple lifecycle environments - Dev, QA, Staging and Production.
- Use your deep technical knowledge to analyze and solve critical issues, providing end-to-end problem resolution.
- Assist Development with complex query tuning and schema refinement.
- Perform scheduled maintenance and support release deployment activities, after working hours.
- Ensure all alerts have been acknowledged and escalated as needed.
- Monitor and report on system performance.
- Plans and analyzes risk associated with system upgrades.
- Designs, implements, and administers backup and disaster recovery solutions for key databases.
- Helping to implement, deliver and test backups in a way which meets key Recovery Point Objectives.
- Prepare and present status and technical reports as required.
- Troubleshooting DB server service outages as they occur, including after-hours/weekend support.
- Help define and implement DB High Availability strategies including DB Clustering and Always On availability groups.
- As new applications are implemented, help choose the best Recovery Time/Recovery Point objectives, including DB High Availability strategies including DB Clustering and Always-on availability groups, log shipping, replication, etc.
- Identifies faults, raise trouble tickets and provides resolution of complex problem requests.
- Act as the subject matter expert for all services under service catalog and to help troubleshoot specific capacity and performance issues.
- Install and configure new DB servers from scratch.
- Develop and maintain capacity and performance metrics to track overall infrastructure trends.
- Maintain Service Level Agreements (SLA) with internal and external customers.
- Prepare executive summary of the SLA measurement, program achievements and root cause analysis when SLA targets are not achieved.
- Enforce, maintain, and document compliance, maximum uptime and performance with all established standards.
- Collaborate with IT teams and management to devise a data strategy that addresses industry requirements.
Job Requirements
- Bachelor's degree in communication/computer engineering, computer science or equivalent.
- 3-5 years working experience in a similar environment.
- Database administration experience in PostgreSQL.
- Experience implementing high availability strategies and managing virtual machines.
- Troubleshooting PostgreSQL issues.
- Strong query tuning and performance problem-solving skills.
- Strong RMAN backup and recovery skills.
- Strong SQL DDL, DML, and PLSQL coding skills.
- Excellent verbal and written communication skills.
- Experience with Database upgrade, enhancement and migration.
- Ability to meet deadlines and manage project delivery.
- Excellent report-writing and presentation skills.
- Critical thinking and problem-solving capabilities.