Senior Oracle PL SQL Developer Resume New York, NY - Hire IT People

SUMMARY:

7+ Years of experience in software industry with depth knowledge in SDLC
Good knowledge in Oracle, Perl, Unix Shell programming
Strong coding and programming experience in Oracle PL/SQL using cursors, ref cursors, collections and bulk collects
Well - versed in Perl and HTML/JavaScript/CSS based web applications
Ability to develop/maintain applications and write complex Oracle PL/SQL queries
Extensive experience in CGI / DBI/DBD programming in Perl using JavaScript and HTML
Strong hands on experience in Oracle SQL query optimization, stored procedure, performance tuning
Having experience in developing SQL, PL/SQL applications like Cursors, Triggers, Exceptions, Packages, Stored Procedures and Functions.
Strong in writing UNIX shell scripts & knowledge in UNIX commands
Strong development, support and administration experience on Oracle, SQL, and PL/SQL
Experienced in working in financial industry including trading and banking
Strong work ethic, committed to smart work

TECHNICAL SKILLS:

Languages: Python, Perl, PL/SQL, C, C++, HTML, JavaScript

Operating Systems: : UNIX, Windows

Databases: Oracle, MS Access

Tools: DBI/DBD, CRON TAB

Web Servers: Apache, Weblogic, WebSphere

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

Senior Oracle PL SQL Developer

Responsibilities:

Worked on performance tuning of SQL, Oracle PL/SQL and analysis of tables for report generation
Designed and implemented automated chain process using Perl CGI
Debugged and wrote error trap routines in Unix Korn Shell
Developed complex Oracle SQL scripts to generate data content records for automatic content generation
Worked on FACETS Data tables and created audit reports using queries.
Developed Oracle PL/SQL functions, views, Data partitioning, Collections and cursors for changing existing content to new format
Implemented the Agile Scrum process to manage project
Used ETL (Informatica) to load data from source to ODS
Created Database objects like Tables, Views, Stored Procedures, Packages using Oracle 12c Tools like PL/SQL, SQL * Plus.
Used SQL*Loader to convert the data from the CSV to Oracle 12c tables
Developed Perl Scripts to monitor the process schedulers
Used Oracle to manage and store, transactional and configuration data.
Designed custom reports with associated materialized views and PL/SQL procedures to summarize backend Oracle data
Analyzed the mainframe reports for member/eligibility/claims and mapped the fields with FACETS batch jobs and reports
Worked on Performance tuning of SQL, PL/SQL and analyzed tables
Developed Unix Shell scripts and setup Cron jobs for monitoring the database
Designed and implemented Schema for the backend databases using Oracle 12c and PL/SQL
Created and modified SQL*Plus scripts to capture data
Developed database triggers, Packages and stored procedures using Oracle PL/SQL cursors and tables

Environment: Oracle 12c, PL/SQL, SQL, DBI/DBD, Perl, UNIX, KornShell, Crontab

Confidential

Oracle PL SQL Developer

Responsibilities:

Involved in user requirements gathering, analysis, design, coding, testing, implementation and review
Designed and developed Oracle PL/SQL scripts for data import/export.
Wrote Perl scripts for forms, encoding test scripts and text processing
Wrote stored procedures to replicate data in Oracle 11g database
Created interfaces using HTML for web page presentation of data
Uploaded data into Oracle using SQL*Loader
Enhanced the performance of SQL statements, Mappings by identifying bottlenecks and used Informatica
Created flat files with SQL*Plus from Oracle tables in Unix environments
Developed and tested Oracle PL/SQL procedures, functions and triggers and worked on its performance tuning
Created many batch scripts using Unix scripting and scheduled jobs using Crontab
Used SQL*Plus to execute PL/SQL programs, procedures and packages
Developed, tested and optimized Oracle 11g queries and PL/SQL code for the migration of large datasets
Created Unix shell scripts to accommodate various automated processing needs for clients
Developed various simple to complex mappings using transformations such as Aggregator, Expression, Lookup, Filter, Router, Rank, Sequence Generator, Update Strategy using Informatica
Wrote SQL and shell scripts for Performance tuning and monitoring, database backup and recovery on Oracle
Provided technical support on issues arise after deployment to production

Environment: Oracle 11g, PL/SQL, JavaScript, HTML, DBI/DBD, Perl, UNIX, Crontab, SQL

We provide IT Staff Augmentation Services!

Senior Oracle Pl Sql Developer Resume

New York, NY

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship