Senior Oracle DBA - Chantilly, VA, United States - ITC Federal

Description

Overview


POSITION TITLE:
Senior Oracle


DBA GOVERNMENT AGENCY:
Drug Enforcement Administration (DEA)


POSITION INFORMATION:
Full-Time Position; Government contractor supporting


DEA LOCATION:
Chantilly, VA; Telework policy - 3 days in office/2 days remote after initial 30 days onsite


POSITION TIMING:
Position requires candidate to obtain a DEA clearance (in addition to the DoD Secret required); DEA clearance can take 2-4+ weeks to process


BENEFITS:
Health, Dental and Vision, 401(k), Flexible Spending Account (FSA), 11 Paid Federal Holidays, PTO, education reimbursement ITC Federal, LLC, is an information technology and consulting company focused on servicing the needs of the Federal Government
ITC's mission is to apply earned expertise in information technology and information assurance/security to assist this client in achieving its mission
ITC is located in Fairfax, VA and offers outstanding compensation and benefits plan and a challenging and rewarding professional work environment
Senior Oracle DBA provides highly technical expertise and guidance in the design, implementation, operation and maintenance of database management systems (DBMS)
Designs, implements, and maintains complex databases with respect to JCL, access methods, access time, device allocation, validation checks, organization, protection and security, documentation, and statistical methods
Evaluates and recommends available DBMS products after matching requirements with system capabilities
Defines required database administration policies, procedures, standards, and guidelines
Prepares and delivers presentations on DBMS concepts
Responsibilities

• Support Special Operations initiatives through database design, data modelling, and Linux Oracle database development
• Assist in tuning complex data analytical queries
• Monitor database environments to ensure optimum performance
• Provide technical expertise to application development teams
• Collaborate with data architects on the logical models and translate into an optimal physical model that performs efficiently under various load profiles
• Assist with metadata management and resolution of semantic conflicts as result of data integration from disparate data sources
• Assist with decommissioning efforts and architecture and design of the online archive data store
• Maintains security posture of the Linux Oracle platform in accordance DEA control sets and patch management

Qualifications

• 10+ years relevant work experience as Oracle DB Engineer/Developer
• Experience Data Modelling using state of the art tools e.g

ER Studio

• Expertise in Metadata Management
• 7-10 years expertise in large and complex SQL query development, SQL, PL/SQL, and Oracle development tools.
• Good experience in diagnosis, Performance tuning and Oracle Internals, including Oracle 12c in memory feature
• Experience in Data integration and analytics
• Knowledge of OEM Grid Control 12c
• Strong working knowledge of LINUX Red Hat Enterprise (RHEL) and Windows OS
• Bachelor's Degree in Computer Science or related field, preferred or matched experience

Candidate must have a minimum of an ACTIVE Secret security clearance WORKING ENVIRONMENT:

• Prolonged periods of sitting at a desk and working on a computer.
• Standard office environment; ability to lift 25 pounds

ITC Federal is an equal opportunity/affirmative action employer and will not discriminate against any application for employment on the basis of age, race, color, gender, national origin, religion, creed, disability, veteran status, marital status, sexual orientation, genetic information, military status, disability, or sex including pregnancy and childbirth or related medical condition or on any other basis prohibited by law.