What are the responsibilities and job description for the Oracle Database Architect position at Procession Systems?
Job Description
OVERVIEW :
We are seeking an Oracle Database Engineer that offers exciting opportunities to support essential services and mission critical activities across the enterprise. Our mission supports the Government Corporate Management Services (CMS) by providing full life cycle support services through the sustainment, modernization, and transformation of the enterprise corporate applications. These applications are used across the government enterprise and are critical to the daily functions of thousands of users across acquisition, business, finance, HR, training, recruitment, program management, security, logistics and more.
GENERAL DUTIES :
Join a team introducing emerging technologies for enterprise-wide impact on daily operations.
Shape and lead new development efforts, starting from the ground up.
Engage with key stakeholders, including in a project with high visibility across the enterprise.
Become one of the select SMEs, taking the lead as an initial architect in a pioneering development effort.
Opportunities expand as the technology you implement is adopted across different directorates.
Work on a team developing a series of applications that are certified, trusted sources of mission-critical data for decision-making across the enterprise.
Design, build, and maintain databases based on simple requirements.
Support UX, middleware and backend database development efforts by collaborating with developers to define and implement technical designs that meet project requirements.
Have frequent interactions with customers to gather input and feedback.
Maintain and optimize Oracle databases to ensure their reliability, security, and performance.
Monitor database health and performance, addressing any issues promptly.
Work in an agile, fast-paced team, creatively solving customer requirement challenges.
Operate with a high degree of independence and initiative, even with limited technical direction.
Required Skills
REQUIRED QUALIFICATIONS :
A bachelor’s degree and five (5) years' experience as a Database Engineer in programs and contracts of similar scope, type and complexity is required. Ten (10) years of experience required In lieu of bachelor’s degree.
Experience designing, building, and maintaining a database from simple requirements
Oracle SQL experience and knowledge in areas such as creating tables, SQL queries using unions, joins (inner / outer), complex queries and views
Familiarity with Oracle Row Level Security
Experience with data ETL
CLEARANCE :
Full Scope Polygraph minimum
Desired Skills
DESIRED QUALIFICATIONS :
Familiarity with AWS RDS
Familiarity with database administrative tasks such as backups, database migrations and cloning and restoring (preferably using AWS RDS)
Knowledge of PL / SQL
Familiarity with SQL Developer session / sql monitoring tools
Experience with the Atlassian Tool Suite
Experience working with Git for configuration management
About Procession Systems
About us
