SUMMARY

• 8 years of increasingly responsible experience in all aspects of Oracle Database developer in fast growing environment.
• My expertise involves in Database development, customization and testing on top of Oracle database and SQL Server.

TECHNICAL SKILLS

Operating Systems: HP, IBM AIX (RS 6000, eSeries P570), Sun Solaris 9, 10 & 11, Red Hat 4, 5, 6, and Windows server 2005/2008 R2/2012

RDBMS: Oracle 9i, 10g R1 and R 2, 11g R1 and R2, MS SQL Server 2008R2/2012

Languages: Oracle SQL, PL/SQL, HTML, XML, .NET, Shell Scripting

Tools: TOAD, ERwin, SQL*Plus, SQL*Loader, EM, Grid Control, SVN, TFS, INNOVisual Studio 2010/12

PROFESSIONAL EXPERIENCE

Confidential, CA

Sr. Oracle Developer

Responsibilities:

• Design and Developing of workflow procedures
• Interacted with client to gather the requirements and implement the same in the project
• Experience in migrations of project’s application interfaces.
• Responsible for handling the Billing application and related Change requests.
• Responsible in implementing JSP pages for project specific, team member’s assigned workflow details and for proper monitoring of tasks assigned.
• Implemented PL and SQL queries, triggers and Stored Procedures as per the design and development related requirements of the project.
• Has done end to end testing of the applications and Error casual analysis
• Used PL/SQL and SQL*Loader to create ETL packages for flat file loading and error capturing into log tables.
• Involved in testing the application for Oracle 11g to 11g R1 and R2 upgrade.
• Tuning of the SQL queries, which takes long time to process the request using Explain Plan, Hints to reduce the response time.
• Involved in all phases of database development, from needs assessment to QA/QC, design, and support.
• Generated log files for Procedures using UTL File
• Created job scheduling tables
• Designed, developed and maintained UNIX shell scripts to collect and monitor database metrics
• Extensively used spring framework modules like core, IOC, AOP modules throughout the application.
• Involved in retrieving the images from database and converting them into different file formats ( JPEG, BMP) using JavaComm technology
• Involved with OLTP relational databases system analysis, design, implementation and management.
• Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL*Trace, TKPROF, STATSPACK, AWR and ADDM reports
• Analyze SQL statements, reorganize database objects and design indexes to improve response of queries
• Generated the AWR reports with the features like ASH, Wait events, Model statistics and resource intensive SQL statements

Environment: RHEL 4, 5, Windows Server 2008 R2/2012, Oracle 11g R1/R2, TOAD, OEM, Data Pump, Diagnostic and Tuning Advisors, WebLogic Server 11g, Oracle ODI, Java 5&6.

Confidential, PA

PL/SQL Developer

Responsibilities:

• Designed workflows to do the Extract, Transformation and Load of data.
• Actively involved in requirement gathering and review meetings.
• Analyzing the data model to understand the relationships.
• Archive application data from live and retired applications
• Create Optim directories, dB alias and install database clients used by Optim.
• Determining the criteria for archiving and purge of each application.
• Write and modify UNIX shell scripts to manage Oracle environment.
• Performed Data Migration as a part of enterprise data warehouse project.
• Responsible for scheduling Optim extract and load jobs.
• Experience in writing Files using procedures for logging result.
• Recovery procedures are applied for complete and incomplete recoveries depending on the type of failure.
• Involved in modifying various existing packages, Procedures, functions, triggers according to the new business needs.
• Wrote SQL Queries using Joins, Sub Queries and correlated sub Queries to retrieve data from the database.
• Used SQL Loader to upload the information into the database and using FILE packages write data to files.
• Logical and Physical data modeling using ERwin, Dimensional/ OLAP Data Modeling, Relational/ OLTP modeling.
• Used PL/SQL, SQL Loader as part of ETL process to populate the operational data store.
• Performed scheduling Control - m for scheduling jobs.

Environment: Oracle 11g, 10g R1 and R2, Sun Solaris, RHEL 4, Windows 2003 with Active DirectoryOEM, Export/Import, SQL, PL/SQL, SQL*Loader, TOAD, Erwin, STATSPACKCrystal Reports.

Confidential

Sr. Software Engineer

Responsibilities:

• Provided 24X7 supports for all the production and development databases.
• Worked on several shell scripts to maintain the database activities.
• Mentoring the Database Performance using automated scripts.
• Optimization and tuning SQL queries using TRACE FILE, TKPROF, EXPLAIN PLAN.
• Continuous monitoring of database performance during peak and non-peak loads using STATSPACK.
• Responsible for optimizing the queries and application tuning.
• Perform SQL tuning and assist developers with coding PL/SQL.
• Provided support to Application Database Administrators in designing the database.
• Worked on several shell scripts to maintain the database activities.
• Optimization and tuning SQL queries using TRACE FILE, TKPROF, EXPLAIN PLAN.
• Involved in creation of sequences for automatic generation of Product ID.
• Created Database Objects like tables, Views, sequences, Synonyms, Stored Procedures, functions, Packages, Cursors, Ref Cursor and Triggers.
• Automation of data load using shell scripting and SQL*Loader.

Environment: Oracle 10g/9i/8i, RHEL 4, Windows Server 2005/08.

Confidential

Associate Engineer

Responsibilities:

• Written, tested and implemented various UNIX Shell, PL/SQL and SQL scripts to monitor the pulse of the database and system.
• Performed Database Tuning for Oracle 9i servers including reorganization, SGA, kernel, redo log tuning, Rollback tuning.
• Requirement gathering and worked according to the CR.
• Worked under the senior level guidance.Data validation/Reconciliation report generation.
• Code Development as per the client requirements.
• Involved in the development backend code, altered tables to add new columns, Constraints, Sequences and Indexes as per business requirements.
• Perform DML, DDL Operations as per the Business requirement.
• Creating views and prepares the Business Reports.
• Resolved production issues by modifying backend code as and when required.
• Used different joins, sub queries and nested query in SQL query.

Environment: Windows 98/NT/2000, RHEL 3, 4, Oracle 9i/8i, TOAD, Database Tools/Utilities.