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