- Perform duties related to migrating on-prem SQL Server databases into the Azure Cloud.
- Install new releases, patch, and maintain SQL Server databases.
- Analyze/tune databases to run at optimal efficiency.
- Resolve issues with external and internally developed database applications.
- Perform root cause analysis of issues/problems and create preventative measures. Ensure proper escalation and coordination of all issues.
- Perform database cloning operations from production to test and development environments.
- Develop, implement, and monitor database backup and recovery procedures.
- Implement DDL/DML scripts in support of SCRUM application release cycles.
- Automate recurring tasks through a combination of SQL, PL/SQL, or scripting languages such as Perl, Bash, PowerShell, etc.
- Assess and suggest opportunities for application and process improvement.
- Promote adherence to departmental/software development standards.
- Promote learning, understanding, and the general enablement of the DBA team.
- Set a professional example for the team through model behaviour, superior performance, and proper attendance.
- Work independently, with the ability to overlap work schedules with US-based teammates.
Required Knowledge, Skills & Abilities:
- BA in Computer Science or the equivalent combination of education, training, and experience.
- Ability to own and manage tasks and/or projects with minimal direction.
- Ability to successfully troubleshoot issues/provide solutions with minimal direction.
- Ability to learn new technologies/applications with minimal direction.
- ‘Can do’ attitude towards solving problems and completing tasks.
- Capable to research and resolve issues with technologies outside of core competency.
- 5+ years of database administration experience, with a focus on both on-prem SQL Server and Azure.
- Clustering/Replication.
- Scripting skills such as PowerShell, Perl, etc.
- Backup and all facets of recovery (simple restore, point-in-time recovery, etc.).
- VLDB.
- Understand all aspects of database administration; be comfortable working with developers.
- Clear and effective written and verbal English communication skills.
- Strong technical and interpersonal skills with the ability to work with minimal supervision within a global staffing environment.
- Proven analytical/problem-solving skills. Ability to adapt in a dynamic environment.
- Ability to effectively communicate with technical staff (applications development and technical services) and management.
Preferred Knowledge, Skills & Abilities:
- SQL Server.
- Software Development experience.
- Business Intelligence tools and concepts (ETL, SSAS, SSRS).
- Azure-based SQL Server administration.