Junior SQL Database Administrator

**Purpose**
- The Junior SQL Database Administrator will support the business in achieving its strategic objectives within the Data Services Business Unit.
- As a Junior SQL Database Administrator in the Business Unit team, you will be responsible for consulting with clients on information technology challenges.
- Microsoft SQL database administrator will be responsible for the upkeep of Client SQL environments on premises and in the cloud with mínimal downtime.
- The job will require an organized self-starter that can support clients and work within the larger team to better the service delivered to the clients.

**Job Context**
- A Junior SQL Database Administrator will perform database administration, maintenance, security, and troubleshooting on multiple client environments.
- A Junior SQL Database Administrator will be required to complete multiple reports for the clients as the basic support process and will further their knowledge in the systems and SQL to increase knowledge and skill levels.
- The Junior SQL Database Administrator will be required to work on multiple client environments facilitating with break/fix and problem resolution.
- Duties will include scheduled reporting, call management and operational tasks like CAB meetings.
- All aspects of SQL needs to be looked after and advised on to the other teams, internal, client side and 3rd party. Where issues do arise, that are not resolved in a timely manner, the person needs to be able to communicate effectively to escalate. Good people skills and inter team relationships are of the upmost importance. The person will also need to be able to self-organize and manage personal capacity to deliver all requirements according to process and SLA.

**Key Performance Areas and Indicators**
- Perform database administration, maintenance, security, and troubleshooting.
- Working knowledge of AOG, mirroring, log shipping, DR processes, recoveries and DB restores.
- Provide daily health check reports.
- Respond to customer requests.
- Understand backup processes and management and their impact in database environments.
- Develop, maintain, perform, and test database backup and recovery strategies and procedures.
- Perform database installations.
- Provide proactive performance monitoring, and capacity planning for future database and server growth with provided reports.
- Work closely and effectively and maintain good relationship with DBA team members, and in-house software development, project management, QA, and system admin teams.
- Upskill on a regular basis in MS SQL, AZURE and other database technologies.
- Participate and contribute in the team’s development process.
- Work with technical contacts from other teams or external partners on integration projects.
- Ability to provide on-call and 24x7 DBA support.
- Willing to travel for work occasionally.

**Qualifications**

Required (not-negotiable):

- Minimum of 1+ years’ experience in the management of Microsoft SQL Server technologies (2012 and later).
- Microsoft certification in Database technologies.

Advantageous (nice to have):

- ITIL Foundation certification
- Development database and other

**Knowledge**

Required (not-negotiable):

- Good working knowledge of database management including backups, jobs, and capacity management.

Advantageous (nice to have):

- Understanding of Managed Services, and the ability to manage enterprise level environments, whilst adhering to service level agreements and levels of reporting.
- Understanding of Project Management concepts.
- Development skills in SQL including report writing and SSIS package development.
- Application development skills.
- PowerShell proficiency
- AZURE experience, setup, configuration and troubleshooting.

**Attributes and Competencies**
- Strong analytical and problem solving abilities
- Clear and logical thinking
- Team player that is easy to work with and that functions in any size team
- Demonstrates personal motivation and a positive attitude
- Uses initiative, shows determination and commitment to delivery
- Copes under pressure
- Demonstrates resilience
- Facilitation Skills
- Strong work ethic and drive for results
- Values quality and produce high quality work at all times
- Good verbal and written communication skills, including an extensive vocabulary of general language and ICT terminology
- Reliable - ensures that if an assignment is allocated, it will be completed as agreed
- Willing to learn other platforms
- Demonstrates high ethics and adherence to Dimension Data values
- Self-motivated, with a keen passion to stay ahead of the trends.
- Risk management/risk mitigation skills.

**Additional Must-Haves**
- Must be willing to work overtime when required.
- Must be willing travel to customer sites as and when required.
- Own transport essential.