Senior PostgreSQL Database Administrator

ConfidentialHyderabad / Secunderabad, Telangana, India

6 days ago

Job description

Softility is currently seeking a Senior PostgreSQL Database Administrator to join our Hyderabad & Chicago, US offices. As a Senior Postgres DBA, you'll need to manage multiple projects simultaneously and make the best decisions in the moment and in the long term for the company. You will work in a team environment to provide expertise in relational databases, logical / physical database design, and support, including performance tuning, diagnosing problems, and addressing issues. You will be responsible for upgrades, performance monitoring, installations, managing data replication, diagnosing system problems, disaster recovery testing, and maintaining user accessibility. In addition, you will act as a lead technical resource for our IT application teams.

Responsibilities

Database Management, Installation, and Configuration : Configuring.
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.

Requirements

Education : Bachelor's degree in Computer Science, Information Technology, or a related field.

Experience : 10+ years of experience as a PostgreSQL Database Administrator.

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.

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.

This job was posted by Hymavati Sarojini from Softility.

Skills Required

Query Optimization, Documentation, Postgresql, Microsoft Sql Server, Shell Scripting, Troubleshooting, Security, Aws Rds, Terraform, Ansible, Database Management, Oracle, Python

Create a job alert for this search

Senior Database Administrator • Hyderabad / Secunderabad, Telangana, India