SUMMARY

• Worked on HA of the databases including RAC, ASM and Data Guard.
• Worked extensively on all database administration tasks on 11g and 12c databases
• Build RAC from scratch on Linux
• Build and manage databases on Solaris and AIX.
• Possess experience in SQL Server Database Administration.
• Worked as a lead in Data Center Consolidation on large database systems.
• Worked as a primary support for database related issues with clients.
• Worked on multiple projects in parallel to daily DBA activities.
• Designed Data Archival policy on high transactions tables using Bulk deletes, partition drops, exchange partition, Transportable Tablespaces.
• Implemented Disaster Recover Site with Data Guard, and maintained Physical and Logical Standby Databases along with Active Data Guard and Oracle GoldenGate.
• Performed Database Tuning & Performance, Storage Management, Plan growth and changes (capacity planning), Database Monitoring, Security Management and Tuning SQL queries.
• Used tools like TOAD, DB Console, Confio, and Grid Control to monitor database performance.
• Build and administer SQL Server 2005/2008 standalone and cluster databases.
• Evaluated Oracle features and Oracle related products to leverage existing hardware/software/incenses.
• Build, configured and managed 9i/10g/11gdatabases.
• 11g R2 Administration included:
• Installation of RHEL5, set up group/users, installing Linux packages and setting kernel parameters
• Upgrade from 10g R2 to 11g R2
• Build 11g R2 RAC from scratch including Linux OS installation.
• Installed11g R2, upgraded and performed Hot Patching
• Partitioning - system partition, virtual column base partition, reference partition, composite partition and range-range partition
• New features and enhancements of RMAN, Flashback and logminer
• Data recovery advisors
• SQL Access Advisor, Performance Analyzer, SQL Plan Manager, Automatic SQL Tuning, SQL performance analyzer, Table compression and SQL access advisor, SQL plan management and Database replay
• Table compression enhancement,
• Build and manage Active Data Guard
• Mentors the team on technology concepts and ensures team compliance
• Worked on 12c Grid Control to setup central alerting system for monitor targets to be proactive to ensure high availability while getting the best performance.

PROFESSIONAL EXPERIENCE

Confidential | Chicago, IL

Oracle DBA

Responsibilities:

• Configuring Oracle 11g and 12c on Linux and IBM Linux Servers, Oracle RAC, Data Guard, High Availability, ( Physical and Logical Standbys) Building Disaster Recoveries across multiple Data Centers and configuring ASM and Database Upgrades
• Worked on Planning Database, Sizing table space, Create database, scripts, Monitor database 24x7 production supports.
• Proficient in managing Oracle Instance, database storage structure, schema objects.
• Responsible for DBA functions and ETL development in Data ware housing.
• Performed upgrades from Oracle 10g to 11g and applied patches.
• Configured and Upgraded to Oracle 11gR2 from 10g and from 11.2.0.2 to 11.2.0.3
• Migrated databases from oracle 10g on Solaris 10 to oracle 11g on Linux
• Provided daily production support.
• Migrated to 12c Multi-tenant databases.
• Maintenance of Oracle 11gR2 Real Application Cluster (RAC) Database for High Availability, Scalability and Performance by determining the best Cluster architecture, choosing the best hardware configuration for Oracle RAC.
• Successful in installation/maintenance of 11g Active Data Guard
• Implemented switchovers on primary and standby databases during DR practices
• Upgraded databases from 10g to 11g to 12c
• Worked on Auditing and security with Oracle databases.
• Monitor and Configured Oracle 10g databases using OEM.
• Worked with Flash Recovery Area.
• Created and Managed user, table spaces, data files and archive log
• Performance Tuned and optimized SQL Query, SGA, and Disk I/O using Oracle Enterprise Manager and by monitoring the Stats pack report generated from snapshots taken at the peak business hours.
• Troubleshoot Database performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM). Tuned database for optimum performance.
• Communicate and coordinate with Oracle using My Oracle for major database issues/ problems
• Schedule jobs in crontab including RMAN backup and other memory maintenance, security jobs.
• Worked on oracle Public and Private Database Link.
• Applied client patches and other patches as required.
• Planned and Performed Daily, Weekly and Monthly Backups. Tested and implemented restore procedures for complete and incomplete recovery using RMAN.
• Perform capacity planning required to create and maintain database environments.
• Supported 24/7 on-call pager support for mission critical financial databases.
• Setup replication using 11g GoldenGate

