SUMMARY:

• More than 16 years of IT experience out of which 14 years as Oracle DBA having experience in Database Architect/Administration, Install, Configure, Upgrade, Migrate and support Oracle 9i,10g,11g and 12 c RAC Databases, Disaster Recovery, High Availability Data Guard plan on multiple Unix and Windows based systems.
• Experience in Installing Grid Infrastructure with ASM Oracle Clusterware and configuring Disk groups.
• Experience in Installing Oracle 9i, 10g,11g & 12 C Oracle RAC, Data Guard, Upgrades and Migration.
• Supported Upgrade for ATG ecommerce Application from Version 9 to 11 on Oracle 12 C database.
• Experience in Performance Tuning and Monitoring and Troubleshooting Databases using Oracle Grid Infrastructure.
• Implemented Oracle Audit and Security Policies and Fine Grained Control for users.
• Setup and configure Oracle RMAN, Backup’s and recoveries and build DR systems and test the configurations.
• Experience in Setup and configuration TDE (Transparent Data Encryption) for Table space/Column level Encryption and generate P12 & SSO Wallets.
• Created Encrypt/Decrypt functions for Credit Card Encryption for PCI Project (Processing Card Industry).
• Ability to work as self - start, self-motivated and a good team player.
• Ability to perform Project Management functions to support business deliverable within budget and time constraints.
• Experience on Logical & Physical Designing of Databases, Data Modelling Conceptual Design & Data Architecture. Extensive use of Erwin v4.x/3.x as a modelling tool.
• Authenticate the database by integrating with directory services, Active Directory and LDAP.
• Well versed using tools viz. MS-Visio, MS-Office and Documentation.

SKILLS SUMMARY:

Operating Systems: HP-UX 9/10/11/11i, AIX 7.1, Solaris, Red Hat Linux and Windows.

Software: Oracle 7/8/8i/9i/10g/11g, 12 C, Oracle RAC 9i/10g/11g & 12 C Data Guard (Standby, both Logical and physical), Oracle Advance Replication, Golden Gate, RMAN, Oracle 12 C Grid ControlOEM, Oracle Internet Directory (OID, ONS, LDAP), MySQL

ERP: BaaN ERP, YANTRA ( Confidential Sterling Order Management) PkMS Warehouse Management and Adage.

Application & Tools: YANTRA (Order Management System), ATG Dynamo, Oracle Ecommerce 9x, 11x Versions (Online Stores), PCMS (Product Catalog System), SPOTLIGHT, TOAD, SQL Developer, BMC Patrol, STATPACK, Erwin Data Modelling 4.0, Informatica 7.x Administration, Redwood Scheduler Administration. RemedyHEAT, Perigrim, CA and Scopus.

PROFESSIONAL EXPERIENCE:

Confidential, Columbus, OHIO

Oracle Technical Consultant

Responsibilities:

• Successfully Migrated ATG database from Oracle 11g to 12 c and also supported ATG migration form version 9.x to 11.x.
• Install, configure and setup Oracle 12 C 3 Node RAC for Tokenization Project.
• Work through the ATG Upgrade Mock conversions and successfully cutover to Prod migration.
• Working on Yantra Mock conversions and planning on the prod cutover for BOPIS Project (Buy Online and Pick up at Store).
• Developed code for Oracle Encryption/Decryption and implemented Oracle TDE (Transparent Data Encryption) for Credit Card Data per PCI Compliance Project (Processing Card Industry).
• Supporting day-to-day production issues and this includes Incidents/Change Request management.
• Apply database patching using OPatch utility for all the RAC & Non-RAC Databases.
• Apply critical and CPU patches and keep all environments in-sync.
• Work closely with Oracle Support and raise SR's for any critical issues.
• Refresh Clone DEV/QA environments using RMAN backups.

Confidential, Sacramento, CA

Database Architect

Responsibilities:

