MUMBAI · FULLTIME
Postgre Database Administrator
Winjit Technologies
Mumbai · onsite · Posted 48d ago
Sourced from
Undisclosed10–16 yrsfulltimeMumbai
About a minute. You'll make an account on the way through.
agent · working
- Read this posting0.5s
- Found the form on Naukri · 14 questions to answer1.0s
- Decided the answers for all of them3.0s
- Tailor your résumé to this role
- Waiting for you
Section · 01
About this role
- Strong hands-on experience in PostgreSQL database administration, installation, configuration, upgrades, patching, and maintenance.
- Experience in Oracle to PostgreSQL migration, including database assessment, schema conversion, data migration, validation, and production cutover.
- Convert and optimize Oracle SQL, PL/SQL, procedures, functions, packages, triggers, sequences, and data types for PostgreSQL.
- Strong expertise in SQL query development, query analysis, troubleshooting, and performance tuning.
- Analyze execution plans using EXPLAIN / EXPLAIN ANALYZE and optimize queries, indexes, joins, and database structures.
- Develop SQL, PL/pgSQL, Shell/Bash scripts for database administration, migration, monitoring, and automation.
- Design and execute database backup and restore strategies for production and non-production environments.
- Configure and manage automated PostgreSQL backups, WAL archiving, retention, and backup monitoring.
- Perform regular restore and recovery testing to validate backup integrity and recovery procedures.
- Hands-on experience with Point-in-Time Recovery (PITR) and database recovery from backup/WAL.
- Manage DC (Primary) to DR replication and ensure database synchronization between environments.
- Perform DC to DR failover/switchover activities and validate application/database connectivity after DR activation.
- Perform DR to DC failback/switchover and ensure data synchronization before restoring the primary environment.
- Monitor replication health, replication lag, WAL, database availability, and recovery status across DC and DR.
- Experience with PostgreSQL streaming replication, physical replication, logical replication, and HA configurations.
- Plan and execute DR drills, including database failover, recovery, validation, and rollback activities.
- Monitor database performance, availability, capacity, and health using PostgreSQL and enterprise monitoring tools.
- Configure alerts for CPU, memory, disk utilization, connections, locks, deadlocks, slow queries, replication lag, WAL growth, and database availability.
- Use tools such as pg_stat_statements, pgBadger, Prometheus/Grafana, CloudWatch, ELK/OpenSearch, or equivalent monitoring solutions.
- Troubleshoot slow queries, database locks, deadlocks, connection issues, replication failures, storage issues, and performance bottlenecks.
- Perform database capacity planning, storage forecasting, and database growth analysis.
- Manage PostgreSQL users, roles, privileges, authentication, and database security.
- Implement and maintain least-privilege access, auditing, encryption, and security controls.
- Manage VACUUM, ANALYZE, autovacuum, table/index maintenance, partitioning, and database housekeeping.
- Perform PostgreSQL version upgrades, patching, configuration changes, and extension management.
- Support production deployments and database changes, including deployment validation and rollback planning.
- Maintain database SOPs, backup/restore procedures, DR runbooks, migration documents, monitoring dashboards, and troubleshooting guides.
- Work closely with application, DevOps, infrastructure, security, and architecture teams for database-related activities.
- Provide root cause analysis (RCA) for production database incidents and implement corrective/preventive actions.
- Ensure database operations comply with availability, performance, security, backup, and DR requirements.
- Experience with large-volume/high-transaction PostgreSQL databases is preferred.
Sourced from naukri
Section · 02
Skills
PostgresqlTroubleshootingDatabase DevelopmentDatabase Designdbadatabase maintenancePerformance monitoringDatabase ManagementDatabase
Section · Company
About Winjit Technologies
Winjit Technologies
IT Services & Consulting
1k+
employees
2004
22 years old
Nashik,Maharashtra
India
About
Winjit specializes in designing strategic, state-of-the-art, AI-first approach solutions to all business problems.
Industries
IT Services & ConsultingInternetHardware & NetworkingSoftware Product
Employee ratings
264 reviews
3.6/ 5
Culture
3.6
Career growth
3.0
Work-life
3.6
Employees rate it well for
Work Life Balance29Work Culture28Learning24Senior Management21Work Environment20
Find them on