About the Role
We’re looking for a mid to senior level MSSQL DBA with Oracle Apps/Oracle RDBMS background to own day-to-day database operations, performance tuning, high availability, and security across our SQL Server environments. You’ll collaborate closely with application teams, DevOps, and InfoSec to ensure our data platforms are reliable, performant, and scalable.
What You’ll Do (Key Responsibilities)
·Administration & Operations
oInstall, configure, and maintain Microsoft SQL Server (2016+ preferred) across development, staging, and production.
oManage user access, roles, and security (AD integration, least privilege, auditing).
oPlan and apply patches and cumulative updates, managing change windows and rollbacks.
·Performance & Optimization
oMonitor and tune performance (indexes, stats, query plans, I/O, memory, CPU).
oUse tools such as Query Store, Extended Events, DMVs, and third-party monitoring (e.g., Redgate, SolarWinds/DPA).
oConduct root cause analyses and implement permanent fixes.
·Backup, Recovery & HA/DR+
oDesign and maintain backup/restore strategies (native backups, compression, encryption).
oImplement and support HA/DR (Always On Availability Groups, Log Shipping, Failover Cluster Instances).
oTest and document disaster recovery procedures with defined RPO/RTO.
·Development Support
oPartner with developers on T‑SQL best practices, schema design, and code reviews.
oManage deployments (SSDT/DACPAC, migrations) and support CI/CD integration.
oOptimize stored procedures, views, functions, and ETL jobs (SSIS or equivalent).
·Automation & Observability
oAutomate routine tasks with PowerShell, SQL Agent jobs, and scripts.
oMaintain monitoring and alerting for capacity, performance, and availability.
oProduce runbooks, documentation, and knowledge base articles.
·Data Governance & Compliance
oImplement encryption at rest/in transit, data masking, and retention policies.
oSupport audits and compliance (e.g., SOX, HIPAA, PCI) where applicable.
·Cloud & Modernization (as applicable)
oSupport SQL Server in Azure/AWS VMs; familiarity with Azure SQL Managed Instance/Azure SQL Database a plus.
oParticipate in migration or modernization initiatives.
Qualifications (Required)
·4-7 years of hands-on experience as an MSSQL DBA in production environments.
·Strong knowledge of SQL Server 2016/2019/2022 administration, T‑SQL, indexing, statistics, and query optimization.
·Experience with Always On Availability Groups, backups/restores, and SQL Server Security (encryption, auditing).
·Proficiency with Windows Server, Active Directory, and networking basics (DNS, TCP/IP).
·Experience with PowerShell scripting and SQL Server Agent job management.
·Familiarity with monitoring/observability tools (native + third-party).
·Excellent documentation, communication, and stakeholder collaboration skills.
Nice-to-Have (Preferred)
·Experience with/exposure to Oracle Apps, Oracle RDBMS, Goldengate
·Exposure to Azure SQL (PaaS/MI), AWS RDS for SQL Server, or Kubernetes (SQL on containers).
·Experience with SSIS, SSRS, SSAS (or modern equivalents).
·Knowledge of ETL/ELT patterns, data warehousing, or BI tooling.
·Experience with DevOps/CI-CD for databases (Git, pipelines, Redgate, SSDT).
·Scripting in Python or Bash, and infrastructure-as-code (Terraform/ARM).
·Certifications: Microsoft Certified: Azure Database Administrator Associate, DP-300, or MCSA/MCSE (legacy).
Education
·Bachelor’s degree in Computer Science, Information Systems, Engineering, or equivalent experience.
Work Eligibility
·Must be authorized to work in the United States.