What if the work you did every day could impact the lives of people you know? Or all of humanity?At Illumina, we are expanding access to genomic technology to realize health equity for billions of people around the world. Our efforts enable life-changing discoveries that are transforming human health through the early detection and diagnosis of diseases and new treatment options for patients.Working at Illumina means being part of something bigger than yourself. Every person, in every role, has the opportunity to make a difference. Surrounded by extraordinary people, inspiring leaders, and world changing projects, you will do more and become more than you ever thought possible.
Position Summary:
We are currently looking for an exceptional Senior Database Engineer, to join our mission, to improve human health by unlocking the power of the genome.
As Senior Database Engineer, you will be responsible for the Warehouse DB management of highly available and resilient database infrastructure on one or more leading cloud platform, preferably AWS. You will have considerable experience in a Cloud Infrastructure DB Engineering role, working on a regional scope, preferably within a fast-paced multinational organization. You will excel in cloud-based deployment, support, and the management of multiple cloud-based database platforms.
You will be able to provide knowledge and expertise in administration, configuration, optimization, and monitoring of database servers at scale. Essentially, you will be able to work in a dynamic, collaborative regional team and will be comfortable liaising with internal and external stakeholders.
Responsibilities will include:
Being part of the team’s 24/7/365 global support of on-premises and cloud DB servers and cloud Warehouse infrastructure in a follow-the-sun model; provide on-call support responsibilities.
Monitor & measure the performance & availability of platform proactively, and implement automated corrective actions identified to improve performance & availability.
Collaborate with partner support teams to remediate production issues with high urgency.
Collaborate with the IT Security and Engineering teams to audit, document, and support RBAC on the platform.
Conduct root cause analysis & implement and develop automated pro-active measures. Monitor effectiveness of implemented measures.
Support multiple CI/CD database releases and deployments.
Support development teams for enhancements, troubleshooting, and issue resolution.
Use and improve workflows and procedures to ensure consistency and auditability in a managed database infrastructure.
Design, develop, implement and manage the database platform automation in Sprint cycles.
Work within and enforce security and regulatory compliance procedures.
Developing, managing and testing database backup and recovery plans. Perform database preventive maintenance and execute annual DR exercise.
All listed tasks and responsibilities are deemed as essential functions to this position; however, business conditions may require reasonable accommodations for additional tasks and responsibilities.
Preferred background, skills, and experience:
3+ years of experience supporting Snowflake environment; implementing features of Snowflake like RBAC access controls, data sharing, cloning, integration with different tools.
5+ years of database administration experience supporting MS SQL Server, MySQL, PostgreSQL (MongoDB is a plus).
Deep knowledge of SQL programming is mandatory.
Knowledge of security architecture implementation, data governance/classification in warehouse (preferably Snowflake).
Experience with compliance/security controls for database systems.
Expertise in troubleshooting DB servers’ problems and performance.
Knowledge of cloud database platforms, preferably AWS.
Knowledge of DBMS/Warehouse concepts and technologies.
3+ years of expertise with Windows and Linux server platforms.
2+ years of experience with automation tools such as Ansible, Terraform in CI/CD methodology, git.
Demonstrated knowledge of scripting and programming languages such as Bash/PowerShell, and Python.
All listed requirements are deemed as essential functions to this position; however, business conditions may require reasonable accommodations for additional tasks and responsibilities.
Education:
Bachelor’s degree in computer sciences or related technical discipline
AWS Certification and/or Azure Certification is preferred.
اطلب مساعدة الخبراء لكتابة سيرة ذاتية مميزة.