Oracle Developer with admin exp (mid-level) - REI Systems

Overview

REI Systems’ mission is to deliver innovative technology solutions for Federal Clients. The foundation of our success is an unwavering determination to surpass our client’s expectations. We offer this same commitment to our employees by providing professional development, projects that are impactful and meaningful, and the flexibility to spend time with family and friends. We believe our employees are at their best when they are fulfilled in both their professional careers and their lives outside of work.  Learn more at REIsystems.com.  

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

REI Systems is an Equal Opportunity Employer

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! If you are solution oriented and thrive in a fast paced, agile environment then come work for a company that was named a Washington Post Best Place to Work for 5 out of the last 6 years.

Responsibilities

• 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 

Education: Bachelor's degree in information systems, computer science, or other related field. 

Clearance:  FDA Public Trust clearance must be obtainable

Location: Hybrid - locals to DMV area highly preferred.

EEO Statement: REI Systems is an Equal Opportunity Employer (Minority/Female/Disability/Vet) 

#LI-HYBRID

#LI-TK1