Database Engineer

Overview

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 www.REIsystems.com.

Employees voted REI Systems a Washington Post Top Workplace in 2015, 2016, 2018, 2020, 2021, 2022, 2023 and 2024!

Have you ever wondered how the food you eat is deemed to be safe, or how pharmaceutical companies are inspected to ensure the drugs they produce meet FDA regulations? If so, we have a very large new program with the Food and Drug Administration (FDA) and would love to have you join us! 

Responsibilities

Project Overview:

We are modernizing FDA cloud infrastructure with a focus on procurement, migration, and optimization using AWS. This project aims to improve cloud operations, enhance security, and automate processes for mission-critical applications.

REI is looking for an Appian Consultant to design and implement industry-focused, integrated solutions leveraging the entire Appian Technology Platform of solutions. As an Appian Consultant/Developer, you will be a key leader for the business of consulting as well as the business of our clients. REI’s growth trajectory ensures that Appian Consultant/Developers, will immediately impact customer interaction and team development, working closely with our clients and REI core members. Not only do REI Appian Consultant/Developers become experts at building process applications on the Appian software, they also become business process experts in the various client industries they work.

Position Overview:

Work directly with project stakeholders throughout the entire life-cycle of projects to define, design, and implement business process based solutionsDesign and implement solutions with Appian software and provide demonstrations to clientsindependently interface with client technical teams and business owners as needed during the design and implementationSupervise, mentor and develop junior consultants on application and implementation methodologyOther similar professional duties maybe assigned as needed.

• Provide operational maintenance, support, and upgrades for complex database management systems architected using a microservices framework. 
• Maintain and scale enterprise level databases as a part of technical solution to meet customer objectives and project requirements. 
• Monitor and configure database systems and databases to achieve optimum performance levels; Perform indexing, data partitioning and performance tuning as required. 
• Support complex database software installations, patching and upgrades to operating systems and related database software packages 
• Document backup and recovery procedures, perform backups, automate and monitor logging. 
• Support database data integrity by implementing and managing appropriate solutions of varying complexities.
• Support external audits and conduct audits of databases to ensure compliance with established standards, policies, and configuration guidelines.
• Leverage open-source platforms, tools, databases, front-end frameworks, and middleware. 

Qualifications

• 5 years of experience designing, developing and managing enterprise-level Oracle database versions 12c and 19c.
• 2 years of experience with reference data management, schema segregation/consolidation, database consolidation/segregation, container and pluggable database creation and porting to cloud-based environments, preferably AWS RDS.
• Strong PL/SQL skills using Advanced Collections and Oracle-supplied Built-in Packages.
• Ability to work with functional application DBAs and address the data and processing quality issues and develop solutions.
• Ability to find database structure and configuration level issues at domain and integrity-level constraints, check constraints, and list, range, hybrid and partitioning.
• Exposure to Programming Logic and Techniques in any of the Object-Oriented Languages connecting to read from and write to Oracle Databases.
• Ability to demonstrate the proper techniques used for database backup and restoration, managing database performance and performing typical security lockdown procedures. 
• Extensive experience in ETL, process mapping, and data transformation 
• Experience with improving performance on enterprise applications with large data. 
• Be up to date on the current technology landscape, be technology agnostic, and have a passion for staying current and experimenting with new approaches and tools. 
• Able to communicate effectively with high-level U.S. Government, senior management, internal customers, and external partners.
• Solid understanding of CI/CD pipeline 

Educational Qualifications:

BS in Engineering, Computer Science, Information Systems or equivalent

Certifications: Appian Developer certification or better required within 90 days of hire

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.

#LI-HYBRID

#LI-TK1