Database Architect (SQL Server)

MBI Digital Corp; United States; Remote; USD 90,000 - 150,000; Full time

Job summary

An established industry player is seeking a skilled Database Architect to lead their DBA team and develop a robust database administration strategy. This remote role offers the opportunity to shape database solutions, ensuring high availability and optimal performance of SQL Server environments. The ideal candidate will bring over a decade of experience, including leadership in database architecture, and a proactive approach to problem-solving. Join a dynamic team and make a significant impact on the company's data management strategies while enjoying the flexibility of remote work.

Qualifications

• 10+ years in database administration with SQL Server focus.
• 5+ years leading DBA teams and setting strategies.

Responsibilities

• Develop and drive DBA strategy for scalability and security.
• Lead DBA team, ensuring best practices in administration.
• Architect and optimize SQL Server databases for performance.

Skills

Microsoft SQL Server

Database Architecture

Database Administration

SQL Query Optimization

Automation & Scripting

Leadership

Problem-Solving

Education

Advanced degree or certifications (MCSE: Data Management & Analytics, AWS/Azure Database Certifications)

Tools

Snowflake

Terraform

Ansible

PowerShell

Job description

MBI Digital is looking for a Database Architect with 10+ years of experience in database administration and architecture, with a focus on SQL Server and 5+ years in a leadership role, guiding DBA teams and setting database strategy.

The candidate will be responsible for developing and executing the overall database administration (DBA) strategy, leading the DBA team, and ensuring the optimal performance of our SQL Server environments. This role requires deep expertise in SQL Server architecture, database optimization, and high availability solutions. The ideal candidate will be a strong leader, capable of setting direction and best practices for database management.

This is a 100% remote opportunity with 6-8 months project engagement with possibility of extension. The candidate should be willing to work in the Pacific time zone.

Job Responsibilities:

1. Develop and drive the DBA strategy to ensure scalability, security, and high availability of database systems.
2. Provide direction, mentorship, and oversight to the DBA team, ensuring best practices in database administration.
3. Architect, implement, and optimize SQL Server databases to meet the performance and reliability needs of the business.
4. SQL Expertise: Develop, optimize, and troubleshoot complex SQL queries, stored procedures, and indexing strategies to enhance database performance.
5. Automation & Scripting: Utilize scripting languages (e.g., Python, PowerShell) to automate database processes and deployments.
6. Lead efforts to optimize database performance, including query tuning, indexing strategies, and resource allocation.
7. Design and implement high-availability solutions, replication strategies, and disaster recovery plans for critical databases.
8. Ensure database security, access control, and compliance with industry standards and company policies.
9. Work closely with development, infrastructure, and business teams to align database solutions with company objectives.
10. Establish and maintain database documentation, policies, and best practices for database administration.

Qualifications:

1. 10+ years of experience in database administration and architecture, with a focus on SQL Server.
2. 5+ years in a leadership role, guiding DBA teams and setting database strategy.
3. Hands-on experience with Snowflake administration, including data modeling, security, and workload management.
4. Advanced degree or certifications (MCSE: Data Management & Analytics, AWS/Azure Database Certifications) are a plus.
5. Knowledge of Terraform, Ansible, or Infrastructure as Code (IaC).

Skills:

1. Expert-level experience with Microsoft SQL Server, including database architecture, administration, and optimization.
2. Strong understanding of SQL Server high-availability and disaster recovery solutions (Always On, replication, mirroring, etc.).
3. Experience with database automation, scripting (PowerShell, T-SQL), and performance tuning.
4. Strong leadership, communication, and decision-making skills.
5. Excellent problem-solving skills with a proactive mindset.