PROFESSIONAL SUMMARY:

• Extensive knowledge on database administration for Oracle 9i, 10g, 11g and 12c, DB2 UDB 9.7/10.5, SQL Server 2008/2012databases with experience in very large - scale database environments and handling Production, Staging, QA and development environments.
• Hands on experience with Installation, Configuration, Patching, upgrading, and migration of databases.
• PerformDB patching, Cloning, DB Installation, troubleshoot issues/errors/incidents, Collaborate with Oracle support for bugs & issues resolutions and do personal research.
• Hands on experience in Oracle 10g/11g/12c RAC implementation & administration (Oracle Cluster-ware setup and configuration, RAC Installation using ASM, Grid Installation.), Patching, RMAN Backup.
• Experience in a variety of hardware and software platforms including; OEL, UNIX/Linux, Sun Solaris, HP-UX & AIX and RHEL.
• Handy in Migrating Single Instance databases to RAC Environment.
• Extensive experience in DataGuard Configuration, Implementing and Maintaining Standby Databases i.e. ACTIVE DATAGUARD & SNAPSHOT STANDBY
• Implemented strategy for partitioning and management of data tables in RAC.
• Worked with Golden gate 11g replication solutions to facilitate data flow between databases.
• Experience with Oracle features: Flashback Recovery, Data pump, ASM, ASH, AWR, ADDM, ASSM, ASMM, Automatic Undo management, Grid Monitoring and Recycle Bin.
• Hands on experience inOEM Grid Control (11g) and Installed OEM 12c Cloud Control for database Monitoring/Performance/Diagnostics.
• Experience in LOGICAL BACKUPS and Database migration tools with DATA PUMP, Export/Import and Transportable Table-spaces.
• Experience in Performance Tuning, tuned various large critical OLAP and OLTP databases of Terabytes size using various tools and utilities like STATSPACK,SQL-Trace,Tkprof, SQL Monitoring report, SQL Tuning Advisor,Analyzeand Explain Plan Methods.
• Tuned the Database with Initialization Parameters. Viewing the Initialization Parameters with Enterprise Manager. Increasing Performance by Tuning the DB CACHE SIZE parameter.
• Extensive knowledge in Database Backup and Recovery concepts using RMAN utilities (scheduling full/incremental/cumulative backups, hot/cold backups writing/editing UNIX Shell Scripts for RMAN).
• Experience in database cloning with RMAN, Capacity Planning, Database Refresh and Patch management.
• Experienced in maintaining databases on large Production, Testing and DEV environments.
• Supported Oracle E-Business Suite(EBS),Oracle Retail Management System(RMS)and Oracle Business Process Management(BPM)Application suite.
• Wrote shell scripts to automate the process of monitor file-system usage, switching Archive log destination, database monitoring etc.
• Experience as On-Call 24x7 production DBA support, application/development DBA.
• Handled daily production problems/change requests (DBCRS) with Oracle.
• Developed custom database monitoring/health check alert scripts for database uptime/downtime status, and sizing issues using grid control (OEM).
• Proficient in raising SR/PMR with Oracle and IBM Support to resolve the bottlenecks in the database environments.
• Excellent Communication skills,co-ordination and Communication with system administrators, business data analysts and development teams.

TECHNICAL SKILLS:

Databases: Oracle 9i/10g/11g/12c, DB2 UDB 9.7/10.5, My-SQL 5.5, SQL Server 2008 R2/2012

Operating System: Red Hat Linux4.x,5.x,6.x, AIX, 4.3.3,5.1,5.2,6.2, Sun Solaris5.8,5.9,5.10, OEL 5.1,6.1,6.3, AIX 6.1, 7.1, Windows 95/98/2000/2003/ XP/7/10.

Database Tools: OUI, OEM Grid/Cloud control,DBCA, DBUA, DBMA, ASMCA, RMAN,Veritas Net Backup,ADDM, AWR, TKPROF, Toad, SQL Developer, SQL*PLUS, STATSPACK, MSEXCEL, Database Control, Data Guard Working Analysis, Erwin.

DB Utilities: EXP, IMP, EXPDP, IMPDP, RMAN, SQL*LOADER,OEM,TOAD, SQL Developer, Toad for DB2

Languages: PL/SQL, SQL, UNIX Shell scripting, PERL, XML,HTML.

PROFESSIONAL EXPERIENCE:

Confidential

Database Administrator

Responsibilities:

