PostgreSQL Administrator

PostgreSQL DBC

Location: Bengaluru, India
Available Shifts: 10 PM - 6 AM IST

Are you a PostgreSQL who lives in Bangalore OR India (any location)? Are you community minded? Do you blog, contribute to the Open Source community? Are you inspired by ever-shifting challenges, constant growth, and collaboration with a team of peers who push you constantly to up your game? At Pythian, we are actively shaping what it means to be an open-source database engineer and administrator, and we want you to be a part of the worlds top team of MongoDB, Cassandra, and MySQL professionals.

• As a PostgreSQL Consultant (DBC) you will work as part of Pythian's 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.
• You'll work closely with the customer teams to understand their needs, in both a project-based and long-term support capacity.
• You'll 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 you're not fixing things, you'll 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.

• While we understand you might not have everything on the list, to be the successful candidate for the PostgreSQL & MySQL job you are likely to have skills such as:
• Knowledge and experience in installing, configuring, and upgrading PostgreSQL & MySQL databases & tools relevant in PostgreSQL Administration.
• Experience administering PostgreSQL & MySQL in virtualized and cloud environments, especially AWS, GCP, or Azure.
• Experience with scripting (bash/python) and software development (C , Java, Go).
• Automation technologies such as Ansible, Terraform, Puppet, Chef, SALT experience.
• Previous remote working experience a plus.
• Debugging skills and the ability to troubleshoot methodically, identifying and applying fixes for known errors, and when necessary, capacity to think outside of the box to resolve complex issues.
• Very good documentation skills.
• Nice to haves include: Understanding of current IT service standards such as ITIL. Being a contributor to Open Source projects relevant to PostgreSQL, MySQL, or other database or infrastructure software.

• Love your career: Competitive total rewards package with excellent take-home salaries, shifted work time bonus (if applicable), and an annual bonus plan
• Love your development: Hone your skills or learn new ones with an annual training allowance; 2 paid professional development days, attend conferences, become certified, whatever you like
• Love your work/life balance: 3 weeks of paid time off and flexible working hours. All you need is a stable internet connection
• Love your workspace: We give you all the equipment you need to work from home including a laptop with your choice of OS, and budget to personalize your work environment
• Love your community: Blog during work hours; take a day off and volunteer for your favorite charity.

Pythian excels at helping businesses use their data and cloud to transform how they compete and win in this ever-changing environment by delivering advanced on-prem, hybrid, cloud, and multi-cloud solutions to solve the toughest data challenges faster and better than anyone else. Founded and headquartered in Ottawa, Canada in 1997, Pythian now has more than 300 employees located around the globe with over 350 clients spanning industries from SaaS; media; gaming; financial services; e-commerce and more. Pythian is known for its technology-enabled data expertise covering everything from ETL to ML. We pride ourselves on our ability to deliver innovative solutions that meet the specific data goals of each client and have built meaningful partnerships with major cloud vendors AWS, Google, and Microsoft. The powerful combination of our extensive expertise in data and cloud and our ability to keep on top of the latest bleeding-edge technologies make us the perfect partner to help mid and large-sized businesses transform to stay ahead in todays rapidly changing digital economy. If you are a PostgreSQL Database Consultant; live in Hyderabad/Bengaluru; love your data and want to love your career, then join us

For this job, an equivalent combination of education and experience, which results in demonstrated ability to apply skills will also be considered. The successful applicant will need to fulfill the requirements necessary to obtain a background check. Accommodations are available upon request for candidates taking part in all aspects of the selection process.

Locations: Bengaluru