Title: | Senior Oracle DBA |
---|---|
ID: | 1123 |
Location: | Suitland, MD |
Employment Type: | Exempt (salaried) |
Department: | Engineering |
Overview
As a Senior Oracle DBA at IBR, you will be required to meet the criteria below:
- Obtain and maintain a public trust clearance. U.S Citizen and Greencard holders only. No sponsorship.
- This is a full time position. The candidate is required to be onsite in Suitland, MD.
- 10+ years of experience with Bachelors Degree
- Candidate must have experience with Oracle 12c, multi-tenant, and RAC.
Do you want to help IBR build a portfolio of next-generation data collection systems? As a Senior Oracle Database Administrator at IBR, you will support Oracle 11g, 12c multi-tenant and RAC for a key business unit of the Census Bureau. The DBA will be responsible for Tier 3 support and research and development of database related projects including tuning, optimization and troubleshooting multiple environments (20+), stand-alone and pluggable databases, SQL and PL/SQL routines. Candidate must have experience with Oracle 12c multi-tenant and RAC.
Responsibilities
- Supervise performance of database installations, configurations, patching, upgrades and migrations as required
- Analyze performance issues and providing recommendations based on testing results
- Proactively diagnose and resolve problems affecting database
- Maintain database configurations in compliance with release management and change management
- Participate in special projects and performs additional duties as required.
- Support the installation, configuration and operations of WebLogic, OHS, and Oracle Business Intelligence.
Qualifications
- 6+ years of experience with Bachelors Degree
- Must have hands on experience with Oracle 12c multi-tenant and RAC
- Experience with the Commerce Business System and Core Financial System
- Experience as an SME working with Oracle 11g/12c Multi-tenant RAC and Data guard running on a variety of operating systems (Linux (RHEL), Solaris and Windows).
- Experience with WebLogic, OHS, and Oracle Business Intelligence products.
- Experience with Oracle Backup Design Planning.
- Expertise writing complex SQL statements and tuning existing SQL statements for performance and scalability.
- Experience developing SQL*loader Data loading/unloading scripts, stored procedures that process and modify existing data.
- Creating database jobs to execute ad-hoc PL/ SQL as well as procedures used to validate data, modify data, or gather table and index statistics at regular intervals.
- Monitoring and troubleshooting SQL*Loader/PL/SQL Data Loads for Performance, Coding and Infrastructure issues.
- Experience with UNIX shell scripting for automating regular data loading and other database maintenance activities.
- Experience working in Oracle environment on Red Hat Linux platform.
- Critical thinking and problem solving abilities to address complex issues involving data movement and data replication.
- Proven ability to resolve architectural issues in the environment and database infrastructure, as well as develop and maintain an in-depth understanding of the database architecture and the application functionality.
- Strong hands-on Experience with the Oracle RMAN Backup and Restore, Export and Import Data Pump utilities.
- Experience working with Oracle 12c OEM for database monitoring.
- Experience with E2 Travel interface
- Experience in Coding Functions, Stored Procedures, scripts, etc using PL/SQL
- Experience with multiple methodologies of software development, including Scrum, Kanban, and Waterfall
- Experience in Oracle JDeveloper (11g and up)
- Experience with Oracle Forms and Reports Services
- Experience with Oracle Web Application Troubleshooting on Weblogic platform
- Experience with Unix/Linux
- Experience with Subversion
- Experience with financial systems
- Experience/certification for Oracle Identity Management Suite
- Experience/certification for Oracle BPM
- Experience with Oracle HTTP Server
- Experience conducting code reviews
- Experience creating entity relationship diagrams, data models, and other artifacts of technical architecture
About IBR
Imagine Believe Realize, LLC (IBR) is an emerging small business focused on delivering software and systems engineering solutions to government and commercial clients. Our talent acquisition strategy is tailored to career seeking candidates who embrace continuous learning and desire to grow as a professional in the software/systems engineering industry. We strive to enhance our team members ability to thrive in the workplace by creating a proper work/life balance and first-class benefits package that includes:
- Nationwide medical, dental, and vision insurance
- 3 weeks of paid time off
- 10 paid federal holidays
- 401k matching
- Life insurance at no cost to our employees
- Short term disability insurance at no cost to our employees
- Long term disability insurance at no cost to our employees
- Health care flex spending accounts
- Dependent care flex spending accounts
- Training opportunities
- Education assistance opportunities
IBR is an Equal Opportunity and Affirmative Action Employer. It is our policy to offer employment opportunity to all persons without regard to race, color, age, national origin, religion, sex, gender identity/transgender status, veteran status, disability, genetic information, pregnancy, childbirth or related medical conditions, or any other status protected under applicable federal, state, or local law.
Learn more at http://www.teamibr.com