Terence N

Database Administrator - 6 Years of Experience


Database Administrator

Education Level:


Will Relocate:



Professional Summary I have Six years of extensive experience in Oracle Database Administration performing Installation, Configuration, Migration, Upgrades, Backup and Recovery, Cloning, Replication, Database Security, Memory Management, Data Modeling, Performance Monitoring and Tuning, Patching, RAC, Data Guard and Grid Control. * Supported 10g, 11g and 12c databases running on various platforms like RHEL 2.1, 3.x, 4.x, 5.x., 6.x, Linux Enterprise Server 9, 10, AIX 5.1, 5.2, 5.3, 6.1, SQL-server, Windows 95/98/NT/2000, HP-UX 10.x, 11.x. Sun Solaris 2.5, 2.6, 8, 9, 10. * Good communication and cooperation skills with an aptitude to learn quickly, with a great ability to work under pressure. * Proactively monitoring database health and taking preventive actions using alert scripts and OEM grid control for database uptime/downtime state. * Automated many regular tasks like Backups, exports and imports etc. using crontab and AutoSys. * Local and remote administration and support of Oracle production and development Databases. * Experience in Identifying performance bottlenecks on high volume transaction systems, analyze of SQL statements and design indexes to improve response of queries. * Upgrading and migrating Oracle 10g to 11g RAC Databases running on legacy infrastructure to Oracle 12c Pluggable Databases running on the latest platforms. * Migration of non ASM to ASM database. * Performing Fault Injection Test Cases for verifying High Availability at each layer of RAC stack like port, instance, ASM and Node failover. * Applying PSU, CPU, SPU Patches and One-Off Patches. * Successfully installed and configured a 3 nodes RAC on a development, UAT and production environment. * Troubleshoot and Resolved RAC issues like Node Eviction, OCR related issues, rebooting of faulty nodes and relocating the switched over services. * Worked with developers to resolve different RAC related issues: hangcheck timer, split brain, huge pages setup etc. Troubleshooting performance issues for the RAC instances (GC events) * Installed and Configured Data guard for Oracle Disaster Recovery and Performed switchover/switchback from primary database to standby database for testing purpose for the application teams when required. * Successfully implemented physical standby database in an Active Data guard configuration for disaster recovery in a RAC environment. * Design and implementation of Backup and Recovery strategies (both cold and hot backups) and performing periodical backup, restoration and recovery using RMAN (full and incremental) * Testing and implementing different physical and logical backup and recovery methods including point in time, media recovery, full/partial, and Data Pump export/import. * Experience with tertiary backup storage such as VERITAS NetBackup and IBM Tivoli Storage Manager. * Used EXPDP & IMPDP to take backup at database, tablespace and table level. * Installation and configuration of Golden Gate for bidirectional data replication. * Automated the monitoring of Data Replication in Oracle Streams and Golden Gate processes and heart beat. * Experience in configuring and implementing ASM and proficiency in using ASMCMD and ASMLIB. * Involved in the technical design, development, system integration, quality assurance and production support activities of System Development Life Cycle (SDLC). * Installation, configuration, upgrades, maintenance and performance optimization of PeopleSoft 9.2 database environment (FIN, CRM and HR). * Installation and Configuration of Oracle 12c Multitenant container and pluggable databases with Flex Cluster and Flex ASM. * Using partitions for large tables and bitmap indexes for the OLAP databases. * Extensive experience with Database Cloning and Refreshing pre-prod/dev databases with production data. * Experience in implementing enterprise databases on enterprise Storage Solutions using Storage area Networks (SAN) /Network Attached Storage (NAS). * Proficient in Database Design (Physical and Logical Database Design) and Normalization. * Experience in Extracting, Transforming and Loading (ETL) data using SQL loader utility.