Lead Infrastructure Engineer - Data Platforms

Job Description

KEY ACCOUNTABILITIES Provide technical leadership for migrating existing Microsoft SQL Server and NoSQL Databases to Public Cloud, developing and owning migration processes, documentation, and tooling. This includes defining strategies and roadmaps for database migrations, ensuring alignment with overall IT strategy and leveraging automation wherever possible to streamline the process. Expertly administer and manage mission-critical, complex, and high-volume Database Platforms in a 24/7 environment, implementing and maintaining automated monitoring and alerting systems to proactively identify and address potential issues. Proactively identify and address potential database performance bottlenecks, proposing and implementing automated solutions to optimize database efficiency and scalability. This includes developing and deploying automated scripts for performance tuning and optimization. Lead the design and implementation of highly available and scalable database solutions in the cloud (GCP preferred), ensuring compliance with security and governance standards and utilizing Infrastructure as Code (IaC) for automated provisioning and management of database infrastructure. Administer and troubleshoot SQL Server, PostgreSQL, MySQL, and NoSQL DBs (MongoDB), implementing best practices and resolving complex performance issues through automated scripting and tooling. Develop and maintain comprehensive documentation for database systems, processes, and procedures. Champion the adoption of DevOps practices, including CI/CD, infrastructure as code (Terraform), and automation (Ansible, Python, PowerShell) to streamline database management and deployment. Actively participate in the development and improvement of automated deployment pipelines. Collaborate with application stakeholders to understand their database requirements and provide technical guidance on database design and optimization, emphasizing automation opportunities to improve development workflows. Contribute to the development and implementation of database security policies and procedures, ensuring compliance with industry best practices and leveraging automation for security auditing and vulnerability management. Actively participate in Agile development processes, contributing to sprint planning, daily stand-ups, and retrospectives, focusing on automation opportunities to improve team efficiency and reduce manual effort. Mentor and guide junior team members, fostering a culture of knowledge sharing and continuous learning, particularly around automation and DevOps practices. Stay abreast of emerging technologies and trends in database administration and cloud computing, recommending and implementing innovative solutions to improve database performance and reliability, with a focus on automation and efficiency gains. MINIMUM QUALIFICATIONS 9+ years of hands-on experience with leading design, refactoring, or migration of databases in cloud infrastructures and services for at least one of Microsoft Azure, Amazon Web Services, and Google GCP (preferred). Experience with automating database migration processes is highly desirable. Experience maintaining and administering with CI/CD tools such as Ansible, GitHub, and Artifactory in a cloud environment and developing/writing scripts using advanced DevOps languages such as Python, PowerShell. Demonstrated ability to design and implement automated workflows. Experience working with infrastructure as code such as Terraform, or equivalent. Proven ability to automate infrastructure provisioning and management. Experience with concepts, processes tools required for cloud adoption including cloud security, governance, and integration. Experience with automating security and compliance tasks is a plus. Experience with SQL Server AlwaysOn and Windows clustering. Experience with automating the management of high-availability clusters is preferred. Experience with agile techniques and methods. Familiarity with user expectations for cloud Databases (to be able to design user-centric engineering services e.g., provisioning self-service workflow). Experience with automating user provisioning and access management is a plus. Working knowledge of DevOps, Agile development processes, exploration, and POCs. Ability to work collaboratively across functional team boundaries. PREFERRED QUALIFICATIONS Good understanding hands-on experience of Linux OS and Windows Server (2012+). Experience working with high availability, disaster recovery, backup strategies, and server tuning strategies including parameters, resources, contention, etc. Excellent interpersonal and communication skills. Ability to work in a fast-paced team environment. Flexibility, reliability, initiative, responsibility, and a can-domentality.