REI Systems' mission is to deliver reliable, innovative technology solutions that advance Federal clients' missions and exceed their expectations. Our technologists and consultants are passionate about solving complex challenges that impact millions of lives. We take a Mindful Modernization approach in delivering our services, including application modernization, grants management, case management systems, government data analytics, and advisory services. This approach, the REI Way, ensures mission impact by aligning our clients' strategic objectives with measurable outcomes through people, processes, and technology.
We offer the same commitment to our employees by providing professional development, meaningful projects, and flexibility to spend time with family and friends. We believe employees are at their best when fulfilled in both their professional careers and their personal lives. Learn more at
Employees voted REI Systems a Washington Post Top Workplace in 2015, 2016, 2018, 2020, 2021, 2022, 2023 and 2024!
Principal Database Engineer
Job Locations: US-VA-Sterling
Job ID: 2024-3264
# of Openings: 1
Category: Developer/Architect/Designer
Overview
The role focuses on managing and optimizing large-scale database systems, potentially across cloud platforms. Key tasks include database performance tuning, migration to the cloud, ensuring security, and supporting critical business applications. Collaboration with development and DevOps teams is essential to meet project goals in industries like healthcare, finance, or government services.
Position Overview:
The Principal Database Engineer is responsible for designing, implementing, and maintaining complex databases, ensuring performance, security, and scalability. Key responsibilities include optimizing queries, leading cloud migrations, developing disaster recovery plans, and ensuring data integrity. Expertise in SQL, NoSQL, and cloud databases is essential.
- Maintain, monitor, and support application-required functionality and validity of back-end DB components and scheduled jobs
- Support continuous performance of Production instances of applications by troubleshooting and solving issues from production tickets
- Work with project leads to design new database tables, objects, and schemas; create backup and recovery processes; and manage the archiving and purging of data
- Support any Data Migration related activities and use cases
- Monitor scheduled jobs, identify inter-dependencies and issues, and troubleshoot and find appropriate fixes, as needed.
- Conceptualize viable technical solutions that meet customer objectives and project requirements within the cost and schedule constraints
- Provide thought leadership for innovative data solutions to address complex business problems
- Work with team leaders and data analysts in resolving complex technical and operational issues
- Work with and through both functional and technical project team members to deliver products in an agile manner
Qualifications
Required Qualifications:
- 10+ years of experience architecting, designing, developing, and managing enterprise-level databases using relational databases like Oracle, MySQL, PL/SQL and SQL Server
- 5+ years of experience with ETL tools like Informatica and Pentaho Kettle
- Experience with CARS metadata, stored procedures, and triggers
- Excellent programming skills using PL/SQL and Linux Shell scripting.
- Strong communication and teamwork abilities
- Experience delivering solutions using Agile delivery practices
- Solid understanding of CI/CD and Agile DevOps pipelines
- Data Architecture and Governance Adherence
- Logical to Physical model conversion in forward engineering
- Suggesting optimum parameters for the database
- Creating and altering DDL scripts for application schema creation
- Installing and configuring application in a multi-schema, multi-database environment
- Database performance tuning in conjunction with distributed application components enhancement
- Supporting and resolving ongoing database and application issues
- Refreshing databases for lower level environment from higher environment.
Educational Qualifications:
BS in Engineering, Computer Science, Information Systems or equivalent
Clearance: Eligible to obtain a public trust clearance.
Location: Hybrid (One day per week or as needed in the REI Sterling Office)
EEO Statement: REI Systems is an Equal Opportunity Employer. In our workplace, we seek, we welcome, and respect diversity in all of its forms.
#J-18808-Ljbffr