SUMMARY

• Over 8 years of experience in analysis, design, development, testing and implementation of application software as OraclePL/SQL developer.
• Experienced as Oracle DBA in production environments, Oracle performance tuning, SQL tuning and Real Application Clusters (RAC), specializing in tuning and monitoring for high availability
• Extensive performance tuning experience, specializing in instance tuning, Oracle RAC tuning and SQL Optimization.
• 8+yrs of experience in developingUNIXshells scripts in Korn (.KSH) shell for Input file logic/requirement validations, calling SQL files and SQL*Loader part. Used/modifiedUnixscripts and commands for fixing the issues as part of production support and maintenance.
• Experience in Design and Implementation of Stored Procedures, Functions, Packages, Triggers, Tables, Indexes, Constraints, Materialized Views and others in Oracle 12c/11g/10g /9i database.
• Proficient in working and conceptual knowledge of Oracle Reports and Forms using Oracle Reports10g/9i/6i, Forms11g/10g/9i/6i, BI Publisher.
• Experience with Oracle Supplied Packages such as DBMS SQL, DBMS JOB, UTL FILE and Partitioned large Tables using range partition technique.
• Expertise in loading data from flat files to the Database Tables usingSQL*Loader, External Tables, UTL Utilities.
• Proficient in the Data Manipulation using SQL for the retrieval of data from the Relational Database (inner joins, outer join, group by, order by, cursors etc).
• Proficient in writing and tuning Complex SQLstatements, complex joins co - related sub-queries and SQLstatements with Analytical functions (Rank, Lead, Lag, Connect by level etc).
• Experience in writing dynamic SQLStatements using EXECUTE IMMEDIATE and DBMS SQL.
• Extensively worked with Arrays, Records, Dynamic SQL and Exception Handling.
• Experienced in developing the UNIX Shell Scripts and PERL Scripts to execute the scripts and manipulate files and directory.
• Worked on automating data loading, extraction, reports generation using UNIX Shell scripting.
• Experience in handling very large data files using Export-Import Utilities and SQL*Loader.
• Responsible for Database Cloning, Patch Application, Unix Shell Scripting, Backup& Recovery and Documentation. Installing and Configuring Oracle11g grid and Data Guard maintenance in large environments.
• Creating database and database objects like table, index, table space, rollback/undo segments and views and analyzed relevant objects to collect statistics to tune the system performance
• Database replication using snapshots, materialized views, import/export and advanced replication methods
• Proficient working in various Operating Systems: Windows, Linux, Unix.
• Experience in Java build tools such asAntandMaven.

TECHNICAL SKILLS

Operating Systems: Windows, UNIX, Linux, AIX

Middleware SOA Integration Products: JCAPS 6.3 & 5.1.3, eGate SRE 5.x, Glassfish ESB, MTS, IBM MQ Series, BMC PATROL WebSphere MQ 4.1, IBM Websphere MQ Explorer 7.1, MQ Visual Edit 1.6.4.1, Introscope

Languages/Integration: Java, XML, Web Services, JAX-WS (SOAP), JAX-RS (REST), XSD, JIBX

Oracle / Tools: Oracle 11gR2, 10g, 9i, SQL Server 2005 and 2008Oracle Products:Oracle10g (Grid Control), OEM (Oracle Enterprise Manager), RMAN, OEM 12C, SQL*Loader, Import and Export(EXPdp/IMPdp), ASM, TKPROF, SRVCTL, SQL* Loader and SQL * Net, Golden Gate.

Web Technologies: J2EE (Servlets, JSP, EJB), JDBC, AJAX, JQuery, JavaScript, AngularJS, HTML, CSS

Testing: Junit, Integration, Regression, UAT and Post-Production Testing

Framework: MVC Architecture, Jakarta Struts 1.1, Spring 3.1, Hibernate 3.1, JSF 2.0, Axis

QualityTools: Win CVS, CMVC, Tortoise SVN 1.8.4, HP Quality Center 10

IDETools: NetBeans 6.9, MEB 2013 (My Eclipse Blue 11.0), WSAD 5.x

Tools: and Packages: Ant 1.7.1, Apache Maven 3.0.5, Log4J, UML, RAD, FTP, MS Visio, BMC Remedy 7.5, Service Now, Requestit, Microsoft Solution Center, JIRA 6.0, Splunk, Atlassian Bamboo 4.3, Altova XML Spy, Access Now

