Database Administrator Oracle
Resume:
ANAND TATIKAYALA
SR. ORACLE DBA
********@*****.***
Mobile: 678-***-****
Background:
A highly accomplished Oracle DB/RAC/EBS Certified Professional with 20 years (11 yrs in USA) of hands-on expertise with DB & Apps Administration, Installations, Configurations, Upgrades, Migrations, Patching, Cloning, Performance Tuning, SQL Tuning, Backup/Recovery, Space Management, DB security, Auditing, Troubleshooting, DB Design, Oracle metalink support, Shell Scripting, Documentation and 24/7 mission critical prod support.
Professional Summary:
Expertise in Lead DB administration, design, development, replication, data and performance tuning
Exceptional and proven database management skills with experience in managing Oracle builds
Well exposure on Oracle 12c, 19c Amazon RDS and cloud infrastructure environments for federal
AWS RDS for Oracle, including administration, security, automation, and CloudFormation Templates (CFTs)
Great experience with PRISM – a large, high-volume Oracle database and maintenance of its architecture
Hands-on lead skills on oracle upgrades/migrations, DB security, disaster recovery, patch management
Working experience on SuperCluster/Exadata in a large complex UNIX and Windows environments.
Sound technical expertise with Oracle RAC (12 nodes) and many clustered database systems
Expertise in database design, installation, configuration, upgrades, replication & strong SQL Tuning
Hands-on exposure on cloning, backup/recovery, performance tuning and database security.
Expertise in Oracle RAC solutions, (ASM) builds, configuring OEM and Data Guard setup/configuration
Exposure on replication using Oracle Streams, Shareplex, Golden Gate and heterogeneous replication
Expertise in DB security, DB audit, user profiles, security patch updates and PCI layer 3 migration.
Experience with Oracle Super Cluster/Exadata, database sizing and capacity planning.
Performed PL/SQL development, Shell scripting and Performance tuning.
Expertise with Web logic, OBIEE, Workflow, Hyperson, People Soft, Informatica
Hands on proficient exposure on PostgreSQL, MariaDB, MySQL, and SQL scripting
Experience working with VMware and Oracle Virtual Machine (VM).
Experience with NetBackup RMAN database backups, ASM storage, SAN storage.
Experience with Erwin data modeler,Oracle Designer and knowledge of Toad Data modeler.
Experience with Oracle 11g warehouse builder and knowledge of ETL.
Performed data conversion and development across several platforms and contributed in all phases of SDLC
Experience with My Oracle Support (MOS) for Oracle SR, patch download and software delivery cloud.
Exceptional skills in evaluating latest Oracle products and state-of-the-art technologies.
Experience as On-Call 24x7 production DBA support, application/development DBA.
Extensive knowledge on database administration for Oracle 8i, 9i, 10g and 11g & 19c with experience in very large scale database environment and mission critical large OLTP and OLAP systems.
Managed Oracle databases running on Windows, NT Server, UNIX/Linux, Sun Solaris, HP-UX & AIX and RHEL
Hands on experience in Oracle 10g/11g/19c RAC implementation & administration (Oracle Clusterware setup and configuration, RAC installation using ASM, Grid Installation).
Expertise with SQL, PL/SQL programming, shell/perl/cron scripting
Hands on technical cloud infrastructure knowledge on snowflake database administration on AWS/GCP
Handled mission critical 24/7 prod environments to ensure high availability
Project Experience:
Client: General Dymanics IT /CMS, MD
Duration: July 2018 – June 2025
Sr. Oracle Database Administrator
Project Description:
CMS (Centre for Medicare & Medicaid systems, a federal client of GDIT, based at Maryland) serves the public as a trusted partner and steward, dedicated to advancing health equity, expanding coverage, and improving health outcomes. CMS programs cover more than 160 million people across the country through the 3Ms - Medicare, Medicaid and the Children’s Health Insurance Program (CHIP), and the Marketplace. In short, CMS provides health coverage to 1 in 2 Americans. CMS programs are critical to ensuring all Americans have access to quality health care. CMS' goal is to ensure that every person has the opportunity to access the care they seek at an affordable cost. These programs distribute substantial funding throughout the U.S. health care system annually and CMS provides quality oversight for most hospitals, health systems, health care facilities and providers across the country.
Support DBA activities on Oracle Exadata of Dev/Test/Prod/DR environments.
Hands on expertise and familiarity with Jira, Confluence, Remedy, Panaya tools
Expertise over Oracle 12c, 19c Amazon RDS Backups and other cloud infra tasks
Participated in functional test planning and testing for the assigned applications
Supported Oracle CPU Patch Releases, maintenance & cloning using Ansible Tool
Participated in problem-solving and troubleshooting for the assigned application
Respond quickly for production issues and taking responsibility for their resolution.
Resolved database performance issues, replication, and other distributed data issues.
Managed backup/recovery of databases using RMAN and/or Network Appliance Snapshots.
Strong Hands-on expertise in PostgreSql,AWS,Snowflake,Docker,Kubernetes and Gitlab tool
Managed security of database structures and corporate data held within databases.
Developed database procedures, triggers and SQL scripts for development teams.
Assisted in the definition and implementation of database standards and SQL Tunings
Reviewed scripts submitted by the Development team to ensure that all standards are met.
Monitored databases for errors and perform problem determination when necessary.
Expertise in Real Application Cluster (RAC) and Oracle Enterprise Manager Monitoring Tool
Supported HIGLAS environments using PostgreSQL, MariaDB, MySQL, and SQL scripting skills
Exposure on PRISM – a large, high-volume Oracle database and maintenance of its architecture
Share knowledge by effectively documenting work by making SOP documents
Participated in on-call rotations to support PROD & Non-Prod databases
Designed high available systems using Standby/Data Guard/Oracle Goldengate/Advanced Queuing
Well exposure on Oracle Golden Gate 19c Replication & Globalization Support on Linux Machines
Hands on technical expertise on DB Administration & Automation of Database Activities
Expertise with exadata in large scale industries and dataware house environments
Handled 10g/11g/19c RAC administration and its components in various unix and windows flavors
Sound knowledge on Data modelling, data/system integration, data management etc.
19c/12c/11g/10g/9i databases administration on Sun, HP, AIX, RHEL and Windows platforms.
Non-Production support in resolving non-production related incidents.
Troubleshooting all levels of issues in database and Applications.
Involved in Capacity Planning, Hardware Sizing, Storage Planning and building various platforms
Hands on experience with Oracle Golden Gate and ORDS on Linux Machines with Oracle Databases
Installed, configured and administration of OEM 19c for monitoring alerts and DB/Applications
Engaged in Database Refreshes from PRD to TST/DEV/UAT
Strong knowledge on basic concepts of RAC and ASM on 10g/11g/12c/19c Oracle Databases
Performed creation, configuration and Management of Oracle RAC, ASM
Involved in interpreting AWR and ADDR, TKPROF and Explain Plan reports
Design and implementation of the database strategy for the cloud-based replacement for PRISM
AWS RDS Oracle, including administration, security, automation, and CloudFormation Templates (CFTs).
Handled TOP wait Events, Type of Indexes, Fragmentations, HWM, Statistics & automation of tools
Support Database Re-Org activities for all Oracle Linux Databases on Exadata Machines
Supported PROD environments 24/7 regular/oncall, rotational basis along with support teams
Client: ConEdison, NY
Duration: Jun 16 - Jun 18
Role: Sr. Oracle DBA Lead
Supported Oracle EBS/Fusion Middleware/Hyperion/OBIEE databases and Applications
Good understanding of Exadata Architecture & features
Understanding of CELLCLI, DCLI and Cell Storage software
Well knowledge on Flash cache, Storage Index, HCC and IORM
Hands-on expertise on Performance tuning of Exadata components
Solid exposure of Exadata hardware, Luns, Cell Disk and Grid disk
Performed applications code migrations/Database Deployments using STAT/Panaya/Kintana tools
Engaged in co-ordinating/managing multiple, complex application releases across different platforms
Engaged in Upgrading Oracle Databases 10G to 12c & Migration from Sun Solaris to Linux (RHL) 7
Well exposure on Oracle Streams and Golden Gate configuration/support in Linux environments
Involved in Developing and Running Scripts for EBS Upgrade, OS Migration/DB Upgrade.
Engaged in Developing Test Plan, Test and Commission the Upgraded/Migrated System.
Engaged in Technical upgrade plan, instance plan, UAT /QA/Performance test cycles.
Performed RMAN backups, recovery and Apps clones/DB refreshes for support.
Handled installation & configuration of OBIEE in data warehouse environments
Engaged in Database Refreshes from PRD to TST/DEV/UAT
Strong knowledge on basic concepts of RAC and ASM
Hands on exposure on PostgreSQL, MariaDB, MySQL, and SQL scripting
Performed creation, configuration and Management of Oracle RAC, ASM
Exposure on adpatch, adclone, adrelink, adadmin, adcrtrl, FNDLOAD, etc
Involved in interpreting AWR and ADDR, TKPROF and Explain Plan reports
Handled TOP wait Events, Type of Indexes, Fragmentations, HWM, Statistics & automation of tools
Expertise on troubleshooting cluster / asm storage related issues.
Expertise on PCP and middle tier Load balancer setup / troubleshooting
Expertise in troubleshooting Oracle EBS issues related to Concurrent Manager / OPMN / Workflow etc
Performed Oracle DB admin tasks like Backup, Restore, DB refreshes, clones etc
Performed Clones of Oracle Applications R12 instances using NetApp snapshot technology
Application Code migrations, FNDLOAD, Apps bounce/restart etc through ITSM/CR/SPARC requests
Handled Cloning and Refreshing Oracle Database/Application Instances.
Performed Oracle Database Patching and Tax updates.
Performed Database Health check and Space Management.
Performance tuning of DB (exa cell servers / disks) and Apps through various scenarious
Supported RAC instances (4 node) using SRVCTL utility.
Maintained databases on 10g/11g/12c including all daily activities and DBA jobs.
Handled Hot, Cold, Logical, net backups using RMAN/SNAP for backup and recovery.
Engaged in writing Shell/Perl scripting for various activities at DB/Apps admin
Supported PROD environments 24/7 regular/oncall, rotational basis along with support teams
Client: Gilead Sciences, CA
Duration: Dec 13 – May 16
Role: Sr. Oracle DBA Lead
Administration of Oracle 11g/12c RAC, sybase databases & R12 Applications on RHEL 64 bit environments
Handled 10g/11g databases conversion to RAC and 12c with exadata environments
Performed Applications code migrations using Kintana / Panaya tools.
Upgraded EBS from R12.1.3 to R12.2/12.2.5 on RHEL 7 platform servers.
Configured Oracle ERP products: CRM, EPM, Financials & HRMS with EBS 12.2 applications
Experience of database migration from commodity (non-exa) to exadata environment
Involved in Capacity Planning, Hardware Sizing, Storage Planning in various platforms
Involved in configuring DMZ & Load Balancer with EBS 12.1 Applications.
Performed Oracle web logic server (12.2.1) configuration with EBS.
Installed/maintained the COTS product and custom developed objects and monitoring/troubleshooting
Handled issues of Financials of Purchasing, Accounts Payable, Accounts Receivable, General Ledger
Handled issues of Fixed Assets, Property Manager, Inventory and workflow services
Patch/Release management through patch wizard and change management process.
EBS R12 Middleware Applications support on 11g/12c databases with RAC/ASM using SRVCTL
Configuration and implementation of Japan language with EBS R12
Oracle discoverer configuration and setup with oracle EBS
Handled Oracle EBS issues related to Concurrent Manager / OPMN / Workflow etc
Performance tuning of both Apps and DB layers (Cell Servers/disks) in exadata environments
Web logic, SOA suite, Oracle EBS R12.2 installations and configurations
SSO/OAM with OID/Portal and DMZ/SSL setups and configurations during cloning process.
EBS upgrade from R12.1.3 to R12.2.5 and Oracle Database from 11gR2 to 12C
Oracle DB admin tasks Backup, Restore, Disaster recovery, Data guard setup, Golden gate
DB/Apps refreshes/clones from PRD to DEV, TST, UAT, VAL using NetApp snapshot technology
Oracle production instances and web logic servers on exadata environments
Code migrations, FNDLOAD through ITSM/CR/SPARC/REMEDY requests
Periodic Cold/Hot/snap/rman backup & recovery processes
Performed Export, Import, Expdp, Impdp, Flashback, ADDM and AWR.
Performance tuning using Explain Plan, SQL*Trace, TKPROF, AWR reports
Configured Standby database for disaster recovery and data guard setup for high availability.
Handled Load balancing, databases/schema/table re-organization for faster performance.
SQL tuning and assisted developers with coding on PL/SQL
Monitored database performance through alerts, alert log, enterprise manager and awr reports
Hands on Shell/Perl scripts, cron jobs, backup scripts
Health Check of Databases, Applications and monitored performance
Handled critical Database recovery from Block Corruption and a physical datafile drop
Handled the process of analyzing tables every night through a cron/manual script
Security and access to database by granting and revoking roles to and from users.
ASCP, Demantra, ODI, Financials, HRMS modules configurations in R12 environment
Supported mission critical PRD environments 24/7 oncall and offsite.
Client: US Concrete, TX
Duration: Mar 13 - Aug 13
Role: Sr. DBA Lead
Oracle, mysql Database Administration on UNIX/SUN, DB2, Sybase environments.
11gR2 database Installation, Configuration on Linux
Supported Weblogic, OBIEE, OID, Hyperion, SOA and Informatica environments
Configured multinode shared file system, SSL and DMZ with EBS
Configuration and setup of Dataguard for high availability
Configuration of 11g RAC for 3 nodes on Red Hat Linux
Handled Change, Problem, Release, Incident, Security Management.
EBS upgrade from 11i to R12 and Oracle Database from 10g to 11g
Clones of Oracle Applications R12 instances from PROD to DEV,TEST, UAT
Configured financials, HRMS, CRM and Manufacturing modules with EBS
Logical backups, Hot/Cold Backup and Recovery and Database Refreshes.
Incomplete/complete recovery of data files, tablespaces, control files
Handled critical database block corruptions using media/tape backup
Oracle Software 10g/11g on Sun Solaris platform.
Handled database space requirements and adjust for future needs.
Performed database Performance Tuning using AWR, and ADDM
Network Trouble Shooting using TNS configuration, listener/sqlnet settings.
Handled database memory usage, cpu usage, hit ratios, I/O, locks/latch contention.
Performed FNDLOAD, Export/Import, expdp/impdp, Materialized Views, Replication.
Performed Disaster Recovery Drills, documented database and application validation steps.
Experience in Performance Tuning using EXPLAIN PLAN, SQLTRACE, TKPROF, STATSPACK, AWR and ADDM.
Setup Oracle Enterprise Manager (OEM) 10g & Grid Control (11g) for database monitoring
Experience in Database Backups RMAN (Full/Incremental backups) and in traditional hot/cold backups.
Experience in LOGICAL BACKUPS and Database migration tools with DATA PUMP, Export/Import
Good experience in writing/editing UNIX Shell Scripts.
Good experience in PATCHING AND UPGRADATION.
Expertise in upgrading Oracle Development and Production databases from 10g & 11g, 11g to 12c/19c.
Extensive knowledge and experience on managing very large Data Warehouse databases.
Proficient in SQL, PL/SQL, Stored Procedures, Functions, Cursors and Triggers.
Experience in configuring and implementing ASM and proficiency in using ASMCMD and ASMLIB.
Experience in Flash-Back Technology.
Experience in Database Refresh and patch management and in cloning with RMAN and manual methods.
Experience in Capacity Planning and Bench Marking.
Developed database monitoring/health check alert scripts for database uptime/downtime status and sizing issues using grid control (OEM).
Client: Empirix, MA
Duration: May 12 - Feb 13
Role: Sr. Consultant DBA
Installation of Oracle 10g/11g on RHEL, SUN, DB2, Sybase
Database creation for Testing and Development
Applications upgrade from R11i to R12.1.1 on RHEL
Patching Oracle Applications R12 instances.
Periodic backup of the databases on 9i/10g/11g
Backup & Recovery procedures to ensure consistency.
Hot/cold/snap/rman backups and backup validations
Import/Export, Impdp/Expdp, Flashback, ADDM and AWR activities.
Performance tuning using explain plan, trace, tkprof, awr reports
Standby database for disaster recovery and data guard for high availability.
Load balancing, databases/schema/table re-organization for perrformance.
Oracle DB admin tasks Backup, Restore, Disaster recovery, data guard setup
DB/Apps refreshes/clones from PRD to DEV, TST, UAT, VAL
Oracle production instances and web logic servers.
Application Code migrations, FNDLOAD through ITSM/CR/SPARC/REMEDY requests
Periodic Cold/Hot/snap/rman backup & recovery processes
Export, Import, Expdp, Impdp, Flashback, ADDM and AWR.
Performance tuning using Explain Plan, SQL*Trace, TKPROF, Statspack, AWR reports
Mission critical PRD environments 24/7 oncall and offsite.
Client: Solaria Corp, CA
Duration: Apr 11 - May 12
Role: Sr. DBA
System roll-outs and change management during project implementation
Concurrent Manager issues and setting up PCP
Disaster recovery and high availability (setting up logical/physical data guard with RAC)
Installations, Configurations, Upgrades, Migrations
Logical/rman/hot/cold/snap backups and recovery, disaster recovery
Complete/incomplete recovery, recovering data files, tablespaces, control files, block corruption.
Handled large data in large scale industries and dataware house environments
Configuration of oracle business accelerators with EBS R12
Handled Data modelling, data/system integration, data management etc.
Performed Oracle Apps DBA activities on 12.1.3, 12.0.4, 11.5.10.2 on Oracle, DB2, Sybase
Supported 10g/9i databases on Sun, HP, AIX, RHEL and Windows platforms.
Sysadmin activities define conc programs, request sets, profile settings, user/responsibility mgmt
Printer settings, concurrent manager setups, workflows setups.
Cloning/refresh of Oracle Applications/Databases from Production to TEST, DEV, QA, UAT
Monitoring, Patching, performance tuning, troubleshooting Appl/DB issues in a 24x7 environment.
Oracle 10g, 11g, 12C features, OEM, ASM, and Grid Control
Database Performance Tuning and Network Trouble Shooting using TNS configuration
Designed Tablespaces, tables, views, synonyms, indexes, database links and materialized views
SqlTrace, TKPROF, Explain plan, Statspack, AWR, and ADDM.
Database performance, hit ratios, I/O, lock, and latch contention.
Mission critical 24/7 prod environments to ensure high availability
Client: Injazat Data Systems, UAE
Duration: Jan 11 - Mar 11
Role: Oracle DBA
EBS R12 Applications on 11g/12c databases with RAC/ASM using SRVCTL
Configuration of Arabic language with EBS R12
EBS 11i cross platform migration from Win2000 32bit to Linux 86-64bit
PCP and middle tier Load balancer setup / troubleshooting
Oracle EBS issues related to Concurrent Manager / OPMN / Workflow etc
Handled financials of Purchasing, Accounts Payable, Accounts Receivable, General Ledger
Handled Fixed Assets, Property Manager, Inventory and workflow services
Performed performance tuning of both Apps and DB layers on DB2, Sybase, Oracle
Weblogic, SOA suite, Oracle EBS R12 installations and configurations
SSO/OAM with OID/Portal setups and configurations during cloning process.
upgrade from R11.5.10.2 to R12.1.1 using oracle database 10gR2
Oracle DB admin tasks Backup, Restore, Disaster recovery, data guard setup
DB/Apps refreshes/clones from PRD to DEV, TST, UAT, VAL
Oracle production instances and web logic servers.
Application Code migrations, FNDLOAD through ITSM/CR/SPARC/REMEDY requests
Periodic Cold/Hot/snap/rman backup & recovery processes
Export, Import, Expdp, Impdp, Flashback, ADDM and AWR.
Performance tuning using Explain Plan, SQL*Trace, TKPROF, Statspack, AWR reports
Standby database for faster disaster recovery and data guard setup for high availability.
Load balancing, databases/schema/table re-organization for faster performance.
Client: Bank Danamon, Jakarta
Duration: Dec 09 - Dec 10
Role: Oracle DBA Consultant
Oracle databases, Applications on RHEL Linux 64 bit environments
10g databases administration and monitoring using 10g OEM
10g Databases cross platform migration from HP to Linux.
Patch management and release management through change management
EBS R12 Applications on 10g databases with RAC/ASM using SRVCTL
Configuration of SSL certificates with EBS R12 for apps security
Middle tier Load balancer setup / troubleshooting
Oracle EBS issues related to Concurrent Manager / OPMN / Workflow etc
Performance tuning of both Apps and DB layers.
Weblogic, SOA suite, Oracle EBS R12 installations and configurations
SSO with OID/Portal and DMZ/SSL setups/configurations during cloning process.
Upgrade from R12.1.1 to R12.1.3 and implemented 12c Database
Oracle DB admin tasks Backup, Restore, Disaster recovery, data guard setup
DB/Apps refreshes/clones from PRD to DEV, TST, UAT, VAL
Oracle production instances and web logic servers.
Application Code migrations, FNDLOAD through ITSM/CR/SPARC/REMEDY requests
Periodic Cold/Hot/snap/rman backup & recovery processes
Export, Import, Expdp, Impdp, Flashback, ADDM and AWR.
Performance tuning using Explain Plan, SQL*Trace, TKPROF, Statspack, AWR reports
Standby database for faster disaster recovery and data guard setup for high availability.
Load balancing, databases/schema/table re-organization for faster performance.
SQL tuning and assisted developers with coding on PL/SQL
Database performance through alerts, alert log, enter prise manager and awr reports
Shell/Perl scripts, cron jobs, backup scripts
Client: Cisco Systems, India
Duration: Apr 09 - Dec 2009
Role: Oracle DBA
Installation of Apps R12 on RHEL, SUN, HP and AIX
Clones of Oracle Applications R11i/R12 instances.
10g database cross platform migration from SUN to RHEL
Periodic backups of the databases on 9i/10g using RMAN
Backup & Recovery procedures to ensure consistency.
Oracle Recovery Manager (RMAN), and standby database
Hot/cold/snap/rman backups and backup validations
Import/Export, Impdp/Expdp, Flashback, ADDM and AWR.
Performance tuning using explain plan, trace, tkprof, awr reports
Handled environment setup, database design, rdbms data modelling.
Performed database cloning and refreshes to setup test and development database
Standby database for disaster recovery and data guard for high availability.
Load balancing, databases/schema/table re-organization for perrformance.
Oracle DB admin tasks Backup, Restore, Disaster recovery, data guard setup
DB/Apps refreshes/clones from PRD to DEV, TST, UAT, VAL
Application Code migrations, FNDLOAD through ITSM/CR/SPARC/REMEDY requests
Periodic Cold/Hot/snap/rman backup & recovery processes
Export, Import, Expdp, Impdp, Flashback, ADDM and AWR.
Performance tuning using Explain Plan, SQL*Trace, TKPROF, Statspack, AWR reports
Client: Verizon, NJ
Duration: Oct 08 - Jan 09
Role: Programmer Analyst
Handled Oracle Apps DBA activities on 12.1.1, 12.0.4, 11.5.10.2 application versions
Performed System releases, code deployments during project implementation
Concurrent Manager issues during programs run time on month end process
Disaster recovery and high availability (setting up logical/physical data guard with RAC)
Logical/rman/hot/cold/snap backups and recovery, disaster recovery
Complete/incomplete recovery, recovering data files, tablespaces, control files, block corruption.
Configuration of oracle business accelerators with EBS R12
Data modelling, data/system integration, data management etc.
10g/9i databases on Sun, HP, AIX, RHEL and Windows platforms.
Sysadmin activities define conc programs, request sets, profile settings, user/responsibility mgmt
Printer settings, concurrent manager setups, workflows setups.
Cloning/refresh of Oracle Applications/Databases from Production to TEST, DEV, QA, UAT
Monitoring, Patching, performance tuning, troubleshooting Appl/DB issues in a 24x7 environment.
Oracle 10g ASM, OEM / Grid Control to monitor PRD/DEV databases effectively
Database Performance Tuning and Network Trouble Shooting using TNS configuration
Database growth on daily basis, modification of databases, addition of tablespaces, datafiles
Table reorganization, index rebuild, gather stats/analyze tables periodically etc
Oracle Support processes for technical requests using Metalink.
SQL, PL/SQL programming, shell/perl/cron scripting and helping developers in robust queries
Client: iTrac global, India
Duration: Apr 07 – Sep 08
Role: Oracle DBA Analyst
Created new EBS sandbox build with R12.1 for business demo environment
Performed configuration of German language with EBS R12
PCP and middle tier Load balancer setup / troubleshooting
Oracle EBS issues related to Concurrent Manager / OPMN / Workflow etc
Performance tuning of both Apps and DB layers.
Weblogic, SOA suite, Oracle EBS R12 installations
OAM/SSL setups and configurations during cloning process.
Upgrade from R12.1.1 to R12.1.3 and implemented 12c Database
Oracle DB admin tasks Backup, Restore, Disaster recovery, data guard setup
DB/Apps refreshes/clones from PRD to DEV, TST, UAT, VAL
Oracle production instances and web logic servers.
Application Code migrations, FNDLOAD through ITSM/CR/SPARC/REMEDY requests
Periodic Cold/Hot/snap/rman backup & recovery processes
Export, Import, Expdp, Impdp, Flashback, ADDM and AWR.
Performance tuning using Explain Plan, SQL*Trace, TKPROF, Statspack, AWR reports
Standby database for faster disaster recovery and data guard setup for high availability.
Load balancing, databases/schema/table re-organization for faster performance.
SQL tuning and assisted developers with coding on PL/SQL
database performance through alerts, alert log, enter prise manager and awr reports
Shell/Perl scripts, cron jobs, backup scripts
Health Check of Databases, Applications and monitored performance
Critical Database recovery from Block Corruption
Handled the process of analyzing tables every night through a cron script
Client: Sony Japan, India
Duration: Oct 06 – Mar 07
Role: Software Engineer
Installation of Oracle 10g on LINUX, SUN, HP environments
Database creation for Testing and Development
Clones of Oracle Applications R11i/12 instances.
Data block corruption using tape/media backup
Periodic backup of the databases on 9i/10g/11g
Backup & Recovery procedures to ensure consistency.
Oracle Recovery Manager (RMAN), and standby database
Hot/cold/snap/rman backups and backup validations
Import/Export, Impdp/Expdp, Flashback, ADDM and AWR.
Performance tuning using explain plan, trace, tkprof, awr reports
Environment setup, database design, rdbms data modelling.
Database cloning and refreshes to setup test and development database
Standby database for disaster recovery and data guard for high availability.
Load balancing, databases/schema/table re-organization for perrformance.
DB admin tasks Backup, Restore, Disaster recovery, data guard setup
DB/Apps refreshes/clones from PRD to DEV, TST, UAT, VAL
Oracle production instances and web logic servers.
Application Code migrations, FNDLOAD through ITSM/CR/SPARC/REMEDY
Periodic Cold/Hot/snap/rman backup & recovery processes
Configuration of new ASM storage for daily growth of production data
Performance tuning using Explain Plan, SQL*Trace, TKPROF, AWR reports
Shell/Perl /Cron scripts for daily monitoring and managing alerts
Oncall/p1 mission critical support for production issues/alerts as and when come
Client: Citi Group, India
Duration: Apr 05 – Sept 06
Role: Database Engineer
Performed capacity planning, hardware sizing, database creation and new build
Periodic backups of the databases on 9i/10g for recovery needs
Backup & Recovery procedures to ensure consistency.
Oracle Recovery Manager (RMAN), and standby databases
Hot/cold/snap/rman backups and backup validations
Import/Export, Impdp/Expdp, Flashback, ADDM and AWR.
Performance tuning using explain plan, trace, tkprof, awr reports
Database patching using opatch utility to fix the various bugs.
Database cloning and refreshes to setup test and development database
Standby database for disaster recovery and data guard for high availability.
Load balancing, databases/schema/table re-organization for perrformance.
Oracle DB admin tasks Backup, Restore, Disaster recovery, data guard setup
DB/Apps refreshes/clones from PRD to DEV, TST, UAT, VAL
Oracle production instances and web logic servers.
Database security patching for every quarter as per business needs
Periodic Cold/Hot/snap/rman backup & recovery processes
Export, Import, Expdp, Impdp, Flashback, ADDM and AWR.
Performance tuning using Explain Plan, SQL*Trace, TKPROF, Statspack, AWR reports
Standby database for faster disaster recovery and
Contact this candidate