• Primary ORACLE/MSSQL database administrator for government agencies.• 24/7 Standby support for all DB related activities including SQL query performance tuning and migration.

System Engineer for Singapore Government - Land Transport Authority (LTA).Manage both LTA application support and database support.

• 2 member DBA team managing Oracle, DB2, MSSQL, HANA and MAX databases.• Primary DBA for Oracle and MSSQL databases.• Configuring, Managing, Upgrading, Restoring Oracle/DB2 Databases.• Installed ITM Agent Monitoring for DB2 databases.• Performed RMAN refresh for full Oracle database from production backup.• TDP Upgrade for TSM in Oracle,DB2 and MS SQL databases.

Mphasis Ltd., India, April 2013 – January 2015Spl Senior Infrastructure EngineerSouth West Hub (Leveraged Clients) - Highlights Supported 14 leveraged Clients with databases from 9i to 11g including RAC, ASM and OEM. Primary DBA for 4 clients and provided on-call support. Worked on VERITAS cluster nodes and Oracle Streams. Successfully created 10 oracle databases in Linux servers and configured RMAN backup in HPDP. Upgraded production database from 9i to 11gR2 manually without any data loss on time in Solaris. Monthly RMAN refresh and traditional export/import for secure tables in 1.3TB production to test database. Reviewed and implemented several performance tuning measures and achieved significant improvement inapplication, query and database performance. Re-created standby database for 4-node RAC manually as DR using RMAN. Configured and managed databases in 11g OEM. Migrated 9i database about 1.3 GB using RMAN recovery without any data loss within 48 hours and won appreciationfrom clients. Won Summit Award for successful production live DR drill activity. Conducted training sessions to team members on Backup and recovery, OEM configuration. Won Recognition Award for conducting training program to Fresher’s team. Generated Oracle Streams Latency Report which was nominated for Innovation award and presented to MphasisKnowledge Management Team.

Merck & Co. - Highlights Managed/Carried out day to day database administrative activities for a wide variety of databases which included Oracle 9i, 10g, 11g, RAC and EXADATA databases. In addition to that around 2000 databases were monitored through Oracle Grid control (OEM).. Performance tuning of poorly performing SQLs and Analyzing load performance on a daily basis. Achieved 100% SLA in all the incidents and service requests. Improved the overall database performance by 40% by carrying out database parameter changes, query tuning, partitioning tables, index rebuilding and table coalesce. Accomplished full RMAN database recovery of 500MB to 1 TB databases with zero data loss. Reduced the cost of data storage significantly by carrying out various space optimization measures and reclaimed 20-40% space by reorganization, compression, tablespace coalesce, shrinking data file, archival and purging of historical data. Reviewed and enhanced database security measures by implementing database firewall, password management policy, user roles and privileges, scripts to identify suspicious activity and auditing. Code Migrations to DEV ->TEST->PROD and performing Export and Import of Schemas and Tables. Performed quarterly patching of databases. Reviewed the patch release, evaluated the risks and tested in development databases before applying in production systems. Reviewed backup strategy and carried out routine Disaster Recovery exercises to ensure fool proof and efficient recovery of database in accordance with the SLA's. Created 10g and 11g databases including ASM and RAC. Created and Rebuilt Indexes, Partitioning and created materialized views and refreshed. Scheduled backup/monitoring jobs in OEM including ASM and RAC instances. Upgraded databases from 9i to 11g and 10g to 11g manually. Managed Data guard physical standby/failover databases. Established and managed user access, design and implement user environments.