RESUME Pradeep Anandh nd th SB-08, 2 Floor, Ittena Padma Appartment I, 5 Main, Opp.

to Ramamurthy Nagar Police Station, Uttam Sagar Road, Bangalore 560 016, INDIA
Cell: 0091-988-050-8601, 0091-886-788-9090

[email protected] / www.icthealth.com SUMMARY Over 8 years of Total experience in IT Industry and Looking for ORACLE CORE DBA positions. CERTIFICATIONS AND TRAININGS Oracle Certified Associate (Oracle 9i DBA) November 2003. Brain Bench certified SQL ANSI Professional October 2000. Attended Internal / Inhouse Training for SQL-Server 2005. Attended One Day Training for DB2 9 XML from IBM. ACADEMIC CHRONICLE MCA (Master of Computer Applications), Trichy, Bharathidasan University, 63.14%, 1999-2002. BSc (CS), SASC College, Tiruchengode, University of Madras, 69.84%, 1996-1999. HSC, SPB Higher Secondary School, Erode, State Board, 52.58%, 1996. SSLC, SPB Higher Secondary School, Erode, State Board, 75%, 1994. SOFTWARE EXPERTISE Platforms RDBMS Packages Tools : : : : Linux (RHES 4, 5, 6), Oracle Linux (5,6), Oracle VM, Solaris 10 Oracle (7.3, 8i, 9i, 10g, 11g), SQLServer, Mysql, Postgres MS-Office 2003, 2008 SQL*Plus, SQL*Loader, TOAD, Shareplex, Smart DBA, Foglight, DB Flash, Veritas, Big Brother, Legato Networker, TIVOLI, AVAMAR, PL/SQL Developer, VSS, SVN PROFESSIONAL ACHIVEMENTS From ICT HEALTH Got Dedicated Employee of the Year Award. From SRIT Got 6 Appreciation Letters for Successful Implementation. From NOUS Got 5 Appreciation Letters for Best Performer. From WebEx Got 12 Appreciation Letters for outstanding performance. From Oracle Oracle Certified Association 9i DBA (OCA). From Brain Bench Brain Bench certified SQL ANSI Professional.

Pradeep Anandh G S < Technical Lead Database Services, ICTHEALTH, Bangalore > Page 1 of 7

RESUME PROFESSIONAL EXPERIENCE Working as Technical Lead Database Services from February 2010 Till Now for ICT Health Technology Services India Pvt. Ltd., Bangalore, INDIA.

Responsibilities 1. Successfully Implemented ORACLE RAC 11203 on Linux X86_64 bit architecture with 2 Nodes. 2. 3. Working Knowledge of Amazon Cloud (EC2 Instances, RDS, Non RDS, VPC). Implemented Active Data guard using RMAN Auxiliary in 11201 in Production Environment. 4. Successful Implementation of Oracle Applications(Oracle Apps) 12.1.3, which involves Software Installation, Patching, Cloning of DB and Application and DB Maintenance. 5. Handled In-house HINAI Application deployment in Load Balancer Environment on RHEL Environment, Oracle Linux Environment. 6. Oracle PRM Administrator currently handling the Relationship between Oracle and our Company. 7. 8. 9. 10. 11. 12. Expertise in SQL Tuning, Performance Tuning. Knowledge in AVAMAR tool for Oracle backups scheduled, also using CLI. RHEL Currently handling OS Administration. VM Having Practical Knowledge on Configuring VMWARE and Oracle VM. Expertise in SQL tuning and DB Performance Tuning. Created EMDEDDED software (Hinai Enterprise, Hinai Standard), using Shell scripts. This embedded is combining Oracle DB and our In-house Application as a single Installer. 13. 14. Installation of Oracle Web logic 12c. Installation of Oracle BI 11g R1.

Worked as Senior Database Administrator from July 2006 Jan 2010 for Sobha Renaissance Information Technology, Bangalore, INDIA.

Responsibilities 1. Gone to Indian Forest Research (IFRIS), Dehradun, INDIA, to deploy Oracle Database in the Datacenter Server Farm. Its like one of the E-governance Project, which is successfully running in Live. Used Oracle 10204 in IA-64 bit Environment with HP Service Guard Cluster.

Pradeep Anandh G S < Technical Lead Database Services, ICTHEALTH, Bangalore > Page 2 of 7

RESUME 2. Remotely implemented Oracle LDAP and Oracle Advanced Security Feature Proxy User settings done at Botswana, South Africa and regular Oracle Installation, DB Creation (10202) in 64 bit Environment which is in OS Clustering. Implemented through Shell Scripts and made the DB as a complete Automation. And Giving Remote support too. 3. Gone to SGPGI, Lucknow, INDIA to deploy the Oracle Database, with the Data Center (DC) Site and the Disaster Recovery (DR) Site. Used Oracle 10202 in 64bit Environment with OS Clustering in DC and implemented manual Fail-over and Fail-back in the DR. Implemented Data Guard Physical. Its working fine in Live. 4. Remotely supporting our Billing Components Telecom Application in Germany, doing the routine DBA activities and mainly involved in DB Deployments and Supporting Clients. Runs in Sun and HP, Supporting Development Database as well. 5. Remotely given support to BSNL, Trichy (South Zone) for our Deployment of our Product Interconnect Billing. Suggested the Backup Solutions for our Database Size around 4 TB, but TCS are taking care of all DBA activities. 6. Remotely Done Migration for our CRM Application from US Sun Server 8 to ISRAEL Sun Server 10 Oracle 9201, Implemented Automation of DB using Shell Scripts. 7. Remotely Deployed our HIS application in Assalam International Hospital, Cairo, Egypt in Windows 2003 Server Oracle 10203. Implemented Data Guard Physical. 8. Remotely Deployed and Maintenance of our RCONSTRUCT product DB in RHAS4 Oracle 10202 at ETISALAT Afghanistan. Implemented Automation of DB using Shell Scripts. 9. Gone for Deployment and Maintenance of our RCONSTRUCT product DB in Windows 2003 Server Oracle 10202, Implemented Oracle Failsafe 3.3 at MFAR Constructions Bangalore Client. In RHAS5 Oracle 10203 at Confident Group Bangalore Client. In RHAS4 Oracle 10204 at Sobha Developers Bangalore Client. 10. Gone for Deployment setup of our OSI - NetXpert Application in VSNL Mumbai, INDIA. 11. 12. Implemented Streams Replication in TEST Environment, not yet went to Live. Gone for System Study at Indonesia Jakarta, PLN Electricity Project, regarding DB sizing and for CRM Applications. 13. Gone for Implementation at Welcare Hospital LLC, Dubai for Oracle Installation, DB Creation (10202) in 64 bit Environment which is in OS Clustering. Implemented

Pradeep Anandh G S < Technical Lead Database Services, ICTHEALTH, Bangalore > Page 3 of 7

RESUME through Shell Scripts and made the DB as a complete Automation. And Giving Remote support too. 14. Gone for Implementation at ABMH, Pune for Oracle Installation DB Creation (9204) in 32 bit Environment which is in OS Clustering. Implemented all Security things through Shell Scripts and made the DB as a complete Automation. And Giving Remote Support too. RMAN Backups using IBM Tivoli. 15. Working in OS Cluster Environment and Handling Production DBs and Development DBs and giving support to all onsite clients in Jordan, Thailand, and Dubai. 16. Applying Patches / Upgrading Database (Both Production and Development).

Worked as Senior Database Administrator from November 2005 June 2006 for NOUS Infosystems, Bangalore, INDIA. Responsibilities 1. 2. Team Member, IS DBA Gave Support to Toshiba TEG, Germany. Monitoring the Production Database Size around 300GB, in Solaris and OS Cluster Environments. 3. 4. Worked in Night Shifts and complete Oncall rotations. Monitoring applications (Oracle 11i) and other network stuffs using Big Brother Tool. 5. Based on the Users request, generating the Trace Files using TKProf in the development and the Production Environments. 6. Worked in OS Cluster Environment and Handled Production DBs and Development DBs. 7. 8. 9. 10. 11. 12. Applied Patches in APPS Environment (Both Production and Development). Deployment Member, DBA Gave Support to Bay Area, USA. Database setup in Red Hat Linux AS4 and Monitoring the Production Database. Configured Shell Scripts for Monitoring the Database and Backup (Disk). Migrated Database from Oracle 8i to Oracle 10201. In both the clients, the database backups are through OS Snapshots.

