SUMMARY

• Overall 9+ years of total experience in the IT Industry, inclusive of extensive 8+ years of experience in Oracle 9i/10g/11g/12c Architecture, RMAN backups, Crash Recovery, Optimization, Performance Tuning, Troubleshooting in Production, Test and Development Instance environment with very large scale database and mission critical large OLTP and OLAP systems ranging from 30gb to 5TB in a variety of hardware and software platforms including UNIX/Linux, Sun Solaris, HP - UX, AIX
• Installed and Cloned Oracle database 10g, 11gR2, 12c Servers on RHEL
• Installed and Cloned Oracle 10g and 11g Grid Agents
• Created ASM disk groups with failure groups for normal and high redundancy.
• Applied scheduled CPU patches every quarter on production, QA and development.
• Schedule and Monitor RMAN incremental/daily and full/weekly hot backups for the databases through grid and manually. Maintained and monitored the jobs on a daily bases.
• Responsible for supporting Oracle 11g databases for multiple applications. This involved maintaining various schemas/users along with their roles, profiles, privileges and objects.
• Perform restore/recovery for databases when needed via RMAN. Performed a point in time recovery.
• Migrated data using EXPDP and IMPDP across databases using the TRANSPORATABLE TABLESPACE parameter.
• Scheduled jobs in UNIX via crontab.
• Written Shell script.
• Worked on configuring memory management parameter in an effort to tune istances.
• Used data stage to migrate data from SQL server to oracle database. Migrated from object oriented environment to relational environment.
• Created and maintained database objects like Tables, Indexes and Partitions.
• Ran AWR reports for performance tuning database.
• Monitored Oracle Streams Environment. Checked status of streams and started and stopped streams. Informed developer if streams were not working. Created reports on streams using dictionary views.
• Performed database upgrades to 11.2.0.3 from 11.2.0.2.
• Did database migrations using EXPDP, IMPDP, transferring database files etc.
• Installed and maintained the Oracle Grid Infrastructure.
• Created and upgraded Oracle Databases using DBCA (Database configuration Assistance) in UNIX environment.
• Configured jobs for backup of database. Monitored database backups.
• Setup Transparent Data Encryption for Table Columns.
• Setup Data guard for High Availability. Familiar with Data guard Broker.
• Wrote scripts to identify segments that are being used in queries but are not giving good performance.
• Hands on experience with 11g new features like Real Application Testing, SQL Performance Analyzer, setting AWR baselines, SQL Profiling using SQL Repair Advisor, using Automatic Diagnostic Repository, using support workbench, Oracle Secure Files etc.
• Extensive use of AWR to generate database statistics, ADDM to find the performance issues and get recommended solution to improve the performance.
• Installed and configured Grid Control to monitor RAC and Non RAC instances, patched and upgraded the Grid Control to 10.2.0.4.
• Supported production being on call 24/7.
• Hands on experience in working with VMWare database environment.

TECHNICAL SKILLS

Operating Systems: Linux, Windows, AIX HPUX, Sun Solaris

RDBMS: 10g, 11g, 12c, SQL Server 2005, SQL Server 2008

Documentation: Microsoft SharePoint, Microsoft Office

Tools: & Utilities: TOAD, Grid Control, SQL Developer

High Availability: RAC, ASM, Data Guard, Materialize Views, Golden Gate

Languages: SQL

PROFESSIONAL EXPERIENCE

Confidential, Detroit, MI

Oracle DBA

Environment: Oracle 12c, 11g, RAC, ASM, Data Guard

Responsibilities:

• Installed databases using silent install.
• Performed Database refreshes using RMAN duplicate database
• Performed schema level refreshes
• Build 2-node RAC cluster.
• Migrated databases from standalone to 2-node RAC clusters.
• Setup DR using Data Guard.
• Put up monitoring scripts for Data Guard
• Modified / added functionality in existing monitoring shell scripts.
• Applied PSU / one off patches
• Provided on-call support.
• Scan databases for security issues
• Provided support to offshore DBAs.

Confidential, Seattle, WA

Oracle DBA

Environment: Oracle 12c, 11g, 10g, 9i, Toad, RMAN, Data Pump, SQL Developer

Responsibilities:

• Installation of Oracle 11g, 10g, 9i installation and Configuration.
• Build RAC on 2 nodes, 3 node clusters.
• Add/Remove node to/from existing RAC.
• Supported multiple database farms including development/production sizes up to 5 TB for 24/7.
• Designed, Installed and configured the Oracle server software and related products. Upgraded 30+ databases from 9.2.0.6 to 10.2.0.1 to 10.2.0.3 to 11gR1/R2 on RHEL and AIX.
• Completely build RAC from scratch including OS and RAID configuration.
• Scheduled meetings with application team for database migration review to gather legacy information such as type of application, database options, current oracle configuration, capacity and oracle outstanding tasks.
• Setup and documented Oracle GoldenGate replication on 11g for support team.
• Developed, revised and implemented policies, standards, procedures and guidelines necessary to effectively administer the database environments.
• Ensure databases adhere to corporate standards and policies. Worked with application team, developers, change management team and DBA team to ensure smooth life cycle progress from development through testing and production implementation.
• Monitoring and maintaining 2/3 node RAC database on Red Hat Linux. Providing support to the development team and handling release schedules.
• Maintaining sound backup and recovery policies and procedures using RMAN. Monitoring the scheduled backup procedures for daily basis using crontab.
• Database refreshes using export /import and data pump. Used RDA, ADDM and AWR reports to monitor the database performance.
• Used power designer, E/R Studio for data modeling and to estimate the database size, database design reviews.
• Developed and maintained PL/SQL Stored Procedures, Packages, Functions and Database Triggers. Developed and maintained shell/Perl scripts for setting up batch jobs and managing release scripts.
• Implemented SQL outline to get the better execution plan for the offending queries. Setting up analyzing scripts and coordinated with development team to gather table statistics.
• Perform Database Tuning & Performance, Storage Management, Plan growth and changes (capacity planning), Database Monitoring, Security Management and Tuning SQL queries.
• Day to Day General Administration Tablespace Management, Undo Management, Managing Users, Resources, Managing User Privileges and Roles.
• Diagnosed Oracle bugs and coordinating with Oracle support through metalink to resolve them in timely manner.
• Performed various tasks like Administering RAC using SRVCTL, Adding nodes and instances, Administering Storage Components, Parameter Management, and Configuring High Availability Features for RAC.
• Primary DBA for 1GB - 2.5TB database for 24/7 support.
• Upgrade Data warehouse Database from 8K block size to 32K block size to optimize performance.
• Worked on OLTP and Data warehouse farms.
• Refreshed multiple databases for Development and Testing upon short request.
• Served as part of a 7 member DBA team which was involved in the maintenance of the Oracle 9i/10g database for the Production as well as the development environments.
• Actively involved in designing/Testing of Disaster Crash recovery.
• Improving the performance of the database by tuning SQL and database instance parameters using Automatic Database Diagnostic Monitor and SQL Tuning Advisor in Oracle 10g.
• Created and maintain users, roles and privileges.
• Involved in discussions with the management regarding the advantages/disadvantages and upgrade plans.
• Perform Backup and Recovery thru RMAN.
• Provided technical troubleshooting and give consultation to development teams.
• Performed Database Refreshes and Database Copies for Development, Test and Production databases.
• Implemented basic replication through Materialized Views.
• Initiated cronjobs to review alert logs and dump files to check for any ORA- errors.
• Used Oracle 10g AWR & ADDM to monitor database activities and performance tuning.
• Performed Database Administration using TOAD, Oracle Enterprise Manager and SQL scripts.
• Installed, migrated, configured and tested Oracle 11g databases in various environments.
• Extremely dedicated, self - motivated, Pro-Active and willing to assume responsibility.

Confidential, Chicago, IL

Oracle DBA

Environment: Oracle 11g/10g, 9i, Toad, RMAN, Import/Export, Oracle OEM, WinScp/FTP.

Responsibilities:-

• Oracle client installation.
• Configure TNS names.
• Oracle 10g, 9i installation and Configuration.
• Apply Patches to existing versions.
• Worked on Windows and Linux database farms.
• Installed oracle 10g from scratch on a new server
• Configured backups
• Written batch jobs to automate backsups.
• Refreshed schemas.
• Creating and dropping of users, granting and revoking permissions to users/roles as and when required
• Ensuring successful & periodical Backup & Restoration.
• Develop, Implement and administer database policies and procedures.
• Perform database analysis, design, coding, testing and implementation of database structures.
• Used Oracle backup utility RMAN to implement Oracle backup strategy.
• Capacity planning, capacity monitoring and management.
• Managed day-to-day production databases.
• Monitoring CPU, memory, disk I/O, paging, and swapping using various UNIX commands.
• Analyze disk space requirements.
• Reported to Lead DBA upon all project completion. Configured RMAN backup for 10g RAC database
• Monitoring 10g RAC performance
• Configured and Managed ASM disks and disk groups thru both Grid Control and ASMCMD utility.
• Data modeling / Logical database design and implementation (including index design)
• Upgrade from 9i to 10g
• Provide assistance in migrating databases.
• Troubleshoot Oracle Net issues.
• Worked with Oracle on ongoing issues.
• Applied CPU patches.
• Configuring and using the Oracle Enterprise Manager in 10g for Performance, Maintenance and Administration tasks
• Create and maintain multiple databases.
• Provide 24/7 on call support
• Created and maintain documents on SharePoint.