Servers: WebLogic Server 10.3.5, IBM WebSphere Server 8.5 (WAS 8.5), Tomcat Server 7.x, Glassfish V2

PROFESSIONAL EXPERIENCE

Confidential, NY

Sr. Oracle PL/SQL / UNIX Shell Scripting Developer

Responsibilities:

• Worked on building highly available systems using amazon web services.
• Worked on installing, upgrading and managing database clusters on amazon EC2 instances.
• Created reporting system, including data model and dictionary, ETL, and Web reports.
• Extensively worked with troubleshooting of reporting, and ETL issues with distributed teams.
• Created BFF (backup file format) packages for AIX to install third party tools.
• Wrote ksh scripts from system admin tasks.
• Installed & configured KVM guests RHEL5 & RHEL6
• Responsible for the AIX & RHEL Servers 3rd level support for 300+ servers
• Responsible for the development and support custom written UNIX shell scripts for automation.
• Responsible for the effective provisioning, installation/configuration, operation, and maintenance of systems hardware and software and related infrastructure, both physical and virtual (VMware), in a Windows and AIX/Linux/Solaris environment.
• Involved in all phases of software development including gathering requirements, creating specifications, development of database objects, developing code and validating programs.
• Extensively developed PL/SQL Packages, Stored procedures, Triggers, and finely tuned them for performance. Extensively used PLSQL tables and Bulk loader programs for processing data and loading into oracle tables.
• Designed and implemented client-server application using Oracle Forms Builder using Forms Builder 11g
• Involved in designing Complex SQL queries, subqueries and complex joins based on the transformation rules and the STTM document.
• Proactively tuned SQL queries leading to significant improvement in system response time and efficiency.
• Developed UNIX scripts for transmitting files from the secure server to the customer specified server, using various FTP batch processes.
• Performed various activities like creating, debugging and modifying data base objects and User defined functions and finely tuned them for performance.
• Developed and customized existing reports as per client specific requirements using Oracle Reports Builder 10g.
• Developed Unix shell scripts with embedded SQL*Loader calls and PL/SQL statements to extract data from the existing application in the form of flat files and load the extracted data into the new proposed application, as a part of migration.
• UNIX shell scripting was used for scheduling batch jobs. The system was used to run batch processes and reports that utilized PL/SQL and Oracle Reports.
• Developed back-end PL/SQL packages, building UNIX shell scripts for data migration & batch processing.
• Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
• Involved in Database Performance Tuning using Oracle Hints, Explain plan, TKPROF, Partitioning and Indexes.Wrote Korn and awk scripts to analyze security of AIX pSeries boxes.
• Worked on Securing AIX systems and implementing TCP Wrappers and Secure shell.
• Developed PL/SQL triggers and master tables for automatic creation of primary keys.
• Handled JSP compilation and worked on remote applications
• Actively participated in R12 upgrade with 4 member team
• Production Support for SOA and Agile Applications
• Developed Maven Script for the build and dependency process.
• Monitored and scheduled the UNIX scripting jobs.
• Version Controlwas mandated throughSubversion.
• Performed Unit Testing UsingJunit.
• ImplementedLog4Jto trace logs and to track information.
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files
• Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.

Environment: Oracle 10g, 11g, Oracle Enterprise Manager, ASM, AIX, Database Control, TOAD, OEM 11g r2/12c, Data Guard, Siebel eScript / VB script, SQL, PL/SQL, Shell script

Sr. Oracle PL/SQL / UNIX Shell Scripting Developer

Responsibilities:

