As the Senior ETL Engineer, the individual will oversee the extracting and replicating of organizational data and loading it into a data warehousing environment that they created. In this role, the ETL Engineer has both design and programming abilities as they will also oversee evaluating the system's performance and fixing any issues before it goes live. In addition, Senior ETL Engineer will be well-versed in coding languages and warehouse design and can adequately express ideas. The Senior ETL Engineer will create an environment that is highly efficient and tailored to meet the organization’s data storage requirements.

Responsibilities:

• Proficient management of ETL applications
• Supports, administers, and sustains a clustered-server database platform hosted in an enterprise IT environment
• Manages diverse database systems, ensuring peak performance, robust security, and high availability provide technical support for incident response, service degradations, outages, and other service interruptions
• Investigates hardware and software problems related to the database-hosting infrastructure and perform corrective actions
• Provides technical support for incident response, service degradations, outages, and other service interruptions
• Design, create, automate, and maintain sophisticated programs that extract, convert, and load data.
• Identifying data storage needs. Determine the organization's storage requirements. Select the optimal alternative.
• Data warehouses are created by ETL Engineers based on the needs of an organization.
• Creating dependable data pipelines to connect systems and transport data from one format to another.
• When the data warehouse is finished, the ETL Engineer extracts and sends the data to the new system.
• Quality Control. After the warehouse is operational, the ETL Engineer conduct tests to ensure stability.
• Debugging. ETL Engineers resolve any warehousing system issues. Collaborate closely with application development teams to design and optimize database schemas.
• Offer expertise in writing, tuning, and troubleshooting complex SQL queries, stored procedures, and ETL processes.
• Execute and oversee data migration initiatives when required.
• Develop and execute data migration strategies when necessary.
• Develop and maintain advanced automation scripts for streamlined database provisioning and management.
• Enhance monitoring and alerting systems to proactively identify and resolve database issues.
• Efficiently manage cloud resources and optimize cost-effectiveness
• Maintains comprehensive documentation detailing database configurations, procedures, and best practices
• Regularly generates performance and usage reports to support informed decision-making
• Drives problem resolution and root cause analysis across the technology stack
• Participates in the resolution of database availability, capacity, and performance issues
• Contributes to ongoing improvement of internal processes and ETL tools
• Participates in infrastructure and organizational initiatives across multiple IT disciplines
• Sustains fleet of physical and virtual etl-hosting servers running a mix of operating systems (Open Systems and Windows/Linux Systems) in multiple network environments
• Performs daily operations, onsite support, and on-call support for all aspects of ETL software
• Works with original equipment manufacturers and/or third-party vendors to resolve performance degradations and outages
• Supports and participates in projects relating to the move of systems and services to modernized hosting environments and Cloud capabilities; provides expert advice on configuring database systems to meet the environment and boundary requirements, and customize services to meet new performance goals
• Performs other tasks as required by Vencedor and the Government contracting office

Required Qualifications/Education and Experience:

• BA/BS Degree
• Must possess and maintain Secret clearance
• Must possess a CompTIA Security+ certification
• Minimum 3 - 5 years of experience with designing, building, and managing databases
• Proficiency in managing a diverse range of ETL applications
• Ability to translate customer requirements into database structure
• Strong grasp of advanced database security practices
• Possession of excellent oral and written communication skills
• Mastery of scripting languages (e.g., PowerShell, Python) for automation
• Experience with creating and formulating workflows

OSC Edge delivers a total rewards package that we know will attract, engage and retain top talent. Key elements of our package include a competitive base pay and a comprehensive benefits package:

We offer eligible employees with an opportunity to enroll in a variety of benefits offerings. Here are just some of our benefits for our US based positions:

• Medical/ Dental/ Vision
• Life insurance and AD&D
• Flexible Spending
• Accident, Critical Illness and Hospital Indemnity coverage
• 401(k) and ROTH retirement options and company match
• Pet Insurance
• Identify Theft and Fraud Protection coverage

About OSC Edge:

Founded in 2008, what started as a small business has grown into a diverse and innovative global team owned by Cook Inlet Region, Inc. an Alaska Native Regional Corporation. As a US Federal contractor, we are a dedicated IT Service Provider supporting the Departments of the Army, Navy, Air Force, DoD Educational Institutions, and large corporate entities. Our expertise is in Cloud Computing, Cyber Security, Compliance Management, Enterprise Architecture, IT Support, and CSfC. If you are passionate about making a difference and thrive in a dynamic and collaborative environment, we invite you to apply to join our team.

Equal Opportunity Employer/Veterans/Disabled