Senior PostgreSQL Database Administrator
S M Software Solutions Inc
Date: 3 weeks ago
City: Hyderabad, Telangana
Contract type: Full time
Job Title: Senior PostgreSQL Database Administrator
Experience : 10+ years
Location : Hyderabad
Mode : Onsite
Notice Period : Immediate joiners
Job Responsibilities
Experience : 10+ years
Location : Hyderabad
Mode : Onsite
Notice Period : Immediate joiners
Job 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.
- Education: Bachelor’s degree in Computer Science, Information Technology, or a related field.
- Experience: 10+ years of experience as a PostgreSQL Database Administrator
- 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.
- 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
How to apply
To apply for this job you need to authorize on our website. If you don't have an account yet, please register.
Post a resumeSimilar jobs
Senior Account Payable Processor
Optum,
Hyderabad, Telangana
7 hours ago
Optum is a global organization that delivers care, aided by technology to help millions of people live healthier lives. The work you do with our team will directly improve health outcomes by connecting people with the care, pharmacy benefits, data and resources they need to feel their best. Here, you will find a culture guided by inclusion, talented peers, comprehensive...
Trainee - Laboratory Medicine - 49539
Apollo BGS Hospitals,
Hyderabad, Telangana
13 hours ago
Job Identification 34737 Posting Date 11/03/2025, 04:31 AM Apply Before 11/30/2025, 04:31 AM Degree Level Graduate Job Schedule Full time Locations No. 8-2-293/82-J-III/DH/900,, Hyderabad, Telangana, 500033, IN
Product Application Engineer
AMD,
Hyderabad, Telangana
1 day ago
WHAT YOU DO AT AMD CHANGES EVERYTHINGAt AMD, our mission is to build great products that accelerate next-generation computing experiences—from AI and data centers, to PCs, gaming and embedded systems. Grounded in a culture of innovation and collaboration, we believe real progress comes from bold ideas, human ingenuity and a shared passion to create something extraordinary. When you join AMD,...
