SUMMARY:

• A Detailed and goal - oriented Oracle Database Administrator with 6 years of experience in designing and maintaining Oracle 10g, 11g and 12c RDBMS.. Supported a variety of critical applications running on Oracle, 10g, 11g and 12c.
• Implemented LINUX HUGE PAGES on OEL 5.5 and Redhat Linux 6.x for Clustered Environments.
• Performing day-to-day database administration tasks like Tablespace usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs etc.
• Extensive experience designing and implementing backup and recovery strategy for databases using Recovery Manager (RMAN), traditional Export/ Import, Export/Import Datapump as well as conventional Hot/Cold Backups.
• Implemented various backup strategies for Large / Medium sized databases using RMAN
• Worked extensively on Cloning /Duplicate of databases using RMAN.
• Experience with various database Backup and Recovery methods like PITR, TSPITR, Export/Import and Flashback Technologies.
• Migrated databases from Non-ASM file system to ASM file system using RMAN.
• Upgrading and Migration of Oracle database to higher version and other platforms using manual method and traditional Export/Import, datapump& Transportable Tablespace (TTS).
• Experience in coding SQL, PL/SQL package, function, stored procedure, triggers, and Materialized view for Oracle database.
• Experience in Java spring batch processing, development of robust batch applications
• Hands on experience with logical backups, Hot/Cold backups, Recovery, and cloning of databases using (RMAN) Recovery Manager, SQL-Backtrack, VERITAS Net Backup.
• Disk Space Management involving managing archives, space allocation to various tablespaces and also capacity planning for new applications.
• Experience include Installation, Configuration, Upgrades, Space Management, System maintenance, patching, data replication, Database security, Performance Monitoring, Performance Tuning, Backup and Recovery and also includes RAC, ASM, Data Guard, Golden Gate, Data Pump and grid control experience.
• Supported as Production and development DBA on OLTP, Data warehouse environment. Involved in Change/Release/Patch management and off-shore co-ordination, Product development, data center Migration and Upgrade. Administration including design, deploy, tune, trouble-shoot. Efficient to manage 50+DB.
• RAC Installation and Admin on UNIX platform. Load balancing. Manage fail-over. Backup CRS files. Tune cache fusion. Resource utilization on Nodes.
• Managed ASM, create and prepare disk for ASM. Create ASM instance. Add/remove disk. Manage space on disk groups. Expertise on asmcmd commandline. Handle 10TB database on ASM.
• Experience in the management of database in the EXADATA machine trouble shooting.
• Performed Backup/restore/recover using RMAN and user managed. Create backups, Incremental and Cumulative backups using RMAN. Logical backup of schema using expdp/impdp. Restore and recover from backup.
• PL/SQL objects creation. Create trigger/ function/ stored procedure/ packages. Tune and trouble-shooting PL/SQL codes. Write database Monitoring PL/SQL objects. Create Materialized view.
• Experience in Golden Gate to support data replication monitoring, tuning and capacity planning. Experience in bi-directional and broadcast replication from source to target databases using Golden Gate 9.5 and Golden Gate 10.0.
• Applying Patches, Critical Patch Update/Patch Set update and One-off Patches using OPatch. Experience in patching RAC databases in rolling fashion to maintain high availability.
• Experience in tuning database and memory components for optimal performance using AWR, ADDM and ASH reports.
• Good knowledge v$ performance views and command line skills to identify information about sessions, wait events, system performance etc
• Involved in tuning applications for optimal response time using SQL /Optimizer Trace at various levels and events, Explain Plan, TKprof, Oradebug and also identifying the poor SQL's, histograms, row chaining & row migrations and tune accordingly.
• Exposure to SQL Tuning Advisor, SQL Profiles, SQL Monitoring, SQL Access Advisor, SQL Baselines and SQLTXTRACT tools and utilities.
• Implemented various Partition techniques to achieve availability, performance and manageability of large tables and indexes
• Expertise in Configuring RMAN with Catalog /Nocatalog and worked on Point-In-Time Recovery and flashback.
• Plugging the tablespace between different platforms using Cross platform transportable tablespace Utility.
• Collecting performance statistics using Statspack/AWR (Automatic Workload Repository) and ADDM (Automatic Database Diagnostic Monitor).
• Used TKPROF utility and Explain Plan for tuning SQL queries.
• Experience in regular DBA activities such as Upgrades, Patches, TAR support, Cloning, Backups and Recovery Manager, Performance Tuning, Capacity Planning and documentation
• Memory tuning by using ASMM (Automatic shared Memory Management). Sort area size, Buffer cache, Shared pool size, Different pools like Recycle pool, Keep pool.
• Rebuilding of Indexes for better performance, User Management, Tablespace management, maintenance of Oracle Database..
• Installing Oracle patches, Migration of database across releases.
• Expertise in loading data from flat files using external tables, SQL* Loader.
• Experience with SQL, PL/SQL, UNIX Scripting.
• Extensive knowledge in other RDBMS databases like SQLSever and MY/SQL database
• Hands on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings, and sessions.
• Excellent analytical, problem solving, communication and interpersonal skills

