SUMMARY:

• DBA and modeler with over 12 years of experience in all aspects of Database Administration, with in - depth experience in implementing, supporting and tuning Production Systems.
• Oracle 8i, 9i, 10g, 11g, 12c
• Real Application Clusters (RAC)
• Performance Tuning
• Distributed Databases
• Disaster Recovery Solutions
• Golden Gate
• Data Modeling (Erwin)
• SQL Server
• Data Pump and Flash-back Recovery
• Oracle Enterprise Manager (OEM)
• AIX(5,6,7),Solaris,HPUX,Linux,Windows
• Database Security and Auditing
• Perl/Shell Scripting
• Exadata
• Over 10 years of experience as Oracle Data Base Administrator, providing 24/7 production support for Production, Test and Development (11g,10g/9i/8i) databases on Various Platforms.
• Experienced in working mission critical environments including DBA Team of 30 DBA’s, 6000 Databases in 1000+ servers and 1800+ Applications.
• Experience in Installation and configuration of Oracle 8i, 9i, 10g, 11g in Unix/Linux, Solaris and Windows environment.
• Experienced in regular Database Administration activities such as Upgrades, Patches, TAR Support, Cloning (Hot/Cold/RMAN), Backup and Recovery, Performance Tuning, capacity planning, script development, and documentation.
• Installed and Configured GoldenGate on Test, dev and production instances.
• Designed, modeled, normalized and implemented logical and physical models
• Proficient in server side programming like Procedures, Functions, Database Triggers& Packages.
• Expert in utilizing ETL tools, including Oracle Data Integrator, Informatica and Oracle.
• Good Knowledge of Oracle single sign-on and oracle web logic server.
• Experience in maintenance of SQL Server in a VLDB environment & experience in troubleshooting and resolving database problems.
• Experience in installing MS SQL Server 2005/ 2008/ and updating with hot fix and service packs.
• Extensively used the native tools like tuning wizard, SQL Server Profiler, Performance Monitor, Activity Monitor, and Event viewer for performance analysis.
• Experience in Data Modeling of Oracle, PL SQL &, Business Intelligence Data Warehousing.
• Developed approaches and frameworks for the enhancement of data quality and integrity.
• Worked on identifying facts, dimensions and various other concepts of dimensional modeling which are used for data warehousing projects.
• Hands on experience in installing, configuring, and using Hadoop ecosystem components.
• In-depth knowledge and experience in full life-cycle of Application deployment which includes Data architecture, Logical and physical database design, Data modeling using Erwin, Writing sql,pl/sql codes for application, testing the application Following stage deployment and load testing and finally go live to production.
• Did scripting, wrote stored procedures and packages per the application requirement such as to load bulk data into tables. Used PLSQL to write/created triggers on tables to fire at various incidents like insert, update, delete etc.
• Experienced in using 11g, 10g features Data Pump, Flash-Back Recovery, AWR, ASM, ADDM, 10g Grid Monitoring, Recycle Bin.
• Experienced in developing RMAN scripts for database back up including hot and cold backup options for both RAC and stand alone instances.
• A

WORK EXPERIENCE:

Confidential, Woonsocket, RI.

Senior ORACLE DBA

Environment: ORACLE 9i,10g and 11g,12c AIX, UNIX

Responsibilities:

• Experience in managing Web based OLTP/DSS database systems with over 2 TB in size.
• Migrated database from Omnicare to CVS with all application functionalities.
• Worked on Tivoli monitoring and Control-M scheduling for backups.
• Upgraded many database from 11g versions to 12c.
• Implemented high level Auditing on databases for security reasons on Hospital records.
• Enabled alerting on specific actions performed by both DBA and Users.
• Implemented scripts to find out the orphan users in the servers. Successfully migrated logins and users between multiple servers.
• Installed, configured, administered and secured SQL Server 20012/2014 on production and Non-production in Clustered and Stand -alone Server Environments.
• Worked in implementing SQL Security and object permissions like maintenance of database creating and users and logins assigning roles to the users and managing user permissions.
• Implemented scripts to find out the orphan users in the servers. Successfully migrated logins and users between multiple servers.
• Implemented oracle RAC server for 2 nodes and 3 nodes in Dataguard environment.
• Implemented Oracle High Availability solution using Oracle 11g Physical Standby. Maintained dataguard and Trouble shoot issues.
• Very good experience in Installation, configuration and maintenance of SQL Server.
• Installing ASM environment and migrating database from NON-ASM to ASM.
• Configured GoldenGate to achieve unidirectional and bidirectional replication.
• Setup GoldenGate User with necessary privileges.
• Resolved replication issues in Goldengate.
• Worked on Exadata servers and many migration works.
• Tuned Backup Scripts to automate the processes like RMAN, and developed Scripts to automate datapump exports for specific schemas on which the clients need a quick restore, and developed SQL scripts for maintaining administration tasks.

