Senior Database Administrator (DOL- GPMS)

<h1 style="text-align: left;"><strong>                                         Senior Database Administrator  </strong></h1> <p><strong>Location</strong>: Remote, USA. </p> <p><strong>Type - </strong>Future Opportunity: Proposal</p> <p><strong>Who we are:</strong></p> <p>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.</p> <p>Horizon’s culture is based on our core values, and we PRIDE ourselves on a diverse, employee, and family-centric approach.</p> <p><strong>What are we are looking for:</strong></p> <p>We are looking for a Senior Database Administrator supporting DOL. </p> <p> </p> <h2 data-section-id="115i9ww" data-start="33" data-end="52">Position Summary</h2> <p data-start="53" data-end="466">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.</p> <p data-start="468" data-end="840">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.</p> <h2 data-section-id="18w7bso" data-start="842" data-end="865">Key Responsibilities</h2> <ul data-start="866" data-end="2311"> <li data-section-id="1v13st6" data-start="866" data-end="972">Lead the analysis, design, implementation, and testing of database applications and reporting solutions.</li> <li data-section-id="uu0fik" data-start="973" data-end="1054">Develop and maintain process-based reporting solutions using BPMS technologies.</li> <li data-section-id="s2w2to" data-start="1055" data-end="1146">Create and implement technical process models, interactive reports, and data simulations.</li> <li data-section-id="1hwr98s" data-start="1147" data-end="1255">Review and verify application programming to ensure compliance with industry standards and best practices.</li> <li data-section-id="1fjxv7a" data-start="1256" data-end="1395">Collaborate with end users and Department of Labor (DOL) Subject Matter Experts (SMEs) to gather requirements and validate functionality.</li> <li data-section-id="ieyhcz" data-start="1396" data-end="1473">Design, develop, and maintain enterprise business reports and BI solutions.</li> <li data-section-id="1ha998z" data-start="1474" data-end="1536">Support planning and execution of data migration activities.</li> <li data-section-id="sr6rlw" data-start="1537" data-end="1616">Develop ETL processes and data transfer methodologies for enterprise systems.</li> <li data-section-id="v0b5sc" data-start="1617" data-end="1712">Perform SQL programming, database normalization, performance tuning, and system optimization.</li> <li data-section-id="1kb6x1e" data-start="1713" data-end="1807">Design and implement solution architectures for large, complex, and interrelated IT systems.</li> <li data-section-id="g7od7x" data-start="1808" data-end="1922">Manage secure data transfer mechanisms including SFTP, DB Connect calls, VPN tunnels, and database web services.</li> <li data-section-id="1yvf99a" data-start="1923" data-end="2023">Configure and support ODI tools, firewall rules, port specifications, and data transfer protocols.</li> <li data-section-id="6b8hnq" data-start="2024" data-end="2115">Implement and support enterprise data repository solutions handling large-scale datasets.</li> <li data-section-id="fa2ls6" data-start="2116" data-end="2226">Support querying and management of datasets ranging from millions of records to multi-terabyte environments.</li> <li data-section-id="1jwslll" data-start="2227" data-end="2311">Participate in project planning activities following SDLC and Agile methodologies.</li> </ul> <h2 data-section-id="1cpo032" data-start="2313" data-end="2339">Required Qualifications</h2> <ul data-start="2340" data-end="3607"> <li data-section-id="110vvin" data-start="2340" data-end="2434">Minimum 10 years of hands-on application development and database administration experience.</li> <li data-section-id="17e5emq" data-start="2435" data-end="2528">Strong experience with ETL data transfer methodologies and enterprise reporting structures.</li> <li data-section-id="19ittr5" data-start="2529" data-end="2650">Proven expertise with Oracle Data Integrator (ODI), including architecture, models, patterns, and solution development.</li> <li data-section-id="1fegspo" data-start="2651" data-end="2755">Minimum 10 years of experience working with Oracle back-end databases, including Oracle 19c or higher.</li> <li data-section-id="11s9xax" data-start="2756" data-end="2861">Strong knowledge of SQL programming, ETL tools, database design, normalization, and performance tuning.</li> <li data-section-id="1sexe9f" data-start="2862" data-end="2936">Experience with system integration and enterprise solution architecture.</li> <li data-section-id="1sz9nbz" data-start="2937" data-end="3109">Hands-on experience with: <ul data-start="2967" data-end="3109"> <li data-section-id="orcfqs" data-start="2967" data-end="3005">Secure File Transfer Protocol (SFTP)</li> <li data-section-id="bb11y9" data-start="3008" data-end="3026">DB Connect calls</li> <li data-section-id="1m3nyvv" data-start="3029" data-end="3042">VPN tunnels</li> <li data-section-id="1tw8e43" data-start="3045" data-end="3068">Database Web Services</li> <li data-section-id="5bqcv3" data-start="3071" data-end="3109">ODI configuration and administration</li> </ul> </li> <li data-section-id="1gt1eq6" data-start="3110" data-end="3193">Experience configuring firewall rules, ports, and secure data transfer protocols.</li> <li data-section-id="1apm2tg" data-start="3194" data-end="3298">Demonstrated understanding of project management methodologies including: <ul data-start="3272" data-end="3298"> <li data-section-id="1j4cxn4" data-start="3272" data-end="3278">SDLC</li> <li data-section-id="16yuaby" data-start="3281" data-end="3288">Agile</li> <li data-section-id="178myeq" data-start="3291" data-end="3298">Scrum</li> </ul> </li> <li data-section-id="1fqakbk" data-start="3299" data-end="3400">Experience implementing data repository solutions and supporting large-scale database environments.</li> <li data-section-id="1jfgr01" data-start="3401" data-end="3519">Experience working with datasets containing millions to billions of records and multi-terabyte storage environments.</li> <li data-section-id="1id237b" data-start="3520" data-end="3607">Minimum 7 years of experience supporting government Grant Program business processes.</li> </ul> <h2 data-section-id="iq4pcz" data-start="3609" data-end="3634">Education Requirements</h2> <ul data-start="3635" data-end="3840"> <li data-section-id="1q56w4u" data-start="3635" data-end="3729">Bachelor’s degree in Computer Science, Information Systems, Engineering, or a related field.</li> <li data-section-id="26yxt2" data-start="3730" data-end="3840">In lieu of a bachelor’s degree, a minimum of 10 years of relevant professional experience may be considered.</li> </ul> <h2 data-section-id="1bdyt7m" data-start="3842" data-end="3861">Preferred Skills</h2> <ul data-start="3862" data-end="4176" data-is-last-node="" data-is-only-node=""> <li data-section-id="19qmnyi" data-start="3862" data-end="3930">Strong analytical, problem-solving, and troubleshooting abilities.</li> <li data-section-id="1o2m87o" data-start="3931" data-end="3994">Excellent communication and stakeholder collaboration skills.</li> <li data-section-id="1hdcehj" data-start="3995" data-end="4093">Ability to work independently and manage multiple priorities in complex enterprise environments.</li> <li data-section-id="1pglj6l" data-start="4094" data-end="4176" data-is-last-node="">Experience supporting federal or government IT environments is highly preferred.</li> </ul> <p> </p> <p><strong> </strong><strong>Why you will succeed at Horizon:</strong></p> <p>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.  </p> <p>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. </p> <p> </p> <p><strong>Why you will love working with us/ Perks:</strong></p> <ul> <li>A comprehensive benefits package including healthcare (medical, dental, vision, and disability)</li> <li>a 401 (k) program where you are 100% vested from day one with an employer match after 90 days.</li> <li>An Educational Assistance program.</li> <li>a Student Loan Repayment Program</li> <li>Gym Reimbursement Program.</li> <li>Paid Time off</li> <li>Dynamics, a passionate, multi-disciplinary team of creative minds to work with, and many more.</li> </ul> <p> </p> <p>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.  </p> <p> </p> <p><strong>                                                                                                                      EOE/Vet/Disabled</strong></p> <p> </p>

