SUMMARY:

• An Oracle DBA with around 7+ years IT experience in Oracle (10g, 11g, 12c) 10g/11g RAC, installation, migration, designing, backup, recovery, scripting, performance tuning etc. spanning various industries like insurance, financial etc. in variety of environments like UNIX, LINUX, AIX, in production as well as development databases.
• Extensive experience in implementation, maintenance, installation, administration of Oracle databases 12/11g/10g across various operating systems including UNIX, Sun Solaris, AIX and Windows.
• Installed Oracle 10g/11g software.
• Excellent experience in configuring and tuning of Oracle 11g,12c and high availability databases.
• Experience in fulfilling DBA daily activities, including schema management, user management (creating users, synonyms, privileges, roles, quotas, tables, indexes, sequence), space management (tablespace, rollback segment), monitoring (alert log, memory, disk I/O, CPU, database connectivity), scheduling jobs, UNIX Shell Scripting.
• Migrated single instance databases to multimode 10g/11g/12c environment for high availability and load balancing.
• Very good experience on TOAD, RMAN.
• Proficient with Amazon Cloud ( AWS ).
• Upgrading databases to higher versions, applying patches and patch sets Strong experience in Backup and Recovery strategies using RMAN, creating RMAN scripts, Export/Import, Data Pump, Hot and Cold backups.
• Expertise in Oracle performance tuning using statspack, tkprof, explain plan.
• Delivering SQL and Database performance tuning services via V$/GV$ views, Explain Plan, AWR (statspack) reports, ADDM, Tkprof.
• Expertise in creating Oracle Tables, Table Partitions, Views and Materialized Views.
• Experience with SQL, PL/SQL coding, stored procedures, triggers, cursors, functions, packages, UNIX Shell Scripting, Indexes, Logical and Physical database design to implement the business logic.
• Experienced in Oracle Support (raising SR) processes for technical requests through Metalink.
• Excellent at setup and managing GoldenGate Replication.
• Documentation of Oracle database operations and training of backup personnel.
• Excellent verbal and written communication skills. Willingness to learn new technologies, openness to new ideas and ability to learn very quickly.
• Data loading using Logical backups using full export and DATAPUMP.
• Database replication using snapshots, materialized views and advanced replication methods.
• Participated in on - call (off hours) schedule in providing technical support.
• Troubleshoot performance issues for the Oracle Cluster.
• Support OS upgrade - Cleanup of Clusterware and database software and re-install, with no downtime.
• Add or Remove Node from RAC.
• Experience with implementing the Oracle Partitioning on Tables & Indexes.
• Move databases from one location to another successfully. Expansions/Upgrades in RAC cluster done with no downtime in 24X7 environment.
• Moderate experience in managing SQL Server .
• Intermediate experience in managing MySQL instances.
• Experience in troubleshooting, system analysis, data modeling, logical and physical database design & installation and performance analysis and optimization.
• Work in 24x7 production environment and provided on-call and day-to-day DBA support.
• Expertise in Oracle Enterprise Manager (OEM), TOAD & Erwin.

TECHNICAL SKILLS:

Operating System: UNIX, RHEL, Sun Solaris, AIX, Windows 2003/2008/2012

Scripting: SQL, PL/SQL, Unix Shell Scripting

Databases System: Oracle 12c, 11g R2, 10g, 9i, SQL Server 2005, 2008 and 2012

Documentation Tools: Share point MS Office, Visio, Wiki

Tools: /Utilities: sqlplus, sqlldr, exp, imp, expdp, impdp, Exadata, Golden Gate RMAN, RAC, Data Guard, ASM TOAD, OEM, DB console, RMAN, lsnrctl

PROFESSIONAL EXPERIENCE:

Confidential, OHIO

Oracle Database Administrator

Responsibilities:

• Installed Oracle 12c on windows with container and pluggable databases.
• Participated in day to day DBA tasks: installations, ongoing maintenance tasks, database updates, backup and recovery process for Oracle databases.
• Worked in PL/SQL and SQL Tuning tasks, change management and database refreshes.
• Supported sales and marketing teams by providing technical Product expertise and creating write-ups for new product releases.
• Evaluated new Oracle 12c features for DBAs and Developers.
• Experience in Installation and configuration of Oracle 9i, 10g, 11g on RHEL, Solaris and Windows environment.
• Experience in Installation of Oracle 10g Real Application Clusters (RAC) databases on Linux and Sun Solaris operating system.
• Excellent at setup and managing GoldenGate Replication.
• Moderate experience in managing SQL Server .
• Intermediate experience in managing MySQL instance.
• Experience in migrating Standalone Database to High Availability RAC environment with ASM
• Hands on experience in configuration, administration, maintenance & recovery of single-instance & Real Application Clusters (RAC) Databases.
• Configured Data guard environments for disaster recovery and high availability, experience setting up physical & logical standby, active data guard.
• Hands on Experience using Oracle utilities Data pump, SQL Loader, RMAN, Original export/import.
• 24*7 - Production database support with support to developers & end-users.
• Implemented automated backup strategy using the UNIX shell script CRON UTILITY.
• Expertise in SQL and UNIX Scripting (Used to write UNIX Scripts & implemented by Using CRONJOB for Day-to-Day activities).
• Proactive monitoring, identifying areas that need to be improved in the database using Statspack, AWR, ADDM and 11g OEM Grid Monitoring.
• Performance tuning of the database - SQL Statement Tuning. Used Tuning utilities like STATSPACK, TKPROF, EXPLAIN PLAN, AWR, ADDM and Tuning of SGA, Distribution of disk I/O, Sizing of tables and indexes.
• Cloning databases for development/testing environments using traditional backup methods as well as using RMAN.
• Experienced user of Oracle PL/SQL in stored procedures, functions and triggers.

Environment: Oracle 9i/10g/11g/12c, Oracle 12c/11g RAC, ASM, RHEL 6,5.8,5.4, Sun Solaris, TOAD, SQL, PL/SQL, Data Guard, OEM, RMAN & SQL*Loader

Confidential, Chicago, IL

Oracle Database Administration

Responsibilities:

• Install 11g,12c databases and clients on RHEL and other win/*nix platforms.
• Configure ASM packages on Linux.
• Install ASM disks.
• Manage ASM disk groups via ASMCMD and database control.
• Manage 5-node RAC Cluster.
• Troubleshoot RAC issues with olsnodes, crs stat, crs register, crs unregister, crsctl check crs. crsctl check cssd, crsctl check crsd, crsctl check evmd, crsctl stop, srvctlnodeapps, crsctl status, coreconfig etc.
• Multiple OCR and Voting Disk to different location for higher availability.
• Add and delete node in RAC environment.
• Stop and start nodes via srvctl and manually.
• Reconfiguring Services via srvctl utility.
• Working with Oracle to solve multiple RAC issues.
• Troubleshoot connectivity issues and solved listener configuration.
• Worked with Unix Administrators to create new 4 node RAC cluster.
• Configure and install database control.
• Managed agents for Database Control monitoring tool.
• Troubleshoot OEM repository.
• Update sysman passwords to troubleshoot OEM connection issues.
• Manage security and grants for database users.
• Created Materialize Views on remote host to refresh multiple times in a day.
• Responsible for writing shell scripts to automate tasks.
• Responsible for managing daily full backups.
• Recovered corrupted datafiles from backups.

Environment: Oracle 11gR2, 10g, AIX6L, Solaris 10/9, LINUX (RED HAT), SUN Sparc E 4500/5000/450, RMAN, TOAD, SQL LOADER, DATA PUMP & OEM/Grid Control.