PostgreSQL DBA

TCS Hiring for PostgreSQL DBA

Experience Range : 10 To 15 years

Job Location : Delhi, Hyderabad, Bengaluru, Pan India

JOB DESCRIPTION

Must have skills:

• PostgreSQL installation and Configuration on Linux/Windows OS platform.
• Configuring HA, DR databases.
• Database upgrades and applying PSU packs.
• Hands on experience in writing/troubleshooting shell scripts/Perl/python.

Key Responsibilities :

• Strong working knowledge of PostgreSQL9.5, 9.6, 10, 11, 12, 13, 14
• Perform day-to-day administration of databases, including backup/recovery, Capacity planning and performance tuning.
• Familiarity with monitoring tools like Confio, Solarwind and splunk etc.
• Very good knowledge about PostgreSQL Architecture. High Availability and DR solution.
• Experience with replication configuration in PostgreSQL. Filesystem based, statement based, sync and async based replication
• Knowledge of limitations in PostgreSQL and their workarounds in contrast to other popular relational databases
• Proficient understanding of code versioning tools such as (Git/Mercurial/SVN)
• Upgrading PostgreSQL databases to latest versions
• Applying latest Fix-Packs as per requirements
• Monitor database performance and recommend improvements for operational efficiency
• Database performance tuning by configuring database parameters.
• Monitor the Alert logs files, transaction logs, archive logs and backup log
• Monitor system's health and performance
• Perform Database maintenance like, Reindexing, Update Statistics and review and optimize query tuning
• Perform scheduled maintenance and support release deployment activities after hours
• Review Hardware and configuration and suggest the improvement areas
• Manage database security and make sure it's complied policies, regular audit of security processes
• Good knowledge in Linux operating system and hands on experience in writing shell scripts/Perl/python, with this scripting knowledge, should explore automating the repetitive tasks
• Refine and automate regular processes, track issues and document changes
• Independently analyze, solve, and correct issues in real time, providing end-to-end problem resolution
• Capacity planning, space management and data maintenance activities for database system.
• Perform database enhancement and modification as per the requirements.
• Global On-call Support including weekend
• Regular Connect with Client
• Operational Shift support as per Roster
• Willing to learn and work on other Opensource/DB technologies like DB2, MYSQL, MSSQL
• Knowledge of ITSM process and ticketing tool like ServiceNow/REMEDY etc.

Minimum Qualification:

15 years of full-time education