Senior SQL Database Administrator

seaco asia pte. ltd.; Singapore; Sur place; SGD 120 000 - 160 000; Plein temps

Résumé du poste

Seaco Asia Pte. Ltd. is seeking an experienced SQL Database Administrator to design, engineer, and optimize our Microsoft SQL Server environment. You will implement replication models, develop SQL objects, and lead performance hardening efforts while collaborating with development teams.

The role requires 5+ years of SQL DBA experience, strong problem-solving skills, and the ability to work independently or with others to deliver robust data platforms.

Qualifications

• Bachelor's degree required.
• 5+ years as MS SQL Database Administrator.
• Experience designing/implementing complex SQL projects.
• Knowledge of SQL Server 2012+ including Availability Groups.
• Familiarity with DB2 SQL/400 preferred.

Responsabilités

• Design, plan, and engineer the Company's Microsoft SQL Server environment.
• Implement and maintain SQL replication models for data accuracy.
• Develop stored procedures, triggers, views, and other SQL objects.
• Provide technical advisory to development teams and resolve SQL issues.
• Create preventative maintenance procedures and documentation.
• Establish connectivity and access standards; ensure security integration.

Connaissances

Microsoft SQL Server

Transact-SQL

Replication

Linked servers

Backup strategies

Active Directory

Windows security

DB2 SQL/400

Communication

Problem-solving

Independent work

Collaboration

Formation

Bachelor's degree

Description du poste

This position is responsible for the planning, design and engineering of the Company's RDBMS environment (Microsoft SQL Server); acts as technical resource and as technical advisor to the development group; responsible for the tracking and resolution to SQL related problems and the communication of status to appropriate individuals; responsible for the stability of the Company's SQL replication model; manages the development of preventative maintenance procedures and methods; consults with development group on a variety of issues and provides support as required.

DUTIES & RESPONSIBILITIES

Database Architecture & Engineering

• Design, plan, and engineer the Company's Microsoft SQL Server environment
• Implement and maintain SQL replication models for data accuracy
• Develop stored procedures, triggers, views, and other SQL objects
• Perform code reviews for all SQL changes

Performance & Optimization

• Optimize database performance through indexing, query tuning, and configuration
• Design and test SQL Server business continuity plans
• Establish connectivity and access standards for SQL environments

Standards & Documentation

• Create installation/software implementation standards for SQL systems
• Develop preventative maintenance procedures and methods
• Document database architectures and troubleshooting guides

Collaboration & Support

• Act as technical advisor to development teams
• Resolve SQL-related problems and communicate status updates
• Consult on development projects requiring database expertise

REQUIREDQUALIFICATIONS:

Knowledge and Skills:

Technical Expertise

• Microsoft SQL Server (2012+ including Availability Groups)
• Transact-SQL programming (stored procedures, triggers, views)
• Replication, linked servers, and backup strategies
• ODBC/MDAC connectivity
• Windows Active Directory/SQL security integration
• DB2 SQL/400 (preferred)

Soft skills

• Excellent verbal/written communication
• Strong technical analysis and problem-solving
• Ability to work independently and collaboratively

Education and Experiences:

Required:

• Bachelor's degree
• 5+ years as Microsoft SQL Database Administrator
• Experience designing/implementing complex SQL projects