Oracle DBA

CoreSys Consulting - Arlington, VA

POSITION SUMMARY:  Responsible for knowledge and proficiency with an enterprise database technology (e.g., Relational, SQL database, In-Memory databases, NoSQL databases and new emerging databases). Establishes and maintains security and integrity controls. Formulates and monitors policies, procedures and standards relating to database management. Proposes and implements enhancements that will improve the performance and reliability of the system. Maintains professional and technical knowledge by attending educational workshops; reviewing professional publications; establishing personal networks; benchmarking state-of-the-art practices; and participating in professional societies. Identifies customer database requirements. Defines optimal conceptual, logical and physical data models that address customer requirement and balances performance (e.g., indexes, views, snapshots) and storage (e.g., normalization, de-normalization). Incorporates security, back-up, and disaster recovery into database designs. Establishes database parameters that maximize database performance. Installs, configures, and patches database management systems (DBMS). Writes database documentation, including data standards, procedures and definitions for the data dictionary (metadata). Controls access permissions and privileges. Ensures that storage and archiving procedures are functioning correctly. Conducts capacity planning. Communicates regularly with technical, applications and operational staff to ensure database integrity and security. Clones application environments. Ensures availability of related application technology (e.g., web services, applications, batch processors, job schedulers, etc.). Provides Tier III support for the application technology stack. Applies application, security, and database patches. Migrates new software code and break fixes. Verifies shell/SQL scripts, packages, and stored procedures for system enhancements. Installs and configures third party products that integrates with the underlying application.

RESPONSIBILITIES:

  • Source file acquisition, data loading of various data types (eg. xml, flat files, Oracle dmp, SQL server, etc.), DDL/DML/SQL execution, table and schema creation, user/role security, table maintenance, data migration between data centers, etc.
  • General Oracle database support activities will include: database sizing, cloning, testing, debugging, replication, backups, restores, disaster recovery, and ongoing support to include status checks and critical patch updates.

 

REQUIRED QUALIFICATIONS:

  • BA/BS degree and 7-10 years of related experience
  • Current Secret Clearance required; SSBI preferred
  • Current Security+ Accreditation required
  • 5+ years hands-on experience as an Oracle DBA
  • 3+ years experience working as a DBA in support of PeopleSoft
  • Solid understanding of Oracle database, Exadata, Solaris

 

DESIRED QUALIFICATIONS:

  • Solid experience installing, configuring, upgrading and tuning Oracle 11g/12c on Solaris & Linux
  • Experience implementing Oracle Database Vault
  • Experience implementing Oracle Audit Vault
  • Experience supporting Oracle Golden Gate
  • Experience working in support of PeopleSoft ERP
  • Good working knowledge of SAN vSAN technologies
  • Experience with volatile storage and recovery techniques
  • Experience with ZFS helpful
  • Experience with Oracle Superclusters
  • Experience working in DISA and working with the DISA DECC environment
  • Direct hands-on experience with the DISA DECC SAN technologies and COOP process
  • Experience with DOD and/or GSA database security requirements is a major plus
  • Experience with Oracle Enterprise Manager (OEM) 12c, Oracle Recovery Manager (RMAN) and have Unix shell scripting, SQL Scripting and PL/SQL experience
  • Minimum of 4 years of Oracle Database Administration experience in Solaris and LINUX environments
  • Minimum of 2 years of Oracle SQL or PL/SQL development experience
  • Oracle Database Administrator Certified Professional helpful but not required

Must be a US Citizen and possess a Security Clearance due to Federal Contracting Requirements

 

About Us: CoreSys Consulting is a Veteran Owned Small Business (VOSB) working primarily with the US Government. We hold a CMMI maturity level 3 rating in both Services and Development as well as an ISO 9001:2015 certification. The CoreSys leadership team has over twenty years of project planning, execution, and maintenance of Information Technology (IT) systems. We specialize in Custom Application Development, Enterprise Architecture and Governance, DoD Architectural Framework (DoDAF), Service Oriented Architecture (SOA), CIO Support, Application Transformation and Modernization, J2EE / Open Source Solutions, Data Warehousing, plus much more. Full time employees are eligible to participate immediately in CoreSys Consulting Services’ competitive employee benefits package, which includes medical, dental, vision, disability and life insurance as well as participation in our 401k program with a company match.



Posted On: Thursday, July 11, 2019



Apply to this job
  • Government Contract Requirements
  • *