David Chellappa Email & Phone Number

Bear, De, Us

Oak Brook, Illinois

Installing Oracle 11g and 10g across various platforms, both 32 and 64 bit, including binariesAdministering RAC and non-RAC databasesImplementing and administering standby (Data Guard) and Pre-Production databasesUpgrading RDBMS from 10g to 11gCreating shell/SQL/database scripts in Linux for monitoring database growth (tablespaces, segments, extents, etc.), RMAN backup and recoveryExecuting and generating reports relating to Performance and Growth analysisRefreshing instances on a weekly, monthly and bi-monthly basis manually and utilizing RMAN’s Active Duplicate and backup-driven cloningUtilizing Flash Recovery Area to manage ArchivelogsPerformance tuning tasks such as resizing the SGA and PGA, assessing disk utilization by database, checking for database locks, generating AWR reports, etc.Implementing and managing Cold, Hot and RMAN scheduled backups (Full and Incremental)Exporting/Importing schemas using DataPump Reorganizing database storage across various mount points to optimize disk utilization and performance according to Netapp standardsInstalled ASM binaries; created and mounted diskgroups and disks for various database filesInvolvement in Database Migration across environmentsTransitions of non-hosted client databases into hosted environments; server builds according to prerequisitesInstalling and updated RPMs and other environmental parameters according to fresh database installation/upgradesInvolved in assisting Apps DBAs with OATM implementation in 11i and R12 environmentsImplemented and set matrices for OEM 12c (cloud control) 12.0.1.0

• Administered SQL Server 2008 and 2005 databases using Management Studio and Idera’s SQL Diagnostic Manager• Created schemas in Oracle 10g production databases on Red Hat Linux clusters• Monitored clustered Production servers (mostly on Windows Server 2008 and 2003) for performance and hard disk related issues• Wrote and executed shell scripts in Linux for Oracle export and import jobs.• Ran performance monitoring scripts on all Production, Staging and Development instances• Ran ETL jobs relating to Warehouse population and building Cubes on SQL Server• Monitored weekly and daily database jobs for Pending and Shipped Orders, new Customer creation, etc. in a High Availability environment• Set up Backup Schedules in Windows and Linux for SQL Server and Oracle 10g database

Installation and configuration of Oracle 9i and 10g and its patches on both servers and desktopsManaged different kinds of backup, primarily via Export/Import; also took cold backupsMonitoring, using database scripts, and managing databases using tools like Oracle Enterprise Manager (OEM)Creation and management of databases for Data Migration Portal; monitored Migration on a daily basis giving credence to performanceCreated schemas with a view toward creating and maintaining users within said schemaInvolved in migrating from Oracle databases to Sybase Adaptive Server 15; created triggers, indexes and other database objectsInstallation and configuration of VMWare on several machines; creation of virtual images in developmentCreated and restored dump files using export/importPerformed database cloning/refreshingProvided day-to-day technical support for various customers Assisted developers by creating tables, indexes, triggers, procedures and other sundry database objectsInvolved in troubleshooting various issues related to connectivity, performance tuning, database monitoring and securityInstalled and Tested Oracle 10g on several machines in anticipation of upgrading databases for future development projects

Administered Oracle and MySQL databases; installed and configured Tomcat and JBoss web servers; involved in development using Adobe Flex and Flash