Kalyan Palle

E-Mail: aczgvg@r.postjobfree.com / Mobile: 262-***-****

SUMMARY:

Over Eleven years of Experience in Information Technology industry as a Database Administrator

With exposure to Practices and Procedures that includes installation, configuration, administration, migration, upgrade, remote administration and support of Oracle databases on all major Operating Systems

Experience on Oracle, MongoDB, AWS Cloud, MySQL, Hadoop technologies.

Excellent knowledge of Linux, Solaris, Windows operating system, and server processes monitoring, and the interaction between the database and the operating system such as shared memory processes and networking concepts.

Strong learning abilities with keen interest in learning new technologies and best practices with passion to take on challenges to deliver and add value to the clients, good communication and inter-personal skills, accustomed to work in a team environment with tight schedules, and capable of working efficiently under pressure and managing multiple project.

Develop and manage build and release processes and configurations to support daily software development, testing, production builds and deployment operations.

Expertise in performing system administration tasks and change management process for implementation and migration, coordinating with Oracle Corporation Support to resolve issues, and providing 24x7 application support.

Integral part of a Team with Large Global Customers, handling large volume, high availability systems and multiple Databases on various Operating systems on 24*7 support and onsite-offshore

support model.

Administering and maintaining Production, Stage, Development instances 24X7 Production Database Support and maintenance.

SKILL SETS:

OPERATING SYSTEMS: Sun Solaris, HP-UX, Linux Red Hat, Windows

DATABSES: Oracle 9i, 10g, 11g,12c and AWS, Verizon 11g and 12c

ERP: Oracle Applications 11.5.9, 11.5.10

TOOLS: Autodba, OEM10g/12c, Toad, Appworx, Quest Central, Cloud Watch, Chef, Puppet

BACKUP TECHNOLOGIES: HP-BC Backup, VERITAS NetBackup and using custom shell scripts scheduled through crontab, RMAN.

LANG/TECH: Korn Shell scripting, Unix Shell Script

Attainments:

Oracle Database 12c Administrator Certified Professional

Oracle Database 11g Administrator Certified Associate

Oracle Database 11g Administrator Certified Professional

Oracle Certified Expert, Oracle Real Application Clusters 11g and Grid Infrastructure Administrator

PROFESSIONAL EXPERIENCE:

Wissen Infotech

Client: GE Healthcare Apr 2010 to Till now

Role: Lead DBA

Responsibilities (As Lead Oracle DBA):

Worked on 9i, 10g RAC, 11g RAC, 12c RAC and NON RAC databases.

Migrated databases from one cluster to another cluster and Migrated databases to Cloud (Amazon, Verizon)

Clusterware upgrade from 10g to 11g, 11g to 12c.

Experience with Oracle 12c container/pluggable databases.

Created Amazon RDS instances and Established Standards of Operating Procedures to migrate, and manage databases to cloud.

Good experience in Amazon Web Services environment and good knowledge of AWS services like Elastic Compute Cloud (EC2), S3, RDS, VPC, Cloudwatch.

Experience in performing Mongo DBA operational routines.

Cluster\Sharding\Replication maintenance as well as creation and removal of nodes

MongoDB cluster job performance, capacity planning, connectivity and security

Installation and configuration of Oracle Enterprise Manager 10g and 12c.

Applied patches on Oracle 12c/11g/10g Clusterware and RAC databases.

In depth experience in DataGuard, ASM, Golden Gate, Exadata.

Worked on Transparent Data Encryption (TDE), Oracle Data Masking Pack, Strong Protection of Database Backups, Oracle Data Vault.

Extensive experience in Database Backups RMAN (Full/Incremental backups) and in traditional hot/cold backups.

First hands-on experiences in software and firmware maintenance of both the Database and Storage servers in the Exadata database machine.

Solid skills to configure Exadata to meet company internal security requirement.

Greatly improved performance in daily transforms by identifying and reorganizing indexes on major tables and changing performance related parameters in the database.

