SUMMARY

• IT Professional with 10+ years of experience as an ORACLE DBA on different platforms.
• Providing 24/7/365 primary systems dba support of all Oracle RAC & standalone databases and related systems on Solaris SPARC, Solaris x64, AIX and Linux
• Experience managing large - scale, massively concurrent, highly available distributedOraclesystems.
• Have a proven ability to rapidly master complex new skills, concepts and troubleshoot complex technical problems under pressure. Experience as Oracle DBA spanning version 8i to 12c on different HP-UX, Sun Solaris, Linux, AIX, and Windows 2000/NT environments.
• Disaster recovery planning, detailed out the processes and procedures for implementing disaster recovery, implemented database backups and Disaster recovery strategies using RMAN. Experience setting up DR through various synch methods.
• Ensuring optimal resilience of deployed systems and meet all disaster recovery and compliance requirements dictated by the business.
• Supported Microsoft sql server 2012,2008 and 2005 in restores,backups.
• Experience in Oracle Real Application Clusters (RAC) Installation, administration, troubleshooting and Performance tuning in 12c and 11g environments
• Implementation of High Availability solutions with Oracle 12c RAC, Physical and Logical Standby Databases (Data Guard). Thorough Experience supporting the Production Databases with complete lifecycle including Installations, Upgrade, Patching, Cloning, Backup/Recovery.
• Extensive hands-on experience in the design, construction and deployment of data warehouse systems andExperience supporting Data Warehouse Databases over 10 TB in size.
• Proficient in Oracle 12c/11g/10g/9i/8i Database Design, Installation of Oracle binaries on various platforms. Implementing, Administration, Performance tuning and troubleshooting 24x7 Production environments.
• Troubleshooting Oracle database issues and optimization issues using AWR reports and Explain Plans. Analysing Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitoring (ADDM), Active Session History (ASH) reports for the health check of the databases, and used the notification tools to send the alerts in OEM 12c Grid Control.
• Experienced in Installation, configuration and setting up of Oracle Enterprise Manager Cloud control 12c Release 3, installing Oracle management agents on Linux platform.
• Experience upgrading enterprise manager cloud control 12c,upgrading oracle management service,Repository, agents
• Extensive experience working for datacenter Migration projects between Coppell and Westminster for all oracle databases for Confidential Corporation.
• Coordination with UNIX/Storage/Network Engineers in troubleshooting issues.
• Technical lead in critical database projects during requirements, design, development, QA, production implementation and monitoring phases
• Prepare and maintain technical documentation for DBMS standards and design (e.g., system requirements), database parameter configurations, and prototype designs, as well as backup and recovery plans
• Good Knowledge of oracle High Availability features, Disaster Recovery, Cluster Technology and FLASHBACK Technology.
• Design and Deploying Oracle RAC environments, Monitoring, Evaluating Performance, Configuring RMAN for Oracle RAC
• Adding and Deleting Oracle RAC from Nodes on Linux and UNIX Systems, diagnose problems for Oracle Real Application Clusters components using trace and log files
• Converting Single-Instance Oracle Databases to Oracle RAC and Oracle RAC One Node
• Administering Oracle ASM Instances,ASM Disk Groups, ASM Files, Directories, and Templates
• Experience creating, managing troubleshooting physical and logical standby databases.
• Upgrading Databases in an Oracle Data Guard Configuration. Experience working on different scenarios while administering Oracle Data Guard configuration
• Experience using Oracle Database High Availability Solutions for Unplanned Downtime
• Creating a standby database with Recovery Manager(RMAN) and good understanding of Oracle Data Guard protection modes, redo transport services, apply services, role transitions
• Tuning RMAN performance,troubleshooting RMAN operations by interpreting RMAN message output
• Experience working on Advanced RMAN recovery scenarios, Block Media Recovery, Oracle Flashback Technology and Database Point-in-Time Recovery
• Experience installing, configuring and maintenance of Oracle Goldengate 11g Release 2 ( 11.2.1.0.13 ), Active/active, Uni/Bidirectional Configuration, Zero Downtime Migration Experience.
• Experience setting up Goldengate monitors, Trail file Management, familiar with logdump utility, Conflict Detection & Resolution, Data Selection, Filtering and Maintaining data flows
• GoldenGate configuration review, implementation, test and performance analysis and tuning.
• Installed and configured Golden Gate software, patching, created manager, extract, replicate parameter files and tested the data flow from source to target database
• Identifying High-Load SQL Statements, improve the efficiency of high-load SQL statements by tuning them using SQL Tuning Advisor
• Interpretation of Automatic Database Diagnostic Monitor(ADDM) Findings, Reviewing ADDM Analysis, Implementing ADDM Recommendations
• Optimize data access paths by creating the proper set of materialized views, materialized view logs, and indexes for a given workload by using SQL Access Advisor
• Analyse SQL performance impact of SQL tuning and other system changes by using SQL Performance Analyser
• Determining the Cause of Spikes in Database Activity by Viewing SQL Execution Details for SQL /PL SQL Statements
• Running Active Session History Reports and Diagnosing Serious Performance Problems in Real Time.
• Tuning SQL Statements by Creating SQL profiles, Restructuring SQL statements, Creating additional indexes or materialized views, Refreshing optimizer statistics, Managing SQL Profiles, Managing SQL Plan Baselines
• Proficient in Oracle High Availability features like RAC, DATA GUARD, GRID CONTROL and Oracle Performance Tuning Utilities like ADDM, AWR, ASH, SQL-Tuning Advisor, MTTR Advisor, EXPLAIN PLAN, TK PROF, and DBV.
• Expertise in using backup/recovery strategy, designing and implementation using cold backup, hot backup and RMAN methodologies. Vast knowledge of different recovery scenarios using RMAN in Production environment
• Experienced with tools/utilities: OEM, RMAN, Stats pack, TOAD, SQL Navigator, and SQL* Loader, Data Pump (expdp/impdp).
• Used PL/SQL (Stored procedures, triggers, packages), SQL* PLUS, SQL* LOADER and SQL tuning of Oracle database.
• Hands-on Experience in System Configuration’s, planning upgrades for mission critical production databases, migrating Databases for Lease Rollover, Patching Databases without affecting the critical business activities.
• Intricate knowledge of the Oracle database internals, Architecture, Data Dictionary, Data Management, Automatic Storage Management (ASM) and System Management
• Implemented Cross Platform Transportable Table spaces to move large databases across platforms
• Representing team on problem calls to provide RCA along with order of events occurred while addressing Severity1 and Severity2 MUIs (Multi User Incidents)
• Attending IT CAB (Change Advisory Board) meetings every Week to discuss the approved changes (CRs).Providing Inputs for back out plan, back out time, post implementation testing
• Review and implement incoming Service Requests (SRs) and ensure that they are resolved within SLA. Investigating, remediating and promptly closing all incoming Incidents(IC’s).
• Efficient and prompt in communicating and coordinating with other groups during implementation of HPSM change tickets during the change window
• Excellent analytical, problem solving, communication Skills and very proactive in nature.
• Ability to troubleshoot highly complex technical issues related to the Oracle Database in areas like High Availability, Golden Gate, Data Guard, Corruption, Backup and Recovery, RMAN, Performance, Memory Management, Streams, Advanced Queuing, Data Warehousing, Storage, Capacity Planning.
• Migrated multiple Clients from AIX, Solaris, Windows, HP-UX, and Linux to different platforms with Oracle 11g,10g,9i
• Oracle 11g RAC installation on Linux - 4 node to test new features. Upgraded several 10g RAC clustered databases to 11g
• Vast experience working on ORACLE 12c/11g/10g/9i on high-profile, externally facing, large scale projects
• Excellent working knowledge on Installations, Upgradations, Cloning & Migrations of Oracle server software and related products
• Experience with performance tuning of application and database tier, process and query optimization, troubleshooting locking issues, resource contention monitoring, analysis of queries
• Established effective database performance monitoring procedures.
• Database Tuning - Tuning Applications, Tuning Memory, Tuning I/O and Tuning Disk Usage.
• Downloading and applying Oracle patches for bug fixes using OPatch utility
• Expertise writing script to monitor the database with shell and PL, SQL code such as procedure, function, and package.
• Worked both as a Development DBA and a 24x7 Production DBA
• Experienced performing installation, configuring SQL Server Instances on windows enterprise server 2008
• Good technical exposure in troubleshooting maintenance jobs, migration, creation, restoring of SQL server databases as well.

