Data base Administrator

Artifintech; Lansing (MI); On-site; USD 150,000 - 185,000; Full time

Job summary

Artifintech is seeking a senior database engineer to own cloud data warehousing, ETL development, and governance across Dev, QA, and production environments. You will architect Azure Database Services, optimize SQL data models, and automate tasks with PowerShell within an Agile framework.

The role emphasizes deep SQL skills, large-scale data management, and collaboration with stakeholders to deliver reliable, scalable data solutions in the cloud.

Qualifications

• 12+ years of hands-on experience in database administration and enterprise data management.
• Deep expertise in Azure Database Services, SQL data modeling, and extensive ETL development.
• 8+ years of T-SQL development, stored procedures, and query optimization.
• 5 years of PowerShell scripting for automating database tasks.
• 5 years delivering database solutions within Azure DevOps and Scrum agile environments.

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 optimize ETL pipelines; migrate legacy on-premise ETLs to cloud.
• Database Administration & Performance Tuning: model data, create DDL/DCL objects, monitor performance, and implement recovery procedures across environments.
• Infrastructure & Security Governance: upgrade DB server infra, monitor DR systems, enforce access controls and architectural standards.
• DevOps & Agile Delivery: use Azure DevOps and PowerShell; coordinate releases with developers and stakeholders.

Skills

Azure Database Services

SQL Data Modeling

ETL Development

T-SQL Proficiency

PowerShell Scripting

Azure DevOps & Scrum

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.