Database Administrator

Database Administrator – CSE Database Services Team

Background:

Within Technology & Transformation there is a requirement for a suitably skilled Database Administrator to join the Customer Service Experience (CSE) Database Services team working on T&T Strategic Projects. The successful candidates will over the next 12 months:

·       Provide database support for upgrades and assessments

·       Provide advice and support to project stakeholders regarding to all aspects of Database support.

The DBAs will be required to support the delivery of services provided by DBA team.

Service Types / Category

Individual Service Names

Troubleshooting/Support

DBA Support

DBA Alerts

Daily Monitoring of Database Estate

Security

SQL Server Security Best Practice

Installation and Maintenance

New Builds

Upgrades and Migrations

Database Backup and Recovery

Work closely with Senior DBA in deployment of DBATools to Database Estate

Database Administrator Responsibilities:

·       Support the HSE - Technology & Transformation Project in the management of the SQL database estate.

·       Contribute and assist in the migration of databases from out of support servers.

·       Manage database upgrades and consolidation projects

·       Maintain and administer database security access

·       Perform database Ad-hoc backups and restores

·       Trouble shoot and resolve database connectivity issues

·       SQL Server Installation, Upgrades, Migrations and Configuration

·       Install database software service packs and cumulative updates as necessary

·       Monitor and maintain database storage resources

·       Monitor and maintain database maintenance plans for backups, index rebuild/defragment, and database statistics

 Deliverables for this position:

·       Health check Assessments of SQL database estate in the regions:

·       Identification of SQL Servers/Databases

·       Documentation on configurations, version, dependencies, availability of backups

·       Testing of Ability to restore from backups

·       Analysis of Storage and configuration requirements

·       Migration to new locations on National Data Centres:

·       Configuration of new SQL Servers & SQL Server Instances

·       Application of latest patches/update

·       Transfer of Databases

·       Rollback plans

Post-Migration tasks:

·       Continuous Monitoring of additional SQL database estate

·       Updating of relevant documentation,

·       Decommissioning of redundant SQL Servers

Required Skills & Competencies:

The successful candidate will be required to demonstrate the following skills:

·       Proven expertise in the area of SQL DBA; min 2yrs experience

·       Proven experience of setting up, managing and monitoring replicated SQL databases

·       Excellent knowledge of database security, backup and recovery and performance monitoring                 standards

·       Ability to ensure business continuity in terms of database replication, backup and recovery

·       PowerShell scripting skills would be advantageous

·       Experience creating stored procedures, views and functions

Personal Characteristics:

·       Demonstrate good problem solving, analytical and decision making skills

·       The ability to interact in a professional manner with key stakeholders

·       The ability to produce against set timelines

·       Self-starter with a willingness to take responsibility

·       Excellent teamwork and interpersonal skills

·       Excellent written and verbal communication skills

·       Impeccable attention to detail