PostgreSQL

ConfidentialDelhi

30+ days ago

Job description

Key Responsibilities :

Database Installation & Configuration :

Install and configure PostgreSQL databases in production and development environments.

Perform database migrations from older systems or versions to the latest PostgreSQL versions.

Set up replication and failover processes for high availability.

Database Maintenance & Administration :

Monitor and ensure database performance is optimized (e.g., query performance , indexing , disk I / O , etc.).

Perform backup and restore operations to ensure data integrity and disaster recovery.

Regularly update and patch the database to the latest version for security and performance.

Data integrity checks , data migrations , and management of schemas and tables .

Performance Tuning & Optimization :

Use performance monitoring tools to identify and resolve performance issues such as slow queries and resource bottlenecks .

Optimize SQL queries and database design to ensure efficient performance at scale.

Create and maintain indexes and optimize the query execution plan for critical applications.

Security Management :

Ensure the security of the database by managing access control , user roles , and permissions .

Implement encryption for data in transit and at rest.

Regularly audit database access and activities to ensure compliance with security standards.

Replication & High Availability :

Configure and maintain PostgreSQL replication (both master-slave and multi-master ) setups for high availability.

Manage clustering and failover procedures to ensure database uptime.

Backup & Recovery :

Implement a reliable backup strategy using tools like pg_dump , pg_basebackup , or continuous archiving .

Ensure point-in-time recovery (PITR) is set up and functional.

Perform periodic testing of disaster recovery procedures.

Troubleshooting & Support :

Provide day-to-day support for PostgreSQL databases including diagnosing and resolving database-related issues.

Troubleshoot database connectivity issues , performance bottlenecks, and integrity problems.

Respond to critical issues or outages promptly to restore database availability.

Collaboration & Documentation :

Collaborate with development teams to optimize database queries and ensure database performance.

Document database configurations, procedures, backup strategies, and any changes made to the system.

Maintain clear and accurate records of database incidents, tickets, and resolutions.

Capacity Planning & Scalability :

Plan for capacity and growth in database storage and resources to meet organizational needs.

Perform scalability testing to ensure the database can handle increasing loads efficiently.

Required Qualifications :

2-5 years of experience as a PostgreSQL Database Administrator or similar database management role.

Solid experience with PostgreSQL installation , configuration , and maintenance .

Proficient in SQL (including complex queries, joins, etc.) and PostgreSQL-specific functions .

Hands-on experience with PostgreSQL replication , clustering , and high availability setups.

Experience with backup and restore strategies , disaster recovery procedures, and point-in-time recovery .

Strong troubleshooting skills for database performance issues, including query optimization and indexing .

Experience with monitoring tools (e.g., pgAdmin , Nagios , Prometheus , Grafana ) to analyze database performance.

Knowledge of security best practices and managing user roles and permissions in PostgreSQL.

Familiarity with PostgreSQL extensions like PostGIS (for geospatial data) or pg_partman for partition management is a plus.

Familiarity with cloud platforms (AWS RDS, Azure Database for PostgreSQL) is an advantage.

Bachelor's degree in Computer Science , Information Technology , or related field.

Skills Required

Postgresql, Grafana, Prometheus, Nagios, pgadmin

Create a job alert for this search

Postgresql • Delhi

Related jobs

Promoted

PostgreSQL DBA

Technogen India Pvt. Ltd.Delhi, India

Role : PostgreSQL Database Administrator (DBA) - Work mode – 5 days WFO - UK Shift – 2 PM to 11 PM - Work Location : Hyderabad - Exp : 9-12 Years. Please share your resumes to rajamahender.We are loo...Show moreLast updated: 2 days ago

Promoted

GCP Data Architect

Tata Consultancy Servicesdelhi, delhi, in

Design and Implement Data Architectures : Architect and build scalable, end-to-end data solutions on GCP, encompassing data ingestion, transformation, storage, and consumption.Develop Data Pipelines...Show moreLast updated: 25 days ago

Promoted

Postgres SQL Developer

ACL DigitalDelhi, India

We are looking for ideal candidate with below expertise as must.Strong SQL (PostgreSQL is mandatory) Develop and optimize complex SQL queries in PostgreSQL. Knowledge of aggregate function, Windows ...Show moreLast updated: 2 days ago

Promoted

PostgreSQL Engineer L3

GenpactDelhi, India

PostgreSQL Engineer L3 Location : Hyderabad Experience : 5-8 years Immediate joiners preferred.Please share resume to nsenthil. PostgreSQL L3" along with notice period.Responsibilities Act as subject ...Show moreLast updated: 3 days ago

