BHAVANI GURUSWAMY (B.S, M.S) Senior Oracle DBA

ac0w7b@r.postjobfree.com Work Authorization - H1B (Start Date : 3rd April 2017 ) Phone : +1-469-***-**** EDUCATION:

MCA - Master of Computer Applications - University of Madras, Chennai. (Nov 1997) B.Sc in Applied Sciences - Thiagarajar College of Engineering, Madurai Kamaraj University (April 1991) TECHNICAL SKILLS:

Relational Databases : Oracle 8i/9i/10G/11gR2, Oracle 12c, Oracle 10gR2/11gR2 RAC DBA, Oracle 10g Data Guard, Exadata Machine Admin, Oracle GoldenGate 12c, Sybase ASE 15.7, EDB PostgreSQL 9.4, SQL Server 2000 Tools: SQL Developer, TOAD 9.7, Sybase Central V6.0, PEM, Pentaho Data Integration, Ispirer Programming Technical: C,C++,Java 1.4, BASIC, COBOL, Visual Basic 6.0 Cloud Computing : AWS - Solution Architect, AWS RDS CERTIFICATIONS: OCP in oracle 9i, OCP in oracle 10g R2, Oracle Certified Expert in 10g R2 RAC PROFESSIONAL EXPERIENCE: 13+ years’ experience as an Oracle DBA with domain expertise in Finance and Insurance. Tech Mahindra Americas Ltd Plano, TX 75093

[Feb 2017 - Present] AIG Cloud Migration Project 2 - AIG, Fortworth, Tx

• Migration of existing Legacy Sybase databases onto AWS PostgreSQL / AWS oracle databases.

• Post migration Data validation using Pentaho BI tool. Data assessment source data for correctness, preparing the system for migration. Handling data type mismatches between source and target.

• Application testing after migration for correctness, performance, quality, data consistency etc

[Feb 2014 - Jan 2017] New Generation BIZFILE - ACRA, Singapore

• Oracle 11gR2 RAC implementation, configuration and administration, Replication set up using oracle Goldengate for critical applications

• Performance Tuning - To comply with business SLA’s. Regular analysis of AWR, ADDM, ASH reports.

• Database security - Restrictions imposed on installation, initialization parameters, oracle net configuration, audit/profile settings, encryption needs, access level restrictions, network assessments, redundancy, mirroring requirements etc

• Testing - Active participation on Application Testing - Load tests, stress tests, endurance tests and functionality tests.

• Documenting the Architecture, Infrastructure Assessment/HighAvailability Testing, BAU Activities, System Configurations etc

[Feb 2010 - Jan 2014] Equity Trading - Fidelity Investments, Boston, USA

• The old Legacy Trading System has been decommissioned and Rebuilt with Latest Technology

• Actively participated in decoupling complex dependencies between Trading databases and FIMT CDE & ODS database.

• Active participation in Core DBA Activities, Set up and Managing RAC Databases

• Replication setup, troubleshooting, maintenance – Materialized view, Golden Gate, Advanced Queues IBM India Pvt Ltd Bangaluru, India - 560 029

[Jan 2009 - Jul 2009] The Hartford, Connecticut, USA

• Knowledge Transfer Process for forming the extended offshore database support team. KT for different divisions of Life oracle database system like GBP, IPD - Individual and Group, HIMCO,HIMCO, International etc.

• Successfully completed KT process and the offshore team started functioning. Production support followed by core database activities carried out at offshore.

[Jun 2008 - Dec 2008] A.P. Moller Maersk, Denmark

• Production support for APPM database servers 9i,10g RAC Databases, Maintenance

• Quarterly CPU Patch upgrade Management,Cloning/refreshes from production to non production environments

• Application Release management -DB upgrades, DB Availability Management – Managing Incidents, Problem Records

[Jan 2006 - May 2008] Fluor Corporation, Irving, Texas

• Oracle 8i/9i/10g Installation Database Creations Maintenance, Production support

• Oracle Version upgrades ( 8i to 9i or to 10g, 9i to 10g ), Performance Tuning of Databases, Backup Management e-Cosmos India Pvt Ltd Bengaluru, Karnataka 560017

[Jun 2003 - Dec 2005] Rubix Information Technologies Inc, USA

• 24 X 7 Monitoring, Maintenance of Production Databases in Solaris

• Managing user access to the database, Performance tuning, Unix/Solaris Shell Scripting for basic maintenance activities

• Setting up Auto startup/shutdown of DBs along with o/s restarts, Space management, Tablespace creation, adding datafiles etc. TEACHING EXPERIENCE: NIIT, Krishnagiri, India

[Nov 2000 - May 2003] Computer Literacy Programme, Government Arts College for Women, Krishnagiri, India

• Computer Literacy Programme conducted by Government to make Tamil Nadu a computer Literate Tamil Nadu

• Training College students on computer basics, BASIC programming language, Visual Basic 6, MS-office, Photoshop etc.