ROFESSIONAL EXPERIENCES SUMMARY:

• Over 5+ years of strong experience in Oracle database administration in heterogeneous system environment including WINDOWS, UNIX and LINUX amongst others.
• Team player with excellent interpersonal, analytical and communications skills
• Monitored and managed various database components (logical & physical) like tablespaces, segments
• Worked extensively on Shell scripting for backup, recovery and maintenance for databases
• Experienced in full life cycle of database administration in Oracle . Worked as a Development Support DBA in Oracle .
• Provided database related services to their development & QA environments .
• Good experience of Installation in Oracle 10g, 11g and 12c Database Administration, experience in Installation of oracle , 11g (11.2.0.1, 11.2.0.4) and 12c (12.1.0, 12.2.0.2) in development and test environments depending on project requirements.
• Good skills in SQL* PLUS, SQL* Loader , UNIX Shell scripts (KSH and CSH), Import/Export Server Manager .
• Experience in installation, upgrades, patches and TAR support. Duties included database creation, Performance tuning /reorganization, cloning, backup/recovery , user and security management, auditing, general troubleshooting , coding , and configuring servers.
• Good knowledge on the Creation of table spaces, data files, roles, redo logs, rollback segments, stored procedures and Triggers.
• Extensive experience in Performance Tuning of database, instances, SGA, I/O, and Rollback segment using different methods and detecting locks.
• Experience in Implementing FLASHBACK technology and its various features in Oracle 10g/11g.
• Configured physical and logical Standby Database (Data Guard) and tested for business continuity/Disaster recovery plan.
• Expertise on Installation/Configuring/Maintenance of Oracle Streams for replication, integration and transmission of data between different databases and applications.
• Experience in applying several patches such as CPU/PSU patches, One - Off Patches, Interim patches, DST, Patch sets as per the oracle recommendations.
• Wrote scripts to inform the DBA team on the status, performance and space management of the database
• Participated in planning and implementation of off-site Disaster-Recovery planning and testing
• Duties included database creation, backup/recovery using RMAN , tuning/reorganization, user and security management, auditing, cloning, general troubleshooting , and configuring servers.
• Extensively used Oracle Enterprise Manager (OEM) for maintaining and monitoring database.
• Managing 26 application running on 15 databases.
• Experience in Logical backup using and full/ partial export/import and Data Pump.

TECHNICAL ENVIRONMENT

OPERATING SYSTEMS: RHEL 6, 7, Linux / Unix, Sun Solaris 11.3. AIX 5.1, 5.2, 5.3, 6.1, Windows 95/98/NT/2000.

RDBMS: Oracle 9i, 10g, 11g, 12c

LANGUAGES: SQL,UNIX Shell Scripting, Ksh, bash and Perl Scripting

SOFTWARE/ APPLICATIONS/ TOOLS: DBCA, DBUA, Recovery Manager (RMAN), Oracle Enterprise Manager (OEM), OEM Grid Control, Oracle Data Guard, Oracle Management Service (OMS), Agents, sql Developer, TOAD, Exp/Imp, DataPump (expdp/impdp),SRVCTL,SQL*Plus, Recovery catalog, Autosys, Crontab, HP Manager, My Services, OTG etc

TUNING TOOLS: SQL TRACE, TKPROF, EXPLAIN PLAN, STATSPACK, SQL*Plus, Oracle Enterprise Manager, Transportable Tablespaces, SQL*Loader, RMAN, DataPump, Export & Import, AWR, and ADDM.

WEB TOOLS: HTML, XML

PROFESSIONAL EXPERIENCE:

Confidential

Oracle Database Administrator

Environment: Windows, RHEL, Oracle 11g, Data Guard, Oracle Grid Control, RMAN, STATSPACK, SQL Developer, TOAD, SQL*Plus.

Responsibilities:

