SUMMARY:

• Around 13 years of experience in the information Technology filed as a Oracle Database administrator in System Analysis, Design, Development, Implementation, Administration, Testing maintenance and support
• Experience as Oracle DBA (12c/11g/ 10g /9i/8i) on different HP - UX, Sun Solaris, RHE Linux, AIX, and Windows 2000/NT environment.
• Experience in full life cycle of database administration. Worked both as a Development DBA and a 24x7 Production Support DBA.
• Experience in Oracle Real Application Clusters (RAC) Installation, administration, troubleshooting and Performance tuning in 10g and 11g.
• Experience in Oracle database Installation, administration, troubleshooting and Performance tuning in 8i, 9i, 10g and 11g.
• Implementation of High Availability solutions with Oracle 11g RAC on ASM, Physical and Logical Standby Databases (Data Guard) Thorough Experience with supporting the Production Database with complete life cycle including Installations, Upgrade, Patching, Cloning, Backup/Recovery, High Availability including Oracle Real Application Cluster (RAC) and Data Guard.
• Oracle Golden Gate configuration and administration.
• Knowledge in various states of System Development Life Cycle (SDLC). Like System Analysis, Applications Design, Development, Integration & System Testing Support of Oracle 8i, Oracle 9i, Oracle 10g and Oracle 11g and 12c in Production, Staging, and Development environments.
• Expertise in Installation, Configuration, Upgradation, Patching and Maintenance of Oracle Production and Development Databases.
• Implemented advanced features of Oracle 11g/10g such as Automatic Database Diagnostic Monitor (ADDM), Automatic Workload Repository (AWR) for monitoring database performance.
• Proficient in implementing and maintaining Database Security (Users, Roles, Privileges), space management (logical structures such as tablespaces and rollback segments) and auditing of users.
• Expertise in creating primary database storage structures (Tablespaces) and primary objects.
• Designed and implemented Oracle Database Back up & Recovery.
• Hands on experience with tools like SQL*Plus, Export and Import Utilities along with Oracle Enterprise Manager (OEM).
• Hands on Experience in Space Management, Capacity Planning.
• Creating Users, Roles and Profiles, Privilege management with role-based security.
• Backup of database Logical and Physical (hot and cold) using Backup script procedures and also using RMAN.
• Migrated Database between different data centers and hosted on different platforms using Data pump Expdp / Impdp.
• Database encryption, oracle wallet, TDE
• Ability to work under extremely tight deadlines and can maintain focus on objectives and processes and troubleshooting, implementation and development skills.
• Worked in 24x7 production environment and provided on-call and day-to-day support.
• Strong communication and Interpersonal skills, Commitment to team work concepts.
• Effectively handle multiple tasks simultaneously and have ability to acquire and apply knowledge rapidly.
• Co-ordination with Confidential for technical support, new products and releases, technical discussion/support.

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

Sr. Oracle Database Administrator

Responsibilities:

• Installed and configured 11g on different operating systems of AIX and Linux.
• Installed and configured 12.1.0.1 on operating systems of Linux.
• Created a physical standby for Disaster Recovery (DATA GUARD).
• Oracle Golden Gate configuration and administration.
• Created a Active Data guard.
• Configuration and administration oracle ASM
• Installed and configured 11g Real Application Clusters (RAC) on Linux.
• Taking backup of databases using RMAN.
• Upgrading Oracle RAC cluster and database from 11.2.0.3 to 11.2.0.4
• Responsible for applying CPU and PSU patches on most of the production databases
• Used tools like export/import and data pump export/import.
• Applied Patches includes PSU and Bug-fixes for database.
• Experienced writing UNIX scripts and troubleshooting issues.
• Installed Oracle Configuration manager on various production environments
• Good experience in managing the databases using the OEM grid control like Scheduling backups, performance monitoring, alerts setting, generating reports in seconds, email notifications, Black out instances during maintenance/down times etc.
• Supported development databases and test databases .
• Performance tuning.
• Worked on Database encryption and oracle wallet
• Designed and implemented Oracle Database, Back up & Recovery.
• Is responsible for handling the performance issues and undertaking the 24x7 on call support.

Confidential, Minneapolis, MN

Sr. Oracle Database Administrator

Responsibilities:

