Manager Oracle
Resume:
Anudeep
*****@***********.***
Professional Summary:
ORACLE DBA with 8 years of experience in Database Administration, providing 24x7 production support and development support 11g R2, 10gR2, 9i databases on different platforms with practices for Oracle Database Infrastructure, Standards and Implementation.
Extensive experience in Installations, configuration, Cloning, Security, Patching, Upgrades.
Implementation of Enterprise wide Database Monitoring enabling Oracle 11g Enterprise Manager Grid Control. One stop solution for monitoring every single Oracle Database within the global enterprise
Database Backup and Recovery using RMAN including duplicating/cloning Databases across with point-in-time recovery option.
Oracle Exadata Database Machine administration, performance tuning, migration, backup and recovery
Installation and configuration of Oracle 10g &11g RAC using Cluster ware and ASM.
Installed Oracle Golden Gate 11g, Implemented uni-directional and bi-directional replication.
Strong experience in RMAN, fail-over/fail-back/switch-over of stand by databases.
Hands on experience on Oracle ExaData Database Machine Implementation and Maintenance.
Experienced in Installation and Configuration of Oracle Primary and Standby (Dataguard) Database and Switchover/Switchback of Database in 10GR2 /11GR2 RAC
Experience in multi-node and RAC environments including configuration of PCP.
Experience in very large scale database environment and mission critical large OLTP and OLAP systems.
Created development, testing, staging, production, RAC and standby databases for OLTP, DSS and Data Warehousing using customized shell scripts and stepwise.
Highly experienced in Cloning of Oracle databases from multi-node to single-node and single node to multimode
Enabling Load Balancing in a Multi-Tier Architecture
Import/Export and Expdp/ Impdp utilities.
Monitor nightly Database backup Jobs and necessary actions for failed backup jobs including script corrections, disk space monitoring and Database availability.
Setup procedure for Database statistics gathering – Frequency, Best Time of the day to execute stats gathering jobs, correct level of gathering statistics.
In-depth understanding on oracle utilities SQL Trace, Explain Plan, TKPROF, Statspack, AWR, Analyzer and DBMS_STATS in Performance Tuning.
Creating roles, profiles, privileges and assigning roles to users.
Extensively worked on monitoring and optimizing the database by performance tuning.
Hands on experience with various tools like SQL*Loader, TOAD, Oracle SQL Developer and Oracle Enterprise Manager (OEM).
Hands on experience on Mongo DB admin and configuration, replication and BRS backup.
Developing shell scripts and SQL scripts to carry out routine checks on databases.
Implemented proactive monitoring scripts for production databases.
Troubleshooting for slow performing SQL by enabling Database tracing including session specific tracing. Performed SQL Tuning using Explain Plan.
Database trigger, stored procedure and packages PL/SQL coding.
Multiple upgrades of Sun Solaris and Linux servers from 9i to 10g, 10g to 11g.
Knowledge on Oracle Support Process for Technical requests using Oracle Metalink and other support procedures.
Result oriented, Self-motivated, Team Player, Ability to work independently and can work during weekends and on-call rotations for support and maintenance activities. Track record of meeting the SLA's within time, Ability to learn any technology and become productive.
Educational Qualifications:
Bachelor of Technology
Technical Skills:
Database
Oracle 12C,11gR2, Oracle 11gR1, Oracle 10gR2, Oracle 9i,8i, MYSQL, SQL Server 2008
Oracle Products
Oracle Real Application Cluster 10g/11g/12C, OEM 12C, Golden Gate, Data guard, Import & Export, Data pumps, Data Masking, Oracle Wallet Management, Automatic Storage Management, Oracle 10g/11g/12c (Grid Control), Oracle +Exadata, RMAN, Transparent Data Encryption and ETL(Extraction Transformation and Loading)
Operating System
Oracle Linux, HP UNIX 11i, Red Hat Enterprise Linux (RHEL) 4.x, 5.x, 6.x, Sun Solaris 5.8, 5.9, 5.10, Windows XP/2003/2008, AIX 5.x
Languages
SQL, PL/SQL, Unix shells scripting, VBScript
Tools & Utilities
SQL Trace and SQL tuning Advisory, SQL* plus, ADDM, DBCA, Log Miner, TKPROF, AWR, ASH, Toad, Putty, ERWIN, ETL tool, DBUA, Opatch, Statspack,DB Verify, SRVCTL,CRSCTL, ASMCMD, ADRCI, SQL Loader
Web Monitoring Tools
Web Portals, BMC Remedy, HP Quality Center, HP Java ITO (OVO) console, Oracle Enterprise Manager(OEM) 12c/11g/10g
Web Technologies
HTML, XHTML, CSS, XML
Professional Experience:
Cisco Systems, Morrisville, NC Aug’13 – Sept’15
Sr. Oracle DBA
Responsibilities:
Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
Cross Platform Migration from 10G to 11GR2 using Transportable Tablespaces.
Installation of Oracle Database Software 11G.
Configured Golden gate extract and replicate during the database character set conversion.
Configured Golden gate datapump extract to move the trail files from source database server to target database server.
Oracle RAC 11g implementation on Linux platform.
Involved in Installation and configuration of Oracle 10g &11gRAC using Cluster ware and ASM.
Cluster management and verifying cluster process to ensure smooth operations.
Oracle 10g Physical and logical Data guard installation and maintenance.
Administration of application specific data marts.
Configured and Manged Oracle Solaris ZFS Database Overview.
Migrating multi terabyte Oracle database from AIX, Solaris to Exadata environment
Applying bug fixes and bundle patches(BP) on exadata environment
Performed Data Guard switchover/failover as per the requirements.
SQL Queries/Application and Database performance monitoring and tuning using various tools like ADDM, AWR, Explain Plan and Statspack reports.
Worked on Golden Gate 12c Replication configuration like unidirectional as well as bidirectional as per the requirement and addition of tables for the existing Golden Gate configuration.
Database Growth and Space management, capacity planning; distributing the tables, redo logs, archived redo logs and rollback segments on different disks to optimize data retrieval.
Configuring parameter file to fix sizes of SGA components in conformity to available resources.
Involved in logical backup using and full/ partial export/import and Data Pump.
Oracle Solaris ZFS manages synchronous writes internally with the Oracle Solaris ZFS intent log (ZIL)
Expert in implementing complete setup and support of RAC environment with major components like ASM, DIAG, RDBMS, Services, Patches, Disks, Grid Control, EXADATA update/upgrade etc
Used SQL Loader extensively to extract data from flat files and loading into the new application.
Performed database analysis, design, coding, testing and implementation of database structures.
Maintaining UNIX scripts for monitoring and backup.
Provided real time, capture, transformation, routing and delivery of database transactions across the systems with the help of Golden Gate 12c
Monitored Oracle ZFS Cache sizes with the command and readjusted the parameters whenever needed.
Worked on Golden Gate, leading tool for data replication.
Installed and Configured GOLDEN GATE Extracts/replicate for multiple databases
Database managing and monitoring using Oracle Enterprise Manager (OEM).
Involved in Database migration across the different OS versions.
Planning, Scheduling and implementing database changes while ensuring no impact to users.
Applied Oracle patches for DST, upgrading and migration of databases.
Working on Oracle Exadata Backup Configuration utility
Captured messages from JMS messanger with the help of Golden Gate 12c
Configured error handling for restart, logging, production support and status reporting in Golden Gate.
Cloned databases using custom shell script with hot and cold backups of source database.
Implemented VERITAS Net Backup using RMAN (Recovery Manager) as a media management layer.
Performed user administration, space administration on development and test database.
Creating the database, tables, table spaces and data objects, setting privileges, indexes, user and password management, Security administration.
Creating Indexes, rebuilding indexes, analyzing indexes to improve the performance of query.
Implementation of Oracle & Application Software Patches and maintaining SW License and maintenance agreements.
Trouble shooting and performance tuning golden gate replications.
Implemented necessary monitoring scripts for Golden gate in unix/perl scripting.
Creating tablespaces and planning the location of data, index and rollback tablespaces redo log files and control files in adherence to the Optimal Flexible Architecture.
Performing regular Backups and Recovery as per Organization Strategy to support the database and Troubleshooting with restoring and recovery.
Environment: Oracle Database 10g/11gR2, Data mart Oracle Enterprise Manager 11g/12c, Oracle Golden gate 11.2.1 Shell Scripts, Batch Tools, Secure Shell, Toad, SQL Developer, Putty, OUI.BMC Remedy
Barclay Card US, Wilmington, DE Apr’12 – July’13
Sr. Oracle DBA
Responsibilities:
Working as a Sr. Oracle DBA to support Oracle 11g database and perform all the maintenance activities such as Patching, Cloning, tuning etc.
To set up plans and procedures to perform maintenance activities conforming to the existing Customer standards and guidelines and be able to seamlessly work upon service levels.
Involved in designing of disaster recovery plan using Data Guard, and High Availability using RAC.
Intensively used 10g Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitoring (ADDM) reports for the health check of the databases and used the notification tool to send the alerts in OEM Grid Control.
Cloning databases using scripts as well as RMAN and performed Table space point in time recovery (TSPITR) using RMAN.
Configured Golden Gate replication between Production and Pre Production, Performance and Prime Performance environments.
Installed Oracle Golden Gate 11g, Implemented uni-directional and bi-directional replication.
Monitor the golden gate process manually and using Oracle 12c cloud control
Reading Alert Log and User trace Files and Diagnosing the Problem.
Installed and configured Data Guard using RMAN, written shell script for monitoring archivelog GAP on standby database.
Monitoring and Troubleshooting of Physical standby Database Replication issues.
Playing the role of a Liaison between the Business Team and the Development Team.
Installation and configuration of Oracle client products and Maintenance of Concurrent Programs
Review the Customized codes being put into the Oracle system and optimize the performance of the same.
Providing Oracle DBA related activities like patching, upgrade and Oracle Administration related activities like managing build for code migration for different releases, code migration, configuration management and other activities
Created users account for the Golden Gate and granting privileges
Planning, applying and monitoring Oracle patches on different instance and Applying patches, cloning and other Oracle DBA activities and Controlling database and Security
Coding Standards and configuration management through various development instances and also integrating the Custom developed components.
Shell Scripting and PL/SQL Programming to resolve business problems of various nature.
Rebuilding of Indexes and managing the table partitions for better performance, maintenance of Oracle Database.
Upgraded production databases from 10g to 11g without downtime using Golden Gate replication
Experience in Identifying performance bottlenecks on high volume transaction systems. Analyze SQL statements, reorganize database objects and design indexes to improve response of queries.
Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL*Trace and TKPROF, STATSPACK.
Configuring and Monitoring the Multi Master Replication for the disaster Recovery in Production environment.
Work with database, engineering and infrastructure team to manage scheduled clones for all supporting environments and dependent systems.
Environment: Oracle Database 10g/11gR2, Oracle Enterprise Manager 11g/12c, Shell Scripts, Batch Tools, Secure Shell, Toad, SQL Developer, Putty, OUI, Sqlplus, OVM, VNC
Merial Pharmaceuticals, Atlanta, GA Dec’10 - Mar’12
Oracle DBA
Responsibilities:
Upgrade/Migration of the oracle databases from Oracle 9i to Oracle 10g.
Installation, Configuration and Administration of Oracle 10g RAC with ASM.
Extensively used Oracle Enterprise Manager (OEM) Grid Control for maintaining and monitoring databases.
Setup of Standby database for faster disaster recovery and Data guard setup for high availability.
Perform hot, cold, incremental, cumulative, differential backups using RMAN.
Partitioning tables by determining the suitable methodology to improve performance and manageability
Implement Golden Gate replication solutions to facilitate data flow between heterogeneous (SQL Server and Oracle) environments
Key role in optimizing database performance by analyzing database objects, generating statistics, creating indexes, creating materialized views, Oracle 10g AWR, ADDM, ASMM etc.
Checking of Alert log and Trace files to monitor the database on a daily basis.
Patched Oracle Database Server 9i and 10g using Opatch, apply security patches (CPU/PSU).
Tuned memory System Global Areas like Shared pool area, Data Buffer Cache, redo buffers, I/O, Contention, modified parameter file and rebuild indexes according to the requirement for performance.
Utilized recovery methods like Point In Time Recovery (PITR) and Table Space point in time recovery (TSPITR) using RMAN.
Implement Golden Gate replication solutions to facilitate data flow between heterogeneous (SQL Server and Oracle) environments
Creating users grant permissions and coping with the day-to-day demands and troubleshooting their connectivity, permissions and performance problems.
Wrote shell scripts and scheduled database backups using Cron utility.
24/7 Production Oracle database support and administration.
Provided on-call support regarding production-related database problems.
Co-ordinate with IT managers and application developers to ensure the database integrity, high availability and security.
Environment: Oracle 10g, Linux, Windows, Oracle Enterprise Manager, Golden Gate, Toad, RMAN, Data Pump, Putty, SQL Loader
ADT Securities, Boca Raton, FL Feb’09 - Nov’10
Oracle DBA
Responsibilities:
Managing day-to-day operational aspects of a project and scope.
Managing application security, including creation of users, responsibilities and setting up profile values, assigning roles, manage printers.
OEM grid control setup for managing and monitoring the Oracle e-business suite and other legacy databases.
Building and implementing backup and recovery strategy using RMAN.
Monitor and optimize performance of the database using AWR and other oracle provided tools.
Troubleshooting issues related to concurrent manager, apache server, forms server, report server, concurrent requests.
As a first escalation person for any issues for the customers, responsible for helping any time 24/7 to the assigned customers.
Creation of users, assigning responsibility, creation of custom menus and responsibility
24x7 Production Database Administration and support.
The work involves overall maintenance of Oracle 10g database, performance tuning, backup, recoveries and other database related activities.
Installation and configuration of a 2 node RAC.
Configuring a Physical stand by with Maximum Availability mode.
Configuration and implementation of Bidirectional Streams.
Taking Backups on scheduled time and monitoring scheduled RMAN Backups.
Establish and Document Backup and Recovery strategies and procedures after evaluating various options including RMAN.
Creating and dropping of users, granting and revoking rights as and when required.
Day to day performance monitoring and tuning of database applications using SQL Tracing, Explain Plan and Tkprof features.
Monitoring of database objects like rollback segments, temp segments and tablespaces
Diagnose and troubleshoot Database problems and failures
Involved in the Design (Logical and Physical) of Databases
Management of table space growth, monitoring data files additions, extent growth
Constantly monitor the performance at peak load of the Databases and viewing Alert log files and Trace files.
Monitoring of database for growth and performance
Monitoring Growth of tables and undertaking necessary re-organization of database as and when required.
Environments: Oracle 10g, OAM, OEM Grid Control, Unix Shell Scripting, UNIX Cron jobs, RMAN, TOAD, Oracle Dataguard, OEM, Toad, Data Mover, Import Manager
Tracfone, Doral, FL Jul’08 – Jan‘09
Database Administrator
Responsibilities:
Installation, Configuration, Upgrade and patching of Oracle 9i/10g.
Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
Involved in DATAGUARD (Standby) setup for high availability and disaster recovery purpose.
Provided support to Application Database Administrators in designing the database.
Scheduling and Performing regular database backups using RMAN.
Using sql trace, tkprof, explain plan, autotrace, statspack reports for performance issues resolution.
Extracting of data from different flat files into Oracle Database using SQL*Loader and automated the process.
Import and Export of database objects to copy from one database to another database.
Responsible for creating Database links.
Developed UNIX Shell Scripts for automating the loading procedures.
Upgraded Oracle 9i databases to Oracle 10g and implemented Oracle 10g features to ensure high performance and easy maintenance.
Configuring flashback database for production.
Automating the regular processes using Dbms_scheduler, Crontab job schedulers.
Creating users and roles to maintaining database security.
Worked with application developers to debug PL/SQL programs, tune queries and database sizing.
Creating PL/SQL packages, procedures and database triggers.
Database tuning, backup and recovery and general day to day running of the system.
Systems analysis and design.
Provided on-call support for Production databases and also resolved the issues working with development team.
Environments: Oracle 9i/10g, HP UX, Windows 2003 server, Oracle Configuration Assistant, Oracle Data guard, Oracle Universal Installer, OEM, Import Manager, Shell Scripting, PL/SQL.
Celestial Technologies Ltd, India Dec’06-Jun’08
Oracle DBA
Responsibilities:
Install and Managed Physical Standby databases Data Guard for disaster recovery.
Experience in Backup and Recovery techniques using RMAN.
Integrated the Backup Status Reporting for all the databases in the enterprise to enable the web reporting using Oracle SQL, PLSQL
With help of EXPORT/IMPORT utility of database to do table level and full database Defragmentation.
Extensively developed UNIX Shell scripts to automate database operation and database monitoring.
Experience in working high transacted OLTP systems.
Creation of monthly IOT, creation and management of partitioned indexes and tables. Performance Monitoring and Tuning Databases and Application.
Partitioning for improving big tables to improve the Performance of the database.
Identifying bottleneck and rectifying it fine-tune store procedures to improve performance, database loads, performance improvements, proper setup of database files.
Performance tuning at database level for the parameters like SGA, PGA, PGA_AGGREGATE_TARGET.
Implemented and monitored all databases using Oracle Enterprise Manager (OEM) for maximum uptime and optimal performance
Maintaining data integrity and tune database for optimum performance and availability.
Environment: Oracle 10g, Windows NT, Windows 2000 server, UNIX, Data Mover, Import manager, Data guard
Contact this candidate