SUMMARY:

• Over 10 years of Oracle DBA experience.
• Expertise in Oracle Installation, Database configuration and upgrade, administration, backup and recovery, troubleshooting of various oracle products/versions 9i / 10g/11g.
• Have provided database support on large environments (24x7 Data Warehouse) upto 5TB including achievements in DW Data Model changes.
• Experienced on different platforms covering UNIX, Linux and Windows.
• Excellent Logical and Physical Oracle Database Design skills.
• Space Management, User Management, Roles & Privileges.
• Experienced in creation of Standby Databases and Data Guard Architecture.
• Experienced in Installation and Administration of Oracle 9i RAC.
• Have experience in data warehousing concepts and ETL Tool like AbInitio.Have worked on various production/ development projects and is experienced in data loading.
• Experienced in Solaris/Linux administration, Monitoring Swap Space, Process Management, Working with remote machines using rlogin, ssh, telnet, Putty, ftp etc.
• User and group Management, Scheduling cron jobs and Shell Scripting.
• Have my own hot backup/cold backup, Export, Import and performance tuning scripts.
• Very Strong in Dataguard and performance tuning, scheduled jobs using the job scheduler and UNIX cron.
• Created (Dataguard) physical standby database as DR Solution for production database using RMAN create standby database command, also setup Data Guard Broker to manage data guard environment.
• Upgraded Oracle Databases using Database Upgrade Assistant, Migprep and Export/Import utilities in a highly compressed time frame for smooth and successful migration.
• Involved in SQL Replication for copying & distributing data and database objects from one database to other and then synchronizing to maintain consistency.
• Also very much familiar with SQL Migration.
• Experienced in trouble shooting like application level tkprof/explain plan, Database level schema management, Index Creation, partitioning, locally managed Tablespaces, Bitmap indexes, reverse key indices etc,OS level using SAR, VMSTAT, IOSTAT and TOP tools and network levels.
• Experienced in Database Sizing, Capacity Planning and building Very Large and High Performance Databases, Oracle Streams. Very Much involved in Benchmarking and Server selection.
• Oracle Database tuning for long running concurrent jobs using Stats pack, TKPROF, etc.
• Experienced in mentoring junior DBAs and documenting the dba standards/ work book. Involved in documenting the application as I consider it as one of the most important things to do.
• Excellent project planning, budgeting and prioritization skills.
• Apart from these, the value addition I bring to the table is in terms of a vast experience coupled with a complete commitment to the project at hand.

TECHNICAL SKILLS:

Sun Solaris 2.8, Linux, Unix, Windows 95/98/2000/NT, Windows 2000 Advance server, PL - SQL, SQL,UNIX Shell, Oracle 8.0/8i/9i/10g, Sql Server, Developer 2000, Designer 2000, SQL*Loader,Data guard,TOAD, PL Editor, RMAN, Oracle Enterprise Manager, TOAD, SQL Loader, Query Analyzer, PL/SQL Developer, Remedy, Clarify., Sun SPARC-III, Pentium III, Pentium IV, Erwin, Designer 2000, VISIO.

PROFESSIONAL EXPERIENCE:

Confidential, Des Moines, IA

Database Administrator

Responsibilities:

• Managing and Administrating oracle 10g/RAC databases in Unix Environment.
• Oracle Database tuning for long running concurrent jobs using Stats pack, TKPROF, etc.
• Applied Oracle Streams for Capturing, Staging and Consuming data.
• Applied Load Balancing between sites to provide scalability and availability of data to end users.
• Planning and creation of OLTP databases and Data Warehouse using Oracle 10g.
• Monitoring and optimizing the performance of Oracle databases using Oracle OEM, AWR and SQL scripts for the 4 node RAC Instances.
• Worked on the Materialized Views refresh process by scheduling them thru the DBMS Scheduler Job and Grid Control Job.
• Change management using Oracle OEM and SVN.
• Modification of database structure as through JIRA Tickets.
• Developed a full set of standard procedures for installation, backup, restoration, and tuning; primarily from the application perspective.
• Provided leadership on issues such as standard SQL*Net configurations, archive strategies, security management, and monitoring strategies.
• Applied strong technical expertise in application tuning, complex view creation, tuning of troublesome SQL statements, stored procedure and snapshot strategy.
• Job scheduling using crontab.
• Monitoring the health of the database by generating AWR reports.
• Performed Standby configurations for our various Primary servers.
• Security Auditing for users.
• Implemented database backup strategies using RMAN utility.

Confidential

Database Administrator

Responsibilities:

• Involved in the database migration from Oracle 9i to Oracle 10g.
• Migration from Solaris to AIX.
• Involved in SQL Replication for copying & distributing data and database objects from one database to other and then synchronizing to maintain consistency.
• Also very much familiar with SQL Migration.
• Created & rebuild indexes for better performance
• Row Migration and Row Chaining as per healthcheck.
• Security Auditing for users.
• Managing and Administrating oracle 9i/RAC databases in Unix Environment.
• Oracle Database tuning for long running concurrent jobs using Stats pack, TKPROF, etc.
• Applied Oracle Streams for Capturing, Staging and Consuming data.
• Applied Load Balancing between sites to provide scalability and availability of data to end users.

Confidential, Nutley, NJ

Lead Oracle DBA

Responsibilities:

