SUMMARY

• Over 9 years of Oracle experience.
• Excellent experience in administering 10g/11g Real Application cluster (RAC).
• Excellent experience in installing and patching database in both RAC and standby configuration.
• Oracle Linux/Solaris/Windows OS OracleRDBMS & and SQL Server databases
• Installation, configuration, cloning, maintaining concurrent managers, user management issues and space management, Patching (database and application patches), backups (logical and physical)
• Oracle RAC 11g/12C grid Infrastructure one node, multi node installation and configuration schema updates, data migrations, tech upgrades, user maintenance, troubleshooting, backup management, performance tuning, data recovery, and disaster recovery planning
• Documentation, software development methodology, version control, testing, and migration standards
• Performance Tuning of SQL statements and Database using tools like AWR, Explain plan, TKPROF, SQL Analyze, STATSPACK and Dynamic Performance Views.
• Oracle Active Dataguard for high availability/disaster recovery setup (implement and test DR plan)
• Replication, Performance Tuning, RMAN, ASM, RAC, OEM
• Handled more than 400 databases with max size of 15TB.
• Data Pump and Exp/Imp utilities, replication of tables to cross platform and Creating Materialized Views, PL/SQL and stored procedures and SQL scripting,
• PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Created PL/SQL stored procedures, functions and packages, creating indexes on the tables for faster retrieval of the data to enhance database performance.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.
• Diagnosis and troubleshooting typical SQL, PL/SQL Tuning issues
• Data modeling, Table restructuring in oracle database
• Disaster Recovery Strategies, testing & implementation
• Support and manage Onsite - Offshore model for Production in 24/7 systems, Development and Test instances and Oracle Applications environments of varied complexity.
• Installation and basic administration of Microsoft SQL Server 2000

TECHNICAL SKILLS

Platforms: Sun Solaris, IBM AIX, Windows XP/2000/ 98, Windows Server 2003, Linux

Database: Oracle 12C, 11gR1/R2 (11.1.0.7/11.2.0.3/11.2.0.4 ), Oracle 10g, Oracle 9i/8i, MS-SQL Server (7,2000) 11gR2 active dataguard

Languages: PLSQL, UNIX Shell Scripts, T-sql, C, C++

Tools: OEM, RMAN, TOAD 9.5, Golden gate, SSIS, Jira, Remedy, HP Quality Center, Autosys

PROFESSIONAL EXPERIENCE

Confidential, St. Louis, MO

Senior Oracle DBA

Responsibilities:

• Responsible for database infrastructures, strategies, enterprise solutions, administrations.
• Database up gradation to its higher release like 10.2g to 11.1g and 11.1g to 11.2g, 11g to 12c.
• Defined and implemented HA/DR solutions using Oracle Data Guard, Oracle RAC for the company’s mission critical applications to maintain business continuity.
• Looking into day-to-day activities of Production database, monitoring its growth and performance.
• Worked on Backup and Recovery strategies, improve database functionality, consolidate databases, and provide periodichealth check to ensure your system is operating at maximum efficiency.
• Experience with Java application support and troubleshooting.
• Strong understanding in PL/SQL and SQL and able to write SQL query.
• Actively participate in developing Shell scripts to automate and monitor.
• Working knowledge of ticketing tool (HP Service Manager/Remedy/ITSM7).
• Monitoring the jobs through Autosys and will fix the bug.

Environment: Oracle 10g, 11g, 12c, SQL, PL/SQL, Linux/Windows, RMAN, Oracle Enterprise Manager (OEM), SQL server, Autosys, Jira

Confidential, Chicago, IL

Senior Oracle DBA

Responsibilities:

• Involved as DBA for knowledge transfer activity.
• Database support (Monitoring, Administration, and Tunings & Backup) in oracle 9i, 10g, 11g
• Database upgradation to its higher release like 10.2g to 11.1g and 11.1g to 11.2g.
• Responsible for implementation and management of dataguard. (logical database)
• Remote database administration of the instances.
• Looking into day-to-day activities of Production database, monitoring its growth and performance.
• Hands on experience with Refreshes using rman and user using veritas managed methods.
• Experience on working on the DB’s hosted on Clustered Servers.
• Linux crontab configuration to automate the shell scripts. Extensively worked on DBMS JOB and DBMS SCHEDULER.
• Working on DR Drills.
• Perform database software installation/patching/up gradation to development, test and production servers.
• Management of oracle Instance, physical structure of the database like data files, redologfiles, control files (mirroring of the control file) and Storage management.
• Creating users with restricted access, profiles and attaching them with users
• L1+ work for SQL server.
• Working knowledge of ticketing tool (HP Service Manager)