Worked as Database Administrator (Global Technical Support) from December 2004 October 2005 for WebEx Communications Inc., Bangalore India.

Pradeep Anandh G S < Technical Lead Database Services, ICTHEALTH, Bangalore > Page 4 of 7

RESUME Responsibilities 1. Team Member, Technical Engineering Operations Group and Recovery

Management Team. 2. 3. 4. 5. 6. Handled More than 80 Production DBs for Deployment and Maintenance. Played a vital role with Migration / Deployment in Solaris Environments. Handled 6 TB Web Conferencing DB - Based on Geographical Support. Fine-tuning of the Database, including Memory (SGA), I/O and Application. Maintenance of Oracle Database on the Production systems. Constantly monitoring the performance (V$ dynamic Performance views at peak load) of the databases, View Alert Logs and Trace Files. 7. 8. Identify areas to improve Oracle response time, Monitoring File I/O. Creation and Maintenance of Database Links and Snapshots for providing point in time Representation of Data and Maintaining Transactional Consistency. 9. To schedule Database Reorganizations (Defragmentation) In order to keeps the database running smoothly. 10. Attending to day-to-day problems in the Oracle database and taking suitable actions for trouble shooting. 11. 12. 13. 14. Identifying PL/SQL objects that need to be pinned. Getting the detailed Information of the package, package body. Analyzing and monitoring UTLBSTAT and UTLESTAT and taking Report.txt. Checking Row chaining, analyzing tables and Indexes with compute statistics on every week. 15. 16. Identifying corrupted Table data and Index data. Using SQL AREA and SQLTEXT to identify poor performance statements and suggesting better ideas to improve the performance. 17. Determined the access path with plan table and optimized the queries to improve the rank of access path by adding proper hints and rearrange the queries. 18. 19. Using Hints for query to overwrite existing path in the particular statement. Arranging data files and log files in different paths for to improve the performance and for precaution measure. 20. 21. Using CRON for scheduling Backups for 24*7 operations. Periodical Monitoring of database performance using UTLBSTAT and UTLESTAT and tuning the database for best performance. 22. Analyzing the execution plan for SQL queries using EXPLAIN PLAN and AUTOTRACE utility and creating necessary indexes to improve the response time. 23. Monitoring the instance statistics from V$ROWCACHE, V$LIBRARYCACHE, V$SYSSTAT, V$FILESTAT.

Pradeep Anandh G S < Technical Lead Database Services, ICTHEALTH, Bangalore > Page 5 of 7

RESUME 24. 25. Installation of Oracle Servers, Clients. Configuring Stand by Database, Basic Replications (Materialized View, Updateable Snapshot). 26. Enrolling users and managing system security.

PERSONAL PROFILE Date of Birth Gender Nationality Marital Status Languages Permanent Address : : : : : : Tuesday, July 03, 1979 Male Indian Married Sourashtra, Tamil, English, Kannada Pradeep Anandh G S S/o Madurai, Sekar G Pandurangan SB-08, 2nd Floor, Ittena Padma Appartments Opp RM Nagar Police Station, Ramamurthy Nagar Bangalore 560016. Karnataka, INDIA. REFERENCES Ashok Dash General Manager Oracle Practice ICT HEALTH Technology Services India Pvt. Ltd. Tirumala Tech Part, Plot No. 27, st nd 1 Cross, 2 Phase Doddanekundi Industrial Area Whitefield Road, Bangalore 560048 Phone: 0091-804-252-2800 Mobile: 0091-968-600-8080, 0091-95-3505-5853 [email protected]

OTHER REQUIRED DETAILS Education Total IT Experience Communication Preferred Location On Call Support Current CTC Expected CTC : : : : : : : MCA (Correspondence) and BSc (Computers) Regular. 8 Years. Fluent English Speaking and Writing Skills. Bangalore, Tamilnadu inside India, Anywhere in the World. Yes, Ready to Work in any kind of Shifts. 14.5 Lakhs / Annum. At the time of discussion.

Pradeep Anandh G S < Technical Lead Database Services, ICTHEALTH, Bangalore > Page 6 of 7

RESUME Notice Period : 1 Month. Already mentioned in the First Page of my Resume.

Education Percentage :

Pradeep Anandh G S < Technical Lead Database Services, ICTHEALTH, Bangalore > Page 7 of 7