Postgresql Database Admin

About Position: We are seeking a skilled PostgreSQL DBA to manage high-performance database systems that support our innovative customer experience SaaS platform. This role required you to support tuning, scalability, availability, and reliability of our rapidly growing structured and unstructured production databases running in containerized Kubernetes environments. This is an opportunity to work on new innovative technologies and in collaboration with talented engineering and operations teams. If you thrive on constantly finding creative ways to increase performance, scalability, and automation of complex and real-time environments, come join our team. - Role: Postgresql Database Admin - Location: All Persistent Locations - Experience: 8 to 12 Years - Job Type: Full Time Employment What You'll Do: - Lead implementations of database solutions for client's microservices infrastructure. Install, monitor and performance tune large database systems. - Plan and implement backup and recovery solutions. - Roll out replication solutions for high availability and disaster recovery scenarios. - Recommend and evaluate new tools and methodologies. - Provide full-life cycle architectural guidance and ensure quality technical deliverables. - Work with development and operations teams to tune production queries for optimal performance. - Investigate production issues and provide root cause analysis. - Review and advise on new database schema changes. - Provide on-call support on a rotation schedule Expertise You'll Bring: - 8+ years of extensive experience in database technologies primarily PostgreSQL 9.6.x or higher. - Experience in PostgreSQL partitioning, auditing, performance improvement, query optimization, index management etc. - Ability to provide on-call support on a rotation schedule. - Demonstrated experience working in physical, virtual, and "cloud" environments. - Demonstrated experience running databases at scale within containers and good understanding with containers orchestration tools such as Kubernetes, Mesos-Aurora etc. - Demonstrated experience configuring and maintaining monitoring and alerting tools such as PgAdmin, Grafana, Prometheus, Solarwinds DPA etc. - Preferred Qualifications Proficient in tuning databases procedures and queries. - Experience in supporting PostgreSQL databases in AWS or other public clouds. - Solid understanding of various infrastructure components: servers, storage, and networking, application and database performance metrics. - Knowledge and experience with Cassandra or similar No-SQL data stores is a huge plus. - SQL development experience. - Proficiency with scripting languages like Bash/Golang/Python. - Excellent verbal and written communications skills. Benefits - Competitive salary and benefits package. - Culture focused on talent development with quarterly promotion cycles and company-sponsored higher education and certifications. - Opportunity to work with cutting-edge technologies. - Employee engagement initiatives such as project parties, flexible work hours, and Long Service awards. - Annual health check-ups. - Insurance coverage: group term life, personal accident, and Mediclaim hospitalization for self, spouse, two children, and parents. Values-Driven, People-Centric & Inclusive Work Environment: Persistent Ltd. is dedicated to fostering diversity and inclusion in the workplace. We invite applications from all qualified individuals, including those with disabilities, and regardless of gender or gender preference. We welcome diverse candidates from all backgrounds. - We support hybrid work and flexible hours to fit diverse lifestyles. - Our office is accessibility-friendly, with ergonomic setups and assistive technologies to support employees with physical disabilities. - If you are a person with disabilities and have specific requirements, please inform us during the application process or at any time during your employment Let's unleash your full potential at Persistent - "Persistent is an Equal Opportunity Employer and prohibits discrimination and harassment of any kind."