Job Description

Job Type: Full Time

Locations: Hyderabad - India

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:

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.