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