PROFILE

Vikram K Email:[email protected]
Mob. No: +91 8341454509
TECHNICAL SUMMARY

 Having 11+ years of IT experience in Oracle Applications DBA and Oracle DBA.
 Experience in Installing and configuring various Oracle Products like Oracle Applications (EBS),
Databases, Web logic, forms & Reports.
 Involved in Oracle EBS upgrade to R12.2.10.
 Support / Manage Oracle ERP databases on Exadata.
 Experience in ORACLE 12x and 19x databases on Cloud and non cloud environments,Multi node
server and Load Balancer environment in Oracle EBS.
 Experience in Applying Application Patches & Database Patches on Production and Non-Production
instances (RAC and Non RAC), applying the patches for fixing the bugs.
 Experience in Support & Upgrading Oracle (LSH) Life Science Data Hub.
 Experience in Setup the REST Webservices in EBS.
 Experience in configuring Oracle E-Business Suite Integrated SOA Gateway Release 12.1.3.
 Experience in RMAN Cloning Oracle Production to Non-Production instances.
 Experience in configured the Physical Standby database in Data guard (DGMGRL).
 Expertise in Maintaining and scheduling RMAN backups.
 Good knowledge of UNIX platform Ability to proactively identify troubleshoot and resolve live
database systems issues.
 Experience in Creating indexes and analyzing which indexes to create based on requirement.
 Performed Oracle Database and Applications E-Business Suite Health Check.
 Experience in AD Utilities for maintenance Oracle Applications.
 Very well versed in Oracle Applications Utilities like AD Administration, AD Controller,
Autoconfig, AD Relink, Auto Patch.
 Troubleshooting on (workflow mailer, Concurrent manager, Apache, Forms & Reports server etc.).
 Document and Implement Change control requests in Production systems.
 Analyzing and gathering statistics of objects for better performance.
 Experience in Defragmentation on Production databases, Index rebuilding.
 Performance Monitoring, Tuning SQL, determine the size of System Global Area SGA, estimate the
number of users, CPU and Disk space requirement.
 Developed scripts for Pro-actively monitoring disk I/O, locks, memory & CPU usage etc.
TECHNICAL SKILLS

ERP Packages : Oracle Application 11i & R12.

Databases : Oracle 19c,12c,11g, 10g , RAC (10g &11g) databases.
OS : IBM AIX, Linux, Solaris, Windows.
Others : OBIA, Oracle Streams, Informatica and Cognos.
1

Client : Novartis,Merck,Genpak,3M, Dunkin, Norli,ABS.

Role : Lead Administrator.
Organization : Cognizant Technology Solutions
Duration : Dec 2019 to till date.
Environment : Oracle EBS R12.X, 11i,LSH 2.X, 3.X,Oracle 11g,12c &19c,Linux, AIX
RESPONSIBILITIES

 Provided Production Support in Managed Services Team.

 Involved in DB & EBS upgrades to 19c & EBS R12.2.10
 Ensure that the databases remain healthy and stable, ensures meets our overall SLA's- Provide DBA
services to support project and steady state day to day work.
 Patch Analysis, Applying Application Patches & Database Patches on Production as part of CR.
 Cloning/Refresh of EBS 11i & R12 instances.
 Workflow tables purge and re-org the tables.
 RMAN backup faulures.
 Rest Service Deployment Migration(API’s), Custom top creation, Tablespace space reclaim.
 Demantra tasks-schema cloning/ patching / bounce the services.
 LSH Security Vulnerabilities (IT360 Report- SSC failed Controls for OS & DB level).
 Workflow tables purge & table re-org.
 Server Migration, CPU Patch, TLS1.2 implementation, Node Addition, Secure File migration, JDK
Upgrade.
 Providing support to Exadata DB team, Linux, Data Centre, tech team, app team and management.
activities.
 Set up the SAS DPServer configuration, Davinci, RAVE SOD, RAVE ODM Adaptor migration to
LSH
 Debugging the Cronjob failures, Database backup Job failures, OS level script issues.
 Update the status reports and complete the project deliverables.
 Expertise in TKPROF, ADDM and AWR reports for diagnostics purpose.
 Used AD Controller utility to see the worker status and resolved worker issues by checking worker
log files and restarted failed workers.
2

Client : Novartis, Otsuka, Merck & Sunovion Pharmaceuticals.