TECHNICAL SKILLS

Operating System: LINUX Platforms RHEL 6, 5.x,HP-UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 8, 9, 10, AIX 5.1, 5.2 and Windows Server 2008/2003/2000/ NT

Database software: ORACLE 12c/11g/10g/9i,SQL Server (2012,2008,2005,2003)

HighAvailability: RAC (12c/11g/10g), Data Guard (Physical and logical standby setup),GoldenGate

Tools: & Utilities OEM (Oracle Enterprise Manager), RMAN (Recovery Manager),SQL*Loader, SQL *Plus, TOAD, Data Guard, Putty, Statspack, Opatch, Winscp3

Languages: SQL, PL/SQL, C, shell scripting, Html, Java, and JSP

Ticketing Tools: Clear Case, Clarify, HP Service Manager (HPSM), HP Service Desk (HPSD)

PROFESSIONAL EXPERIENCE

Confidential, Jacksonville, FL

Sr Oracle DBA

Responsibilities:

• Installed, configured and maintained Oracle 12c/11g/10g standalone and RAC databases (2node, 4node) on Linux, Solaris and Windows Platforms.
• Designed and implemented high availability solutions such as Data Guard and Real Application Clusters on Linux and Solaris Platforms.
• Installed and configured QA, Development and Production instances on Windows 2003 Servers, Linux and AIX servers. Provide all tuning, cloning, 24 X 7 support for production environment.
• Extensive tuning and scalability benchmarking of various environments at the Operating system and Database level for AIX, HP-UX and Solaris.
• Migrated data from an existing legacy based manufacturing and financial system to newer versions of oracle database release 11g and 12c RAC environments
• Converting Oracle Database 11g (Release 2 ( 11.2.1.0.13 )) Installations to Oracle RAC.Oracle. Complete Oracle Clusterware Installation, Validating the Cluster, Installing Oracle Database 11g Software with Oracle RAC, OCR,CRS,resolving administrative Issues, Monitoring Oracle RAC Database and Cluster Performance
• Configured Data guard(10gR2 and 11gR1) Physical standby, start DR in read-only mode, Role reversals, Monitoring/troubleshoot the DR database
• Strong experience working on Unidirectional replication, one source to two destinations(all databases are Oracle 11.2.0.3.0 on Linux x86-64),Upgraded from GG 11.1.1.1.2 to 11.2.1.0.13
• Installed and configured Goldengate with latest patches. Investigated long transactions and Monitoring of up/down/lag for GoldenGate processes
• Goldengate trail logs cleanup, Resolution of GoldenGate data errors, Up/Down of Extract, Pump, Replicat processes
• Cloning/Patching/Migration/Upgrades. Scheduling and executing the Oracle Critical Patch Updates.
• Performed Daily, Weekly and Monthly Backups. Tested and implemented restore procedures for complete and incomplete recovery using RMAN
• Handled Problem calls to brief issues with storage, OS, corruptions, and performance complaints from developers.
• Install, tune and configure complex clustered database environments and setup SAN, Oracle 10g RAC, ASM, OCFS, Dataguard, Veritas Cluster,
• Supported MS sql server databases.
• Monitored the Performance of the migrated databases using OEM 12c grid Control. Interpreting AWR, ADDM, ASH reports to diagnose health check of the databases.
• Managing optimizer statistics,histograms,controlling cursor sharing, managing SQL Plan Baselines
• Installed OEM Grid Control 12c and configured targets, agents for monitoring and alerts.
• Extensively used OEM Grid Control Diagnostic and tuning packs to tune the databases in real time
• Performed cloning, duplicate of databases from Tape Devices and disks to facilitate the quicker refresh timings, build test environments, restore for table data related issues using RMAN
• Used Oracle 10gR2 Flashback Query options for recovering the whole database to a point in time, Flashback table for restoring the state of a table to a certain point in time and Flashback Drop
• Responsible for migration of data and implementing structural changes from development servers to production servers using Datapump Export, Datapump Import and database links thereby providing remote support for the Production Databases
• Performed the database’s migrations and upgrades from AIX/Solaris to Redhat Linux platforms as a cost effective measure.
• Routine Database Administration tasks such as Space Management, Upgrades, Migration, Patches, Cloning, Backup & Recovery
• Developed PL/SQL packages, procedures, functions and triggers to support application.
• Database performance monitoring, tuning database and application with efficient database parameters.
• Applied PSU Patches on various Environments
• Installed, configured and maintained SQL Server 2008/2005 on window’s servers 2008 and 2003.
• Performed SQL Server Refreshes from production to development and test environments as a part of customer/vendor request and build new databases.
• Setup/Monitored the SQL Server Jobs and activity for performance related issues.
• Performed back and recovery, restoration of SQL Server databases for legacy systems.
• Worked in 24x7 production environment and provided on-call and day-to-day support. Key member of the technical problem solving as well as problem avoidance team, routinely sought after to address extremely complex, critical customer issues.
• Developed and tested storage strategies and disaster-recovery plan for large manufacturing company's operational database, delivering solution that guaranteed recovery performance and high availability.
• 24X7 production support and on ODBA on-call rotation
• Conducting sessions on Performance Tuning for development teams.

