Oracle DBA - Onsite - W2 Only

  • Mechanicsburg, PA
  • Posted 6 hours ago | Updated 5 hours ago

Overview

On Site
Depends on Experience
Contract - W2
Contract - 12 Month(s)

Skills

Oracle
Database Administration
Microsoft Azure
Oracle RAC
OLAP
OLTP
PL/SQL
ERwin
Linux
Microsoft SQL Server
RDBMS
Data Modeling
Database Migration

Job Details

Position: Oracle DBA
Location: Mechanicsburg, PA (day one onsite)
Duration: Long-term
Job description:
Required Skills

  • 7+ years of experience in Relational Database Management System (RDBMS) and OLTP/OLAP environments.

  • 5+ years of experience in Oracle database on Linux Os.

  • 5+ years of experience in Oracle 19c or above version databases

  • 5+ years of experience in SQL, PL/SQL code review, and performance tuning

  • 3+ years of experience in Oracle RAC, Multi-tenant database architectures.

  • 3+ years of experience in Database health monitoring and tweaking as required

  • 2+ years of experience in Data Modeling (Erwin), designing and developing ERD for LDM, PDM

  • 2+ years of experience in Azure Cloud architecture

  • Extensive experience in setting up, configuring, and maintaining Database security controls like TDE, Data Masking, and Data Redaction.

  • Extensive experience in process improvement identification, automation.

  • Experience in Oracle database upgrade and database migration from multiple platforms and versions.

  • Responsibilities include working with the Development team and Client DBAs for DR setup, rehearsal, and validation support.

  • Experience in defining and following the standardization process.

  • Experience working as a Developer or Jr. DBA with a large group of application architects and developers.

  • Experience in working with the Client technical team for database-related issues triage and collaborating with Oracle support by creating a ticket, following up.

  • Knowledge of named PL/SQL objects like stored procedures, packages, functions, and database triggers

  • Good understanding and hands-on experience with Oracle utilities and tools

  • Hands-on experience in shell scripting

  • Strong communication skills, both written and oral"


Preferred Skills

  • Good understanding of other leading RDBMS like SQL Server, PostgreSQL

  • Good knowledge of OLTP, System Life Cycle Methodologies (SLDC) in Database Driven Application Development.

  • Excellent verbal and written communication skills

  • Proficient in gathering requirements and developing project plans

  • Demonstrated technical writing abilities

  • Ability to work independently once direction is provided

  • Ability to monitor progress and be involved with multiple concurrent initiatives."


Responsibilities:

  • Supporting Oracle database custom application development, deployment, and implementation support of RDBMS. Resource should have extensive experience in Development support administration for custom applications. This is not a core/infra DBA role, but will have a partial support requirement.


Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.