PostgreSQL Administrator

**Overview:** - Remote PostgreSQL DBC role at Pythian, India. - Collaborative environment focused on solving complex database challenges. - Part of a global team of MongoDB, Cassandra, and MySQL professionals. **Key Responsibilities:** - Provide support for database and application infrastructure. - Work with customer teams to understand needs and offer project-based and long-term support. - Create and document database standards, optimize queries, indexes, and data structures. - Monitor and support database environments, troubleshoot complex issues. - Use vendor tools and Pythian-developed accelerators for performance tuning. - Author blog posts, create knowledge base articles, and host webinars. - Cross-functional training in NoSQL, Site Reliability Engineering, and DevOps. **Requirements/Skills/Qualifications:** - Knowledge and experience in installing, configuring, and upgrading PostgreSQL & MySQL. - Experience administering databases in virtualized and cloud environments (AWS, GCP, Azure). - Scripting (bash/python) and software development (C++, Java, Go) skills. - Automation technologies (Ansible, Terraform, Puppet, Chef, SALT). - Debugging skills, methodical troubleshooting, and problem-solving. - Good documentation skills. - Understanding of IT service standards (ITIL) and contribution to open-source projects. **Compensation & Benefits:** - Competitive total rewards and salary package. - Flexible remote work with stable internet connection. - Collaboration with top industry professionals. - Training allowance for skill development. - Annual wellness budget for personal health. - Paid vacation and sick days, plus a day off for volunteering. - Background check requirement for successful applicants. - Accommodations available upon request during the selection process.