Senior IT Database Administrator I
IT
Rocket Lab's IT team is responsible for how our global teams access information and run operations across our computer systems, networks, and devices. Our hardworking IT team is a group of flexible problem-solvers working in a fast-paced environment but who also thrive under the challenge of supporting all of our proprietary systems and people, from finance to launch operations.
SENIOR IT DATABASE ADMINISTRATOR I
Based onsite at Rocket Lab in Mt Wellington, Auckland, NZ the Senior IT Database Administrator will work closely with the US counterpart to deliver world class SQL Server services to Rocket Lab sites across the globe. You will be expected to collaborate with teams from ERP, BI, software development and other IT functions. The ideal candidate will have deep expertise in SQL Server environments and will be responsible for ensuring the availability, performance, security, and integrity of our mission-critical database systems.
WHAT YOU'LL GET TO DO:
- Design, implement, and maintain on-prem and cloud SQL Server database environments (2016/2019/2022) across Rocket Lab
- Manage database availability groups, replication, and failover clustering
- Perform database installations, upgrades, patches, and migrations
- Monitor database uptime, performance & resources, resolve performance issues, advise on query optimization and table indexing
- Ensure robust backup and recovery strategies with tested disaster recovery procedures are in place
- Ensure compliance with regulatory requirements (GDPR, HIPAA, SOX, etc.)
- Provide senior-level technical support for database-related issues across all Rocket Lab sites and ensure effective collaboration / handover with the USA Senior DBA
- Work closely with application support and development teams to deliver robust and high performing business solutions
- Create and maintain comprehensive global documentation of database systems and procedures
YOU'LL BRING THESE QUALIFICATIONS:
- 5+ years of experience in IT and a bachelor's degree OR equivalent years of work experience (9+ years total experience)
- 5+ years of experience in database focused technology role
- Microsoft Certified: Azure Database Administrator Associate or similar certification
THESE QUALIFICATIONS WOULD BE NICE TO HAVE:
- 5+ years of experience in SQL Server Database Administration in a distributed multi-instance server environment
- Experience with Azure SQL Database and managed instances
- Knowledge of PowerShell scripting for automation
- Understanding of Windows Server administration and storage systems
- Experience with database monitoring tools (SolarWinds, RedGate, Idera, etc.)
- Experience with migration and support of cloud platforms (Azure, AWS)
- Knowledge of DevOps practices and CI/CD pipelines
- Familiarity with other database platforms (Oracle, PostgreSQL, MySQL)
- Experience with containerization (Docker, Kubernetes)
- Knowledge of data warehousing and ETL processes
ADDITIONAL REQUIREMENTS:
- Specific vision abilities required by this job include close vision, distance vision, peripheral vision, depth perception, and the ability to focus
- Regularly required to sit, use hands and fingers, operate computer keyboard and controls, and communicate verbally and in writing
- Must be physically able to commute to buildings
- Occasional exposure to dust, fumes and moderate levels of noise