Senior Database Administrator (DOL- GPMS)

Job Description

Job Description

Senior Database Administrator

Location : Remote, USA.

Type - Future Opportunity: Proposal

Who we are:

Horizon Industries Limited (Horizon) is a dynamic IT and Management Consulting firm based in the Washington, DC area. Founded in 1996, Horizon Industries Limited (Horizon) has evolved into a company of highly qualified professionals that provides full-cycle IT Consultant and Management support in both the private and public sectors.

Horizon's culture is based on our core values, and we PRIDE ourselves on a diverse, employee, and family-centric approach.

What are we are looking for:

We are looking for a Senior Database Administrator supporting DOL.

The Senior Database Administrator (DBA) is responsible for leading the analysis, design, implementation, testing, and support of enterprise database and reporting solutions using Business Process Management Suite (BPMS) technologies. This role supports the development of business reports, interactive dashboards, process models, and data integration solutions while ensuring adherence to industry best practices.

The Senior DBA will work closely with end users, stakeholders, and DOL SMEs to ensure reporting functionality and BI applications meet business requirements and operational objectives. The role also includes database administration, ETL development, data migration planning, system integration, performance tuning, and support for large-scale enterprise data environments.

• 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 Department of Labor (DOL) Subject Matter Experts (SMEs) 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.

• 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 Protocol (SFTP)
  • DB Connect calls
  • VPN tunnels
  • Database Web Services
  • ODI configuration and administration
• Experience configuring firewall rules, ports, and secure data transfer protocols.
• Demonstrated understanding of project management methodologies including:
  • SDLC
  • Agile
  • 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.
• In lieu of a bachelor's degree, a minimum of 10 years of relevant professional experience may be considered.

• Strong analytical, problem-solving, and troubleshooting abilities.
• Excellent communication and stakeholder collaboration skills.
• Ability to work independently and manage multiple priorities in complex enterprise environments.
• Experience supporting federal or government IT environments is highly preferred.

Why you will succeed at Horizon:

Horizon works at the forefront of new Appian features and development practices and supports its employees in being trained and certified in the latest and greatest. As we continue to expand and grow the Horizon brand around the globe, we want to ensure that our team members are growing with us, as you are a vital part of our success story. This is a great opportunity for us to invest in our employees by supporting them with the right skills and tools to be successful in their careers.

You will find a career map with a focus on someone who wants to specialize in a technical track or a people management track. We will provide you with a series of personal and professional development opportunities to ensure you have the support and tools necessary to grow and achieve your goals. This includes personal career coaching and mentoring opportunities, among other initiatives.

Why you will love working with us/ Perks:

• 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
• Dynamics, a passionate, multi-disciplinary team of creative minds to work with, and many more.

Horizon is an Equal Employment Opportunity employer, and it is our policy to consider all applicants for employment. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, or national origin.

EOE/Vet/Disabled