ORACLE 15 yrs

• Supporting Oracle Application Instance 11.5.8, 11.5.9, and 11.5.10 Patching Oracle applications Using Auto patch
• Responsible for maintaining OLTP ETL Oracle Database environment.
• Worked on Root-Cause-Analysis RCA process SOX compliance.
• Designed plans to achieve high availability, scalability, recoverability of the Database.
• Diverse industry experience including Banking, Finance, HR, Logistics, Health Studies.
• 15 years of experience as an Oracle database and application both in 24x7 Production and application high availability, production, QA, Test and Development Instance environments.
• Managed and provided production support to more than 100 instances of database with size ranging from 10 GB to 35 TB with more than 1200 concurrent users.
• Extensive experience on Automatic Workload Repository and Automatic Database Diagnostic Monitor ADDM , ASM, DBCA, DBUA in Oracle 11g
• Automated monitoring, performance, maintenance of the database by unix scripts shell Perl and also by OEM GRID.
• Worked on different platforms like Linux, Aix, hp-unix, Sun Solaris windows.
• Worked on application like Harvest, Hyperion, Actimize, capstone etc .
• Implemented FLASHBACK technology.
• Proficient in Oracle 11g Architecture, Installation, I/O tuning, Memory Tuning, Performance Tuning, Backups, Recoveries, RMAN backups, Symantec Backup, Optimization, Crash Recovery, Troubleshooting, database security and disaster recovery.
• Experienced in installing and upgrading oracle 11g in AIX, Linux, Hp, Sun and windows.
• Experienced in HACMP, VERITAS Linux RAC-ASM, Data Guard and stand alone database.
• Experience in installing Oracle patches, Migrating and upgrading database across releases.
• Worked extensively in migration and administration of Oracle Database 11gR2 Real Application Cluster RAC on ASM file system and Cluster Management.
• Excellent experience in maintaining and managing ASM file systems.
• Worked on transportable table's spaces, triggers, procedures, functions and packages.
• Setup, design, capacity planning and configure database for every environment from scratch.
• Used design tools like Erwin, VIZIO and ER-studio for database modeling.
• Extensive knowledge in working with the tools like OEM, TOAD, ADDM, Export/ Import, Stats pack, SQL Loader, external table, SQL Analyze, TK-Prof, Explain Plan, AWR.
• Created Partition Table List, Range, and Hash to improve query performance.
• Generated Materialized views to cache data that was frequently needed.
• Worked on RMAN for the backup, used schedulers like Autosys, cron jobs and CA7 jobs.
• Very well versed in Rapid Install, AdPatch, Adadmin and Adctrl utilities for Oracle Applications.
• Installation, Configuration, Troubleshooting of Oracle Applications 11i.
• Cloning of Oracle Applications 11.5.8 Rapid Clone, Ad Clone, Autoconfig Cloning .
• Implementation of Technology Stack Pack, Technology stack configuration e.g. Apache, Form Server, Report Server, Concurrent Manager and Jinitiator for Oracle Applications 11.5.8.

SQL Server 5 yrs