Confidential, Minneapolis, MN

Oracle DBA

Responsibilities:

• Supporting Oracle Customers running various versions of Oracle database (9i, 10g and 11g.)
• Build 10g and 11g RAC
• Set up Data Guard
• Worked on various performances related issues.
• Worked with Storage team for ASM and other file system needs.
• Set up uni-directional Golden Gate for replication.
• Setup the materialize views for replication.
• Provided assistance to Customers In Solving ORA-00600 and ORA-07445 errors
• Provided assistance to Memory Corruption and Dictionary Corruption Errors
• Provided consultative services to implement the Memory configuration for Database Instance and ASM instances.
• Provided assistance to Implement Huge pages /Large Pages in Unix platforms
• Assistance to High memory utilization issues in Unix and Windows Platforms
• Worked on many data refreshing tickets using Data Pump and RMAN Duplicated database.
• Worked with Oracle Development and Oracle Bug Diagnostics Escalation Team for solving the bugs hit by the customer
• Provided assistance to numerous customers in production Database Hung and non-responsive issues
• Has good understanding of analyzing the hang analyze and system state dumps
• Supported application and professional services to manage their data ranging from GB to TB in oracle database, solving of space problem, data loading problem.
• Providing all round DBA support to resolve Application and DB outages on production, development, test and staging Customer environments across the Globe.
• Involved in resolving issues after Installations, Upgrades, Cloning, patching (both DB and Applications), CPU patches, and one off patches.
• Setup the RMAN Backups for all the Production databases satisfying RTO and RPO. Leading in performing periodic DR Drill and testing RMAN backups with various scenarios..
• Evaluated Oracle Database Monitoring and PL/SQL tools.
• Helped on Demand engineers in the dry run for disaster recovery test for On Demand Customer instances.
• Investigate, diagnose, and quickly resolve issues in production and testing environments. Work closely with the customers to quickly resolve production problems.
• Proactive database monitoring using 12c cloud control / 11g Grid Control
• Install Oracle supplied tools to assist in database and SQL Tuning like SQLT.
• Models compliance with company policies and procedures and supports company mission, values, and standards of ethics and integrity
• Provides and supports the implementation of business solutions
• Upgrade/Migration databases from Oracle 9i to Oracle 10g
• Worked on database migration from non-ASM to ASM.

Confidential, Bolingbrook, IL

Oracle Database Administrator

Responsibilities:

• Setup DB link
• Install database using dbca
• Setup tnsnames using netca and manage tnsnames.ora file
• Run scripts
• Document procedures in SharePoint.
• Create users
• Manage database users and profiles
• Reset database passwords.
• Created databases using OMF.
• Gather statistics.
• Install clients on user’s laptop.
• Troubleshoot connectivity issues.
• Worked on SQL Developer and SQL TOAD.
• Actively participated in gathering Business Requirements and System Specification from system users.
• Installation of Oracle on Linux and Windows.
• Performed installations of Oracle and SQL server databases.
• Created tables, indexes, table spaces, users, integrity constraints and supported all phases of a development cycle.
• Analyzed and suggest improvements to SQL queries and statements written by others.
• Developed stored procedures to pull the data from the distributed systems.
• Involved in preparing the User Test plans.
• Monitored of tablespace related issues like increasing the storage parameter values, resizing the data files, adding new data files etc.
• Database links (dblinks) were created to access the data from remote databases.
• Apply CPU patches.
• Created and managed Materialize Views
• Setup Backup using RMAN
• Created ASM instance
• Managed ASM Diskgroups
• Managed ASM using asmcmd