SUMMARY

• 9 years of IT experience as both Oracle Database Administrator specializing in several flavors of UNIX (Solaris, AIX, & Red Hat Linux) & Windows operating systems.
• Experience working on Supercluster Exadata machines.
• Implemented Goldengate replication b/w heterogeneous environments
• Zero down time migrations - wif goldengate and datapump
• Extensive noledge in 11g R2 RAC implementation and troubleshooting
• ADR - Active data guard configured wif fast switch fail over.
• Extensive experience in installing oracle software, upgrading teh databases and applying patches as required along wif raising TARs for support.
• Expertise in cloning database on same and different servers
• Experience in disaster recovery planning wif detailed processes and procedures of implementing a disaster recovery solution attaining 99.5 % availability.
• Experienced in administering RAC, RMAN, and Standby databases. Configured and Maintained dual Dataguard setups and DA Replication/streams for High Availability and offline reporting
• Experience in server architecture, database full life cycle administration and database server administration in production and all other environments.
• Experienced in upgrading databases to higher versions and migrating databases including cross-platform migration from one server to other servers across different OS Platforms like from Solaris to AIX and building VLDBs.
• Worked on projects to build complete Datacenter.
• Troubleshooting Database performance using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor and used SQL Profilers as suggested by ADDM as necessary.
• Expert in teh areas of SQL & PL/SQL generating and tuning teh statements minimizing teh elapsed times.
• Good proficiency in implementing Backup and Recovery Strategies using Tools like Oracle RMAN, IBM Tivoli Storage Management, Veritas Netbackup, EMC Legato Storage Manager and defined SOP’s to accomplish Service Level Agreements meeting teh application’s backup/restoration policies.
• Expert in Installation and configuration of OEM Grid Control 12c and teh Agents.
• Expert in administering database objects like Tables, Indexes, Views & materialized views, Sequences, Functions, Procedures, Triggers, Stored Procedures and Packages.
• Supported many systems 24x7. Ability to work beyond regular hours. Carried primary and secondary DBA support roles wif pager rotation to support during weekends, holidays and beyond regular hours.
• Extensive monitoring capabilities wif scripts and OEM monitoring interface
• Work experience on in-house built replication process using triggers wif “pull” mechanism similar to streams and experienced in (4.2 TB) multi-terabyte databases and table partitions.
• Implemented new features of Oracle 10g like Log Miner, Transportable Tablespaces, Data Pump, Flash Back, & multiple Archive-Log Destinations etc.

TECHNICAL SKILLS:

Operating Systems: UNIX, HP-UX, AIX 5.2, SUN Solaris 2.5.1, Sun Cluster 2.0/2.1/2.2/3.0 , Linux 9.3 servers, and Window NT/2000/2003 Server.

Hard Hardware: HP Itanium & PA RISC &, Sun Sparc E 4500/5000/450 wif EMC symmetrix 8530, HP PA-RISC 2.0, HP 9000/E39

Databases: ORACLE 12c, 11gR2/10g/9i, SQL Server 2005, 2008, 2008 R2, IBM db2i and MS Access.

Languages: SQL, PL/SQL, T-SQL (Transaction SQL) and Shell Programming.

Software: SQL*Loader 8.0, SQL*PLUS 8.0, Siebel EIM Oracle Universal Installer, DBCA (Database Configuration Assistance), and MS Office.

Tools: Power Designer, DB Artisan, OEM, RMAN (Recovery Manager), Export/Import, SQL*Loader, SQL *Plus, SQL Trace, MS Project Management, TOAD, Replication.

PROFESSIONAL EXPERIENCE:

Confidential, Tulsa, OK

Senior Database Administrator

Responsibilities:

