SUMMARY:

• Certified Lead Oracle DBA / Architect, with over Eleven plus years of experience in Oracle 10g, 11g, ASM, ACFS, RAC, DATAGUARD, DR, GRID CONTROL.
• Specialized in Shared Service e.g. Oracle RAC, SQL Server clustering, Disaster Recovery Plan, disparate industry verticals, database design, installation, migration, performance and tuning, standards and governance, SOA architecture.
• Experience with RMAN, Oracle Enterprise Manager (OEM), OEM Grid control, Oracle Automatic Storage Management (ASM), Data warehousing, Oracle Data Guard, Oracle Data pump, Active Data Guard.
• Experienced in Planning, Installation, Physical and Logical Database Design, Backup and Recovery, Cloning, Refreshing test and development databases, Monitoring, Troubleshooting & Tuning
• Extensive DBA experience in supporting multiple instances of ORACLE database including Development, Reporting, Data Warehousing, User acceptance testing & Production.
• Experience in database migration by designing and implementing database logical and physical storage structures. Install, configure & secure GRID agent on database servers
• Provided senior operations DBA/architect with Expertise in working with more than 500 plus Databases with more than 50,000 User overall.
• Planned logical storage structure, Database Model, Tablespace, Tables, Indexes, views, Users, Roles, Profiles, Security and Auditing.
• Solid Experience in Oracle DBA activities including installation, migration, upgradation, configuration, backup, recovery, PL/SQL, SQL scripts programming.
• Experience in optimizing database access and allocates/re - allocates database resources for optimum configuration, database performance and cost.
• Extensive experience in daily batch and report monitoring, space management, index rebuild, statistics collection and other Oracle housekeeping tasks.
• Expertise includes development, enhancement, implementation, advanced DBA activities, programming and people skills.
• Solid experience of implementing large database (Size in TBs) production servers on various platforms.
• Administration, maintenance & tuning of large Oracle databases. Design & implementation of backup strategies.
• Expertise in migrating Oracle 11g database from Virtual Machine to Amazon Web Service (AWS RDS).
• Experience in database security strategies by creating database users, user roles, profiles and audits.
• Experience in CLONING / REPLICATING production database using RMAN & OEM Grid Control.
• Worked with developers to understand the logical model and to create the physical model.
• Worked on Amazon and Verizon Web services (cloud databases).
• Implementation of HIGH-AVAILABILITY solutions.
• Experience with Oracle 10g and 11g on UNIX & Windows operating systems.
• Expertise in Installation / Configuration of RAC Databases on Active / Passive node on SUN Solaris
• Expertise in Installation / Configuration of RAC Databases on Active / Active node on Linux
• Performed Failover & switchover testing of database using SRDF & Data guard methods
• Experience in backup/restore, disaster recovery using RMAN & OEM Grid Control.
• Expertise in ORACLE Data Guard & Real Application Clusters (RAC).
• Hands on Experience in Job scheduling through crontab, O/S updates and upgrades, patches loading.
• Experience in analyzing database & rebuilding indexes to improve database performance.
• Implemented & monitored daily, weekly and monthly batch jobs in database
• Experience working with Oracle Active Data Guard & Data Guard Broker.
• Expertise in handling and coordinating multiple Team (Onsite - Offsite - Offshore)
• Upgrading and Migrating Databases from lower versions to higher versions.
• Experience in using data pump import/export utility of ORACLE.
• Expertise in Applied PSU to standalone and RAC databases
• Troubleshooting RAC issues & providing solution
• Strong analytical and problem solving skills

TECHNICAL SKILLS:

RDBMS: Oracle 11g / 10g, SQL Server

DB Tools: Toad, Export, Import, Data pump, RMAN, Log Miner, Change Manager, Streams, AWR, ADDM, STATSTPACK, SQL developer.

Operating System: Windows server, Sun Solaris, RH Linux 5, HP-UX, AIX 5.5/6

Oracle Tools: Oracle Enterprise Manager & Grid Control, SQL

Other Tools: AUTOSYS, ECMS, Alarmpoint, Peregrine Service Centre, VMware Server, ResolveIT, Virtual Control, RFC

Languages: SQL, UNIX Shell Programming

PROFESSIONAL EXPERIENCE:

SME / Implementation Engineer

Confidential, Roseland, NJ

Responsibilities:

• Implemented in production for High availability/performance Oracle RAC database system with Data guard configuration using SSD drive Technology
• Designed and executed a plan to upgrade DB's to Oracle 11g including Standby and Data Warehouse environment
• Design process for business enhancement and create implementation plan.
• Design and implement replication process to provide High availability.
• Implemented multi-node architecture to support business application performance and functionality.
• Provided day-to-day DBA support to business (front office, mid office, back office applications), risk management.
• Design and implement various monitoring tool to keep the business running on its high efficiency.
• Created procedure and packages to make the application to work without any issue during upgradations.
• Involved in the Multi Node/Single Node Cloning of Production to multiple instances.
• Designed and implemented the software and hardware testing strategy before delivery the system towards production.
• Contribute on Horizontal and vertical scaling on Oracle database systems.
• Performed DBA activities and conducted query optimization.
• Designed and implemented high availability architecture.
• On call 24X7 Production Support.
• Hands on Involvement in Installation and configuration of Oracle Multi node RAC architecture.
• Performed Database Refresh from Production to QA and Development databases.
• Installed & Maintained Oracle 12c cloud control.
• Implemented security and bug fix patches every certain interval of time.
• Design and implemented critical transitional applications.
• Design and testing various available Database technologies to save cost of maintenance and support

Environment: Oracle 11.1.0.7 & 11.2.0.4, RMAN, Data Guard, Broker, Shell Scripting, RAC, ASM, SQL, TOAD, DBA Toolkit, Sharepoint, OEM

Lead Oracle DBA

Confidential, Milwaukee, WI

Responsibilities:

• Enforced DBA best practices to installation, server setup, backup and recovery, application tuning and performance tuning.
• Maintained inventory of all cloud databases.
• Co-ordinate with AWS / Verizon for any issues for databases.
• Create the Dev, Prod and Test Oracle Database 11gR2 by Amazon Web Service (AWS RDS).
• Create user, Tablespace on the Dev, Prod and Test Oracle Database 11gR2 (AWS RDS).
• Install and maintain all DBMS and related software.
• Perform migrations to Amazon Web Services and Verizon web services.
• Did Migration of 150 application databases to cloud services.
• Troubleshoot application issues while connecting to cloud databases.
• Involved in Day-to-day DBA Best Practices to ensure business standards.

Environment: Oracle 11.2.0.4, RMAN, Data Guard, Broker, Shell Scripting, RAC, ASM, SQL, OEM, AWS and Verizon web services.

Senior Oracle DBA

Confidential, Irving TX

Responsibilities:

• Install and maintain all DBMS and related software.
• Established and maintain all DBMS operating environments (UAT, Production and COB) on hosts/servers in TI Data Centers.
• Worked DBA teams enable EM monitoring for clustered/single node instance
• Establish and document DBMS operating standards and procedures.
• Establish and maintain physical backup and recovery processes for all DBMS environments.
• Recover DBMS subsystem and support database recovery at the contingency site.
• Research and resolve DBMS system problems and assist in the resolution of application problems.
• Establish DBMS system security standards and support Security Administration in maintaining access controls.
• Monitor performance and tune all DBMS subsystems. Support application performance review and tuning efforts.
• Provide 24 / 7 Database Hotline support for production systems.
• Check and ensure appropriate OS patch levels are applied on the hosts
• Analyzed system software requirements and provide the SA team with file system size information.
• Upgrade DBMS software and apply patches, as per the corporate standards
• Maintain and standardize documents for setting up new and existing servers
• Applied configuration changes from UAT to PROD/COB servers
• Fine tune configurations based on system load, response needs and inputs from app DBAs
• Process STRs/SIRs related to infrastructures changes and problems.
• Provide weekend support, whenever pre-scheduled off business hour work, is being performed
• Provide database recovery support for various database disasters
• Maintained active COB (Continuity of Business) server on a different host
• Managed database space
• Resolve errors and system warnings/messages
• Monitored production server resources performance
• Worked with vendors as necessary on problems
• Responsible for configuring and scheduling physical database backups using certified scheduling agent with proper escalation details
• Involved in Day-to-day DBA Best Practices to ensure business standards.

Environment: Oracle 10.2.0.4 / 11.1.0.7 & 11.2.0.3, RMAN, Data Guard, Broker, Shell Scripting, RAC, IBM AIX 6, ASM, SQL, Virtual Change Mgmt., ResolveIT, Alarmpoint, DB Portal, Sharepoint, OEM, Citi Marketplace, CDBI

SME / Database Management Analyst - Regional

Confidential

Responsibilities:

• SME for EMEA Region & part of US Project
• Worked in on call model to support all DBA activities of PROD, TEST, QA and DEV severs for OLTP and OLAP.
• Managed the application processes and co-ordinate different teams to make the migration/implementation successful.
• Supported the SDRF storage migrations and also worked with SA for the storage upgrade of the VCS.
• Worked closely with the application team and developers to create the database and schema structure
• Monitored the RAC performance and supported in case of crash.
• Resolved ORA-0600, deadlock issues and other ORA errors.
• Created user role, profiles as required.
• Worked on the SQL and pl-SQL performance issue. Did the SQL tuning for the better performance.
• Worked with developers to check the SQL performance through the AWR reports, explain plan and stress/load test.
• Hands on Installation / Configuration of RAC Databases on Active / Passive node on SUN Solaris
• Hands on Installation / Configuration of RAC Databases on Active / Active node on Linux
• Installation of OEM Agents on the database server and configuration of OEM for that database.
• Hands on Configuration of Dataguard Broker on Prod / DR
• Failover & switchover testing of database using SRDF & Dataguard methods
• Involved in Planning & Implementation of Backup strategies
• Configuration of database backup’s on tapes and restoring on disk
• Configure ACFS file system for backups / exports
• Performed schema refresh using expdp / impdp and supported the application go live activity.
• Refreshed full database from RAC to single node and RAC to RAC database using hot backup.
• Managed Import/Export depending up on requirements using export / datapump utilities
• Scheduled RMAN backup and troubleshooting any backup issues. Also, configured RMAN backup using NETBACKUP.
• Monitored the standby server and resolved the synchronization issues.
• Performance tuning using the AWR, ADDM reports. Enabled the trace to monitor the session activity and gather the performance statistics. Analyses the trace files by tkprof.
• Worked with the developers in their application testing and the SQL query performance testing. Provided explain plan and analyzed the query plan.
• Supported the application team and co-ordinate the new releases of the application by supporting their stress and load tastings. Worked with the application to make the application live.
• Managed the database security by assigning the appropriate privileges and roles.
• Configured the standby server using Active Dataguard.
• Monitored the databases using the Grid Control, OEM.
• Involved in Upgrading from 11.2.0.1 to 11.2.0.2 on standalone and RAC
• Migration from 10g to 11gR2 database
• Monitored and tuning Database Server
• Maintenance related activities on production database
• Applied of Patches on Production & DR database
• Applied security baselines to Grid Infrastructure and database software binaries
• Involved in Performance tuning the production database with respect to the application
• Troubleshoot RAC issues & providing solution
• Co-ordinate with SA in case of space issues and new server build for RAC.
• Communicated with the Oracle Support and the Quest Support to resolve the critical issues.
• Responded to the users to understand and resolve the issues.
• Involved in Day-to-day DBA Best Practices to ensure business standards.

Environment: Oracle 10.2.0.5 / 11.2.0.1 & 11.2.0.2, RMAN, Data Guard, Broker, Shell Scripting, Toad, RAC, Windows2005/2008, LINUX, Sun Solaris, ASM, SQL, PL/SQL, ECMS, AUTOSYS, EIDRS, Enterprise Password Vault, Peregrine Service Center, Alarmpoint, DB Portal, SharePoint.

Senior Oracle DBA / SQL Server DBA

Confidential

Responsibilities:

• Installation / Configuration of Databases on RAC node on UNIX platform
• Installation / Configuration of Databases on Active / Passive node on Windows / UNIX
• Involved in Configuring Data Guard (physical / logical) for production site
• Failover & switchover testing of database
• Database Backup on Tapes and restoring on Disk
• Involved in Managing Import/Export Depending up on Requirements
• Monitored and fine tune Database Server
• Maintenance related activities on production database.
• Installed Patches on Production and Logical Standby Database Server
• Involved in Performance tuning the production database with respect to the application using our own load generation tool
• Perform Planning & Implementation of Logical and Physical Backup strategies
• Involved in Troubleshooting issues from database logs and providing solution
• Involved in Day-to-day DBA Best Practices to ensure business standards.
• Installation of MS-SQL on cluster nodes / Standalone nodes
• Created / configured database for MIS & DR purpose
• Configured Log shipping from production to standby databases
• Maintenance related activities on production database
• Failover & switchover testing of database
• Troubleshoot issues from database logs and providing solution.

Environment: Oracle 10.2.0.5, Microsoft SQL Server 2005, IBM AIX 5.3, HP-UX 11 & Windows 2003 (Operating System), IBM Tivoli Software Manager 5.3 (TSM) & HP Data Protector (back up software), IBM DS4700/DS4800 & HP EVA (Storage)

Senior Oracle DBA

Confidential

Responsibilities:

• Audit Database use, using guidelines for Auditing, Creating and deleting audit trail views, Managing /Viewing Audit trail information
• Backup & Recovery - Database Backup through RMAN to Tapes and restore from Tapes to disk, Import and Export
• Involved in Operating System security, Data security policy, User security policy and Password Management policy with the help of Bank
• Prepared procedural / operational manual and technical documentation required by the Bank
• Understood client’s database related needs in terms of number of database users, maximum number of active
• Installation & Configuration of Databases
• Managed Devices & Databases, User Accounts, Access rights and resources
• Involved in Database Backup on Tapes and restoring on Disk
• Import, Export and distribute Data
• Monitored and tune Database Server
• Managed the size and file of the Database schema objects
• Managed processes and Control Files
• Installed Patches on Production and Logical Standby Database Server
• Implemented of security policy for AIX OS
• Creation and Configuration of Databases
• Administration Database security privileges authentication
• Users at any given point of time, number and size of databases, data archival
• Installation of Patches on Production and Logical Standby Database
• Installation & administration of AIX 5.2 on RS6000
• Managed RAW Volume Groups
• Managed File systems
• Monitored log files such as errpt, smit.log, hacmp.out & cluster log files
• Involved in Back up of AIX system using smitty tool
• Implementation of security policy, user policy, and password policy for AIX OS
• Tune AIX kernel & network parameters for Oracle database platform
• Involved in Day-to-day DBA Best Practices to ensure business standards.

Environment: Oracle 10g Database with RAC (10.1.0.4), IBM AIX 5.2 & Windows 2000 as Application Servers O.S), IBM Tivoli Software Manager 5.3 (TSM)(Backup software), FASTt600 & FASTt700(Storage)