PostgreSQL Database Administrator

2 months ago


Andheri Mumbai Maharashtra, India Syncwell Infotech Private Limited Full time

**L1 PostgreSQL Database Administrator**

Job Summary:
The L1 PostgreSQL Database Administrator is responsible for routine database operations, including monitoring, maintenance, and basic troubleshooting. This role is crucial in ensuring the continuous availability and performance of PostgreSQL databases, handling day-to-day tasks with guidance from higher-level DBAs.

**Technical Responsibilities**:
**Database Monitoring & Alerting**:
Utilize monitoring tools like pgAdmin, Prometheus with Grafana, or Nagios to track key PostgreSQL metrics (e.g., query execution times, CPU/IO load, replication status).

Set up and manage alerting systems to notify about thresholds breaches (e.g., disk space, connection limits).

**Backup and Recovery Management**:
Execute regular backups using tools like pg_dump, pg_basebackup, and configure automated backup scripts.

Perform data restoration using pg_restore and validate backup integrity using checksums and test restores.

**User Management and Security**:
Manage PostgreSQL roles and privileges using SQL commands (CREATE ROLE, GRANT, REVOKE).

Enforce basic security protocols, including SSL configuration and enforcing password policies.

**Basic Performance Tuning**:
Perform routine maintenance tasks like VACUUM, VACUUM FULL, ANALYZE, and REINDEX to optimize table performance.

Identify and create indexes based on slow query logs (pg_stat_statements).

**Database Maintenance & Housekeeping**:
Monitor and maintain logs using pgBadger for performance insights and log rotation.

Implement periodic pg_repack or cluster operations to reorganize tables and indexes.

**Patching and Updates**:
Validate patches in a staging environment before production deployment.

**Basic Troubleshooting**:
Diagnose and resolve common issues like connection timeouts, lock contention, and missing indexes.

Use PostgreSQL diagnostic views (pg_stat_activity, pg_locks) for issue identification.

**Documentation and Reporting**:
Document standard operating procedures (SOPs), database configurations, and maintenance scripts.

Maintain an incident log for database issues and resolutions.

**Technical Skills**:
Operating Systems: Proficient in Linux/Unix (e.g., CentOS, Ubuntu), with basic shell scripting.

PostgreSQL Tools: psql, pgAdmin, pg_dump, pg_restore, pg_basebackup.

SQL: Basic to intermediate SQL scripting, query tuning, and optimization.

Monitoring Tools: Prometheus, Grafana, Nagios, pg_stat_statements.

Scripting: Basic Bash/Python for automation of routine tasks.
---------------------------------------------------------------------------------------------------------------------
- **Job Title**:
**L2 PostgreSQL Database Administrator**

Job Summary:
The L2 PostgreSQL Database Administrator handles advanced database tasks, including performance tuning, replication, and disaster recovery planning. This role involves in-depth troubleshooting and optimizing database systems to ensure efficient operations and high availability.

**Technical Responsibilities**:
**Advanced Performance Tuning**:
Perform in-depth query optimization using EXPLAIN, EXPLAIN ANALYZE, auto_explain, and pg_stat_statements.

Optimize PostgreSQL configuration parameters (shared_buffers, work_mem, maintenance_work_mem, effective_cache_size) for performance improvements.

Implement partitioning strategies and fine-tune indexing (including BRIN, GIN, and GiST indexes).

**Replication & High Availability**:
Set up and manage replication configurations (e.g., streaming replication, logical replication).

Implement and monitor high-availability solutions using tools like Patroni, pg_auto_failover, or PgBouncer for connection pooling.

**Backup & Disaster Recovery**:
Design and implement comprehensive backup strategies using pgBackRest, Barman, or custom scripts.

Develop and regularly test disaster recovery plans, including Point-In-Time Recovery (PITR) scenarios.

**Security Hardening**:
Enforce advanced security measures, including database encryption (e.g., TLS, data-at-rest encryption), role-based access control (RBAC), and auditing with tools like pgAudit.

Conduct regular security audits and vulnerability assessments.

**Data Migration & Upgrades**:
Plan and execute major version upgrades using techniques like pg_upgrade, and handle data migrations with mínimal downtime.