Environment: Oracle 12c/11g/10g RAC, Oracle 12c/11g/10g, Golden Gate, Windows/Linux, IBM AIX, Linux RHEL 6, 5.x, RMAN, OEM Grid Control 12c/11g/10g, SQL server 2005, 2008

Confidential, Omaha, NE

Oracle DBA

Responsibilities:

• Providing Support to Oracle databases.
• Upgraded the Oracle Databases from 10.2.0.5 to 11.2.0.4
• Worked on 10g, 11g databases.
• Maintaining, Monitoring and Administering for Oracle environment on RAC architecture
• Setup the RAC one node.
• Worked closely with Functional/Developers and helping them in fixing issues
• Upgrade Oracle Discover Application from 10g to 11g.
• Applying latest patches from Oracle Support to the Test and Production Instances for resolving issues or Enhancing features.
• Cloning Oracle Instances from Production to Test, Development Instances and coordinate with Testing and Development Teams.
• Backups- Logical and Physical for Multiple Instances.
• Controlling and Monitoring of User Access to the Database including Granting and revoking of Privileges and Roles and Tablespace Quotas.
• Raising the Service Request and working with Oracle Team.
• Installed and configured 10g Discoverer on a Oracle Application environment..
• Supported Microsoft sql server 2012,2008,2005environments in backups,restores and performance tuning issues.
• Scheduled the Rman Backup scripts in a cron job.
• Creating and maintaining various Oracle databases on production/development servers and provide 24 x7 support
• Involved in designing and creating Databases, Tables, Views, Stored Procedures and Triggers.
• Identified, tested and resolved database performance issues to ensure data optimization.
• Implementation of system wide security policies and trouble shooting.
• Involved in migrating Oracle Databases from Development to Production Server
• Managed Login and User: adding logins, roles, groups to the Windows Server and MS SQL Server and maintaining proper security procedures.
• Applied Patches for Developers Bug fixes and Scheduled Maintenance on Oracle Databases
• Implemented DR setup on the Oracle environment as per Client Standards.
• Installed the Oracle 10g,Oracle 11g databases and Created Tablespaces on ASM environment.
• Done Full Exports and Imports of the database at schema as well as tablespace level for different customers.
• Performed the Restore of Oracle 10g/11g databases on a One node RAC environment.
• Tested the relocate of the One node RAC environment.
• Install, configure and write scripts for RMAN
• Daily DBA activities as Performance Monitoring, Instance Health Check etc
• Provided 24*7 Production support in Oracle Production Databases
• Cloning the Oracle 9i/10g/11g Databases from Production to UAT, QA, DEV databases through rman.