Confidential, PA.

Senior Oracle DBA and Modeler

Environment: ORACLE 9i, 10g and 11.2,11.3,11.4, 12c, UNIX, AIX, Exadata

Responsibilities:

• Member of 24x7 support team on both production and development databases with on-call pager.
• Performed Dimensional Modeling (Data Marts, Facts and Dimensions) in both Star Schema and Snowflake Dimensional modeling using Erwin.
• Developed, took care of, and maintained logical and physical ERWin data models, along with corresponding metadata.
• In-depth knowledge of Software Development Lifecycle (SDLC) and AGILE software development methodologies adhering to best practices and industry standards.
• Experienced in ETL, data transformation, conversion and interface.
• Implemented Fast Start Failover on Dataguard on Oracle 11.1 and 11.2 for the purpose of Instant failover whenever the Primary database is down for over a pre-determined time period, the time period being decided upon the Client individual limit.
• Highly involved in Implementation of Exadata servers.
• Did capacity planning and Created new 4 node clusters on AIX boxes and moved over few crucial existing databases to cater better performance and auditing too.
• Extensive experience in implementing high availability and Disaster recovery concepts like Log Shipping, Mirroring and Replication (Snap Shot and Transactional).
• Expert in Data Integrity, Performance Tuning and Query Optimization.
• Created Procedures and PLSQL blocks to enable auditing on Users’ audit output stored in database and the output of Sys Users is stored in flatfiles on the file system as the Hospital Data was critical and necessity was to Audit and send alerts to the concerned to monitor.
• As these various audit trails quickly grow out of control when database activity increases the two challenges of maintaining file system size and table size were addressedto maintain size limits.
• Created the relevant procedures, plsql blocks that enable the Audit and Password verification across 10g and 11g platforms, and the scripts needed to purge the data.
• Arcsight Connectors and Loggers were used to retrieve the data and the Email Alerts were individually sent to the required recipients.
• Upgraded Oracle goldengate v10 to v11 Prepare parameter files for Extraction and Replication
• Install, Configure and maintain Single-node and Multi-node cluster Hadoop cluster.
• Monitor a Hadoop cluster and execute routine administration procedures.
• Maintenance of databases including Oracle patching,backup and restore of database and datafiles.

Confidential, Omaha, NE.

ORACLE DBA

Environment: ORACLE 9i,10g and 11.1,11.2,11.3, UNIX, SUN SOLARIS

Responsibilities:

• Worked on backups using cold, hot and backups and also tested various recovery procedures.
• RMAN scripts for database back up including hot, cold backup for both RAC & standalones.
• Installed and Configured GoldenGate Test, dev and production instances.
• Cross-Train DBAs on Goldengate configuration and replication.
• Configured different levels of replication such as DDL replication, DML replication for table level, schema level, database level using Golden Gate.
• Hands on experience with the new version ODI 12C
• Worked on migrating all the mappings from ODI 11G to ODI 12C.
• Setup different environments like test and dev using database Cloning.
• Installation of 9i, 10g and 11g databases for Testing, Development and Production.
• Experienced in writing functional specifications, translating business requirements to technical specifications, created/maintained/modified data base design document with detailed description of logical entities and physical tables.
• Created PL/SQL procedures (jobs) to automate maintenance tasks.
• Implemented a SQL purging process for Old claim data as per business requirement.
• Troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, Connectivity issues and Security issues etc.
• Developed and automated daily, weekly and monthly counts of Claims by Scheduling the SQL Job.
• Good Conceptual and Logical Data Modeling skills
• Document the plan, execution and process phases and demonstrate the client for approvals.
• Monitoring Growth of tables and undertaking necessary re-organization of database as and when required. Write scripts to monitor tablespace and extent growth.
• Responsible for smooth rollout and keeping a check for the first cycle of Production runs
• Discussed on various denormalization, partitioning and indexing schemes for physical model.
• Worked on Normalization and Denormalization techniques.
• Configured and used Oracle FlashBack for recovery of objects in the database.
• Rebuilding of Indexes for better performance, maintenance of Oracle Database
• Installing ASM environment and migrating database from NON-ASM to ASM.
• Applying patches using OPATCH and patch sets using OUI.
• Developer Environment Setup, Support, Cloning and Refreshes.
• Maintain schemas accordingly and partition tables for different scenarios.

