SQL Data Architect

3 days ago

Apply Now

Receive Emails with Similar Jobs

Sprezzatura Management Consulting, LLC

WebsiteLinkedInAll Job Openings

11 - 50 employees

Founded 2009

🏛️ Government

Description

• manage and maintain Microsoft SQL Server databases and related systems. • drive the roadmap and maturity of the backend of a data analytics data warehouse and reporting project. • Oversee the Database Design and Development of MS SQL Server databases (2019+). • Develop schemas, procedures, functions, and jobs to support application databases and data warehouse databases. • Utilize cloud platforms (Azure, AWS) to set up and manage databases. • Perform cloud migrations from private cloud to public cloud and set up production services. • Facilitate continuous integration and deployment (CI/CD). • Ensure the security of cloud-based database systems, implement IAM policies, and utilize monitoring tools. • Collaborate with application teams to define cloud architecture and design plans. • Provide L3 and L4 support for application production issues. • Use database performance monitoring tools and evaluate reporting health and ETL performance. • Provide code review and mentorship in writing efficient and scalable code. • Work closely with the IT security team to align database security measures.

Requirements

• Bachelor's degree in computer science, Information Technology, or a related field. • 8+ years of experience in MS SQL including 4 years in BI Analytics (Data warehousing, Data science). • 2+ years of experience as a Data Architect including experience on cloud platforms (Azure, AWS). • Extensive knowledge of cloud services, DevOps practices, and CI/CD pipelines. • Extensive knowledge of ETL services such as SQL Service Integration Services, BCP, SQLCMD, SSDT, Azure Data Factory, Azure SQL database Export/Import. • Proficiency in SQL Server versions 2019+ • Familiarity with the Software Development Lifecycle (SDLC) methodologies, including Agile/Scrum and Waterfall. • Experience with cloud security measures and IAM policies. • Knowledge of scripting/coding languages such as PowerShell, C#, Python, and Shell scripting (primarily for use in ETL and SSIS) • Previous involvement in cloud migration projects is a plus. • Familiarity with web-based technologies (.NET, ASP.NET, JavaScript, CSS) and service-oriented architecture. • Familiarity with SharePoint Online framework (Lists, Export/Imports) • Excellent troubleshooting and problem-solving skills, with a keen eye for detail. • Effective communication and interpersonal skills to collaborate effectively with cross-functional teams and clients. • IT security certifications (e.g., CISSP, CISM) will be an advantage. • Skills Considered a Plus: Databases and stores such as Azure SQL, MongoDB. • Other RDBMS such as Oracle, MySQL, MariaDB, Postgres. • Databricks, Azure Data Pipelines Azure DevOps SharePoint MS Power Platform

Benefits

• healthcare • 401K • vacation • paid sick leave