Oracle Manager

Saikishore Chitikeshi

Oracle Applications DBA Mobile: 484-***-**** E-Mail: ************@*****.***

Summary

8+ years of Experience in Oracle Database Administration, Oracle Application Administration, Data Masking,Migration, Monitoring,infrastructure,production support, Performance Tuning, Database Backup and Recovery.

3+ years of experience with Standby Database, Data Guard, Replication.

2+ years of experience working in RAC environments.

3+years of experience in Oracle Collaboration suite.

Hands-on experience with Oracle 11g/10g/9i/8i Installation on Linux, Sun Solaris, IBM AIX and HP-UX.

2 years of experience on Oracle 12C and Oracle OEM12c

3+years of experience with Oracle Exadata and Oracle Exalogic

Applied patches on Exadata machine using patchmgr utility.

Worked on IORM,DBRM for IO statistics.

Expertized with the concepts of Hybrid Comulmar compression,Smart Flash Cache.

Upgraded Oracle E-Business suite from 11.5.10.2 to 12.1.3,11.5.10.2 to 12.2

Implemented Belgium, Netherlands, Brazilian Portuguese and Swedish Localizations.

Experienced with Disaster Recovery planning, testing and implementation.

Worked on Concurrent Manager Setup and trouble shooted manager related issues.

System Administration activities in Oracle E-Business Suite.

Performed patch analysis and applied latest RUP(600 patches in a short time span) Levels to be inline with the minimum baseline patch requirements for the extended support for Oracle E-Business Suite 11i.

Experienced in handling with Oracle Applications Version R12.2,12.1.3and 11i.

Excellent track record in providing 24/7 on-call support for both production and development databases in result-oriented, time-critical environments.

Proficient in administration activities like Installation, Configuration, Upgrades, Patches, TAR support, Cloning, Capacity Planning, script development and documentation.

Experienced in Real Application Clusters (RAC) setup, configuration and cluster interconnection with Automatic Storage Management (ASM), configured user log on load balancing and failover on RAC database for high availability.

Migrated NON OATM databases to OATM.

Experienced in Handling SSO/OID issues.

Monitor Oracle application services using OAM

Implemented Best Practices for Maintenance, Monitoring, Backup/Recovery, Growth Management, and Contention Resolution and Defrag scenarios across diverse environments.

Performed Patching, Maintenance, Refreshing/Cloning and Backup/Recovery of Oracle EBS Database and Application Tiers.

Strong experience in Hot/Cold Backups and Point-in-time Recovery procedures using RMAN.

Comfortable with SQL, PL/SQL, and developing various Database objects like Triggers, Stored procedures, Functions, Sequences, Views etc.

Delivered SQL and Database performance tuning services via V$/GV$ views, Explain Plan, TKPROF, AWR (Statspack) reports, ADDM, SQL Tuning Advisor, SQL Access Advisor, Oracle Enterprise Manager (OEM), Grid control, analyzed SQL trace dumps for 9i/10g/11g.

Used Oracle Optimizer to perform Cost Based Optimization on database objects.

Experience in Migration of Databases from 9i to 10g, 10g to 11g,11g to 12c.

Performing cross-platform migration tasks like:

Migration of Databases from IBM AIX 6.1 to RHEL 5.8.

Migration of application tier from Sun solaris,AIX to RHEL 5.8

Experienced in installing, configuring and maintenance of Oracle Golden Gate

Performed bi-directional replication from source to target Database using Oracle Golden Gate.

Experienced in building Standby databases. Implementing FSFO (Fast start failover) on databases and configuring disaster recovery site using Data guard. Also proficient with new 11g features such as Active Data Guard and Snapshot standby database.

Worked with development teams to implement change management for custom code migrated into environments.

Tuning the databases for optimal performance and monitoring CPU performance

Adept at using tools such as SQL Developer and TOAD for database administration.

Written and scheduled PL/SQL and KORN shell scripts using job schedulers like CRON and Alert Manager.

Transferring compressed files on FTP servers, on UNIX platform.

Expertised in AOL activites, Alerts monitoring and troubleshooting, Workflow configuration and troubleshooting workflow related activites.

Experienced in applying application patches using ADOP,Cloning in 12.2

Implemented JRE certificates in oracle application environments.

Resolved Oracle Applications issues with Forms, Apache, CM, and Workflow.wd on reportingork

Actively worked on reporting tools like Discoverer,OBIEE.

Troubleshooting OBIEE,SOA application performance issues.

Experienced in setting up DMZ environments of E-Business suite.

Expertize in Data Center Migration.

Hands-on experience in Oracle collaboration suite by addition of users,workspace and other administering activites.

Troubleshooting connection related issues with EBS and ODI environments

Experienced in Installation,configuration of Oracle Webcenter portal, Content Management (Imaging, Capture, etc.) and and integrating with Oracle E-Business suite.

Technical Skills

OPERATING SYSTEMS

Windows 98, NT, 2000, 2003, 2008, UNIX, Sun Solaris, Red Hat Linux.

SOFTWARE

ORACLE 9i/10g/11g Oracle Applications 11i/R12 Oracle Collaboration Suite

Oracle 10giAS Oracle Enterprise Manager AD utilities

TOAD SQL *Plus X-windows

BIG IP – F5 VNC viewer SQL Developer

Cacti

Programming languages

C, C++, Core Java, JSP.

Scripting Languages

Shell Scripting,Sql.

Educational Qualifications

B.E in Electronics and Communication Engineering,Anna University,India

Certifications

OCA 11g Oracle Certified Associate

Work Experience

Infinity Pharmaceuticals Cambridge MA- Jan 2015- Till Date

Role:Sr Consultant Oracle Apps DBA

Responsibilities (as Oracle DBA/Oracle Applications DBA)

Worked on performance related issues due to concurrent managers and form related performance issues.

Resolved Oracle Applications issues with Forms, Apache, CM, and Workflow.

Applied patches including thorough Patch analysis.

Resolved configuration issues raised by technical teams.

Performed Administration tasks by using AD Utilities.

Providing support for R12 environments.

Expertised in AOL activites,Alerts monitoring and troubleshooting, Workflow configuration and troubleshooting workflow related activites .

Writing shell scripts and scheduling them in the crontab for monitoring the activites.

Experience on SOA and other weblogic applications.

Experienced in handling Exadata databases.

Data Masking/Data Scrubbing for sensitive data(Payroll related,credit card ) in Non-Production instances.

Installed and configured Oracle Collaboration suite.

Loading data from flatfiles in CSV format to oracle databases by creating tables using SQLLDR.

Experiencing in Troubleshooting PL/SQL packages and procedures.

Installation,configuration of Oracle Webcenter portal, Content Management (Imaging, Capture, etc.) and and integrating with Oracle E-Business suite.

Hands-on experience on Oracle Identity Analytics,Oracle Identity and Access Management product suite comprising products Oracle access Manager 10g/11g,OEG,Oracle Internet Directory.

Tricore Solutions –Norwell MA –May 2013-Dec 2014

Role: Consultant Oracle Apps DBA

Responsibilites:(as Oracle DBA/Oracle Apps DBA)

Experienced in Planning, Installation, Backup and Recovery, Cloning or Refreshing Database and Oracle Applications.

Expert in upgrading Oracle Applications to 11.5.10.2 to 12.1.3 and 11.5.10.2 to 12.2.

Expert in upgrading Oracle Databases 10g to 11g, 10g to 11gR2 for 11.5.10 Instance.

Able to see applications in full context, from end user, to the database, OS and back to the hardware.

Experienced with Disaster Recovery planning, testing and implementation

Works with minimal direction and within a cross functional team.

Experienced in Working as a team, Lead a team or working individually on various projects according to the requirement.

Experienced in planning, coordinating and implementing infrastructure/operational projects in support of business goals and objectives.

Performing Concurrent Manager Setup and trouble shooting.

System Administration of Oracle Apps.

Managed major hardware and database upgrades, database migrations for multiple applications in heterogeneous environments.

Experience in analyzing the model and architecture for the Oracle Database and Oracle Applications implementations.

Role of BI admin as well to perform the installations and configurations of the whole Reporting structure.

Expert in opening up service request with Oracle support and working on it.

Expert in analyzing the upgradation and migration strategies for Oracle Applications and Oracle databases.

Extensive experience in installing/creating Oracle databases and Oracle Applications in RAC environment.

Developed scripts for the various simple to complex DBA tasks (day to day DBA tasks, cloning).

Good experience and knowledge in Oracle Applications system administration such as Managing

Addition of users and provided administrative privileges in Oracle Collaboration Suite

Concurrent Programs and Requests, Configuring Printers, Reports, Administering Concurrent Managers and Work.

Expert in Cloning using Rapid clone and ADCONFIG.

Experienced in handling Exadata databases with size of 4Tb.

Expertise in implementing Shared APPL_TOP and PCP.

Expertise in troubleshooting Workflow mailer Notification Issues.

Experience on SOA and other weblogic applications

Expertise in addition of ASM diskgroups to existing diskgroups.

Expert in Cloning multi node RAC to Single node RAC databases and Non-RAC Databases.

Automated cloning processes using shell scripts.

Handled JVM Memory Issues.

Worked on OEM12c in preparation of database Health check reports and setting blackouts.

Created Multi-node application environment with DMZ configuration

Application of Certificates to oracle applications to avoid warning messages during forms launch.

Handled Projects involved in platform migration from different OS with database sizes in TB.

Worked on Cloning OBIEE,SOA applications and administrating the application related issues.

Data Masking/Data Scrubbing for sensitive data(Payroll related,credit card ) in Non-Production instances

Loading data from flatfiles in LDT,WFT format to oracle application tables in R12 using FNDLOAD,WFLOAD.