Confidential, Memphis, TN.

ORACLE DBA

Environment: ORACLE 9i,10g and 11g, UNIX, SUN SOLARIS

Responsibilities:

• Experienced in Implementing Oracle High Availability Solution 10g RAC with ASM and Raw Devices and 10g CRS. Experienced in configuring & Managing the ASM
• Worked on Relational and Dimensional Data modeling for creating
• Logical and Physical Design of Database and ER Diagrams, using data modeling tools like ERWIN
• Trained on building Conceptual, Logical and Physical data model.
• Dropped and recreated all the indexes for the foreign keys with new column list.
• Created before update trigger for all the tables to set the update date, update user columns.
• Defined relationships and cardinalities among entities.
• Automation of data load using Korn shell scripting and SQL*Loader.
• Worked on forward & reverse engineering processes. Created scripts to implement model changes.
• Experience of using Oracle Enterprise(OEM), Grid Control, and Data Guard.
• Discuss with users in Designing relevant tables, table spaces, and users for custom applications,Establish more and proper objects names to make it user friendly environment for them.
• Assist with database capacity palaning with Design and Build team.
• Responsible for decisions in setting exact privileges and managing user accounts.
• Defining and Implementation of Backup and Recovery strategies.
• Planned and implemented Disaster Recovery solutions using Oracle 10g Data Guard.
• Developed RMAN scripts for database backup and recovery including hot and cold backup.
• Troubleshoot SQL server database performance issues and tune database objects.
• Experience in maintenance of SQL Server in a VLDB environment & experience in troubleshooting and resolving database problems.
• Created PL/SQL procedures (jobs) to automate maintenance tasks.

Confidential, Jacksonville, FL

ORACLE DBA (Performance Team)

Environment: ORACLE 9i,10g and 11g, LINUX, SUN SOLARIS 9, IBM AIX,NT

Responsibilities:

• Primary DBA for 10 productions and development / testing databases ranging from 100G to 1TB
• Member of Performance team which gets escalations from Off Shore and Primary DBA’s
• Installation and creation of 9i and 10g databases for Testing, Development and Production.
• Installation and Maintenance of Data Guard/Standby database.
• Configured and used Oracle FlashBack for recovery of objects in the database.
• Upgradation of Database from 9i to 10g and applying patches whenever required.
• Developed RMAN scripts for database backup and recovery including hot and cold backup.
• Applying critical patch updates (CPU) released by oracle quarterly.
• Discussed on various denormalization, partitioning and indexing schemes for physical model.
• Installed and Implemented RMAN Backup & Recovery procedures.
• Developed RMAN scripts for database backup and recovery including hot and cold backup options for both RAC and stand alone instances.
• Configured Oracle 10g R2 Grid OEM to monitor database and reports defined by the DBA group.
• Used Erwin Tool to design Physical/Logical design for Database and schemas.
• Recovery of Database (Recovering from Media Failure, recovering tables dropped accidentally, recovering data files, Recovering from Block Corruption)

Confidential, Charlotte, NC

ORACLE DBA

Environment: ORACLE 10g RAC, 9i, RHEL 4.x, SUN SOLARIS 10

Responsibilities:

