Data base Administrator

Valiant Technologies LLC; Lansing (MI); In loco; USD 120.000 - 180.000; Tempo pieno

Descrizione del lavoro

Valiant Technologies LLC is seeking a senior database engineer to own cloud data warehouse architecture and ETL development. You will migrate on‑prem ETLs to Azure, model data, tune performance, and implement security and disaster recovery practices across the lifecycle.

Must have substantial experience with Azure DB Services, T‑SQL, and Azure DevOps within Scrum teams. This role emphasizes automation via PowerShell and collaboration with developers and stakeholders.

Competenze

• 12+ years of hands-on database administration and data management.
• Azure DB Services, SQL data modeling and extensive ETL development expertise.
• 8–10 years of T-SQL proficiency with stored procedures, DDL/DCL scripting.
• 6–8 years of ETL development experience.
• 5 years PowerShell scripting for automating database tasks.
• 5 years Azure DevOps & Scrum experience delivering database solutions.

Mansioni

• Cloud & Data Warehouse Engineering: SME for the SLDS data warehouse; architect and migrate Azure DB services.
• ETL Pipeline Development & Data Modeling: design/build/troubleshoot ETL pipelines; move on-prem to cloud.
• Database Administration & Performance Tuning: modeling, indexing, tuning, recovery across environments.
• Infrastructure & Security Governance: upgrade infrastructure, DR monitoring, access controls, architecture framework.
• DevOps & Agile Delivery: use Azure DevOps, PowerShell, and Scrum to coordinate releases with stakeholders.

Conoscenze

Azure Database Services

SQL Data Modeling/Structure

Extensive ETL Development

T-SQL Proficiency

ETL Development

Azure DevOps & Scrum

Strumenti

Azure DevOps

PowerShell

Descrizione del lavoro

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.