Environment: Oracle 11g/10g RAC, Oracle 11g,10g, 9i, IBM AIX, Sun Solaris, RHEL,RMAN,PL/SQL,TOAD,SQL*PLUS,SQL Developer, Export/Import, Data Pump, MobaXterm,ASM,RMAN,Red Hat Linux ES6

Confidential, Pittsburgh, PA

Oracle DBA

Responsibilities:

• Providing Support to Oracle,sql server database users through ticketing system.
• Upgraded the Oracle Databases from 10.2.0.4 to 11.2.0.2
• Worked on 9i,10g, 11g databases.
• Maintaining, Monitoring and Administering Instances on RAC architecture
• Performed installations of Oracle 9i/10g/11g and sql server 2012/2008.
• Cloning the Oracle environments from Production to UAT, QA, DEV boxes.
• Working closely with Users/Developers and helping them in fixing issues
• Raising the Service Request and working with Oracle Team.
• Installed and configured 10g Discoverer on a Application environment..
• Scheduled the Rman Backup, Obsolete, ageing of alert log jobs Oracle environments.
• Applied Patches for Developers Bug fixes and Scheduling Maintanence on Oracle databases
• Implemented DR setup on the Oracle Database environments as per Client Standards.
• Installed the Oracle 11g/10g/9i databases and Created Tablespaces.
• Setup and maintenance of appropriate database and application monitoring.
• Migrating application code and objects from development/test environments to production
• Installing and maintaining SQL Server database systems. Maintaining the database systems includes but is not limited to ensuring successful backups, resolving system issues, opening cases with technical support to resolve issues, monitoring success and failure of automated jobs, monitor system availability, updating system documentation, system and database recovery, etc.
• Handled monthly Database Refresh in QA-Test environment for testing of new Deployments and Build.
• Responsible routine DBA jobs like Backups and Restores.
• Done Full Exports and Imports of the database at schema as well as tablespace level for different customers.
• Provided 24*7 and On Call support in Oracle Core Databases and Oracle Applications databases(11i.R12).
• Cloning the Oracle 9i/10g/11g Databases from Production to UAT, QA, DEV databases through rman.