Perform cross-platform migrations (e.g., from Oracle to PostgreSQL) using tools like Ora2Pg.

**Troubleshooting & Root Cause Analysis**:
Perform deep-dive troubleshooting of complex issues (e.g., deadlocks, replication lag, high latency queries) using PostgreSQL logs, pg_stat_activity, pg_locks, pg_stat_user_tables.

Lead incident response and root cause analysis for critical production issues.

**Automation & Scripting**:
Develop automation scripts for routine database tasks (e.g., backups, monitoring) using Bash, Python, or Ansible.

Implement Infrastructure as Code (IaC) for PostgreSQL environments using tools like Terraform.

**Documentation & Mentori



  • Pune, Maharashtra, India HiringGo Full time

    **Job Profile - PostgreSQL Database Administration** **Location - Pune** **Mode - On Site** We are looking for a highly skilled **PostgreSQL Engineer** to join our team. As a PostgreSQL Engineer, you will be responsible for the design, implementation, optimization, and ongoing management of PostgreSQL database systems to ensure their efficiency,...


  • Pune, Maharashtra, India Codvo.ai Full time

    Company Overview: - At Codvo, software and people transformations go together. We are a global empathy-led technology services company with a core DNA of product innovation and mature software engineering. We uphold the values of Respect, Fairness, Growth, Agility, and Inclusiveness in everything we do. We are looking for an experienced 8 to 10 years and...


  • Mumbai, Maharashtra, India GrayMatrix Full time

    Job DescriptionIn our quest for excellence, we're seeking a skilled PostgreSQL Database Administrator to join our team at Gray Matrix IT Solutions. As a key member of our technical staff, you will be responsible for managing and maintaining high availability, scalability, and security of our PostgreSQL databases.We're looking for an individual with in-depth...


  • Mumbai, Maharashtra, India GrayMatrix Full time

    Job OverviewWe are seeking an experienced PostgreSQL database administrator to join our team at GrayMatrix. This role involves managing and maintaining high availability, scalability, and security of our PostgreSQL databases.


  • Mumbai, India Ashnik Full time

    **Open Positions: 1**:** Location**: Mumbai** **The Position**: Ashnik is looking for a talented and passionate person to join our Technical Delivery Team in Mumbai. **Qualification and Experience**: - 4 to 5 years of hands on administration experience of working on PostgreSQL Database - Experience of working in a production support environment -...


  • Mumbai, Maharashtra, India Expleo Group Full time

    **Overview**: 4+ years of experience as a Database Administrator **Responsibilities**: 4+ years of experience as a Database Administrator Proficiency administering PostgreSQL Extensive experience performing general troubleshooting database maintenance activities including backup and recovery, capacity planning, and managing user accounts. Experience in...


  • Mumbai, Maharashtra, India Tata Consultancy Services Full time

    Job DescriptionThe Database Administrator will play a key role in ensuring the smooth operation of our databases, focusing on PostgreSQL administration and technical support. The ideal candidate will have hands-on experience with PostgreSQL and MySQL, with a strong understanding of database administration, server software installation, configuration,...


  • Mumbai, Maharashtra, India Searce Full time

    Job description **5 day working from Office** **Location** - Mumbai & Pune **Experience** - 3 to 12 years **Key Responsibilities**: **Primary Database Expertise**: One resource should have PostgreSQL as their primary database expertise. One resource should have MySQL as their primary database expertise. One resource should have either PostgreSQL or...


  • Mumbai, Maharashtra, India Tata Consultancy Services Full time

    Job OverviewTata Consultancy Services is a global leader in the technology arena and we are seeking a skilled PostgreSQL Database Administrator to join our team.About the RoleThis exciting opportunity will allow you to utilize your technical expertise to administer and maintain our database systems, ensuring high availability and optimal performance.Key...


  • Mumbai, India GrayMatrix Full time

    Job Description :- Manage and maintain PostgreSQL databases, ensuring high availability, scalability, and security.- Perform installations, upgrades, and configuration of PostgreSQL clusters.- Implement effective backup and recovery strategies to ensure data protection and minimize downtime.- Monitor database performance and identify bottlenecks to optimize...


  • Mumbai, Maharashtra, India Tata Consultancy Services Full time

    Inviting Applications for Database Administrator Job Title: Database Admin Experience Required: 8 to 16 years Location: Mumbai - Minimum 8 years of Hands-on PostgreSQL & EDB DB database - Knowledge Performance Tunning & High Availability. - Expertise in PostgreSQL, proficiency in SQL Qualifications :BACHELOR OF ENGINEERING


  • Andheri, Mumbai, Maharashtra, India Sanda Office Management Services Pvt. Ltd Full time

    **Working Environment - Sanda Group Office (MIDC, Andheri East)** **Working Days - Monday to Saturday (2nd & 4th Saturday off)** **Timings: 11:00 a.m. to 8:00 p.m.** **Key Responsibilities**: - Manage and maintain databases, ensuring their performance, availability, and security. - Write and optimize SQL queries, functions, and stored procedures. -...


  • Mumbai, India TransUnion Full time

    TransUnion's Job Applicant Privacy Notice **What We'll Bring**: **What You'll Bring**: EDB & Open source PostgreSQL Installation, setting up replication and failover manager. Configuration of Master-Slave setup, and performing DR switchover and switchback. Ensures security/CIS Baseline implementation of EDB & Open source PostgreSQL DB’s. Shell scripting...

  • Database Administrator

    2 months ago


    Navi Mumbai, Maharashtra, India Wikilabs Full time

    **Urgent Hiring Database Administration - Small Finance Bank - Navi Mumbai** **Skills**: Database Administration on **Postgres and MS SQL** **Total exp**: 5+yrs in relevant domain. **RESPONSIBILITIES**: - Install, configure, and upgrade PostgreSQL - MS SQL databases,Monitor and optimize database performance, including query optimization and index...

  • Crest IT Consulting

    1 month ago


    Navi Mumbai, India Crest IT consulting Full time

    Job Summary : We are seeking a skilled and proactive Database Administrator (DBA) to manage and optimize our MySQL and PostgreSQL, Ms-SQL databases for our software platform. The ideal candidate will ensure database reliability, performance, scalability, and security. You will play a key role in fine-tuning queries, creating and managing indexes, optimizing...

  • Database Administrator

    5 months ago


    Mumbai, Maharashtra, India hirezy.ai Full time

    **Job Title**:Database Administrator **Position Type**: In-Office **Location**: Vashi, Navi Mumbai **Experience Required**: 4+ years Experience We are looking for an experienced Database Administrator to join our team! As a Database Administrator at CarTrade Tech Ltd, you will be responsible for designing, testing, planning, implementing, protecting,...


  • Mumbai, India Zycus Full time

    Global Delivery Pune, Bangalore, Mumbai Zycus is looking out for Database Administrator having expertise in PostgreSQL Database solutions including, database installation, configuration, performance tuning, troubleshooting, and backups, monitoring and enhancements. **Responsibilities**: - The DBA will be responsible for understanding operational...


  • Mumbai, Maharashtra, India Tata Consultancy Services Full time

    Job SummaryWe are seeking an experienced PostgreSQL Database Architect to join our team at Tata Consultancy Services in Mumbai.About the RoleThis is a challenging opportunity for a senior database professional to design and implement large-scale PostgreSQL databases. The ideal candidate will have extensive experience with PostgreSQL, Java, and...

  • Database Administrator

    4 months ago


    Fort, Mumbai, Maharashtra, India Fast Track Jobs Full time

    We requires 2 **Database Administrator (DBA) for a IT Company at Fort** Salary : Nego Exp : Min 1-7Yrs Need immediate Joiner. Designation **:Database Administrator (DBA)** Requirements **:1 Sr / 1 Jr** Job Summary: We are seeking a skilled Database Administrator (DBA) with a strong background in SQL, PostgreSQL, and CI/CD processes. The DBA will be...

  • PostgreSQL Dba

    7 months ago


    Mumbai, Maharashtra, India Just Compile LLP Full time

    **Qualifications**: **Education and Experience**: - Bachelor’s degree in Computer Science, Information Technology, or a related field. - 3-5 years of experience as a PostgreSQL DBA or in a similar role. **Technical Skills**: - Proficiency in PostgreSQL database management and administration. - Experience with PostgreSQL backup and recovery, replication,...