Summary

• About 13 years of experience as an Oracle Database Administrator having hands on experience in database administration, production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, space management, database security, cloning, migration, shell scripting and documentation.
• Migrated Large Solaris implementation environment resipronics to Redhat Linux -- utilized transportable table spaces to reduce downtime -- also utilized data pump pipe techniques to reduce downtime.
• Migrated over 30 SYBASE servers to ORACLE.
• Involved various cross platform migrations using golden gate and migration workbench.
• Extensive knowledge on database administration for Oracle 8i, 9i, 10g 11g with experience within very large scale database environment and mission critical large OLTP and OLAP systems.
• Expertise in development and designing of ETL methodology for supporting data transformations using Informatica Power Center 7.x/8.x
• Design and development of Business Intelligence Solutions using Informatica, Business Objects, Cognos and Erwin. Expertise in Oracle 9i/8i/8.0/7.x, MS SQL Server 2000/7.0/6.5, Erwin 4.0/3.5, SQL, PL/SQL, SQL PLUS, SQL Loader, TOAD, Stored procedures, triggers
• Strong work experience in Data Mart life cycle development, performed ETL procedure to load data from different sources into data marts and data warehouse using Power Center Repository Manager, Designer, Server Manager, Workflow Manager, and Workflow Monitor
• Involved in understanding of Business Processes, grain identification, identification of dimensions and measures for OLAP applications.
• Extensive Data modeling experience using Dimensional Data modeling, Star Schema modeling, Snowflake modeling, and FACT and Dimensions tables.
• Leveraged expert-level knowledge in an array of Oracle tools, including Oracle Forms, Reports, Loader, SQL, and PL/SQL, in the development of a wide variety of programs and scripts. Made senior-level contributions to system analysis and design projects as well as to quality assurance efforts
• Excellent knowledge in people soft help in data migration operation at ware housing
• Excellent experience in installation, setup and configuration of Oracle 8i, 9i, 10g and 11g in HP-UX, Sun Solaris, IBM AIX, Windows and UNIX/Linux environment.
• Expertise in upgrading the databases from Oracle 9i to Oracle 10g and Oracle 10g to Oracle 11g.
• 24 7 production database support with Support to developers end-users.
• Installed Oracle 11g ASM 10g RAC software with ASM OCFS2 File systems.
• Experienced in Installation of high availability RAC environment 2, 3 and 4 node clusters and upgraded standalone databases to 10g RAC environment.
• Expert in implementing ORACLE STREAMS unidirectional, bi-directional and downstream capture and managed Operational, Historical and reporting databases.
• Proficient in setting up Standby Database using shell scripts and RMAN utility tool, activating and Re-building Standby Databases both Physical and Logical supported by DATAGUARD.
• Managed very large database VLDB of maximum size 5TB with 18 servers including 6 Productions, 6 Testing, 6 Development and 3 Standby databases.
• Created development, testing, staging, production, RAC and standby databases for OLTP, DSS and Data Warehousing using customized shell scripts and stepwise.
• Having hands on experience in Hot/Cold Backup, Recovery and Cloning of databases using RMAN with VERITAS Net Backup.
• Logical and physical modeling using Erwin. And Expertise using tools like Erwin, ER/Studio and Toad.
• Implemented RMAN backup Full, incremental and cumulative and recovery, Incomplete recovery and disaster recovery using Standby database or Data Guard.
• Implemented automated backup strategy using the UNIX shell script CRON UTILITY.
• Performance tuning of the database - SQL Tuning, Used Tuning utilities like STATSPACK, TKPROF, EXPLAIN PLAN, AWR, ADDM and Tuning of SGA, Distribution of disk I/O, Sizing of tables and indexes.
• Data loading using SQL LOADER, Logical backups using full export and DATAPUMP.
• Expertise in maintaining Database Security using security compliance auditing, and expertise in loading data from flat files using external tables, SQL LOADER.
• Good experience of creating PL/SQL packages, Stored Procedures, Functions, Triggers and Views to retrieve, manipulate and migrate complex data sets in Oracle Databases.
• Experienced in using Oracle's Transportable Tablespace TTS feature allows users to quickly move a user Tablespace across Oracle databases.
• Database replication using snapshots, materialized views and advanced replication methods.
• Experience in applying security patches to the databases.
• Effective troubleshooting of database and Performance problems.
• Good experience in Data Migration using export/import.
• Management of Objects, Schemas, Partitioning the tables and Indexes.
• Extensive knowledge of Oracle Architecture, SGA, PGA, LISTENER, TNSNames, V and DBA views.
• Experience in implementation of enterprise databases on enterprise storage solution using SAN.
• Extensive knowledge in reporting tools like Business Objects and crystal reports.
• Knowledge on Oracle Support Process for Technical requests using Metalink and other support procedures.
• Excellent interpersonal and strong analytical skills, Documentation Problem-solving skills with customer service oriented attitude. A very good team player, self motivated, dedicated in any work environment.

