Description

You will own the design, implementation, and optimization of enterprise-level SQL Server databases.

Responsibilities

• Design target SQL Server database architecture and data partitioning strategies for large tables.
• Develop comprehensive data migration strategies, including ETL processes and data validation.
• Establish high availability, disaster recovery solutions, and secure database architecture.
• Optimize SQL Server performance by tuning queries, indexing, and stored procedures.
• Maintain, configure, and monitor SQL Server instances, ensuring operational health and security.

Required Skills

• 8+ years of professional experience with SQL Server Administration.
• Expert knowledge of SQL Server 2019/2022 and advanced T-SQL (stored procedures, functions, triggers).
• Deep expertise in database design, normalization (up to 5NF), and schema conversion.
• Proven experience designing and implementing data migration strategies for large datasets (500GB+).
• Proficiency in SQL Server Always On Availability Groups, replication, and disaster recovery planning.
• Strong capability in performance tuning, including query optimization, indexing strategies, and execution plan analysis.
• Experience with cloud database services, specifically AWS RDS for SQL Server (3+ years).
• Familiarity with ETL tools (SSIS, Azure Data Factory, AWS DMS) and data quality assurance.
• Experience with CI/CD for database deployments using GitHub.

Key Skills

Education

Bachelor's degree