Blog

SQL Server Architect with Azure || Remote with Occasional travel

USC, GC and H1b only || Working with an Implementation Partner

Contract to hire and Full-time requirement || EST Candidates only

Candidate preferred location: Chevy Chase, MD | Ashburn, VA

The client may ask to come onsite for a week or two based on work requirements and travel expenses will be paid.

Full-time candidates will be given first preference. If you find any contractors, we may consider hiring them after a few months. Please confirm whether the candidate is comfortable with a contract-to-hire arrangement. If the candidate agrees to contract-to-hire, this clause will be mentioned in the Statement of Work (SOW), and in such a case, the non-solicitation clause will not be applicable.

Key Responsibilities:

• Design, develop, and maintain robust, secure, and scalable SQL database architectures in Azure.
• Led the migration of on-premise databases to Azure, including performance optimization and seamless data transfer.
• Collaborate with development, DevOps, and cloud teams to integrate SQL databases with other cloud services, applications, and systems.
• Implemented and managed SQL Server databases (including SQL Server 2019/2022) on Azure SQL Database and Azure SQL Managed Instances.
• Optimize query performance and troubleshoot database issues, implementing best practices for performance tuning and high availability.
• Define and implement data security policies and strategies, including encryption, access controls, and disaster recovery plans in Azure environments.
• Perform regular database backups, restore, and manage disaster recovery plans in Azure to ensure data integrity and business continuity.
• Provide expert guidance on SQL architecture, including scalability, data modeling, and cloud cost management strategies.
• Conduct code reviews, database design reviews, and mentoring for junior team members.
• Stay current with evolving Azure technologies and best practices to ensure innovative and efficient solutions.

Required Qualifications:

• Bachelor's degree in Computer Science, Information Technology, or related field (or equivalent experience).
• 5+ years of experience in SQL database architecture, with at least 2-3 years of hands-on experience in Azure cloud environments.
• Expertise in SQL Server technologies, including SQL Server 2019/2022, T-SQL, database performance tuning, and query optimization.
• Extensive experience with Azure SQL Database, Azure SQL Managed Instances, and Azure services such as Azure Data Factory, Azure Blob Storage, and Azure Data Lake.
• Strong understanding of Azure security features and best practices (e.g., Azure Active Directory, role-based access control, encryption).
• Experience in designing and implementing high-availability and disaster recovery solutions in Azure.
• Familiarity with Infrastructure-as-Code (IaC) and DevOps tools in Azure (e.g., ARM templates, Terraform, Azure DevOps).
• Proven ability to troubleshoot, resolve, and manage SQL database issues in a cloud-based environment.

Preferred Qualifications:

• Microsoft Certified: Azure Solutions Architect Expert or Azure Database Administrator Associate certification.
• Experience with NoSQL databases and hybrid cloud architectures.
• Strong understanding of cloud cost optimization strategies and tools within Azure.
• Familiarity with PowerShell scripting or automation tools for Azure.

Regards,

Akash Kumar

Recruitment Team Lead

[email protected]

Techcenter Technologies Incorporated

3240 East State Street Ext, Hamilton, New Jersey 08619