Environment: Oracle Database11g/10g, Toad, DBartisian, Oracle Enterprise Manager (OEM) Grid Control, RMAN,Red Hat Linux ES5/ES4.

Confidential, Atlanta, GA

Sr Oracle DBA

Responsibilities:

• Designed and implemented high availability solutions such as Data Guard and Real Application Clusters (RAC with 3 nodes) on Linux Platforms.
• Configured Five Node RAC Environments on Linux Servers
• Applied PSU Patches on RAC Environments in Rolling Fashion
• Configuration parameters for Extract, Pump, and Replicate processes, Up/Down of Extract, Pump, Replicat processes, Resolution of GoldenGate data errors, Monitoring of up/down/lag for GoldenGate processes
• Formulated and monitor policies, procedures and standards relating to database management and implement enhancements in order to improve the performance and reliability of the system.
• Administeringof databases including Development of Database Policies and Procedures, Security Administration, Documentation and Maintenance
• Designing of databasesincluding Physical Disk Layout and Sizing,Database layout and growth management, and Backup and Recovery Planning
• Implementation of databasesincluding Installation and Configuration, Initialization and Data Loading, Backup configuration and scheduling, and Disaster Recovery Testing
• Daily Operations including Tuning, Error Monitoring, Space usage and monitoring, Performance Monitoring,Patching and Upgrading, identification and resolution of hardware, software and database problems/outages.
• OEM Grid Control Diagnostic and tuning packs to tune the resources based on the ongoing performance.
• Research and identify performance bottlenecks and implement changes (CRs) proactively and avert troublesome trends, as they develop in order to ensure a stable performance for the production environments
• 24x7 coverage and response to systems alerts during after-hour periods. Specific database performance issues, error messages or service problems.
• Installation of Oracle 9i, 10g and 11g binaries on different platforms (include windows, Solaris, REDHAT Linux), for both single and multi-node environments.
• Creation of databases and Configuring Linux clustering, preparing/reviewing Build Sheets, worked closely with Infra structure/network teams to submit IAFs(Infra Structure Assessment) for new projects
• Database development activities such as designing and implementing ETL processes using PL/SQL stored procedures, SQL scripting,
• Performance Tuning and Troubleshooting. Creating SQL Profiles/ SQL Plan Baselines to address performance issues. Importing SQL profiles from one database to another.
• Strong experience in working with various project, application and infrastructure teams, in large enterprise projects. Confirming to client compliances and SLAs.
• Managing Optimizer Statistics, SQL Access Advisor, Instance tuning using performance views
• Setting up Oracle streams- dropping, recreating, configuring /streams health check
• Installing OEM11g agents and applying 11g agent PSU5.Upgrading and repointing an OEM10g agent to OMS11g
• Oracle standby database, promoting standby DB to primary, re-establish standby database
• Refreshing databases using oracle flashback feature. scripts for Refreshing development databases databases/Monitoring the health check of databases /Cloning the reporting databases
• Oracle enterprise manager(OEM) monitoring/configuration/templates/groups
• Oracle APEX installation and configuration. Installing XDB/UTL MAIL on oracle 11g
• RMAN-configuration of backups to be stored offsite, setting up RMAN backup and recovery scripts. setting up RMAN duplicate database
• Good knowledge on Creating Oracle Service Requests SRs, Capturing trace information and providing additional information requested information and following up with Oracle CSS.
• Troubleshooting NetBackup issues
• Implemented DR recovery procedures for oracle databases
• Enforced Security administration, system monitoring by adding and removing users, configuring quotas, auditing, and analysing security problems.
• Managing and Monitoring tickets from the ticketing tool (HPSM & Clarify)
• Creating Change Management tickets and representing them in CAB meetings for approvals.
• Estimate growth of database size by detail analysis of the company's future policies and generating reports for the management to act in advance.
• Involved in all phases of database development, from needs assessment to QA/QC, design, and support.
• DPARs-Database Privileged Access Requests
• Writing shell scripts for daily routine tasks

