SUMMARY:

• 5+ years of solid experience on Oracle (9i/10g/11g) Database and RAC Administration in Installing, Administering, Migrating, Upgrading, Tuning, Troubleshooting and Managing over Multi - terra byte of databases on Linux, Sun Solaris and Operating systems on Production, UAT, Staging, Development environments.
• Installation of oracle 11g databases in production, development and test environments depending on project requirements.
• Collaborated with the UNIX system Administrator to configure any software and hardware requirements that will function with the Oracle Database
• Refreshing development/test database from production using Export/Import & RMAN backups.
• Making structural changes to the databases. Sizing database objects for effective space management and optimal performance.
• Managing database security.
• Installed, configured, and maintained Oracle 10g and 11 g R2 on Linux and also Upgraded from Oracle 10g to 11g.
• Involved in checking and managing tablespace growth, monitoring the data file growth and extents too.
• Involved in export and import of database objects in order to copy them from one database to another & for backup the tables.
• Responsible for continuous Monitoring of CPU usage, I/O contention, memory paging and identify the resource and performance bottleneck and reorganization for ensuring performance.
• Configuration & Administration of Red Hat Linux 3.X/ 4.X at various client servers and service provider's servers.
• Install FTP/TFTP/SFTP Server and set up network connections.
• Configure RAID control partitions.
• Install RPM packages for all the above mentioned modules on servers at client site as well as the service provider's site.

TECHNICAL SKILLS:

OPERATING SYSTEMS: Red Hat Linux RHEL 5.x and Windows XP RDBMS: Oracle 11g/10g

LANGUAGES: SQL, PL/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 DataGuard, Oracle Management Service (OMS), Real Application Clusters (RAC), ASM, Sql Navigator, TOAD, Data Pump (expdp, impdp), SRVCTL, SQL*Plus

TUNING TOOLS: SQL TRACE, TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM

WEB TOOLS: HTML, XML

WORK EXPERIENCE:

Confidential, Broomfield, CO

Oracle DBA

Responsibilities:

• Installation of oracle 11g databases in production, development and test environments depending on project requirements.
• Collaborated with the UNIX system Administrator to configure any software and hardware requirements that will function with the Oracle Database
• Refreshing development/test database from production using Export/Import & RMAN backups.
• Making structural changes to the databases. Sizing database objects for effective space management and optimal performance.
• Managing database security.
• Creating and assigning appropriate roles and privileges to users depending on the user activity.
• Defragmentation of tables and indexes for improved performance and effective space management.
• Have touch-point calls with offshore team and make sure all issues happen in off business hours are addressed with sense of urgency.
• Setup the unidirectional replication on oracle 11g databases using Goldengate.
• Monitoring and troubleshooting the gaps between source and target databases configured with golden gate.
• Successfully upgraded the databases from 11g to non CDB 12c.
• Successfully migrated 12c Non CDB databases to pluggable databases.
• Created Oracle Wallets and implemented Tablespace level TDE security.
• Managed Database Maintenance Activities to achieve optimum database uptime.
• Configuration of Listener and Tnsnames.
• 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.
• Planned database backups (operating system, full/partial backups, and export/import) using various types of backups and designed the backup methodology for the organization..
• Performed other Oracle DBA responsibilities performance tuning, monitoring tablespaces, monitoring users, etc. as well as much problem solving.
• Designed Logical and physical database for business transaction functionality.
• Provide production support for the deployed project till it is stabilized.
• 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.

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

Confidential, Chicago, IL

Oracle DBA

Responsibilities:

