Description

You will manage and optimize Microsoft SQL Server environments, ensuring high availability, security, and performance across on-premises and cloud infrastructure.

Responsibilities

• Install, configure, and upgrade SQL Server instances, including adding features and migrating to different editions.
• Write, optimize, and maintain complex SQL scripts, DML, DQL, DDL, and DCL statements for legacy process modernization.
• Design and implement data models, including logical, physical, and relational structures, using ER diagrams, views, and triggers.
• Develop and maintain SQL Server Integration Services (SSIS) packages for data movement and transformation.
• Enforce security standards aligned with NIST and Microsoft Trust Center guidelines during development and deployment.

Required Skills

• 5-10 years of experience in database design, implementation, maintenance, and administration.
• Minimum 5 years of experience as a lead Microsoft SQL Server Database Administrator.
• Strong proficiency in SQL Server Installation Center and SQL Server Integration Services (SSIS).
• Expertise in data modeling concepts including normalization, aggregation, concurrency, and data interchange formats like JSON.
• Experience with Azure Cloud Services, BLOB Storage, SQL Data Tools, and SQL Reporting Services.
• Familiarity with Amazon Web Services (AWS) infrastructure.
• Ability to write efficient SQL syntax with clear documentation and peer code review standards.
• Strong analytical, problem-solving, and communication skills for collaboration with project management and application designers.

Preferred Skills

• Experience with JavaScript (JSON) data handling and manipulation.

Key Skills

Education

Any Graduate