Senior Oracle DBA

Oracle DBA, Oracle database, Oracle ASM, PL/SQL, SQL loader, Exadata
Contract W2, Contract Independent
Depends on Experience

Job Description

Role: Senior Oracle DBA

Location: Suitland MD

Job type: FTE/Permanent

 

Responsibilities:

·       Client is building a strong Engineering team to deliver high quality, modern Information Assurance solutions and seeking a Senior AWS/Azure who will be responsible for integration and implementation of the public cloud infrastructure that will support Census Systems Enterprise Database shared services.

·       The AWS Engineer will adhere to internal team standards and processes as well as documentation for the design, implementation, operations, and accreditation of COTS infrastructure management solutions. You will build and integrate new systems and assist in the migration of applications, COTS, GOTS, and FOSS products to public cloud resources; provide technological recommendations of infrastructure solutions; implement the solutions required to fulfill system and solution level requirements; and support development, integration, test and validation activities to prove system effectiveness, performance, and readiness during critical test events.

·       Operations & Support of database environments deployed in a 12c Multitenant Architecture

·       Implement Upgrades of databases from 11g to 12c Multitenant and 12c to 19c Multitenant

·       Implement Upgrades of Multi-tenant databases from 12c (12.1.0.2) to 12.2.0.2

·       Deploy, upgrade, operate, and managing databases in 12c Multi-tenant deployed on Exadata Engineered Systems

·       Tuning, optimization and troubleshooting multiple environments (20+), stand-alone and pluggable databases, SQL and PL/SQL routines.

·       Operational responsibilities will include supervising performance of database installations, configurations, and migrations as required

·       Designs, builds, and maintains structure (e.g. relational) and unstructured databases within a multiple tier environment

·       Analyzing performance issues, diagnosing/resolving affecting database systems

·       Performs data access analysis design, and archive/recovery design and implementation.

·       Develops strategies for data acquisitions, archive recovery, and implementation of a database

·       Maintaining database configurations in compliance with release management, change management, and office of information security requirements

·       Troubleshoot issues related to Oracle RAC (Node Evictions, Node Reboots)

·       Deploy Oracle ASM and troubleshooting ASM related issues

·       Perform daily activities like production support and continuous database monitoring.

·       Leverage tools like OEM, AWR, ASH, ADDM Expdp/Impdp, SQL Tuning Advisor, SQL Plan Baselines.

·       Apply patches like Critical Patch Updates (CPU), Patch Set Updates (PSU), and One-Off Patches, Interim patches, DST, and Patch sets.

·       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.

·       Applies knowledge and experience with database technologies, development methodologies, and frontend (e.g. COGNOS) and backend programming languages (e.g. SQL). Performs database programming and supports systems design.

·       Deploy Oracle Wallet configurations and Implement TDE security configurations

·       Deploy Hot/Cold Backup and Recovery of databases using RMAN

·       Implement database environments refresh using data pump

·       Implement Oracle Transportable Tablespace (TTS), Oracle database provisioning and cloning techniques and Oracle standby database server deployments, architecture, configuration, implementation, operations, and management

·       Translates business requirements and database administration operational requirements into long-term architecture solutions.

·       Reviews and develops object and data models and the metadata repository to structure the data for better data management and performance.

·       Performs all activities related to the administration of computerized databases.

·       Conducts quality control and auditing of databases in a multiple tier environment to ensure accurate and appropriate use of data.

·       Includes maintenance of database dictionaries, overall monitoring of standards and procedures, file design and storage, and integration of systems through database design.

 

Experience/Skills Required:

·        Bachelor’s in IT related field

  • Hands on experience as an Oracle DBA supporting large production databases in a multi-tiered environment
  • Experience as a Senior Oracle DBA working with Oracle 11g/12c Multi-tenant RAC and Exadata running on a variety of operating systems (Linux (RHEL), Solaris 11).
  • Experience with migration from Oracle 12c to 19c.
  • Must have at least one database certification that is relevant to the scope of this RFP (examples include:  Oracle Application Grid 12.x or higher, Oracle Enterprise Manager 12.x Implementation Specialist or higher, Oracle Identity Manger 12.x Implementation Specialist or higher, Oracle Database 12.x Administrator Professional or higher, Oracle Database 12.x Performance Tuning Expert or higher, Oracle Database 12.x Security Implementation Specialist or higher, Oracle Database SQL Expert)
  • Must have excellent Database Administration Experience with Oracle PLSQL, Oracle Database on 11.x and 12.x.(19.x a bonus) or higher & providing day to day support and maintenance.
  • Experience configuring 12c or higher databases in Linux
  • Must have excellent understanding of Oracle SQL / PL/SQL skills and Performance tuning Deep knowledge of Oracle partitioning, Indexing and Compression Experience developing complex business logic in the Oracle database using PL/SQL.
  • Strong hands-on experience with the Oracle RMAN Backup and Restore, Export and Import Data Pump utilities and partitioning Oracle databases
  • Experience with Oracle database provisioning and cloning techniques, Oracle Standby Database Server deployments and Oracle Backup Design Planning.
  • Expertise with Oracle Database Security - Wallet Configuration & TDE Deployments for 12c Multi-Tenant and Oracle Database Upgrade mechanisms of different versions and on various platforms
  • Strong hands-on experience with Oracle ASM configuration, deployments, and troubleshooting.
  • Monitoring and troubleshooting SQL*Loader/PL/SQL Data Loads for Performance, Coding and Infrastructure issues.
  • Knowledge of spatial data management and analysis as well as development of physical, network, and social graph applications using Oracle Spatial and Graph
  • Experience with operating system: Sun Solaris 10.0 and later; Red Hat Linux 6.x and later
  • Experience writing complex queries and working with database objects like tables, views etc.
  • 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.
  • Critical thinking and problem-solving abilities to address complex issues involving data movement and data replication. Be able to work independently and have good oral and written communication skills.
  • Must have experience Providing 24X7 and on-call troubleshooting and production support

 

·       Must have hands-on experience with Oracle ASM configuration, deployments and troubleshooting

 

Kind regards,

Dinesh Kumar

E-Business International, Inc

Delivery Lead/Recruitment Manager

Ph: 1-

 

 

Dice Id : EBINTL
Position Id : 7101165
Originally Posted : 2 months ago
Have a Job? Post it

Similar Positions

Oracle DBA/ Developer
  • NetSource, Inc.
  • Chantilly, VA, USA
Oracle Developer/ DBA
  • Softworld, Inc.
  • Washington, DC, USA
Oracle DBA
  • ARK Solutions Inc
  • Richmond, VA, USA
Application DBA Senior: Maryland
  • Altius Technologies Inc
  • Maryland City, MD, USA
Oracle Business Intelligence Developer
  • Leading Edge Systems Richmond
  • Washington, DC, USA
Oracle PL/SQL Database Developer
  • nTech Solutions
  • Rockville, MD, USA
Oracle Database Administrator
  • Chandra Technologies, Inc.
  • Richmond, VA, USA
Sr SQL Developer / Database Developer
  • Creative IT Inc
  • Fairfax, VA, USA