Domain Architect - Logical DBA, MySQL

Job Summary

We are looking for a Microsoft Database Administrator (L2+) with strong hands-on experience in administering and supporting Microsoft SQL Server environments in production. The role involves incident and problem management, performance tuning, availability and DR readiness, patching, security, and automation, working closely with application, infrastructure, and security teams to meet SLA/SLO commitments.

Key Responsibilities

1. Architect And Design Comprehensive Solutions For Product And Sustenance Delivery By Leveraging Sql And Mysql, Ensuring Adherence To Defined Standards And Best Practices.

2. Train And Mentor Team Members On Sql Development And Mysql Administration, Fostering A Skilled Workforce And Mitigating Delivery Risks.

3. Collaborate With Clients To Gather Specifications And Deliver Tailored Solutions, Utilizing Deep Knowledge Of Sql And Mysql Technologies.

4. Stay Updated With Emerging Technologies And Integrate Them Into Solutions To Maintain Relevance, Quality Standards, And Alignment With Client Requirements.

Skill Requirements

8+ years of hands-on SQL Server DBA experience in production (administration and operations/support). Strong proficiency in T-SQL (writing and troubleshooting complex queries, stored procedures, and jobs). Experience with SQL Server HA/DR: Always On Availability Groups (preferred), clustering concepts, log shipping; ability to perform failover and recovery. Backup/restore expertise, including point-in-time recovery; demonstrated experience validating restores. Performance tuning skills: indexing, statistics, execution plans, wait stats, blocking/deadlocks, tempdb contention. Good understanding of SQL Server security: authentication/authorization, server/database roles, encryption basics (TDE), and audit/traceability requirements. Experience with patching and upgrades, including pre-checks, rollback planning, and change implementation. Exposure to Windows Server fundamentals and troubleshooting (services, event logs, basic OS performance counters). Knowledge of ITIL processes (Incident, Problem, Change, Service Request) and working with ITSM tools (e.g., Service Now/Remedy). Ability to work in shifts/on-call as required and handle high-severity incidents with clear communication.

Other Requirements

Experience with SQL Server on Azure (Azure SQL Database/Managed Instance) and related features (Azure AD auth, automated backups, geo-replication concepts). Experience with SSIS/SSRS/SSAS administration and troubleshooting. Experience with replication (transactional/merge) and troubleshooting replication latency. Exposure to DevOps/CI-CD for database deployments and source control for scripts (Azure DevOps/Git). Monitoring and observability tooling experience (SCOM, Grafana/Prometheus exporters, Solar Winds, Redgate/Quest tools, etc.). PowerShell advanced scripting and automation, including scheduled tasks and reporting. Knowledge of compliance frameworks (SOX/PCI) and implementing database hardening standards. We are looking for a Microsoft Database Administrator (L2+) with strong hands-on experience in administering and supporting Microsoft SQL Server environments in production. The role involves incident and problem management, performance tuning, availability and DR readiness, patching, security, and automation, working closely with application, infrastructure, and security teams to meet SLA/SLO commitments. \\r\\n\\r\\n \\r\\n\\r\\n Key Responsibilities \\r\\n\\r\\n Own L2+ production support for Microsoft SQL Server (2016/2017/2019/2022) including incident triage, troubleshooting, service restoration, and RCA. \\r\\n\\r\\n Perform database administration activities: installation, configuration, upgrades, patching (CU/Security), and decommissioning as per change management. \\r\\n\\r\\n Monitor database health and capacity: CPU/memory/storage/IOPS, tempdb, jobs, replication/AG health, and proactively prevent issues. \\r\\n\\r\\nSQL performance tuning: analyze query plans, index strategy, statistics maintenance, parameter sniffing issues, and implement optimizations in coordination with application teams. \\r\\n\\r\\n Manage high availability and disaster recovery: Always On Availability Groups, log shipping, database mirroring (legacy), clustering concepts; run and document DR drills and failover/failback procedures. \\r\\n\\r\\n Backup and recovery ownership: define/validate backup strategy (full/diff/log), test restores, point-in-time recovery, and ensure RPO/RTO compliance. \\r\\n\\r\\n Administer security: logins/users/roles, least privilege access, auditing, encryption (TDE), certificate management as applicable, and support vulnerability remediation. \\r\\n\\r\\n Automate routine DBA tasks using T-SQL and PowerShell; develop scripts for health checks, maintenance, reporting, and standard operations. \\r\\n\\r\\n Implement and maintain maintenance plans/agent jobs for integrity checks (DBCC), index rebuild/reorg, statistics updates, cleanup, and alerting. \\r\\n\\r\\n Support migrations and onboarding of new applications/databases (on-prem to on-prem/cloud), including compatibility checks and cutover support. \\r\\n\\r\\n Work with monitoring/ITSM tools (e.g., SCOM, SSMS alerts, Solar Winds, OEM tools as applicable) and manage alert thresholds and notifications. \\r\\n\\r\\n Maintain documentation: SOP/runbooks, architecture diagrams (textual), CMDB updates, and knowledge articles for recurring issues. Participate in on-call/shift rotation and provide support during planned activities (patching, releases, failovers) as per business requirements. Collaborate with Infra/OS/Storage/Network/Security teams to resolve cross-functional issues and drive problem management and continuous improvement. Required Skills & Experience8+ years of hands-on SQL Server DBA experience in production (administration and operations/support). \n Strong proficiency in T-SQL (writing and troubleshooting complex queries, stored procedures, and jobs).Experience with SQL Server HA/DR: Always On Availabili