• Design and Implement cost-effective correct physical database solutions on business specification and logical models.
• Practical understanding of Data modeling (Dimensional & relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, fact and Dimention tables.
• Comprehensive knowledge and experience in process improvement, normalization.de-normalization, data extraction, data cleansing, data manipulation.
• Familiarity and experience in work environment consisting of business analysts, Production Support teams, Subject Matter Experts, Database Administration and developers.
• Good understanding of Views, Synonyms, Indexes, Joins and Partitioning.
• Experience in extracting, transforming and loading (ETL) data from spreadsheets, database tables and other sources using Sagent ETL Tool.
• Created, documented and maintained logical and physical database models in compliance with enterprise standards and maintained corporate metadata definitions for Enterprise Data store within a metadata repository.
• Developed mapping spreadsheets for (ETL) team with source to Confidential data mapping with physical naming standards, datatyes, volumetric, domain definitions, and corporate meta-data definitions.
• Establish and maintained comprehensive Data model documentation including detailed descriptions of Business entities, attributes and data relationships.
• Worked extensively on Oracle SQL Designing Modeling Tool.

Confidential, Minneapolis, MN

Sr. Oracle DBA

Responsibilities:

• Configuring Oracle 9i, 10g, 11g Databases on Linux and Confidential Linux Servers, Oracle RAC, Data Guard, High Availability,( Physical and Logical Standbys) Building Disaster Recoveries across multiple Data Centers and configuring ASM and Database Upgrades
• Install, configure and maintain Oracle 10g,11g Databases on Confidential Linux and Windows servers.
• Build Physical, Logical Standby databases using Data Guard on Oracle 10g, 11g and implement disaster recovery solutions across multiple Data Centers.
• Install and configure Oracle RAC and configure ASM disk storage.
• Implementation and support of Oracle 10g and 11g migrations and Upgrades from Oracle 9i and 10g databases, including Oracle RAC (Real Application Cluster
• Provide Implementation and support for SAP/Oracle and other application Migrations and Upgrades, including environments using Oracle Data Guard.
• Setup and configure Golden gate and migrated large databases.
• Install and provide support for Oracle Enterprise Manager Grid Control and Agents.
• Implement Logical and Physical data models and maintain using Erwin tool.
• Apply critical and CPU patches and keep in - sync all environments.
• Closely work with other Architects/DBA's as part of the Global team.
• Using RMAN, performs Backup's restores and clone QA/DEV environments for developers testing
• Using GRID control schedule jobs, Install, Oracle binaries, agents, Patch sets and CPU patches and monitors databases etc

Confidential, Oakland, CA

Data Architect / DBA

Responsibilities:

• Lead and work with a team of DBA's migrating Oracle and SQL Server Databases on to Confidential Infrastructure Data Center. Build, Install and Configure 10g databases on RAC and Non - RAC environments on Confidential 3850 M2 series Servers.
• Also, Virtualization of Oracle and SQL servers databases on Confidential ESX Servers.
• Created the plans and design diagrams for the Data migration / consolidation of 4 Data Centers to one Data Center.
• Built primary and standby Databases with Data Guard and rolled over to new Servers.
• Used RMAN backup and restores to migrate databases with minimum downtime.
• Developed and designed physical and logical databases.
• Ensure the recoverability of all production data for operational and business continuation needs.
• Worked on Performance and Tuning, Improved the quality and reduced defects in all database environments.
• Logged support cases as necessary and effectively worked with Confidential
• Interfaced with the client frequently to assure precise specifications for all database activities are documented and executed.
• Clone and refresh databases from Production to Dev/QA Environments.
• Maintained Data Loads using Informatica ETL loads.

Confidential, Minneapolis, MN / Rochester, NY.

Lead Oracle DBA / Architect

Responsibilities:

• Lead and work with a team of DBA's migrating Oracle and SQL Server Databases on to Confidential Infrastructure Data Center. Build, Install and Configure Oracle 9i and 10g databases on RAC and Non - RAC environments.
• Also, Virtualization of Oracle and SQL server s databases on Confidential ESX Servers.
• Created the plans and design diagrams for the Data migration / consolidation of 4 Data Centers to one Data Center.
• Built primary and standby Databases with Data Guard and rolled over to new Servers.
• Used RMAN backup and restores to migrate databases with minimum downtime.
• Developed and designed physical and logical databases.
• Worked on Performance and Tuning, Improved the quality and reduced defects in all database environments.
• Logged support cases as necessary and effectively worked with Confidential
• Interfaced with the client frequently to assure precise specifications for all database activities are documented and executed.
• Clone and refresh databases from Production to Dev/QA Environments.

Confidential, Minneapolis, MN

Sr. Oracle DBA

Responsibilities:

• As part of an Oracle and SQL Server DBA team, provided 24x7 support for QA and development environments. These ERP applications ran on Oracle 8i, 9i and 10g in Primary, Standby, Logical Standby, RAC/Non RAC environments. This includes backup and recoveries.
• Install and configure Oracle 10g Databases on Linux, HP - UX and Windows NT.
• Moved Oracle databases with minimum downtime across servers (64 bit New Hardware Servers).
• Performed Character conversion using export /import on Oracle 10g.
• Configure and administer Oracle 10g RAC and ASM.
• Make sure the Cache Fusion mechanism is working optimally in the RAC Cluster
• Implement Physical Standby and logical standby databases using Oracle's Data guard
• Implement Disaster Recovery Plans using Oracle's Dataguard feature and successfully validating them with switchover and switchback procedures
• Work with developers to configure Fast Application Notifications (FANs) for JDBC/OCI clients there by enabling High Availability and Load Balancing in the RAC.
• Work with Network administrators to configure VIPs in the DNS for RAC.
• Clone and refresh databases from Production to Dev/QA Environments.
• Develop and write scripts for database backup and restore scripts using SQL and K-Shell scripts.
• Develop tests and maintain disaster recovery procedures and documentation for area(s) of responsibility.
• Mentor and train junior members of the team.
• Log support cases as necessary and effectively work with Confidential

Confidential

Sr. Oracle DBA

Responsibilities:

• Provide technical and strategic plans in the DBA team for Oracle databases. This includes shell scripting for ETL loads in a Data Warehousing environment using Informatica 7.1 tools.
• Work with functional experts and application architecture teams to design the logical and physical models for databases of different applications.
• Performed DB Code Migrations and deployments across Dev, QA and Production Databases
• Working with the Internal/External Auditors to meet and remediate the compliance requirements for databases falling under the scope of SOX reviews
• Actively participates in supporting test plans, test environments, benchmarks and statistics and document the procedures.
• Manage projects and day - to-day support of numerous OLTP and DSS database systems
• Setup configure and administration of Informatica power center Server /Client.

Confidential, Minneapolis, MN

Sr. Oracle DBA

Responsibilities:

• Working in the DBA team and helping Migration databases from Clone and refresh databases from Production to Dev/QA Environments and be on call for Production support.
• Installing/ Upgrade Oracle Patch sets and applies security patches and TAR Support.
• Assists in the resolution of complex problems in support of production.
• Creates, develops, and reviews the physical data model created from the logical data model.
• Creates and implements the physical database design and structures
• Analyze Reorganizes databases and indexes, repairs corruption in database tables where possible or recovers them from backup.
• Actively participates in supporting test plans, test environments, benchmarks and statistics and document the procedures.
• Assist with the development of the technical architectures. Ensures the database management
• Systems and tools support the defined architectures and business needs.
• Participates in the testing, evaluation, implementation, and training of DBMS and related software products.
• Plan, coordinate and implement projects or products as required.
• Interfaces with the client frequently to assure precise specifications for all database activities are documented and executed.
• Be available to work extended hours when needed in support of mission critical applications and perform other duties as assigned.

Confidential, Minneapolis, MN

Sr. Oracle DBA

Responsibilities:

• Migration and Deployments across all environments and S/W Deployments
• Installation and Configuration of Oracle 8i, 9i databases across Dev/QA/Prod on HP - UX 11i Servers (RAC and non RAC).
• Installing/ Upgrade Oracle Patch sets and applies security patches and TAR Support.
• Performed DB Code Migrations and deployments across Dev, QA and Production Databases
• Performed space allocation for Database Objects and set up new environments.
• Perform RMAN Backup and restore for oracle 9i Databases .
• Successfully configured RMAN tape backups for Dev/QA (RAC) databases using Veritas Netbackup. Implemented the disaster recovery strategies using RMAN. Successfully performed database recovery using tape backups in RAC environment. Created duplicate databases using RMAN tape backups with Veritas Netbackup.
• Assists in the resolution of complex problems in support of production.
• Creates, develops, and reviews the physical data model created from the logical data model.
• Creates and implements the physical database design and structures
• Analyze Reorganizes databases and indexes, repairs corruption in database tables where possible or recovers them from backup.
• Actively participates in supporting test plans, test environments, benchmarks and statistics and document the procedures.
• Assist with the development of the technical architectures. Ensures the database management
• Participates in the testing, evaluation, implementation, and training of DBMS and related software products.
• Plan, coordinate and implement projects or products as required.
• Interfaces with the client frequently to assure precise specifications for all database activities are documented and executed.
• Be available to work extended hours when needed in support of mission critical applications and perform other duties as assigned.

Confidential, Columbus, OH

Oracle DBA

Responsibilities:

• Support for Database Issues and develop Procedures and Documentation.
• Install and configure Oracle 8.1.7.4 and 9.2 on HP - UX 11i and Linux RH9 Production servers.
• Generate and maintain Data Modeling using Erwin v4.x/3.x.
• Data Migration from PkMS to Web-Based PkMS2002r2
• Involved in writing PL/SQL stored procedures, functions, triggers and scripting.
• Performed recovery/restore of Data files, control files and archive log files in 24/x7 environment for Production Instances.
• Database tuning like Partitioning, Index organized tables indexing and applying all the guidelines for a successful data warehouse. Designed the SQL queries for indexes in sequence. Applied joins to avoid full scans, explained plan regarding query path for full scan, DML operations or indexes used.
• Performance tuning using UTLSTAT reports, third party tools, Explain Plan and monitoring Alert logs. Carry out Capacity planning; generate capacity reports to monitor space utilization.
• Develop concepts to research and evaluate new software tools for database administration.
• Play a lead role in the development and implementation of new projects.
• Create scripts to automate routine database administration tasks.
• Keep up-to-date on current database administration procedures.
• Evaluate releases of Oracle and third party products to ensure that the site is running the products that are most appropriate
• Be available to work extended hours when needed in support of mission critical applications and perform other duties as assigned.