Technical Skills

Professional Experience

Confidential

Oracle DBA/Architect

Responsibilities

• Worked in Motorola Mobility home division, a Google subsidiary company with solutions and system integrations team.
• Currently working on VDMS project for VERIZON.
• Helped in Designing and implementing Key Management System and Dynamic AD Insertion for Verizon FIOS.
• Designed High Availability for Key Management System and Dynamic AD Insertion for Verizon FIOS.
• Designed bi-directional active-active replication using golden gate.
• Implemented both DML and DDL replication using golden gate.
• Used integrated capture to support TDI and TSI encryption in replication using golden gate.
• Implemented RAC to RAC active data guard for several databases in the environment.
• Applied DB and Grid patches patches to fix the bugs in supporting integrated capture.

Environment: Golden gate 11.2, Oracle 10.2/11g RAC,DB2, Enterprise Manager GRID, RUP, RMAN, SAN/NAS, HSM, 10g, Streams, CDC, Data Guard, AIX 5.3.Exadata X2, ToadV9.7.SQL,ODI,Oracle discoverer 10g, Informatica Power Center, EXADATA-X2 -2,HP-PAR 3000,Net apps, CTRIX netscaler, WEBSPHERE 8

Confidential ORACLE DBA

Responsibilities

• Worked in APPDBA team in CARDS division for CAPITAL ONE maintained 1/3 of entire capital one data.
• Developed various logical and physical models using ERWIN tool.
• Interacted with architect and developers to produce appropriate logical and physical models.
• Integrated transaction history data into payment system.
• Current Payment system holds 2 years of data and Transaction history table holds 7 years data. Transaction history data is a superset of payment data. We want to integrate payment data with transaction history, so the transaction history API and reports can point to payment system itself.
• Supported in installing and maintain IBM Rational Asset Manager tool which maintains SOA architectures in the organization.
• Worked with IBM to resolve the performance issues of IBM RAM tool, while creating new assets and loading new data and keep the performance under the SLA.
• Helped in remediating shield effort, which is to change all card numbers and change it to a encrypted format. This is a new federal law to improve security of financial data in all financial organizations.
• Certified the patches using Real Application Testing tool using sql performance analyzer and database replay for oracle 11g databases.
• Upgraded Databases from 10.2 to 11.2 using near zero down time using golden gate.
• Created replication from vendor based systems to central payment system using golden gate.
• Transformed the data from vendor payment table format to central table format using golden gate.
• This reduced ETL time to move the data from vendor system to central payment table.
• Created monitoring scripts to monitor golden gate on various instances.
• Resolved various replication and data discrepancy issues in golden gate.
• Written a custom Database compare script to compare schemas and generate reports customized to capital one ITRO requirements.
• Worked in development of internal tool to generate reconciliation reports for payments generated by vendors like REMITCO.
• This tool includes all the payments via check.
• Tuned all the procedures and packages of the tool to match the SLA using sql advisor.
• Migrated Ware house database to EXADATA to optimize the performance.
• Used storage indexes and hybrid column compression allowed us to save lot of space for partitioning tables for payment system and warehouses by EXADATA.
• Configured EXADATA X2 QUARTER RAC with one step command in test environments.

Environment: Golden gate 11.1, Oracle 10.2/11g,DB2, Enterprise Manager GRID, RUP, RMAN, SAN/NAS, HSM, 10g, Streams, CDC, Data Guard, AIX 5.3.Exadata X2, ToadV9.7.SQL,ODI,Oracle discoverer 10g, Informatica Power Center, EXADATA-X2 -2,DB210,HPUX 11.

