SUMMARY:

• Sixteen + years of experience in managing Production Grade Database Systems and Systems administration.
• Expertise in Installation, Administration and Maintenance of multi terabyte mission critical production databases on various platforms.
• Strong knowledge of High database availability: Oracle RAC, Dataguard, RMAN, ASM.

TECHNICAL SKILLS:

Databases: ORACLE 7.0/8i/9i,10g,11g,12c MS SQLServer, MySQL

Operating System: Sun Solaris, Linux, IBM AIX Windows Server.

Appliance: Oracle Exadata X6,X3 - 2, V2.

Languages: Developer 2000, Visual Basic, C, awk, Shell Scripts, PL/SQL, COBOL

ERP: Oracle EBS 11i,R12

Backup Tools: RMAN, VERITAS NetBackup, Tivoli, EMC Networker, AcronisApp Server: Oracle Application serverDB Tools: Oracle Enterprise manager, VMWARE, TOAD, Spotlight, BMC Patrol.

PROFESSIONAL EXPERIENCE:

Confidential

Senior Oracle Database Administrator

Responsibilities:

• Support Oracle Exadata X6, X3-2, V2’s data warehouse environment
• Worked with Oracle support to configure and install Exadata appliances.
• Migration of database from legacy to exadata V2, X3 and X6.
• Support for Oracle 11g, 12c in standalone and RAC environment.
• Perform various 11g to 12c upgrades which includes
• Upgrade of Oracle Grid infrastructure from 11g to 12c.
• Upgrade of Oracle databases from 11g to 12c and apply Oracle PSU patches.
• Performance database tuning of oracle databases.
• Implemented Oracle TDE on 11g and 12c databases and upgraded them as part of 12c upgrades.
• Environment refreshes using Oracle datapump.
• Oracle OR and DR using active dataguard.
• Backup and recovery of databases using RMAN.
• Implemented database auditing and security for compliance.
• Merger of databases from Confidential to Confidential Inc. This includes data migration using Sql loader,Sql developer and datapump.
• Responsible for Exadata, Oracle database patch management to keep databases up-to date with CPU patches.
• Setup of Oracle Goldengate environments.
• Engage with Oracle support and other software vendors to manage and resolve critical database issues.

Confidential

Senior Oracle Database Administrator

Responsibilities:

• Responsible for administration of business critical multi-terabyte Oracle databases that includes Specialty databases, Auto med databases. Responsible for administration of Oracle Financials databases. Implemented two node 11g R2 RAC database instances on Solaris environment. Responsible for testing Oracle Disaster recovery procedures. Responsible for administration of Oracle data guard, Active data guard for reporting purposes. Implemented auditing and security of database for HIPAA, SOX compliance. Created UNIX shell scripts for database maintenance tasks. Responsible for on-call as part of 24/7 on call database support team.

Confidential

Senior Oracle Database Administrator

Responsibilities:

• Responsible for administration of multi-terabyte Oracle databases. Deployed Oracle Exadata X3-2, V2’s deployment for data warehouse. As part of build team deployed REMODEL, Loyalty, WISE database RAC infrastructure. Migrated multi-terabyte databases from standalone environment to Exadata RAC using Oracle Dataguard. Deployed RX-Central centralized pharmacy database on Oracle for several Confidential pharmacy stores. Implemented several multi node 11g R1,R2 RAC database instances on Solaris and Red Hat Linux. Implemented RAC to single instance / RAC Oracle dataguard for DR solution.
• Converted Oracle dataguard into Active data guard for reporting and DR purposes. Responsible for support and administration of multiple RAC databases on SUN Solaris and Exadata. Implemented Oracle Database Vault on Exadata (RAC). Implemented Oracle Encryption- TDE on Oracle databases. Implemented auditing and security of database for HIPAA, SOX compliance. Installed and configured Oracle Golden gate for data migration. Created UNIX shell scripts for database maintenance tasks. Responsible for database refreshes from Production to QA and development environments. Masked sensitive data in development environment using Oracle Grid Control Data masking. Implemented and configured Oracle 10,11g grid control software for central administration, setup alerts to
• Configured/tuned RMAN hot backups using virtual tape libraries. Performed critical database recovery on various production databases using RMAN, hot backups. Setup and manage Oracle Networking, connectivity of the applications to Server. Responsible for on call team provide 24/7 database support for critical production databases. Performed several critical production 9i/10g to 11g database upgrades. Responsible for database patch management to keep databases up-to date with CPU patches. Interface with Oracle support and other software vendors to manage and resolve critical database issues.

