SUMMARY:

• Having 11+ years of experience in managing RDBMS&NoSQL database systems on various platforms.
• The extensive experience in database support, upgradations and migrations from Oracle 8i/9i/10g and 11g/12c in mixed environments and cross OS platforms (Linux, Solaris, HPUX, AIX, and Windows Server).
• Installed different versions of Oracle on Linux, Solaris and Windows operating systems.
• Experienced in complex data models and logical database deigns.
• Extensively used Erwin to design Logical/Physical Data Models, forward/reverse engineering.
• Upgraded Oracle Databases from 9.2.x/10.1.x to 11.2.x/10.2.x and Migrated From 10.1.x/11.1.x to 10.2.x/11.2.x.
• Involved in Implementation of Oracle 12c/11g/10gRAC (Real application cluster), Using OCFS2, ASM as well as RAW devices.
• Expertise in Oracle 12c databases setup on Linux and UNIX environments.
• Configured OEM 12c for databases monitoring.
• Performed day to day Oracle 12c databases support.
• Configured GoldenGate Replications and performed date to date support activities.
• Performed GoldenGate migration activities from 11.2.0.2 to 11.2.0.4
• Involved in configuration of goldengate and Streams.
• Expertise in Migration of database from Non RAC to RAC.
• Upgraded Oracle RAC from 10g to 11g
• Implementing the TAF and RMAN backup in RAC, Load balancing.
• Expertise in configuration of Disaster Recovery databases using oracle 11g as active dataguard and Physical Standby Databases,
• Expertise in cloning of the database Using cold backup, hot backup and RMAN.
• Expertise in Hot backup & cold backup And Logical backup (Exp/Imp & Expdp/Impdp).

TECHNICAL SKILLS:

Databases: Oracle RDBMS/ORDBMS 8i,9i,10G,11G,12c (RAC,ASM and Data Guard, Flashback Database Features),OracleGoldenGate, OracleStreams,MSSqlServer,MySql,NoSqlDB,MongoDB, Cassandra.

OS: Linux, Solaris,HP Unix, IBM AIX, Windows Server

Oracle Technologies: RAC, GoldenGate,Streams,replications,ASM, Data Guard, Standby database, Transportable Tablespace, External Tables, Partitioning, Materialized views and snapshots, partitioning, Oracle Flashback, Datapump, Oracle Streams, asmlib, ocfs/ocfs2

Programming Languages: PL/SQL, T - SQL, SQL, SHELL (sh, bash, ksh)

Development/Administration/ Performance Tools and Utilities: RMAN with recovery catalog and without, SQL Plus, STATSPACK, AWR/ADDM,TKPROF, EXPLAIN PLAN,Oracle SQL Optimizer, hints, TRACE Analyzer, Quest TOAD,Oracle Enterprise Manager, Remedy

Unix Tools/Commands: cron, at, vi, sed, awk, other Unix, Linux commands and utilities, Informatica Power Center 9.0.1, Power Exchange, Force.com, Apex Explorer, SQOL, Netezza, SQL/PL SQL, Oracle 10g, Visio 2010, Erwin, & UC4,SSIS

PROFESSIONAL EXPERIENCE:

Confidential, Alexandria,VA

Database Administrator-III

Role and Responsibilities:

• Installed / configured Oracle 11.2.0.2 Golden Gate and implemented bi-directional replications.
• Configured Datapump, Extract and Replication Processes in GoldenGate.
• Installed and configured oracle 12c database on Linux and Sun Solaris.
• Performed day to day GoldenGate activities.
• Configured custom scripts for GoldenGate for the extract and replicate process.
• Migrated the GoldenGate from 11.2.0.2 to 11.2.0.4
• Worked on veridata configuration for GoldenGate to compare records between source and target.
• Upgraded RAC databases from oracle 10g to 11g
• Applied PSU patches for RAC databases.
• Configured active dataguard and performed DR activities.
• Expertise in database performance tuning activities.
• Configured OEM 12c for databases monitoring.

Environment: Operating system: Sun Solaris, AIX, Linux, HP-Unix, windows

Databases: Oracle9i/10g, OracleRAC10g/11g/12C, GoldeGate, Replications, Informatica8.6/9.1,SqlServer,NoSQL,MongoDB,Cassandra.

Scripting: UNIX shell, SQL/PLSQL

