Infra - Open source Data Base Engineer

POSITION SUMMARY

Zoetis, Inc. is the world's largest producer of medicine and vaccinations for pets and livestock.  The Zoetis Tech & Digital (ZTD) Global Infrastructure organization is as a key building block of ZTD, comprising of enterprise applications and systems platforms.
 
Join us at Zoetis India Capability Center (ZICC) in Hyderabad, where innovation meets excellence. As part of the world's leading animal healthcare company, ZICC is at the forefront of driving transformative advancements and applying technology to solve the most complex problems. Our mission is to ensure sustainable growth and maintain a competitive edge for Zoetis globally by leveraging the exceptional talent in India.
 
At ZICC, you'll be part of a dynamic team that partners with colleagues worldwide, embodying the true spirit of One Zoetis. Together, we ensure seamless integration and collaboration, fostering an environment where your contributions can make a real impact. Be a part of our journey to pioneer innovation and drive the future of animal healthcare.
 
We are seeking a highly skilled and innovative Global Infrastructure Open-Source Database Engineer to join our team. This role focuses on designing, implementing, and managing open-source database solutions that support our global infrastructure. The ideal candidate will have deep expertise in open-source database technologies, such as PostgreSQL, MySQL, MariaDB, or similar platforms, and will play a key role in optimizing database performance, scalability, and reliability. This position requires collaboration with cross-functional teams to ensure the seamless integration of database systems into the organization's infrastructure while adhering to industry best practices. 
 
POSITION RESPONSIBILITIES 
Percent of Time
Database Architecture and Design: 

• Design and implement scalable and secure open-source database solutions across global infrastructure systems. 

• Collaborate with application and infrastructure teams to ensure optimal database architecture that meets business requirements. 

• Create and maintain detailed compliance and technical documentation for database configurations, processes, and procedures.  30%
Database Management and Optimization: 

• Manage the open-source database standard, configuration, and maintenance, and lifecycle solution to ensureing high availability and reliability. 

• Monitor database performance and design tuning strategies for MSP operations to optimize query execution and system efficiency. Lessons learned will be used to update future solutions and standards. 25%
Automation and Scripting: 

• Develop scripts and automation tools to streamline database management tasks, including backups, monitoring, and recovery for operations use. 

• Implement Infrastructure-as-Code (IaC) practices for database deployment and management using tools like Terraform or Ansible.  25%
Security and Compliance: 

• Ensure database systems comply with organizational security policies and industry regulations. 

• Implement encryption, access control, and auditing mechanisms to safeguard sensitive data residing on our platforms 10%
Research and Innovation: 

• Stay updated on the latest developments in open-source database technologies and recommend innovative solutions. 

• Evaluate and implement new tools and frameworks to enhance database performance and scalability.  10%
 
ORGANIZATIONAL RELATIONSHIPS

• Application Teams

• Security Team

• Compliance Team

• Global Infrastructure Teams

• MSP Operations Teams   
 
EDUCATION AND EXPERIENCE 

Education:

•
• Bachelor's degree in Computer Science, Information Technology, or a related field. 

•
• Relevant certifications such as PostgreSQL Certified Professional, MySQL Database Administrator, or equivalent are a plus. 
 
Experience:

• Minimum of 5-7 years of experience in managing and engineering open-source database systems in a global environment. 

• Proven track record of designing and implementing scalable database solutions for high-performance applications. 
 
TECHNICAL SKILLS REQUIREMENTS

• Expertise in open-source database technologies such as PostgreSQL, MySQL, MariaDB, or similar platforms. 

• Proficiency in database optimization techniques, indexing strategies, and query tuning. 

• Experience with cloud database services (AWS RDS & Azure Database for PostgreSQL/MySQL). 

• Familiarity withStrong knowledge of scripting languages (Python, Bash) and automation tools (Ansible, Terraform). 

• Familiarity with containerization and orchestration tools like Docker and Kubernetes. 

• Strong analytical and problem-solving skills with a focus on innovation. 

• Excellent communication and collaboration skills to work effectively in a global team environment. 

• Detail-oriented with a commitment to documentation and continuous improvement. 
 
PHYSICAL POSITION REQUIREMENTS 
This role requires working in a global environment, occasionally outside regular business hours to support infrastructure deployments or critical issues. 0-5% Travel may be required. Hybrid work -  Tuesday to Tursday in offie.