Database Engineer (PostgreSQL)

Fluentgrid; NTR; Presencial; INR 1.400.000 - 2.000.000; Jornada completa

Descripción de la vacante

Fluentgrid Limited is seeking a skilled PostgreSQL Database Engineer to manage and optimize PostgreSQL databases. Based in Visakhapatnam/Vijayawada, you will design schemas, tune queries, ensure data integrity, and implement backup, recovery, and HA strategies.

The role requires 2–5 years of hands-on PostgreSQL experience, strong SQL/PL/pgSQL skills, and the ability to collaborate with developers and architects on data-heavy applications.

Formación

• Bachelor's degree in Computer Science, IT, or a related field.
• 2+ years of hands-on PostgreSQL DB management and development.
• Experience in performance optimization and production support.
• Strong analytical and problem-solving skills.

Responsabilidades

• Design and implement database schemas, tables, indexes, views, and stored procedures
• Develop and optimize complex SQL queries and PL/pgSQL functions
• Perform database performance monitoring, troubleshooting, and query optimization
• Implement database backup, recovery, and disaster recovery strategies
• Configure and manage database replication, clustering, and high availability
• Ensure database security, access controls, and data integrity
• Work with developers and solution architects for database design and integration
• Support database migration, ETL processes, and data synchronization
• Monitor database health, capacity, and resource utilization
• Prepare database documentation and operational procedures

Conocimientos

PostgreSQL administration

SQL and PL/pgSQL

Database design

Performance tuning

Linux/Unix

Security & access management

Replication & HA

ETL processes

Data modeling

Educación

Bachelor's degree in Computer Science/IT

Herramientas

PgBouncer

Patroni

Linux shell

Descripción del empleo

Role: Database Engineer (PostgreSQL)

Experience: 2 - 5 Yrs

Location: Visakhapatnam/Vijayawada

Employment Type: Full-time

Job Summary

We are looking for a skilled PostgreSQL Database Engineer to manage, maintain, and optimize PostgreSQL databases. The candidate will be responsible for database design, performance tuning, data integrity, backup and recovery, and high availability to ensure reliable and efficient database operations.

Key Responsibilities

• Design and implement database schemas, tables, indexes, views, and stored procedures
• Develop and optimize complex SQL queries and PL/pgSQL functions
• Perform database performance monitoring, troubleshooting, and query optimization
• Implement database backup, recovery, and disaster recovery strategies
• Configure and manage database replication, clustering, and high availability
• Ensure database security, access controls, and data integrity
• Work closely with application developers and solution architects for database design and integration
• Support database migration, ETL processes, and data synchronization
• Monitor database health, capacity, and resource utilization
• Prepare database documentation and operational procedures

Required Technical Skills

• Strong knowledge of PostgreSQL database administration and development
• Proficiency in SQL and PL/pgSQL programming
• Good understanding of database architecture, schema design, indexing, and partitioning
• Experience in query execution plans, performance tuning, and optimization
• Knowledge of stored procedures, functions, triggers, and views
• Understanding of database backup, recovery, and replication mechanisms
• Knowledge of PostgreSQL high availability and disaster recovery concepts
• Experience working in Linux/Unix environments
• Understanding of database security, roles, privileges, and access management
• Knowledge of data modeling and ETL processes

Qualifications and Experience

• Bachelor's degree in Computer Science, Information Technology, or a related field.
• Minimum 2+ years of hands-on experience in PostgreSQL database management and development.
• Experience in database performance optimization and production support.
• Good analytical, troubleshooting, and problem-solving skills.

Preferred Skills

• Knowledge of PostgreSQL automation and monitoring tools.
• Exposure to PostgreSQL replication and clustering solutions such as Patroni.
• Knowledge of connection pooling tools such as PgBouncer.
• Exposure to database migration, version upgrades, and large-volume data handling.
• Familiarity with DevOps practices and database CI/CD automation.

Key Competencies

• Strong database troubleshooting and analytical skills
• Ability to work independently and collaboratively with development teams
• Good communication and documentation skills
• Ability to support production environments and resolve critical database issues