Description

You will own the design, development, and deployment of database architectures and high-volume applications.

This role is on-site.

Responsibilities

• Design and architect data models and database schemas based on technical requirements.
• Implement database clustering for high availability and manage failover procedures.
• Create, maintain, and optimize database objects including indexes, triggers, views, and stored procedures.
• Manage large-scale bulk data migrations, including cleansing, mapping, and transforming over 50 million records.
• Optimize SQL query performance and throughput for high-volume OLTP environments.

Required Skills

• 10+ years of experience with SSRS and SSIS.
• 10+ years in SQL Server Architect, Developer, or Administrator roles on large-scale projects.
• 10+ years developing both OLTP and Kimball-style data warehousing models.
• 10+ years managing schema and data changes in large-scale environments.
• 10+ years with SQL Server 2019 CLUSTER (Active/Active/Passive) configurations.
• Proven experience designing clusters to handle over one million OLTP transactions daily.
• Expertise in writing and debugging complex stored procedures.
• Proficiency with XML, meta-data, and performance tuning.
• 2-3 years of experience as a DBA Administrator.

Key Skills

Education

Any Graduate