• Responsible for Oracle 9i, 10g, 11g and 12c logical and physical database design, implementation, and maintenance on Windows, Linux.
• Managing over 27applications .
• Deploying codes from one database to another and working on performance issues
• Created new databases and users: set up backups, export, and other monitoring scripts
• Implemented database refresh using full export for table level and full database defragmentation, resulting in improved performance and effective space management.
• Managing database security. Design, develop, and implement automated data backup and restoration procedures. Provide technical support for database maintenance and disaster recovery
• Identify, recommend, and implement all new database technologies and Oracle license management.
• Migration from one plate form to another using transportable table space and import and export.
• Requesting RDS servers for migration and configuring the database for migration.
• Had done various projects using RMAN for Backup and recovery, Data guard for Disaster recovery, Installation, Configuration, Migration, upgrade, cloning, patching, Performance Tuning.
• Excellent experience in Installation and configuration of different databases on Operating Systems UNIX and Windows platforms.
• Planned and scheduled the Physical (Cold / Hot) backups as well as Logical backups.
• Experience in management tools like Oracle Enterprise Manager, TOAD and SQL Developer.
• Provided 24x7 Remote / on-call production supports.
• Installed, configured, and maintained Oracle 10g and 11gR2 on Linux and also Upgraded from Oracle 10g to 11g, 11g to 12c
• Intense knowledge of 12c (work on cloud databases) migration from 11g to 12c using tansportabletable space.
• Extensive Experience with RMAN Backups, Hot Backups and Logical Backups .
• Extensively implemented Datapump, conventional Export/Import (Oracle 11g, 10g) for migration and logical backup of database.
• Strong skills in applying security patches ( Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU), One-off Patch ) using “ runInstaller ” and perl based utility “ Opatch ”.
• Performance tuning of the database - SQL Tuning, Used Tuning utilities like STATSPACK, TKPROF EXPLAIN PLAN, AWR, ADDM and Tuning of SGA, distribution of disk I/O.
• Supported Security User Management, Privileges, Roles, Auditing, Profiling, Authentication
• Monitored and performed database sizing, tablespace management and rollback tablespace management , transaction management and security administration
• Database monitoring and performance tuning using OEM (Oracle Enterprise Manager)
• Index creation and management for optimization of DB Processes
• Used Grid Control extensively and set up Rules for alert notification and schedule RMAN backups with Failure notification
• Performance tuning of Queries by maintaining Aggregates, Compression, partition, Indexing and use of Hints, Stored outlines, Statistics for the same.
• Performance tuning and diagnosing DBMS and individual Production databases, organized various migration review meetings with the application team to discuss the migration strategy based on their requirements.
• Performed policies on data confidentiality, integrity, availability, and auditability, based on Access controls for Access to Data at the database level.
• Performed SQL tuning oracle contention and monitored production database using Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM) and Automatic Session History (ASH).
• Highly experienced in Oracle 12c, 11g, 10g Automatic Storage Management ( ASM ) required to fulfill the storage needs.
• Installed, configured and maintained Physical, Logical, Active standby databases supported by Data guard on Oracle 12c, 11g, 10g servers for the purpose of disaster recovery procedures.
• Supported & maintained the Production/Development databases on various servers
• Extensively worked on setting up auditing in many databases we supported
• Managing Database Structure, Storage Allocation, Table/Index segments, Rollback Segments, Undo Segments, and Constraints.
• Database reorganizations and refresh schema-using Export/Import. Creating the database, table spaces, tables, indexes, setting privileges and user logins
• Used hints for SQL tuning and optimization
• Performed Explain Plan analysis for Query Optimization and SQL tuning

Confidential, Pikesville, MD

Oracle Database Administrator

Environment: Windows, RHEL, Oracle 11g,12, Data Guard, Oracle Grid Control, RMAN, ASM, STATSPACK, SQL Developer, TOAD, SQL*Plus.

Responsibilities:

• Installed, configured, and maintained Oracle 10g and 12c, 11gR2 on Linux and also Upgraded from Oracle 10g to 11g.
• Configuration and installation of oracle data guard for real time replication.
• Extensive Experience with RMAN Backups, Hot Backups and Logical Backups .
• Extensively implemented Datapump, conventional Export/Import (Oracle 11g, 10g) for migration and logical backup of database.
• Strong skills in applying security patches ( Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU), One-off Patch ) using “ runInstaller ” and perl based utility “ Opatch ”.
• Performance tuning of the database - SQL Tuning, Used Tuning utilities like STATSPACK, TKPROF EXPLAIN PLAN, AWR, ADDM and Tuning of SGA, distribution of disk I/O.
• Supported Security User Management, Privileges, Roles, Auditing, Profiling, Authentication
• Monitored and performed database sizing, tablespace management and rollback tablespace management , transaction management and security administration
• Database monitoring and performance tuning using OEM (Oracle Enterprise Manager)
• Index creation and management for optimization of DB Processes
• Used Grid Control extensively and set up Rules for alert notification and schedule RMAN backups with Failure notification
• Performance tuning of Queries by maintaining Aggregates, Compression, partition, Indexing and use of Hints, Stored outlines, Statistics for the same.
• Performance tuning and diagnosing DBMS and individual Production databases, organized various migration review meetings with the application team to discuss the migration strategy based on their requirements.
• Performed policies on data confidentiality, integrity, availability, and auditability, based on Access controls for Access to Data at the database level.
• Performed SQL and PL/SQL tuning oracle contention and monitored production database using Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM) and Automatic Session History (ASH).
• Highly experienced in Oracle 12c, 11g, 10g Automatic Storage Management ( ASM ) required to fulfill the storage needs.
• Installed, configured and maintained Physical, Logical, Active standby databases supported by Data guard on Oracle 12c,11g, 10g servers for the purpose of disaster recovery procedures.
• Supported & maintained the Production/Development databases on various servers
• Extensively worked on setting up auditing in many databases we supported
• Managing Database Structure, Storage Allocation, Table/Index segments, Rollback Segments, Undo Segments, and Constraints.
• Database reorganizations and refresh schema-using Export/Import. Creating the database, table spaces, tables, indexes, setting privileges and user logins
• Used hints for SQL tuning and optimization
• Performed Explain Plan analysis for Query Optimization and SQL tuning

Confidential, New York, NY

Oracle Database Administrator

Environment: Oracle 10.2.0.1, HP-UX 11, Sun Solaris 10.0, RAC, Oracle Streams, RMAN, Data Pump, SQL TRACE, TKPROF, EXPLAIN PLAN.

Responsibilities:

• Performed monthly and annual performance reports for trend analysis and capacity planning.
• Successfully installed and configured Oracle 11.1.0.7, 12c
• Performed housekeeping tasks like checking log and trace files.
• Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 10g 11g and 12cGrid Control .
• Refreshed schema using Export/Import. Created the database, table space, tables, indexes, set privileges and user logins.
• Assist in SQL tuning and providing consultation such as creating Materialized views, adding indices, dropping unnecessary indices, using hints wherever possible, amongst others.
• Performed full & incremental backup (cumulative and differential) using RMAN and implemented recovery strategies.
• Refreshed/cloned databases using RMAN utility.
• Successful in applying RDBMS patches, security patches for improving the security and functionality of the databases.
• Achieved optimized performance for the databases by rebuilding indexes, on tables and indexes.
• Extensively used AWR, ADDM and explain plan for periodic performance tuning.
• Implementing Datapump, conventional export/import utility of Oracle 12c, 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 and 11g environments.
• Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, and STATSPACK, SQL Trace & TKPROF, EXPLAIN PLAN.
• Database monitoring/maintenance, replication process and performance tuning are done using OEM (Oracle Enterprise Manager) .
• Automated the processes like moving files, managing alert log, efficient backup by developing UNIX scripts.
• Involved in the installation, configuration and extended support to Oracle 12c, 11g, 10g with ASM file system on Sun Solaris platform.
• Utilized TOAD for database management.
• Configuring data guard for high availability, protection and performance.
• Configuring active standby for reporting and analytical purposes