E Business Suite: 11.5.9, 11.5.10.2, R12.

Utilities: RMAN, SQL*Loader, TKProf, Export, Import.

Tools: Remedy, TOAD, TSM, OEM, Grid, Informatica Power Center 9.0.1, Power Exchange, SQL/PL SQL, Oracle 10g, Visio 2010, Erwin

C onfidential, Dever,CO

Designation:Database Architect

Role and Responsibilities:

• Expertise in process improvement, normalization/de-normalization, data extraction, data cleansing, data manipulation.
• Closely worked with BAs and converted from BRD to Technical documents.
• Experienced in complex data models and logical database deigns.
• Extensively used Erwin to design Logical/Physical Data Models, forward/reverse engineering modeled the Data Warehousing Data marts using Snow/Star Schema.
• Performed Data Modeling and Logical, Physical structure setup for the databases.
• Expertise in Oracle 12c databases setup on Linux and UNIX environments.
• Configured OEM 12c for databases monitoring.
• Upgraded oracle RAC databases from 10g/11g to 12c.
• Expertise in Performance tuning the production database towards optimal performance based on the changes in the database storage structures due to application change requirements. Monitoring and optimizing the performance of the Database through Database Tuning - Tuning Applications, Tuning Memory, Tuning Disk Usage and Tuning OS.
• Implemented High availability using GoldenGate Replication. Implanted Bi-directional replication using golden gate.
• Configured GoldenGate and developed custom scripts for data replications.

Environment: Operating system: Sun Solaris, AIX, Linux, HP-Unix, windows

Databases: Oracle9i/10g, OracleRAC10g/11g/12C, GoldeGate, Replications, Informatica8.6/9.1,SqlServer,NoSQL,MongoDB,Cassandra.

Scripting: UNIX shell, SQL/PLSQL

E Business Suite: 11.5.9, 11.5.10.2, R12.

Utilities: RMAN, SQL*Loader, TKProf, Export, Import.

Tools: Remedy, TOAD, TSM, OEM, Grid, Informatica Power Center 9.0.1, Power Exchange, SQL/PL SQL, Oracle 10g, Visio 2010, Erwin

Confidential, Chase,OH

Application DBA

Role and Responsibilities:

• Primarily responsible for production support. To keep all databases up and running in production.
• In-depth Knowledge of installation, configuration, and maintenance of Oracle database - 9i, 10g and 11g.
• Up-gradation of RAC databases from CRS 10.2 11.2.
• Configuration of 11g CRS RAC Environment using ASM.
• Oracle Golden Gate configuration and administration. Configured bi-directional and unidirectional replication between databases.
• Creating primary database storage structures (tablespaces), altering, and modifying the database structure according to the company’s requirement as necessary, from information given by the application developers.
• Monitor database management systems as well as evaluating database performance to maximize efficiency

Environment: Operating system: Sun Solaris, AIX, Linux, HP-Unix, windows

Databases: Oracle9i/10g, OracleRAC10g/11g/12C, GoldeGate, Replications, Informatica8.6/9.1,SqlServer,NoSQL,MongoDB,Cassandra.

Scripting: UNIX shell, SQL/PLSQL

E Business Suite: 11.5.9, 11.5.10.2, R12.

Utilities: RMAN, SQL*Loader, TKProf, Export, Import.

Tools: Remedy, TOAD, TSM, OEM, Grid, Informatica Power Center 9.0.1, Power Exchange, SQL/PL SQL, Oracle 10g, Visio 2010, Erwin

Confidential, Denver, CO

IT Project Coordinator-I(Lead DBA)

Role and Responsibilities:

• Provided Oracle databases support for production, development and test environments .
• Installed Oracle11g/10g/9i/8i software and created database on Sun-Solaris, HP-Unix, Linux,
• Managed Logical And Physical Database Design.
• Requirement study, Installation of Oracle 11g/10g/9i/8i, Data Modeling, Database design & creation.
• Configured oracle 10g/11g dataguard and performed day to day activities.
• Configured Oracle GoldenGate and performed date to date support activities.
• Installed and configured MongoDB Database 2.6 on Linux.
• Expertise in troubleshooting of NoSQL systems.
• Migrated oracle standby databases to oracle 11g RAC
• Built the Warehouse databases in oracle 10g/11g and Supported ETL activities on warehouse.
• Configured Oracle 11g Dataguard and performed day to day activities.
• Expertise standby database configuration and performed day to day activities.
• Expertise in configuration and support of Bigdata databases like MongoDB systems.
• Performed day to day maintenance activities for Bigdata/NoSQL systems.
• Migrated databases from Sqlserver to Oracle.
• Database backups using sql Backtrack for hot backup&cold backup.
• Experienced in Memory Tuning, Query Optimization, SQL Tuning & Database Tuning.
• Written and Implemented PL/SQL Scripts to check the performance of the database.

