SQL Database Administrator

Job Overview

We are looking for an experienced SQL Server Database Administrator (DBA) to manage, maintain, and optimise the organisation's database environments across production, QA, and development systems.

Job Responsibilities

Database Maintenance and Tuning:

• Create and manage multiple databases and assist in capacity planning.
• Monitor and maintain database systems and troubleshoot issues that may arise.
• Perform proactive database housekeeping, including archiving and database size management.
• Manage production, QA, and development database environments.
• Use tools such as SQL Server Profiler for database tuning. Generate traces, review execution plans, identify performance issues, deadlocks/contention, and resolve them.
• Set up and maintain database infrastructure supporting the company's BI requirements.
  
  

Data Management

• Maintain data integrity and security, including managing roles and permissions of database users.
• Understand relevant business processes, data flows, criticality, and system dependencies.
• Create and manage constraints and indexes to ensure optimal database performance.
  
  

Strategy Development And Implementation

• Develop strategies and implement solutions for database backup, restoration, and replication.
  
  

Documentation And Reporting

• Create and maintain detailed documentation, including diagrams of database infrastructure.
• Maintain comprehensive documentation of incidents, resolutions, and client interactions for reference and training purposes.
  
  

Collaboration

• Support software developers with database operations, including writing complex SQL, tuning DML statements, and creating stored procedures.
• Effectively coordinate and communicate with stakeholders, including internal teams and clients.
  
  

Job Skills/Competencies/Experience

• Knowledge of other databases such as MySQL, NoSQL databases, and in-memory databases will be an advantage.
• MCITP or equivalent certification will be an advantage.
• Ability to create and maintain procedural and database documentation.
• Innovative approach with a focus on improving systems using efficient and modern technologies.
• Experience with SQL Server Integration Services (SSIS) for ETL and data integration.
• Experience with SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS).
• Experience in ETL (Extract, Transform, Load) development and data integration processes.
• Strong experience in query tuning and performance
• Experience analysing execution plans, indexes, and database performance
• Ability to troubleshoot database performance issues, deadlocks, and resource
• Experience reviewing table designs, database schemas, scripts, and stored procedures, and applying database best practices.
• Experience in database design and storage architecture, including data files, log files, and tempDB
• Experience with SQL Server high availability technologies, including clustering, mirroring, log shipping, failover clusters, and replication technologies.
  
  

Technology Stack

The role will operate in a Microsoft SQL Server–centric data environment supporting business applications and reporting platforms. The technology stack includes:

• Database Platform: Microsoft SQL Server
• Query Language: T-SQL
• Database Tools: SQL Server Management Studio (SSMS), SQL Server Profiler
• Data Integration: SQL Server Integration Services (SSIS)
• Reporting & Analytics: SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS)
• Data Processing: ETL and data integration processes
• High Availability: SQL Server clustering, log shipping, database mirroring, failover clustering, and replication technologies
• Development Support: Stored procedures, triggers, functions, indexing strategies, and query optimization
  
  

Qualifications

• 8+ years of experience administering Microsoft SQL Server
• Strong knowledge of RDBMS concepts, database architecture, and SQL/T-
• Extensive experience writing T-SQL, stored procedures, functions, triggers, and complex
• Experience supporting high-transaction databases