• Supporting and Managing all the Oracle & SQL Server databases across the organization.
• Implementation and Configuration of Oracle Enterprise Manager(OEM) Cloud Control 13c for maintenance and monitoring of all the Oracle databases in the environment.
• Installing agents on Windows serversand adding targets in Cloud Control for monitoring the database status and alerts.
• Perform Refresh of databases for application development and testing purpose.
• Involved in Database Hardening as per CIS standardsand enabled auditing across all the databases in the environment.
• Configured and scheduled Oracle Jobs USING DBMS SCHEDULER and file system clean up scripts using CRONTAB.
• Tested and Configured RMAN backups for Oracle databases through OEM Cloud Control.
• Working on Upgrading all the Oracle databases from 11g to 12cacross all application environmentsand documenting the Upgrade process for future .
• Migrating database changes using Version management through various software development lifecycle process.
• Appliedquarterly released CPU patches to update security fixes to Oracle databases 11g/12c.
• Worked on Creating Snapshot clone copy databases on 12c databases which enable to create the clone copy of the database faster and with minimal usage of Storage.
• Setup Oracle Database Gateway for SQL Server(DG4MSQL) and Created database links to connect to non-Oracle databases using DG4MSQL.
• Worked with Oracle Support to troubleshoot and fix issues/bugs on Production databases.
• Worked on gathering information for setting up Oracle Enterprise Metadata Manager(OEMM) for Data Lineage.
• Working on implementing the DEVOPS setup on all the application environments.
• Worked on POC's to test all the case scenarios to migrate all the databases in the environment to Cloud.

Environment: Oracle 9i/10g/11g/12c, SQL Server 2008/2012, Site Manager, AASHTOWARE Application, CEDAR, Road Network System(RNS),Unix, RHEL, Windows Server 2012, ASM, OEM 13c(Cloud Control), RMAN and Data Guard, SQL Developer, Toad for Oracle, Table Partitioning, PL/SQL Tuning, Data Pump.

Confidential

Sr. Database Administrator

Responsibilities:

• Workedas Operations Database Administrator(ODBA) and responsible to perform database administrative activities on different databases like Oracle, DB2, MY-SQL along with managing Oracle Retail Management System(RMS) Application and troubleshooting its related issues.
• Involved in Capacity Planning, Tuning the RAC interconnect, Finding RAC wait events and Tuning the RAC environment using the Enterprise Manager Grid Control.
• Perform re-org on tables, databases, rebuilding of Indexes as required to ensure better performance and maximum uptime of the Oracle and DB2 databases.
• Performing Oracle/DB2/My-SQL DB Refresh from Production to Stage, Quality & Development environments during various stages of development phase based on Application team’s request.
• Maintaining ASM in RAC environment and Monitoring Health checks of OCR, VOTING DISKS and Interconnect for better performance and troubleshooting issues in RAC environment (11GR2).
• Involved in Configuration and maintenance of Standby databases for High availability using Oracle Data Guard for one of critical application at Enterprise level.
• Install/Upgrade to the latest database versions, PSU's and applying latest fix pack versions to keep the databases in sync as per organisation's operational policies.
• Applying patches to fix issues/bugs related to the Oracle Retail Applications(RMS) and was actively involved in performing application related maintenance activities.
• Implement, Maintain and test backup and recovery strategies and extensively used Oracle Enterprise Manager 12c for various maintenance tasks like backup of databases, restoration and recovery of database, troubleshooting performance related issues.
• Performance Tuning for the SQL queries which are running slow and using more CPU cost at system level and performing day-to-day activities like Space Management, deadlock issues, table partitioning to improve I/O access.
• Installing/Setting up Custom alerts on OEM and to monitor the health of Oracle and DB2 databases.
• Migrating database changes, data changes, menu and form changes using version management through the development life cycle.
• Perform data refresh at Schema level using EXPDP/IMPDP utility and Refresh of specific 12c Pluggable database as per Application team's requirement.
• Designed, installed, and configured high-performance uni-directional replication solution using Oracle Golden Gate 11g replication between two data centers.
• Installed 12C grid control, installed agents and registered databases in OEM for monitoring.
• Worked on providing application/database access and fixing user’s application related issues.
• Provide technical support to application support teams and review the design and code changes before Production deployment to ensure that there is no impact/performance issue on the Production databases at later stages.
• Raising IBMPMR/Oracle SR with Support Vendor's to fix bugs/issues on Production databases.
• Working with development teams in maintaining naming standards for newly developed databases objects and assisting in code deployment, migration and testing phases.
• Worked on setting up access to the Oracle Business Intelligence team to access the reports.

