SQL Server Data Architect

Overview

On Site
Depends on Experience
Contract - W2
Contract - 12 Month(s)

Skills

Database
Collaboration
PowerDesigner
Query Optimization
Recovery
Scalability
Database Migration
Communication
Computer Science
Conflict Resolution
Data Modeling
ERwin
Information Technology
Microservices
Microsoft SQL Server
Performance Tuning
Problem Solving
Backup
Stored Procedures
Transact-SQL
Virtual Machines

Job Details

  • Bachelor's or Master's degree in Computer Science, Information Technology, or a related field.
  • 15+ 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.
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 Techwizens LLC