SUMMARY:

• 7 plus years of experience in the field of Information Technology, specializing in Oracle Database having hands on experience in database administration, production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, database security, cloning, migration, shell scripting and documentation in high - availability environments. Possess strong verbal and technical writing skills with excellent communication and inter-personal skills, capable of working efficiently individually and in a team.
• Years of extensive experience as an Oracle Database Administrator 12c, 11g, 10g, 9i, 8i.
• Performed backups, recoveries, installations, database performance tuning, tuning applications, database monitoring and operating system configurations.
• Experience in data (hot and cold) backup and recovery procedures.
• Experience in schema management, tablespace, datafile and extent management, as well as user and privilege management.
• Experience monitoring Oracle RDBMS availability, database exports, tablespace, and extents reports.
• Managing Database Structure, Storage Allocation, Table/Index/BLOB segments, and Rollback segments, Constraints, Database Access, Roles and Privileges.
• Load balancing in RAC nodes using TAF
• Possess excellent written and oral communication skills.
• Configured and Implemented Physical Standby on 10g and 11g Databases (Data Guard).
• Manage Backup and Recovery Program for all Oracle Databases. Install, implement and configure RMAN. Oversee, improve and implement scripts, processes, emergency procedures and testing of all RMAN operations.
• Regular practice of Disaster Recovery Scenerios.
• Work independently and as well working extremely well with other teams and the customer on a daily basis
• Effective communication skills with Project manager, account team, and customer on technical issues and resolutions
• Support databases in Exadata environment
• Implementing ASM file system and its maintenance
• Troubleshoot network issues to connect to database.
• Troubleshoot performance issues by generating statspack report.
• Provided 24/7 support whenever on call.

TECHNICAL SKILLS:

Operating systems: Windows NT/2000/XP, Sun Solaris, HPUX, Linux, AIX, and OS/390

Languages: SQL, PL-SQL, JCL, Visual Basic 7.0, and Java

RDBMS: Oracle 12c, 11g/10g/9i, MS Access, MS SQL Server 2000, DB2

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, ASH, AWR, ADD

Tools: RAC, OEM Grid Control, SQL* Loader, ASM, SQL Server, Export/Import, RMAN, NETCA, DBCA, TOAD, Patch Management, SQLNET, ODBC Export/Import, Data pump, DataGuard, VERITAS Net Backup, VMware

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

Oracle DBA

Responsibilities:

• Installed, configured and maintained 2 node and 3 node Real Application Cluster (RAC) on 10g /11g/12c with ASM.
• 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.
• Upgrade and Migration of Databases from 11.2.0.1 to 11.2.0.3 and applying patches as per requirement.
• Performed an In-place upgrade of a Oracle RAC Database from 11.2.0.2 to 11.2.0.3
• 24/7 on-call production database support.
• Refresh the test and development databases from the source production databases on a regular basis using export/import utility.
• Involved in the migration of huge databases of sizes ranging from 100GB to 4TB.
• Migrating single Instance Databases to 2 Node RAC environments.
• Daily incremental backup and weekly full backup of databases using RMAN.
• Setup of Jobs using the Oracle Enterprise Manager (OEM) database control.
• Installed and configured 12C GRID Control.
• Used SQL *Loader for loading the data into database tables.
• Regular database management on 10g and 11g OEM.
• Involved in installation and configuration of Goldengate extract and replicate issues.
• Implemented Bi-Directional replication in golden gate from target to source and source to target.
• Performed patching on Oracle Database Server 10g and 11g using Opatch utility.
• Applying patch set and interim patches whenever required to make the database software up to date.
• Experience in Online and Offline backups and recovery.
• Monitoring & Scheduling jobs for the daily activities for all the databases using CRONTAB.
• Table space monitoring, Performance monitoring and tuning for performance improvement.
• Analyzing database performance and tuning database on Oracle Exadata using Real Application Testing (RAT)
• Worked on setting up Data Guard on RAC in Oracle 11g & Exadata
• Managing, troubleshooting and resolving oracle database and application issues.
• Performed Explain Plan analysis for Query Optimization and SQL tuning.
• Monitored and tuned long running jobs by working closely with the application development team and analyzing objects, created or rebuilt indexes, query tuning using SQL TRACE, AWR, TKPROF, Explain Plan, TOAD from Quest software (DB Tuning).

Environment: Oracle 10g, 11g, 12c, Linux 5/6, OEM, RMAN, Golden gate, Grid, RAC, ASM, Data guard, TOAD, SQL*LOADER, AWR, ADDM, ASH, Data pumps, Exports/Imports.

Confidential, Skokie IL

Database Administrator

Responsibilities:

• Implemented and configured 10g RAC and 11g RAC.
• Migrated NON ASM databases to ASM databases.
• Maintained Data Guard to ensure high availability, data protection and disaster recovery for enterprise data.
• Created Streams environment in unidirectional and table level for replication of data.
• Configured and used Oracle FlashBack for minor recovery of objects in the database.
• Installed and configured OEM Grid control and intensively used Diagnostic & tuning packs along with AWR & ADDM reports.
• Implemented Oracle Backup and recovery procedures using RMAN & Import/Export.
• Configured RMAN backups for TSM and Commvault and also resolved backup issues.
• Restoring Database’s from Backups on testing environments.
• Effectively uses database replication, security and availability solutions.
• Upgrade and Migration of Database’s from 10.2.0.5 to 11.2.0.2 and applying patches whenever required.
• Applying Quarterly patches and CPU, PSU, One-Off Patches to update Oracle version and to fix the bugs using Opatch utility.
• Effectively uses platform-specific, as well as enterprise, monitoring tools to provide fault and pre-fault performance notifications.
• Provides platform-specific performance tuning, installation and configuration.
• Monitors and manages back-up and recovery as well as capacity planning for all Database platforms
• Carries and responds to off-hours communications device in order to provide 24x7 support.
• Performance Tuning of Databases, Oracle instances, and Applications. Finding Performance bottlenecks using STATSPACK, EXPLAINPLAN,
• SQLTRACE,TKPROF, ASH, AWR, ADDM
• Worked on Instance Tuning, Memory Tuning and SQL Tuning.
• Performed database Point in Time Recovery and Table Space Point in Time Recovery using Transportable Tablespaces.

Environment: Oracle 10g/11g, SQL,PL/SQL, SQL*PLUS, EXPDP/IMPDP, OEM, RMAN, Cygwin - X, Linux, Windows, Data guard, Toad 10.1

Confidential, IL

Junior DBA

Responsibilities:

• In charge of maintaining Production and Development Oracle databases.
• Supporting more than 25 production and development databases 10.2.0.4.
• Responsible for maintaining 190 GB production database.
• Created and maintained failover logical standby database.
• Using Oracle 10g DataPump for export and import.
• Using Automatic Database Diagnostic Monitor (ADDM) to diagnose and fix performance problems.
• Using Automatic Shared Memory Management (ASMM) for optimal use of available SGA memory.
• Using SQL Tuning Advisor and SQL Access Advisor to fix bad SQL.
• Installed and configured Oracle Enterprise Manager 10g Grid Control.

Environment: Oracle 8i/9i/10g, SQL, PL/SQL, SQL plus, TOAD, Import/Export Oracle Enterprise Manager, Windows NT/2000, Sun Solaris 2.5/2.6, Red Hat Linux 2.1