SQL DBA

As discussed, please find the below JD.

Overview

SEA People Analytics team is looking for a skilled SQL Server Database Administrator (DBA) on a contract basis. The ideal candidate will have 8–10 years of experience managing on-premises SQL Server environments with strong expertise in performance tuning, security, and availability. This role supports business-critical applications and requires coordination with internal teams to ensure data systems are optimized, reliable, and secure.

Key Responsibilities

• Data Infrastructure:

  Support new data sources, data cleanup, or automation projects as scheduled during May/June and September/October biannual roadmap planning sessions.

• Database Management:

  Install, configure, and maintain on-premises SQL Server instances to ensure high availability and performance.

• The on-premise SQL server is to be migrated to the Samsung Cloud as of September 2025.

  This role will help prep/test the environment for the transition and the role will transition from on prem maintenance to cloud based server work after the transition is complete.

• Performance Optimization:

  Monitor and tune database performance using tools such as SQL Profiler, Activity Monitor, and Performance Monitor.

• Security Enforcement:

  Implement user access controls, encryption, and auditing practices in line with company policies. Maintain and update security controls as required.

• Backup and Recovery:

  Develop and manage backup to protect data integrity and business continuity.

• Data Pipeline Monitoring:

  Monitor and troubleshoot data pipeline processes to ensure efficient and accurate data flow.

• Cross-Team Collaboration:

  Work closely with application and data engineering teams for query optimization, schema design, and data integration.

• Documentation:

  Maintain accurate documentation of database configurations, maintenance procedures, and compliance requirements.

• Regulatory Compliance:

  Ensure all database systems comply with relevant governance policies and industry standards.

Required Qualifications

• 8–10 years of experience as a SQL Server DBA in production environments.
• Strong proficiency in T-SQL and experience with SQL Server versions 2016 or later.
• Strong proficiency in Python
• Solid understanding of backup, recovery models, and disaster recovery best practices.
• Hands-on experience with high availability solutions such as Always On Availability Groups, replication, or log shipping.

Preferred Qualifications

• Experience with SQL Server Integration Services (SSIS), Reporting Services (SSRS), and Analysis Services (SSAS).
• Experience working in environments aligned with data governance and compliance frameworks.
• Experience with Alteryx (Designer & Server) is a plus.

Soft Skills

• Strong analytical and troubleshooting skills.
• Effective written and verbal communication.
• Ability to work independently and within cross-functional teams.
• Highly organized and detail-oriented with a proactive mindset.

Work Schedule

The candidate shall be supporting the customer during their preferred working hours as listed below:

1. Monday through Friday: 06:30 PM to 03:30 AM
2. Excluding standard US Holidays as published by the customer in the beginning of the year

Work Location

The candidate may work from offsite/offshore location based on the following restrictions:

1. access to customer environment using SDSA approved device
2. Access customer environment using VDI and provisioned

   by SDSA and located in New Jersey, USA

   .