Senior Database Administrator  

Responsibilities:

• Build database systems of high availability and quality depending on each end user’s specialised role

• Design and implement database in accordance to end users information needs and views

• Define users and enable data distribution to the right user, in appropriate format and in a timely manner
• Use high-speed transaction recovery techniques and backup data
• Minimise database downtime and manage parameters to provide fast query responses
• Provide proactive and reactive data management support and training to users
• Determine, enforce and document database policies, procedures and standards
• Perform tests and evaluations regularly to ensure data security, privacy and integrity
• Monitor database performance, implement changes and apply new patches and versions when required

Skills Required:

• Here’s a comprehensive skill list for a Senior Database Administrator (DBA) specializing in Microsoft SQL Server (MSSQL):

  Core Technical Skills
  1. MSSQL Server Expertise
  • Advanced knowledge of SQL Server versions (2016, 2019, 2022).
  • Proficiency in database design, development, and architecture.
  • Strong T-SQL programming skills (queries, stored procedures, functions, triggers).
  • Experience with SQL Server Management Studio (SSMS).
  • Understanding of SQL Server Integration Services (SSIS), Reporting Services (SSRS), and Analysis Services (SSAS).
  2. Performance Tuning & Optimization
  • Query performance analysis and optimization.
  • Indexing strategies, execution plans, and statistics.
  • Experience with performance monitoring tools (e.g., SQL Profiler, Extended Events, DMVs).
  3. Database Administration
  • Backup and restore strategies, including point-in-time recovery.
  • High availability and disaster recovery (HA/DR) solutions (Always On, Clustering, Mirroring, Log Shipping).
  • Proficient in managing and maintaining large-scale databases.
  4. Security & Compliance
  • User authentication, role-based access, and data encryption.
  • Knowledge of GDPR, HIPAA, or similar data compliance standards.
  • Experience implementing SQL Server auditing features.
  5. Automation & Scripting
  • Proficiency in PowerShell scripting.
  • Automation of routine database tasks using tools like SQL Agent or third-party software.
  6. Cloud Platforms
  • Experience with cloud-based MSSQL deployments (Azure SQL Database, AWS RDS for SQL Server).
  • Knowledge of hybrid environments and migration strategies.
  7. Tools & Monitoring
  • Familiarity with third-party tools like Redgate, SolarWinds Database Performance Analyzer, or Quest Spotlight.
  • Experience with monitoring systems and resolving performance bottlenecks.
  Problem Solving: Ability to troubleshoot and resolve complex database issues quickly.
  2. Communication: Effective communication with stakeholders and team members.
  3. Collaboration: Working closely with developers, application teams, and IT operations.
  4. Leadership: Mentoring junior DBAs and leading database-related projects.