Environment: Operating system: Sun Solaris, AIX, Linux, HP-Unix, windows

Databases: Oracle9i/10g, OracleRAC10g/11g/12C, GoldeGate, Replications, Informatica8.6/9.1,SqlServer,NoSQL,MongoDB,Cassandra.

Scripting: UNIX shell, SQL/PLSQL

E Business Suite: 11.5.9, 11.5.10.2, R12.

Utilities: RMAN, SQL*Loader, TKProf, Export, Import.

Tools: Remedy, TOAD, TSM, OEM, Grid, Informatica Power Center 9.0.1, Power Exchange, SQL/PL SQL, Oracle 10g, Visio 2010, Erwin

Confidential, Dallas, TX

Specialist-DBA

Roles and Responsibilities:

• Installed and configured Oracle 10g RAC high availability.
• Implemented 4 Node 10g RAC on SUN Solaris cluster and Linux cluster.
• Migrated Databases from Non-RAC to RAC.
• Creation of development database using manual methods and using DBCA.
• Supporting/Troubleshooting existing 10g/11g RAC databases on SUN Solaris cluster.
• Configured GoldenGate and performed date to date support activities.
• Configuring public and private network and VIP for new RAC databases.
• Experienced with SRVCTL, CRSCTL, OCR and Voting Disk of 10g/11g RAC.
• Converting Single Instance databases to RAC databases.
• Upgrading RAC/NON RAC databases from 9i to 10g and from 10g to 11g.
• Converting the single instance database to RAC database for test instance.
• Maintaining RAC and non-RAC databases, adding ASM disks on prod and non-prod RAC databases.
• Configured highly volume of data replications in the production databases and performed day to day activities.
• Performed Cloning of the databases (Cold, Hot and RMAN).
• Applied patches as per the requirements.
• Configured RMAN backup for all the Production databases.

Environment: Operating system: Sun Solaris, AIX, Linux, HP-Unix, windows

Databases: Oracle9i/10g, OracleRAC10g/11g/12C, GoldeGate, Replications, Informatica8.6/9.1,SqlServer,NoSQL,MongoDB,Cassandra.

Scripting: UNIX shell, SQL/PLSQL

E Business Suite: 11.5.9, 11.5.10.2, R12.

Utilities: RMAN, SQL*Loader, TKProf, Export, Import.

Tools: Remedy, TOAD, TSM, OEM, Grid, Informatica Power Center 9.0.1, Power Exchange, SQL/PL SQL, Oracle 10g, Visio 2010, Erwin

Confidential

Specialist-Systems

Role and Responsibilities:

• Upgraded Oracle Databases from 9.2.x/10.1.x to 11.2.x/10.2.x and Migrated From 10.1.x/11.1.x to 10.2.x/11.2.x.
• Involved in Implementation of Oracle 10gRAC (Real application cluster) on ASM.
• Upgraded Oracle RAC from 10g to 11g
• Implementing the TAF and RMAN backup in RAC, Load balancing.
• Expertise in configuration of Disaster Recovery databases using oracle 11g as active dataguard and Physical Standby Databases,
• Performed cloning of the database Using cold backup, hot backup and RMAN.
• Performed database Hot backup & cold backup And Logical backup (Exp/Imp & Expdp/Impdp).
• Managing the cluster ware files i.e., OCR files & voting disk.
• Converting the single instance database to RAC database for test instance.
• A dding ASM disks on prod and non-prod RAC databases.
• Taking logical backups (export/import).
• Implementation of backup and recovery strategies.
• Performed Cloning of the databases (Cold, Hot and RMAN).
• Applied patches as per the requirements.
• Configured RMAN backup for all the Production databases.

Environment: Operating system: Sun Solaris, AIX, Linux, HP-Unix, windows