• Worked on creation of database, users, table spaces, tables, views, procedures, triggers, Rules, Defaults, user defined data types and functions.
• Implemented Third Party solution Litespeed for SQL Server back and increased back up and restore performance.
• Excellent understanding of Change Control Management and followed the same in implementing Changes to Production database in previous projects.
• Good Understanding of RAID Technologies.
• Prepared Disaster recovery plans and procedures for SQL Server Databases in Production environment.
• Worked with Popular monitoring tools like NETIQ App manager, SQL Profiler, Idera Diagnostic Manager, Windows Performance and performance counters for Tuning MS SQL Performance hands on experience in Troubleshooting database issues.
• Implemented proactive monitoring scripts for production databases.
• Experience in working with version controlling tools like VSS for managing SQL scripts and changes that are going to production.
• Experience in system tables and stored procedures using T-SQL.
• Hand on experience in writing and debugging Stored Procedures and triggers.
• Experience in Troubleshooting database issues using SQL Server tools like Performance, Profiler, and System stored procedures and IDERA Diagnostic Manager Third party tool .
• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, database consistency checks using DBCC Utilities.
• Implemented log shipping with SQL Server 2000 and 2005.
• Experience in setting up and managing of Replication models like Snapshot and Transactional. .
• Data migration using SSIS services across different RDBMS like Oracle, MS SQL, MS access flat files.
• Designing and documentation of Upgrade/Migration of SQL Server Strategies and plans.
• Design Tool.
• Good Knowledge in Design and document of Logical and Physical data models using Erwin
• databases in clustered and un-clustered environments Windows, 2000, 2008 and 2008R2 .
• Expert in installation and configuration of MS SQL Server 2000/2005/2008/2008R2 servers and
• 5 years of experience with MS SQL Server 2008R2/2008/2005, MS SQL Server 2000, 7.0 in Production, QA, Test, Development Replication Cluster Server Environments.
• Very good experience in Installation, configuration and maintenance of SQL Server.
• Experience in Data Modeling Logical and Physical Design of Databases , Normalization and building Referential Integrity Constraints.
• Very good T-SQL Programming skills. Experience in query optimization performance tuning. Used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands
• Experience in Database backup and disaster recovery procedures.
• Experience in Replication Snapshot, Merge, mirroring and Transactional.
• Has very good experience in complete ETL cycle including data analysis, database design, data mapping and conversion and data load.
• Created complex DTS Packages for Data Migration and Transformation. Experience in data migration from Oracle/Access/Excel Sheets to SQL Server 2005/2000/7.0
• Experience in MS SQL Server upgrades from 7.0 to MS SQL Server 2000 and from 2000 to MS SQL server 2005.
• Worked in OLTP OLAP environment that includes Production 24x7 , QA and development databases in SQL Server.
• Experience in Dimensional Modeling, ER Modeling, Star Schema / Snowflake Schema, FACT and Dimensional tables and Operational Data Store ODS .
• Has Knowledge of Analysis Services Reporting Services, SQL Server Clustering and Log Shipping

DB2 2 yrs

• Support DB2 application databases in a 24x7 Parallel Sysplex Data Sharing environment.
• Installed DB2 clients and servers.
• Use EXPLAIN and DB2 traces to monitor and tune SQL performance.
• Diagnose application software problems implement Disaster Recovery procedures.
• Wrote scripts to extracts and migrate data from oracle to db2 and db2 to oracle.

Golden Gate 5 yrs SharePlex 2 yrs

• Support GG application databases in a 24x7.
• Build the GG from the scratch, participated in the implementation and maintenance of the system.
• Developed jobs parameter files and all the other process for both active - active and active passive architecture.
• Currently working on migration using Golden Gate mirroring and between sqlserver and oracle.
• Currently working on both Active - Active and Active - Passive architecture.

Oracle PL/SQL Skills 8 yrs

• PL/SQL Programming experiences for around 6 years with RDBMS technologies for batch processes, front ends in Forms 6i/Reports 6i Oracle Apps11i.
• Extensive experience developing designing Packages PL/SQL , Procedures, Functions, and Database Triggers. Designed and maintained tables, views, triggers and indexes in both Oracle, Sql Server 2000 data warehousing tools.
• Experience providing 24X7 on-call support to maintain all Databases up and running in Production environment.
• Developing and Tuning SQL, PL/SQL triggers materialized views and stored procedures.
• Created scripts to insert static records and execute them using SQL Plus.
• Developed SQL Loader scripts, merge, bulk load, multiple table load, migrating data.
• Created PL/SQL programs to generate on-line .XML reports.
• Experienced with designing GIS Graphic information System transactional.
• Wrote PL/SQL programs to upload data from one database to another
• Used data migration technology by pl/sql data pump, external, sql loader and also with ETL.
• Involves query writing, batch programming, data fixing, data loading , data analyzing, data modeling etc.
• Worked extensively on writing technical documentation.
• Incorporate the pl/sql with Perl scripts and shell scripts.

