PostgreSQL Database Administrator (DBA)

Automios; Chennai District; On-site; INR 800,000 - 1,200,000; Full time

Job summary

A technology services company in Chennai is seeking a skilled PostgreSQL Database Administrator. This role involves database administration, ensuring data integrity, and maintaining high availability PostgreSQL databases. Ideal candidates will thrive in a fast-paced environment and possess strong skills in troubleshooting, SQL, and performance tuning. This full-time position offers opportunities for career growth.

Qualifications

• Ability to troubleshoot and resolve database issues quickly and efficiently.
• Proficient in SQL and PL/pgSQL.
• Experience with database replication and high availability on repmgr or patroni.
• Experience with backup tools like pg_dump, pg_basebackup, barman or pgbackrest.
• Experience in performance tuning techniques for PostgreSQL.
• Familiarity with PostgreSQL backup and recovery strategies.
• Proficiency in using monitoring tools such as Nagios, Grafana, or similar tools.
• Experience in database security practices, including user management and access controls.
• Strong scripting skills (e.g., Bash, Python, or similar).
• Experience with automation tools (e.g., Ansible, Chef, Puppet), data migration tools and knowledge on other database administration is a plus.
• Familiarity with containerization (Docker, Kubernetes) and orchestration tools is a bonus.

Responsibilities

• Install, configure, and maintain PostgreSQL database systems.
• Design and implement backup and recovery strategies.
• Set up and maintain database replication and high availability configurations.
• Manage database security and user access.
• Monitor and optimize database performance.
• Perform routine database optimization tasks.
• Assist with database migrations.
• Diagnose and resolve database-related issues.
• Collaborate with development and infrastructure teams.
• Maintain clear documentation of database configurations.

Skills

Troubleshooting and database issues

SQL and PL/pgSQL

Database replication and high availability

Backup tools like pg_dump

Performance tuning techniques for PostgreSQL

PostgreSQL backup and recovery strategies

Monitoring tools like Nagios or Grafana

Database security practices

Scripting skills (Bash, Python)

Automation tools (Ansible, Chef, Puppet)

Containerization (Docker, Kubernetes)

Education

Bachelor’s degree in Computer Science or related field

Job description

Overview

Job Title: PostgreSQL Database Administrator (DBA)

Location: Fill time

Job Type: Full-Time

Job Summary: We are seeking a skilled and motivated PostgreSQL Database Administrator. The ideal candidate will be responsible for the database administration, ensuring data integrity, and supporting a robust, highavailability environment of PostgreSQL databases hosted in various platforms. This is a great opportunity for someone who thrives in a fast-paced environment and is eager to further develop their technical expertise.

Responsibilities

• Database Administration: Install, configure, and maintain PostgreSQL database systems in production and development environments.
• Backup and Recovery: Design and implement backup and recovery strategies to ensure data integrity and minimize downtime.
• Replication and High Availability: Set up and maintain database replication and high availability configurations to ensure system reliability.
• Security: Ensure database security by managing user access and permissions, applying patches, and enforcing best practices.
• Performance Tuning: Monitor and optimize database performance, identify bottlenecks, and implement improvements.
• Database Optimization: Perform routine database optimization tasks, including query tuning, index management, and configuration adjustments.
• Data Migration: Assist with database migrations, including schema changes and data transfer between environments.
• Troubleshooting: Diagnose and resolve database-related issues, including performance issues, database corruption, and connectivity problems.
• Collaboration: Work closely with development and infrastructure teams to support application deployments and system upgrades.
• Documentation: Maintain clear and detailed documentation of database configurations, processes, and troubleshooting procedures.

Required Skills

• Ability to troubleshoot and resolve database issues quickly and efficiently.
• Proficient in SQL and PL/pgSQL.
• Experience with database replication, high availability on repmgr or patroni
• Experience with backup tools like pg_dump, pg_basebackup, barman or pgbackrest
• Experience in performance tuning techniques for PostgreSQL.
• Familiarity with PostgreSQL backup and recovery strategies.
• Proficiency in using monitoring tools such as Nagios, Grafana, or similar tools.
• Experience in database security practices, including user management and access controls.
• Strong scripting skills (e.g., Bash, Python, or similar).
• Experience with automation tools (e.g., Ansible, Chef, Puppet), data migration tools and knowledge on other database administration is a plus.
• Familiarity with containerization (Docker, Kubernetes) and orchestration tools is a bonus.

Desired Qualifications

• Bachelor’s degree in Computer Science, Information Technology, or related field (or equivalent experience).

Soft Skills

• Strong problem-solving and troubleshooting skills.
• Excellent communication and collaboration skills.
• Ability to work independently and handle multiple tasks simultaneously.
• Attention to detail and proactive in identifying and addressing potential issues.

Seniority level

• Mid-Senior level

Employment type

• Full-time

Job function

• Information Technology

Industries

• IT Services and IT Consulting

Referrals increase your chances of interviewing at Automios by 2x

Get notified about new Database Administrator jobs in Chennai, Tamil Nadu, India.

Data Engineer, MIDAS, Digital Acceleration

Data Engineer, MIDAS, Digital Acceleration

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.