Oracle Database Administrator

Location: Washington, DC
ANALYTICA is seeking an experienced Oracle Database Administrator to support a federal government agency in Washington, DC.

 Responsibilities:​ 
  • Perform troubleshooting on any database issues (principally Oracle Environment), performance analysis, ensuring database security, evaluating new database trends and technologies, developing and testing Unix shell scripts, PERL scripting and coding required for database administration and associated database tools
  • Work as part of a team to design and develop code, scripts, and data pipelines that leverage structured and unstructured data integrated from multiple sources
  • Look to leverage reusable code modules to solve problems across the team, including Data Preparation and Transformation and Data export and synchronization
  • Design and develop automated test cases that verify solution feasibility and interoperability, to include performance assessments
  • Tuning the Oracle database for optimal performance in large scale / big data environment
  • Act as a Big Data delivery liaison with Infrastructure, security, application developments.
  • Performing upgrades of the database and software to new release levels
  • Starting up and shutting down the database
  • Planning for backup and recovery (Control Files, Redo Logs, Rollback Segments, System Data Files, etc) of database information. Maintaining archived data on tape. Backing up and restoring the database (On-line and Complete)
  • Managing the database's storage structures
  • Managing users and security
  • Managing schema objects, such as tables, indexes, and views
  • Making database backups and performing recovery when necessary
  • Proactively monitoring the database's health and taking preventive or corrective action as required
  • Monitoring and tuning performance of Oracle database
Qualifications and Experience
  • Oracle Database 12 Database Administration
  • Ability to obtain and maintain a DOD Secret clearance
  • Ability to obtain and maintain a DHS EOD Suitability clearance
  • Experienced in database tuning to improve process efficiency
  • Advanced Oracle DBA experience with Oracle 12c, Oracle 11g on Unix/Linux/Solaris platform
  • Experience working with at least 1 of the following: •Oracle Rman, DataPump, Export/Import, Data Guard
  • •Oracle database Security Hardening experience
  • Experience using monitoring tools such as: Oracle Enterprise Manager (OEM), TOAD, Unix/Linux shell scripts for monitoring, Prometheus, Netcool, NetBackup, and Recovery Point
 Additional Desired Skills & Competencies
  • Oracle Certification 
About ANALYTICA: Analytica is a leading consulting and information technology solutions provider to public sector organizations supporting health, civilian, and national security missions. Founded in 2009 and headquartered in Washington D.C., the company is an established SBA certified HUBZone and 8(a) small business that has been recognized by Inc. Magazine each of the past three years as one of the 250 fastest-growing companies in the U.S.  Analytica specializes in providing software and systems engineering, information management, analytics & visualization, agile project management, and management consulting services. The company is appraised by the Software Engineering Institute (SEI) at CMMI® Maturity Level 3 and is an ISO 9001:2008 certified provider.
or
this job portal is powered by CATS