Web logic, Web Sphere Skills 3 yrs

• More than 3 years of experience in Web logic, Web Sphere, BEA Tuxedo Servers.
• Installation, deploying maintaining clusters in Web Logic, Web Sphere and Tuxedo environments.
• Application support of Web logic 7.0/8.1/9.2/10.1/11g , Web Sphere 5.x/6.x , Tuxedo 6.5/8.1 applications.
• Deployed applications WAR, JAR, and EAR in stand-alone and clustered environments of Web Logic 7.0/8.1/9.2/10x/11g and Web Sphere 5.x/6.x .
• Configured and administered JDBC connection pools/Data Sources/JMS in Web Logic Servers.
• Installed and configured IBM HTTP, Iplanet SunOne , and Apache Web Server in various environments

Oracle Forms, Java Reports Skills 6 yrs

• Design the front end and reports according the technical sketch.
• Coordinate to accumulate information for development from business and users.
• Worked in migration stating from 4.5 to 10g for both Forms and Reports Discover Reports.
• Generated all types of reports from GL, Balance Sheets etc..
• Thorough knowledge with Java application platform configuration and performance optimization.
• Good understanding on Java scripting and good working experience in JDeveloper.

UNIX Skills 15 yrs

• Developed batch processes for financial reporting applications and modules using Perl and Korn shell scripts on Oracle database, with partitions and sub-partitions.
• Worked extensively in Shell scripting to generate script to upload and download data in database.
• Worked using SQL loader in Unix
• Used procedures, Functions and Packages in Scripts.
• Worked in Perl Scripting.
• Used FTP, Telnet, SSH to connect to various database and operating systems by scripts.
• Used TAR, CPIO for backup.
• Used TOP, VMSTAT for performance check
• Wrote scripts to copy, transfer, modify and write content of files to different locations.
• Wrote scripts and jobs to monitor and create log files.
• Infomatica 3 yrs Abinitio 2 yrs
• Extensively used Ab Initio GDE Ver 1.13.27 and GDE 1.14.31 and EME for ETL processing.
• Created lots of dynamic DMLs and XFRs wherever there is required.
• Excellent in creating the Job Wrapper Scripts for every deployed graph.
• Extraction, Transaction and Loading was done using different Components and different expressions using Ab Initio to create test data.
• Extensively worked with Multi files system and used Partition Components and DePartition components extensively.

Other Technologies Skills 5 yrs

• Worked in various other technologies like PRO C, Infomatica 7.1, Abinitio
• Worked in different ETL technologies to extract or copy or automate the data flow.
• Very strong working experience in Data ware house environment.
• ETL experience in implementation and design
• Strong working experience in MySQL.
• APEX oracle application express
• OBIEE Oracle Business Intelligence Enterprise edition
• Erwin experience in reverse engineering and redesigning the existing database design.
• Data Migration using SQL Loader and EXP/IMP Utility
• Worked full fledged in Crystal Reports.
• Worked full fledged in Discover Reports.
• Good knowledge in Teradata.
• Worked with ER studio
• Worked with Autosys jobs for scheduling the jobs.
• Worked with Streams, Shareplex quest software Toad from replication of database.
• Experienced in working in both a team and individual environments.
• Strong ability to handle multiple projects simultaneously up to completion.
• Analytical and Systematic thinking ability with a goal and solution oriented approach.
• Professional experience

Confidential

Environment: Oracle11g, SQL server2008R2, Unix Linux Solaris , windows, Python, Grid, Toad SQL Developer, GoldenGate.

