Remote Senior Database Administrator, PostgreSQL (Remote - India)

Description:

• This position is for a Senior Database Administrator specializing in PostgreSQL, located remotely in India.
• The role involves managing database infrastructures, ensuring high availability, performance, and reliability for critical business applications.
• Responsibilities include the installation, configuration, upgrade, and maintenance of PostgreSQL databases in various environments such as on-premises, virtualized, and cloud (AWS, GCP, Azure).
• The candidate will ensure database performance, availability, and security through monitoring, troubleshooting, and optimization.
• The role includes administering backup and disaster recovery plans, including Point-In-Time Recovery (PITR), replication, failover, and high availability solutions.
• The candidate will support database migrations from various engines (Oracle, MySQL, MSSQL) to PostgreSQL, ensuring smooth transitions and minimal downtime.
• Automation solutions using tools like Ansible, Terraform, Puppet, Chef, or SALT will be implemented to streamline database operations.
• Documentation for procedures, architectures, and client-specific implementations will be developed and maintained.
• Participation in presales activities, including proposals, technical discussions, and client visits, is expected as needed.
• The candidate will mentor junior team members, contribute to the team knowledge base, and provide technical leadership on complex projects.
• Monitoring of cloud-native and on-premises databases using tools like Prometheus, Grafana, SolarWinds, Zabbix, Nagios, Datadog, and CloudWatch/Stackdriver/Azure Monitor is required.

Requirements:

• A minimum of 10 years of experience with PostgreSQL database administration is required.
• Strong knowledge of PostgreSQL installation, configuration, and upgrades, including High Availability solutions (Patroni, repmgr) and backup tools (Barman, pgBackRest, pg_basebackup) is essential.
• Experience with cloud-based PostgreSQL deployments and migrations is necessary.
• Proficiency in scripting languages such as Bash and Python, along with familiarity with programming languages like C++, Java, and Go, is required.
• Strong debugging and troubleshooting skills with the ability to solve complex technical problems are essential.
• Experience with database automation tools (Ansible, Terraform, Puppet, Chef, SALT) is required.
• Knowledge of database monitoring tools and the ability to configure alerts, analyze metrics, and resolve performance issues is necessary.
• Experience with database migrations, schema conversions, and performance tuning post-migration is required.
• Excellent documentation, problem-solving, and communication skills are essential.
• Familiarity with IT service standards such as ITIL is a plus.
• Prior remote work experience and exposure to containerized or Kubernetes environments is desirable.
• Experience with EnterpriseDB (EDB) solutions, such as EDB Postgres Distributed (PGD) or EDB BigAnimal, is a plus.

Benefits:

• The position offers a competitive total rewards package with performance incentives.
• There is fully remote work flexibility along with a home office setup allowance.
• A substantial professional development budget is provided for training, certifications, and skill enhancement.
• A wellness allowance for gym memberships, fitness, and self-care is included.
• The role offers generous paid vacation, sick days, and volunteer day-offs.
• There is an opportunity to collaborate with industry experts on challenging and impactful database projects.
• The work environment is described as high-performance, supportive, and inclusive.