SQL Database Administrator

Bharuwa Solutions Pvt Ltd

9 years

0 Lacs

Noida Uttar Pradesh India

Posted:1 day ago| Platform:

Apply

Skills Required

sql database postgresql security development test restoration indexing strategies tuning optimization resolve planning storage management data archiving devops design automation documentation query configuration maintenance replication monitoring pgadmin scripting aws azure mysql oracle docker technology certifications

Work Mode

Remote

Job Type

Full Time

Job Description

Job Title:

Senior Database Administrator – PostgreSQL

Location:

Experience Required:

Employment Type:

Work Mode:

Job Summary:

Senior Database Administrator (DBA)

Key Responsibilities:

Administer and maintain PostgreSQL databases across development, test, and production environments.
Perform regular database backups, restoration, and disaster recovery exercises.
Implement and monitor database indexing strategies to ensure high performance.
Execute advanced performance tuning and optimization for queries, schemas, and configurations.
Manage database security, user roles, and privileges.
Monitor system health and performance, ensuring high levels of performance, availability, and security.
Troubleshoot and resolve database issues in a timely manner.
Perform capacity planning, storage management, and data archiving strategies.
Collaborate with application developers and DevOps teams to design and optimize database schemas.
Implement automation for routine database tasks and ensure adherence to best practices.
Create and maintain documentation related to database configurations, policies, and procedures.

Mandatory Skills:

PostgreSQL Administration
(version 12 and above preferred)
Database Backups & Recovery
(e.g., pgBackRest, Barman)
Indexing Techniques and Query Optimization
Performance Tuning
(both at DB level and SQL query level)
Strong understanding of
PostgreSQL internals
, configuration tuning, and maintenance best practices
Experience with
High Availability (HA)
and
Replication mechanisms
Hands-on experience with
monitoring tools
(e.g., pgAdmin, Prometheus + Grafana, or similar)
Scripting knowledge (e.g.,
Shell, Python
or
SQL
scripts)

Preferred Qualifications:

Experience in
cloud environments
(AWS RDS, Azure Database for PostgreSQL, or GCP)
Knowledge of other RDBMS systems (e.g., MySQL, Oracle) is a plus
Familiarity with
CI/CD
and
DevOps practices
Exposure to
containerized environments
(e.g., Docker, Kubernetes)

Education:

Bachelor’s or Master’s degree in Computer Science, Information Technology, or a related field
Relevant certifications in PostgreSQL or database administration (preferred but not mandatory)

Mock Interview

Practice Video Interview with JobPe AI

Start DevOps Interview

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.