SUMMARY

• Over 7 years of experience as Oracle Database Administrator on a variety of UNIX (Solaris, HP - UX, IBM -AIX), RHEL, Windows 2000/2003/2008 with Oracle (8i, 9i, 10g, 11g) on both single instance and multi instance environment with 24x7 DBA support.
• Installed and configured oracle database server on SOLARIS, HP-UX, IBM-AIX, WINDOWS, and REDHAT LINUX.
• Created development, testing, staging, production, RAC and standby databases for OLTP, DSS and Data Warehousing.
• Migration/Up grading of oracle database from 8i to 9i, 9i to 10g, 9i to 11g, 10g to 11g,11gR1 to 11gR2.
• Installed Oracle 10g/11g RAC database server on two node, configurations, networking, tuning and maintenance using OFA, OMF, ASM and OCFS2 file system.
• Management of schemas objects & Partitioning the tables & indexes, USERS and PRIVILEGES, OEM Grid monitoring and have a great experience with Oracle Streams.
• Worked on all kinds of backup operations using RMAN (full database, data file, image copies, incremental backup sets, validating), using Flash recovery area, and recovery operations.
• Have implemented ORACLE STREAMS and worked on both types of standby databases supported by DATAGUARD (logical standby and physical standby).
• Extensively performed all kinds of backup and recovery using Hot/Cold Backup, Recovery and cloning of databases using RMAN, data pump and regular import/export utilities.
• Worked with ETL in different sources like database systems and applications in Gigabytes, Terabytes.
• Logical and physical modeling using Erwin.
• Expertise in PL/SQL, SQL and UNIX Scripting (Used to write UNIX Scripts & implemented by Using CRONJOB for Day - to - Day activities).
• 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, Sizing of tables and indexes.
• In depth knowledge and extensive working experience in oracle database administration such as data modeling, database design, methodology, DBMS web technology (HTTP, HTML, Perl scripts) and transaction management.
• Oracle Net: configuring listener, OID, net service names, working on tuning, starting/controlling listener server process, debugging using network utilities.
• Expertise in using all kinds of tool/utilities like Oracle universal installer, Enterprise manager, DBCA, Net manager, SQL*loader, SQL*plus, TOAD, SQL*navigator, ONCA, ASM and All Flashback features.
• Have Knowledge on Golden Gate.

TECHNICAL SKILLS

Operating Systems: HP-UX 10.x/11.x, Sun Solaris 8/9/10, AIX 5.2/5.3/6.1, Red Hat Linux RHEL 7.3/8/9, SUSE 10.0 and Windows NT/2000/2003

RDBMS: Oracle 8i/9i/10g/11g, Oracle 11gR1/11gR2 Real Application Clusters (RAC), SQLServer2005

Languages: SQL, PL/SQL, C#, C, C++, XML, Perl scripting, Shell Scripting

S/W & Application: OEM, DATAGUARD, Recovery Manager (RMAN), Datapump, STATSPACK, AWR, TKPROF, ADDM, ERWIN, Teradata, ETL, Clusters, Veritas Backup, EMC Storage, DTS, Developer 2000, SQL Loader, TOAD

Web & Reporting Tools: HTML, XML, Discoverer, DBI, BO, crystal reports

PROFESSIONAL EXPERIENCE

Confidential, Colorado Springs, CO

Oracle DBA

Responsibilities:

• Installed, configured and maintained Oracle 10g/11g databases on Linux, UNIX and Windows Platforms.
• Installed OEM 12C cloud control Grid Agents on UNIX, LINUX and Windows for monitoring production databases.
• Migration/Upgrading of oracle databases from 10g to 11g with low maintenance window and applied patches to various databases.
• Upgraded the databases to the current version of the patch sets. Applied 11.2.0.3 patch set.
• Setup Data Guard and Netapp snap clones. Setup load balancing and webcache - also configured shared application tier using VCS.
• Installed Veritas Cluster Services (VCS), Veritas File system (VFS) Veritas Net Backup etc., and archived original configuration.
• OnNetAppData Storage, developed new product database and participated in all aspects of the entire development cycle, including developer support, testing and implementation.
• Installed SQL Server Database engine on windows 32bit /64 bit platforms.
• Physical data models using ERWIN forward-engineered into DDL’s and rolled over to different schemas.
• Involved in the project creating and supporting a 4-node and 8-node RAC on Oracle 11g on Red hat Linux AS 4.0
• Created and maintained databases for business applications on various platforms in shared and dedicated environment.
• Responsible for application SQL tuning, database tuning and memory tuning.
• Monitored the Performance of the migrated databases using grid Control and features AWR, ADDM,
• Worked on testing, pre-production stages of RAC implementation on AIX 6.1/7.1.
• Configured Data Guard to ensure high availability, data protection and disaster recovery for enterprise data.
• Applied CPU patches each quarter to keep the databases up to date.
• Created TABLESPACES, partitions, indexes and other database objects on existing Siebel database.
• Configured, Installed and Managed Oracle Exadata.
• Managing the Data warehouse databases on Exadata, Quarter RAC { 2 node }, Half RAC { 4 node } and Full RAC { 8 node } ranging the sizes from 30TB - 50TB.
• Planned and Performed Daily, Weekly and Monthly Backups. Tested and implemented restore procedures for complete and incomplete recovery using RMAN.
• I have been responsible for multiple OLTP databases ranging from sizes 200GB - 4TB.
• Experienced in EBS11i installation, configuration and cloning.
• 24X7 production support and on call rotation.
• Performance tuning of application by identifying the SQL, which are not written well.

Environment: Oracle 11G, Oracle Enterprise Manager (OEM), OEM 11g Grid Control, DB2, RMAN, RAC, ASM, DB Artisan, Data Guard, EBS11i, AIX OS 6.1/7.1, Linux (RHEL 4.x, 5.x), Sun OS 5.8/5.9/5.10 , Toad, Golden Gate

Confidential, Austin, TX

Oracle DBA

Responsibilities:

• Worked extensively on monitoring 10G grid control database, configuration of error notifications, installing listeners, and adding them to the grid control.
• Creating new instances, refreshing databases, and cloning databases.
• Created development, testing, staging, production, RAC and standby databases for OLTP, DSS and Data Warehousing and Oracle Streams
• Providing support for production of Oracle databases.
• Keeping Oracle environments up-to-date by installing, upgrading, applying patches, etc.
• Backing up and recovering databases, improving disaster recovery strategy.
• Configured high availability solution such as ASM, Data Guard and RAC.
• Maintaining user accounts, Profiles and ensuring proper database security.
• Developed UNIX Shell scripts to automate database operation and database monitoring.
• Configured online and offline Database Backups using RMAN.
• Upgrading database from Oracle version 10gR2 to 11gR1and migration of data.
• Performance tuning of application by identifying the SQL, which are not written well.
• Write UNIX Shell scripts for database job atomization and use Perl script for upgrades.
• Resolved users problems, recovered database on demand. Created and managed database objects. Partitioning when implementing Oracle VLDB.
• Experienced in cross platform application migration.
• Experienced in Applying CPU and interim patches.
• Worked with oracle support 24x7 to expedite the process in resolving an issue.
• Developed or modified Oracle backup and recovery scripts. Used Oracle backup utility RMAN to implement Oracle backup and perform recovery.

Environment: Oracle 11gR1/11gR2, SQL, PL/SQL, EnterpriseLinux5.4, EBS11i, IBM AIX6.1, SUNOS 5.9, Windows Server 2003, Toad.

Confidential, IL

Oracle DBA

Responsibilities:

• Provided primary database administrative and Architect support for DB2 UDB V9.x databases.
• Installed upgraded and patched DB2 software and associated applications.
• Installation and configuration of Oracle 11g/10g/9i on Windows and AIX series.
• Monitoring and supporting more than 40 databases.
• Performed Database Refresh from Production to QA, UAT and Development databases.
• Storage, growth and file system space, in adherence to the Optimal Flex Architecture.
• Extensive experience in RMAN recovery testing, RAC and standalone database
• Created a Clone Database using RMAN on remote Server and used SRVCTL commands for Real Application Cluster (RAC) Databases
• Implemented Data Guard with high availability and performance configurations and Participated in Data Guard Fail over tests
• Monitoring Day-Day Backups, Log’s & recovering the mass per the requirement.
• Utilized LOG MINER Technology & applied Application Database Transaction other database.
• Supported development teams by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottle necks by using tools EXPLAIN PLAN, STATSPACK, and TKPROF.
• Cloned schemas, objects and data on new server using exports from10g database and imported to 11g database using data pump.
• Responsible for capacity planning, database security, recovery planning and installing patches
• Monitored Database Sizing, Table Space Management, Transaction Management and Security Administration.

Environment: Oracle11g/10g, Oracle10g/RAC, UNIX, Solaris10, TOAD, SQL, PL/SQL, TKPROF, Data Guard.

Confidential, CT

Oracle DBA II

Responsibilities:

• Review of Database logical and Physical design.
• Install, Upgrade and maintain Oracle 10g, 9i on Sun Solaris and Windows 2003, Redhat4 Installation, setup and configuration of DATA GUARD.
• Implementing Database Security, Management of role-based security.
• Write and modify UNIX shell scripts to manage Oracle environment.
• Extensive Performance Tuning, Memory (SGA) Tuning, Net backup, EMC (Time finder and SRDF), RAID, RAW Devices.
• Cloning databases using scripts as well as RMAN.
• Established database backup/recovery strategy for different databases.
• Management of table space growth, monitoring data files additions, extent growth.
• Constantly monitor the performance of the Databases and viewing Alert log files & Trace files.
• Implemented schema level, table level and bidirectional oracle streams.
• Used PL/SQL, SQL Loader as part of ETL process to populate the operational data store.
• Performed scheduling Control-m for scheduling jobs.

Environment: Oracle 10g and 9i, Sun Solaris, RHEL 4.2, Windows 2003 with Active Directory, OEM, RMAN, Export/Import, SQL, PL/SQL, SQL*Loader, TOAD, Erwin, STATSPACK

Confidential, Kansas City, MO

Oracle DBA I, II

Responsibilities:

• Developed Client-Server applications using front-end tools like Oracle Developer 2000 - Forms 5.0/6i, Oracle Reports 2.5/6i, SQL*Loader, Data Pump and SQL*Navigator.
• Created indexes, rebuild indexes and maintained indexes.
• Substantial development experience in creating stored procedures, PL/SQL Packages, Triggers and Functions. Strong knowledge in Oracle cursor management and exception handling.
• Involved in analyzing and adding new features of Oracle 10g like DBMS SHEDULER, Create Directory, Data pump, CONNECT BY ROOT in existing Oracle 9i application.
• Used EXPLAIN PLAN, TKPROF to tune SQL queries.
• Developed Complex SQL queries using various joins and developed various dynamic SQL’s thorough out the projects.
• Involved in designing numerous Oracle Forms and Reports by interacting directly with End Users and Business Analyst.
• Performed database tuning for daily loads and slow response issues.
• Used Triggers for database activities, like delete, update triggers.

Environment: ORACLE 9i/10g, SQL, PL/SQL, Toad v9/9.1, Cronjob, ETL, UNIX AIX 5.2, Windows NT/2000, SUSE 10.0, RHEL 7.3.

Confidential

Jr Oracle DBA/Developer

Responsibilities:

• Responsible for managing production, development & test databases and applications.
• Reviewing of database design document and creating ER diagrams, providing conceptual and logical data model and translating into physical database.
• Verify all instances are up and run daily reports and test scripts.
• Verify DBSNMP is running and success of database archiving to tape.
• Look in SQL*net for errors and issues.
• Worked on VERITAS volume manager and VERITAS Cluster Service.
• Archive all Alert Logs to history.
• Creation of Table space, Data files, Indexes, Rollback Segment and monitoring them.
• Responsible for configuring database memory structure, managing storage allocation, creating user accounts, roles and privileges for DB operations and security maintenance.
• Used imported/exported and SQL- loader to load data into tables.
• Wrote extensive Sub Queries, PL/SQL procedures, functions, database triggers and packages.
• Developing Hot/Cold and logical backup scripts to automate the backup procedures.
• Automated monitoring the databases, performance parameters, and backup/recovery activities by RMAN and VERITAS backup running Cronjobs and write UNIX shells scripts for job automation.
• Partitioned large tables to increase the performance.
• Interacted with data modelers, developers, application owners for gathering the required information and resolving various issues.

Environment: Oracle 8i/9i, import/export, SQL loader, shell scripts, SQL net, DBSNMP, PL/SQLVERITAS, SQL*PLUS, UNIX.