Environment: Oracle 11g/10g/9i on Windows/Solaris/Linux/AIX, Oracle10g/11gr2 RAC, GoldenGate, VERITAS NetBackup, Oracle Enterprise Manager (OEM) Grid Control, Shell Scripting

Confidential, Atlanta, GA

Database Consultant

Responsibilities:

• Support of 24x7 Production Databases. DBA on call rotation.
• Installation and creation of 10g and 11g databases for Testing, Development and Production.Backup & Recovery of Database using RMAN
• Implemented DATA GUARD (Physical Standby) for high availability/disaster recovery purpose.
• Installation, Configuration & Administration of 10G OEM.
• Upgrade and install Sun Cluster on multi-node RAC - Upgrade 9i RAC and 10g RAC to 11g RAC.Install Dataguard for Reporting and failover for DR.
• Continuous Performance monitoring and tuning of the databases and application using OEMTuning Pack, Diagnostics Pack, STATSPACK.
• Responsibilities included data modeling, backup and recovery, performance tuning, maintaining data security, applying upgrades and patches to the database servers, storage monitoring.
• Design, development, implementation and automation via scripting and scheduling.
• Proficient in Using the 10g OEM Change Management Pack Installation
• Implementation & Administration of RAC with ASM.
• Excellent experience in handling daily database change activities.
• Making structural changes to the databases when database design changes are to be implemented.
• Migration of the database from sun Solaris to Linux. Installed and maintained Oracle 10g software On Linux systems.
• Monitoring of hot backups, exports on Linux and Windows.
• Performed Refresh of databases on Linux servers.
• Improving the Overall Response time of the SQL statements by using hints.
• Written SQL scripts to monitor Table spaces and extent growth.
• Routine Database Administration tasks such as Space Management, Upgrades, Migration, Patches, Cloning, Backup & Recovery.
• Defined backup procedures using daily hot backups and weekly cold backup.
• Storage and space management including table spaces and data files.
• Developed scripts for daily maintenance activity for analysing tables/indexes, and monitoring their growth rate. Automation of startup shutdown on all production and development databases using shell scripts
• Performance Tuning of database supporting Web based applications.
• Analysing and validating objects for block corruption.
• Troubleshooting Database errors. Helping the development teams in writing the optimized SQL statements
• Implementing and rescheduling backup jobs
• Creating best practices and publishing to team

