Snr SQL Server Database Administrator

• The Senior SQL Database Administrator will support the business in achieving its strategic objectives within the Data Services Business Unit.
• As a Senior SQL Database Administrator in the Business Unit team, you will be responsible for consulting with clients on complex information technology challenges.
• Microsoft SQL database administrator will be responsible for the upkeep of Client SQL environments on premises and in the cloud with minimal 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 Senior SQL Database Administrator will perform database administration, maintenance, performance tuning, security, and troubleshooting on multiple client environments.
• A Senior SQL Database Administrator performs project management tasks as needed to ensure all requirements are delivered on time, and meeting user requirements. They will participate in, and may lead projects and ensure their timely delivery.
• A Senior SQL Database Administrator has knowledge of all Britehouse Digital products, services and solution lines. They contribute to, and will often technically lead, new business intelligence projects.
• The Senior SQL Database Administrator will be required to work on multiple client environments within a short space of time to assist with break/fix and sourcing business requirements, estimating hours for the build, and developing from those specifications.
• The Senior SQL Database Administrator will work within a team to deliver a solution to our clients. The Senior SQL Database Administrator will need to be able to deliver portions of a solution as well as an entire solution. It is expected that a Microsoft Business Intelligence Developer will be able to carry a conceptual design through to a fully functional system.
• 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:

• Perform database administration, maintenance, performance tuning, security, and troubleshooting.
• Understand and able to deploy High Availability Data solutions.
• Understand and able to implement, troubleshoot and manage transactional Replication.
• Working knowledge of mirroring, log shipping, DR processes, recoveries and restores.
• Strong understanding of database security including encryption.
• Knowledge of database licensing.
• Provide daily health check reports.
• Respond to customer requests.
• Understand backup processes and management and their impact in database environments.
• Be able to plan and implement environment migrations.
• Knowledge of OS clustering setup and troubleshooting.
• Develop, maintain, perform, and test database backup and recovery strategies and procedures.
• Perform database installations, configurations, upgrades, and migrations.
• Provide proactive performance monitoring, and capacity planning for future database and server growth.
• Develop and maintain best practices database documentation.
• Administer and maintain database and user security policies and standards
• Work closely and effectively and maintain good relationship with DBA team members, and in-house software development, project management, QA, and system admin teams.
• Research, and evaluate new databases trends and technologies and provide best practices and recommendations.
• Support strategic decision making for technology base.
• Design, evaluate and recommend best practices for database models and architecture.
• Manage standards and strategies for security, database objects, and backup / recovery.
• Monitor capacity and performance, troubleshooting, and proactively resolving a wide variety of problems. Establish and maintain…