Senior Database Administrator (DOL- GPMS)
Horizon Industriesabout 3 hours ago
Remote, WorldwideSenior / Staff+
H1B Sponsor
Responsibilities
- Lead the analysis, design, implementation, and testing of database applications and reporting solutions.
- Develop and maintain process-based reporting solutions using BPMS technologies.
- Create and implement technical process models, interactive reports, and data simulations.
- Review and verify application programming to ensure compliance with industry standards and best practices.
- Collaborate with end users and DOL Subject Matter Experts to gather requirements and validate functionality.
- Design, develop, and maintain enterprise business reports and BI solutions.
- Support planning and execution of data migration activities.
- Develop ETL processes and data transfer methodologies for enterprise systems.
- Perform SQL programming, database normalization, performance tuning, and system optimization.
- Design and implement solution architectures for large, complex, and interrelated IT systems.
- Manage secure data transfer mechanisms including SFTP, DB Connect calls, VPN tunnels, and database web services.
- Configure and support ODI tools, firewall rules, port specifications, and data transfer protocols.
- Implement and support enterprise data repository solutions handling large-scale datasets.
- Support querying and management of datasets ranging from millions of records to multi-terabyte environments.
- Participate in project planning activities following SDLC and Agile methodologies.
Requirements
- Minimum 10 years of hands-on application development and database administration experience.
- Strong experience with ETL data transfer methodologies and enterprise reporting structures.
- Proven expertise with Oracle Data Integrator (ODI), including architecture, models, patterns, and solution development.
- Minimum 10 years of experience working with Oracle back-end databases, including Oracle 19c or higher.
- Strong knowledge of SQL programming, ETL tools, database design, normalization, and performance tuning.
- Experience with system integration and enterprise solution architecture.
- Hands-on experience with secure file transfer protocols, DB Connect calls, VPN tunnels, and database web services.
- Experience configuring firewall rules, ports, and secure data transfer protocols.
- Demonstrated understanding of project management methodologies including SDLC, Agile, and Scrum.
- Experience implementing data repository solutions and supporting large-scale database environments.
- Experience working with datasets containing millions to billions of records and multi-terabyte storage environments.
- Minimum 7 years of experience supporting government Grant Program business processes.
- Bachelor’s degree in Computer Science, Information Systems, Engineering, or a related field.
Benefits
- A comprehensive benefits package including healthcare (medical, dental, vision, and disability).
- A 401(k) program where you are 100% vested from day one with an employer match after 90 days.
- An Educational Assistance program.
- A Student Loan Repayment Program.
- Gym Reimbursement Program.
- Paid Time off.
- A dynamic, passionate, multi-disciplinary team to work with.