Confidential

ORACLE DBA

Responsibilities:

• Worked in universal service delivery USD for AT T U-verse and maintained 3 mission critical systems as application DBA.
• Maintained various logical models using CVS tool.
• Developed various logical and physical models using ERWIN tool.
• Interacted with architect and developers to produce appropriate logical and physical models.
• Designed near zero down time migration, during hardware migration of applications.
• Used golden gate and data guard model to create more efficient model to migrate applications on hardware migrations.
• Resolved various performance problems in various databases.
• Created best practices for the team to update current practices with efficient models.
• Created replication solution using golden gate between various mission critical systems.
• Provided database/application tuning including as reducing lock contention, analyzing objects.
• Build environments and support IST, ORT and volume testing for release to release.
• Coordinated with MOTOROLA application team and DB team to support a vendor based system which provide IPTV access for ESPN.
• We have built a logical standby database using Golden gate, which is more efficient in terms of failover time. This between RAC to RAC configuration which first in the organization.
• Design and implemented an AUTOMATED FAILOVER mechanism between primary and secondary site for a mission critical application.
• Currently supporting 3 mission critical plus systems production systems as primary DBA.
• Created TIRE 3 data mart to take off the load from existing data mart.
• Designed and implement migration and replication solution between existing and tire 3 data mart using golden gate.
• Created ETL solutions using golden gate between two data marts.
• Configured EXADATA data center and migrated the existing data mart to it, using golden gate.
• Used smart scan and storage indexes to reduce the query timings significantly on the data mart.
• Migrated PAYMENT systems from oracle to EXADATA using golden gate and data pump in near zero down time using cascading replication.
• Conducted DR / recovery testing on EXADATA.
• Tuned EXADATA database to meet the Service level agreements.
• Used offloading and storage for index organized tables for to improve performance and save space.
• Used HCC column compression to compress fact tables in ware house and optimized the performance to meet the SLAS.

Helped to configure EXADATA X2 QUARTER RAC in various environments.

Environment: Golden gate 11.1, Oracle 10.2/11g,DB2, Enterprise Manager GRID, RUP, RMAN, SAN/NAS, HSM, 10gRAC, Streams, CDC, Data Guard, AIX 5.3.Exadata X2, ToadV9.7.SQL,ODI,Oracle discoverer 10g, Informatica Power Center, EXADATA-X2 -2.

Confidential

Database Administrator

Responsibilities:

• Designed staging system which used golden gate to get data from OLTP system to warehouse through ODI
• This is an efficient implementation which reduced the data loading time to 4HRS.
• This replaced conventional triggers and COBAL extractor program used to take 12 hours of time to load data.
• Installed golden gate in various data guards, which is more efficient way for disaster recovery.
• Implemented golden gate to get various data from various systems.
• Used to be Primary DBA for 24 7 on call.
• Supported ERP databases, suing BR and BW tools.
• Handled zero time migration system using golden gate and transport table spaces between 9.20.8 to 11.1.0.7 for import production systems.
• Used to be active part in installing 11gr1 OEM.
• Implemented a total ware house using golden gate only.
• Used to support day to day administration activities for all the databases
• Used to migrate to migrated data across flat forms.
• Install and configure application server
• Responsible for administration and supporting Oracle 9i, 10g and 11i databases.
• Solely Responsible for maintaining 80 databases
• Responsible of handling 50 TB environment
• Involved in portioning of database to monthly time bases
• Experienced using Informatica integrated with shell programming.
• All the jobs are integrated using complex Mappings including Mapplets and Workflows using ODI
• Provide reporting services and best practices in developing reports for Oracle Reports, BI Publisher, Oracle Discoverer and Oracle Discoverer Administrator against Oracle Financials and client's home grown systems.
• Data Refresh in Test and Integration Databases using Transportable Table spaces.
• Performed Setup Recovery Manager RMAN and Flash Recovery in RAC Environment.
• Oracle Streams Bi-Directional replication implementation at Table, Schema and Database Level.
• Implemented backup strategies using hot/cold, exp/imp used on the business req.
• Cloning databases using scripts as well as RMAN and performed Tablespace point in time recovery TSPITR using RMAN.
• Implemented Streams replication between RAC and non RAC database environments.
• Installed Oracle 10g Enterprise Manager Grid Control for diagnosing and monitoring performance related problems and configured with Application servers on test databases.
• Responsible for code migration from development into production databases.
• Worked on Automatic Storage Management ASM with SAN Storage for managing data in EMC Symmetrix.