Databases: Oracle9i/10g, OracleRAC10g/11g/12C, GoldeGate, Replications, Informatica8.6/9.1,SqlServer,NoSQL,MongoDB,Cassandra.

Scripting: UNIX shell, SQL/PLSQL

E Business Suite: 11.5.9, 11.5.10.2, R12.

Utilities: RMAN, SQL*Loader, TKProf, Export, Import.

Tools: Remedy, TOAD, TSM, OEM, Grid, Informatica Power Center 9.0.1, Power Exchange, SQL/PL SQL, Oracle 10g, Visio 2010, Erwin

Confidential

IT-Specialist

Roles and Responsibilities:

• Understanding customer requirements.
• Doing customization for the client needs.
• Analysis, development of the application.
• Installation, configuration, connectivity and trouble shooting of Oracle 9i databases on Sun-Solaris, IBM-AIX.
• Provided Database support for the databases in a Development, Test and Production environment.
• Installed & Upgraded from 9.2.0.2 to 9.2.0.5 on Sun Solaris.
• Install / configure and support management system.
• Design, develop, install and administer Oracle 10g - in OLTP / Data Warehousing environment
• Identified source systems, their connectivity, related tables and fields and ensure data suitability for mapping.
• Worked with cross-functional teams and prepared detailed design documents for production phase of current customer database application
• Participate in review of models - performing presentations
• Plan and implement partitioning, replication, backup and recovery of the Oracle databases performance
• Perform capacity planning and implement database security - applying hardening rules and patching
• Monitor/perform ongoing tuning of the database instances and capacity planning
• Perform data analysis and mapping of source/target databases
• Developing and maintaining PL/SQL code - packages / procedures / functions / triggers and standalone SQL scripts

Environment: Operating system: Sun Solaris, AIX, Linux, HP-Unix, windows

Databases: Oracle9i/10g, OracleRAC10g/11g/12C, GoldeGate, Replications, Informatica8.6/9.1,SqlServer,NoSQL,MongoDB,Cassandra.

Scripting: UNIX shell, SQL/PLSQL

E Business Suite: 11.5.9, 11.5.10.2, R12.

Utilities: RMAN, SQL*Loader, TKProf, Export, Import.

Tools: Remedy, TOAD, TSM, OEM, Grid, Informatica Power Center 9.0.1, Power Exchange, SQL/PL SQL, Oracle 10g, Visio 2010, Erwin

Confidential

DataBase Administrator

Roles and Responsibilities:

• Identified source systems, their connectivity, related tables and fields and ensure data suitability for mapping
• Design and support ODS, Data warehouse
• Engineering of legacy systems to derive physical models for further analysis and work
• Analyze business/functional requirements to derive logical models
• Analyze data-related and system integration opportunities and challenges and make recommendations.
• Installed and configured Oracle 9i, 10g on HP UNIX.
• Created logical and physical standby databases using Data-guard and converting physical standby to snapshot for testing purposes.
• Performed HOT/COLD backups using RMAN and Logical backups using data-pump.
• Configured Recovery Manager (RMAN) and performed Hot and Cold backups for production databases using RMAN.
• Created user accounts, roles and granting required access permissions and privileges to the database based on the application they are accessing.
• Conducted daily routine checks on alert logs and trace files for database errors and taken necessary actions to resolve the issue.
• Addressed issues involving data mapping / cleansing on source and target systems
• Participate in review of models - performing presentations
• Install, configure and tune Oracle databases in VMware on Solaris platforms in a RAC environment
• Perform capacity planning and implement database security - applying hardening rules, CPUs and PSUs
• Implement database level hardening for compliance with security standards
• Developing and maintaining PL/SQL code to meet requirements - packages / procedures / functions / triggers and standalone SQL scripts.

Environment: Operating system: Sun Solaris, AIX, Linux, HP-Unix, windows

Databases: Oracle9i/10g, OracleRAC10g/11g/12C, GoldeGate, Replications, Informatica8.6/9.1,SqlServer,NoSQL,MongoDB,Cassandra.

Scripting: UNIX shell, SQL/PLSQL

E Business Suite: 11.5.9, 11.5.10.2, R12.

Utilities: RMAN, SQL*Loader, TKProf, Export, Import.

Tools: Remedy, TOAD, TSM, OEM, Grid, Informatica Power Center 9.0.1, Power Exchange, SQL/PL SQL, Oracle 10g, Visio 2010, Erwin