PostgresSQL DBA

Tata Consultancy Services

4 - 8 years

0 Lacs

Ahmedabad Gujarat India

Posted:4 weeks ago| Platform:

Apply

Skills Required

database postgresql sql server monitoring data design backup restore developer tuning support engineering architecture maintenance automation troubleshooting nosql apache spark solr sourcing management

Work Mode

On-site

Job Type

Full Time

Job Description

Role** Senior Database Administrator Required Technical Skill Set** PostgreSQL 9.x to 13, SQL Server, Business Intelligence (SSIS Desired Experience Range** 4-8 Years Location of Requirement Customer Premise - Ahemdabad Desired Competencies (Technical/Behavioral Competency/Skills) Must-Have** Monitoring data distribution to identify data skew, monitor vacuum and analyse needed on objects Resource queue design for multiple workload prioritizing Managing segments and recovering segments during segment crash Managing and restoring backup using BART/ equivalent tools Performing POCs on various restore methodologies Managing database and client host connectivity using pg_hba.conf Assisting application developer teams in design and performance tuning Providing database support in day to day operation Establishing and advising users on database-specific best practices Developing and enhancing database utilities Minimum Educational and Technical Qualification: Possess a Degree/Diploma in Computer Science, Engineering or related field. You have at least 4 years of experience within a Database Administrator role with hands-on experience with postgresql database V10+ Knowledge in postgresql architecture and database maintenance Excellent shell and SQL skill for DBA tasks automation is required Familiar with Postgresql in handling large datasets Good performance and troubleshooting skill At least 4 years of experience within a Database Administrator role with hands-on experience in database upgrades, backup recovery etc., Excellent shell and SQL skill for DBA tasks automation is required Good to Have Skills on NOSQL technologies, Apache Spark, Impala, Solr Keywords for Sourcing** (Internal use) Database Administrator in Postgres SN Responsibility of / Expectations from the Role** 1 Production database administration, maintenance and upgrade activities 2 Role and Access Management 3 Backup, Recovery and PITR 4 Database performance tuning Show more Show less