• Installed and configured 11g Real Application Clusters (RAC) on Linux.
• Oracle Golden Gate configuration and administration.
• Experienced in working and monitoring the databases by using Oracle Enterprise Manager (OEM).
• Supporting both production and development activities.
• Creating of databases for Testing, Development and Production.
• Setup of Standby database for faster disaster recovery and Data Guard setup for high availability.
• Installation of Oracle version 10g and 11g on Linux.
• Applying patches whenever required.
• Migration of Database from 10.2.0.2 to 11.2.0.2 using DBCA and Performed Validation tests.
• Maintenance of Oracle Database. Rebuilding of Indexes, creating and managing Table spaces and allocation tables to different tablespaces.
• Taking AWR reports and analyzing the statistics for performance issues and resolving them.
• Taking periodic Backup of the database and the software using RMAN.
• Designed and implemented Oracle Database, Back up & Recovery.
• Administrating MSSQL databases.

Confidential, Indianapolis, IN

Sr. Oracle Database Administrator

Responsibilities:

• Oracle databases migration from 10.2.0.4 to 11.2.0.4 in between different data centers.
• Upgrading oracle database from 10.2.0.2 to 10.2.0.4.
• The work involves overall maintenance of ORACLE database, performance issues, tuning, backup, recoveries and other database related activities.
• Checking of Alert log and Trace files to monitor the database on a daily basis. Also wrote monitoring scripts to check reports for space, Max. Extents, coalescing etc. which are kept in CRONJOB.
• Day to day performance monitoring and tuning of database.
• Installed and Configured Oracle Data guard for Oracle 11g &10g
• Creating users granting the permissions and coping with the day-to-day demands and troubleshooting their connectivity, permissions and performance problems worked with users to determine system requirements.
• Database activities include allocation and maintenance of Rollback Segments, Automatic Undo management, table spaces, data files, redo log files, mirroring of redo log files across multiple disks.
• Designed and implemented Oracle Database, Back up & Recovery.
• Provided 24*7 System support.

Confidential, St. Louis, MO

Sr. Oracle Database Administrator

Responsibilities:

• Installation, Upgradation of Oracle 10g databases on Linux Server.
• Backup of database using RMAN
• Provided System support for both development and 24/7 production environment.
• Taking care of all alerts for space issues and user requests.
• Assisted in configuring optimal Oracle 10gR2 RAC architecture.
• Worked on Migrations from 10g to 11g.
• Managing database security. Creating and assigning appropriate roles and privileges to users depending on the user activity.
• Applying patches and Migrations works and work closely with Oracle to keep application environment up to date.
• Designed and implemented Oracle Database, Back up & Recovery.

Confidential, Buffalo, NY

Sr. Oracle Database Administrator

Responsibilities:

• Installed 10gR2 database on Linux and AIX.
• Provided database related services to their development and QA environments.
• Data exports from production and staging databases.
• Tuned production database performances and was instrumental in SQL tuning that improved application response.
• Analyzed business requirements and built logical data models that describe all the data and relationships between the data. Designed and implemented physical database
• Installation and configuration of Oracle 10g database server and their version upgrades.
• Responsible for performance tuning. Extensively worked SQL tuning, database tuning and operation systems tuning.
• Used several utilities and tools to perform performance tuning & monitoring
• Applied patches, successfully upgraded Oracle. Worked on Storage, Network configurations.
• Designed and implemented Oracle Database, Back up & Recovery.

Confidential

Technical Specialist

Responsibilities:

• Supported around 600+ Oracle Servers in Confidential, NL.
• Supporting, monitoring, administrating oracle 8i/9i/10g databases
• All aspects of Database Administration, involved managing large size databases supported very large SAP databases and MAX DB with 24x7 support.
• Customer management and Escalation management
• Involved in transition phase and setup the project from initial stage and make the project stable.
• Cross verifying service Manual and updating Service Manual.
• Creating Work Instructions and documenting the process involved.
• Generating reports and managing the dashboards.
• Involved in regular meetings with Service desk and Incident Management.
• Coordinating with client and relevant technology teams for access issues and approvals.
• Knowledge transfer to new joiners, sharing best practices with the Team.
• Develop strong inter-personal relationships with the team to cohesively bond them together.
• Worked on service now and remedy ticketing tools.
• Managing Team.
• Ensure Client is informed and kept up to date of Incidents/Service resolution and progress towards it

Confidential

Sr. Systems Engineer

Responsibilities:

• Worked on data center setup
• Supporting Oracle databases for telecom billing system
• Supporting End to End IT operations
• Managing IT Support Team.
• Created oracle 10g databases on sun Solaris and HP Unix and windows servers.
• IBM rational clear case and clear quest oracle database support.
• Monitoring database using Toad.
• Managing Quantum Tape Library and HP EVA storage administration.

Confidential

Oracle DBA

Responsibilities:

• Administration ad monitoring 8i/9i Oracle Databases on windows servers
• User administration.
• Alert log monitoring.
• Tablespace administration.
• Temp and undo management.
• Export and import.
• Monitoring databases using TOAD.
• Rollback segment management.