• Implemented various customized Oracle reports using different techniques in Oracle sql/pl-sql.
• Analyzed and converted application requirements into functional design.
• Regular database activities, backups monitoring, issue resolving through Remedy.
• Created and modified complex functions, stored procedures, packages and Triggers by using Oracle PL/SQL based on the business rules.
• Extensively worked on Schema Migration, Database Program Migration, Data Migration from Sybase to Oracle by using Oracle SQL Developer.
• Performed Tuning by using various tools like EXPLAIN PLAN, DBMS PROFILER, Indexes, Hints etc.
• Worked on Dynamic SQL by using Execute Immediate and DBMS SQL along with Bulk Collect.
• Created Mail Scripts in UNIX to send notification on successful completion or failure of various Interfaces and Jobs, with Customized Subject and Text.
• Designed and developed Oracle Database objects like materialized views, and associated objects like triggers and indexes.
• Involved in data load using PL/SQL and SQL*Loader and cron jobs calling UNIX scripts to download and manipulate files.
• Created trigger events using UNIXand Perl to send email to project managers on high severity issues.
• Developed UNIX scripts for sending mails to the bank and the business team, when the external feeds to the bank are received.
• Writing Unix Shell Scripts to run batch jobs, automated processes, and to automate routine systems administration tasks.
• Worked onSQL*Loaderto load data from flat files obtained from various facilities every day.
• Worked on Table partitioning and Index creation to improve the performance of the query.
• Worked with DBA’s regarding the data checks during migration, loading, creation and management of tables, indexes, table spaces etc.
• DevelopedPL/SQL triggersandmaster tablesfor automatic creation of primary keys.
• Involved in Requirement Gathering, High Level Design, Low Level Design, Development, Unit testing & Integration Testing of Data Migration process using ETL Methodology.
• Experience in using various oracle pl/sql collections VARRAYS,NESTED TABLE, ASSOCIATIVE ARRAYS with INDEX BY VARCHAR2
• Involved in creating various utility scripts to generate log files in UNIX using shell scripts.
• Assisted in migrating IVMs, and VIOS servers on Power-6, and Power-7.
• Migrated LPARs on IVM, and VIOS from local storage to SAN storage including setting up redundancy.
• Contract to implement security, AFS and SSH on AIX 4.3.3
• Performed VIOS OS updates.
• Performed partitioning of tables in data warehouse environment.
• Managed and monitored the data guard, Creation Of core Databases.
• Restored unknown backup to create new Databases for Corporate applications.
• Managed tablespaces and other database objects.
• Support and Maintenance of over 4000 core Databases for CISCO.
• OEM monitoring for CISCO databases.
• Handled PSU and CPU new releases and applied the recommended patches .
• Managed RMAN reports and oracle version mismatch.
• Created unit test scripts withJUnittool for covering code in various modules.
• UsedLog4J to log various events and exception when performing various transactions by the users for debugging purposes.
• Used Subversion/SVNas a version control and source repository system.
• Implemented the Maven framework to ease the development, build and dependencies management thus saving huge development time to the organization.
• Created Oracle objects like tables, types, packages, procedures and functions.
• Provided Production Support by interacting with the testers and fixing bugs.

Environment: Oracle 10g, 11g, Oracle Enterprise Manager, ASM, AIX, Database Control, TOAD, OEM 11g r2/12c, Data Guard, Siebel8. Client Application Configuration, Siebel EIM and EAI (Inbound and Outbound Web Services), eScript& Administration and Workflows

Confidential, Charlotte, NC

Oracle PL/SQL Developer

Responsibilities:

• Gathered requirements and review functional requirements, business flows including application security.
• Involved in full development cycle of planning Analysis, Design, Development, Testing & Implementation.
• Created PL/SQL Stored Procedures, Functions, Triggers and Packages for implementing business logic.
• Extensively used Cursors, User-defined Object types, Records, and Tables in PL/SQL Programming.
• Developed PL/SQL packages using indexes, joins, bulk collects and bulk variables.
• Developed control files for SQL*Loader and PL/SQL programs for loading and validating the data into the Database.
• Experienced in using Application processes and items for code reusability across the application.
• Experienced in building classic reports, interactive reports and dynamic PL/SQL reports to enhance the performance.
• Developed the user interface using the Oracle APEX form types depending on the requirements.
• Formulated SQL queries, functions and processes as per customization requirement for APEX.
• Coded and implemented PL/SQL packages to perform Application Security and batch job scheduling
• Extensive experience with various test efforts like data validation, integrity testing and Unit testing.
• Created and modified SQL*Loader scripts for migrating flat file data into target.
• Performance tuning of queries consuming excessive resources or slow running queries by providing required hints to the query.
• Supported development effort by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using Explain Plan.
• Was responsible for monitoring database, diagnosing errors, building, deploy, maintain and trouble shoot database objects.
• Expert Confidential database tuning, application tuning and performance monitoring. Fine tuning Initialization parameters, I/O, memory and operating system kernel parameters.
• Managed appropriate use of free space within tablespaces, reclaimed space whenever possible. Reorganized tables and indexes within databases when needed.
• Monitored system resource availability and responded to system memory and data issues.

