Oracle Developer / Oracle DBA Job at Alans Group, Wilmington, NC

dDg4YTFyZE9qR0dwZm03THcya240OEFEdGc9PQ==
  • Alans Group
  • Wilmington, NC

Job Description

Title: Oracle Developer / Oracle DBA

Location: Wilmington, DE (Hybrid)

Duration: Long Term

Technology Requirement:

5+ years of experience as an Oracle Developer with strong DBA background.

Expertise in Oracle PL/SQL development, writing stored procs, packages, triggers.

Strong experience in Oracle Database Administration (12c/19c or higher).

Solid understanding of database architecture, indexing, partitions, and performance tuning techniques.

Hands-on with SQL tuning, AWR reports, StatsPack, Explain Plans, etc.

Experience in commercial loans systems / banking / financial services domain.

Familiarity with development lifecycle tools and deployment methodologies.

Proficiency in Unix/Linux shell scripting is a plus.

Experience working with Oracle Exadata environments.

Prior exposure to Commercial Loans applications or financial platforms.

Experience in Oracle RAC, Data Guard, GoldenGate, or other high-availability technologies.

Duties and Responsibilities.

Design, write, and optimise PL/SQL code, stored procedures, functions, and packages.

Perform database performance tuning, query optimisation, and troubleshooting.

Manage backend workflows including complex SQL queries, data integrations, and batch processes.

Maintain database availability, integrity, backup and recovery procedures.

Collaborate with application development teams on database design, deployment strategies, and data-related requirements.

Support seamless deployment of database components across environments.

Utilise Oracle DBA tools for monitoring, maintenance, and capacity planning.

Conduct root-cause analysis for data issues and performance bottlenecks.

Provide on-call production support as needed.

Job Tags

Similar Jobs

XPO Logistics

Trailer Mechanic Job at XPO Logistics

 ...What youll need to succeed as a Trailer Mechanic at XPO Minimum qualifications: ~1 year of verifiable experience in heavy-duty maintenance and/or time in an entry-level Technician role ~ A valid drivers license ~ Able to perform safety inspections of equipment...