Upgraded Oracle Collaboration suite from 10.1.2 to 10.1.4

Experiencing in Troubleshooting PL/SQL packages and procedures.

Handson experience in a conversion or Merger Acquisition environments

Having experience in Financials sector and modules like AR,AP,PAY,GL

Installation,configuration of Oracle Webcenter portal, Content Management (Imaging, Capture, etc.) and and integrating with Oracle E-Business suite.

Enabled SSL on Oracle Collaboration suite 10g.

Added 100 of users and provided read-only priviliges to workspaces in Oracle Collaboration Suite.

Experienced on Workflow configuration and troubleshooting workflow related issues.

Oracle Corporation- Feb 2012 to May 2013 Hiayderabad,I

Role: AIT Consultant-Oracle Apps DBA

Responsibilities (as Oracle DBA/Oracle Applications DBA)

Worked on performance related issues due to concurrent managers and form related performance issues.

Resolved Oracle Applications issues with Forms, Apache, CM, and Workflow.

Applied patches including thorough Patch analysis.

Resolved configuration issues raised by technical teams.

Performed Administration tasks by using AD Utilities.

Worked on SSO/OID related issues.

Providing support for R12 environments.

Expertised in AOL activites,Alerts monitoring and troubleshooting, Workflow configuration and APEX Integration

Writing shell scripts and scheduling them in the crontab for monitoring the activites.

Familiar with Smart Flash cache and Hybrid columnar compression techniques in Exadata architecture.

Enabled IORM for databases.

Applied HR Payroll patches and resolved the syncing issues of user details in the per table

Monitoring the database using OEM 11G.

Data Masking/Data Scrambling for sensitive data(Payroll related,credit card ) in Non-Production instances.

Loading data from flatfiles in CSV,LDT,WFT format to oracle databases,applications using FNDLOAD,WFLOAD and SLQLDR executables.

Modified Usernames or last names in Oracle Collaboration suite.

Added users and provided restricted priviliges to users in Oracle Collaboration Suite.

Created Workspaces and assigned to user groups for easy access of documents in Oracle Collaboration suite.

Dresser Inc- Austin Texas - May 2007-Dec 2011 Hyderabad,India

Role:Database Administrator

Responsibilities (As Oracle DBA):

Upgraded Oracle applications databases from 10.2.0.3 to 10.2.0.4, 10.2.0.4 to 11.1.0.7,

10.2.0.4 to 11.2.0.2, 11.1.0.7 to 11.2.0.2.

Installed and configured Oracle Enterprise manager 10g and 11g.

Applied Patch sets, CPU patches and One-Off patches to 10g/11g homes.

Applied Daylight Saving Time (DST) Patches.

Migrated legacy Oracle 8i Databases on Windows to Oracle 10g on Solaris platform.

Performed schema refreshes from production to test & dev and from Development to

Production using exp/imp and expdp/impdp.

Worked on scripts for creating new schemas, assigning roles and privileges and for

monitoring Tablespace usage, Temp tablespace usage and undo tablespace usage.

Assisted Team in converting core databases to UTF8 character set.

Created Database instances for development and Performed Database refreshes.

Worked on Tablespace alerts, mount point issues, backup failures and ORA- errors in

production as well as development/test environments.

Worked with Oracle Support for Bug fixes by raising TAR/SRs using Oracle Diagnosibility

tools.

Performed Daily Checks and fixed issues related to Oracle Databases, Enterprise

manager and mount point usage.

Worked on various alerts related to Host, agent, database and listener connectivity

issues, resolved blocking locks and DDL and DML locks.

Generating and reviewing AWR and ADDM reports.

Implemented Production Change controls.

Responsibilities (as Oracle Applications DBA)

Cloned Oracle Apps Databases/Environments.

Added new languages to Oracle Applications and applied country specific localizations

Integrated third party applications into E-Business Suite.

Performed RUP patching and upgraded Oracle Apps databases.

Resolved Oracle Applications issues with Forms, Apache, CM, and Workflow.

Applied patches including thorough Patch analysis.

Resolved configuration issues raised by development teams.

Performed Administration tasks by using AD Utilities.

Applied Quarterly release of Oracle Critical Patch Updates to Oracle Application Databases.

Worked on user account management - creating users, disabling users and responsibility management.

Managing concurrent managers -ensure system is running smooth by monitoring throughput and watching for long running requests.

Performed sysadmin tasks as per the requirement.

Copying new forms, reports, custom code to production environment from Development.

Worked on changing passwords of apps, sys, system and specialized users every quarter in TEST, DEV and PROD.

Documented tasks in coordination with onsite team.

Decommissioned Application instances.

Installed new products as per business requirement.

Applied monthly payroll patches and latest vertex payroll update for HRMS Products.

Worked on setting blackouts and monitoring alerts using OEM 10g

Experienced in Oracle collaboration suite by addition of users,workspace and other administering activites.

Contact this candidate