Extensive experience in configuring and implementing ASM

Experience in logical backups and Database migration tools with datapump, Export/Import and Transportable Tablespaces.

Worked actively on features such as AWR, ADDM, and ASH, performance statistics collection, and fine tuning database wait events.

Created a number of database instances for development, testing and production.

Configure and Register Oracle Database in OID

Applied database patches using Opatch utility.

Coordinated and interfaced with Oracle support for upgrades, certification issues and tars

Wissen Infotech

Client: Dresser, Addison, Texas Feb 2009 to Mar 2010

Role: Oracle Application DBA

Responsibilities:

Configured 10g Cluster on Linux and Solaris environments.

Migrated Oracle Apps database to RAC 10g on Oracle 10g cluster.

Administering Oracle Apps databases in RAC and non RAC environment.

Administering separate Oracle apps databases for ERP, ASCP and CFG.

Cloned ASM environments using RMAN.

Upgraded the 11i databases to 11g (11.1.0.7.0)

Upgraded Oracle developer to 19 patchset.

Implemented latest ATG Rup-7 and native java plug-in in place of J-Initiator.

Administering and maintaining Production Apps 11i instances, 24X7 Production Database Support and maintenance.

Installed E-Business suite single and multi-nodes on Solaris and Linux platforms.

Upgraded E-Business suite application instances from older versions of 11i, 11.5.10 to 11.5.10.2

Applied application patches and merged patches manually

Excellent Knowledge on AD Utilities and their usage.

Starting and shutting down of workflow components through OAM.

Knowledge in parallel concurrent processing.

Purging unwanted request output and log files

Troubleshooting self-service web application issues.

Troubleshooting forms server, Apache server issues

Troubleshooting concurrent manager issues.

Knowledge in Generic Service Management (GSM) and FNDFS.

Performed Sysadmin tasks as per the requirement.

Worked with end users in resolving E-business Suite application issues reported by them.

User account management – creating users, disabling users, responsibility management.

Managing concurrent managers – ensure system is running smooth, monitoring throughput, watch for long runners.

Oracle instance cloning activities and reconfiguration after refresh.

Installation and upgradation of application stack (apache and forms home)

Load balancing across Apache, forms servers.

Application database cloning

oCluster application db to cluster application db

oNormal application db to Normal application db

Wissen Infotech

Client: GE Healthcare, WI Aug 2005 to Jan 2009

Role: Oracle DBA

Responsibilities (As Oracle DBA):

Worked on 10g RAC databases (have enough knowledge on CRS, ASM).

Developed standard for directory structures on new UNIX boxes.

Performed numerous Installations of various versions 9.2.0 and 10.2.0

Performed CRS home and RDBMS home from RAC systems.

Performing database upgrades as part of new releases

Regular database activities, backups monitoring, issue resolving through Remedy

Created a number of database instances for development, testing and production.

Working with VERITAS Net backup Technology to take the hot and cold backups.

Scheduled hot and cold backups using AppWorx Scheduler.

Automated cloning of the Oracle databases using Appworx scheduler.

Appworx chains and modules creation.

Migrated databases between machines.

Installed patchsets and upgraded Oracle (RDBMS).

Applied database patches using Opatch utility.

As a part of Performance Tuning monitor long running form sessions and kill them, fix the chained rows, monitor TEMP tablespace, monitor alert logs for errors, Identify CPU usage in the Middle tier and eliminate them.

Coordinated and interfaced with Oracle support for upgrades, certification issues and tars

Performed number of dev, test and stag cloning from PROD databases.

Performed cross version Instance refreshes.

Performed number of Media recoveries, tablespace and datafiles recovery and point in time recoveries.

Managed tablespaces and other database objects.

Created custom schemas, maintained archived log files

Education Qualification:

B.Tech : Rajiv Gandhi college of engineering and technology (Pondicherry)

Contact this candidate