jobs in ITC Infotech

ITC Infotech Hiring! Full Time Database Administrator (Sybase ASE - MS SQL Server) in - Ricebowl

Database Administrator (Sybase ASE - MS SQL Server)

ITC Infotech

Singapore

Share
Save

Working Location

  • Singapore

Job Description

Responsibilities

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.


Important Information

Never provide your bank or credit card details when applying for jobs. Do not transfer any money or complete unrelated online surveys. If you see something suspicious, Report this Job ad.

Learn More