Data base Administrator

Cloud Analytics Technologies, LLC; Lansing (MI); On-site; USD 120,000 - 160,000; Full time

Job summary

Cloud Analytics Technologies, LLC in Lansing, MI seeks a seasoned Database Engineer to lead cloud data warehousing initiatives. You will architect, migrate, and optimize Azure-based data solutions, adhering to governance standards.

You will own ETL pipelines, data modeling, and SQL performance tuning, delivering cloud-ready data assets. Proficiency in T-SQL, PowerShell, and Azure DevOps is essential for continuous, Scrum-driven releases.

Qualifications

• 12+ years of hands-on database administration and enterprise data management required.
• Deep expertise in Azure Database Services, SQL data modeling/structure, and ETL development.
• 8–10 years of T-SQL proficiency required.
• 6–8 years of ETL development experience.
• 5 years of PowerShell scripting experience.
• 5 years in Azure DevOps and Scrum frameworks.

Responsibilities

• Cloud & Data Warehouse Engineering: SME for the SLDS data warehouse; architect, migrate, and maintain Azure Database Services while aligning with CEDS standards.
• ETL Pipeline Development & Data Modeling: Design, build, and optimize complex ETL pipelines; migrate legacy on-prem ETLs to cloud.
• Database Administration & Performance Tuning: Data modeling, DDL/DCL, indexing, performance tuning, recovery across multiple environments.
• Infrastructure & Security Governance: Upgrade database servers, DR monitoring, enforce security controls and architecture frameworks.
• DevOps & Agile Delivery: Use Azure DevOps, PowerShell, and Scrum to coordinate releases with developers and stakeholders.

Skills

Azure Database Services

SQL Data Modeling/Structure

Extensive ETL Development

T-SQL

PowerShell Scripting

Azure DevOps

Tools

Azure DevOps

PowerShell

SQL Server

Job description

US Citizen, Green Card, H-1B, OPT-EAD, CPT, Other

Work Authorization:US Citizen, Green Card, OPT-EAD, CPT, H-1B, H4-EAD, Other

Key Responsibilities:

• Cloud & Data Warehouse Engineering: Serve as SME for the SLDS data warehouse; architect, migrate, and maintain Azure Database Services while aligning with CEDS standards.
• ETL Pipeline Development & Data Modeling: Design, build, and troubleshoot complex data extraction, transformation, and loading (ETL) pipelines; transition legacy on-premise ETLs to cloud infrastructure.
• Database Administration & Performance Tuning: Perform physical and logical data modeling, DDL/DCL object creation, index/memory distribution monitoring, performance tuning, and recovery procedures across Dev, QA, Pre-Release, and Production environments.
• Infrastructure & Security Governance: Upgrade database server infrastructure, monitor agency disaster recovery systems, implement security access controls, and enforce architectural frameworks.
• DevOps & Agile Delivery: Utilize Azure DevOps, PowerShell scripting, and Scrum practices to coordinate database releases with application developers and business stakeholders.

Required Qualifications & Experience:

• Overall Industry Experience (12+ Years Required): Minimum 12 years of hands-on experience in database administration and enterprise data management.
• Core Technical Specialties (At least 3–5 Years Required): Deep technical expertise in Azure Database Services, SQL Data Modeling/Structure, and Extensive ETL Development.
• T-SQL Proficiency (8–10 Years Required): Advanced T-SQL writing, stored procedure development, query optimization, and DDL/DCL scripting.
• ETL Development (6–8 Years Required): Extensive track record building, testing, and optimizing complex ETL processes.
• PowerShell Scripting (5 Years Required): Hands-on experience automating database administrative tasks using PowerShell.
• Azure DevOps & Scrum (5 Years Required): Proven experience delivering database solutions within Azure DevOps and Scrum agile frameworks.

We are an equal opportunity employer. All aspects of employment including the decision to hire, promote, discipline, or discharge, will be based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, national origin, citizenship/ immigration status, veteran status, or any other status protected under federal, state, or local law.

Some of our Business Ventures - Knowledge Analytics

Do restrictive necessities, your capability for advanced analytics or your business model need custom-made applications and infrastructure configurations? opt for our hosted managed services to urge comprehensive analytics solutions supported industry-leading Cloud Analytics Technologies, LLC code - delivered by the Cloud Analytics Technologies, LLC consultants UN agency understand these solutions best. Through a mix of with-it technology and dedicated service and support, Cloud Analytics Technologies, LLC hosted managed services will facilitate you: