SUMMARY:

• Confidential is an Oracle Database Administrator Certified Professional (OCP - DBA) with 16 years of experience in the designing, installation, administration, performance tuning, backup & recovery, cloning, upgrades, patching, migration, production support, troubleshooting, implementation, testing and maintenance of Oracle 8, 8i, 9i, 10g, 11g and 12c databases on both Unix (AIX, HP-Unix, Redhat Linux) and Windows platforms.
• He has experience in managing large databases up to the size of 30TB. Confidential has hands on experience in configuration and maintenance of Real Applications Clusters (RAC) databases, ASM, Data Guard for standby databases and Advanced Replication.
• He has extensive experience in Oracle GoldenGate for faster databases replication. He has 3 years of experience in configure and manage Exadata databases.
• He has hands on experience in configuring column level and tablespace level encryption and snapshot standby databases. Configure and monitor databases with 12c Cloud Control.
• He has expert level knowledge to administer and monitor databases using third party tools such as Toad DBA suite, Spotlight on Oracle RAC, DBArtisian etc.
• He is expert at create and tune PL/SQL stored procedures, functions, packages, triggers as well as complex SQL queries.
• He has excellent communication and interpersonal skills.
• He has about 2 years of experience each with DB2, SQL Server and Postgres databases.

TECHNICAL SKILLS:

Operating Systems: AIX 5.2,5.3,6.1,7.1 RedHat Linux 3,4,5,6.4,6.8, Oracle Solaris 10, 11 HP-UX 11i, Windows 2000/2003/ NT/2012

Databases: Oracle 8, 8i, 9i, 10g, 11g & 12c, Postgres 8.3, DB2 10.1, 10.5, SQL Server 2008 * 2012

Database Utilities: Exp, expdp, imp, impdp, RMAN, SQL Loader, SQL &PL/SQL Developers

Oracle DB admin tools: 10g/11g Oracle Enterprise Manager through database control and grid control, Oracle 12c Cloud control.

Third Party Admin Tools: Performance analysis from Quest for oracle, TOAD DBA suite for Oracle RAC, Spotlight on Oracle RAC, DBArtisan XE2/9.0

Remote Login Tools: Putty, Hummingbird Connectivity V7.1, Citrix ICA Client

Development Tools: Developer 2000, Visual Basic 6.0, Power Builder 4.0

Storage: SAN RAID 5 & 10, NAS, Fusion I/O

PROFESSIONAL EXPERIENCE:

Sr. Database Administrator

Confidential, Salt Lake City, UT

Responsibilities:

• Install and configure Oracle WebLogic and fusion middleware
• Install and configure Oracle Identity Manager and Oracle Internet Directory
• Install and configure Oracle Access Manager.
• Support and Administer Oracle databases of versions 11g and 12c.
• Setup RMAN full, incremental and archived log backups for the databases.
• Configure Active standby database with Dataguard.
• Tune the databases and queries using AWR, ADDM and ASH reports and using Oracle 12c cloud control.

Sr. Database Administrator

Confidential, Carrollton, TX

Responsibilities:

• Support and Administer Oracle databases of versions 9i, 10g, 11g and 12c.
• Administer single node and multi-node RAC databases.
• Support 12c M ultitenant container databases.
• Configure and maintain oracle Exadata databases.
• Support and manage replication vis GoldenGate.
• Migrated Oracle databases to AWS Cloud .
• Manage and Administer Oracle databases on AWS Cloud .
• Support and manage DataGuard for standby databases.
• Converted physical standby database to snapshot standby database and vice versa for production application performance testing.
• Add ASM storage as necessary.
• Monitor and Manage RMAN backups.
• Tune the databases and queries using AWR, ADDM and ASH reports and using Oracle 12c cloud control.
• Support database environments through SM9 ticketing system.

Environment: Oracle 9i, 10g, 11g and 12c, ASM, RAC, Active Data Guard, Tablespace Encryption, Snapshot Standby, Red Hat Enterprise Linux 5, 6.4, Oracle Solaris 10, 11, Exadata, GoldenGate, Oracle 12c Cloud control, Toad DBA suite

Sr. Database Administrator

Confidential, Irving, TX

Responsibilities:

• Manage multi-client databases especially databases involving VISA and PNC Bank data.
• Administer and Maintain 4 node RAC in 11g and 12c environments.
• Configure and maintain oracle Exadata databases.
• Migrated Oracle databases to AWS Cloud .
• Manage and Administer Oracle databases on AWS Cloud .
• Upgrade single node and RAC databases from 11g to 12c. I also upgraded standby databases from 11g to 12c.
• Configure physical local and remote standby databases and then configure Data Guard broker for real time apply.
• Converted physical standby database to snapshot standby database and vice versa for production application performance testing.
• Configure ASM database instances and disk groups and add disks as necessary.
• Implemented Tablespace(TDE) and Column level encryption to protect critical financial data at rest(backups)
• Duplicate Production database with RMAN as UAT databases on the quarterly basis.
• Restore the database to previous point in time using database flashback from the restore point as well as restore the databases using RMAN backups as necessary.
• Create and deploy database package to export and drop the partitions whenever the size of the segment exceed certain limit.
• Used LogMiner to analyze data from Redo and Archived logs files and undo unwanted changes.
• Apply PSU patches on the GRID and RDBMS Oracle Homes on quarterly basis.
• Implement full, cumulative, incremental and archivelog backups using RMAN.
• Use RMAN incrementally updated backup for faster restore time.
• Install, Configure and Maintain Oracle Golden Gate for Multi-Master Replication
• Tune the databases and queries using AWR, ADDM and ASH reports and using Oracle 12c cloud control.
• Review and approve schema and code changes.
• Performs the capacity planning required to create and maintain the databases.
• Control migrations of all schema objects and code changes
• Assists with impact analysis of any changes made to the database objects.

Environment: Oracle 11g and 12c, ASM, RAC, Active Data Guard, Tablespace Encryption, Snapshot Standby, Red Hat Enterprise Linux 5, 6.4, Oracle 12c Cloud control, Toad DBA suite

Sr. Database Administrator

Confidential, Fort Worth, TX

Responsibilities:

• Configure, administer and tune Oracle data warehouse database (of 12 terabytes in size) as well as Oracle OLTP databases.
• Configure and administer active and passive standby databases with Data Guard
• Install and configure diskgroups with ASM for 20 Terabytes SAN storage required for RAC
• Configure and manage RAC database instances
• Created Recovery catalog and implement RMAN full(level 0), incremental (level 1) and archivelog backups.
• Restored and recovered Production databases to a specific point in time from RMAN backup. Recovery was performed due to User and DBA errors.
• Implemented RMAN Incrementally updated backup for point of sale database.
• Migrate databases from 8i to 11g, 10g to 11g and 10g to 12c versions.
• Install, Configure and Maintain Oracle GoldenGate for One way Replication
• Work closely with developers to tune SQLs and PL/SQLS
• Partition database tables and indexes to improve query performance.
• Responsible for physical database design and work closely with Data Warehouse Architect for logical design.
• Tune the databases and servers for optimal performance.
• Work on I/O, CPU, Memory, network, lock etc waits.
• Backup database schemas and tables using data pump export.
• Create and administer DB2 databases.
• Configure and schedule online and offline DB2 backups.
• Apply Oracle and DB2 patches to remediate quarterly security issues.
• Involved in On Call rotation for Oracle, DB2 and SQL Server databases.
• Trained and mentored three Oracle DBAs

Environment: Oracle 12c,11g,10g,9i & 8i, AIX 5.3, 6.1, 7.1 Red Hat Enterprise Linux 5, 6.4, Oracle 12c Cloud control, Toad DBA suite, Performance Analysis for Oracle from Dell.

Sr. Database Administrator

Confidential, Dover, NH

Responsibilities:

• Gather data requirements for capacity planning from Architect & MDM team Lead
• Estimate and request for 20 Terabytes SAN storage required for PROD, QA RAC databases as well as PROD standby database.
• Install and configure diskgroups with ASM for 20 Terabytes SAN storage required for RAC
• Estimate and request for 13 Terabytes NAS storage required for RMAN level 0 & 1 backups and datapump export dumps required for PROD and QA.
• Advice OS configuration parameters to sysadmin and then configure database instances for RAC
• Create resource groups & RAC services in the databases. Then make changes to connection entries (jdbc & tns) in Siperian application, GoldenGate and Informatica nodes as well as developers so that application and users will connect the database instances through their respective database services.
• Configure physical standby database with Data Guard
• Prepare and tune RMAN level 0 backup scripts so that whole database with 6 Terabytes in size completes in 7 hours.
• Prepare and tune RMAN level 1 backup scripts to shorten the run time to 15 minutes.
• Tune database configuration parameters
• Monitor and tune database memory (SGA & PGA), I/O, resource & lock contention etc.
• Work closely with developers and tune SQL queries and PL/SQL programs
• Mentor Oracle DBAs for Oracle standard practices to run the database at the optimal level.
• Help Oracle DBAs to resolve Oracle database issues
• Used AWR & ADDM reports to diagnose and tune database issues.
• Used OEM to monitor and tune databases
• Configured and diagnose the database with Spotlight on Oracle for RAC (Quest tool)
• Backup as well as migrate schemas and tables through datapump
• Applied patches to the database
• Created range and list partitions on tables to improve queries performance

