Remote opportunity For SQL Database Architect

DATAmundi; United States; Remote; USD 83,000 - 165,000; Full time

Job summary

DATAmundi is seeking an experienced Microsoft SQL Server DBA and Database Architect for a remote, short-term engagement. You will design, implement and manage SQL Server architectures, ensuring performance, security, and availability while collaborating with DevOps and development teams.

Ideal candidates have 10–12+ years of hands-on SQL Server experience, proficiency with Azure SQL Database, AGs, and CI/CD for databases. Strong communication and documentation skills are required.

Qualifications

• 10–12+ years of hands-on SQL Server DBA/architecture experience.
• Experience with replication, clustering and Always On Availability Groups.
• Proficiency in T-SQL scripting, performance tuning and troubleshooting.
• Strong knowledge of database security, data integrity and compliance.

Responsibilities

• Design scalable SQL Server database architectures, schemas, and data models.
• Develop and maintain T-SQL scripts for automation and maintenance.
• Optimize performance via query tuning, indexing and caching.
• Manage availability, replication, clustering and AGs.
• Collaborate with development and DevOps to enable CI/CD pipelines for databases.
• Ensure security, data accuracy and compliance across databases.
• Document configurations, architectures and operational procedures.
• Assist integration of databases with applications and APIs.

Skills

SQL Server DBA

Database architecture

T-SQL scripting

Query optimization

Performance tuning

Data modeling

Security/compliance

CI/CD for databases

DevOps collaboration

Communication & collaboration

Documentation

Education

Bachelor's degree in Computer Science or related field

Microsoft SQL Server certification

Tools

SQL Profiler

Azure SQL Database

Always On Availability Groups

Job description

We are looking for an experienced Microsoft SQL Server DBA / Database Architect for an urgent, remote, short-term project.

• Location: Remote
• Experience: 1012+ years
• Duration: 4 months, extendable by 1-2 months
• Employement - Consultant of Datamundi.ai
• Payment Terms - 3 - 45 days from the date of invoice

Job Overview

The candidate will be responsible for designing, developing, and managing SQL Server database architecture, ensuring optimal performance, security, scalability, and availability. The role involves collaborating with development, DevOps, and other IT teams to deliver effective database solutions aligned with business requirements.

Key Responsibilities

• Design and develop scalable SQL Server database architectures, schemas, and data models.
• Implement database solutions that improve application performance, scalability, and reliability.
• Optimize database performance through query tuning, indexing, caching, and troubleshooting.
• Manage database availability, replication, clustering, and Always On Availability Groups.
• Develop and maintain T-SQL scripts for database automation and maintenance.
• Monitor database performance and resolve complex technical issues using tools such as SQL Profiler.
• Translate business requirements into effective database designs and data models.
• Collaborate with software developers to integrate databases with applications and APIs.
• Work with DevOps teams to implement database CI/CD pipelines and deployment processes.
• Ensure database security, data accuracy, accessibility, and compliance.
• Maintain comprehensive documentation of database configurations, architecture, and operational procedures.
• Recommend improvements to existing database systems and database management processes.

Required Skills & Qualifications

• 10-12+ years of hands-on experience in Microsoft SQL Server database administration and architecture.
• Strong knowledge of relational and non-relational databases, database normalization, data modelling, and indexing.
• Expertise in T-SQL scripting, query optimization, performance tuning, and database troubleshooting.
• In-depth knowledge of SQL Server features, including replication, clustering, and Always On Availability Groups.
• Experience with Azure SQL Database and cloud database services.
• Familiarity with database performance monitoring tools, including SQL Profiler.
• Experience with database security, compliance standards, and data integration strategies.
• Knowledge of database DevOps practices and CI/CD pipelines.
• Strong understanding of software architecture and database design principles.
• Bachelor's degree in Computer Science, Information Technology, or a related field.
• Microsoft SQL Server certification is preferred.
• Excellent analytical, problem-solving, communication, and collaboration skills.

Work Location: Remote