Senior Database Developer

Wynn Al Marjan Island

Job Description

Roles & Responsibilities

Desired Candidate Profile

The primary duties and responsibilities of this role are:

• 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

• Migrate and develop complex stored procedures

• Understand and assist with development with ETL pipelines including Python scripts for data processing

• Monitor and troubleshoot database performance, integrity, and security

• Document database architecture, standards, and development processes

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

• SQL Server Expertise: Excellent 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

• Development & Deployment: Strong familiarity with CI/CD tools and versioning strategies for database code

• 5+ years of experience in SQL Server database development

• Experience with SSIS, SSRS, TSQL, ETL, DWH, and SQL Server Agent