TECHNICAL SKILLS:

Databases: Oracle 10g, 11g and 12cDatabase Tools: SQL*Plus, Toad, OEM Grid, RMAN, SQL*Loader, Exp/Imp/Data Pump, Log miner, Statspack/AWR, Shareplex, Top, DBCA, DBUA, ADDM, Oracle Migration Workbench, ERwin, QDesigner, Remedy

Operating Systems: MS Windows, UNIX (Solaris 8/9/10, AIX, HP-UX), LINUX

Hardware:: Sun Fire 15K, Sun 6320 Storage, Sun Enterprise Servers 890/880/420/450, Sun StorEdge 6320, Hitachi, EMC, Dell Servers, Compaq Servers 6000/3000/1600/800, HP/UX-9000, Red Hat Linux 6.2

PROFESSIONAL EXPERIENCE:

Confidential, Naperville, IL

Oracle Database Administrator

Responsbilities:

• Supporting multiple databases for production, development, test and staging purposes on Sun Solaris and Windows environments.
• Implemented switchovers on primary and standby databases as a part of planned maintenance activities.
• Upgraded the RAC and standalone databases from 10g (10.2.0.4 and 10.2.0.5) to 11g (11.2.0.2, 11.2.0.3 and 11.2.0.4) and 11g to 12c. as part of performance improvement by utilizing the new features. Also upgraded 11g (11.2.0.3) Databases to 12c (12.1.0.1).
• Creation, Configuration and Setting up of RMAN Catalog databases and registering target Databases with the Catalog.
• Responsible for Backup and recovery of the databases using RMAN Tool (Recovery Manager), and Database Flashback using GRP ( Guaranteed Restore Point ) and Export and Import (Datapump and Normal ) for restoring the specific objects at the database level.
• Building Oracle Stand by databases, both Active Dataguard for real-time replication and normal Dataguard for disaster recovery also referred as BCP clone purposes.
• Worked on Disaster Recovery by converting physical standby databases to SNAPSHOT standby database and opened in the read/write mode for testing purposes without interrupting the primary production database.
• Implemented Dataguard, creating both logical and physical standby databases in 10g and 11g RAC environment for production database.
• Implemented ASM on RAC and stand-alone databases. Managing disks and disk groups with ASM.
• Installed Goldengate version 11 and version 12 with latest patches applied on DBFS filesystem and ACFS filesystem, also working testing new OGG 12.2 new features available.
• Implemented Goldengate integrated replicat and co-ordinated replicat(available from OGG 12c) to improve the performance of data replication to targets
• Implemented user level security, object level security, dataencryption, data masking, and Fine Grain auditing using DBMS FGA package.
• Participates on project teams as database administration support to ensure that databases are appropriately modified to support new business applications and requirements
• Install, patch and upgrading Oracle 10/11g & 12c to support internal production and test environments.
• Installation of 12c OEM and customize it to our needs.
• Installing Oracle Golden gate on RHEL and setup table level replication as well as DDL replication too.
• Evaluated Oracle 11gR2 Golden Gate for future purposes that is for reducing the complexity involved in Oracle Streams.
• Configured Oracle Streams on Oracle 11g, 10g databases for data replication and monitored them using Grid Control.
• Automated the Data Replication process using Materialized Views for reporting databases.
• Used Oracle Enterprise Manager (OEM) 11gGrid Control for monitoring multiple database and notification of database alerts, and configured EM agents on multiple database servers.
• Implementing Datapump, conventional export/import utility of Oracle 11g, 10g for re-organizing Databases/Schemas/Tables to improve the performance.
• Used import/export utilities for cloning/migration of small sized databases and Datapump import/export to move data between 10g/11g environments.
• Applying upgrade patch, maintenance and interim (opatch) patches on all the databases.
• Refreshing Dev and Test instances with data from Production on a regular basis.
• Developed PL/SQL packages, DML, DDL, Oracle tables, Stored Procedures, functions, cursors, triggers and UNIX shell scripts.
• Alert management, Created and setup alerts to send notification to Users from application wherever necessary.
• Created and troubleshoot DB Link issues in Oracle for communicating with external databases.
• Used Utilities like Explain Plan, SQL*Trace, TKPROF and Statspack for SQL Tuning Purpose.
• Worked on Re-Organizing the tables to convert from non-partitioned to partitioned tables using Online Re-definition (with minimal impact to live system), CTAS(create table as select ), exp/imp and creating the table with new DDL and direct insert sql.
• Created, scheduled db maintenance tasks, such as tables/indexes analysis, index rebuild, materialized views refresh, db exports and janitorial day-to-day tasks.
• Perform day to day activities like backup-restore, space management, monitoring database alerts, performance tuning.
• Proficient in troubleshooting Node Eviction in Oracle RAC Environment
• Applied PSU patches and other database related patches.
• Have a good experience in administering Oracle Clusterware components.
• Configured ASM and handled issues and suggested feasible workarounds for ASM Metadata corruption and Configured user log on load balancing and failover on RAC database.
• Responsible for SQL query tuning and optimization. Performed database tuning and optimization using tools such as Tkprof, STATSPACK, Explain plan and SQL*Trace.E fficiently performed installation, setup and creation of three node cluster RAC with Oracle11.2.0.3 database using GRID infrastructure with ASM file systems on RHEL 5.5.
• Maintenance of Oracle 11gR2 Real Application Cluster (RAC) Database for High Availability, Scalability and Performance by determining the best Cluster architecture, choosing the best hardware configuration for Oracle RAC.
• Successful in installation/maintenance of Physical Standby database using OracleData Guard forOracle 11.2.0.3 and Oracle 10.2.0.5RAC databases.
• Database monitoring/maintenance, replication process and performance tuning are done using OEM (Oracle Enterprise Manager).

