SQL Dba

As a Senior SQL DBA, you will be responsible for the management, maintenance, and optimization of our SQL Server instances, servers and databases, all of which are crucial to our operations in delivering reliable life critical services. This role requires a deep understanding of database architecture, performance tuning, and disaster recovery strategies. You will work closely with our global and regional IT teams to ensure data integrity, security, and availability across all platforms., * Database Management: Install, configure, and manage SQL Server databases in hosted, cloud and occasional on-premise environments. Ensure high availability and performance.

• Mentoring and training: Educate and train other technology professionals within the organization on good practice within your domain.
• Performance Tuning: Monitor database performance, identify bottlenecks, and implement solutions to optimize performance. Utilize indexing, query optimization, and other techniques.
• Backup and Recovery: Design, implement, and manage backup and recovery strategies. Ensure data is recoverable and secure.
• Security: Implement and maintain robust security measures to protect sensitive healthcare data in compliance with integral data protection regulations (e.g., HIPAA, GDPR).
• Code Optimization Collaboration: Work closely with development teams to review and optimize SQL code, ensuring efficient data retrieval and minimizing performance issues. Provide guidance and best practices on writing optimized SQL queries and database interactions.
• Monitoring and Maintenance: Set up and manage monitoring systems to proactively identify and address issues. Perform regular maintenance tasks, including updates and patch management.
• Documentation: Maintain comprehensive documentation of database configurations, processes, and procedures. Ensure documentation is up-to-date and accessible.
• Collaboration and Support: Work closely with IT, data analytics, and business intelligence teams to support data-related initiatives and troubleshoot issues.
• Continuous Improvement: Stay current with emerging database technologies and best practices. Propose and implement improvements to database systems and processes.

• Expertise in SQL Server (all versions), including setup, configuration, patching, and upgrades.
• Strong knowledge of database performance tuning and optimization (PTO), using tools like SQL Profiler, Execution Plans, and DMVs.
• Experience with high-availability (HA) and disaster recovery (DR) solutions such as Always On Availability Groups, Clustering, Replication, Log Shipping, and Backup/Restore strategies.
• Familiarity with cloud-based SQL environments, such as Azure SQL, AWS RDS for SQL Server, or Google Cloud SQL.
• Proficiency in T-SQL scripting, including stored procedures, triggers, and complex queries.
• Understanding of ETL processes and working with tools like SSIS.

Operational and Analytical Skills

• Proficient in monitoring database performance and troubleshooting issues with tools like SolarWinds DPA, Redgate, or native SQL tools.
• Experience with database security, including encryption, access control, and auditing.
• Strong knowledge of data governance.