| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidate RAJ
ORACLE DATABASE ADMINISTRATOR
Over 8+ years of experience in Oracle Database Administration encompassing Installation,
Configuration, Patch Installation, Migration, Upgrades, Backup and Recovery,
Cloning, Replication, Database Security, Memory Management, Data Modelling,
Performance Monitoring and Tuning, RAC, Data Guard, Grid Control and Enterprise
Manager.
Installation and administration of Oracle 12c/11g/10g/9i on OEL, RHEL, Windows, HP-Unix, IBM-
AIX and Sun Solaris in OLTP and OLAP environment.
Performed Migration and Upgrade of databases to 11g and 10g
Up gradation of databases applying patches, patch sets and critical patch updates.
As a DBA we use to give permissions to access the LDAP databases.
Installation and configuration of Oracle Server 11g RAC with ASM on multi node systems, 11g, 10g
and 9i in different operating systems for OLTP environment on Very Large Databases(VLDB).
Experience on Oracle 12c/11g/ASM/RAC and up gradation of standalone databases to 11g RAC
environment and 12c standalone environment
Installed and Configured Enterprise manager OEM12C and 11g.
Configuration of Automatic Storage Management (ASM)
Configuration and Management of Data Guard on RHEL, OEL and Windows.
Experience with Data guard broker configuration and switchover.
Extensive experience with Database Cloning and Refreshing pre-prod/dev databases with prod/pre-prod
databases.
Extensive experience in installation and implementing OEM and TOAD and setup of Oracle Grid
Control
Experience on Data Replication using Snapshot, Materialized views, import/export.
Regular database synchronization for test database environments through automation.
Installation and configuration of RMAN with and without Recovery Catalog.
Design and implementation of Backup and Recovery strategies (both cold and hot backups) and
performing periodical backup, restoration and recovery using RMAN(full and incremental)
Testing and implementing different physical and logical backup and recovery methods including point in
time, media recovery, full/partial, and data pump export/import.
Migration of the databases from one platform to another platform.
Experience of Oracle Golden Gate installation, configuration and troubleshooting Golden Gate issues.
Knowledgeable on Oracle Streams.
Extensive experience using SQL* Loader, External Tables and Oracle Application Express for data
loading.
Knowledge on Exadata Smart Scan technology which improves query performance by intensive query
processing and data mining scoring to scalable intelligent storage servers.
Worked on Oracle Exadata X3-2, SuperCluster M6-32 Servers.
Knowledge and working experience of working on Oracle 12c Databases.
Detecting and diagnosing production system performance problem by analyzing STATSPACK reports,
Oracle trace and log files, AWR, ADDM, analyzing SQL statements, measuring system and database
activity, Querying Oracle dynamic performance views.
Monitoring and Optimization of database performance through database tuning, system tuning and
application tuning.
Experience in SQL Tuning, Optimization, cost based optimization and Hints
Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN,
TKPROF, STATSPACK, and SQL TRACE.
Proficient in INDEX REBUILDING and INDEX TUNING
Experience on Oracle monitoring tools including Oracle Application Server monitoring and Oracle Linux
monitoring using NMON and TOP commands.
Experience working with Database Resource Manager
Working experience in creating materialized views.
Experience using Erwin as a Data Modelling tool & Designing the ETL processes
24*7 on-call production database support and maintenance including remote database support
Assisting in implementation of change control process in production.
Ability to work in a team as well as to take individual responsibility.
TECHNICAL SKILLS:
Operating Red Hat Linux RHEL 2.1, 3.x, 4.x ,5.x, 6.x HP-UX 10.x, 11.x, Sun Solaris
Systems 9.0/10.0, AIX 5.1, 5.2 and Windows 98/NT/2000/2003.
Data Bases Oracle 12c/11gRAC/10gRAC/10g/9i, EXADATA
Languages SQL, PL/SQL, C, C++, UNIX Shell Scripting, JAVA
Tools/Utilities RAC, OEM Grid Control, SQL Navigator, SQL* Loader, ASM, SQL Server,
Export/Import, RMAN, SQL Developer, DB Artisan , TOAD, Patch
Management, SQLNET, ODBC, Export/Import, Data pump, Data Guard,
VERITAS Net Backup, AVAMAR ,VMware, Log miner, Crontab, Oracle
Golden Gate, Streams
Tuning Tools TKPROF, SQLtexplain, EXPLAIN PLAN, STATSPACK, ADDM, AWR
Terminal Putty, Telnet, FTP
Emulation
PROFESSIONAL EXPERIENCE:
Pepsico/HCL America Inc., Frisco, TX July 2016
Till Date
Role: Sr. Oracle DBA
Responsibilities:
Upgraded databases from 11g to 12c in multiple platforms like Suse Linux, HPUX Itanium.
Resolved invalid components after the upgradation of database.
Resolved backup issues reported in the DBR report that includes both netbackup/tape and disk
related backups.
Applied patch set updates to database and grid homes.
Daily activity includes resolving the SRs raised through service manager tool and pro-active
involvement of any P-1 and P-2 incidents.
Maintained Datagaurd standby databases across all the environments.
Migrated databases in RAC environment by setting up RAC to standalone physical standby and
activating the standby during the cutover window.
Resolved db link issues for the migrated databases.
Worked closely with the application teams to tune the sql statements and achieve the desired runtime.
Setting up the OID entries for all the databases to accomplish the application connectivity.
Environment: Oracle 9i/10g/11g/11gR2/12c, RAC EXADATA, AIX, SOLARIS, HP-UX, Redhat
Linux, OEM 12c, RMAN, NETBACKUP, OID
Este Lauder Companies, Melville, NY Oct 2015 Jun
2016
Role: Sr. Oracle DBA
Responsibilities:
Database Technologies like Oracle Data Guard /fast start failover, Oracle Internet Directory, Oracle
Enterprise Manager, Oracle RMAN were implemented.
Experienced in switching primary database to standby and standby to primary during regular
maintenances of catalog databases and DR databases.
Performed switchover and failover in a data guard environment.
Critical applications migrated included SAP etc.
Migrated approx. 500 TB of actual Database storage with Near Zero downtime approach.
Migrated databases using cross platform transportable tablespaces method.
Database migration between physical to physical and physical to VMware virtual machines.
Implemented a new 11.2.0.4 feature - Reduce Transportable Tablespace Downtime using Cross
Platform Incremental Backup.
Successful Disaster Recovery implementation & testing.
Upgraded databases from 11g to 12c and configured standby.
Data migration from old systems to Oracle EXADATA (V2/X3-2) using different methods
e.g. EXPDP/IMPDP, Transport Tablespaces and etc.
Upgrading Oracle Database from 11.2.0.2.0 to 11.2.0.3.0 in Oracle EXADATA.
Ensuring SLA timings by taking and restoring backups from PROD to TEST EXADATA.
Successful implementation & testing of Unique Rolling Maintenance / High Availability design.
Successful Performance, SAP Functional & Integration testing with the newly migrated systems, inside
Isolated Landing Zone.
RMAN / DDBOOST & (EMC Time Finder Clone) were implemented, as the SAP Oracle database
backup methodologies.
Control M jobs along with Nimsoft agents were deployed for automated SAP Oracle DB monitoring
capabilities.
Oracle Data Guard was tested with SAP application tier to provide Rolling Maintenance / Automated HA
failover capabilities.
Worked in BI/BW/PORTAL/SOLOMAN/PI environment like upgrades and check sap marketplaces for
downloads from sap support.
Configured Physical Standby (Data Guard) databases for the Production Databases.
Worked on SAP BRTools Like BRCONNECT,BRRESTORE,BRSPACE,BRARCHIVE
Extensively performed development database refreshes using data pump and RMAN.
Configuring and Monitoring RMAN backups and performing recoveries.
Performed MySQL database refreshes using phpMyAdmin tool.
Implemented bi-directional Golden Gate replication between production and lower environments.
Refresh of the development and Test databases using Golden Gate re-instantiation with datapump
export as an initial load.
Handled new Projects for stabilizing environment like OEM 12 Cloud Control Build with customized
templates and 11G2 RAC Builds.
Creating RAC database with ASM and Data guard configuration which includes primary and standby
database creation
Efficiently managing backups and recovery through RMAN which includes RMAN duplication, refresh
and cloning in Standalone, RAC and data guard Environment.
Troubleshooting node eviction issues and applying CRS# bundle patch using Opatch utility for bug
fixing.
Troubleshooting RAC databases & ASM issues, network & database connectivity issues and Oracle
connectivity issues.
Performed Capacity Planning, Undo segments and Health check reviews in RAC.
Upgraded Oracle Applications 11i e-business suite to R12 for test, development environments.
Performed cloning of R12 Oracle Apps E-Business Suite which includes cloning of both database tier and
application tier.
Involved in Providing KT to team members.
Environment: Oracle 11g/11gR2/12c, RAC EXADATA, HP-UX, Redhat Linux, OEL, RMAN,
DDBOOST, MySQL, Oracle EBS R12
PEPSICO INC, Plano, TX Jan 2015 Sep
2015
Role: Sr. Oracle DBA
Responsibilities:
Support and duties related to ECC, BI, XI and Portal systems and OEM 12c on Oracle & Hana
Platform.
Worked on Brtools integrated with netbackup, HP Data Protector Tools and oracle enterprise manager,
oracle advanced compression.
Applied SBP latest oracle patches from SAP recommended June 2014.
Implementation of Oracle Internet Directory, Secured Oracle profiles / Dormant account locking, World
writable remediation, International security remediation & Guardium security policies / scans for
improved DB security practices.
RMAN / Netback up& Business Continuance Volumes ( EMC Time Finder Clone ) were implemented ,
as the SAP Oracle database backup methodologies.
Oracle Enterprise Manager 12C was deployed for automated SAP Oracle DB monitoring capabilities.
Oracle Data Guard Fast Start Failover was tested with SAP application tier to provide Rolling
Maintenance / Automated HA failover capabilities.
Upgraded OEM from 11g to 12c.
Experience in maintaining/working on databases ranging from 5TB to 20TB size large databases.
Installed, Configured Golden Gate and Migrated Oracle databases from hp-ux to linux environment
utilizing Golden Gate.
Implemented Bi-Directional replication in golden gate.
Experience in setting up Golden Gate (11g and 12c) Configuration, Manage, Checkups and Troubleshoot.
Configured Extract and Replicate pumps for Golden gate replication. Troubleshooting issues in
GOLDENGATE Environment using LOGDUMP.
Implemented performance parameters in replicat process and also involved in Splitting replicats
which improved performance of Golden Gate environment.
All the SAP databases were moved from physical to VMware virtual machines.
Performed ASM disk remediation i.e., moving the underlined storage from vmdk to RDM disks.
Implemented Enterprise Manager Grid Control 12c to provide monitoring and management of the Oracle
database estate.
Performed a zero downtime cross platform database migrations using Oracle Golden Gate.
Configured and maintained Physical Standby databases for all Production Databases.
Configured RMAN backups and performed recoveries. Also worked on BCV snapshot technology.
RMAN cloning of multi TB databases from tape to development.
Installation of Oracle EBS R12 on RHEL platform both 12 and 12.2 versions
Patched Oracle Apps EBS R12 using ADPATCH utility.
Environnent: Oracle 9i, 10g/11g/11gR2/12c RAC, HP-UX, RHEL, OEL, GoldenGate, Oracle EBS
R12
FedEx Corp., Colorado Springs, CO Jan 2014- Dec
2014 Role: Sr. Oracle DBA
Responsibilities:
Installation, Configuration and administration of Oracle 11g/10g database on Red Hat Enterprise Linux
(RHEL) and also Up gradation from Oracle 10g to 11g.
Configured 3-node Real Application Cluster (RAC) and monitored RAC instance with Oracle
Enterprise Manager Grid Control.
Installed and Configured Oracle Enterprise Manager Grid Control 11g.
Up gradation of Grid Infrastructure and Oracle Databases from 11.2.0.1 to 11.2.0.3 on 3-node RAC
environment.
Configured and Implemented Oracle 11g ACTIVE DATA GAURD for Database Disaster Recovery by
using DATA GUARD (DGMGRL) broker
Involved in configuration files like Listener.ora, Tnsname.ora for Client-Server environment using
network configuration assistant.
Configured Physical Standby databases and logical Standby database for ACTIVE DATA GUARD.
Worked on X3-2 machine where backups, restores are run across all database instances in Exadata system
with two or four RMAN channels allocated per instance.
Scheduling the backups for the database using EM 12C cloud control.
Migration of database from one server to another server.
Implemented Data guard, creating physical standby databases in 10g and 11g RAC environment for
production database.
Installed, Configured and Administered Golden gate.
Configured parameters for the Bi-directional replication.
Performed conversion Non RAC single instance to Real Application Cluster (RAC) database instances.
Using Oracle Data Pump utility making faster exports/imports on large databases and saving lot of time.
Performed day to day administrative tasks by analyzing the database like checking for failed processors,
verifying the query for particular issues and validating disk space.
Develop and enforce both database and OS-level security policies for data protection. Administer all
databases in the areas of maintenance, tuning, performance, and troubleshooting.
Efficient in using the Oracle Tools like OEM, SQL* Plus, SQL* Loader, TKPROF, LOGMINER,
STATSPACK, SQL*Net, IMPORT/EXPORT, and RMAN.
Developed Scripts for transferring data from production server to testing/development servers.
Shell scripting and PL/SQL programming to resolve business problems of various natures.
Managing databases on multiple servers.
Environment: Oracle 11g, 10g, Linux 4/5, OEM, DBUA, RMAN, Golden Gate, Grid, RAC, ASM,
Exadata X2-2, Data Guard, SQL* LOADER, AWR, ADDM, ASH, TTS, Data Pumps, Exports/ Imports.
Nintendo, Seattle, Washington Feb 2012 Dec
2013
Role: Sr. ORACLE DBA
Responsibilities:
Installed, configured and maintained databases on high availability systems like Data Guard and
Real Application Cluster environments
Involved in fresh installation of 11.2.0.3 RAC on Automatic storage Management and created
databases in RAC environment
Installed OEM repository database, 12c agents on hosts and discovered targets and created new
Groups, Templates, Incident Rule sets in OEM 12c
Configured Physical standby, Snapshot Standby and Active data-guard and performed
Troubleshooting data guard environment
Performed various activities on ASM, including partitioning, managing raid levels and performed
proactive capacity planning.
Up-gradation / MIGRATION of dev/test/prod databases from 10g to 11g
Migrated applications from Unix to Linux using golden gate with minimum down time and resolved
issues in golden-gate
Installed golden gate 11g version and upgraded golden gate from 10 to 11.1 on AIX
Applied patch set and interim patches whenever required to make the database software up to date
Involved in measuring smart scan, storage index and measuring offload statistics for individual SQL
Cursors on Exadata
used Flashback mechanism for logical corruption of databases
Installed and Implemented Backup & Recovery procedures, Implement Hot, Cold and Logical
backup plans
Performed tasks like Database Sizing, Table space Management and Rollback Tablespace
Management, Transaction Management and Security Administration
cloned databases for development and test environments using RMAN
Taking periodic Backup of the Database and the software using RMAN and supporting VERITAS
Net-backup Team
Creation of Users and granting them the required Roles and Privileges accordingly and Involvement in
space management, rectification of lock problems, managed quotas
Managed Oracle space, performed Oracle table space management tasks, maintained tables,
database objects and Rebuilding indexes for better performance of Oracle database.
Worked extensively in Performance Tuning at various levels including instance tuning, Query tuning,
Database performance tuning
Used oracle tools like AWR, ADDM, Advisories, TKPROF, EXPLAIN PLAN for the Better database
performance
Extensive Performance Tuning, Memory (SGA) Tuning, RAID, RAW Devices
Involved in Writing SQL scripts to monitor table space and extent growth
Familiar with ORA-600 error & Involved with this ERROR
Provided support to Application Database Administrators in designing the database
Tested many scenarios in RAC, Dataguard and RMAN environment
prepared documentation for maintenance, knowledge transfer and Mentoring level 2 DBA's
24 X 7 Production database administration, support and monitoring to ensure Proactive problem
recognition and resolution of database issues
Environment: Oracle 10g/11gR2, Sun Solaris 5.9, RHEL 5.x, IBM-AIX 6.1, OEL 6.3, OEM 11g/12C,
EXADATA, RAC 10g/11g, ASM, Data guard 10g/11g, Data pumps, RMAN, TDE, AWR, ADDM, ASH,
TTS.
Morgan Stanley, New York city, New York Mar 2010 - Jan 2012
Role: Oracle DBA
Responsibilities:
Installation, configuration and maintenance of Oracle 11g databases
Estimated growth of database size by detail analysis of the company's future policies and generating
reports for the management to act in advance.
Performed up-gradation of grid infrastructure from 11.2.0.2 to 11.2.0.3
Performed health checks of RAC instances using Crsctl and Srvctl utility
Monitoring and managing of Oracle instances using Enterprise Manager Grid Control (OEM grid) 10g /11g
Configured pfile, Listener and Net service names manually for production and physical standby databases in
Data-guard environment
Migrated databases from File system to ASM & troubleshooting issues in ASM 11g
Installed Golden Gate for replication between cross platforms
Configured parameters files for extracts, replicat's and
Applied patches on standalone servers using Opatch utility
Performed Migration of databases from 10g Unix to 11g on Linux
Implemented data transfer using Data Pumps and Export/Import utilities
Registered databases in catalog server and Performed Cloning of databases using RMAN from production to test
and dev. Environment
Involved in scheduling incremental, cumulative and full backups and configured retention policy using RMAN
Configured listener for external procedure calls, Worked closely with ETL applications team
Performed daily maintenance tasks like space management, rectified locking problems, managed quotas
configured network components like TNSNAMES, Names Server, Connection Manager, for easy and effective
management of Oracle networking
Extensively used AWR, ADDM and EXPLAIN PLAN for Generating reports
Develop and enforce both database and OS-level security policies for data protection.
Involved in Setup the Oracle Wallet for Encryption Functions and Expertise in protecting the Oracle wallet with
ACFS access controls
Created Tables That Contain Encrypted Columns and Oracle Wallet Management for Transparent Data
Encryption
Involved in administration of all databases in the areas of maintenance, tuning, performance, and
troubleshooting and debugging SQL/PL SQL involved in Application development
Efficient in using the Oracle Tools like OEM, SQL* Plus, SQL* Loader, TKPROF, LOGMINER,
STATSPACK, SQL*Net, IMPORT/EXPORT, and RMAN
Involved in writing for shell scripts for monitoring health checks and also for taking RMAN backups
and Developed Scripts for transferring data from production server to testing/development servers
Environment : Oracle 10g, 11g, RHEL 5.5, HP-Unix 7i , OEM, DBUA, RMAN, People-soft, Golden gate, Grid,
RAC, ASM, Data guard, SQL*LOADER, AWR, ADDM, ASH, TTS, Oracle Wallet, TDE, Data pumps
Comerica Bank, Detroit, MI Nov 2009 Feb 2010
Role: Oracle DBA
Responsibilities:
Responsible for setup and implementation of 2 NODE RAC on 10g.
Added a new node for 2 Node RAC for minimizing the downtime, maximizing availability and also achieved load
balancing by minimizing the interconnect traffic
Used CRSCTL and SRVCTL commands for the stop / start Cluster operations.
Responsible for capacity planning, database security, recovery planning and installing patches
Involved in UP-GRADATION of databases from 10.2.0.2 to 10.2.0.4 on Sun Solaris
Installed 10.2.0.4 agent and involved in registering of databases in OEM
Installed STANDALONE servers on ASM and migrated databases to ASM
Worked extensively on monitoring 10g grid control database, configuration of error notifications, installing
listeners, and adding them to the grid control
Collected ADDM recommendations using OEM 10g/11g to tune the TOP running SQL Query's
Implemented Disaster Recovery Plan for critical databases using DATAGUARD
Worked on physical and snapshot standby 11gR1 databases in Data-guard environment
Involved in construction of Disaster Recovery (DR) for all the production databases using DATAGUARD
Performed Database Refresh from production to testing and development environment and used EXPDP for
schema level
Worked closely with PL/SQL developers for fine performance tuning
Supported development teams by providing SQL statement tuning and removing load and query performance
bottlenecks by using tools EXPLAIN PLAN, STATSPACK, and TKPROF
Experienced in scheduling the database backup jobs using Crontab
Created a Clone database using RMAN on remote server
Involved in database design and used Erwin as a Data Modeling tool & Designing the ETL processes
Involvement in space management, rectification of lock problems, managed quotas
Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical I/O
and Memory Usage.
Created and monitored database objects like Tables, Indexes, Views, Users and DB links
Conducted time to time analysis and monitoring of the software and hardware requirements and act
accordingly.
Environment: Oracle 11g/10g, Windows 2008, Sun Solaris 5.x, Oracle RAC, TOAD, VERITAS, OEM,
LOGMINER, Informatica, DB Links, SQL, PL/SQL, TKPROF, EXPLAIN PLAN.
CAPITAL IQ, Hyderabad, India Aug 2008 - Oct 2009
Role: Oracle Developer/DBA
Responsibilities:
Involved in Up-gradation of databases from 9i to 10g
Configured listener and TNS names manually
Configured Oracle Data-guard for Oracle Disaster recovery on 10g Solaris.
Achieved High availability, Data protection and maximum performance by maintaining physical standby
databases
Implemented Oracle database backup & recovery solutions using RMAN
Configured and Tuned RMAN for better performance and backup strategies
Involved in writing for shell scripts for taking RMAN backups
Worked extensively on performance tuning of queries by maintaining Aggregates, Compression, partition,
indexing and use of statistics
Restored and Recovered database at the times of occurrence of critical failures.
Created user accounts, roles and granting required access permissions and privileges to the database based on
the application they are accessing
Performed large batch jobs and tuning of SQL queries and database systems
Monitored Oracle Instances, Users, Tables, Table-spaces, Memory structures, and Rollback segments, Redo-logs,
Archived Redo-logs and Alerts
Performed automated backups and scheduling using scripting
Written Stored Procedure and Triggers for database maintenance and management using PL/SQL and Involved
in gathering requirements from end users
Estimate growth of database size by detail analysis of the company's future policies and generating reports for
the management to act in advance
Clear documentation was prepared on all the processes like program specification, bugs fixing logs & change
requests for future reference
Environment: Oracle /10g/9i, Sun Solaris 5.x, HP-UX 7.x ,OEM 10g, Shell Scripting, TOAD, putty,
STATSPACK,EXPLAIN PLAN.
EDUCATION
Bachelors of Technology from Acharya Nagarjuna University.
|