Back to blog

Common Interview Questions And Answers

1. HOW DO YOU PLAN YOUR DAY?

This is what this question poses: When do you focus and start working seriously? What are the hours you work optimally? Are you a night owl? A morning bird? Remote teams can be made up of people working on different shifts and around the world, so you won't necessarily be stuck in the 9-5 schedule if it's not for you...

2. HOW DO YOU USE THE DIFFERENT COMMUNICATION TOOLS IN DIFFERENT SITUATIONS?

When you're working on a remote team, there's no way to chat in the hallway between meetings or catch up on the latest project during an office carpool. Therefore, virtual communication will be absolutely essential to get your work done...

3. WHAT IS "WORKING REMOTE" REALLY FOR YOU?

Many people want to work remotely because of the flexibility it allows. You can work anywhere and at any time of the day...

4. WHAT DO YOU NEED IN YOUR PHYSICAL WORKSPACE TO SUCCEED IN YOUR WORK?

With this question, companies are looking to see what equipment they may need to provide you with and to verify how aware you are of what remote working could mean for you physically and logistically...

5. HOW DO YOU PROCESS INFORMATION?

Several years ago, I was working in a team to plan a big event. My supervisor made us all work as a team before the big day. One of our activities has been to find out how each of us processes information...

6. HOW DO YOU MANAGE THE CALENDAR AND THE PROGRAM? WHICH APPLICATIONS / SYSTEM DO YOU USE?

Or you may receive even more specific questions, such as: What's on your calendar? Do you plan blocks of time to do certain types of work? Do you have an open calendar that everyone can see?...

7. HOW DO YOU ORGANIZE FILES, LINKS, AND TABS ON YOUR COMPUTER?

Just like your schedule, how you track files and other information is very important. After all, everything is digital!...

8. HOW TO PRIORITIZE WORK?

The day I watched Marie Forleo's film separating the important from the urgent, my life changed. Not all remote jobs start fast, but most of them are...

9. HOW DO YOU PREPARE FOR A MEETING AND PREPARE A MEETING? WHAT DO YOU SEE HAPPENING DURING THE MEETING?

Just as communication is essential when working remotely, so is organization. Because you won't have those opportunities in the elevator or a casual conversation in the lunchroom, you should take advantage of the little time you have in a video or phone conference...

10. HOW DO YOU USE TECHNOLOGY ON A DAILY BASIS, IN YOUR WORK AND FOR YOUR PLEASURE?

This is a great question because it shows your comfort level with technology, which is very important for a remote worker because you will be working with technology over time...