PostgreSQL Database Administrator

Softility; Hyderabad; On-site; INR 1,200,000 - 2,400,000; Full time

Job summary

A technology firm in Hyderabad is seeking a skilled database administrator with expertise in PostgreSQL management. The role involves installation, configuration, and optimization of PostgreSQL databases, ensuring high availability and security. The ideal candidate should possess 5 to 15 years of experience, have strong knowledge of cloud solutions, and excellent problem-solving abilities. Familiarity with AWS and automation tools like Terraform and Ansible is preferred.

Qualifications

• 5 to 15 years of experience in database management.
• Expert in PostgreSQL database management and administration.
• Strong knowledge of shell scripting.
• Strong shell scripting and automation experience.

Responsibilities

• Manage installation and configuration of databases.
• Optimize queries for high performance and availability.
• Automate routine database tasks and maintenance.
• Plan and execute data migration projects across cloud environments.
• Write and optimize complex SQL queries (joins, subqueries, window functions).
• Advanced data manipulation and bulk operations.
• Scripting to automate routine maintenance tasks.
• Implement security measures: encryption, auditing, access control.
• Diagnose and resolve complex issues using logs and metrics.
• Create and maintain database documentation and runbooks.
• Collaborate with developers and system administrators to ensure integrity and security.

Skills

PostgreSQL database management

Database backup and recovery

Performance tuning

AWS RDS

Strong communication skills

AWS RDS and AWS DMS

PostgreSQL extensions

Problem-solving

Communication and teamwork

Education

Certification in PostgreSQL administration

Tools

Terraform

Ansible

Python

Quest Foglight

MS SQL Server

Oracle

Yugabyte

Job description

Employment Type

Full-time

Experience

5 to 15 Years

Required Skills

• Expertise in PostgreSQL database management and administration
• Expertise in database backup and recovery solutions.
• Expertise in database security practices.
• Expertise in at least one shell scripting language
• Deep understanding of performance tuning, including indexing strategies, query optimization, and monitoring tools.
• Strong knowledge of AWS RDS and AWS DMS
• Experience using PostgreSQL extensions
• Excellent problem-solving skills and attention to detail.
• Strong communication and teamwork abilities.

Preferred Qualifications

• Certification in PostgreSQL administration.
• Experience with other cloud database solutions
• Experience with Terraform and Ansible
• Experience with Python scripting
• Experience administering Microsoft SQL Server, Oracle, or Yugabyte
• Experience using Quest Foglight to solve performance problems

Responsibilities

• Database Management, Installation, and Configuration.
• PostgreSQL for high performance, including tuning parameters and optimizing hardware.
• High Availability and Replication: Setting up and managing high availability solutions, such as replication, clustering, and failover mechanisms. Plan and execute data migration projects to PostgreSQL or other database platforms across public/private cloud environments.
• Query Optimization: Writing and optimizing complex SQL queries, including joins, subqueries, and window functions.
• Advanced Data Manipulation: Handling complex data manipulation tasks, including bulk data operations and data transformations.
• Scripting and Automation: Writing scripts to automate routine database tasks and maintenance.
• Security: Implementing security measures, such as encryption, auditing, and fine-grained access control.
• Troubleshooting: Diagnosing and resolving complex issues, often involving deep dives into logs, system performance metrics, and query execution plans.
• Documentation: Create and maintain database documentation, including data standards, procedures, and operational runbooks.
• Collaboration: Work closely with developers, system administrators, and other stakeholders to ensure database integrity and security.