PROFESSIONAL SUMMARY:

• Overall 5 plus years of experience as Oracle DBA
• Worked on RAC, ASM, Data Guard, Grid Control, OEM cloud control.
• In depth knowledge of Software Development Life Cycle (SDLC) Phases such as Requirement analysis, Design, Development, Testing and Deployment
• Managed SQL Server Databases
• Worked on Data Center Migration projects
• Strong skills in setting up Data Guard
• Strong skills in Building ASM servers
• Build RAC from scratch
• Worked on Linux, Windows, AIX, HPUX Solaris and CentOS.
• Pose strong knowledge in Linux Administration.
• Strong skill in managing databases running on VMWare
• Pose strong skill in VMWare technology.
• 24x7 production database and applications support
• Involved in Database Design with Data Architects.
• Worked extensively on database refreshes
• Worked extensively on Cloning of databases
• Worked on Active Data Guard
• Worked on RMAN restores and recoveries.
• Redesigned database objects with grants, permission and roles.
• Setup of the database environments for the Dev and QA teams.
• Upgrade databases from Oracle 10g to Oracle 11g R2.
• Reorganizing Tables and Indexes for improving performance.
• Created the database objects based on the requirements for project requirement.
• Table space analysis, space allocations for tables, rollback segment monitoring and as member of application development team.
• Worked on Performance Tuning of the databases.
• Worked on Index tuning and SQL Tuning
• Worked with Developers in Deployment and Releases
• Worked on weekend and off hours to get project done on time.
• Worked on severity - 1 tickets with oracle
• Implemented complex business rules using database triggers and constraints.
• Adding, dropping users, creating Roles, Profiles and Grants based on the Role of the user.
• Planned and implemented database Backup on development and preproduction databases.
• Implemented Snapshots for remote objects for Reporting team.
• Testing of Backup's and Documenting backup strategies.
• Developed stored procedures, packages and database triggers.
• Performed Diagnosis & Tuned database and SQL statements as and when required.
• Managing Production as well as Development Instances.
• Identified and provided solutions for poorly written queries.
• Setup Uni-Directional Goldengate
• Provided on-call 24/7 support.
• Written Shell scripts
• Worked extensively on OEM, 11g grid control and 12c cloud control.
• Good knowledge in RAID Configuration.
• Worked with different teams to get the project done.
• Good knowledge in Dynamic Views and Dictionary Tables.
• Set up materialize views to provide replication.

TECHNICAL SKILLS:

Operating Systems: RHEL, HPUX, AIX, Windows, CentOS, Solars

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

High Availability: RAC, Data Guard, ASM, GoldenGate, Materialize Views

Languages: SQL, Bash Shell scripts, TSQL

Tools: RMAN, OEM, SQL*Loader, exp, imp, expdp, impdp, ERWIN, TOAD, etc

Tuning Tools: TKPROF, EXPLAIN PLAN, S TATSPACK, SQL Advisor, DBMS Stats

Database Modeling: Erwin, TOAD,

PROFESSIONAL EXPERIENCE:

Dubuque, IA 

Oracle DBA

Role & Responsibilities:

• 24x7x365 administrative support staff.
• Configured Data Guard to provide high availability by implementing Physical stand by database.
• Used RMAN duplicate database feature to move/clone databases on Linux, AIX and Solaris.
• Cluster Installation and Configuration, Administering databases in RAC for high availability.
• Installation, Configure, setup of 11g RAC on Linux.
• Add new nodes to RAC 11g Cluster to distribute the load.
• Installed and implemented 10g RAC with 4 nodes with ASM.
• Installing, configuring and maintaining Enterprise Manager Cloud Control to monitor and manage Exadata and regular databases
• Upgraded Databases from 10g to 11g and applied patches as per requirement.
• Worked extensively on data center migrations on multiple database versions. i.e, 9i, 10g and 11g.
• Responsible for installing and configuring GoldenGate on Oracle Servers.
• Database migration from 9i to 10g to 11g.
• Designed, configured and maintained backup and recovery policies including RMAN backups.
• SQL, PL/SQL Tuning and Monitoring.
• Compared and contrasted multiple snapshots using AWR.
• Experience in monitoring and tuning SQL Server and database performance using SQL Profiler, Index Tuning Wizard, and Windows Performance Monitor.
• Recovered databases and clone applications Using RMAN.
• Responsible for resolving several complex recovery scenarios (including RMAN) with critical production database.
• Extensively used AWR, ADDM, TKPROF, and SQL Trace for database performance statistics.
• OEM Grid Control installation and configuration for monitoring and performance tuning.
• Proactive performance monitoring, and capacity planning for future database and server growth.
• Performed Range Partitioning as a cause to improve the performance of the database.
• Performed Cross platform migration using transportable tablespaces and RMAN.
• Performed Import and Export using Oracle Data pump utilities
• Administered and maintained database security policies and procedures. Experience with administration of high-performance and large-scale multi-terabytes databases.
• Handled all standard database administrative tasks, such as: proactive performance tuning and monitoring, trouble-shooting, back-up and recovery, installations and configurations on an as needed basis.
• Used external tables and SQL*Loader to import data from flat files.
• Monitored database space requirements and adjusted for future needs.
• Performed version upgrades and patch installs.
• Designed and implemented database backup/restore methodologies, responsible for Troubleshooting performance and networking issues. Basic OS system administration.
• Perform database administration tasks as part of a scheduled change management task.
• Proficient in communicating directly with internal resources on a daily basis,
• Able to work effectively with multiple teams at once.

Confidential, TX

Oracle DBA

Roles & Responsibilities:

• Supported more than 30 databases 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.
• 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 datapump. 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.
• 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.
• 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.
• Performance Monitoring and Tuning of Oracle Application Servers using Statspack, TKPROF, and OEM for tuning on 9i and on 10g using SQL access manager, SQL tuning manager.
• Performed database cloning/exp/imp to setup identical databases in the production and development environments.
• Applied Quarterly CPU (CRITICAL PATCH UPDATES) on the entire database farm.
• Performed Export/Import through Data Pump.
• Build Grid control for Monitoring 40+ database.
• Provided technical troubleshooting and give consultation to development teams.
• Implemented basic replication through Materialized Views.
• Involved in monitoring the lock processes, releasing locks in case of resource blockage and gathering statistics.
• 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.