GSK Solutions Inc - SQL Database Architect

Database Developer is needed in Hamilton, United States.

Client: GSK Solutions Inc

Location: Township of Hamilton, NJ

Contract: Contract

Job Description

The SQL Database Architect is responsible for designing, developing, and implementing highly-complex, reliable, and scalable databases to meet the organization’s objectives and requirements. This role requires familiarity with various database technologies, concepts, methodologies, practices, and procedures. The architect performs a variety of complex tasks with minimal supervision, assisting in defining system and application architecture while providing vision, problem anticipation, and problem-solving abilities. This includes consulting clients to identify needs or issues and conducting research to analyze problems and recommend solutions.

Requirements

PREFERRED QUALIFICATIONS: Extensive knowledge of specific database systems and hands-on work in all phases of database design and management. Experience in various technologies and roles including database systems of any type and size.

Technical Skills (Must Have)

• 8+ years of SQL Server administration experience
• Expert knowledge of SQL Server 2019/2022
• Advanced T-SQL programming
• Database design and normalization (1NF through 5NF)
• High Availability & Disaster Recovery strategies
• Performance tuning and optimization techniques
• AWS RDS for SQL Server experience (3+ years)
• Large-scale data migration experience
• PowerShell and T-SQL scripting for automation

Professional Experience (Must Have)

• 10+ years of database administration experience
• 3+ years of cloud database experience (Azure SQL or AWS RDS)
• Experience with large-scale data migrations (500GB+ databases)
• Experience with mission-critical systems (99.9%+ uptime)
• Experience with high-transaction environments (50K+ transactions/day)
• Experience with Agile/Scrum methodologies

Key Responsibilities

Responsibilities for the role are divided into several key areas:

• Database Architecture & Design (30%): Includes designing SQL Server database architecture, data partitioning strategy, security architecture, and disaster recovery solutions.
• Data Migration (25%): Involves developing a data migration strategy, creating ETL processes, validating data, and ensuring data integrity during migration.
• Performance Optimization (20%): Focuses on query optimization, indexing strategy, tuning procedures, and monitoring performance bottlenecks.
• Database Administration (15%): Encompasses SQL Server instance management, user roles and permissions, health monitoring, and maintenance activities.
• High Availability & Disaster Recovery (10%): Requires implementing Always On Availability Groups, configuring replication, and testing disaster recovery procedures.

Interview Process

Interviews will be conducted either via iLinc Web Cam or in person, with a preference for in-person interviews for first-round candidates.

Company Overview

GSK Solutions Inc. is a dynamic IT services provider specializing in consulting solutions and staff augmentation across various technology domains. We deliver high-quality, timely, and cost-effective solutions that frequently exceed client expectations through innovative approaches and expert execution.

Compensation

Pay Rate: $70/hr on C2C / 1099 all inclusive (OR) $65/hr on W2

Work Location: In person in Hamilton, NJ