SUMMARY

• Excellent 9+ years of experience as an Oracle 12c,11g, 10g, 9i DBA in 24x7 Production high availability, Test and Development Instance environment
• Hands on Standby databases, Data Guard, RMAN, Performance Tuning, Upgrade, Database Security, Database Audit, RAC, ASM, Golden Gate
• Excellent 9 +years experience as an Oracle Database Administrator (DBA) on Operating System viz. Sun Solaris, Linux, AIX and Windows 2000\2003 server in 24x7 Production, QA and Development environments
• Oracle database 12c, 11g, 10g, 9i administration on Unix, Linux, AIX Installing, upgrading, migration and maintaining. Experience in using enterprise level tools including Oracle Enterprise Manger (OEM), Oracle Enterprise Cloud Control 12c, SAP BRTOOLS, Oracle 11g Database Administration for SAP Application.
• Experienced in implementing ITIL Processes like Quality, Risk, Ticket, Process and change management
• ITIL Ticketing tools knowledge (HPSM), ITSM
• Lead for Database external Audit (third party Audit) and software license upgrade project
• Lead for DVM Project (Data volume management) of Oracle Database on SAP application
• Lead for Mission Critical projects (MCA Projects) and done set up of Databases, Standby DB, Backup configuration, BCP set up
• Oracle memory and SQL tuning, Monitoring and experience working together with a team to delivers high availability service
• Supported STANDBY databases, setup, troubleshooting, maintenance, switchover, switchback and Failover
• Upgraded Oracle databases from 10g to 11g, 11g to 12c,
• Worked on Migration project. Experienced with large scale data migration. Specifically, responsible for validating a large data migration / conversion of legacy data to Oracle system
• Wrote/ Modified various SHELL SCRIPTS for automation, data base alerts, OS alerts, backup’s & database monitoring, space management, archive space management, set up batches, crontab jobs
• Experience in doing RMAN Backup strategy configuration and set up, backups and recovery using RMAN, Cold/Hot Backups, export/import/Data pump
• Performance Tuning of SQL statements, Instance tuning, Database Tuning using tools like Explain plan, TKPROF, SQL Analyze, SQL Plan Management, ADDM, AWR reports etc
• Plan for contingency, BCP Management, disaster management that includes Standby databases, Data guard and cloning/refresh of the databases
• Participated in Configuration, support and installation of 11g RAC environment on Linux environment using ASM
• Oracle Enterprise Pack experience - Golden Gate, Database Vault, Audit Vault, Security/Encryption, Data masking, Transparent Data Encryption, Transport Layer Security(TLS)AES
• Database Security, managing user, privileges, role
• Analyzing, developing and maintaining data architectures using ER Tools, ERwin, ER Studio process models, application - database interfaces and experience consulting to an Oracle data base design and implementation team
• Skilled in logical and physical database design
• Successfully installed and extensively worked on Oracle installation of 12c, 11g, 10g and applying Critical Patch Update and security patches in various environments (Prod / Staging / Testing)
• Administration of Database Structure, Storage Allocation, and Table/Index segments, Rollback Segments, Undo Segments, LOB objects
• Adding, Managing Oracle partitions, Materialized view
• Experience in Capacity Planning, Space Management, Database Upgrades / Migration Data Extraction
• Database Real Application Testing
• Exposure to maintained Oracle Streams like start and stop, and troubleshooting Stream process management
• Exposure to SQL server administration worked with Oracle Support team for SR resolution and to resolve critical incidents
• Project planning experience worked on SDLC life cycle, including effort estimation on technical tasks and resource allocation
• Good communication, Presentation skill, interacting with different stake holders and management teams, ready to take ownership, dedicated and passionate towards my Duty, good Risk handling capacity, Decision making skills, Team Lead and encourage them to complete work on time with best quality, problem solving skills and would be a welcome addition to your IT team, good person, team member and Leader

TECHNICAL SKILLS

Operating System: Sun Solaris 10, Red hat Linux (2.1AS, 3.0ES), AIX, Windows 2000\2003

RDBM: Oracle 12c/11g / 10g, Oracle (9.2.x, 8.1.x), SQL Server

Languages: SQL, PL/SQL, UNIX shell scriptDatabase Tool Oracle 10g, 11g, 12c (OEM), PL/ SQL Developer, SQL Developer, Quest ToadSAP BRTOOLS, Golden Gate

Interfacing Tools: SSH, Putty, Super Putty, WinSCP, Toad for DBAUtilities DATAPUMP, Imp/Exp, SQL*Loader, DBCA, DBUA, SQL Trace, DBVerifyTivoli, RMAN, SCP, SQL worksheet, TKProf, AWR, ADDM, OEM, SAP BRTOOL

PROFESSIONAL EXPERIENCE

Confidential, New Jersey

Oracle DBA

Responsibilities:

• Experience in or participation in Capacity Planning, Re-Engineering, Performance Fine Tuning and Cost Optimization
• Assist application development teams in planning, design, implementation, and documentation of Oracle environments.
• Experience with Oracle Multitenant database
• Oracle database 12c R2 installation
• Installation, configuration and tuning of Oracle databases used by various business critical systems, including Oracle Financial Applications
• Day-to-day database server administration, monitor database health, nightly database back-up and refresh, database/object recovery, cron job execution and other database administration tasks.
• Experience on Oracle Enterprise Manager cloud control 12 c
• Experience on Oracle Enterprise management console
• Oracle RAC Administration, troubleshooting, maintenance, set up using ASM.
• Golden Gate Administration, troubleshooting, maintenance
• Successfully completed ownership of DVM (Data Volume Management) project and released around GB space from each 1TB-5TB Database..
• Worked on LOB object of SAP like SOFTCONT tables etc and improved performance and space released from Big table
• Performed Bulk index Rebuild activity on around 1 laces Index using BRTOOLS for DVM
• RMAN backup configuration and automated scripts of backup corrected as per SAP standards on Oracle DB
• Recovery of Database in some scenario like control file corrupted, archive missing, dbf file missing, segment corrupted
• Worked on Decommission of Databases
• Database performance improved by tuning SQL statements, Memory tuning, database tuning, OS tuning, parameter file corrected, capacity planning, using SQL plan management, AWR, ADDM, SQL tuning advisor .Optimized database performance by analyzing database objects, gathered statistics, created indexes
• Removed block corruptions of objects mostly index after DB Refresh
• Troubleshoot most of the errors, oracle bugs occurred during DB Refresh activity
• Provided time to time solution whenever Archives getting 100% full and shell script corrected to resolve these kind of issue using automated scripts
• Environment setting like disk size, mount points, archive points, data-files configuration and table-space configuration corrected and modified
• 24/7 support provided for severity 1 activity by providing details like ADDM, AWR report, monitor CPU utilization and continuously worked with Oracle high availability team for its resolution
• Handled critical situation which was Time bound and on time delivery
• Database Upgrade 10g to 11g and 11g to 12c, oracle installation as per standards and provided time to time solution to their issues
• Worked on DR set up creation using Data Guard and troubleshooting done on many issues faced by team during DR setup activity
• SAP Solution Manager Database Configuration and backup configuration
• Worked with SAP Support and Oracle Support for License, patches update
• Modified automated Batches, archival scripts, backup jobs, email functionality, alert scripts
• Oracle Partitioning and Advanced Compression
• Experience in database reorganization

Environment: Oracle 12c, 11.1.x/10.2.x/9.2.x, Data guard, RAC, Golden Gate, Linux, Unix, SAP Basis, RMAN, Winscp, Putty, SSH, TKPROF, AWR, ADDM, STATSPACK, DATAPUMP, EXPORT/ IMPORT,BRTOOL, Shell Scripts, Toad, PL/SQL developer, ASM

Confidential, Chicago

Senior Oracle DBA

Responsibilities:

• Participated in Impact analysis and DB design and generated ER diagram for application to maintain LDM/ PDM(Logical/Physical data model)
• Involved in building critical application as MCA(Mission Critical Application) project. As per provided MCA specification database policy, structure, standards and its backup policy created
• DR set up created and capacity planning for database servers, Standby Database set up using Data Guard
• Exposure to Golden Gate troubleshooting
• RAC using ASM troubleshooting, set up
• Used import/export, data pump, schema cloning, Database cloning
• DB space management its storage its mount point and file system policy designed
• Batches and MV refresh scripts prepared and scheduled successfully for production
• Impact analysis and troubleshooting for change requests
• Overall database monitoring and basic Shell scripting
• Upgraded databases from 10g to 11g, 11g to 12c
• Database cloning, schema creation
• Created User, Role and maintain its security by providing Privileges, Grants on objects
• Handled DB slowness issues
• Performed Data-Masking activity for Production DB
• To maintain DB objects scripts for production.
• Oracle networking like maintain DB link, TNS file, Listener connectivity and to ensure DB availability
• Environment setting like disk size, mount points, archive points, data-files configuration and table- space configuration for Production setup to get 100% restoration of database in case of any database or data corruption/loss
• Planning and applied Patching on Oracle database
• Oracle Performance Tuning which includes proactive capacity planning, OS tuning, Memory tuning, SQL tuning with AWR & ADDM
• Database refresh using manual and automated RMAN DUPLICATE, Export/ Import Datapump method
• Monitoring and controlling Oracle databases using OEM and other tools
• To ensure execution of Backup daily basis for Production databases and do backup and recovery using RMAN
• To identify databases for decommission and worked with different teams to do decommission
• To carry out deployments on databases requested by application and other teams
• Lead Database Audit by providing Audit information to External Auditor(Third Party) and implemented their suggestions and handled multiple database Audit and minimized NCR 15 to Zero in a two quarter
• Lead for License upgrade for oracle software
• Lead for BCP Project Team of around 40 members and multiple BCP Drill done successfully
• Worked together with multiple team like BA or Users, DAG(Quality and process management), Auditor, BCP team, DB Backup and restoration team, WFS team, Tech team and OS team, Networking team, Risk management team
• Handled project start-up to end up SDLC life cycle and implemented ITIL Process
• To get prepared all project database documents as per standards and get it reviewed and approved from GL/PL, DAG for Audit and IBM PMR(Project management review).
• To create and Maintained UPP, UMP, IBM PMR, concept notes, project plan, daily status, weekly status, monthly status report for project, estimation costing and timesheet of resources.
• Handled and fulfilled requirement for major application CR roll-out in production and its database documents updated as per Audit policy
• To manage CR and Ticket escalation level
• Performed Incident service improvement
• Exposure to six sigma process implementation for the project
• To be in compliance with strong ITIL processes like Ticket & Change Management, Problem and Known Error management, Knowledge management, Risk, Process, Quality management
• To implement Process improvement to save on cost and estimation, improve on productivity and customer satisfaction

Environment: Oracle 12c, 11g, 10g, 9i, RAC, Data guard, Linux,AIX, Solaris 10, OEM, ASM, RMAN, Winscp, SQL Developer,Putty, SSH, TKPROF, Toad, AWR, ADDM, STATSPACK, DATAPUMP, EXPORT/ IMPORT, Materialized Views, Shell Scripts, PL/SQL developer, SQL developer

Confidential, Minneapolis

Oracle DBA

Responsibilities:

• Basic Oracle database administration
• Worked with Application, development Team to handle database issues and provide solutions
• Developed strategies for archival policy, RMAN backup, recovery and implemented it on databases.
• Impact analysis and capacity planning for any change or enhancement
• Involved in Oracle server building planning and providing detailed specification to OS, storage team
• Conduct meetings with all stake holders for data volume management and decommission of DB
• Multiple schema design for Development team for SDLC(systems development life cycle)
• Involved in Database planning and its maintenance
• Optimized database performance by analyzing database objects, gathered statistics, created indexes
• Planned and execute the backup strategy for physical standby Oracle databases
• Build Standby databases, Data Guards and its configuration and cronjobs
• Maintained Oracle security through users, roles and Oracle profile
• Improved performance of batch jobs, many reports. Performance fixes typically reduced batch runtime by hours. Recommended and implemented materialized views, indexing improvements, as well as improved SQL techniques. Tracked down the source of troublesome locking problems
• Created many SR to Oracle Metalink to find best troubleshooting method for high priority issues
• Identified and tuned SQLs in production databases
• Worked with Oracle Meta Link team to Tuned and correct Pfile parameter to improve performance of databases and implemented those parameter on multiple databases
• Daily report monitor and identify and resolved failed backup issues of databases for production and non production
• Resolved issues of DB refresh activity
• Modified shell scripts for archival policy, backup policy and alert scripts
• User management, space management and monitoring on DB level
• Providing required privileges to user as per defined security policy
• Database storage its mount point and file system policy designed
• Participated Database Audit and providing required information to management
• Oracle Performance Tuning which includes proactive capacity planning, OS tuning, Memory tuning, SQL tuning with AWR & ADDM, explained plan
• Lead for BCP planning and its execution
• User Activity Monitoring
• License upgrading and installation
• Process monitoring on server
• Lock/ Unlock users, DB shrinking, DSN creation
• Backup process monitoring and essential DB maintenance activity
• Creating scripts to fetch data as per the requirement
• DB Space management
• User management

Environment: Oracle 10G, 11g,RAC, Data guard, Linux, AIX,Solaris 10, OEM, ASM, RMAN, WinSCP, SQL Developer,Putty, SSH, TKPROF, AWR, ADDM, DATAPUMP, EXPORT/ IMPORT, Shell Scripts, PL/SQL developer

Confidential, New Jersey

Responsibilities:

• Installed, Configured, Managed, and Patched Oracle 10g, 11g on Linux, Unix
• Upgraded databases from 9i to 10g and 10g to 11g
• Applied Critical Patch Update and security patches in various environments (Prod / Staging / Testing)
• Oracle Database 9i,10g,11i basic administration on Linux and HP Unix
• Backup configuration and management with Oracle RMAN and Tivoli
• Participated in Configuration and installation of R12 RAC environment in a Linux environment using ASM
• Cloned many RAC DB to RAC DB
• Participated in Configuration and installation of R12 RAC environment in a Linux environment using ASM
• Experienced in maintenance and management of databases using Oracle Enterprise Manager Grid Control
• Maintaining Oracle database systems and experience using enterprise level tools including Oracle Enterprise Manger (OEM)
• Physical STANDBY database, setup, troubleshooting, maintenance, switchover, switchback and Failover
• SETUP LOGICAL BACKUPS of database using EXPORT/IMPORT and 10g DATAPUMP
• Did troubleshooting for backup recovery activity
• Exposure to Oracle Streams: patching, start and stop, Stream process management, Checking Streams locking issue, Stream-admin password change
• Performed SQL tuning to improve the database performance.
• Troubleshooted database problems faced by developers and QA team with tools and utilities like AWR report ADDM, Sql trace
• Monitoring and tuning databases and experience working together with a team to delivers high availability service.
• Schema refresh from production to various other environments
• Did Database cloning from production to various environments
• Did production and non production SQL deployment within defined timeframe and SLA’s.
• Analyzing, developing and maintaining data architectures, process models, application - database interfaces and experience consulting to an Oracle data base design and implementation team.
• Worked with Application Team for database loading, development and management of operational procedures
• Basic Linux Administration for DBA
• Did OS Monitoring of CPU Utilization & performance with tools like (TOP, VMSTAT, SAR, IOSTAT etc)
• Space management, Instance health check
• User creation and Security maintenance
• Database link creation and maintain distributed database
• Maintained Oracle Networking
• Database Health check and Troubleshooting
• Created many SR and worked with Oracle Meta link team for SR resolution.
• Quality Documentation for all database administration and deployment activities
• Maintains requests and task with Request Tracker management
• Project coordination like KT management for Offshore, Attending client meetings, documentation of processes and getting approval from Client.
• Coordinate with onsite DBA team to assign role responsibility and explain Project requirement and process to new team member
• Communicate with Project Managers, Systems Architects, Systems Analyst, Application Developers to gather requirements for testing and develop estimates for testing execution

Environment: Oracle 10g,11g RAC Oracle 11.1.x/10.2.x/9.2.x, Linux, Solaris 10, Windows 2000\2003, OEM, Grid, RMAN, Tivoli, WinSCP, Toad for DBA, Putty, SSH, AWR, ADDM, STATSPACK, DATAPUMP, EXPORT/ IMPORT, Shell Scripts

Confidential

Oracle DBA and Technical Consultant

Responsibilities:

• Created Databases, Users, Roles
• Essential Linux/ UNIX administration for DBA
• Maintained Oracle Networking
• Maintained physical & logical database structure
• Managed Database availability and security
• Validated Invalid Objects in the databases
• Utilities - Export, Import, Data Pump
• Solved Queries of Developers and troubleshooting
• Installed Oracle 9i, 10g database server and client on UNIX, Linux and Windows
• Database and Schema Refresh activity
• RMAN recovery backup.
• Applied Critical Patch Update and security patches in various environments (Prod / Staging / Testing)
• Disk space Management, Archive log space management.
• OS Monitoring of CPU Utilization & performance with tools like (TOP, VMSTAT, SAR, IOSTAT etc)
• Database Health check and Troubleshooting.
• Did Database cloning from production to various environments
• Troubleshoot database problems faced by developers and QA team with tools and utilities like AWR report and STATSPACK
• Worked with Application Team for database loading, development and management of operational procedures
• PL/SQL code checking and modifying it for Performance Tuning.
• Quality Documentation for all database administration and deployment activities
• Maintains requests and task with Request Tracker management
• User Activity Monitoring
• License upgrading and installation
• Process monitoring on server
• Lock/ Unlock users, DB shrinking, DSN creation
• Backup process monitoring and essential DB maintenance activity
• Creating scripts to fetch data as per the requirement
• DB Space management
• User management
• Worked with Google Technical Team to improve site performance and implemented Confidential Search Engine
• Handled stock market day end closing, stock matching, final stock values and its trading details
• Handled Mission Critical Application(MCA) which interface between Stock Exchange, NSE, BSE and ICICIDIRECT.COM
• Successfully completed Ownership for daily stock market opening and closing activity and did troubleshooting for server connectivity between NSE, BSE and ICICIDirect.com
• Handled Bulk email sending application to ICICIdirect customers
• Solved client tickets received from Confidential customer care for Oracle database
• To help actively on database side to implement application enhancements and changes
• Created quality documents on standard operating procedure used for DB support
• To manage and resolve database requests through ticket mechanism
• Worked in an investment banking environment, interacting with the traders, etc.

Environment: Oracle9i, Oracle10g, Sun Solaris. Red Hat Linux, Windows, Data Pump Toad, Putty, SQL Server, OEM, SQL*LOADER, RMAN, WinSCP, Toad for DBA, Putty, SSH, AWR, ADDM, STATSPACK, EXPORT/ IMPORT, Shell Scripts, PL/SQL, T-SQL

Confidential

Junior. Oracle DBA

Responsibilities:

• Database Administration, creation and Maintenance.
• Installed Oracle 9i, 10g database server and client on UNIX, Linux and Windows
• Troubleshooting for recovery backup using RMAN and cold backup method
• Physical database design and developing software at the data layer in anORACLEenvironment
• Design, maintenance, and administration of relational databases
• Did production and non production SQL deployment within defined timeframe and SLA’s
• Oracle memory and SQL tuning
• PL/SQL code checking and modifying it for Performance Tuning.
• Worked with Application Team for database loading, development and management of operational procedures
• Database and Schema refresh
• Executing DB scripts keeping data integrity
• Creating Databases, Users, Roles
• Managing Database availability and security
• Tablespaces management and creation.
• Export, Import utility
• SQL scripts review.
• Hot and cold backup, recovery.
• Statspack and AWR report creation for Performance Tuning.
• Database Space management.
• Database Health check