Environment: Oracle 8i, 9i, 10g, 11g, SQL, PL/SQL, Linux/Windows, RMAN, Oracle Enterprise Manager (OEM), SQL server

Confidential, Phoenix, AZ

Oracle DBA / Developer

Responsibilities:

• Responsible for, both manage and support all Production, Development and Staging instances of Oracle Version 8i, 9i, 10g.
• Maintaining databases in 24x7 Production environments.
• Monitor and troubleshot various database remotely.
• Also refreshing Database as per the requirements of the clients (CLONING, Export, Import, Datapump).
• Ensuring successful & periodical Backup & Restoration.
• Develop, Implement and administer database policies and procedures
• Writing scripts for informing the DBA’s regarding the status, performance and Space Management of the Database.
• Provide 1st level technical support and assistance to all database end-users.
• Install new versions of database software and perform maintenance functions of the database.
• Reorganization of tables, indexes, table spaces, data files, redo log files, and control file as per the requirements of the databases performance and space management requirements of the Servers.
• Database Backup Management using exports or online backups./Data Pump.
• Monitoring the database for CPU utilization and killing unwanted user processes.
• Plan for system growth and monitor capacity usage for new hardware or software requirements and communicate these capacity requirements to management.

Environment: Oracle 10g/11gR2, SQL PLUS, PL/SQL, Solaris, Linux/ Unix, Oracle Enterprise Manager (OEM)

Confidential

Oracle Database Administrator

Responsibilities:

• Installation of 3 nodes RAC with Golden Gate
• Resolved the issues happened during replication.
• Nesting period of one month under process trainer.
• Installation, Configuration and troubleshooting of Windows NT 4.0 Workstation, Windows 2000 Professional, Windows Xp Professional..

Confidential

Oracle DBA

Responsibilities:

• Specialized to handle severity 1 (mission critical, business loss situation) and escalated issues.
• Analyzing statspack/AWR reports to identify performance problems at instance level.
• Working with development in resolving bugs with Oracle 8i/9i/10g/11g.
• Worked with IT managers and application developers, bug developers in resolving critical database issues.
• Train and coach new joiners in the team.
• Helping others in technical issues via oracle community and oracle forums.
• Create a duplicate database or cloning of database for testing purpose from production.
• Creation of new database.
• Writing Shell scripts for monitoring the Oracle databases and scheduling the jobs.
• Working on backup failure issue and providing the solutions in minimum time.
• Recovery of latest data in case of database failure.

Confidential 

Oracle DBA

Responsibilities:

• Maintenance of Oracle production and development databases in RAC as well as for single instance environment.
• Capacity and Storage planning for future storage requirements
• Managing Database Structure, Storage Allocation, Table/Index segments, and Rollback segments, Constraints, Database Access, Roles and Privileges.
• Checking Alert log & monitoring growth of the Tablespaces.
• Managing Oracle by using OEM
• Creation of Users under the Security Management.
• Planning and scheduling backups using Cron
• Backup, Export/Import and various database issues
• Testing Recovery Strategies by Simulating Database Crashes on Development Systems
• Computing the statistic of database through monitoring dynamic and performance tables regularly & Implemented SQL scripts to monitor & to get information on free space, Extents, Tablespaces.
• Tuning database, applications, memory, and disk usage
• Monitoring and optimizing the performance of the Database
• Capacity Planning, Minimize the database down time.
• Rebuild standby database from primary database.
• SQL Tuning
• Apply CPU patch on oracle databases, supporting unix administrators for OS patching
• Upgradation from 10.2.0.4 to 10.2.0.5.
• Check and provide the resolution for grid alerts, job failures, and tablespace issues.
• Rebuild standby database from primary database.