Information Technology Manager
Resume:
Prabu Ch
*****.*****@*****.***
TECHNICAL SKILLS
Operating Systems: Sun Solaris 10, RHEL Linux and Windows 95/98/2000/XP.
Programming Languages: SQL, PL/SQL, MY SQL, Shell scripting, C, C++, Java, HTML, PHP, CSS, XML and Javascript.
Tools/Utilities: RMAN, Exp/Imp datapump, OEM, AWR, Explain plan, Stats pack, TKPROF, opatch, Data Guard, ASM, RAC, Golden gate, SQL Developer, TOAD, PUTTY, ssh, ETL, Datastage, ODI and OBIEE.
RDBMA: Oracle 9i, 10g [10.1.0.2, 10.2.0.3], 11g [11.1.0.6, 11.0.1.7], 12c.
EDUCATION
Master of Science in Software Engineering December 2016
University of Houston-Clear Lake, Houston, TX GPA: 3.88 /4.0
Bachelor of Technology in Information Technology May 2012
Jawaharlal Nehru Technological University, India. GPA: 3.4/4.0
PROFESSIONAL EXPERIENCE
Systems Engineer July 2012 – August, 2015
Tata Consultancy Services, India
Client: Xerox Corporation
Database Administrator
SUMMARY
11g Oracle Certified Associate.
Installation and creation of Oracle Databases on Linux and Windows Plat forms.
Installation and configuration of Oracle Server 11g RAC with ASM on multi node systems, 11g and 10g in different operating systems.
Experience in configuring and troubleshooting Data guard 12c, 11g and 10g for physical standby databases.
Expertise in upgrading and migrating of oracle database to higher version.
Expertise in logical backups, Hot/Cold Backup, RMAN Backups, Recovery and Cloning of databases.
Experience in Performance Tuning by using tools/utilities by Automated Workload Repository (AWR), Automatic Database Diagnostics Monitor (ADDM), Explain Plan, Auto trace, TKPROF and Stats pack.
Excellent in creating/altering partitioned huge tables to speed up the regular queries.
Good experience in applying Critical Patch Update (CPU Patches) on Databases.
Proficient in Database administration activities such as user management, space management, monitoring, creating Database, Managing Oracle Instance and Database security and materialized views.
Automated many common tasks using Crontab including: Backups, exports and imports, archiving old records and verification of such processes.
Actively participated in interaction with users, team lead and technical manager to fully understand the requirements of the system.
Used ODI 11g/12c for extraction, loading and transformation ETL of data in the data warehouse.
Extracted data from different sources like Oracle Tables, views and flat files, Hyperion implemented Business logic and loaded into target warehouse (Oracle).
Trained Developers and Business users in OBIEE and BI Publisher Application and assisted them to generate and create their own reports, dashboards and perform ad-hoc analysis.
Management of 200+ database with sizes ranging from 20GB to 2TB and a mix of single instance/RAC Environments.
24/7 production Database on Call support.
Excellent problem solving skills with strong technical background and good interpersonal skills. Quick learner and excellent team player, ability to meet deadlines and work under pressure.
Contact this candidate