Senior Database Developer - Systems Architecture

Wynn Al Marjan Island

About the Position:

Wynn Al Marjan Island is currently seeking a Senior Database Developer to join the IT team.

The primary duties and responsibilities of this role are:

• The Senior Database Developer will lead the design, development, and optimization of SQL Server databases to support enterprise applications, analytics, and operational systems. This role demands deep expertise in SQL Server technologies, database architecture, and cloud-based deployments

• Design and implement robust SQL Server database schemas, stored procedures, functions, and triggers.

• Develop and maintain ETL processes using SSIS and other integration tools

• Optimize T-SQL queries and indexing strategies for performance and scalability

• Implement and manage Change Data Capture (CDC) for real-time data tracking

• Set up and maintain replication servers for high availability and disaster recovery

• Collaborate with application developers and analysts to support backend data needs

• Conduct database deployments and version control using CI/CD pipelines

• Monitor and troubleshoot database performance, integrity, and security

• Document database architecture, standards, and development processes

About You:

The ideal candidate for this position will have the following experience and qualifications:

• 5+ years of experience in SQL Server database development

• Experience with SSIS, SSRS, and SQL Server Agent

• SQL Server Expertise: Highly rated skills in T-SQL, query optimization, and performance tuning

• Stored Procedures & Functions: Advanced experience in writing and debugging complex logic

• Triggers: Proficient in designing and managing triggers for business logic enforcement.

• CDC & Replication: Hands-on experience with Change Data Capture and replication server setups

• Database Concepts: Strong understanding of relational models, ER diagrams, normalization, and operational systems

• Azure Cloud SQL DB: Experience deploying and managing SQL Server databases in Azure environments. Familiarity with CI/CD tools and versioning strategies for database code