Oracle Database administrator
Resume:
Summary
Over **+ years of experience as an Oracle DBA. Experience in Data Modeling, Design, Development & Production Support. Experience in working with international teams and offshore, onshore model.
Experience in managing large OLTP/OLAP and Data warehouse databases of size multiple TB (200.) Experience widely in performance tuning, Memory Tuning and Application Tuning.
Overview
24 X 7 Production database administration, support, monitoring, proactive problem recognition and resolution of database issues.
Managed team of 20 + Oracle DBAs and 15 ETL folks to provide Production operations support.
Project transitions for mission critcal enviornments from project phase to opertions.
Led migration project of 50 + databases from Windows platform to Linux platform
HOTO review and documentation.
Implemented onshore-offshore model at various occasions and ran it smoothly.
Led Database upgrade projects from 11g to 12c/18/19c for 600 Oracle Databases.
Experience in configuration, implementation of oracle 10g/11g RAC with ASM disk on Linux servers
Worked as Oracle DBA, Technology Manager, Operations Lead.
Long term service improvements and deliverables - quarterly/yearly.
Implemented Golden Gate.
Oracle ACS contract negotiations/renewals
Oracle advanced Security to mask and secure sensitive Data – DB Vault.
Experience in upgrading databases to Oracle 10g/11g
Providing day to day support in extensive Golden gate enviornment (Target/Source- Both Sides.)
Experience in Agile methodologies.
In depth experience in Oracle database architecture, Oracle database development, Oracle database administration, database/SQL performance tuning, Data Warehouse
Led the team of 20 + Oracle DBA to have smooth operations support 24 * 7.
Experience in Oracle E-Business Suite 11i & R12
Resource management – Team Roster -On call support
Experience in process improvement, Database Design, Database creation, Oracle Server Installations/Upgrades/Patches, Space Management, Capacity Planning, Backup & Recovery, Disaster Recovery, Database Performance Tuning, Memory Tuning, Application Tuning, Security Administration, Data Warehousing, Standby Database (Data Guard), Replication, Real Application Clusters, Automatic Storage Management (ASM)
Exposure to Exadata and Big data
Experience in Multi Node RAC cluster design, administration and support.
Experience in analyzing the Database Migration requirement and providing an efficient and workable solution. Worked with Project Managers to understand different client’s requirement and provide an efficient solution keeping in mind the methodology, duration and resources.
Experience in analyzing and translating business requirements to technical requirements and architecture.
Experience in VERITAS I/O on oracle database.
Good knowledge about the technical aspects of telecom Industry and Insurance sector
Experience in Oracle 9i, Oracle 10g,11g software installation and configuration.
Experience in upgrading databases to Oracle 10g/11g.
Installation and Maintenance of Standby (Dataguard) database.
Installation, Configuration and Administration of Oracle 10g RAC.
Applied patches to Oracle Databases.
Experience in NETBACKUP on oracle database and NETBACKUP for oracle advanced BLI.
Cloned Oracle Databases for development and testing.
Proficient in SQL, PL/SQL programming and performing SQL tuning and assist developers with coding PL/SQL. Expertise in AIX shell scripting.
Experience in optimization and tuning SQL queries using SQL_TRACE, TKPROF, EXPLAIN PLAN, STATSPACK, AWR.
Experience in design and implementation of Backup & Recovery procedures.
Experience in using RMAN for backup and recovery. Experience in implementing Hot, Cold and Logical backup plans.
Customization and development of Korn shell scripts.
Experience in the management of schemas, de-fragmentation and partitioning the tables & indexes to improve the performance.
Responsible for setting and managing user accounts, granting required privileges to users.
A Self-starter with a positive attitude, willingness to learn new concepts and acceptance of challenges. Strong listening, interpersonal and analytical skills.
Result oriented, self-motivated, Team player, ability to work independently.
Education
Master’s in Science Computers Science.
Technical Overview
OperatingSystems
HP-UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 8, 9, 10, AIX 5.1, 5.2, 5.3
Red Hat Linux RHEL 2.1, 3.x, 4.x, 5.x, Linux SuSE, and Windows 95/98/ME/NT/2000/XP.
RDBMS
Oracle 19c/18c/12c/11g RAC/10g/9i MySQL, SQL Server 2000/2005
Languages
SQL, PL/SQL, UNIX, Perl Scripting, Shell Scripting, Delphi, C, C++
Tools
RMAN, OEM, SQL*Loader, SQL NET, EXP, IMP, expdp, impdp, TOAD,VB, ORADEBUG, RACDIAG, DBMS APIS, SRVCTL, CRSCTL, OCRDUMP, CDC, Data Modeling – Power Designer, Erwin, Golden Gate
Tuning Tools
TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM, Oracle Tuning Pack, Oracle Enterprise Manager, Dynatrace
Other
EMC, NetApp, Streams, Veritas NetBackup, TSM, HP Data Protector, Shareplex, NetApp filers, DataStage, Pentaho, Informatica
Professional Experience
Company : Pacific Gas & Electric (Pg & E) San Ramon, CA
Role : Operations DBA Team Lead - Oracle
Period : Jul 2016- Present
Environment : Oracle 9i/10g/11g/12c/18c/19c ASM, APEX, Toad, PL/SQL, SQL, SQL*Plus, OEM 10g/ 12c, 13c, 11g RAC, Golden Gate, Linux, DataStage, OBIEE, Dataguard broker, RMAN, Remedy, Win 2003, Informatica, Power builder, Splunk, Oracle Apex, Dynatrace
Responsibilities:
Ensure Project deliverables meets the deadline.
Managing a team of 9 Oracle DBAs onshore and 15 offshore.
Managing 1300+ databases 500 + production instances.
Ensure to meet Operations SLA 99.9%
Implemented ITSM process and problem ticket management system
Responsible for providing RCA and remediation plan for P1 incidents.
Responsible building the enviornment (Oracle 12c) and standardizing it per Pg & E standards.
Led the half yearly disaster recovery exercises – organization wide.
Looking over Oracle ACS contract as to what to exclude/include against the allocated budget.
Initiative of upgrading 600 Oracle databases to Oracle 12c and 19c
Created budget efficient onshore-offshore model.
Smooth transition of computing services from previous vendor to current vendor
Majorly involved in migrating Oracle databases from Windows OS to linux and to upgrade to oracle 12c.
Database refreshes 230+ TB with storage replication method.
Goldengate rebuilt after the whole db refresh
Goldengate Support for 12 Goldengate processes for mission critical database
TDE encryption implemented for various oracle 12c databases.
Make sure warm handoff between onshore/offshore.
Responsible for stabilizing the environment and keep it healthy and up and running and transition to maintenance team.
Installed Oracle Apex in standalone mode.
Have migrated 50 + oracle databases from windows platform to linux platform and have upgraded to Oracle 12c.
Incident management, remedy ticketing system
Responsible for preparing documentation including – ADRP, On call cheat sheet, Operations run book, Operations Checklist.
Responsible for Disaster recovery exercises and fail over to DR site and forth.
Responsible for handling escalation from cross functional team/project Managers, providing them required info when/if needed.
Performance tuning, working with application team.
Responsible for support, monitoring, proactive problem recognition and resolution of database issues.
Conducting sizing & capacity planning for Oracle databases.
Implementation plan review and suggesting changes per standard/process
Applied PSU patches, upgraded OPatch.
Group Admin of OEM ( Oracle Enterprise Manager 12c) for whole group.
Performed OMS 2nd installation.
TFA installation on all production databases.
Performance diagnosis, CPU usage, Top, NMON, NETSAT, iostat, SAR
Discovering Databases in OEM 12c/13c and configuring them and listeners.
Perform SQL tuning and assist developers with coding PL/SQL.
Monitor and tune Oracle database for optimum performance.
Worked as a fire fighter and resolved long time pending performance issues.
Management of schemas, objects partitioning the tables & indexes.
Automation of data load using Korn shell scripting.
Providing guidance for Golden Gate on source side.
Implementing Golden Gate on Dev and QA boxes.
Responsible for setting and managing user accounts, granting required privileges to users.
Perform other regular DBA activities including space management and performance monitoring.
Responsible for deploying the code in the production and have been taking care of most of the releases.
Effective troubleshooting of Performance tuning problems in Oracle database.
Continuous monitoring of database performance during peak and non-peak loads using AWR.
Company : Bank of the West San Ramon, CA
Role : Co-ordinator/Sr. Oracle DBA
Period : Jun 2015- May 2016
Environment : Oracle 10g/11g, ASM/XtremeIO, Hyperion, APEX, Toad, PL/SQL, SQL, SQL*Plus, OEM 10g/ 12c, 11g RAC, Golden Gate, VPD, Linux, Pentaho, Ignite, Informatica, OBIEE, Cherwell, Dataguard
Responsibilities:
Ensuring Incident Management- tickets are below threshold and responding within the SLA.
Responsible for stabilizing the enviornment and keep it healthy and up and running.
Responsible for meeting the SLA’s, meeting with delivery team and understanding the project requirement and involved in OLA and documentation.
Responsible for CR process within the team – ensuring every change is getting captured and been tracked via CR process.
Responsible for handling escalation from cross functional team/project Managers, providing them required info when/if needed.
Escalation point of contact for several source systems and articulating issues and triaging.
Creating/publishing guidelines.
Standard documentation.
Responsible for support, monitoring, proactive problem recognition and resolution of database issues.
POC exposure for BigData and Exadata.
Undergone DB Maestro training
Undergone EMC snap sync training
Conducting sizing & capacity planning for Oracle databases.
Implementation plan review and suggesting changes per standard/process
Implement Database Partitioning strategies.
Applied PSU patches, upgraded OPatch.
Golden Gate production Support
Converted single database instances into oracle RAC for high availability.
Converted 2 nodes RAC enviornment into 5 node RAC.
Group Admin of OEM ( Oracle Enterprise Manager 12c) for whole group.
Performance diagnosis, CPU usage, Top,NMON, NETSAT, iostat, SAR
Using ignite other than OEM 12c for extensive performance diagonis and metrics
Applied security patches, proactive monitoring of databases and applications.
Discovering Databases in OEM 12c and configuring them and listeners.
Perform SQL tuning and assist developers with coding PL/SQL.
Monitor and tune Oracle database for optimum performance.
Oracle Realms – Federal, HR – to secure sensitive data.
Standardized gather stats process.
Involved in informatica upgrade project and completed successfully.
POC of VPD row /column level security
Worked as a fire fighter and resolved long time pending performance issues.
Rebuilding the Materialized views and make sure that none of the materliazed view is in the stale mode.
Monitoring database through OEM/Ignite.
Creating/adding/dropping VPD policies.
Replication using GoldenGate, materialized views
Database Vault – securtiy realms to protect and masking sensitive data.
Customization and development of Unix shell scripts.
Management of schemas, objects partitioning the tables & indexes.
Automation of data load using Korn shell scripting.
Providing guidance for Golden Gate on source side.
Impementing Golden Gate in Dev and QA boxes.
Responsible for setting and managing user accounts, granting required privileges to users.
Perform other regular DBA activities including space management and performance monitoring.
Responsible for deploying the code in the production and have been taking care of most of the releases.
Trouble shooting Golden Gate replication failures.
Limiting the user management and sensitive data access via – Oracle Advanced security tools – Oracle Database Vault – Data Masking.
VPD configuration is in progress for row level encryption
Effective troubleshooting of Performance tuning problems in Oracle database.
Continuous monitoring of database performance during peak and non-peak loads using AWR.
Company : NetApp, Sunnyvale, CA
Role : Operations Technology Manager/Lead - Oracle
Period : Jan 2010- June 2015
Environment : Oracle 10g/11g, APEX, EBS 11i and R12,AIX 5.3, AIX 6.1, SQL Server 2012 Toad, PL/SQL, SQL, SQL*Plus, OEM 10g/ 12c, 11g RAC, Golden Gate, Linux, Pentaho, Datastage, OBIEE
Responsibilities:
Managing Datawarehouse Operations team of à 7 DBA’s, 8 ETL /Pentaho team members and 8 MDM team members.
Responsible for meeting the SLA’s, meeting with delivery team and understanding the project requirement and involved in OLA and documentation.
Responsible for incident management and routing problem tickets to the right group and providing directions.
Responsible for handling escalation from product vendor (Oracle) and contacting them, providing them required info when/if needed.
Escalation point of contact for several source systems and articulating issues and triaging.
24 X 7 on call support, production database administration, support, monitoring, proactive problem recognition and resolution of database issues.
Applied Agile method to better adapt to the business requirements changes; quickly designed and coded/implemented the following applications with scrum teams
Conducting sizing & capacity planning for Oracle databases.
Installed GoldenGate ( Both Target and Source side) and providing support.
Installed OEM 12c and configured targets in OEM.
Implement Database Partitioning strategies.
Applied PSU patches, upgraded OPatch.
Maintain and supported MySQL5.5 databases.
Group Admin of OEM ( Oracle Enterprise Manager) for whole group.
Performance diagnosis, CPU usage, NMON, NETSAT, ISOSAT, SAR
Using Axibase other than OEM for extensive performance diagonis and metrics
Applied security patches, proactive monitoring of databases and applications.
Discovering Databases in OEM and configuring them and listeners.
Perform SQL tuning and assist developers with coding PL/SQL.
Monitor and tune Oracle database for optimum performance.
Oracle Realms – Federal, HR – to secure sensitive data.
Performance tuning in MySQL application instances.
Responsible for optimizing the queries and application tuning.
Made scripts to compare the init files and other health check reports.
Rebuilding the Materialized views and make sure that none of the materliazed view is in the stale mode.
Installed 4 node RAC on Linux. Configured cluster database in OEM.
Implemented Oracle Golden Gate between SAP and eBI.
Provide day to day support for GoldenGate (Target/Source – both ways)
Monitoring database through OEM.
Database Vault – securtiy realms to protect and mask sensitive data.
Customization and development of Unix shell scripts.
Management of schemas, objects partitioning the tables & indexes.
Automation of data load using Korn shell scripting.
Responsible for setting and managing user accounts, granting required privileges to users.
Checking the snap mirror status at regular intervals.
Managing SOX controls for the process.
Perform other regular DBA activities including space management and performance monitoring.
Responsible for deploying the code in the production and have been taking care of most of the releases.
Limiting the user management and sensitive data access via – Oracle Advanced security tools – Oracle Database Vault – Data Masking.
Effective troubleshooting of Performance tuning problems in Oracle database.
Continuous monitoring of database performance during peak and non-peak loads using AWR.
Infrastructure Strategies:
Database upgrade from oracle 10g R2 to Oracle 11g R2 also from Oracle 11.2.0.2 to Oracle 11.2.0.3.
Designed and Developed Flexplore database environment to off load PROD database for ADHOC reporting.
Involved in implementing Database vault to secure sensitive data.
Involved in implementing 4 node RAC (11gR2) with Oracle Golden Gate for Real time Reporting data from SAP, ERP and EBI systems.
Installed Oracle Golden Gate in 4 node RAC environment.
Upgraded GoldenGate to 11.2.1.0.1.
Implemented NetApp Snap Mirror strategies for various activities like DB backup, Cloning & Standby Database.
Completed POC of implementing Oracle Timesten caching on Data warehouse reporting database.
Implemented Oracle Result cache.
Design Database storage Layout for all new implementations.
Evaluating Oracle Patches, testing patches.
Provide L3/L4 support for Operational DBA Team.
Develop POC on new technologies & work with other architect teams to implement solutions.
Develop Documentation, best practices for Database technologies and providing necessary trainings to operational DBA’s on new technologies like RAC, Golden Gate, performance tuning & best practices.
Company : Knowledge Solutions, New Jersey
Role : SR Oracle DBA.
Period : Feb 2009- Jan 2010
Environment : Oracle 9i, 10g/11g RAC, Sun Solaris 10, MySQL4.1, RHEL 4.x, Toad, PL/SQL, SQL, SQL*Plus, AIX, Streams, Linux, Windows XP
Responsibilities:
24 X 7 Production database administration, support, monitoring, proactive problem recognition and resolution of database issues.
Involved in process improvement, Oracle Server Installations/Upgrades/Patches, Space Management, Capacity Planning, Backup & Recovery, Disaster Recovery, Database Performance Tuning, Memory Tuning, Application Tuning, Security Administration, Data Warehousing, Data Guard, Oracle Advanced Replication, Real Application Clusters, Oracle Standby.
Utilized oracle streams to capture, propagate and apply the transfer of data, transactions and events within managed databases.
Performed database cloning to setup test and development database.
Installation and Maintenance of Stand by database.
Experience in Disaster Recovery Drills, documented database and application validation steps
Conducting sizing & capacity planning for Oracle databases.
Upgrading production and development databases to Oracle 10g/11g.
Maintain and supported databases MySQL 4.1.
Experience in implementing Asynchronous oracle streams Change data capture
Installation, Configuration and Administration of Oracle 10g RAC.
Applied RDBMS patches, security patches, proactive monitoring of databases and applications.
Perform SQL tuning and assist developers with coding PL/SQL.
Responsible for optimizing the queries and application tuning.
Provided support to Application Database Administrators in designing the database.
Installed and Implemented Backup & Recovery procedures.
Used RMAN for backup and recovery. Performed backup validations using RMAN.
Implemented Hot, Cold and Logical backup plans.
Customization and development of Unix shell scripts.
Management of schemas, objects partitioning the tables & indexes.
Automation of data load using Korn shell scripting and SQL*Loader.
Responsible for setting and managing user accounts, Granting required privileges to users.
Defining and Implementation of backup and recovery strategies
Perform other regular DBA activities including space management and performance monitoring.
Effective troubleshooting of Performance tuning problems in Oracle database.
Optimization and tuning SQL queries using TRACE FILE, TKPROF, EXPLAIN PLAN.
Continuous monitoring of database performance during peak and non-peak loads using STATSPACK.
Company : SiriusXM, Washington DC .
Role : Oracle DBA.
Period : Jan 2008- Jan 2009
Environment : Oracle 9i, 10g/11g RAC, Solaris 10, SQL Server 2008, RHEL 4.x, Toad, PL/SQL, SQL, SQL*Plus, AIX, Windows XP, HP-UX 10.0
Responsibilities:
24 X 7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
Installation, Configuration and Administration of Oracle 10g RAC.
Migration of oracle databases from windows to Linux and applying patches for Database using opatch.pl Perl script.
Used Quest Shareplex for replicating databases.
Involved in developer Environment Setup, Support, Cloning and Refreshes. Performed database cloning to setup test and development database
Performed and implemented Hot, Cold and Logical backup plans.
Involved in Installation, Configuration and Maintenance of 9i to10g as and when needed.
Proactive database monitoring using Stats pack, Explain plan and AWR report.
Upgrading development and production databases to Oracle 10g.
Involved in applying patches to Oracle Databases and Oracle Applications.
Cloned/Refreshed Oracle Databases for development and testing.
Experience in implementing Asynchronous oracle streams Change data capture
Responsible for optimizing the queries and application tuning.
Conducting sizing & capacity planning for Oracle databases and management of schemas, objects partitioning the tables & indexes
Perform SQL tuning and assist developers with coding.
Provided support to Application Database Administrators in designing the database.
Installed and Implemented Backup & Recovery procedures.
Used RMAN for backup and recovery. Performed backup validations using RMAN.
Applied High priority, security patches downloaded from Metalink
Conducted multiple “dry runs” (test runs) to gather timings for production upgrades.
Monitored regularly whether primary and standby databases are in sync and clearing the backed up archive log files after confirming that they are applied on the standby database.
Monitored the database objects growth, managing the extents growth and de-fragmenting the objects, which are running out of maximum extents. Monitoring the excessive fragmentation of table spaces and taking remedial steps.
Company : Steria
Role : Oracle DBA,
Period : Nov 2005 – Nov 2007.
Environment : Oracle 9i, 10g RAC, Solaris 2.8,10, RHEL 4.x Toad, PL/SQL, SQL, SQL*Plus
Responsibilities:
24 X 7 on call–support for both production and development databases with on-call pager.
Refresh/Cloning of Database and applications for development, testing.
Installation, Configuration and Administration of Oracle 10g RAC.
Performance Tuning for optimized results using tools like Explain Plan, SQL*Trace,
TKPROF and STATSPACK
Involved in taking periodic Backup of the Database and the software using RMAN and VERITAS Net backup
Set up of Standby database for faster disaster recovery and Data guard setup for high availability.
Implemented Oracle Data ware house tool CDC (Change Data Capture).
Involved in implementing oracle retail management.
Logical, physical data modeling, implementation and database administration.
Worked with team in successful installation of 10g RAC on 2 nodes.
Performed SQL tuning and assist developers with coding PL/SQL.
Creating and Managing Table spaces with different block-sizes to prevent row chaining.
Migration of Database and applying patches whenever required
Installed, Configured, Upgraded & Applied patches for Prod & Dev Servers.
Installed and Implemented Backup & Recovery procedures.
Designing appropriate Backup / Recovery Policies for databases.
Creating table spaces, tables, and users for custom applications.
Creating and dropping of users, granting and revoking permissions to users/roles as and when required.
Ensuring proper online and offline backup. Periodical reading and checking of backups taken.
Monitoring Growth of tables and undertaking necessary re-organization of database as and when required
Capacity Planning & Benchmarking using analysis from STATSPACK reports
Developed shell scripts to automate the processes and to proactively monitor the database.
Resolve various application failures due to data entry errors or system errors.
Involved in identifying problems and implementing corrective actions.
Company : ICICI Bank
Role : Oracle DBA
Period : Apr 2004- Oct 2005.
Environment: PL/SQL, SQL, SQL*Plus, SQL Server 2005, Oracle 9i, Oracle 10g, HP UNIX, AIX, Linux (RHEL), Windows XP
Responsibilities:
24 X 7 Production Oracle database support and administration
Involved in Database migration from Oracle9i to Oracle 10g.
Backup and Recovery using RMAN with external tape backup system.
Created Recovery Catalog to store multiple database backups.
Detect corrupted blocks by using DBVERIFY utility.
Oracle Database and SQL tuning using SQL TRACE, STATSPACK, EXPLAIN PLAN, TKPROF etc…
Partitioning tables by determining the suitable methodology to improve performance and manageability
Installation of Oracle RDBMS on HP and Solaris boxes
Day to day operations of various databases at the client sites
Oracle SGA tuning, change initialization parameters for Function based indexes
SQL Tuning using Explain Plan
Work with Unix Administrator to allocate disk space, create volume groups and mount points for database
Creating users, manage security roles and privileges
Hot backups, Export/Import, RMAN
Use glance on HP to check system performance
Metalink support research
Use of Logminer utility.
Daily refresh of Finacle Database & Management.
Involved in RAC administration including 10g Database cloning, tuning, patching and monitoring concurrent manager processing etc.
Cloned/Refreshed Database environments to create patch, test, development and QA environments.
Other activities like applying RDBMS patches, security patches, proactive monitoring of databases and applications.
Cloned environments to create patch test, development and QA environments.
Created scripts to monitor and manage the databases.
Recreated backup plans and scripts.
Performed hot, cold, tablespace level backups.
Applied High priority, security patches downloaded from Metalink
Conducted multiple test runs to gather timings for production upgrades
Implemented database Auditing, data security and Remediate high-risk violation in production environment.
Participated in Disaster Recovery Drills, documented database and application validation steps.
Other activities like applying RDBMS patches, security patches, proactive monitoring of databases.
Company : Bharti Cellular Ltd.
Role : Oracle DBA
Period : Nov 2003-Mar 2004
Environment: PL/SQL, SQL, SQL*Plus, Oracle 9i, Oracle 10g, HP UNIX, AIX, Linux (RHEL), Windows XP
Responsibilities:
Oracle Patch management on production servers.
Installation, configuration and maintenance of 10g,9i, 8i production databases on HP-UX
Designing, Planning and configuring production databases for High Availability (24*7)
Designing Backup and Recovery strategy for production databases.
Performance and Tuning of production databases
Performance and Tuning of applications.
Installation of Oracle 10g/9i/8i
Creating of database according to specification required by the application
Administration and Monitoring of all databases.
Preparing the database for billing on specific dates.
Creating Tablespaces, tables, mapping views etc during bill cycles and end of month.
Space management.
Analyzing tables and indexes.
Rebuilding indexes.
Backup of databases.
Tuning of database using STATSPACK, SQL TRACE files, TKPROF utilities.
Troubleshoot the problems related to databases.
Maintenance of standby database.
Company : CRC (Computer Research Center)
Role : Jr Oracle DBA
Period : April 2000-Sep 2003
Environment: PL/SQL, SQL, SQL*Plus, Oracle 8.0, 9i, HP UNIX, Linux (RHEL)
Responsibilities:
24 X 7 Oracle database support and administration
Involved in Database migration
Backup and Recovery.
Created Recovery Catalog to store multiple database backups.
Oracle Database and SQL tuning using SQL TRACE, STATSPACK, EXPLAIN PLAN, TKPROF etc…
Partitioning tables by determining the suitable methodology to improve performance and manageability
Day to day operations of various databases at the client sites
Oracle SGA tuning, change initialization parameters for Function based indexes
SQL Tuning using Explain Plan
Work with Unix Administrator to allocate disk space, create volume groups and mount points for database
Creating users, manage security roles and privileges
Hot backups, Export/Import
Metalink support research
Cloned/Refreshed Database environments to create patch, test, development and QA environments.
Other activities like applying RDBMS patches, security patches, proactive monitoring of databases and applications.
Created scripts to monitor and manage the databases.
Recreated backup plans and scripts.
Performed hot, cold, tablespace level backups.
Applied High priority, security patches downloaded from Metalink
Conducted multiple test runs to gather timings for production upgrades
Implemented database Auditing.
Participated in Disaster Recovery Drills, documented database and application validation steps.
Other activities like applying RDBMS patches, security patches, proactive monitoring of databases.
Contact this candidate