PostgreSQL Administrator

What will you be doing

• As a PostgreSQL Consultant (DBC) you will work as part of Pythians open source team and supply complete support for all aspects of database and application infrastructure to a variety of our customers.
• Our collaborative environment means everyone works together to solve complex puzzles and develop innovative solutions for our customers.
• Youll work closely with the customer teams to understand their needs, in both a project based and long term support capacity.
• Youll create and document database standards, create optimized queries, indexes, and data structure.
• Monitor and support database environments and serve as an escalation point for complex troubleshooting and interactive production support.
• Use database vendor provided tools and Pythian developed accelerators to performance tune various database system, specific queries and applications scenarios.
• Diagnose and address database performance issues using performance monitors and various tuning techniques.
• Identify areas of opportunity and recommend appropriate improvement suggestions.
• Cross-functional training in NoSQL, Site Reliability Engineering and DevOps methodologies are encouraged.
• When youre not fixing things, youll be authoring new blog posts on interesting topics for our open-source community to digest, creating new articles in our customer facing knowledge base for more frequently seen issues, and hosting webinars amongst other things like participating in conferences and meetups promoting Pythian to the open source community.

What do we need from you

Skills Required

Data Migration, Sql Queries, Database Tuning, Backup Recovery, Performance Monitoring