Oracle Developer

Wise Skulls; Alpharetta (GA); On-site; USD 90,000 - 120,000; Part time

Job summary

A leading banking firm in Alpharetta, GA, is looking for an Oracle Developer with at least 5 years of experience in Oracle SQL and PL/SQL. The role involves analyzing data needs, troubleshooting database issues, and optimizing query performance. Ideal candidates have a strong background in database design, troubleshooting, and experience with ETL processes. Please send your updated resume to apply.

Qualifications

• Minimum 5+ years of experience in software development using Oracle SQL and PL/SQL.
• Extensive experience in developing Stored Procedures and related database objects.
• Strong analytical and troubleshooting skills.

Responsibilities

• Analyze data needs and design databases to meet requirements.
• Troubleshoot database integrity and performance issues.
• Document processes and procedures.

Skills

Oracle SQL

PL/SQL

Unix

Database performance tuning

Python

ETL process

Troubleshooting

Tools

SQL*Loader

Golden Gate

QLIK replication software

Job description

Overview

Our client is one of the leading banking globally.

Designation: Oracle Developer

Experience: 5+ years

Duties and Responsibilities

• Works with stakeholders to analyze data needs, design or evaluate solutions and develop databases to meet business requirements
• Troubleshoots and resolving database integrity issues, blocking and deadlocking issues, connectivity issues, and security issues
• Troubleshoots Oracle related CPU, Memory, I/O, disk space and other resource contention
• Conducts performance tuning, query optimization, using Performance Monitor, and other related monitoring and troubleshooting tools
• Executes backups, restores, recovery models, and database maintenance tasks.
• Writes and troubleshoots SQL Code and designs (stored procs, functions, tables, views, triggers, indexes, constraints)
• Documentations processes and procedures
• Upgrades database from one SQL version to another SQL version.
• Provides technical support and coordination for core infrastructure components including server, network, storage, and software

Experience and Education Requirements

• Minimum 5+ years of experience in software development using Oracle SQL, PL/SQL and Unix.
• Extensive experience in developing Stored Procedures, Functions, Triggers, Views, Cursors, Packages and Exceptions.
• Knowledge of Python would be an added advantage. Expertise in database performance tuning and Unix programming.
• Experience in data replication within Oracle and Oracle to other DB. Knowledge on Golden Gate and QLIK replication software.
• Good experience in developing programs to import data from various sources into Oracle Database tables using PL/SQL, SQL*Loader.
• Experience with ETL process for Data loading from Oracle to Data Warehouse.
• Having good experience in deployments and production support of developed applications. Also having customers handling experience.
• Strong analytical, diagnostic and troubleshooting skills and ability to work in a dynamic, team-oriented environment.
• Hands-on experience in Oracle database design and modeling and query tuning.

please attach your updated resume while applying. You can share your resume on [e-mail].

Job Details

• Seniority level: Mid-Senior level
• Employment type: Contract
• Job function: Information Technology
• Industries: Staffing and Recruiting

Referrals increase your chances of interviewing at Wise Skulls by 2x

Get notified about new Oracle Developer jobs in Alpharetta, GA.