Oracle PL/SQL - Senior Developer Resume Ashburn, VA - Hire IT People

PROFESSIONAL SUMMARY

Over 11+ years of IT experience in system analysis, design, development, testing, implementation and support of business applications using
Oracle 11g/12c, PostgreSQL 10.2 / UNIX technology with strong analytical, technical and logical skills
Extensive work experience in creating data modeling, database objects, Performance Tuning and query optimization
Good experience with SQL Loader, Import/Export of data files, Materialized views in various types of ETL projects
Experience in working on C, C++, Pro*C, Unix / Linux Shell scripting, Perl
Extensive work experiences on Data structures, Pointers, Object Oriented programming concepts
Extensive knowledge in Confidential software s like Confidential Workload Automation GUI V9, Confidential Reporting Facilities 9, Confidential Configuration Manager 9, Remedy
Extensive knowledge Confidential Platform Process Manager tools

TECHNICAL SKILLS

Languages: - PL/SQL, Pro*C, Shell Script, Perl, C, C++, XML, Visual Basic 6.0.

Database: - Oracle 11g/9i/8.x, PostgreSQL 10.2

Concepts: - DBMS, Data Structures, Operating Systems, IPC Mechanisms, TCP/IP Networking, Client - Server Architecture, Object-Oriented Programming.

Tools: - SQL developer, SQL Navigator, Toad, golden, SQLPlus, Clearcase, Subversion, MKS Source Integrity, UML, gcc/g++, gdb, SVN, MS Visio, Wireshark, Source Insight, Putty, Reflection, Winmerge, UltraEdit, EditPlus, MobaXterm

OS: - UNIX ( HP-UX, AIX), RedHat Enterprise Linux, Windows XP/Vista/7, CentOS release 6.3 Linux

PROFESSIONAL EXPERIENCE

Oracle PL/SQL - Senior Developer

Confidential, Ashburn, VA

Responsibilities:

Involved in creating functional and technical specification documents after gathering requirements from business.
Designed data model, Schema design, PL/SQL stored procedures, packages, materialized view
Developed Shell scripts to schedule jobs in Control - M tool
Extensively worked on performance tuning using explain plan of SQL Queries.
Handled projection data delivery to more than 15 clients on daily / weekly basis.
Performed risk mitigations on projection data handling with clients
Provided estimation to clients on quarterly basis with regards to projection data
Lead a team of size 6 (onsite-offshore model)
Receive, research, solve, or escalating technical problems related to internal production systems
Determine root cause and solution for problems encountered by end users
Coach end-users on the capabilities and functionality of available applications
Participate as SME representing the support team on projects

Environment: UNIX - AIX, Linux - CentOS 6.3, Oracle - 11g, PostgreSQL 10.2, Shell Scripts, PL/SQL, Confidential Control M

Technology Associate

Confidential, Chicago, IL

Responsibilities:

Designed and implemented IC+ application using PRO*C, and C.
Utilizing PL/SQL, Created stored procedures for efficient retrieval and manipulation of data for search engine.
Created functions and triggers for efficient manipulation of data. Created Database schema. Created database objects.
Created stored procedures and views.
Created and maintained UNIX batch jobs using shell script.
Prepared Unit test cases, and performed Integration testing with other components.
Involved in PL/SQL code review to fix issues in UNIX batch jobs.

Environment: UNIX - AIX, Oracle - 10g, C, PRO*C, Shell Scripts, PL/SQL

LEAD ENGINEER

Confidential, Chicago, IL

Responsibilities:

Designed and implemented Confidential using C/Shell Scripting / Oracle / Pro*C in Unix OS.
Customer applications are developed in different platforms and the jobs / processes running in these platforms are currently monitored by standalone Job Confidential and custom tools.
Therefore there exists a need to implement the scheduler based on cross platform for Confidential, using which the total turnaround time of the business processes can be reduced.
Actively involved in integration Testing and system testing.
Designed and implemented Confidential using C/C++/Shell Scripting/Oracle/Pro*C on Unix OS. Confidential is a business intelligence tool to project sales data.
The manufacturer expects to see incremental sales from special packs. Confidential methods concepts are applied to existing data in projecting sales information.
Actively involved in integration Testing and system testing.
Analyzed complete architecture of Confidential system and helped in fixing issues at real-time.
An Confidential is an on-line database which has been customized for a client s Customer.
Confidential is a data retrieval tool, most useful for selecting or viewing key pieces of information.
Analyzed complete architecture of Confidential
Analyzed the complete architecture of the Confidential and helped in fixing the bug on real-time.
JSTQC is a Visual Basic tool that operates in the Windows environment and is connected to an Oracle database.
Confidential the user to create multiple client database files. It helps to view the client database for bulk periods.

Environment: UNIX - HP UX, Oracle - 9i, C/C++, PRO*C, Shell Scripts, PL/SQL

We provide IT Staff Augmentation Services!

Oracle Pl/sql - Senior Developer Resume

Ashburn, VA

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship