Company Description
Media Doc, operating as Mediadoclb, is a leading provider of innovative software solutions that support digital transformation for businesses of all sizes. The company specializes in remote outsourcing services, assembling a diverse team of highly skilled professionals from various industries. Mediadoclb focuses on delivering high-quality, scalable technology that helps organizations modernize their operations and improve efficiency. Team members collaborate across disciplines to build robust solutions tailored to client needs, creating a dynamic environment for continuous learning and professional growth.
About the Role
We are looking for a Senior SQL Server DBA to own the reliability, performance, security and availability of our Microsoft SQL Server estate. You will be the technical authority on our database platform, working closely with application developers, DevOps, security and data teams. You will design resilient architectures, resolve complex performance issues, and raise the bar on how we operate databases in production.
Key Responsibilities
Platform ownership and architecture
Design, deploy and maintain SQL Server instances (virtualized and cloud only) across production and non-production environments.
Architect and manage high availability and disaster recovery solutions: Always On Availability Groups, Failover Cluster Instances, log shipping and replication.
Define standards for database design, naming, indexing, partitioning and capacity planning.
Performance and reliability
Proactively monitor and tune performance: execution plans, indexing strategy, statistics, wait stats, blocking and deadlocks, Query Store.
Lead root cause analysis for production incidents and produce clear post-incident reports.
Perform capacity planning and forecast storage, memory and compute needs.
Backup, recovery and continuity
Own backup and restore strategy, including regular restore testing and documented RPO/RTO targets.
Run and improve DR drills.
Security and compliance
Implement and audit access controls, encryption (TDE, Always Encrypted, TLS), auditing and least-privilege principles.
Support compliance requirements such as ISO 27001, SOC 2, GDPR and PCI-DSS, as applicable.
Manage patching, cumulative updates and version upgrades with minimal downtime.
Automation and DevOps
Automate routine tasks using PowerShell, T-SQL and tools such as dbatools.
Support CI/CD for database changes (schema versioning, migration tools, code review for SQL).
Contribute to infrastructure-as-code and monitoring/alerting standards.
Good knowledge of SLQ Server replication features is necessary.
Collaboration and leadership
Review database changes from developers and advise on schema design and query optimization.
Mentor junior DBAs and engineers; document runbooks and best practices.
Participate in an on-call rotation for critical production systems.
Support migrations to cloud platforms (Azure SQL Managed Instance, Azure SQL Database, SQL Server on AWS/Azure VMs) where relevant.
Required Qualifications
7+ years of hands-on experience administering SQL Server in production, including at least 2 years in a senior or lead capacity.
Deep expertise in T-SQL, query tuning, indexing and execution plan analysis.
Proven experience with Always On Availability Groups, clustering, backup/restore and DR planning.
Strong knowledge of SQL Server internals: storage engine, memory management, locking and latching, tempdb.
Experience with SQL Server 2016 or later, ideally 2019/2022.
Strong PowerShell scripting skills.
Experience with monitoring tools (e.g. SolarWinds DPA, Redgate SQL Monitor, Idera, Prometheus/Grafana, or equivalent).
Solid understanding of database security and compliance practices.
Excellent communication skills in English; ability to explain technical risk to non-technical stakeholders.
Preferred Qualifications
Microsoft certifications such as Azure Database Administrator Associate (DP-300) or equivalent.
Experience with Azure SQL, AWS RDS for SQL Server, or hybrid architectures.
Experience with SSIS, SSRS or SSAS administration.
Familiarity with other platforms (PostgreSQL, Oracle, MySQL) and with NoSQL concepts.
Experience with Git, Azure DevOps or similar CI/CD tooling, and infrastructure as code (Terraform, Bicep, Ansible).
Experience with large-scale or high-transaction systems (multi-terabyte databases, 24/7 operations).