Confidential

Lead Database Administrator

Responsibilities:

• Responsible for administration and availability for Oracle Financials 11.5.10, R12, Peoplesoft 8, and EMC’s
• Documentum D5 production databases.
• Oracle 8i, 9i and 10g database administration and maintenance on Sun Solaris, Oracle/ Red hat Linux and
• Ms Window servers.
• Implemented and configured Oracle 10g grid control software and alerts to monitor all company wide
• Production, QA/Dev/Test databases.
• Configured reports on Oracle Enterprise manager grid control for historical database growth for storage planning and critical tablespaces. Responsible for EBS 11i, R12 administration: environment refreshes, Patch deployment. Automated and implemented scheduled database jobs from OEM grid with critical email and page alerts. For Disaster recovery and high availability implemented Oracle 8i, 9i and 10g Data Guard (physical standby
• Database) for primary production servers.
• Designed physical database for Production and development servers. Performed database upgrades - Oracle 8i database 8.1.7 to 9i, 9i to Oracle 10g. Automated database activity using stored procedures and triggers. Responsible for monitoring table spaces and segments space allocation. Implemented Oracle Transparent Gateways on MS SQL server to query MS SQL Server tables from Oracle database. Used tools like Spotlight, Toad, and OEM grid to monitor databases and optimize performance of the
• Databases .
• Deployed custom procedure to capture TOP 10 SQL on all the production databases using STATSPACK for
• Performance tuning of applications.
• Deployed database procedures to alert critical user password expiration dates. Responsible for applying latest software release, critical database patches to the databases. Creation of DB links, Snapshots for replication of database objects from remote Oracle database sites. Generation or various database related reports using SQL Plus, Crystal reports, SQL server 2000 reporting services. Designed and developed table structure PL*SQL stored procedures and database triggers to implement
• Business rules.
• Created scheduled RMAN backups for multi terabyte production databases to disks and tapes using Veritas
• Netbackup.
• Deployed Oracle 11g database for RMAN recovery catalog on Sun Solaris. Configured Hot /Cold backups using disk based solution for enabling disaster recovery on a nightly basis. Performed critical database recovery on various production databases using RMAN, hot backups. Implemented and documented procedures to perform database cloning from production to QA environment. Implemented schema level Oracle streams for data replication. Setup and manage Oracle Networking, connectivity of the applications to Server. As part of on call team provide 24/7 database support for critical production databases. Implemented auditing and security of database for Sarbanes Oxley compliance. Interface with Oracle support and other software vendors to manage and resolve critical database issues. Setup and maintenance on Oracle Application web servers using hardware load balancers. Implemented several multi node
• RAC database instances on Red hat and Oracle Enterprise Linux for high availability and Scalability. Responsible for support and administration of multiple RAC databases. Created Oracle Hyperion, OBIEE databases on oracle RAC using ASM to integrate with Oracle financials. Configured RMAN backup and recovery strategies for RAC databases. Performed RAC server moves across datacenters and restored it on different SAN environment. Setup Oracle 11g RAC environment on Oracle Enterprise Linux for QA testing. Converted single instances running on regular file systems to run on oracle ASM. Installation, Administration and maintenance of multiple Oracle Application Servers version 10.1.3 using

Confidential

ORACLE Database Administrator

Responsibilities:

