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, 14Perform 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 replicationKnowledge of limitations in PostgreSQL and their workarounds in contrast to other popular relational databasesProficient understanding of code versioning tools such as (Git / Mercurial / SVN)Upgrading PostgreSQL databases to latest versionsApplying latest Fix-Packs as per requirementsMonitor database performance and recommend improvements for operational efficiencyDatabase performance tuning by configuring database parameters.Monitor the Alert logs files, transaction logs, archive logs and backup logMonitor system's health and performancePerform Database maintenance like, Reindexing, Update Statistics and review and optimize query tuningPerform scheduled maintenance and support release deployment activities after hoursReview Hardware and configuration and suggest the improvement areasManage database security and make sure it's complied policies, regular audit of security processesGood knowledge in Linux operating system and hands on experience in writing shell scripts / Perl / python, with this scripting knowledge, should explore automating the repetitive tasksRefine and automate regular processes, track issues and document changesIndependently analyze, solve, and correct issues in real time, providing end-to-end problem resolutionCapacity planning, space management and data maintenance activities for database system.Perform database enhancement and modification as per the requirements.Global On-call Support including weekendRegular Connect with ClientOperational Shift support as per RosterWilling to learn and work on other Opensource / DB technologies like DB2, MYSQL, MSSQLKnowledge of ITSM process and ticketing tool like ServiceNow / REMEDY etc.Minimum Qualification :
15 years of full-time education