SUMMARY:

• Overall experience in Project Management and leadership qualities for heading a project from start to finish, along with excellent communication skills.
• Extensively used Microsoft Suite of Products Word, Excel, PowerPoint, Visio and have the ability to multi - task on various tasks simultaneously.
• Over 16+ years of experience in Database Objects development - Tables, Views, Triggers, Stored procedures, Cursors, packages using Oracle 7 thru 11g, PL/SQL, Data Guard, Golden Gate, Sybase, MS SQL Server, MySQL, MS Access, DB2.
• Over 7+ years of experience in Java, Struts, Servlets, JSP, EJB with WebLogic App Server, Jakarta/Apache Projects, Apache FOP, Apache Tomcat, JBoss, XML,XSLT, XSL-FO for PDF, Web Services.
• Extensive knowledge in Requirements gathering, analysis, design, programming, debugging, coding, testing, implementation, Documentation & test scripts.
• Oracle application database configuration, tuning and performance optimization.
• Ongoing database maintenance, security patches, etc.
• Database cloning to refresh test instances from production.
• Experience in preparing Test Plans, Test Cases and Software testing.
• Extensive experience in software analysis, architecture, design and development of databases, client/server, Object oriented and Web Applications.
• Experience with Java J2EE Web applications and other open source technologies on Web Logic, JBoss and Apache Tomcat application servers.
• Good working knowledge in Confidential technologies Linux,PHP, Python, Postgres, Rabbitmq, Redis server, Apache HTTP Server, LAMP etc.

TECHNICAL SKILLS:

Project Management Tools: MS Project, Office, Excel, Visio, PowerPoint

Oracle Technologies: Oracle 11g/10g/9i/8i/7, Oracle RAC Installation on Oracle Enterprise Linux, Created ASM Disk Groups and installed ASMLibs for ASM Instances, Created Partitions (table level, index level), LVM, RMAN Backup and Recovery, DataPump Export/Import, Oracle Grid Control, Oracle Enterprise Manager (OEM), Oracle Advanced Replication, Data Guard, Streams, SQL, SQL PLUS, iSQL PLUS, PL/SQL, SQL*Loader, External Tables for Data Loads, Stored Procedures & Packages, Triggers & Cursors, Pivot tables, RefCursors, Snapshots, Materialized Views, Collections, BULK Collect, PL/SQL Developer Integrated Development Environment, TOAD, PL/SQL Navigator, Database design, Data extraction and data analysis, Oracle Performance Tuning and Optimization, Explain Plans, SQL Optimizer, ADDM, Statspack and AWR Reports

Java Technologies: Java, J2EE, Struts, Spring, Hibernate, WebLogic, JBoss, Apache Tomcat, Apache FOP, JSP, Servlets, EJB, Web Services, XML,XSLT, XSL-FO, JDBC, JNDI, JavaMail, DOM and SAX Parser, MyEclipse, JBuilder, Ant

PROFESSIONAL EXPERIENCE:

Confidential

Sr Database Analyst

Responsibilities:

• Technology involved Oracle 12c,11g, 10g Linux, SUN OS UNIX environments.
• Mentored Team members on Technical and Process Improvements and automation capabilities.
• Wrote reusable scripts for process automation upon management's request.
• Conversion and data loading for moving databases to different environments.
• Database refresh from production to lower environments.
• Worked on existing Golden Gate environments for cross platform replication like Mainframe to Oracle, Sqlserver to Oracle etc.
• Configured Enterprise Manager for setting thresholds and metric alerts and also created and maintained database templates.

Confidential

Associate Manager/Data Architect

Responsibilities:

• Led/Coordinated with multiple application (development, support) teams and multiple Vendors across multiple geographies (Time Zones).
• Technology involved Oracle 11g, 10g Linux, Netezza Sun OS UNIX environment.
• Mentored Team members on Technical and Process Improvements and automation capabilities.
• Developed high level documentation for multiple clients Project transition on behalf of Confidential .
• Proposed many solutions for performance improvement of many SQL's latest SQL performance enhancement tools for application development and production support teams.
• Led an offshore team of 5 to configure Oracle DR solutions, IBM Netezza database upgrade and proposed multiple solutions for performance improvements to clients.
• Implemented DR(Disaster Recovery) solutions for different clients using Oracle Data Guard and Golden Gate.

