SQL Database Administrator
||Jobs @ Wiggle
Calling all SQL Database Administrators - We want you…..
We are looking for an experienced Database Administrator to join our Production Services team Team to oversee the day to day management of all SQL databases across the Wiggle CRC estates.
What will you be doing:
You will be a member of a 10-strong team who are internationally distributed. On a day to day basis you will make sure that our live databases are running on time and accurately. You will be an integral part in the website deployment process carrying out the Website deployment process carrying out SQL reviews, making sure queries are correct and signing them off against reviews.
The technical stuff:
Day to day management of operational database environments.
Mentor and Share technical expertise with junior members of the team.
Manage and Liaise with developers and third party to ensure standards and architectural principles are applied as appropriate.
Where required to work with the business to capture and analyse requirements, providing technical input in a clear well-communicated manner. Create suitable design documentation and / or data models for others (including 3rd party offshore suppliers) to work from.
Develop an excellent understanding of one or more systems, how these systems support the business, how these systems interact with other corporate (and 3rd party) applications, and their place in the overall IT architecture.
Analyse systems proactively to identify problems and trends and propose technical solutions and recommend changes to optimise system performance and usability.
Create documentation to support future maintenance of system and to support operational requirements.
Ensuring agreed OLA’s are adhered to.
Managing incidents, service requests and minor change within Production Services Team.
Managing, tracking and trouble-shooting issues, change controls, bespoke project roll-outs and live fault escalations.
Maintaining a high level of availability of services and minimising the risk of exposure to system downtime through continual monitoring of key systems.
Provision of out of hours support.
Improving system & automating repetitive jobs.
Knowledge, Skills and Experience:
5+ years of experience in database development and support in Microsoft SQL Server (MSSQL) environments.
Experience and Knowledge of supporting and maintaining an enterprise Database platform with a main focus on SQL Server 2005/2008/2012.
Experience and Knowledge of supporting Wintel and Linux Operating systems required for database operations.
Experience and Knowledge of database Integration Services
Experience and Knowledge of using and configuring enterprise database monitoring solutions
Knowledge of MSSQL management tools (Profiler, DTA, SSMS, SAC, SSCM, PerfMon, DMVs, system sprocs)
Experience in troubleshooting and resolving MSSQL integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc.
Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.
Ability to detect and troubleshoot database related CPU, memory, I/O, disk space and other resource contention.
Knowledge of database backups, restores, recovery models, database shrink operations, DBCC commands, Clustering, Database mirroring, Replication.
Experience in implementing MSSQL operational automation.
Knowledge of how MSSQL indexes, index management, integrity checks, configuration, patching. How statistics work, how indexes are stored, how they can be created and managed effectively.
SSRS - Backup Failures/Job Failures/ Instance Status/Service Status and Mirroring Synchronisation using remote T-SQL Queries via MS-DTC/RPC.
Does this sound like the perfect job for you? Fantastic, please click to apply.
We are #forthegoodstuff