PostgresSQL DBA

Role** Senior Database Administrator

Required Technical Skill Set** PostgreSQL +.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