• Verizon manages a set of applications and databases M2M MC currently in Production, which run on Microsoft Windows and SQL Server 2008 R2. These systems support transactions for 2 million devices currently. Verizon anticipates this system will need to support 10 million devices by the end of 2014. For several reasons, including enterprise capabilities, scalability and performance, Verizon would like to convert this entire SQL Server system to an Oracle 11gR2 11.2.0.4 on Red Hat Linux database system.
• As part of this overall conversion, one of the initial tasks is to convert the current built-in SQL Server replication configurations to Oracle's GoldenGate software for replication.
• The current SQL Server M2M MC environment replicates all tables for 13 databases. The requirement from Verizon is to convert those 13 databases' SQL Server replication to GoldenGate, plus implement GoldenGate replication for 7 databases that currently are not being replicated, for a total of 20 databases with replication. The replication will maintain the existing 4 server 2 in Miami and 2 in Culpepper full-mesh strategy that Verizon has in place now.
• This project requires implementation and set up of GoldenGate in both Sql Server environment in Windows and Oracle Linux environment.

Confidential

Environment 1: Oracle11g, SQL serverR2, Unix Linux Solaris , windows, Reflection, Grid, Toad Oracle, Golden Gate, ER studio, Web Admin in EBiz Infrastructure, Web Logic Administration

• Oracle:- My duty includes maintaining high standards of database performance and support. Support migration, project enhancements, installing new databases, backup RMAN , patching, creating objects and maintain the standards, space managements. Here in this environment we handle RAC, Data Guard, single instance databases. Successfully migrated a 3 TB RAC 11g database from Solaris 5.10 to Linux using RMAN convert. We successfully accomplished version upgrades, new database base build, migration from different environment in my tenure. Installed oracle 12C and agents in around 20 applications and 30 database. Also work in constructing new scripts in both Perl and shell for scheduling jobs. Upgrade 11g databases to 12C.
• WebLogic:- Working in web servers my duty includes creation configuration of new domains, setting up new websites in web servers SunOne 6.1/iPlanet . Web Proxy set up for new applications, static content, re-directs. Working with Stalling and dual direct setups. Installation, configuration and set up of apache servers for various web sites. Tomcat installation and setup on web servers. Web Server Admin console administration. Requesting and installing VeriSign certificates for various servers. Configuration and set up in obj. conf and server.xml files for various applications and URIs. Creation and maintenance of WLS domains. Application server console administration in Web Logic 8/10.x for the following: Deployment of applications, JDBC, JMS Security Realms.
• Golden Gate:- working solitary on installing Golden Gate process for the first time VDH for the ever expanding there requirement. This technology will help them to process the data faster and secure between databases and environment. This technology will work between SqlServer and Oracle too.

Confidential

• Environment 1: Oracle11gR, Unix, Toad Oracle, Golden Gate, ER studio Autosys
• Environment 2: Sql server 2008, Windows, Toad Sql server.
• Web Logic Administration

Confidential

• Oracle:- Working as production DBA for SQL server 2008 and Oracle 11g in AIX/Linux and windows operating system respectively. Along with the supporting production I handled 15 major migrations. 13 of the migration are from oracle 10g to 11g and the other one was from Oracle to SQL server using SQL-server build tools and last one was from oracle to DB2. Among the migration a scratch level build on RAC application called PEGA. In production migration 8 of them where stand along with different sizes varies from 5 terabits to 90 Gig, among the migration the interesting one was migration and build of GOLDEN GATE for a active passive mode system. In my tenure I helped to build and design two application systems from scratch Oracle financials application related to a money laundering . Worked in all part of DBA activities like DDL's, security management, building the environment for developments, performance management, Autosys Cron job creation for scheduling the jobs for automation. Used different tolls like ASM, TKProf, explain plans, AWR reports and Topaz, SIR to monitor the performance of scripts and operating systems. Also responsible for fine tuning the script, writing shell or Perl script in Unix using DBI interface, administrating the Unix jobs, monitoring jobs and scheduling jobs in EM, Grid monitoring, and analyzing data issues and correcting them. Golden Gate been used to push the data from different OLTP to Data warehouse environment as required. Data Warehouse builder been used to move the data in the environment. Working as an architect, was also responsible for moving data from the old system to the new.
• Sql Server:- Migrated one oracle system to sql server using SSMA, build the database from the scratch and make available to production in the time frame. This database we build with log shipping process for disaster recovery. Set the database backup schedule the jobs for automated backup. Also acting as dba for production maintenance, used scripts to maintain and monitor the activity and performance tuning. Build SSAS, SSRS in the database for the business.
• Web Logic Administration- Configuration and maintenance of various domains required for CRMS and Navigator projects of Suntrust. There are more than 25 domains and many different environments. Creation of Domain Clusters and JVMs in Web Logic 9.2/10x/11g as required. Application support for various environments such as Development/Load Test/UAT/Production/Pre-production. Also worked in Console administration.