• Managed team of 5 Jr. DBAs. Defining their roles and responsibilities.
• Space Management, User Management, Roles & Privileges.
• Allocating and re-organization of tablespaces.
• Defined process for Data migration, process automation.
• Involved in Database Support to SOE Migration. Managing multiple databases.
• Created & rebuild indexes for better performance
• Row Migration and Row Chaining as per healthcheck.
• Managed key functional activities related to database management for various projects. Installation, database creation, configured as per Migratiwon requirement.
• Involved in Version Upgrade, Installing patches.
• Backup, restore & recovery of database using Exp/Imp Utility
• Recovering objects from Flashback Area.
• Performance tuning for migration processes.
• Security Auditing for users.
• Monitoring daily loads and to collect statistics for tuning
• Tuning Database and Instances
• Managing and Administrating oracle 9i/RAC databases in Unix Environment.
• Involved in Database replication, creating and managing materialized views.
• Defined replication process for non-oracle based database to oracle, like MS SQL server to Oracle, MS Access to Oracle, MySQL to Oracle etc. Tuning replication processes.
• Involved in Delta management setup for Data warehousing, Oracle Stream POC.
• Involved in Automation of various processes thru Unix Shell scripts.
• Designed, developed & implemented the standby database/data guard strategy not only for failover but also for the backup purpose.

Confidential, Princeton, NJ

Lead Oracle DBA

Responsibilities:

• Space Management, User Management, Roles & Privileges.
• Allocating and re-organization of tablespaces.
• Developed a full set of standard procedures for installation, backup, restoration, and tuning; primarily from the application perspective.
• Provided leadership on issues such as standard SQL*Net configurations, archive strategies, security management, and monitoring strategies.
• Applied strong technical expertise in application tuning, complex view creation, tuning of troublesome SQL statements, stored procedure and snapshot strategy.
• Infrequently document management creation and Maintain DB objects and code in source controls / GE libraries.
• Job scheduling using crontab.
• Monitoring the health of the database by generating AWR reports.
• Resolved tickets raised by the Business users and tuning ad-hoc queries requested from business.
• Performed Standby configurations for our various Primary servers.
• Security Auditing for users.
• Implemented database backup strategies using RMAN utility.

Confidential, Princeton, NJ

Sr. Oracle DBA

Responsibilities:

• Developed support covering 4 Major databases in different phases of the project Dev, Integration, System Testing, UAT, Pilot and Launch.
• Granted access to various database objects to the Business users with giving specific privileges to access specific data. Creation of Indexes, Materialized views to improve performance.
• Configured and implemented RMAN utility for backups and recovery.
• Configured Oracle Standby databases for the mission critical 24X7 databases.
• Created and Maintained Documentation of databases and the related products.
• Created databases, performing upgradation from version Oracle 9.2.0.4 to Oracle 9.2.0.8.

Confidential, Shelton, CT

Sr. Oracle DBA

Responsibilities:

• Involved in Design using ERWIN Model Manager, generating LDMs and PDMs, IR/Bugs/Defects Analysis & Fixing.
• DBA Support during different phases of the project DEV, Integration, System Testing, UAT, Pilot and Launch.
• Created Process to migrate the DB and Data changes to different environments.
• Tracking the change controls and implementation
• Involved in designing processes for merging the R1 and R2 databases.
• Extensively used TOAD, SQL Loader Excel Macro for Database changes and Data Loading
• Data Analysis and validation of data by discussing with GE Business.
• Project Management - Tools like preparing MOM, Process Maps, FMEA
• Tracking the changes through MKS- Integrity Server.

Confidential

Oracle DBA

Responsibilities:

• Extended support for Daily Data Loads for the loads to get completed within agreed SLA time, supporting business users for smooth extraction of the data from the DWH for the analysis and trending by tuning the queries of business users.
• Created and managed Database objects like tables, Indexes with daily, weekly and monthly partitions and sub partitions to support daily loads and keeping database statistics up-to-date for better performance.
• Granted access to various database objects to the Business users with giving specific privileges to access specific data.
• Performed data model changes for various implementations of projects without affecting the daily database loads and usage by business users.
• Ticket Management- Tickets are normally for the following issues: ETL Load failure, ETL Load long running issues, Performance Related Errors, Rollback Segment Error, Temporary Segment Error, User’s request for access/privilege to a table etc.
• Merged and accommodated new client’s data to the data warehouse whenever a new client adds up to business. Allocating space for history data,capacity and growth planning for future data.
• Special skills include understanding the business processes, technology, capacity planning and projecting future requirement.
• Involve in Discussion with Development people for suggestions on project to improve the performance when system goes live.

Confidential

Database Administrator-Offshore

Responsibilities:

• Primarily involved in CDCI DW migration process and coordinated with RUN team to develop the scripts necessary to run on the Production server.
• Extended Offshore Build support for the CDCI 24x7 Data warehouse during implementations.
• Created database objects like Table, indexes with Daily, monthly and yearly List partitions and Hash Partitioning options.
• Analyzed the tables, rebuilding the indexes for the performance gain during the query execution. Monitoring the space usage and Tablespace Growth during the Graph generation in the ETL processes, coordinating with ETL team during the production and resolving issues.
• Monitored the performance and tuning the large queries in the Warehouse reporting process.

Confidential

Database Administrator-Offshore

Responsibilities:

• Database support for development team.
• Oracle Software Installation and Database creation.
• Schema refresh as per request.
• Executing user requests as per mails.
• Granted access to various database objects to the Business users with giving specific privileges to access specific data.
• Space Management, User Management, Roles & Privileges.
• Allocating and re-organization of tablespaces.
• Data Analysis and validation of data by discussing with BP Business.
• Job scheduling using crontab.