Database Administrator II - IT Infrastructure

Database Administrator II

Job Description :

An exciting opportunity for a Database Administrator II (DBA) to join a dynamic global business to help drive change and innovation. We're looking for an experienced DBA professional to help us improve our suite of databases to be more robust, efficient, automated, and cloud friendly.

Role Purpose

The principal responsibility of this role is to provide operational database management within the Site Reliability Engineering (SRE) team and work with the software engineering teams for new and existing databases.

This Encompasses

• working in partnership with the business and the technology teams, bringing awareness and insight of the different operational constraints / opportunities for projects targeting cloud-based or on-premises databases.
• design, implementation, and maintenance of cloud and on-prem database environments.
• promotion of mutual feedback in cross-functional groups, following database administration best practices.
• a strong focus on service availability and proactive detection of problems.
• ability to articulate technical and business concepts to different audiences and be able to influence technical decisions with solid metrics collection and proof of concepts.

Responsibilities

• Assist with database automation via infrastructure as code.
• Configuration management.
• Maintain database patching.
• Maintain database version support lifecycles.
• Database server tuning.
• Participate in / conduct post-mortems of production incidents.
• Migrate legacy servers to newer versions and to the cloud where applicable.
• Assist with operational security and compliance.
• Raise potential threats to operational and security understand every organization is different and professionals have their own unique history and experience, so we don't expect to find a 100% match of candidate competencies in respect of the tech stack we use. We list our preferred technologies, but if you have transferrable knowledge and you are willing to learn what you do not know, we will consider your application.

Skill Requirements

• 2-4 year's experience with Database Administration
• Bachelor's degree in IT/IS/CS or additional equivalent work experience.
• Work with software engineering teams to provide direction in database queries and indexes for optimum efficiency and supportability.
• Work in an Agile environment supporting multiple software engineering teams.
• Proficiency with one or more of these database platforms.
• Microsoft SQL server
• PostgreSQL server
• Oracle.
• Experience with Azure Postgres, Azure SQL, AWS Aurora, AWS Postgres.
• Assist and direct routine system/database maintenance.
• Participate in an on-call support rotation every few weeks.

Additional Preferred Skills

• Experience with Microsoft SSIS troubleshooting.
• Experience with Infrastructure as Code using Terraform.
• Knowledge of Microsoft SSAS.
• Proficient in Linux administration (RHEL/Ubuntu).
• Experience with configuration management tools (Ansible/Salt Stack).
• Experience with programming / scripting languages such as Bash, Python, and PowerShell.
• Proficiency with command line tools to quickly triage and fix production issues.