Database Engineer (Secret Clearance Required)

As a Database Engineer at Solerity, your primary responsibilities include leading the design and development of software applications tailored to meet user needs, managing application developers, executing SQL tuning, and ensuring efficient database performance. You will also design and implement PL/SQL codes, managing testing and maintenance of database functionalities to ensure scalability.

To be considered for the Database Engineer position at Solerity, applicants should have a minimum of a Bachelor's degree in IT-related fields, combined with at least 10 years of technical experience in IT or IT-related programs that support DoD/Federal Agencies. A Master’s degree with 7 years of experience is also acceptable. Additionally, candidates should possess a DoD Secret clearance.

Database Engineers at Solerity primarily work with Oracle PL/SQL, SQL Server, MySQL, Hadoop, Spark, and Kafka. Familiarity with Informatica PowerCenter and experience relevant to USTRANSCOM IT Systems is also highly desired.

At Solerity, Database Engineers work in a supportive and collaborative environment in O'Fallon, Illinois, specifically at Scott AFB. The role includes a flexible work schedule, allowing for onsite, hybrid, or remote work arrangements, which helps maintain a balance between professional and personal life.

Employees at Solerity enjoy a comprehensive benefits package that includes medical, dental, and vision coverage, flexible spending accounts, a 401(k) plan with company contributions, generous paid time off, tuition assistance, and even pet insurance—all aimed at supporting a healthy work-life balance.

When answering this question, it's crucial to highlight your specific experience using PL/SQL, detailing particular projects where you designed, implemented, or optimized code. Emphasize how this experience prepares you for the demands of the Database Engineer role at Solerity.

In your response, outline your methodology for SQL tuning, including the tools you use for monitoring performance and how you identify bottlenecks. Discuss your experience in optimizing queries for both speed and efficiency, particularly in complex databases.

Discuss your familiarity with best practices surrounding data integrity, such as constraints and triggers. Also, talk about security measures you've implemented in previous roles to protect sensitive information, particularly in environments similar to those managed by USTRANSCOM.

Highlight any previous leadership roles, discussing how you guide and support your team. Explain your approach to mentoring developers in coding best practices, project management, and achieving performance goals.

Share specific examples of data models you've created or worked on, emphasizing your understanding of data relationships and the importance of accurate data architecture for project success. Mention tools you have used for data modeling as well.

This is your opportunity to show problem-solving skills. Choose a specific challenge relating to database design or engineering and explain the steps taken to resolve it, showcasing your analytical skills and perseverance.

Discuss your hands-on experience with various database management systems, focusing on how you adapted to different environments and the unique challenges each posed. Highlight relevant projects where applicable.

Explain your strategies for professional development—whether it be through industry conferences, certifications, online courses, or networking with peers. This shows your commitment to continuous learning in a fast-evolving field.

Reflect on what excites you about the work Solerity does, particularly regarding the support for federal agencies. Tie this back to your professional values and how they align with the mission of enhancing logistics systems for the military.

Share techniques that help you manage stress and ensure productivity, such as planning, prioritization, and effective communication. Discuss your experience in meeting deadlines without compromising quality, which is particularly relevant for the dynamic projects at Solerity.