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

Apply for:

SQL Database Administrator