SQL Server Architect || Hybrid - Maryland || 12+ Years Experience ||

  • Maryland City, MD
  • Posted 15 hours ago | Updated 15 hours ago

Overview

Hybrid
Depends on Experience
Accepts corp to corp applications
Contract - W2
Contract - Independent
Contract - 12 Month(s)

Skills

Disaster Recovery
Database Architecture
Database Design
Database Migration
ERwin
High Availability
Data Archiving
Data Modeling
Data Security
Data Storage
Database
Artificial Intelligence
Backup
Collaboration
Communication
Conflict Resolution
Performance Tuning
PowerDesigner
Problem Solving
Query Optimization
DevOps
Management
Mentorship
Microservices
Microsoft SQL Server
Transact-SQL
Virtual Machines
RPO
Recovery
Regulatory Compliance
Scalability
Stored Procedures

Job Details

SQL Server Architect

Hybrid - Maryland

12+ Years Experience

Key Responsibilities:

Assess the current SQL Server database architecture and identify areas for improvement in scalability, performance, and maintainability.

Design and implement a new high-performance, future-ready database architecture to support a 5M daily transaction load and integration with microservices and AI-driven systems.

Develop and implement a comprehensive archival strategy for cold, warm, and hot data storage to efficiently manage a large-scale system of 100TB.

Work closely with application developers to ensure database design aligns with the microservices architecture.

Optimize database performance by identifying and resolving bottlenecks, indexing strategies, and query tuning.

Develop and implement best practices for database design, partitioning, indexing, and data archiving.

Ensure high availability and disaster recovery strategies with near-zero RPO and RTO, considering the multi-agency information handled by the system.

Collaborate with DevOps teams to automate deployment, backup, and monitoring processes.

Implement data security measures and ensure compliance with industry standards.

Provide technical guidance and mentorship to the development and operations teams.

Stay up-to-date with the latest SQL Server technologies and industry trends.

Required Qualifications:

Bachelor's or Master's degree in Computer Science, Information Technology, or a related field.

8+ years of experience in SQL Server database design, development, and administration.

Proven experience in redesigning and implementing large-scale, high-performance SQL Server databases, with the ability to contribute from day one.

Strong understanding of database scalability techniques such as sharding, partitioning, and indexing.

Experience in handling large-volume databases (100TB+) and implementing efficient archival strategies.

Proficiency in performance tuning, query optimization, and troubleshooting database issues.

Experience with self-hosted SQL Server databases on virtual machines (VMs).

Hands-on experience with database migration, backup, and recovery processes.

Familiarity with data modeling techniques and tools such as ERwin or PowerDesigner.

Strong knowledge of T-SQL, stored procedures, and triggers.

Experience with microservices architecture and integrating databases within distributed systems.

Excellent problem-solving skills and the ability to work in a fast-paced environment.

Strong communication and collaboration skills.

Thanks

Navya

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

About Bright Sol