PostgreSQL – Database Administration and Performance Optimization

Experience Required:

Primary Skills:

Cloud Platform:

Working Mode:

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

1. PostgreSQL Database Administration & Management

• 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.

3. Azure Data Factory (ADF) & Data Integration

• 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.

4. Deployment & Collaboration

• 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.

amisha.bose@truelancer.com