• Installing 9i and 10g, 11g databases on LINUX and SOLARIS 10.
• Performed database Cloning to setup test and development database.
• Conducting sizing & capacity planning for Oracle databases.
• Upgradation and Migration of Database from 9i to 10g and applying patches whenever required.
• Maintaining schemas and partitioning tables.
• Performance tuning of Oracle Database Objects by fixing row chaining.
• Worked in cross platform migrations from Windows to Linux, Solaris to Linux
• Worked on database upgrades 8i to 9i and 9i to 10g R2.
• Rebuilding of Indexes for better performance, maintenance of Oracle Database
• Creating and drop users, granting and revoking permissions to users/roles as and when required.
• Developed and executed processes supporting SOX audits of Oracle Applications environments.
• Developed the strategy for external data load in to Data Warehouse
• Moved nearly 1 gigabyte of data per day from the source system to the data warehouse.
• Created custom extraction system that populated a data warehouse star schema.

Confidential, Dallas, Texas

ORACLE DBA

Environment: ORACLE 10g, 9i, RHEL 4.x, SUN SOLARIS 9, HP-UX 11

Responsibilities:

• Involved in 24x7 support for both production and development databases with on-call pager
• Installation and creation of 9i and 10g databases for Testing, Development and Production.
• Performed database Cloning to setup test and development database.
• Conducting sizing & capacity planning for Oracle databases.
• Upgrade and Migrate database from 9.2.0.6 to 10.2.0.2 and apply patches whenever required.
• Complete system designing, data model conceptual/physical defining tables, relationship between tables, general domains, and screen design/functionality behind the screen.
• Worked on Entity Relationship Diagram in Models. Reverse and Forward Engineering on Database Models.
• Experienced in dealing with Web based OLTP systems.
• Involved in Database Designing, Logical, Relational Database Diagram, Integrity Constraints and Finally Physical Data Modeling and Normalization.
• Created components detailed design specifications using UML (class, activity, sequence and collaboration diagrams).
• Implemented oracle high availability solution using oracle 10g PHYSICAL STANDBY.
• Managed the PHYSICAL STANDBY including Switchover and Failover scenarios.

Confidential, Iselin, NJ

ORACLE DBA

Environment: ORACLE 10g, 9i and 8i, LINUX, SUN SOLARIS 9, IBM AIX

Responsibilities:

• Involved in 24x7 supports for both production and development databases with on-call pager.
• Installation and creation of 9i and 10g databases for Testing, Development and Production.
• Installation and Maintenance of Data Guard/Standby database.
• Conducting sizing & capacity planning for Oracle databases.
• Upgradation and Migration of Database from 9i to 10g and applying patches whenever required.
• Developed RMAN scripts for database backup and recovery including hot and cold backup.
• Used tools like TKPROF, Explain Plan, ORADEBUG and TRACE file to tune SQL Queries.
• Used ORADEBUG, 10046 and 10053 Trace for troubleshooting the performance issues
• Installed and Implemented Backup & Recovery procedures.
• Automation of backup by creating scripts.
• Tested different recovery scenarios.
• Experienced in using 10g feature Flashback option.
• Recovery of Database (Recovering from Media Failure, recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption)
• Applying patches using OPATCH and patch sets using OUI
• Capacity Planning & Benchmarking using analysis from STATSPACK reports.

Confidential, Philadelphia, PA

ORACLE DBA

Environment: ORACLE 9i and 8i, LINUX, SUN SOLARIS 9, IBM AIX

Responsibilities:

• Installation and creation of 9i and 10g databases for Testing, Development and Production.
• Performed database Cloning to setup test and development database.
• Installation and Maintenance of Oracle database.
• Conducting sizing & capacity planning for Oracle databases.
• Upgrading Database from 8i to 9i and applying patches whenever required.
• Developed RMAN scripts for database backup and recovery including hot and cold backup.
• Installed and Implemented Backup & Recovery procedures.
• Monitor growth of tables and take necessary re-organization of database as and when required.
• Created PL/SQL procedures (jobs) to automate maintenance tasks.
• Write SQL scripts to monitor tablespace and extent growth.
• Applying patches using OPATCH and patch sets using OUI
• Capacity Planning & Benchmarking using analysis from STATSPACK reports.
• Installing 9i for TEST and Development.
• Developing shell script to automate the processes.
• Create table spaces, tables, and users for custom applications.
• Create and drop users, granting and revoking permissions to users/roles as and when required.
• Installed and Implemented Backup & Recovery procedures.
• Developed RMAN scripts for database backup and recovery including hot and cold backup.
• Upgrading and migrating the databases.
• Capacity Planning & Benchmarking.
• Database export/import using exp and imp utilities.