jobs in ITC Infotech

全职 Database Administrator (Sybase ASE - MS SQL Server) 工作, 薪水, ITC Infotech 公司招聘中 - Ricebowl

Database Administrator (Sybase ASE - MS SQL Server)

ITC Infotech

Singapore

分享
保存

工作地点

  • Singapore

职位描述

岗位职责

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.


重要安全守则

申请工作时,切勿提供您的银行或信用卡详细资料。不要转账或完成无关的在线调查问卷。如果您发现可疑内容,请举报此招聘广告。

了解更多