Promoted

Senior PostgreSQL DBA Architect

Sonata SoftwareDelhi, India

In today's market, there is a unique duality in technology adoption.On one side, extreme focus on cost containment by clients, and on the other, deep motivation to modernize their Digital storefron...Show moreLast updated: 13 days ago

Promoted

Database Engineer II- (Python,SQL,Automation)

Tekion CorpDelhi, India

As a Database Engineer II at Tekion, you will design, automate, and optimize database operations across our cloud-native automotive retail platform connecting OEMs, dealerships, partners, and consu...Show moreLast updated: 3 days ago

Promoted

GCP Data Architect

HCLTechNoida, Uttar Pradesh, India

Total years of experience : 12+ Years.Location : Noida, Bangalore, Chennai, Pune, Hyderabad.Relevant experience for engagement : 10 Years. Maintain architecture principles, guidelines and standards.Pro...Show moreLast updated: 30+ days ago

Promoted

Staff PostgreSQL Database Administrator- Billion Dollar Global Enterprise Software Product Company -

CareerXperts ConsultingDelhi, India

Staff DBA to pioneer the architecture and management of our next-generation hybrid data platform, which unifies RDBMS, NoSQL search, and cutting-edge vector databases to power our flagship SaaS sol...Show moreLast updated: 16 days ago

Promoted

AWS PostgreSQL Database Administrator (DBA)

SpringbordDelhi, IN

AWS PostgreSQL Database Administrator (DBA).This role is ideal for a skilled database professional who can ensure high performance, reliability, and automation of database operations in a cloud env...Show moreLast updated: 2 days ago

Promoted

PostgreSQL Engineer L2

GenpactDelhi, India

Kindly share resume to nsenthil.Sub of "PostgreSQL L2" along with notice period.Perform daily monitoring and administration of PostgreSQL databases across various environments.Manage database user ...Show moreLast updated: 3 days ago

Promoted

Senior PostgreSQL Developer

Prophecy TechnologiesDelhi, India

AWS RDS / Aurora, GCP Cloud SQL / Spanner).Secondary Skills : Knowledge of.PostGIS, pg_stat_statements, TimescaleDB).Show moreLast updated: 24 days ago

Promoted

POSTGRES MSSQL DBA

AccelyaDelhi, India

Database Administrator – Pune, India.As a Database Administrator, you will operate, optimize, and ensure the availability of Accelya’s cloud databases. You will also plan and execute the seamless mi...Show moreLast updated: 2 days ago

Promoted

Python, Pyspark, SQL, GCP

Tata Consultancy ServicesNoida, Uttar Pradesh, India

TCS present an excellent opportunity for Python, Pyspark, SQL, GCP.Job Location : TCS Noida Yamuna.Experience required : 7-12 yrs. Walk in Interview Date : 08-Nov-25 (Saturday.ReactJS and Python f / w f...Show moreLast updated: 1 day ago

Promoted

Postgres Developer

ACL DigitalDelhi, India

We are looking for ideal candidate with below expertise as must Strong SQL (PostgreSQL is mandatory) Develop and optimize complex SQL queries in PostgreSQL. Knowledge of aggregate function, Windows ...Show moreLast updated: 2 days ago

Promoted

PL / SQL Linux

Tata Consultancy ServicesDelhi, India

Role : PL / SQL Linux Experience : 4 to 10 Years Locations : Chennai / Pune / Kolkata Must-Have : Production support – L2 ( Tech Stack : Unix, SQL, Mongo DB, open shift). Monitor / Configuration alerts in IT...Show moreLast updated: 3 days ago

Promoted

Postgres Database Developer

Alp Consulting Ltd.Delhi, India

As a Senior Postgres Database Developer, you will play a pivotal role in designing, developing, and maintaining scalable database solutions that support critical business functions.This position re...Show moreLast updated: 3 days ago

Promoted

Senior Database Administrator (PostgreSQL on AWS RDS or Aurora)

CirrusLabsDelhi, India

As a senior database administrator, you will be responsible for the administration, optimization, and reliability of Liongard's core platform database. You will work closely with development and Dev...Show moreLast updated: 3 days ago

Promoted

PostgreSQL DBA

LTIMindtreeDelhi, India

Location - Bangalore / Hyderabad.Notice Period - Immediate to 30 days.Interested candidates please share your updated CV to v.Show moreLast updated: 30+ days ago