Environment: Oracle 11g/10g/9i on Linux, Solaris, AIX 5.2, TOAD, RMAN, OEM, Shell Scripting

Confidential, Dallas, TX

Oracle DBA

Responsibilities:

• Worked on 24*7 production environment.
• Maintenance and Administration of 2000+ databases on 300+ servers in three different Data Centres.
• Segregate work requests from turnover queue and admin queue based on priority and criticality.
• Installing and configurations of Real Application Cluster
• Preparing Standard Operating Procedures for the repetitive tasks like cloning, database refresh and maintaining standard logs for patching and shift handovers.
• Check status and performance management of all databases.
• Worked on reporting database clones. Activating R-databases for Cloning
• Creating change managements (CM’s) to perform tasks like database migrations, upgrades, retirements
• Architecture and Space management for future requirements.
• Capacity management for database on needs basis.
• Used Oracle utilities like, Imports, Exports, Expdp, Impdp, TKPROF, etc.
• Tested and implemented different physical, logical Backups and Recovery methods like point in time recovery, Media recovery, full and partial recovery using export, import.
• Created shell scripts for monitoring of reporting database clones and alerts.
• Developed shell scripts for monitoring objects, tablespaces, moving archives, check file system.
• Addressing hung analyse jobs. Application troubleshooting, ORA errors, Resolving export issues.
• Build verification for production databases.
• Worked on numerous Move to production cases.
• Database activities include allocation and maintenance of Automatic Undo Management, table spaces, data files, redo log files, mirroring of redo log files across multiple disks.
• Worked on Cloning, refreshing, Creating new databases, hot & cold backups.
• Configuring RMAN on Sun Solaris.
• Applying patches for databases.
• Resolved oracle performance issues involving disk I/O, CPU usage, SQL tuning
• Resolved issues such as locking problems, rollback segs, connection problems, runaway processes
• Created databases and refreshing the data, configuring Data Guard
• Hot and Cold backup Cloning of instances.
• RMAN Auxiliary database cloning. SAN cloning.
• Reorganization of Database for performance gains.
• User account maintenance and administration of Database. Enabling User Auditing.
• Cloning, Patching, Upgrades, Monitoring and tuning for the different instances.
• Upgradation of 8.1.6 to 8.1.7.4 & 8.1.5 to 8.1.7.4 & 8.1.7.4 to 9.2.0.6 &9i to 10.1.x
• Implementing and rescheduling backup jobs
• Restoring dump files, hot backup files and archives from netbackup server.
• Migration of Sql server databases
• Creation, restoration and deletion of SQL server databases.
• Sql server Reporting database restores, build verifications
• Developed shell scripts and automated nightly jobs using cron to schedule the backups, exports, refresh test DB from production site and build development, testing staging DB’s.
• Changing SQL server configuration options.
• Creating new user account, assigning roles and responsibility using system administration.
• Automated backup of Oracle database using RMAN and performing regular system backup.
• Documenting all the upgrade and standard process issues.
• Create Schema (Tables, Indexes, views, sequences, synonyms, roles, and packages), grant roles to users.
• Monitor databases using OEM, re-organization of database tables and indexes.
• Preparing and sending status report, backup report daily by 6:00AM(EST) and 9:00AM(EST)

