Overview:
Azure SQL DBA/Architect
Remote | US Based
US Citizenship or Green Card Holder Required
Employment Options: 1099 Contract Only (No Third Parties)
Project Duration: 5 Months; Average of 120 hours per month
Summary
Our client is an IT consultancy and managed services provider (MSP) that leverages its strong team presence to advance our clients to a secure digital enterprise. With a 25-year corporate resume, our client delivers strategic managed services, IT consulting, and hybrid multicloud infrastructure solutions to optimize our clients’ technology environments. Additionally, our client is NMSDC-certified, with a portfolio of clients that includes some of the nation’s largest airports, utilities, commercial real estate portfolios, and government agencies. They are also backed by Abry Partners, a Boston-based sector-focused private equity firm with $5B under management and more than 30 years of experience in the technology market.
Responsibilities
Our client is seeking an Azure SQL DBA/Architect to design, implement, and optimize complex, highly available SQL databases, with a focus on migrating on-premise SQL databases to the Azure Cloud. The ideal candidate will also provide ongoing database support, recommend best practices, and perform day-to-day database management tasks.
- Plan and execute migrations of highly available SQL databases from on-premise environments to Azure Cloud
- Collaborate with DBAs, application administrators, development, and test teams to define requirements and solve complex problems
- Lead the architecture and design of complex database systems, focusing on performance, scalability, and optimization
- Review and enhance database design, integration, and performance optimization strategies
- Recommend best practices for data modeling, indexing, and query optimization to improve performance and reliability
- Design and implement data migration strategies for a smooth transition to the Azure cloud environment
- Proactively monitor database health, addressing performance issues and bottlenecks
- Drive the adoption of Microsoft Azure SQL Managed Instance (SQL MI) for scalability and manageability
- Ensure data protection and regulatory compliance in collaboration with security and compliance teams
- Perform risk analysis and manage risks related to database systems, including disaster recovery planning and testing
- Maintain strict confidentiality of sensitive data
Requirements
- Minimum of 5 years of experience as a Microsoft SQL DBA, including design, builds, upgrades, migrations, and performance tuning
- Experience with cloud migration projects, particularly in migrating SQL databases to Azure Cloud
- Proficient in Windows Server, WSFC, Always On, Disaster Recovery, and SQL Server architecture
- Hands-on experience with SQL Server Mirroring, Log Shipping, Clustering, and High Availability features
- Strong experience with SSIS and SSRS for business intelligence requirements
- Knowledgeable in database performance tuning, query optimization, and database troubleshooting
- Experience with backups, restore, recovery models, and configuring failover clusters
- Expertise in SQL High Availability, clustering environments, and DBCC utilities
- Experience with Microsoft Azure, IaaS, and PaaS solutions
- Knowledge of indexes, index management, statistics, and Active Directory configurations
- Excellent communication, documentation, and interpersonal skills
Education/Certification Requirements
Other Duties
Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties, or responsibilities that are required of the employee for this job. Duties, responsibilities, and activities may change at any time with or without notice.
--------------
About Us
Northern Virginia-based Precision Solutions is an expert in staffing solutions for companies of any size that open the door to new opportunities and seek outstanding talent. We pride ourselves on being versatile enough to tailor our relationships to the needs of each individual client, being agile in the fast-paced marketplace, and being precise in meeting the needs of any company.
Equal Opportunity Employer Statement
Precision Solutions is an equal opportunity employer. We prohibit discrimination and harassment of any kind based on race, color, sex, religion, sexual orientation, national origin, disability, genetic information, pregnancy, or any other protected characteristic as outlined by federal, state, or local laws.