Confidential

Environment 1: Oracle10g, sqlserver2008, Unix, ToadOracle, GoldenGate, Data warehousebuilder, ER studio Autosys

• Environment 2: Sql server, Windows, Toad Sql server.
• Worked on two loan and property application, this includes leading the technical team to build new requirement changes to this application. Worked in DDL's, security management, building the environment for developments, performance management, Autosys job creation for scheduling the jobs for automation. Also responsible for fine tuning the script, writing shell or Perl script in Unix using DBI interface, administrating the Unix jobs, monitoring jobs and scheduling jobs in EM, Grid monitoring, and analyzing data issues and correcting them. Golden Gate been used to push the data from different OLTP to Data warehouse environment as required. Data Warehouse builder been used to move the data in the environment. Working as an architect, was also responsible for moving data from the old system to the new.
• Worked on both oracle database and sqlserver in the production maintenance and perform tuning.

Confidential

Oracle10g, sql server 2008, Unix, APEX, Toad Oracle Queuing Erwin

Confidential

Oracle database Admin SQL/Plus

Junior DBA supporting a large scale database Oracle 10g on Unix platform. Implementation includes RAC, Grid and Oracle partitioning. Additional duties include maintaining Oracle uses for development side and helped in implementation of new patches to databases. Performance tuning activities encompass utilizing Quest Toad for Oracle. Also was a part of installation and maintenance of internal reporting database. As DBA other responsibilities include developing pl/sql, write shell scripting and implementing standards for database deliverables for application installation features including a partition maintenance package.

Confidential

Oracle Lead/ Oracle database Developer/ System Analyst/ Architect.

Designed, Enhanced and developed applications for the Government Agriculture inventory project. Writing scripts and PL/SQL and managing database was the prime duties. Work involved developing, designing and implementing DDL, stored procedures, Forms and Reports. Also used Microsoft Access, Excel and Visual Basic to port a standardized project estimation tool to use the PeopleSoft HR linked SQL Server back-end for comparison of actual project hours to estimated hour totals. Developed a resource request and tracking system for all EIM IT projects.

Confidential

Oracle DBA, DB2 Sybase.

Worked as a production Support DBA for financial applications on multiple platforms Identified and developed procedures for procedures for system backup and disaster recovery. Constructed C programs embedded with SQL in accordance to shop's standards. Designed effective programs that manipulated tables for reconciliation accounts, experienced with life cycle methods and critical business applications. Worked in supporting different databases Oracle, Sybase and DB2. Work extensively on database backups and recovery and client installations. Worked on tuning database procedures and tables. Worked 24/7 support on the production database.

Confidential

Oracle Developer.

Worked as a developer DBA for logistic base company, main role includes capturing business process requirements, studying existing system and review, consolidating requirements, preparing High level and Low Level Design documents, load the data by using SQL Loader, Writing PL/SQL Procedures, Triggers, Packages for batch processing of the applications, Tuning the SQL Query for efficient performance in packages, procedures and functions. Involved in Testing and production support activates Created Oracle tables in Oracle 7.x.8i, developed front-end development and backend. Performed front-end coding and backend Triggers and Procedures , enhanced Oracle PL/SQL Procedures and Triggers. Participate actively in Designing and implementation of applications. Design the strategies for database backup and recovery. Created Forms through Oracle form Builder templates as for Form design using Visual attributes, Property Classes, Alters, Messages, Object groups and Tool bars. Designed and developed Reports 6i for writing ad-hoc reports.