Senior MSSQL Database Architect | Remote SQL Server Expert

Are you a seasoned Database Architect with profound MSSQL acumen and zeal for optimizing intricate database ecosystems? Our client seeks a Senior Database Architect to conceptualize, implement, and sustain robust SQL Server infrastructure powering mission-critical applications. In this remote position, you'll harness your T-SQL coding prowess and database design expertise to forge scalable, high-velocity database solutions. Key Responsibilities - Architect and implement sophisticated database infrastructures utilizing Microsoft SQL Server technologies. - Craft and maintain efficacious T-SQL stored procedures, functions, and triggers. - Devise and optimize database models, schemas, tables, and relationships with meticulous attention to performance. - Establish authoritative best practices for database design, development, and maintenance across the organization. - Execute database performance tuning, query optimization, and troubleshooting to ensure optimal system operation. - Implement strategic indexing methodologies to enhance query performance and reduce resource consumption. - Design and orchestrate high-availability solutions—including clustering, mirroring, or Always On availability groups. - Strategize and execute database migration initiatives with negligible downtime... a critical success factor. - Develop and implement comprehensive database backup and recovery strategies (ensuring business continuity). - Monitor database performance metrics and proactively address potential bottlenecks before they impact operations. - Collaborate synergistically with development teams to ensure seamless database integration. - Meticulously document database designs, configurations, and maintenance procedures for knowledge transfer. - Mentor junior database professionals on industry best practices and advanced SQL techniques. Required Skills - 5+ years of professional experience as a Database Architect or analogous role. - 3+ years of hands-on experience with T-SQL coding and optimization techniques. - 3+ years of experience wielding Microsoft SQL Server (versions 2016-2022). - Formidable expertise in SQL query composition, optimization, and performance tuning. - Demonstrated experience in database modeling, normalization, and design principles. - Mastery of Data Manipulation Language (DML) and database design fundamentals. - Proficiency with SQL Server Management Studio (SSMS) and complementary tools. - Comprehensive knowledge of database security best practices and implementation strategies. - Extensive experience designing and implementing stored procedures, functions, and triggers. - Exceptional problem-solving and analytical aptitude with fastidious attention to detail. - Robust communication skills for collaborating with technical and non-technical stakeholders. - Capability to translate complex business requirements into effective database solutions. - Experience thriving in a remote environment with geographically dispersed teams. Nice to Have - Experience with Azure SQL Database or SQL Server deployed on cloud platforms. - Proficiency with SQL Server Integration Services (SSIS), Reporting Services (SSRS), or Analysis Services (SSAS). - Familiarity with database DevOps methodologies and CI/CD pipelines for database changes. - Knowledge of NoSQL databases and polyglot persistence architectural approaches. - Relevant certifications—Microsoft Certified: Azure Database Administrator Associate or equivalent. - Experience implementing data warehousing concepts and solutions. - Conversance with business intelligence tools and practices. - Background in industries with stringent data security mandates (finance, healthcare, etc.). - Understanding of data governance frameworks and practical implementation. Why Join Us Collaborating with our client offers you the opportunity to confront complex database challenges while savoring the flexibility of remote work. You'll become an integral part of a forward-thinking team that cherishes innovation and technical excellence. This position provides substantial growth trajectories as you architect mission-critical database systems that empower essential business operations. We provide competitive compensation, professional development support, and the chance to work with cutting-edge database technologies that keep your skills at the industry forefront.