Environment: HP-UX 11, Red Hat Linux4, Windows 2003/2008, Oracle 9.2.0.8/10.2.0.3/11i, DB2, Enterprise Manager GRID, RUP, RMAN, SAN/NAS, HSM, 10gRAC, Streams, CDC, Data Guard, SQL Plus, PL/SQL, ASM, J2EE, ToadV9.7 SQL, ODI, Oracle Discoverer 10g, Golden gate 10.4, SQL Server 2003, SYBASE ASE 15, SAP ECC 6.0.Tortise

Confidential

Database Administrator

Responsibilities:

• Responsible for administration and supporting Oracle 9i, 10g and 11i databases.
• Solely Responsible for maintaining 60 databases
• Responsible of handling 50 TB environment
• Involved in portioning of database to monthly time bases.
• Install and configure application server
• Experienced using Informatica integrated with shell programming.
• All the jobs are integrated using complex Mappings including Mapplets and Workflows using Informatica Power Center designer and Workflow Manager Ver 8.6
• Provide reporting services and best practices in developing reports for Oracle Reports, BI Publisher, Oracle Discoverer and Oracle Discoverer Administrator against Oracle Financials and client's home grown systems.
• Migrated SQL 2003 database using migration work bench.
• Migrated SYBASE ASE 15 to oracle 10g using golden gate.
• 24x7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
• Data Migration from OLD databases Oracle 9i 8i to the New Database Oracle 10G on RedHAT LINUX AS4.Installed and configured the oracle10G RAC on RED HAT Linux AS4 and have migrated 8 databases in different platforms to same single centralized database server oracle10G RAC .
• Created the Migration Scripts for the migration from old system to new system. Created the Scripts using PL/ SQL for DATA MIGRATION from old System to new System for CSMC.
• Involved in designing of disaster recovery plan using Data Guard, and High Availability using RAC.
• Assess reporting environment then created Best Practices report tailored for client's environment.
• Provide reporting services and best practices in developing reports for Oracle Reports, BI Publisher, Oracle Discoverer and Oracle Discoverer Administrator against Oracle Financials and client's home grown systems
• Created new End User Layer EUL for Oracle Discoverer version 9. Created views, business, areas and reports
• Schemas refresh using Export/Import Pump, Creating the database table spaces, tables, indexes, setting privileges and user logins.
• Configuration, Administration and tuning of Oracle 10g and 9i RAC.
• Involved in PeopleSoft Financials upgrades from 8.4x to 9.0 for numerous clients, involving data warehousing, migration, and reconciliation.
• Monitoring and tuning using tools like Enterprise Manager GRID, Oracle cost Based optimizer CBO , SQL analyzer, automatic checkpoint tuning, SQL Advisors, Performance Manager, and Statspack.
• Performed conversion single instance to Real Application Cluster RAC database instances.
• Utilized Oracle Streams to capture, propagate, and apply the transfer of data, transactions, and events within managed databases.
• Provided database/application tuning including as reducing lock contention, analyzing objects.
• Downsizing and defragmenting the Very Large Databases by export / import, cloning those using RMAN duplicate features and then upgrading them to Oracle 10g and Production to development refresh.
• Storage Management Managing Space, Table spaces, Segments and Extents, Rollback Segments Data Dictionary.
• Experienced on Database Security by monitoring User Management, Privileges, Roles, Auditing, Profiling, Authentication and Risk management.
• Used Oracle Advanced Replication feature to set up multi-master replication, dealt with conflict resolution and performance issues.
• Unix Shell scripting in csh, ksh for automating startup/shutdown, backup and recovery, Import and export procedure of databases, getting system alerts.
• Experienced in documentation, provided documentation for database design, analysis, modifications, creating schemas etc.
• Resolved TAR issues 24x7 while assisting the functional team and oracle support Metalink and managing database security.