Environment: Oracle 10g, 11g, Oracle Enterprise Manager, ASM, AIX, Database Control, TOAD, OEM 11g r2, Data Guard.

Confidential, Hartford, CT

Oracle PL/SQL / ETL Developer

Responsibilities:

• Involved in Design, Development and Support phases of Software Development Life Cycle (SDLC).
• Ensured high availability and performance(24 hrs production support)
• Ongoing proactive database-level performance tuning and pro-actively monitor database systems to ensure secure services with minimum downtime
• Managed all database objects in a large mission critical system and provided end to end DBA support system and application side.
• Involved in analysis, design and coding of Oracle processes in PL/SQLto built packages.
• Design and Development of data validation, load processes, test cases usingPL/SQL, Stored Procedures, Functions, Triggers, Cursors using Oracle 10g.
• Validated and loaded data into Oracle Database using DB links and external tables from CSV files.
• Developed Ref Cursors to accommodate the business rules.
• CreatedTables, Views, Materialized views, and constraints.
• Developed Forms (like invoicing, Delivery order) and Reports using Oracle Reports and PL/SQL.
• Customized Customer Transaction Analysis Report to change its layout like changing size of the fields, adding some extra field into the display, changing the display of the Report. Writing after Parameters Triggers for the Validation of the data.
• Created various custom reports like Transaction Aging Report, Credit Card Transaction Report, Active Invoice Register Report, Account Balance Consolidation reports and others using Reports Builder 9i.
• Customized Form filed like enabling, disabling form filed and incorporating oracle alerts using form builder 9i.
• Created (or edited existing) Informatica mappings and sessions to accomplish data migrations. Sources were Oracle, SQL Server 2000, DB2 and flat files and load into Datawarehouse.
• Developed ETL scripts using SQL Loader for transferring flat files into database tables.
• Proposed PL/SQL and UNIX Shell Scripts for scheduling the sessions in Informatica.
• Was responsible for development and testing of conversion programs for importing data from text files into Oracle database utilizing SQL *Loader.
• Involved in Database Performance Tuning using Oracle Hints, Explain plan, TKPROF, Partitioning and Indexes.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Developed Grouping report and matrix reports using oracle reports builder 9i.
• Enforced need of regular data purging processes from production, design and development, to deployment.
• Was responsible for two critical online applications database’s performance which has a huge business/revenue impact

Environment: Oracle 10g, Oracle Enterprise Manager, ASM, AIX, Database Control, TOAD, Data Guard.

Confidential, Austin TX

Oracle PL/SQL / ETL Developer

Responsibilities:

• Responsible for database administration for a large and complex database system using Oracle6 and Oracle7, IDMS, IDMS/R and DB2.Responsibilities included performance & tuning, database design, data modeling, database installation, technical support, and investigation of new technologies.
• Installed Oracle DB 10g, 11g RDBMS, RAC on ASM, Applied Oracle critical patch updates, Implemented and Managed Data Guard, Replication, Backup and Recovery support and performance tuning
• Migrated Non-ASM databases to ASM environment for high availability using RCONFIG.
• Worked troubleshooting RAC and implemented ASM features.
• Applied necessary patches during installation and also in up-gradation of databases.
• Resolved the issues in conflicts between the target and source database in Goldengate.
• Migration of databases from using export/import and data pump export/import utilities and performed database refresh activities for business requirement and tuning purposes.
• Having good experience in user management, table space management, session management, undo management issues.
• Used data pump for schema refresh, and RMAN for database refresh and for backing up databases
• Well Experienced in taking cold backup for a very huge 15-Tb Database.
• Experienced in user management, table space management, session management, undo management issues.
• Experienced in managing space issues in the database level for table space and regular file system cleanup Confidential UNIX level.
• Generated AWR, ADDM and ASH reports for database issues

Environment: Oracle 10g, 11g, Oracle Enterprise Manager, EXADATA X2-2, ASM, AIX, Golden Gate, Database Control, TOAD, ASM, AIX, Golden gate, Tivoli