• Oracle 8i, 9i Setup and 24/7 Maintenance on Sun Solaris. Responsible for administration of 700+ GB sized database. Designed physical database for Production and development servers. Upgraded 8i database 8.1.7 to 9i using logical exports. Managing multiple instances (Production and Development) on single machine. Responsible for monitoring table spaces and segments space allocation. Fine tuning of the Oracle and OS level parameters to optimize performance of the instance. Creation of DB links, Snapshots for replication of database objects from remote database. Generation or various database related reports using SQL* Plus. Designed and developed table structure PL*SQL stored procedures and database triggers to implement business rules. Used ERWIN tools for ER Diagram and to implement business rules for table’s structures and database triggers Loading data into the database using SQL*
• Loader. Creation of Hot Backups for enabling disaster recovery on a nightly basis. Setup and manage Oracle Networking using NET8: connectivity of Clients to Server (ODBC). Performance tuning for history tables which are as big as 1.5 million rows to access the data faster. Assisting and designing applications in FORMS 6i. Debug database and system problems related to SQL programming. Apply application and database patches. Documentation of the dataflow and system design. Monitored database via OEM and trace/alert logs Backup of Database on DLT tapes.

Confidential

On site support engineer

Responsibilities:

• Database administration on Windows 2003/2000/Advance Servers.
• SQL Server database user administration. Create maintenance plans for database backups. Restore databases to test disaster recovery plans. LAN setup, Installation, maintenance, Administration of Windows 2000/Advance Servers Assembling servers and mounting them on racks. Configure RAID as per specifications given. Configuration Active Directory Structure and DHCP on the server. Installation of MS Exchange servers, Database servers (SQL Server 2000). Regular backup of servers on Compaq DLT library using Veritas backup. Installation and administration of MS SQL Server 2000 database.

  Assisting development users for database and system problems. On Call database support to end - users. Installation of critical patches and service packs on the servers.

Confidential

Windows and Oracle Database Administrat or

Responsibilities:

• Oracle 8i database 24/7 administration, maintenance. Responsible for Database user creation and maintenance, table space, segments creation and maintenance. Connecting clients to database using NET8. Regular online logical and physical backups. Written scripts to monitor database activities. OS Shell Scripts. Performance tuning includes tuning of database objects, SGA. Monitoring Applications Services on Windows 2000.

Confidential

ORACLE Database Administrator

Responsibilities:

• Oracle8x, 9i Installation on Red hat Linux, IBM RS 6000 SP and windows servers. Administration and 24/7 maintenance of 100 + GB Oracle database. User, Profile, Role administration and maintenance. Customized parameter file for database instance creation and to achieve max performance on production
• SQL/ PL SQL scripting for report generation (Database triggers, procedures). Physical and logical database design and modeling using ERWIN. Normalization of tables at the time of database design. Extensively worked on raw-data in different styles which needs to go into the database using SQL*Loader and Excel Configuration of Listener’s for networking and NET8 for Clients. Regular database backup using ORACLE RMAN. Database administration using OEM and other 3rd party tools. Implemented Oracle's WEB DB 3.0 for testing web applications on Windows NT. Tuning of database includes SGA tuning and application tuning using E-plan.
• Configured DATAGUARD (HOT standby database) to minimize primary database downtime Implemented nightly backup routines, which include database exports, tape backup and copying database to the development sever for precautionary measures. Performed Media recovery of data files on the database from damaged media. Fine Tuning of SQL statement using TKPROF and Explain plan. Assisting programmers to develop forms in DEVELOPER 2000. Performed re-org on database and segments. Designed database forms and reports tracking database activity using developer / 2000. Optimized INIT.ORA parameters to best utilize the new system's resource.

Confidential

ORACLE (7.x,8.x )Database Administrator

Responsibilities:

• Maintenance, Installation and Administration of 100 GB Oracle production and development database on SCO UnixWare, Windows NT for various production Units & Corporate Office of the company. Maintenance of multiple database instances. Table space management, enrolling users to the database & maintaining security, Porting of raw data in different styles which need to go into Oracle Database using SQL* LOADER. Implemented & tested Archive logs for both production & development database. Backup routines include automated scheduled database exports using cron jobs, tape backup, hot backups, cold backups to minimize the down time.
• Re-organization of database, tables. Recovery of database from media crash. Implemented Stand By Database for Production Server. Implemented a menu-driven DBA tool to monitor and to get information on users, free space, extents, table spaces, tables and Indexes. Connecting Clients with Oracle Database server using SQL*Net. Documentation - Includes Backup & restoration strategies, database layout and Reorg. Of the database.