Environment: Oracle 11g/10g RAC, Oracle 8i/9i/10g/11g on Windows/Solaris/LinuxRMAN, PL/SQL, TOAD, SQL*PLUS, SQL Developer, Export/Import, Data Pump, Shell Scripting.

Confidential, Atlanta, GA

Oracle DBA

Responsibilities:

• Worked as Oracle DBA (10g) on HP-UX 11i v3.
• Installed and configured Oracle Database Software 10g.
• Upgraded the database from Existing Oracle 9i to Oracle 10g and Migration of database (from 9.2.0.5 to 10.2.0.1).
• Designed and implemented backup and Disaster recovery strategies with RMAN.
• Worked in advanced recovery methods like PITR. Logical backup using full/ partial export/import and Data Pump.
• Integrated the Backup status reporting for the entire database in the enterprise to enable the web reporting using Oracle SQL, PL/SQL and UNIX shell Scripting.
• Implemented stand-alone database using Oracle Data Guard feature for High availability configuration.
• Implemented database refresh with the hot backup using full export. Used EXPORT/IMPORT to do table level and full database defragmentation.
• Worked with Oracle partition tables and applied patches as per the requirements of the module. Used Oracle replication as databases for read only snapshots to maintain local copy of master tables in OLTP systems. Also done Patches for upgrading Oracle and DBMS software.
• Used SQL* loader to move data from legacy systems.
• Used PL/SQL (Stored procedures, triggers, packages), SQL* PLUS, SQL* LOADER, Explain Plan, and SQL tuning of Oracle database.
• Troubleshoot Database performance issues using Automated Workload Repository (AWR) . Tuned database for optimum performance.
• Configured Oracle Streams (Advanced Replications) and exchanged data between two databases in remote locations.

Environment: Oracle 10g/9i, Solaris, AIX 5.2, TOAD.

Confidential

Oracle DBA

Responsibilities:

• Cloning, Patching, Upgrades, Monitoring and tuning for the different instances.
• Provided solutions and execution plans for issues. Migrations, DB Sizing, Load Balancing and Performance Improvements methods.
• Configured Recovery Manager (RMAN) to implement backup methodology.
• Performed defragmentation of database objects using export and import. Reorg of databases
• Automated backup of Oracle database using Recovery Manager. Perform regular system backup.
• Monitoring and optimize the performance of the databases.
• Work as part of a team and provided 24X7 support.
• Created shell scripts for monitoring and alerts.
• Protected environment from data loss through hot & cold backup strategy
• Managed tablespaces for storage, validated objects in system tablespace for block corruption.
• SQL Tuning using Explain Plan, SQL Trace, Tkprof, Statspack reports
• Refreshing the Stage and Development Databases using RMAN.
• Working with RMAN to take the backups and restore the databases. Backup and Recovery, RMAN, knowledge of various restore and recovery scenarios
• Performance Tuning of database supporting Web based applications.
• Resolved connectivity issues for users as appropriate.
• Fulfilled on the fly new database requirements for new customers.
• Provided technical support to developers in tuning applications and connectivity issues.
• Scheduling and gathering the statistics at database level
• Performance tuning for Oracle Day-to-day maintenance and management of the several different databases in development, test, regression and production environments; proactively monitoring production environment for any exceptions/ issues.
• Have written shell scripts for automation of various database-monitoring activities.

Environment: Oracle 10g/9i/8i on Windows/Linux, Sun Solaris, RMAN