Oracle 9i/10g/11g/12c
Saikishore Chitikeshi
Rancho Cordova,CA
Summary
13+ years of experience working as a Database & Application Administrator supporting both OLTP and OLAP systems across multiple platforms. Engaged in installations, upgrades, integrations, production support, development support, monitoring, maintenance, performance tuning, troubleshooting of corporate applications like Oracle E-Business suite (11.5.10.X and R12.X.Y) and supported AWS migration for Oracle Core databases and Oracle E-Business suite. Experienced in supporting Mysql ,Cassandra and PostgreSQL databases. Proactive in taking ownership and accountability of duties and responsibilities. Served as a focal point to communicate and resolve issues. Adaptable to new technologies and architectures to work independently in a rapidly changing environment Detail-oriented, organized and meticulous employee. Works at fast pace to meet tight deadlines. Enthusiastic team player ready to contribute to company success.
Overview
14
14
years of professional experience
2
2
Certifications
Work History
Sr Software Engineer
Arcean Solutions
09.2019 - Current
- Part of Core team for Oracle related technologies (E-Business Suite, Exadata, Agile, Siebel, OBIEE, Apex/Rest services, Discoverer)
- Independently lead DBA Team in Infrastructure projects
- Point of contact and accountable for all activities, issues, and projects
- Involved in Build, Run and Operate phases of projects involving Oracle technologies
- Written several scripts in SQL and Unix Shell monitor for automation of database monitoring and maintenance activities
- Upgraded and migrated databases and applications between data centers and Operating Systems
- Resolved several critical performance issues during ERP upgrades
- Prepared continuity and compatibility plans for all applications (ERP, Agile etc.,) and Exadata
- Quickly learned new skills and applied them to daily tasks, improving efficiency and productivity
- Supported application team in eprentise Installation
- Engineered in migrating Oracle/Mysql/Postgres databases and Oracle E-Business Suite databases to AWS
- Experienced in upgrading RDS databases to latest version in AWS
- Implemented Oracle E-Business Suite database upgrade from 12.1 to 19c.
ValsaTech Corp MD
04.2015 - 08.2019
- Worked on implementations, upgrades, release and change management of Oracle E-Business suite and ORMB with databases on RAC
- Assisted team in performing 9i to 11g Oracle RAC Database upgrade
- Stabilized environment, fixing performance and configuration issues post upgrade
- Identified and prepared Standard Operating Procedures for regular tasks
- Diagnosed software issues and applied troubleshooting techniques to resolve problems
- Performed Capacity Planning and lead Database Reorg activities
- Implemented Encyrption in data and transit for Oracle Core Databases and Oracle E-Business suite Databases
- Migrated Oracle Standalone database to RAC 2-node Cluster
- Upgraded Oracle E-business suite from 11i to 12.2.
Consultant Oracle Apps DBA
Tricore Solutions
Hyderabad, India
05.2013 - 03.2015
- Cloned Oracle Applications 11i on RAC/Non RAC environments
- Written scripts to monitor alert log for ORA- errors, LDAP trace for SSO issues
- Fixed performance and configuration issues related to Oracle Enterprise Manager 10g/11g
- Performed sysadmin tasks and migrations
- Provided Shared support for multiple projects
- Upgraded Oracle Applications from 11.5.10.2 to 12.1.3 and 11.5.10.2 to 12.2.3(Multiple Projects)
- Worked on Disaster Recovery planning, testing and implementation
- Experienced in planning, coordinating and implementing infrastructure/operational projects in support of business goals and objectives
- Analyzed upgradation and migration strategies for Oracle Applications and Oracle databases
- Installed Oracle RAC databases and Oracle Applications
- Handled Exadata databases with size of 4Tb and worked on Hybrid Columnar compression and Smart Flash Cache in Exadata
- Implemented Shared APPL_TOP and PCP configuration
- Troubleshooted and resolved Workflow mailer Notification Issues
- Managed ASM disk groups in addition and partitioning raw disks
- Configured Multi-node application environment with DMZ/External configuration
- 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
- Loading data from flat files in LDT, WFT format to oracle application tables in R12 using FNDLOAD and WFLOAD
- Migrated Non-ASM To ASM Databases
- Played as a Lead for Oracle application Upgrade from R12.1.3 To R12.2.3.
AIT Consultant
Oracle Corporation
Hyderabad, India
02.2012 - 05.2013
- (as Oracle DBA/Oracle Applications DBA)
- Troubleshooted Oracle Applications issues with Forms, Apache, CM, and Workflow
- Performed Administration tasks using AD Utilities
- Worked on SSO/OID related issues, de-registering and regsitering sso after clone
- Handled AOL activities ,Alerts monitoring and troubleshooting, Workflow configuration and APEX Integration
- Expertized in Smart Flash cache and Hybrid columnar compression techniques in Exadata architecture
- Enabled IORM and smart scan for Exadata databases
- Applied HR Payroll patches and resolved the syncing issues of user details in the per table
- Monitoring the database using OEM 11G
- Created Custom patches and applied.
Oracle Database Administrator
Wissen Infotech Pvt Ltd
Hyderabad, India
05.2008 - 12.2011
- Administered, supported and monitored databases by proactively resolving database issues and maintaining servers.
- Wrote and maintained technical and functional specifications to document database intentions and requirements.
- Built databases and table structures for web applications.
- Defined hardware requirements and planning storage capacity to manage systems and infrastructure.
- 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 table space 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
- 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 activities
- Experienced in Administration of 11.5.10.2 Oracle Applications
- Provided resources and skill sets to support DBA functions for applications.
- Proposed database changes to ease monitoring and administrative effort.
Education
B.E - Electronics and Communication Engineering
Anna University
Skills
Oracle E-Business Suite
AWS Migration
Data analysis
Report generation
Certification
OCA 11g Oracle Certified Associate
Software
Oracle E-Business Suite 11g/R12
Oracle Apex/Rest/ORDS
Oracle Discoverer 10g/11g, Oracle REST API
Timeline
Sr Software Engineer
Arcean Solutions
09.2019 - Current
ValsaTech Corp MD
04.2015 - 08.2019
Consultant Oracle Apps DBA
Tricore Solutions
05.2013 - 03.2015
AIT Consultant
Oracle Corporation
02.2012 - 05.2013
Oracle Database Administrator
Wissen Infotech Pvt Ltd
05.2008 - 12.2011
B.E - Electronics and Communication Engineering
Anna University