Environment: HP-UX 11, Red Hat Linux4, Windows 2003/2008, Solaris, Oracle 9.2.0.8/10.2.0.3/11i, DB2, Enterprise Manager GRID, RUP, RMAN, SAN/NAS, HSM, 10g RAC, Streams, CDC, Data Guard, SQL Plus, PL/SQL, ASM, J2EE, ToadV9.7 SQL, Navigator V6.1, PeopleSoft, Oracle Reports 10g, Oracle Discoverer 10g, Golden gate10.4, SQL Server 2003, SYBASE ASE 15, Informatica 8.6, SAP ECC 6.0

Confidential

Sr. DBA

Responsibilities:

• Reclaimed over 30 GB space in a Database Re-org in one of the most critical databases.
• Handled Disaster Recovery scenarios.
• Implemented replication with golden gate between reporting and production server.
• Designed and created custom reports using Oracle Reports for support of conversion from corporate legacy system to Oracle ERP Reports covered financial modules such as GL, Payables, Receivables, Project Contracts, Order Management and Manufacturing.
• Registered reports and stored procedures in Concurrent Manager that is part of Oracle Applications 11i
• Involved with quarterly partitioning of database.
• Created value sets in Oracle Applications 11i to support variable choices used in reporting
• Provide database architecture, design, configuration, development experience with all 5 major database platforms
• Responsible for the maintaining 30tb environment over 50 databases.
• Migrating Oracle 9i database to Oracle 10g. Installing Oracle Patch. Migrating production database to new server.
• Designed and created custom reports using Oracle Reports for support of conversion from corporate legacy system to Oracle ERP Reports covered financial modules such as GL, Payables, Receivables, Project Contracts, Order Management and Manufacturing.
• Registered reports and stored procedures in Concurrent Manager that is part of Oracle Applications 11i.
• Created value sets in Oracle Applications 11i to support variable choices used in reporting
• Migrated Oracle 10g databases to Oracle automatic storage management ASM , increasing database performance and disk-space utilization. Coordinated activities in U.S. and India, executing constant technical operations with upgrade scripts taking five days to run. Converted Oracle databases from SUN to IBM AIX pSeries, increasing performance gains and reducing technical support costs. Upgraded corporate website from ISP to in-house Linux servers, directly resulting in 24,000 in annual savings and providing better service and performance.
• Used Migration Workbench for SQL Server to migrate a SQL Server database to Oracle
• Cloned/Refreshed environments to create patch test, development and QA environments Created scripts to monitor and manage the databases.
• Upgraded several databases both release and version upgrades.
• Assisted in project management and planning efforts for design and deployment of PeopleSoft applications and upgrades.
• Handled Database Installations all versions up to 10g .
• Cloned databases with various strategies like Hot, Cold, Logical methods and RMAN.
• Involved in providing technical assistance to developers in all matters concerning performance application related issues.
• All the jobs are integrated using complex Mappings including Mapplets and Workflows using Informatica power center designer and workflow manager.
• Experienced in ETL Administration responsibilities for the Enterprise Data Group using the Informatica tool
• Maintained and monitored replication using golden gate
• Created new environment for golden gate replication
• Resolving issues faced by Application team by analyzing PL/SQL code etc and giving resolution details and root cause analysis. RCCA
• Responsible for Online/Offline database backups and managing Database recovery with RMAN.
• Worked with Oracle Support during ORA-600 and ORA-7445 issues.
• Responsible for storage management - Managing Space, Table spaces, Segments and Extents, Rollback Segments Data Dictionary.
• Configured scripts in Crontab for Production Environment
• Alert monitoring and resolution.
• Design, Install, Tune and Monitor Oracle databases
• Extensively used Tivoli Storage Manager TSM and Netback up
• Monitor and optimize the Performance of the database

Environment: Oracle 10g/9i, SQL Server 2000, Sun Solaris 8.0, SUN SPARC, AIX, HP UNIX, Windows 2000/2003, Oracle Enterprise Manager, SQL Loader, T-SQL, STATSPACK, TKPROF, EXPLAIN PLAN, golden gate , PeopleSoft 9, RHEL 3, Oracle BI10g, Oracle Reports 10g, Informatica, Informatica 8.1.1, Cognos 7