PostgresSQL DBA

Senior Database Administrator Role

We are seeking a seasoned Database Administrator to join our team at Tata Consultancy Services.

Key Responsibilities:
• Production database administration, maintenance, and upgrade activities
• Role and Access Management
• Backup, Recovery, and Point-in-Time Recovery (PITR)
• Database performance tuning

Required Technical Skills:
• PostgreSQL +.x to 13
• SQL Server
• Business Intelligence (SSIS)

Desired Experience Range: 4-8 years

Technical Competencies:
• Mandatory:
• Data Distribution Monitoring to identify data skew, vacuum, and analyze objects
• Resource Queue Design for multiple workload prioritizing
• Segment Management and recovering segments during segment crash
• Backup Management using BART/equivalent tools
• POCs on Restore Methodologies
• Database Connectivity Management using pg_hba.conf
• Application Developer Support in design and performance tuning
• Database Best Practices development and advising
• Database Utilities Development
• Preferred:
• NOSQL Technologies
• Apache Spark
• Impala
• Solr

Minimum Educational Qualifications: Degree/Diploma in Computer Science/Engineering or related field. At least 4 years of experience within a Database Administrator role with hands-on PostgreSQL V10+ experience.

Key Requirements:
• PostgreSQL Architecture Knowledge
• Shell and SQL Skills for DBA tasks automation
• Large Dataset Handling
• Performance and Troubleshooting Skills

Tata Consultancy Services is an Equal Opportunities Employer