Senior SQL Server DBA / Data Architect

⭐ - Featured Role | Apply direct with Data Freelance Hub
This role is a Senior SQL Server DBA / Data Architect, remote, with a contract length of "unknown." Pay rate is "unknown." Requires 10+ years of SQL Server experience, expertise in T-SQL, and knowledge of cloud platforms. Certifications are a plus.
🌎 - Country
United States
💱 - Currency
$ USD
💰 - Day rate
Unknown
Unknown
🗓️ - Date discovered
April 24, 2025
🕒 - Project duration
Unknown
🏝️ - Location type
Remote
📄 - Contract type
Unknown
🔒 - Security clearance
Unknown
📍 - Location detailed
Dallas, TX
🧠 - Skills detailed
#Database Infrastructure #Logical Data Model #Scala #Visualization #Data Lake #SSIS (SQL Server Integration Services) #AWS RDS (Amazon Relational Database Service) #BI (Business Intelligence) #Computer Science #Database Performance #Disaster Recovery #Presto #Schema Design #SQL Server #AWS (Amazon Web Services) #RDS (Amazon Relational Database Service) #Cloud #Data Architecture #Azure SQL Database #Migration #Security #Database Architecture #Data Governance #Azure SQL #Compliance #HADR (High Availability Disaster Recovery) #Python #DevOps #Microsoft Power BI #Replication #Scripting #NoSQL #SQL (Structured Query Language) #Data Encryption #GDPR (General Data Protection Regulation) #Deployment #Storage #SSAS (SQL Server Analysis Services) #Monitoring #Azure #DBA (Database Administrator) #Data Engineering #SSRS (SQL Server Reporting Services) #MongoDB #Automation #Documentation #Databases #"ETL (Extract #Transform #Load)" #Indexing
Role description

Job Title: Senior SQL Server DBA / Data Architect

Location: Remote

Experience Required: 10+ years

Job Summary

We are seeking a highly experienced and detail-oriented Senior SQL Server Database Administrator / Data Architect to lead the design, implementation, and maintenance of our SQL Server database infrastructure. The ideal candidate will have over a decade of experience with SQL Server, a deep understanding of database architecture and performance tuning, and a proven track record of building scalable and secure database solutions

Key Responsibilities

   • Design, implement, and maintain complex SQL Server database solutions.

   • Develop and optimize physical and logical data models.

   • Perform database performance tuning, monitoring, and troubleshooting.

   • Ensure high availability, disaster recovery, and business continuity strategies.

   • Collaborate with development teams to optimize schema design and queries.

   • Lead database modernization and migration projects, including to/from cloud platforms.

   • Create and maintain database documentation, standards, and best practices.

   • Implement security measures to safeguard sensitive data (encryption, auditing, RBAC).

   • Plan capacity and storage, forecast growth, and recommend infrastructure improvements.

   • Mentor junior DBAs and developers, and lead database-related initiatives.

Technical Skills & Qualifications

   • 10+ years of hands-on experience with SQL Server (2012–2022).

   • Deep expertise in T-SQL, stored procedures, indexing, and query optimization.

   • Strong experience with SSIS, SSRS, and SSAS.

   • Proficient in backup/restore strategies, Always On availability groups, replication.

   • Experience with data warehousing, dimensional modeling, and ETL frameworks.

   • Working knowledge of cloud platforms (Azure SQL Database, AWS RDS, etc.) is a plus.

   • Familiarity with DevOps practices and CI/CD for database deployments.

   • Strong understanding of data governance, compliance (GDPR, HIPAA, etc.).

   • Bachelor’s or Master’s degree in Computer Science, Information Systems, or related field.

   • Certifications like Microsoft Certified: Azure Data Engineer/Database Administrator Associate are a plus.

Nice To Have

   • Experience with non-relational databases (NoSQL, Cosmos DB, MongoDB, etc.)

   • Power BI or other data visualization experience.

   • Knowledge of data lake and data mesh architectures.

   • Scripting skills (PowerShell, Python) for automation.