SUMMARY

• 5+ years of IT experience, which includes MSSQL and Oracle Database AdministrationVer. 12C/11G on a variety of OS like LINUX, UNIX, and Windows, and Good experience in Installation, Configuration, Upgrades, Space Management, System maintenance, Cloning, patching, Sql*Plus, Performance Monitoring, Tuning, Backup and Recovery (RMAN), T - SQL
• Installed oracle database server on WINDOWS, LINUX and migration of oracle database server from 11g to 12c and applied oracle patches.
• 24*7 production database support to developers & end-users.
• Having hands on experience in Hot/Cold Backup, Recovery and Cloning of databases using RMAN.
• Implemented full, incremental and cumulative backup using RMAN and recovery, incomplete recovery and disaster recovery using Standby database or Data Guard.
• Hands on experience in Performance tuning of the database - SQL Tuning, Used Tuning utilities like EXPLAIN PLAN, AWR, ADDM and Tuning of SGA, Distribution of disk I/O, Sizing of tables and indexes.
• Performance Tuning like tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms
• Installed and Configured of Oracle Grid Control.
• Logical backups using full export and DATAPUMP.
• Experience with cloning production database to refresh development and test environments (including RMAN Cloning, and Traditional Cloning).

TECHNICAL SKILLS

• Oracle 11g/12c
• MSSQL
• Database up gradation 11g/12C
• Disaster Recovery Solutions
• Recovery Manager (RMAN)
• Security Administration
• Oracle Enterprise Manager (OEM)
• Performance Tuning (DB)
• Linux/Unix Shell Scripting
• Developing with PL/SQL

PROFESSIONAL EXPERIENCE

Confidential, Washington, DC

Oracle Database Administrator

Responsibilities:

• Projects and 24/7 production support Remote and at onsite.
• Parameters, database growth and help in database process like refresh, cloning, data loading etc.
• Involved in the Design of Backup and Recovery Strategies using RMAN, and Configuring Oracle Data
• Guard.
• Setup Oracle Streams and Golden Gate for Site to Site Replication.
• Migrated Oracle Databases from 11G to 12c, Installed and migrated OEM 11g to OEM 12c, 13c.
• Database performance tuning in order to improve application and database performance give recommendation to application team e.g. Index Scan or Full table scan. Run ADDM, AWR report etc.
• Worked with Netapp’s Snap Manager for Backup and Recovery for the database.
• Troubleshoot critical issue on call like resolving ORA errors in production, check alert log file, trace file etc.
• Help to design a database and database size and configure Database parameter according to requirements f the application.
• Installed and administered knowledge modules for BMC Patrol monitoring of Oracle databases and UNIX servers.
• Worked on Database 11G,12C. Worked on almost all different flavors of an OS like AIX, SUN Solaris, Linux, Win NT etc.
• Setup OMS server for 12c grid control to monitor various database and server load and do the performance, tuning.
• Setup all Database environments like DEV, QA, UAT, and Production.
• Help customer in deployment process, like data loading process, oracle partitioning, help customer to take an advantage of partitioning.
• Help customer with their query related problem and give a physical DBA support 24/7.
• Migration activities like moving from DEV to production, Clone the database for testing purpose.
• RMAN Hot Backups Using Catalog and No catalog.
• Performance Tuning Using 10G Grid control, Stats pack, Explain plan, SQL Trace, TKprof.
• Identify problem using ADDM and 11g Grid control.

Environment: Oracle12,11g, Grid Control 12c, AIX, SUN Solaris, LINUX, Windows NT/Servers

Confidential, Ann Arbor, MI

Oracle DBA

Responsibilities:

