SQL Server Database Architect

About Us Schring Consulting is a provider of IT Professional Services, focusing on helping businesses succeed through planning, building, and deploying initiatives. Founded in 2003, Schring has expertise in project delivery & execution, software development, and IT staff augmentation. About the Role We are looking for a SQL Server Database Architect to lead the design, optimization, and governance for a large deployment with 100+ DB servers. Some of these are running mission-critical apps and we need an SME to review, design, and build out redundancies and backups for resiliency. This role will also provide expertise in optimization of databases to ensure they are configured in scalable and highly available environments. This is a contract position. Weekly hours may vary with initial work needing more effort and reducing as the project progresses. Position is fully remote. About the Work High Availability, Disaster Recovery, and Scalability - Design options for redundancy & resiliency - Discuss with architecture to finalize solution - Build out solution - Design and test disaster recovery procedures - Define and achieve low/optimal RPO and RTO - Configure database replication and automated failover mechanisms - Conduct DR testing and validation Performance Optimization - Design indexing strategies for optimal performance - Optimize queries for sub-second response times - Tune stored procedures and functions - Conduct performance testing and resolve bottlenecks - Implement caching strategies and table partitioning for large datasets Database Architecture and Design - Design target SQL Server database architecture - Design normalized schemas across multiple databases - Develop data partitioning strategies for large tables - Create database security architecture, audit trail, and history tracking mechanisms - Establish backup and recovery architecture - Design high availability and disaster recovery solutions Database Administration & Security - Implement security policies and access controls - Implement monitoring tools for database health and performance - Build alerts for database growth and capacity planning About you Required Qualifications - 10+ years of SQL Server administration experience - Expert knowledge of SQL Server 2017 – 2022 - RHEL / Linux and Windows environments - Advanced T-SQL programming (stored procedures, functions, triggers, views) - Proficiency in database design and normalization (1NF - 5NF) - Deep expertise in high-availability and disaster recovery - Performance tuning and optimization (query tuning, index optimization, execution plan analysis) - Scripting and automation experience (PowerShell, T-SQL, CI/CD for database deployments) - Experience in high-transaction environments - Led or participated in database modernization projects - Experience with mission-critical systems requiring 99.9% uptime - Extensive knowledge of various database systems and hands-on experience with all phases of database design and management Job Type: Contract Benefits: - Flexible schedule Work Location: Remote