Environment: Oracle 11.1.0.7 & 11.2.0.1, SAN, NAS, ASM, Red Hat Enterprise Linux 5, 11g OEM through Database Control and Grid Control, Toad DBA suite for RAC, Spotlight on Oracle for RAC, Siperian, Informatica

Sr. Database Administrator

Confidential, New York, NY

Responsibilities:

• Configure and used RMAN for full and incremental level 0 & 1 database backup and recovery
• Configure and use Data Pump for database backups.
• Used RMAN & Data Pump to move tablespaces between databases across different platforms
• Configure & Administer ASM instance, Cluster ready software and RAC database instances. I configured three RAC instances (three nodes) for PROD database.
• Configure & Monitor Physical standby database for PROD database using Data Guard.
• Migrated databases from 9i to 11g. Gather 11g & 10g new, deprecated and obsolete features at SQL, PL/SQL and DBA level and worked on implementing these changes.
• Extensively worked to build PL/SQL programs and SQL queries for database and application needs.
• Tuned PL/SQL programs and SQL queries to reduce load on the server and to improve the performance. Worked with ADDM, AWR and Perfstat to diagnose and improve the performance of the databases.
• Tuned memory, I/O,CPU, undo and redo usage
• Implemented database replication using Oracle 11g GoldenGate.
• Applied database patches.
• Applied one off patches with Opatch utility
• Configured 11g grid control to monitor and diagnose databases.
• Configured Spotlight on Oracle (from Quest) to monitor and diagnose databases.
• Extensively used Toad DBA suite for database admin tasks.
• Partitioned and maintained the tables of 1.1 billion rows
• I have written shell scripts extensively.

Environment: Oracle 9.2.0.7, Oracle 11.2.0.1, Postgres 8.3, Redhat Linux 4.0, Python and Shell scripts, 11g Grid Control, Toad DBA suite, Spotlight on Oracle.

Sr. Database Administrator

Confidential, Westlake Village, CA

Responsibilities:

• Installed Oracle 10g database software in Windows 2003 OS.
• Configured Physical Standby database as DR for Production database using Data Guard.
• Performed Fail over tests for standby database by activating it every three months.
• Configured 10g Grid control for Oracle Databases located in different servers
• Install, configure Oracle software for Real Application Clusters (RAC).
• Create and maintain databases in RAC configuration. Migrated existing databases into RAC configuration.
• Configure ASM database for space management. Applied 10.2.0.3 security patch to 10.2.0.1 databases.
• Develop, implement and schedule database backups using RMAN.
• Create recovery catalog database for RMAN backups. Developed and Implemented hot backup scripts for databases.
• Developed and Implemented Export and Import scripts at schema level.
• Load and Unload database data using Expdp and Impdp utilities.
• Monitor, diagnose and tune the databases with spotlight, AWR, ADDM, data dictionary views, etc.,
• Tune the SQL queries with explain plan, SQL Trace, TKPROF, Auto trace, AWR snapshots.
• Monitor and resolve deadlock issues.
• Partition and maintain database tables as required. Create users, grant and revoke privileges for users
• Monitor and tune to improve the performance of the databases.
• Worked closely with application users to meet their requests
• Setup email and pager notification to alert when listener and database service is stopped.
• Setup email and pager notification on tablespaces free space. Provided On-Call support

Environment: Oracle 10.2.0.3.0 , Windows 2003, Data Guard, 10g Grid control, RAC, ASM, RMAN

Sr. Database Administrator

Confidential, North Quincy, MA

Responsibilities:

• Installed Oracle 10g database software release 1 and release 2 in new Redhat
• Linux servers and HP-UX servers for Development, Acceptance and Production regions.
• Migrated Development, Acceptance and Production databases from Oracle 9i in HP-UX servers to Oracle10G on Redhat Linux Servers.
• Implemented Multi-Master Replication for the databases for which most of the schema tables have primary keys.
• Configured physical Standby databases using Data Guard for the databases for which most of the schema tables does not have primary keys.
• Install, configure Oracle ASM database.
• Install 10g Cluster Ready Services software
• Create and configure Oracle RAC database and its instances in three nodes.
• Configured 10g Grid control for the databases located in different servers so that we can centralize the DBA activities(database monitoring and tuning)
• Scheduled and implemented hot backups for the databases through cron as well as RMAN.
• Scheduled and monitored the jobs that are scheduled through cron, dbms job and dbms scheduler packages.
• Providing the database security by creating users and granting appropriate privileges, application roles to the users.
• Apply patches for Oracle databases as needed. Cloned databases for training
• Recovery of databases from the backups in case of database crashes
• Monitor the databases through third party tools such as Quest Central, TOAD, DBArtician and Oracle tool OEM.
• Tuned the databases through Quest Central tool Spotlight. Resolved deadlocks and wait events issues. Developed and implemented the scripts to archive the database data.
• Contacted Oracle through TAR to resolve unknown issues.
• Developed and scheduled the stored procedures to copy the data First week of every month from OLTP production to data warehouse databases. Provided on-call support
• Worked closely with the application developers to improve the coding standards
• Performed typical day today DBA activities

Environment: Oracle 10.2.0.3.0 , 10.1.0.2.0 , 9.2.0.4, 8.1.7, HP-UX 11i, Red Hat Linux 3.0/4.0, EMC Symmetrix DMX RAID 5, SAN BOX, Data Guard, 10g Grid Control, Quest Central for databases 5.0.1, Spotlight, Embarcadero DBArtisian 7.3.0, TOAD for Oracle 8.5.1, Hummingbird Connectivity V7.1, Lotus Notes 6.0,Citrix ICA Client

Database Administrator

Confidential

Responsibilities:

• Installing oracle and related products, creating and maintaining oracle databases.
• Creating and defining storage parameters for tablespaces, tables, indexes, clusters and other database objects. Creating users and creating and assigning profiles
• Managing connectivity problems with oracle databases from the client side.
• Managing SGA and monitoring the performance of the servers.
• Troubleshooting day-today problems. Tuning databases whenever necessary
• Tuning SQL statements by explain plain, Oracle trace and TKPROF utilities

Environment: Oracle 9i, 10G, AIX 5.3, Windows 2003, Quest Central 4.5, TOAD, OEM, RMAN, SQL* loader, STATSPACK

Database Administrator

Confidential

Responsibilities:

• Oracle Installation, create, configure Oracle 8i and Oracle 9i databases.
• Upgraded Oracle8i databases to Oracle 9i databases.
• Scheduling and monitoring of Jobs on weekly and monthly basis.
• Monitoring the performance of the Servers.
• Monitoring the logical (Exp & Imp) backups by schema wise and taking online physical Backups of all databases. User administration, define roles & profiles and partitioning tables.
• Managing System Global Area. Importing the test dump files from latest backups as requested.
• Monitoring CPU utilization, I/O and memory. Monitoring the recovery process of the standby servers at GEMS Foundation and Bangalore DRP site.

Environment: Oracle 9i enterprise edition, Oracle 8i standard edition, AIX 5.2, RMAN, OEM, Toad, Data Guard, SQL* Loader

Database Administrator

Confidential

Responsibilities:

• Install, configure, upgrade and day-to-day maintenance of databases in production and test servers.
• Scheduled exports of structures all logical objects in the database twice a day (that is at 1 am and 1 pm).
• Creating and monitoring physical standby databases which are in different locations for production databases and ensuring the disaster recovery for the production database by switching database users from primary to physical standby database.
• Defining storage parameters for tables, indexes, clusters, table spaces, rollback segments, redo logs and data files
• User administration, define roles & profiles and partitioning tables.
• Tracking database security and auditing. Managing System Global Area
• Monitoring and troubleshooting auto extension of table spaces
• Design and implementation of backup and recovery strategy using tools, such as RMAN.
• User managed and RMAN managed Backups, Restore and recovery
• Exporting & importing of database data and table structure as needed
• Standby databases for Production systems. Creation of stored procedures, packages and triggers
• Loading of Data from flat files into the Database using SQL*Loader
• Monitor database and system performance
• Tuning SQL Statements, I/O operations, memory and contention

Environment: Oracle 8i enterprise edition (8.1.7), Windows2000/NT, RMAN, Oracle Enterprise Manager, DBArtisan