Oracle DBA with PL/SQL & Snowflake

Diverse Lynx LLC

Jersey City, NJ, United States

6 days ago

Apply on www.careerbuilder.com

Prepare application

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Working hours

Regular working hours

Job source

www.careerbuilder.com

Tech stack

Query Performance Backup Devices Cyber Security Databases Extract Transform Load (ETL) Data Recovery Data Security Cursor (Graphical User Interface Elements) Database Development Database Security Oracle Data Guard Software Debugging

+19 more

Disaster Recovery Memory Management Lynx Oracle Databases Oracle (Applications) Performance Tuning Query Optimization Recovery Manager (RMAN) Server Administration Service Pack Software Engineering SQL Stored Procedures PL-SQL SQL Databases Backup and Restore Scripting Freeform SQL System Availability Database Optimization

Job description

Oracle DBA with strong PL/SQL development skills to manage, maintain, and optimize Oracle database environments while supporting application development and business-critical systems.
The ideal candidate will have expertise in Oracle Database Administration, PL/SQL programming, performance tuning, backup and recovery, database security, and production support.

Database Administration:

Install, configure, upgrade, and maintain Oracle databases.
Monitor database health, performance, and availability.
Manage database users, roles, privileges, and security policies.
Implement backup and recovery strategies using RMAN.
Perform database patching, upgrades, and migrations.
Configure and support Oracle Data Guard for disaster recovery.
Manage tablespaces, storage, partitions, and database objects.
Ensure database compliance, security, and operational standards.

PL/SQL Development:

Design, develop, and maintain PL/SQL packages, procedures, functions, triggers, and cursors.
Develop complex SQL queries and optimize database code.
Support application development teams with database solutions.
Create and maintain stored procedures and ETL processes.
Debug and troubleshoot PL/SQL code and performance issues.
Develop database automation scripts and utilities.

Performance Tuning:

Analyze SQL execution plans and optimize query performance.
Identify and resolve database bottlenecks.
Monitor wait events, memory usage, and resource utilization.
Perform indexing, partitioning, and query optimization.
Use AWR, ADDM, ASH, OEM, and Statspack reports for performance analysis.

Production Support:

Provide 24x7 support for critical database environments.
Troubleshoot production incidents and perform root cause analysis.
Coordinate deployments and database releases.
Support high-availability and disaster recovery environments.

Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination. All applicants will be evaluated solely on the basis of their ability, competence and their proven capability to perform the functions outlined in the corresponding role. We promote and support a diverse workforce across all levels in the company.

Requirements

Analysis Skills, Data Partitioning, Data Recovery, Database Administration, Database Extract Transform and Load (ETL), Database Optimization, Database Programming, Debugging Skills, Disaster Recovery, High Availability, Identify Issues, Information/Data Security (InfoSec), Maintain Compliance, Memory Hardware, OEM (Original Equipment Manufacturer), Oracle, Oracle DBA (Database Administrator), Oracle Database, Oracle PL-SQL, Performance Analysis, Performance Tuning/Optimization, Production Support, Query Optimization, RMAN, Resource Utilization, Root Cause Analysis, SQL (Structured Query Language), Scripting (Scripting Languages), Software Administration, Software Development, Software Patches, Stored Procedures