Environment: Oracle 11g/11g RAC/9i, VMS, Sun Solaris, Windows Server 2003, Red Hat Linux, TOAD, RMAN, SQL server, OEM.

Confidential, Monroe, LA

Database Administrator

Environment: Oracle 12c/11g/10g/ Linux, Solaris, SQL Developer, PL/SQL, Shell scripting (Bourne), OEM, Statspack, RMAN, AWR, ADDM, DataPump.

Responsbilities:

• Installation of oracle 11g databases in production, development and test environments depending on project requirements.
• Enforcing and managing Security and Audit requirement compliance.
• Performance tuning by Fine Tuning Initialization parameters, I/O, Memory, storage and Operating System kernel parameters, Oracle SQL, optimizer, and query plan, optimize queries and performing PL/SQL code profiling.
• Troubleshooting the Database Performance issues by analyzing (AWR), (ASH), (ADDM) reports, using SQL Adviser & UNDO Adviser tools, OEM GRID, and TOAD .
• Capacity Planning as per Data growth and work-load by working closely with other decision making Teams such as Development, Business / Clients.
• Sharing ONCALL rotation weekend shift.
• Apply CPU, RDBMS patches to RAC Databases as per the requirement.
• Supporting OS Patching activity for all RAC Servers.
• Create databases for development, testing and production (including RAC databases and NON- RAC databases).
• Implement and maintain database security (create and maintain users and roles, assign privileges)
• Implementing 11g Data guard with one physical database. Used OEM Grid Control Diagnostic and tuning packs to tune application and SQL queries. Installation, Configuration & Administration of Oracle 11gR2 RAC.
• 24*7 production support for day to day operations and On Call responsibilities.
• Optimization and tuning SQL queries using TRACE FILE, TKPROF, EXPLAIN PLAN. Extensive usage of ADDM, AWR, ASSM, features of 10g/11gR2.
• Database structure changes, table/index sizing, SGA sizing, SQL, I/O and Application tuning, transaction monitoring, detecting lock contentions, tuning sort operations.
• Timely Reorganization of tables and rebuilt of indexes to improve the performance of the SQL queries as part of scheduled maintenance window. Developing online RMAN backup scripts to automate backup procedures.
• Clone RAC databases with various strategies like Cold/Hot/Logical Refresh and RMAN Backup.
• On RAC systems did CRS upgrade, ASM upgrade, DB Upgrade and OEM Agent Upgrade.
• Cloning from cluster database to Normal database and Cloning from Normal database to cluster database.
• Handled all standard database administrative tasks, such as: proactive performance tuning and monitoring, trouble-shooting, back-up and recovery, installations and configurations on an as needed basis.
• Doing the regular activities like monitoring the alert logs, redo log status, listener. Log and checking the space for normal segments, rollback segments and tablespaces.
• Created database link between two databases to access the table data from one local database to remote database using distributed database feature.
• Making structural changes to the databases. Sizing database objects for effective space management and optimal performance.
• Managing database security.
• Defragmentation of tables and indexes for improved performance and effective space management.
• Managed Database Maintenance Activities to achieve optimum database uptime.
• Written SQL scripts to create database objects like tables, views and sequences.
• Created procedures and functions using PL/SQL.
• Preparation of High Level & Low Level Design documents.