Postgresql Administrator

Desired Background

• Bachelors degree in computer science, Business Administration, Information Technology or related field preferred.
• 4-8 years PostgreSQL database administration experience.
• At least 5 year working experience on production database administration.
• Must have good knowledge of Backups, Log shipping, Database replication, performance tuning, Always -on cluster.
• Good understanding of system tables and schema.
• Good problem solving & analytical Skills.
• Good interpersonal, written, and oral communication skills.
• Self-motivated and directed.
• Able to prioritize and execute tasks in a high-pressure environment.
• Experience working in a team-oriented, collaborative environment.

Roles and Responsibilities

• Ensure all database servers are backed up in a way that meets the business Recovery Point Objectives (RPO).
• Test backups to ensure the business Recovery Time Objectives (RTO).
• Troubleshoot Database Servers (MS SQL, PostgreSQL) service outages as they occur, including after-hours and weekends.
• Configure SQL Server monitoring utilities to minimize false alarms.
• Install and configure new SQL Servers & Always-On cluster implement clustering, log shipping, mirroring, replication.
• Install and configure PostgreSQL server Setup replication.
• Installation and configuration of pg_pool, pg_bouncer.
• Troubleshooting of PostgreSQL cluster.
• Deploy database change scripts provided by development team.
• Upgradation of DB server to next version..
• Implement security patches.