Postgresql Database Administrator

Tata Consultancy Services; Pune District; On-site; INR 1,200,000 - 2,000,000; Full time

Job summary

Tata Consultancy Services in Pune, India, is seeking a Database Administrator to install, configure, and maintain PostgreSQL, MongoDB, and MSSQL databases across Linux and Windows servers. You will optimize performance, implement backup and disaster recovery, and ensure high availability through replication and clustering, using SQL and shell scripting along with monitoring tools.

Strong analytical and communication skills are essential; exposure to cloud services and monitoring tooling is a

Qualifications

• Experience with database administration including installation, configuration, and maintenance of PostgreSQL, MongoDB, and MSSQL.
• Ability to analyze and optimize database performance for scalability and efficiency.
• Implement backup and disaster recovery plans and test them regularly.
• Manage databases across Linux and Windows Server environments.
• Proficiency in SQL, shell scripting, and database monitoring tools.
• Solid understanding of replication, clustering, and high availability setups.
• Excellent analytical and communication skills.

Responsibilities

• Install, configure, and maintain PostgreSQL, MongoDB, and MSSQL databases.
• Analyze and optimize database performance for scalability and efficiency.
• Implement and test backup and disaster recovery plans.
• Manage databases on Linux and Windows Server environments.
• Proficiency in SQL, shell scripting, and database monitoring tools.
• Understand replication, clustering, and high availability setups.
• Communicate findings effectively and collaboratively.

Skills

Database Administration

PostgreSQL

MongoDB

MSSQL

SQL

Shell scripting

Monitoring tools

Replication & HA

Analytical & communication

Tools

PostgreSQL

MongoDB

MSSQL

OCI

Prometheus

Grafana

SolarWinds

Job description

Responsibilities:

• Database Administration: Install, configure, and maintain PostgreSQL, MongoDB, and MSSQL databases.


• Performance Tuning: Analyze and optimize database performance for scalability and efficiency.


• Backup and Recovery: Implement and test backup and disaster recovery plans.


• Cross-Platform Support: Manage databases on both Linux and Windows Server environments.


• Proficiency in SQL, shell scripting, and database monitoring tools.


• Solid understanding of replication, clustering, and high availability setups.


• Excellent analytical and communication skills.

Good to have:

• Exposure to Postgress/ Mongo cloud database services (OCI).


• Familiarity monitoring tools like ops manager, Prometheus and Grafana, SolarWinds


• Knowledge of data modeling and ETL processes.