PostgreSQL – Database Administration and Performance Optimization

Truelancer Staffing; India; A distancia; INR 900.000 - 1.500.000; Jornada completa

Descripción de la vacante

Truelancer Staffing in India is seeking an experienced PostgreSQL Database Administrator to manage PostgreSQL databases, tune performance, and build Azure Data Factory pipelines.

You will handle backups, migrations, and production deployments, monitor queries and execution plans, and collaborate with application and infra teams to ensure secure access and reliable data movement across environments. The ideal candidate will own DB operations end-to-end with a focus on stability and scalability.

Formación

• 6–8 years of PostgreSQL DBA experience.
• Strong hands-on experience with database administration and performance tuning.
• Experience designing, deploying, and monitoring Azure Data Factory pipelines.

Responsabilidades

• Create, configure, and maintain PostgreSQL databases, schemas, tables, views, indexes, and functions.
• Manage user roles, permissions, and access controls.
• Perform maintenance, monitoring, and troubleshooting; ensure backups and recoveries.
• Support migrations and deployments across environments.
• Design and optimize SQL queries and execution plans; monitor performance.

Conocimientos

PostgreSQL

SQL

Azure Data Factory

Database Administration

Performance Optimization

Herramientas

pg_dump

pg_restore

pg_basebackup

Azure DevOps

ADF Pipelines

Descripción del empleo

Experience Required: 6–8 Years

Primary Skills: PostgreSQL, Azure Data Factory (ADF), SQL, Database Administration, Performance Optimization

Working Mode: Remote

Job Summary

We are looking for an experienced PostgreSQL Database Administrator with strong hands‑on expertise in database administration, performance tuning, SQL optimization, and Azure Data Factory (ADF). The ideal candidate should have experience managing PostgreSQL databases, optimizing database performance, developing and monitoring data pipelines, and supporting database deployments and migrations across multiple environments.

The candidate should be capable of independently managing database operations, troubleshooting complex issues, and collaborating with application and infrastructure teams.

Key Responsibilities

• Create, configure, maintain, and manage PostgreSQL databases and database objects, including schemas, tables, views, indexes, sequences, functions, and triggers.
• Manage database schemas, ownership, permissions, users, roles, and access controls.
• Perform database maintenance, configuration, monitoring, and troubleshooting.
• Manage database backup and recovery using utilities such as pg_dump, pg_restore, and pg_basebackup.
• Support database migrations, schema modifications, releases, and production deployments.

2. Database Performance Optimization

• Monitor database health, resource utilization, connections, CPU, memory, disk space, and storage growth.
• Analyze query execution plans using EXPLAIN and EXPLAIN ANALYZE.
• Identify and resolve slow-running queries, blocking sessions, locking issues, and performance bottlenecks.
• Optimize SQL queries, joins, subqueries, indexes, and database structures.
• Monitor database workload and implement performance-tuning strategies.
• Design, develop, and maintain Azure Data Factory pipelines.
• Configure linked services, datasets, triggers, and integration runtimes.
• Implement pipeline orchestration, scheduling, monitoring, and error handling.
• Troubleshoot pipeline failures and ensure reliable data movement.
• Integrate data across relational databases, cloud storage, and on-premises systems.
• Use Azure DevOps for version control, source code management, and deployment activities.
• Support database changes and deployments across development, testing, and production environments.
• Troubleshoot database connectivity and application-related data issues.
• Coordinate with application development, cloud, and infrastructure teams.
• Follow database security, data integrity, and change management best practices.

Required Technical Skills

• PostgreSQL: Database administration, schema management, database objects, user/role management, indexing, backup and recovery.
• SQL: Strong SQL development, complex queries, joins, subqueries, query tuning, and execution plan analysis.
• Azure Data Factory: Pipeline development, orchestration, linked services, datasets, triggers, integration runtimes, and monitoring.
• Azure DevOps: Git, version control, repository management, and deployment pipelines.
• Database Performance Tuning: Query optimization, indexing strategies, execution plans, locking, and performance monitoring.
• Data Integration: Experience integrating relational databases, cloud storage, and on-premises systems.

Preferred Qualifications

• Hands‑on experience managing PostgreSQL databases in development and production environments.
• Experience with PostgreSQL high availability, replication, and disaster recovery concepts.
• Understanding of database security, encryption, access management, and auditing.
• Experience with Azure Database for PostgreSQL is an added advantage.
• Exposure to automated database deployments and CI/CD pipelines.
• Experience troubleshooting production database and data pipeline issues.
• Familiarity with Linux/Unix environments and database scripting is desirable.

Candidate Profile

• Strong analytical and problem-solving skills.
• Ability to independently manage database administration and performance optimization activities.
• Good communication and stakeholder management skills.
• Ability to work collaboratively with cross-functional teams.
• Strong ownership of production issues and timely resolution of technical challenges.