• Implemented continuous database availability architecture using Oracle Data Guard. Configured Active Data Guard technology for production databases and maintained physical standby databases on 3-node RAC environment. Implemented Data Guard Broker to ease teh switchover process.
• Performed daily sanity checks of teh Data Guard setups making sure teh MRP, log-apply process is intact as a part of daily Data Guard maintenance.
• Participated and implemented Data Guard switchover procedures both via Broker and manual procedures as a part of contingency exercises to ensure DR procedures.
• Assisted in installing & configuring of multi node Oracle 11g R2 Real Application Clusters (RAC) environment wif ASM on Linux for ORARAC and Windows Operating Systems for AVL projects.
• Zero downtime migrations wif Goldengate wif Datapump.
• Worked wif SAN & UNIX Administrators to flex-clone teh snapshots on Storage Area Network (NetApp and Falcon Store) to clone multiple databases from one server to another.
• Installed Oracle 11g R2 binaries and created and maintained databases for both teh 11g and 10g versions. Cloned number of databases as required and upgraded them from existing Oracle 10g R2 to Oracle 11g R2 versions.
• Implemented Goldengate to fetch data from DB2 to Oracle.
• Implemented cross-platform migrations for multiple databases from Solaris to AIX (IBM Power 750s) as a part of DB GRID project and successfully upgraded them from 10.2.0.4 to 11.2.0.2.
• Worked on Oracle utilities like Data Pump, IMPORT EXPORT, SQL LOADER and other new features of 10g and 11g like Flash Back, Incremental Backups, and Obfuscation technology.
• Implemented Incremental backups on teh databases which took more than 6 hours for a full backup and reduced teh backup times. Working as responsible DBA for a team of 8 members in developing Backup and Recovery scenarios and addressing related issues.
• Involved in performance tuning of Oracle Databases finding teh performance bottlenecks using OEM Grid Control, analyzing Automatic Workload Repository reports using Automatic Database Diagnostic Monitor.
• Performed performance tuning of Oracle Databases, instances and Applications finding teh performance bottlenecks using OEM Grid Control, AWR, ADDM, STATSPACK, ANALYSE, INDEXES IMPLEMENTATION, EXPLAIN PLAN, SQLTRACE, TKPROF.
• Closely worked wif Development team in designing data models & teh ER suggesting better approaches. Extensively worked on implementing models in teh databases using DB Artisan & Power Designer.

Environment: Oracle 11g R2/10g, Oracle 12c, AIX, Linux, RAC, RMAN, Oracle Enterprise Manager, SQL, PL/SQL, Performance Tuning, Goldengate, ADR, Datamirror, IBM DB2i, Exadata, ASM, Super cluster

Confidential, Richmond, VA

Sr. Database Administrator

Responsibilities:

• Installing, upgrading and maintaining Oracle RDBMS on Linux & Windows platforms.
• Worked wif lead DBAs for preparing cluster, configuring, installing Clusterware and Oracle RAC on Red Hat Linux.
• Configured 10G and 11G RAC using ASM and CFS as clusterware.
• Installed and configured 11G grid infrastructure to configure RAC and single instance.
• Configured ASM databases on ASM instance using Oracle 10g.
• Configured backups using RMAN.
• Migrated single instance database to RAC.
• Used duplicate database for cloning Oracle database from production to non-production environments.
• Used online redefinition from partitioning large table to run SQL’s in definite time window using SQL trace.
• Used TOAD, DBArtisan, PL/SQL developer and SQL developer to tune sql’s for new and post prod sql performance issues.
• Analyzed AWR, Statpack and ADDM reports to find teh bottlenecks in teh performance of teh instance.
• Startup and Shutdown of Individual instances on RAC database using OEM.
• Implemented schema replication using Oracle streams.
• Performed Database Cloning from production to test/development environment using RMAN and renamed database using DBNEWID utility.
• Implemented Physical and Logical standby database and schema replication using Oracle streams.
• Backup of database Logical and Physical (hot and cold) procedures and also using RMAN.
• Created mappings using transformations to load teh data into teh target.
• Applying patches and works closely wif Oracle to make Application environment Up to date.
• Backups & Recovery Maintenance, Databases Performance Tuning.
• Typically involved in database Designing, creation and maintenance.
• Good working noledge of SQL, PL/SQL, and shell scripting.
• Created users and grant privileges according to teh requirements.
• Export and import of database objects using Data pump utilities EXPDP and IMPDP.
• Developed shell scripts and PL/SQL procedures and scheduled Cron jobs and DBMS JOBS to monitor teh database performance and for user management.
• Using OEM (Oracle Enterprise Manager) for routine administration, database monitoring, replication process and performance tuning.
• Provided System support for both development and 24*7 production environments.

Environment: Oracle 11gR2, 10g/9i RAC, ASM, Red Hat Linux, SOLARIS, RMAN, SQL*Plus, SQL, PL/SQL, UNIX Shell Scripting, SQL*LOADER, Oracle OEM, Import/Export Datapump, STATSPACK

Confidential, Ann Arbor, MI

Oracle Application Database Administrator

Responsibilities:

• Analyzed requirements and prepared system flows, specifications, and database designs.
• Using OEM (Oracle Enterprise Manager) for routine administration, database monitoring, replication process and performance tuning
• Alice, RSS - Regulatory submission suite and Labeling APP DBA
• Implemented and maintained database through DBA activities include database backup (Cold, Hot, Import/Export), database recovery, tuning, installation, database creation, logical and physical databases design.
• Installed and configured 11G grid infrastructure to configure RAC and single instance
• Startup and Shutdown of Individual instances on RAC database using OEM
• Creation of application users, responsibilities and granting privileges to them.
• Worked wif users to determine system requirements.
• Developed shell scripts and PL/SQL procedures and scheduled Cron jobs and DBMS JOBS to monitor teh database performance and for user management
• Monitoring application performance.
• Database activities include allocation and maintenance of Rollback Segments, Automatic Undo Management, table spaces, data files, redo log files, mirroring of redo log files across multiple disks.
• Experienced in using utilities like Export/Import and SQL Loader.
• Developed PL/SQL packages, procedures, functions and triggers.
• Coordinated wif other team members in establishing tasks and deadlines.
• Provided 24*7 System support.

Environment: Oracle 11g, 10g, 9i and RAC, Sun

Confidential

Database Administrator

Responsibilities:

• Creation of new database, deciding teh location of data, index, rollback, redo log and control files on teh disks.
• Creating, checking, extending table space. Administered database security, created users, granted/revoked roles, privileges, extended databases storage capacity, monitored and reduced database fragmentation, managed data files, rollback segments, extents, segments, re-indexing, monitor storage, backup & restore/recover database, export/import database objects.
• Extensively used SQL Loader to load data from flat files to teh Oracle Database.
• Knowledge of data warehousing methodologies and techniques using star schemas, caching Techniques, DB loads, indexing, Physical and Logical data modeling etc
• Buffer Cache, Tuning of OS by Reducing Paging/Swapping, Tuning of SGA and Tuning of memory allocation. Tuning of me/O, which includes Separating of Data files and Redo log files on different locations, Striping of table data, and Separating of tables and indexes on different locations. Reducing Disk me/O Contention etc. Applications Tuning of Database using EXPLAIN PLAN, TKPROF, SQL TRACE, ANALYZE, HINTS etc. Oracle query tuning and optimization.
• Wrote shell scripts to automate teh processes.
• Developed back-end routines using Oracle SQL, PLSQL, Stored procedures, Packages, Triggers.
• Identified common functionalities, implemented them using PL/SQL, Stored procedures, Packages, Triggers, form Libraries.
• Maintained Integrity and Security, Schema Design, Created & Managed users, roles, permissions, schema objects such as tables, views, snapshots, indexes etc

Environment: Oracle 9i/10g, SUN SOLARIS 8, Import/Export, SQL* LOADER, STATSPACK, EXPLAIN PLANTKPROF, SQL, PL/SQL, TOAD, Windows 2000, Shell Scripts, Cron Script

Confidential

Junior DBA

Responsibilities:

• Creating and Maintaining of databases. Creating table spaces, tables, indexes, data files etc.
• Creating Users, Assigning Privileges and Roles in multiple databases in Windows NT and HP-UX environment.
• Database migration from Oracle 9i to 10.2.0.1, including (manual) scripting for conversation of all database objects.
• Supported Developers and Users by running queries/output (spool file) in SQL-Worksheet/SQL*PLUS environment.
• Experience wif UNIX-AIX.
• Copied multiple tables using export/import utility (automated shell scripts) using teh interactive mode, par file and query related specific rows. Tools SQL-Analyze, TKPROF
• Created synonyms, public database links and Materialized Views in Oracle environment.
• Performed Hot Backups, Cold Backups and also used Import/Export Utility.
• Installation, configuration and administration of Oracle 10g Database.
• Managing Oracle database administration function involving resolution of database start-up problems; managing disk space, user profile creation and user rights management.
• Performed tuning by generation of Stats-Pack Reports and Tracing of Queries.
• Implementation of backup and recovery, monitoring procedures, on-going support and performance tuning.
• Handling various technical aspects like product documentation, software design, coding of modules, quality compliance, monitoring critical paths & taking appropriate actions.

Environment: Oracle 9i/10g, SQL plus, Oracle Enterprise Manager (OEM), Sun Solaris 2.9, UNIX