Environment: Oracle 9i/10g/11g/12c, IBM DB2 UDB 9.7/10.5, MY SQL 5.5, Oracle Retail Management System(RMS) Application, Oracle Weblogic server 11g, Unix, AIX, RHEL, Solaris, ASM, OEM 12c(Cloud Control), RMAN and Data Guard,Datapump, Oracle-Wallet-Management, SQL Developer, Toad for Oracle and DB2, Table Partitioning, PL/SQL Tuning,SQLLoader.

Confidential

Database Administrator

Responsibilities:

• 24x7 production database administration and applications support
• Installed, configured and maintainedOracle10g and 11g R2 on Linux, and upgraded fromOracle11g to 12c.
• Performance Tuning of Oracle Real Application Clusters (RAC).
• Involved in migration of non ASM database to ASM database.
• Involved in Design and implementation of Oracle 11g Data Guard both Physical/logical Standby databases for high availability and disaster recovery.
• Worked on replication and upgraded Production databases with zero downtime using Oracle Golden Gate.
• Develop database Backup and Recovery and Disaster recovery strategies scheduling full and incremental backups using RMAN.
• Created a Standby database using RMAN Duplicate to reduce the down time for the PROD database during the migration process.
• DevelopedShell Scripts to automate the Data Loading process, automate the Backup process and for automation of various Database-Monitoring activities.
• Imported and exported data, databases, schemas and tables using SQL loader and utilities like expdp and impdpdatapump features.
• Troubleshoot database performance issues using Automated Workload Repository (AWR), Automatic Database Diagnostics Monitor (ADDM), Active Session History(ASH) and Tuning the database for optimum performance.
• Involved in the creation of database objects like partitioned tables, materialized views, bitmap indexes, procedures, functions, packages, triggers, views, synonyms and Index Organized Tables.
• Identify poorly performing queries and tune them using Explain Plan, TKPROF, STATSPACK reports and assisting the developers in optimizing and tuning the SQL and PL/SQL code using SQL trace and SQL Tuning Advisor.
• Setting instance parameters and managing Table spaces, segments, extents, indexes, undo data and redo logs.
• Creating Users and managing Users by assigning roles, privileges and profiles to users.
• Setup Oracle Enterprise Manager (OEM) 12c, Installedagents and registered 11g/12c databases for monitoring and tuning the database issues.
• Tuning the SQL queries and tuning the database performance issues at system level to improve the performance of the database.
• Responsible for maintainingOracle11gR2 using SRVCTL, OEM, maintainingOracleClusterware using CRSCTL.
• Closely work with project teams as operations database administration support to ensure that new objects in databases are appropriately modified to support new business applications and requirements.
• Applied quarterly released CPU patches to update security fixes to Oracle database 11g.
• Relatively good experience working with ETL data processing tool and working closely with the ETL Support team.
• Documenting Installation and Upgrade activities and prepared SOP’s with detailed explanation for regular maintenance activities

Environment: Oracle 9i/10g/11g, DB2 9.7/10.5, AIX,OEL, Linux, Unix, RMAN, DBCA, Dataguard,Oracle Golden Gate,Datapump,TSM, OEMand Putty.

Confidential

Oracle DBA

Responsibilities:

• Database administration for Oracle databases including installation, configuration, backup and recovery, performance tuning.
• Upgrade the databases from 10g to 11g and applying the latest PSU.
• Database refresh from Production to lower environments using RMAN to replicate the production issue scenarios for development teams to troubleshoot the issue.
• Performed various tasks on ASM, creating a disk group, Adding a disk to disk group, making disk Online and Offline and troubleshooting issues in ASM environment.
• Oracle database 12c- Worked on install, upgrading to 12c, creation of CDB and PDB databases.
• RAC conversion and Maintenance-Worked on converting single instance databases to Real Application Clusters.
• Performing backups and recoveries using RMAN/conventional hot backups.
• Configured Physical Standby databases using data guard and converted Physical Standby to Snapshot Standby and Involved in DR drills and successfully recovered mission critical environments Using RMAN and Dataguard.
• Setup and Document Backup and Recovery strategies and procedures after evaluating various options including RMAN.
• Migrated data replication solution from Oracle Streams to Oracle Golden Gate 11g.
• Tuning SGA memory structures via. Shared pool by tuninglibrary cache, dictionary cache and buffer cache to reduce paging/swapping at system level and tune the SQL queries to improve theoverall performance of the database .
• Perform re-org on the tables, tablespaces and rebuilding the Indexes for better performance, maintenance of Oracle databases.
• Monitored hit ratios for buffer cache, library cache and dictionary cache.
• Mirrored / Multiplexed control files & redo log files.
• Performed the schema migration from development to test environment using export and importfor application team's testing purpose.
• Upgraded OracleEnterprise Manager from 11g to 12c Cloud control and used it for monitoring and performing maintenance activities on all the managed databases using Oracle Enterprise Manager(OEM) 12c.
• Worked on Building schemas, cursors, developedStored procedures and database triggers in PL/SQL.
• Installed, created, upgraded and maintained Oracle EBS Application(R12.2,Weblogic 11g,OTM 6.2).
• Assisted in the configuration of Oracle Golden Gate for replication.
• Applied RDBMS and Application Patches-Analyzed new PSU and bug fix patches, documented and applied in non-production and production environments.
• Defined users, Custom responsibilities, Request group, menus and functions in Oracle EBS R12 application.
• Migration of Custom Database Objects &AOLsrelated to EBS R12 application from Development Instance to INT/UAT/QA/PROD Instance.
• Troubleshooting concurrent request and manager issues- Worked on issues related to Concurrent managers and performance issues like long running concurrent jobs.
• Installed Oracle Business Process Management(BPM) suite for business applications to create and customize business process models.
• Developed shell scripts to automate the user creation at database level to minimize manual intervention.
• Designing and enforcing standards and naming convention for custom developed objects.

Environment: Oracle9i/10g/11g/12c, Oracle E-Business Suite 11i/R12, Oracle BPM, Sun Solaris, AIX, OEL, Linux, Unix, TSM, RMAN, Data Pump, DBCA, Data guard, OEMand Putty.

Confidential

Oracle DBA

Responsibilities:

• Involved in Installation and customization of databases(10g/11g).
• Created and Managed users, roles, schemas, tables, views, indexes and rebuilding Indexes and granted privileges.
• Involved in checking and managing tablespace growth, monitoring the data file growth and extents too.
• Performed Auditing on user activities on request and as per organization policies.
• Configured Recovery Manager (RMAN) and Performed Hot, Cold and Incremental, differential backups for Production databases using RMAN.
• Performed Cloning and Refresh of Database from production environment/backup to test environment using RMAN Duplicate database and Data pump import export.
• Identified and fixed the logical block corruption using RMAN.
• Monitoring tablespace issues, creating tablespaces and adding datafiles.
• Involved in taking logical backup using Data pump Expdp and Impdp Utility.
• Performed Data load on different databases from flat file using SQL*Loader.
• Proactively managed the databases, set up alarms for managing any exceptions in day to day management of the databases pre-empted and prevented issues, disasters from happening.
• Conducted daily routine checks on alert logs and trace files for database errors and used to take necessary action to resolve the issue.
• Upgraded databases from Oracle 10g to 11g versions and applied latest patches as and when required.
• Setup and maintenance of Dataguard/Physical standby databases, and also performed Dataguard switchover and failover testing.
• Extensively used SQLtuning advisor, AWR, ASH, ADDM and other performance analysis tools, analyzed and implemented the suggested changes in non-production and production.
• Installed OracleEBS R12.0.4 and upgraded to 12.1.3 for the application teams to test and implement new functionalities to upgrade to the latest release.
• Involved in Oracle EBS 11i/R12 maintenance activities like AD utilities, OAM, Concurrent Managers and processes, setting up printing issues, starting and stopping of applications.
• Password Maintenance-Changed database & application passwordsevery quarter as per organization's standard policies.
• Creating of Custom top and registering Custom top with Application File System.
• Reorganizing database for better space utilization- Worked on reorg to save space and improve the performance. Performed scheduled and on demand purge and re-org.
• Troubleshooting database problems faced by the application developers/users.
• Documented the complete project including all pre-installation, post-installation and database configuration steps.

Environment: Oracle 9i/10g/11g,Oracle E-Business Suite 11i/R12, Red Hat Linux, Cent OS, Oracle Enterprise Linux, SQL* Plus, Data Pump,TSM,Veritas, Putty, OEM, PL/SQL