Senior SQL Database Administrator

Seaco Asia Pte Ltd; Singapore; On-site; SGD 70,000 - 120,000; Full time

Job summary

Seaco Asia Pte Ltd in Singapore seeks an experienced Microsoft SQL Database Administrator to design, engineer and optimize the SQL Server environment. You will implement replication models, develop SQL objects, and ensure performance, security, and BC plans.

Collaborate with development teams, perform code reviews, and create documentation for architectures and troubleshooting guides. 5+ years of DBA experience and a Bachelor's degree are required.

Qualifications

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

Responsibilities

• 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.
• 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.
• Act as technical advisor to development teams and resolve SQL-related problems.

Skills

SQL Server

Availability Groups

Transact-SQL

Replication

Linked servers

Backup strategies

Education

Bachelor's degree

Job description

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