Database Administrator (SSIS ETL/Python) - 3632566

Lighthouse Technology Services•Buffalo, NY

3d•Hybrid

About The Position

Lighthouse Technology Services is partnering with our client to fill their Database Administrator (SSIS ETL/Python) position! This is a 6-18 months contract and will be hybrid on site 4 days in Buffalo, NY. This role will be a W2 employee of Lighthouse Technology Services. No C2C or subcontracting arrangements will be considered.

Requirements

8+ years of hands-on RDBMS experience with expertise in database engineering, design, and optimization
Strong proficiency in SSIS for ETL development, with demonstrated ability to build and maintain complex data integration workflows
Solid programming skills in Python for data manipulation, automation, and integration tasks
Mainframe experience with understanding of legacy system data structures and integration patterns
Proven track record leading large-scale RDBMS enhancements, conversions, and production problem resolution across multiple concurrent projects
Mastery-level knowledge of relational database management systems, including architecture, performance tuning, and troubleshooting
Strong project and task management skills with ability to coordinate cross-functional teams and manage competing priorities
Excellent analytical and problem-solving abilities with experience leading issue resolution efforts and providing technical guidance

Responsibilities

Lead the support and optimization of a data warehouse environment comprised of 10-20 databases, managing all data intake processes and ETL workflows using SSIS
Design and implement RDBMS solutions that align with both short and long-term business requirements, serving as the technical architect on complex database projects
Drive database migration initiatives to CoLo and Microsoft Azure environments, with future involvement in Azure Data Factory for ETL processes
Develop and maintain Python scripts for data movement, transformation, and consumption across multiple database platforms
Provide database support for on-premise vendor applications and manage a shared database environment for in-house web and client applications, including provisioning access and data management
Serve as Subject Matter Expert (SME) for RDBMS-related initiatives, providing guidance on vendor/product analysis, functional specifications, and optimal database designs
Mentor and train less experienced database personnel, conducting knowledge transfer sessions and overseeing their development in RDBMS functionality and testing
Collaborate with application owners and technology stakeholders to translate business requirements into detailed functional specifications and efficient database solutions
Manage and oversee execution of complex project plans, ensuring proper task dependencies, issue mitigation, and integrated testing coordination
Maintain internal control standards and ensure compliance with regulatory requirements, audit points, and system maintenance protocols