• Installed, configured, and maintained Oracle 10g and 11 g R2 on Linux and also Upgraded from Oracle 10g to 11g.
• Involved in checking and managing tablespace growth, monitoring the data file growth and extents too.
• Involved in export and import of database objects in order to copy them from one database to another & for backup the tables.
• Responsible for continuous Monitoring of CPU usage, I/O contention, memory paging and identify the resource and performance bottleneck and reorganization for ensuring performance.
• Monitored queries with high response time and high disk read per execution (Top SQLs) and tuning the same using Explain Plan, TKPROF and SQL tuning advisor.
• Involved in De fragmenting data blocks of table spaces for optimized performance. Also partitioned large tables to increase performance.
• Responsible for all database activities such as User management, space management, database security management.
• Implemented the resizing the online redo logs in production and in standby database.
• Automated Database refresh from the Host system to Oracle using, SQL and PL*SQL procedures.
• Implemented Logical and Physical Standby Databases for RAC cluster on Sun Solaris platform using Data Guard feature of Oracle 10g R2.
• Successfully performed data replication using Materialized views and Oracle Streams in Oracle 10gR2.
• Cloned/Migrated databases using RMAN and traditional Datapump export/import utilities in Oracle 10gR2.
• Implemented recovery strategies whenever required and successfully recovered databases in case database crash, media/disk failures by using RMAN.
• Scheduling the Physical backups (hot & cold) in CRON tab using RMAN utility and monitoring the scheduled jobs.
• Collecting performance statistics using Stats pack/AWR (Automatic Workload Repository) and analyzing by ADDM (Automatic Database Diagnostic Monitor)
• Rebuilding indexes or analyzing the index as per the fragmentation level and minimize the performance issues.
• Refresh/Cloning of Database from production environment to test environment and application of patches.
• Monitoring the CPU usage, IO statistics, and CPU time to identify any OS level Performance killers
• Experienced of managing and administering 24 X 7 running databases and support
• Applied bug patches according to the Oracle Critical Patch alerts.
• Configured the automated alerts for the production servers, which alerts DBA with the alert log errors and proactively space related errors.
• Applied patches 10.2.0.2 and 10.2.0.3, 10.2.0.4 and 11.2.0.3.
• Responsible for Creating Users, Groups, Roles, Profiles and assigning the users to groups and grant necessary privileges to the relevant groups.
• Constantly monitor the performance (V$ dynamic performance views at peak load) of the Databases and viewing Alert log files & Trace files.
• Used to run the scripts to check the status of databases such as growing table sizes, extent allocation, free space, used space, fragmentation etc.
• Performed space management, capacity planning, disaster recovery and overall maintenance of the databases.
• Used SQL TRACE, TKPROF, EXPLAIN PLAN utilities for optimizing and tuning SQL queries.
• Maintained the data integrity and security using integrity constraints and database triggers.
• Provided 24X7 supports for all the production and development databases.

Environment: RHEL 5.X; Windows NT 2000/2003; Oracle 10g, 11g

Confidential, IL

Oracle DBA

Responsibilities:

• Configuration & Administration of Red Hat Linux 3.X/ 4.X at various client servers and service provider's servers.
• Install FTP/TFTP/SFTP Server and set up network connections.
• Configure RAID control partitions.
• Install RPM packages for all the above mentioned modules on servers at client site as well as the service provider's site.
• Install and execute health monitoring module and dial up connection reporting module on client sub systems and monitor the communication failures etc.
• Configure servers to use HTTP, DNS, NFS, NetBackup, Storage Disk configuration.
• Diagnose and correct boot failures arising from boot loader, module, and file system errors on Red hat Linux.
• General Network issues troubleshooting related to network outages.
• CRON tab entry experience.
• Use ILO/HMC for remote access of servers on Red hat Linux/AIX respectively.
• Troubleshoot hardware, software and Operating system related errors on Red hat Linux and AIX.
• Performed system-monitoring tools like TOPAS, SAR, VMSTAT, IOSTAT to report systems usage and performance.
• Monitor database systems and provide technical support for database system issues and application performance enhancement/improvement using both Oracle 10g Grid Control & SQL*Plus, as well as UNIX shell scripts.
• Worked closely with Application Developers to design/create new Oracle databases/create new schemas/ database objects, as well as making database changes from DEV to PROD, via TST following requests/ demands from the development team.
• Backup/Recovery of Oracle 9i/10g databases using Oracle RMAN.
• Maintain & troubleshoot Storage Disks from HITACHI, NetApp and EMC Celerra Storage arrays.

Environment: RHEL 3.X, 4.X; Windows NT 2000/2003; Oracle 10g; LPARS; VMware ESX Server; VERITAS Volume Manager; HP DL320, DL330, DL380; EMC Celerra NS; Hitachi; IBM arrays.