Role : Senior consultant.
Organization : HCL Technologies
Duration : Feb 2014 to Nov 2019.
Environment : Oracle EBS 11i & R12, LSH 2.X, Oracle d/b 9i, 10g, 11g, RAC, ASM,
Linux, Solaris 10.
RESPONSIBILITIES

 Regular Database Health check, Monitoring and Daily Preparing Health Check Reports.
 Upgraded Oracle LSH (Life science Data Hub) from 2.2.0.11 to 2.4.6.
 Configured Oracle E-Business Suite Integrated SOA Gateway Release 12.1.3.
 Oracle Fusion middleware 12c installations and Configuration.
 OEM platform upgrade:
 To Migrate the Linux & UNIX servers (targets DB's) from OEM 11g to 12C.
 Set the monitoring template for the targets as per the Source template.
 And create groups and jobs for the specified backup jobs (HOT & INCR) from the source.
 Patch Analysis, Applying Application Patches & Database Patches on Production as part of CR.
 LSH Security Vulnerabilities (IT360 Report- SSC failed Controls for OS & DB level).
 IT Change requests like Server Migration, CPU Patch, TLS1.2 implementation, Node Addition,
Secure File migration, JDK Upgrade, .
 Providing support to Exadata DB team, Linux, Data Centre, tech team, app team and management.
activities.
 Set up the SAS DPServer configuration, Davinci, RAVE SOD, RAVE ODM Adaptor migration to
LSH.
 Maintenance activities.
1. OWB Purging- Quarterly, OWB Expiration notification purge tables, Sys and System tables
Cleanup, RAVE schema Maintenance.
2. Quaterly workflow tables purge & Re-org the workflow tables.
 Interact with app teams and client on technical issues.
 Coordinate database level changes with Infra teams like Exadata DB team, Linux, Data Centre, tech
team, app team and management.
 Quarterly EBS Instances Password change activity.
 Debugging the Cronjob failures, Database Job failures, OS level script issues.
 Provided support for various issues like Assigning of Responsibilities, Front End Connection Issue,
Workflow Agent Listener Service bouncing, Compile invalid objects for Database, Compiling the
specific form.
 Releasing of object locks, Listener issues, Adding Data files, TEMP, UNDO.
 Interact with Oracle Support for technical assistance requests and working with Meta Link.

Client : CISCO(Wipro technologies)

Role : Oracle APPS DBA.
Organization : Saviance Technologies.
Duration : Aug 2013 to Dec 2013.
Environment : Oracle EBS 11i & R12, Oracle d/b 9i,10g,11g,RAC, ASM, Linux ,
Solaris 10.
RESPONSIBILITIES

 Provided Support for On-call Production Support in Managed Services Team.

 Regular Database Health check, Monitoring and Daily Preparing Health Check Reports.
 Ensure that the databases remain healthy and stable, ensures meets our overall SLA's- Provide DBA
services to support project and steady state day to day work.
 Patch Analysis, Applying Application Patches & Database Patches on Production as part of CR.
 Involved in upgrading the database 10g to 11g database.
 Dedicated support and administration of Oracle databases.
 Interact with app teams and client on technical issues.
 Coordinate database level changes with Data Centre, tech team, app team and management.
 Addressing and fixing all issues related to Oracle Databases both ERP and Non-ERP
 Instances for both RAC and NON-RAC databases, debugging the Cronjob failures, Database
Job failures, OS level script issues.
 Monitoring the Critical Pages whenever thresholds are reached and paged for.
 Monitoring and Fixing the Weekend Cold backups and Daily Hot backup failures.
 Managed backups as well as RMAN backup failures if paged for.
 Supporting Month-end, Quarter-end, Year-end and release activities for Cisco.
 Monitoring for high availability of the Oracle Data guard or Disaster Recovery databases as
part of Cisco DR policy.
 Documenting the P1/P2 issues and critical pages handled during the shift.
 Handling User requests via Remedy.
 Monitoring, determine the size of System Global Area SGA, estimate the number of users, CPU and
Disk space requirement.
 Monitoring archive log sync between primary and standby database servers in Data Guard.
 Checking the status of the Cluster-ware and RAC Components.
 Monitoring various Web logic components status.
 Interact with Oracle Support for technical assistance requests and working with Meta Link.

4
Client : Sandals Resorts, IDI, Sheela Foams & National Public Radio (NPR).
Role : Oracle APPS DBA
Organization : Heuristics Informatics Pvt. Ltd
Duration : Nov 2012 to July 2013.
Environment : Oracle EBS 11i, R12 oracle 10g,11g, RAC d/b, Web logic, Oracle Streams,
Solaris, Linux, IBM AIX.
RESPONSIBILITIES

 Support of high performance enterprise architectures using oracle Cluster, RMAN, RAC, ASM,
DATAGUARD, load balancing (Multi-Node).
 Checking the free space in mount points, memory and CPU usage, monitoring undo segments,
Temp Usage, Archives and purging old log files and out files.
 Upgraded Prod databases from 9i to 10g including standby.
 Check for space availability in table spaces and Status of Backups.
 Creating new schemas, Table spaces and new tables and providing parameters.
 Backup, Restore and Recovery operations using RMAN.
 Monitoring Cluster ware Services (CRS / CSS / EVM) and RAC Components.
 Configured the Physical Standby database in Data Guard.
 Defragmentation activity on Production databases, Index rebuilding.
 Backup, Restore and Recovery operations using RMAN.
 Generating ADDM and AWR reports for diagnostics purpose.
 Performance tuning using SQL application tuning using TKPROF, SQL TRACE (For session),
STATSPACK, Explain plan.
 Monitor and tune the Production databases for optimal performance and proactively plans and manages
all aspects of oracle database (space, users, growth, response, throughput, instance performance).
 Daily monitoring the database alert log files & trace files for any error messages, periodic checking table
spaces, Undo TBS & index status.
 Checking Streams status, Trouble shooting Streams process.
 Checking the Replication Heart beat among the two instances.

Clients : GMAC & AOIC

Role : DBA
Organization : MphasiS Ltd.
Duration : April -2011 to Jan -2012.
Environment : Oracle Applications 11i, R12, oracle 9i,10g,10g RAC d/b, Linux, AIX.

RESPONSIBILITIES
 Installation and configuration of Oracle database.
 Creation of Database using DBCA or Create Database syntax, Physical database design.
 Creating user, Role and assigning the Privileges.
 Configuring and Checking availability of DB listener and resolving TNS and listener issues.
 Creating database, control file, set database initialization parameters and plan to distribute table
spaces across different disks.
 Creating users and assigning the responsibilities using system administrator module of oracle
applications.
 Checking the status of important services like concurrent managers, form server, web server,
application listener, and database listener.
 Checking the free space in mount points, Memory and CPU usage, Monitoring undo segments, Temp
Usage, Archives and purging old log files and out files.
 Clearing locks, resolving lock issues, clearing runaway sessions, performing tracing of sessions,
performing grants & synonyms.
 Configured Backup strategy for Production Database using RMAN.
 As DBA daily tasks, Managing all the Production databases with different issues like
Tablespace threshold, Locking Sessions, Temp Segment Usage, UNDOTBS Usage, Redo Log file
Status, Agent Resident Memory Utilization.
 Check the alert log file for errors and Purging old log files and out files.
 Tune Memory structure like Shared Pool, Buffer Cache and Redo Log Buffers.
 Checking alert log file for errors (like ora-600, ora-7445, ora-1555).
 Preparation and scheduling of database maintenance Shell scripts, scheduling the Cron Jobs.
 Renaming the data files on Production database.
 Check whether DB Console is running or not and ASM Usage in Disk Group.
 Preparing action Plans for Data guard setup, Cloning, Upgradation and Migration of the Instances.
 Deployed various Cron job scripts in production and DG severs.

EDUCATIONAL QUALIFICATION

 Master of Computer Applications from Kakatiya University - 2007.

WORK EXPERIENCE

 Working as Lead Administrator in Cognizant Technology Solutions, from Dec 2019 to till date.
 Worked as Senior Consultant in HCL Technologies, from Feb 2014 Nov 2019.
 Worked as Oracle Apps DBA in Saviance Technologies, from Aug 2013 to Dec 2013.
 Worked as Oracle Apps DBA in Heuristics Informatics Pvt. Ltd from Nov 2012 to July 2013.
 Worked as Oracle DBA in MphasiS Ltd, from April 2011 to Jan 2012.