Description
SQL DBA - Halifax - inclusive package £46,5000SQL DBA to join my teams client in Halifax.
Using the most upto date technologies this is a great opportunity for an established production DBA to move to the next level with continued training in the newest technologies constantly offered.
The day to day responsibilities:
- SQL Database administration/Design
- Support /administer all production SQL Server databases (MSCS)
- Strong understanding of DTS, Triggers, Stored procedures, views and replication etc.
- Strong understanding of SQL replication (articles ,publications ,subscriptions)
- T-SQL scripting
- T-SQL performance tuning
- Responsible for database security, security hardening
- Database Design
- Reporting Services
- SSIS development and support
- Assist the Development /Business Intelligence Teams with database analysis and expertise.
- Monitor capacity, integrity and performance of production database(s).
- Monitor and tune database(s) for maximum performance
- Performance and tuning at the database level and have an understanding of application level issues
- Database reorganisations
- Coordinate software and schema releases/updates
- Ensure new and existing database code is efficient - provide guidance/feedback to the Development Team/BIS Team where necessary.
- Database troubleshooting
- Identify, investigate and rectify issues within the environment
- Provide monthly performance and growth statistics
- Provide monthly downtime statistics
- Provide clear and concise documentation
- Patching and application changes
- Responsible for database security
- Backup and Recovery (perform regular backup & recovery testing)
- Failover (perform regular failover testing)
- Document Backup & Recovery procedures
- Document Failover procedures
- Experience with general Microsoft HA including NLB and Clustering
Desirable Skills:
- Knowledge off IIS applications
- Knowledge of Microsoft Dynamics
- Knowledge of Quest Backup & Monitoring tools
- Upstanding of Firewalls
- Microsoft SharePoint
- Terminal Server environments
- Large Database support > 500 GB
This is a perfect role for a DBA who wants to work within an agile environment and keep upto date with the newest technologies as the business is currently working on SQL server 2012 with the view of upgrading to 2014. They will also be training the successful candidate on all of the desirable skills listed so do still apply if you are a core production SQL DBA.