Role Overview:
We are looking for a hands-on, proactive Database Administrator (DBA) with deep expertise across both SAP Sybase ASE and Microsoft SQL Server. In this dual-platform role, you will own day-to-day Business-As-Usual (BAU) database operations, drive measurable reductions in recurring production incidents, and play a key role in migrating legacy Sybase workloads to MS SQL Server. Exposure to multi-engine environments (such as Oracle, Snowflake, Cassandra, or MariaDB) is a strong plus.
Key Responsibilities:
1. BAU Operations & Production Support
- Manage, monitor, and maintain mission-critical Sybase ASE and MS SQL Server environments across production, UAT, and development tiers.
- Handle daily BAU tasks including user access management, database refreshes, patching, capacity planning, and scheduled maintenance jobs.
- Ensure strict adherence to backup and recovery schedules, verifying RTO/RPO compliance through regular restore drills.
- Maintain high availability and disaster recovery (HA/DR) configurations, including MS SQL Always On Availability Groups, Failover Clusters, and Sybase Replication Server.
- Participate in a rotating on-call support schedule to resolve critical production issues (P1/P2) within SLA timelines.
2. Incident Reduction & Proactive Stability
- Analyze recurring P1–P4 incident trends to identify systemic database bottlenecks and eliminate root causes.
- Proactively tune slow-running T-SQL queries, optimize execution plans, refine indexing strategies, and resolve locking, blocking, and tempdb/transaction log contention.
- Build and refine automated health checks, alerting thresholds, and self-healing scripts (PowerShell, Shell/Bash, T-SQL) to catch issues before they impact end users.
- Standardize runbooks, SOPs, and alert documentation to streamline L1/L2 triage and speed up Mean Time to Resolution (MTTR).
3. Sybase to MS SQL Server Migration
- Partner with application, architecture, and infrastructure teams to plan and execute Sybase ASE to MS SQL Server migrations.
- Conduct schema, stored procedure, and data type assessments using tools such as SQL Server Migration Assistant (SSMA) for Sybase.
- Assist in rewriting and optimizing Sybase-specific T-SQL code, triggers, and batch jobs for MS SQL Server compatibility.
- Support data migration testing, performance benchmarking, cutover execution, and post-migration hypercare stabilization.
Required Qualifications:
- Experience: 5+ years of hands-on production DBA experience managing both SAP Sybase ASE (15.x / 16.x) and MS SQL Server (2016, 2019, 2022).
- BAU & Operations: Proven track record managing high-availability production environments, patching, backups, and security compliance.
- Problem Management: Demonstrated success in Root Cause Analysis (RCA), performance tuning, and measurably lowering ticket/incident volumes.
- Migration Experience: Hands-on experience with database upgrades or cross-platform migrations—specifically Sybase to MS SQL Server (including SSMA, T-SQL syntax differences, and data validation).
- Scripting & OS: Strong scripting skills in T-SQL, PowerShell, and Linux/Unix Shell (Bash/Ksh), with solid administration knowledge of both Windows Server and Linux/Unix platforms.
Preferred Qualifications (Good to Have)
- Multi-Database Exposure: Working knowledge or production support experience with Oracle, Snowflake, Apache Cassandra, or MariaDB.
- Cloud Platforms: Experience migrating or managing MS SQL Server on cloud platforms (AWS RDS/EC2 or Azure SQL / Managed Instance).
- Monitoring & ITSM: Familiarity with enterprise observability and ticketing tools (e.g., ServiceNow, SolarWinds DPA, Redgate SQL Monitor, Dynatrace, or CloudWatch).
- Automation: Experience with CI/CD database deployment pipelines and infrastructure-as-code.