Confidential

Team Lead

Responsibilities:

• Technology involved Oracle 11g, 10g AIX UNIX environment.
• Migrated data from DB2 into Oracle 11g closer to 5TB within a month using ODI (Oracle Data Integrator).
• Mentored DBA’s in team with new technology for supporting current environments.
• Led a team of 5 DBA’s with the existing team.
• Installed, upgraded, Patch Oracle 11g, 10g on AIX RAC ASM and standalone DB's.
• Worked on Oracle, SQL Server, Sybase, and DB2.
• Created partitions at data level and index level and created separate tablespaces at data level and index levels.
• Managed ongoing Oracle database maintenance install, configure, support and apply patches and upgrades from 10.2.0.1 to 10.2.0, 3 for security related patches and upgrades from 11G Release 1 to 11G Release 2.
• Scheduled cron jobs and OEM jobs for doing automated OS and DB tasks.
• Monitored database performance by using Statspack report and AWR.
• Used Oracle Data Pump for Export/Import of schemas from different DB’s.
• Used TOAD, PL/SQL Developer Tool, SQL Procedures & Packages.
• Optimized stored procedures, Packages, Triggers for faster performance.
• Used EXPLAIN PLAN, AUTOMATED SQL Tuning, etc., to fine tune queries, improve performance & reduce CPU I/O.
• Used SQL Trace and TKPROF for application tracing for Instance, Session and Module levels.
• Managed Data Mapping & Data Model Changes using DDL and DML scripts.
• Used Toad Data Modeler for Data Modeling.
• Used Putty for Unix AIX environment.
• Used CVS, SVN for Version Control.

Confidential

Senior Oracle DBA Consultant

Responsibilities:

• Technology involved - Oracle 10g, 9i Linux UNIX environment.
• Installed, upgraded, patched Oracle 10g, 9i on Oracle Enterprise Linux.
• Created automated scripts for Roll Partitions for high volume transactions.
• Created partitions at data level and index level and created separate tablespaces at data level and index levels.
• Managed ongoing Oracle database maintenance install, configure, support and apply patches and upgrades from 9.2.0.4 to 9.2.0.8 on 9i databases and upgrades from 10.2.0.1 to 10.2.0, 3 for security related patches.
• Scheduled cron jobs and OEM jobs for doing automated OS and DB tasks.
• Monitored database performance by using Statspack report and AWR.
• Used Oracle Data Pump for Export/Import of schemas from different DB’s.
• Used TOAD, PL/SQL Developer Tool, SQL Procedures & Packages.
• Optimized stored procedures, Packages, Triggers for faster performance.
• Used EXPLAIN PLAN, AUTOMATED SQL Tuning, etc., to fine tune queries, improve performance & reduce CPU I/O.
• Used SQL Trace and TKPROF for application tracing for Instance, Session and Module levels.
• Managed Data Mapping & Data Model Changes using DDL and DML scripts.
• Used Toad Data Modeler for Data Modeling.
• Used X-manager for Unix AIX environment.
• Used CVS, SVN for Version Control.

Confidential

Senior Oracle DBA/Developer

Responsibilities:

• Technology involved - Oracle 11g, 10g, 9i UNIX IBM AIX environment.
• Installed Oracle 11g RAC on Oracle Enterprise Linux using Cluster and ASM Installation.
• Created User Groups OSASM and CRS for ASM and Cluster Installations as a part for RAC Installation on Linux.
• Created and used Partitions on high volume transaction tables.
• Created partitions at data level and index level and created separate tablespaces at data level and index levels.
• Installed Oracle Grid Control 10g and Grid Control Agent on Oracle Enterprise Linux to monitor all the DB running on IBM AIX servers and a few db’s on Windows.
• Installed Oracle Database 11g on new instances in Dev and Test and QA db.
• Managed ongoing Oracle database maintenance install, configure, support and apply patches and upgrades. Upgrade Security patches from 10.2.0.1 to 10.2.0, 3 on a some specific databases.
• Scheduled cron jobs and OEM jobs for doing automated OS and DB tasks.
• Monitored database performance by using Statspack report and AWR.
• Used Oracle Data Pump for Export/Import of schemas from different DB’s.
• Used Oracle Advanced Replication, Data Guard, Streams for aiding in Disaster Recovery.
• Used legacy backups and RMAN for Backup and Recovery.
• TOAD, PL/SQL Developer Tool, SQL Procedures & Packages.
• Optimized stored procedures, Packages, Triggers for faster performance.
• Used EXPLAIN PLAN, AUTOMATED SQL Tuning, etc., to fine tune queries, improve performance & reduce CPU I/O.
• Used SQL Trace and TKPROF for application tracing for Instance, Session and Module levels.
• Implemented Oracle Streams based replication and moved from existing Oracle Advanced Replication and Data Guard for the new Oracle BI Database.
• Managed Data Mapping & Data Model Changes using DDL and DML scripts.
• Used Toad Data Modeler for Data Modeling.
• Used stored procedures and packages to process XML data.
• Set standards to developers to use a Controlled Build to Release environment.
• Used X-manager for UNIX AIX environment.
• Used Microsoft Visual Source Safe for Version Control.

