Postgres DBA

The Role offers

Will be part of the technical steering committee responsible for defining the standards, metrics, project governance and overall success of the project and the technical interface to the customer.

Essential Skills

• 5+ years of DB knowledge with Postgres. Hands on experience on DB replication.
• Hands on experience on DB upgrades.
• Hands on experience in File stream tables, Cross DB references, Logon triggers in respective DB.
• Experience in Functions, Stored procedures, triggers, and user-defined functions. DB Performance Tuning, setting up right DB parameters.
• Hands on with Stored Procedures, Table partitioning, Indexing etc.
• Should have typed XML, done XML indexing and knowledge of Table Audit. Should have worked on SQL Jobs.
• Must be able to understand and handle SQL error Logs. Good to have: Cloud DB like AWS RDS SQL Server, Dynamo DB, Azure SQL. Db scripts, Batch file implementation for SQL queries.
• Should have proven delivery track record for enterprise level infrastructure and security projects
• Should have hands on experience in IaaS, PaaS and SaaS areas. Maintain and improve
• operational procedures on failure management, monitoring, preventative maintenance, expansions, and upgrades

Essential Qualification

• B.Tech or similar