• Installation and creation of 10g, 11g, and 12c Databases for Development, Quality and Production environments and upgraded from 10g to 11g, 11g to 12c.
• Performance Monitoring and capacity planning, Security Compliance (FISMA), audit trail monitoring.
• Interpreted the data to draw conclusion for managerial action and strategy.
• Proposed solutions to improve system efficiencies and reduce total expenses
• Configured Oracle Advance Security, TDE
• Involved in reviewing business requirements and analyze data sources from Oracle server for design, develop, testing and production rollover of reporting and analyzing project.
• Compile and validate data; reinforce and maintain compliance with corporate standards.
• Wrote and fixed numerous SQL queries, varying from simple to complex, multi-page queries.
• Defined, design and configured a security policy to support FISMA compliance which get adopted by all the departments in the university.
• Configured RADIUS for two-factor Authentication in Windows and Linux environment
• Developed organizational units in Active Directory (AD) and managed user security with group policies.
• Experience in Windows Active Directory, Window server 2008/2012
• Creating & Managing Users & Groups and their Profiles.
• Created 12.1.0.2 databases for Testing, and Production on Linux and Windows.
• Used to export and import of different databases using Oracle Exp / Imp and data pump utilities
• Performed all daily Maintenance tasks like monitoring job failures, scheduling backup jobs, and troubleshooting RMAN backup job failures and interacting with Oracle Team when required.
• Install and configured Oracle 12c database
• Design and implement databasebackup and recovery procedures using RMAN
• Having experience in Migrating data to other databases andDatabase storage management
• Experienced in automating Databases activities.
• Monitoring database performance and database operation from OEM
• Support developer by tuning SQL query and PL/SQL codes
• Created table spaces and managed table spaces adding/deleting/ resizing data files
• Performedlogicalbackup & recovery using export/import utilities and Datapump
• Performed SQL and PL/SQL tuning and Application tuning using various tools like AWR, SQL*TRACE, TKPROF and AUTOTRACE.
• Developed MS SQL Server Stored Procedures, Tuned SQL Queries (using Indexes and Execution Plan)
• Developed User Defined Functions and created Views in MS SQL Server
• Documenting Database management tasks

Environment: Oracle 10g/11g/12c, RMAN, DBCA, DBUA, Export/Import (EXP/IMP), Data Pump, AWR, MS SQL SERVER 2008/20012, Windows 2012, Active Directory.

Confidential, Newark NJ

Jr. Oracle DBA

Responsibilities:

• Supporting around 100+ databases which include Non-Prod and Prod databases.
• Handling 2 Node 11g R2 RAC databases hosted on IBM AIX.
• Experience in handling Oracle 11R2 databases hosted on windows environment.
• Extensively worked on configuring and managing Physical standby databases.
• Adhering to ITIL policies such as Incident management and change management while working on day to day tasks.
• Configured OEM for database monitoring and configuring alerts.
• Worked on database cloning using RMAN
• Handling database change releases.
• Using HPSM tool for ticketing.
• Using IBM clear quest tool for release management.
• Managing the DBA team along with offshore/onsite.
• Responsible for project delivery on timely manner.
• Creation of the Development, Test and Production Oracle 9i, 10g databases.
• Setting up Oracle read only replication with materialized views and developed scripts for automating the rebuilt process of replication.
• Daily DBA activities like Tuning of SQL/PLSQL, Performance Tuning, Database auditing and managing user groups, Database security, OS space monitoring etc.
• Tuning for I/O Contention, Memory contention, Row Migration, Block Contentions, etc. DB Cache, SGA Tuning, Optimizing using CBO, analyzing tkprof & statspack reports.
• Planning Backup & Recovery procedures, Performing Backup and Recovery activities (both in archive & no archive mode) using Export/Import utilities.
• Configuration/Troubleshooting of tnsnames, listeners setup.
• Configuration of standby Database.
• Monitoring storage parameters for tables and indexes, monitoring databases for fragmentation at table space, table, row and de-fragmentation for optimal utilization of physical storage.
• Wrote UNIX shell scripts for automation of different administrative activities and notifications, which will continuous monitor the database and send warning, error massages to DBAs via email.
• Worked on setting up off Oracle dataguard for the production database.
• Worked with backup team and was responsible for configuration and implementation of backup strategies using RMAN.
• Managing Application user profiles and managing concurrent managers, concurrent processing, load balancing etc.
• Export and Import of database objects to copy from one database to another database and convention oracle export, import for oracle 10g database.
• Keeping database up-to-date by applying patches and worked with oracle support on different database issues.
• Documentation of Data Base Setup, replication setup, important scripts and administration of Server Environment.
• Standby Database Creation & manage by using Dataguard.
• Replication of database by using Oracle GoldenGate.
• Oracle10g Migration to 11R2g.
• Cloning/Patching of Database

Confidential

Jr. Administrator

Responsibilities:

• Database Creation on Linux, IBM AIX, and MS Windows 2003 (Manually using create database script and DBCA).
• Software support for EPM (Enterprise Project Management),
• Taking Logical backup of a Database using EXP Utility.
• Refreshing test Database using IMP utility.
• Responsible for taking weekly Production database Cold Backup.
• Refreshing database schemas using Export and Import utilities.
• Archive log shipping on DR site from production database and recovering standby database.
• Quarterly restoration of cold backup on a separate server for backup sanity testing.
• Monitoring Database Performance & tablespace freespace of Prod and NonProd Databases. Also sizing it according to the needs and future growth.
• Creating new users assigning grants & loading the Dump using Import utility.
• Maintenance of Tables (Purging Activity).