PostgreSQL Database Administrator

4 days 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

  • PostgreSQL Database Administrator

    3 weeks ago

    Mumbai, Maharashtra, India Tata Consultancy Services Full time

    At Tata Consultancy Services, we are seeking an experienced PostgreSQL Database Administrator to join our team.The ideal candidate will have strong knowledge of PostgreSQL database administration, including installation, configuration, and tuning.The selected candidate will also have experience with database backup and recovery tools and strategies, as well...

  • PostgreSQL Database Administrator

    3 weeks ago

    Mumbai, Maharashtra, India Tata Consultancy Services Full time

    Job Title: PostgreSQL Database AdministratorJob Description: We are seeking a highly skilled PostgreSQL Database Administrator to join our team at Tata Consultancy Services. As a PostgreSQL DBA, you will be responsible for the installation, configuration, and tuning of PostgreSQL databases.Key Responsibilities: Proficiency in PostgreSQL database...

  • PostgreSQL Database Administrator

    6 months ago

    Mumbai, India Tridat India Full time

    We are currently hiring for qualified PostgreSQL Database Administrators for one of our reputed clients: **PostgreSQL DBA resource (L2) Senior, key skills, and responsibilities** - Routine Administrative Activities - Resolve incidents escalated by L1 as per the agreed SLAs and timelines - Analysis of technical issues and permanent fix/solution - Create the...

  • Database Administrator PostgreSQL

    5 months ago

    Pune, Maharashtra, India Clarion Technologies Full time

    ID : 2336 Experience 5 - 7 years Location Pune About Clarion Technologies Clarion Technologies is an IT services company providing customized software solutions to small & medium businesses globally in a broad spectrum of industries. With 20+ years of expertise in Digital Transformation, we help our customers to improve their business performance...

  • PostgreSQL Database Administration

    6 months ago

    Mumbai, India Rapid Technologies LLC - India Full time

    **Sr. PostgreSQL Database Administration** *** **Budget INR 15L** **Location Vikhroli** *** **Rotating Shifts -24 X 7 (NOC).** *** **Must have 5+ Years of PostgreSQL DBA** **Education Qualifications - Any Graduate (BSC, BE, MCA or higher)** *** **Preferred Certification - C-DAC, MCDBA, MCP

  • PostgreSQL Database Administrator

    3 months ago

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

  • PostgreSQL Database Administrator Position

    2 weeks ago

    Mumbai, Maharashtra, India HR PLACEMENT CONSULTANTS (HRPC) Full time

    Job DescriptionWe are seeking a highly skilled PostgreSQL Database Administrator to join our team at HR PLACEMENT CONSULTANTS (HRPC). This role offers an exciting opportunity for professionals looking to leverage their expertise in database management and administration.About the Role:This is a full-time position, with opportunities for career growth and...

  • PostgreSQL Database Administrator

    3 weeks ago

    Pune, Maharashtra, India FIS Global Full time

    **Position Type**: Full time **Type Of Hire**: Experienced (relevant combo of work and education) **Education Desired**: Bachelor's Degree **Travel Percentage**: 0% **PostgreSQL Database Administrator - 7 to 13 **yrs-Bangalore/Pune/Mumbai** Are you curious, motivated, and forward-thinking? At FIS you’ll have the opportunity to work on some of the most...

  • Opening for PostgreSQL Database Administration Role

    5 months ago

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

  • Senior Database Administrator

    1 week ago

    Mumbai, India Ubique Systems Full time

    Position: PostgreSQL Database Administrator Experience: 4-10 years Location: Bangalore Work Mode: Hybrid (3 Days WFO + 2 Days WFH)Key Requirements:Minimum 3 years of experience in PostgreSQL database administration, preferably on AWS Cloud. B.E/B. Tech/MCA (CS, IS, IT, ECE). Expertise in database modeling, administration, tuning, and troubleshooting...

  • Database Administrator

    3 months ago

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

  • PostgreSQL Database Administration

    5 months ago

    Mumbai, India growel softech Full time

    **Preferred Certification - C-DAC, MCDBA, MCP **Sr. No **Desired Skills 1 Will be responsible for the uptime of the various client projects being managed / monitored. 2 Will have to report the daily/weekly/monthly basis database operation checklist. 3 Will make sure that the Tickets raised per shift are closed in the required time limits and if not...

  • PostgreSQL Database Architect

    4 weeks ago

    Mumbai, Maharashtra, India Jio Full time

    Senior PostgreSQL Database AdministratorJio is seeking a highly skilled Senior PostgreSQL Database Administrator to join our team. The ideal candidate will have a deep understanding of PostgreSQL and be able to design, implement, and manage large-scale database systems.Key Responsibilities:Design and implement database architectures to meet business...

  • PostgreSQL Database Architect

    2 days ago

    Mumbai, Maharashtra, India Capgemini Engineering Full time

    Job Summary:We are seeking an experienced PostgreSQL DBA to oversee database performance, security, and availability. The ideal candidate will have strong expertise in database administration, troubleshooting, and high availability.Key Responsibilities:Administer and maintain large-scale PostgreSQL databases.Optimize database performance and ensure high...

  • SQL Database Administrator

    3 months ago

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

  • SQL Database Administrator

    3 months ago

    Andheri East, Mumbai, Maharashtra, India Sanda Group 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.** The DBA will be responsible for database management, performance tuning, backup and recovery, and ensuring database security. **Key Responsibilities**: - Manage and maintain databases,...

  • Database Administrator

    2 months ago

    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**: - **Stored Procedure Development**: - Design, develop, and maintain stored procedures for database operations. - **Function Development**: - **Complex Query...

  • Database Administrator

    3 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,...

  • Database Administrator

    3 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,...

  • Database Administrator

    3 weeks ago

    Mumbai, India Jio Full time

    Job Description:We are seeking a Senior Database Administrator with extensive experience in managing large-scale databases, primarily Oracle 19c and PostgreSQL, and exposure to NoSQL databases such as Cassandra and Elasticsearch. The ideal candidate will play a critical role in maintaining, optimizing, and ensuring the high availability of database systems....