Confidential

Senior Java Developer Team Lead

Responsibilities:

• Technology involved - Java, J2EE, and Struts.
• Created Framework objects Search Result Set and Pooled Connections which were used extensively across all Java applications in DOR.
• Used Struts framework extensively as the Controller for all the java applications.
• Created XSL Framework for regular transformation using a reusable component XSLT Servlet with XML, XSL as parameters to transform and display the forms.
• Created Framework for XSL-FO transformations using Apache FOP for transforming XML Data with XSL into on demand PDF.
• Created Web Service for Corporate Tax System for getting the data from IRS used Apache Xerces for parsing XML Documents extensively for building Web Services components.
• Used DOM and SAX parsers in Corporate Web Services using Xerces implementation.
• Used XML Schema for validation for XML Documents.
• Involved in the Full Life Cycle Development of Data Capture System and Property Tax System and Individual Fraud applications.
• Used JNDI lookup for Database Connections and Oracle OCI for securely passing encrypted password for application databases.
• Moved all the applications from Bea WebLogic to JBoss application server.
• Used JavaScript extensively for Client side validation of all Java applications.

Confidential

Senior Oracle DBA/Developer Team Lead

Responsibilities:

• Technology involved - Oracle 9i / 10g.
• TOAD, PL/SQL Developer Tool, SQL Procedures & Packages.
• Managed ongoing Oracle database maintenance.
• Monitored database performance by using Statspack report and AWR.
• Developed stored procedures, Packages, Triggers in Batch processing environments.
• Developed stored procedures and packages to process XML data.
• Moved existing Oracle Advanced Replication to Data Guard.
• Managed Data Mapping & Data Model Changes using DDL and DML scripts.
• Managed performance issues with the database, using OEM.
• Used EXPLAIN plan to fine tune queries, improve performance & reduce CPU I/O.
• Used Oracle Collections/Oracle Internal Tables and BULK COLLECT techniques for faster processing.
• Performed SQL*Tuning on Snapshot refresh package on procedures, Triggers & queries to verify proper use of Indices for reducing the downtime for moving data.
• Performance tuning, and Query optimization.
• Used SQL Access Adviser to monitor and tune Indexes and use SQL Optimizer Hints to use a specific indexes.
• Used SQL Trace and TKPROF for application tracing for Instance, Session and Module levels.
• Used Toad Data Modeler for Data Modeling.
• Implemented Oracle Streams based replication and moved from existing Oracle Advanced Replication for the Individual Tax System Oracle Database.
• Used Materialized Views in place of snapshots.
• Capacity planning.
• Used command line SQL*Loader primarily for the data conversion of Corporate Tax and Property Tax from Legacy to Oracle Database and to load data into Production Tables.
• Used Oracle Cluster verification Utility for checking the Cluster Installation.
• Used DBCA, DBUA for adding new instances and upgrading existing instances.
• Configured RMAN for Backup and Recovery.
• Used ADDM, AWR and statspack reports for DB performance monitoring.
• Responsible for the design/development of the Data Capture and Property Tax Systems and maintenance of the existing Corporate, Withholding databases.
• Responsible for enhancements based on business requirements.
• Rewrote Snapshots with Materialized Views and Materialized View Logs for snapshot replication.
• Implemented Oracle Advanced Queues for CTR download process.

Confidential, State of Missouri

Oracle DBA/ Developer

Confidential, FL

Oracle Developer

Confidential

Oracle Developer