Manager (Database Admin)
Manulife Singapore
Skills
SQL Server 2005, SQL Server 2008 Certified MCA, NIE, Administration, Win 2012-2019, Cluster/NLB, Windows OS, IIS, Virtualization (Windows, VMware), Scripting, Back-up, JP-Morgan, Deutsche Bank, Western Union, Microsoft, SQL Database, SQL Server, AlwaysOn, Backups, Troubleshooting, SQL Server 2008R2/2012/2016/2017/2019, HADR, Server Administration, Batch, PowerShell, Python, Net Backup, SQL Safe, Red Gate, SQL LiteSpeed, TSM Backup, Avamar, Veeam, SCOM, FogLight, SQLSentry, AVAIL, Nimsoft, NewRelic, Nagios, Solarwinds (DPA), Database, BBDA(formerly GridApp), Azure, AWS, ServiceNow, Solarwinds, DB2, Oracle to SQL Server, SQL, OS, Storage, stored procedures, Backup, Rendering, database design, data migration, SQL Instances & Clusters, SQL Server Engines, Oracle, Azure Cloud, SQL Server Database Admin, SQL Clusters, SQL Server Engine, DTS, SSIS Packages, back-ups, script, power-shell scripting, DB, SQL Server Instance, SSIS, SQL 2012, Implemented automation, SQL installation, SPI, database engine, SQL Server 2000, 2005 and 2008, Microsoft Premier Customer, SSMS, GUI, SQL Cluster, SQL Server 2000/2005 Production Servers, Vista, Windows/ SQL/ IIS/ SQL, Windows Clusters, SQL Server 7.0/2000
Project history
11/2016
-
08/2019
Manulife Singapore
Key Areas:
Working on installation, configuration, upgrade, migration & administration of SQL Instances &
Clusters
Configure & troubleshoot Mirroring &AlwaysON(HADRON)
Streamlining stored procedures/query, optimizing performance on SQL Server Engines.
Conducting Root Cause Analysis and providing reports
Ensuring SQL Server performance and efficient resource managements
Backup and implementing recoveries as needed
Rendering Hotline support as part of on-call (24X7) rotation
Participating in planning/coordinating & execution of disaster recovery activities/drills
Providing updates on availability, database usage, growth and performance metrics to
organisation's top management
Supervising technical planning and analysis of critical issues to ensure that these are resolved
within SLA
Performing database design and implementation tasks including naming convention CPU, Memory and
physical storage configuration, database export & import, data migration/ conversion and
transition.
Oracle & DB2 data migrations to SQL Server
Highlights:
* SQL Database Migrations to Azure Cloud.
* Implement Backup Solution which saved ~3PetaBytes/Year for major applications.
* DC migration Planning.
* Drove a few cost saving initiatives like:
* Assist in optimizing SQL licences.
* Optimizing usage of SAN storages.
* Identifying underutilized servers & drive consolidation plans.
Key Areas:
Working on installation, configuration, upgrade, migration & administration of SQL Instances &
Clusters
Configure & troubleshoot Mirroring &AlwaysON(HADRON)
Streamlining stored procedures/query, optimizing performance on SQL Server Engines.
Conducting Root Cause Analysis and providing reports
Ensuring SQL Server performance and efficient resource managements
Backup and implementing recoveries as needed
Rendering Hotline support as part of on-call (24X7) rotation
Participating in planning/coordinating & execution of disaster recovery activities/drills
Providing updates on availability, database usage, growth and performance metrics to
organisation's top management
Supervising technical planning and analysis of critical issues to ensure that these are resolved
within SLA
Performing database design and implementation tasks including naming convention CPU, Memory and
physical storage configuration, database export & import, data migration/ conversion and
transition.
Oracle & DB2 data migrations to SQL Server
Highlights:
* SQL Database Migrations to Azure Cloud.
* Implement Backup Solution which saved ~3PetaBytes/Year for major applications.
* DC migration Planning.
* Drove a few cost saving initiatives like:
* Assist in optimizing SQL licences.
* Optimizing usage of SAN storages.
* Identifying underutilized servers & drive consolidation plans.
09/2014
-
11/2016
Sr. SQL Server Database Admin
The Optimum Solution
The Optimum Solution, Singapore
Client: Deutsche Bank
Key Areas:
Worked on installation, configuration, upgrade, migration & administration of SQL and SQL
Clusters
Configuring & troubleshooting Log-Shipping & Mirroring/SRDF
Streamlining stored procedures & query and optimizing performance on SQL Server Engine
Maintaining import/export data using DTS/SSIS Packages
Conducting Root Cause Analysis and providing reports on the same
Ensuring SQL Server performance and memory
Taking back-ups and implementing recoveries as needed
Rendering Hotline support as part of on-call (24X7) rotation
Participating in planning/coordinating & execution of disaster recovery activities/drills.
Implementing script customized checks in Batch/PowerShell/SQL Script to perform organisation wide
validations on SQL Server
Liaising with the Engineering Team for improving existing builds/checks
Providing updates on availability, database usage, growth and performance metrics to
organisation's top management
Supervising technical planning and analysis of critical issues to ensure that these were resolved
within SLA
Performing database design and implementation tasks including design database naming convention
and physical storage configuration, database export & import, data migration/ conversion and
transition.
* Highlights: Automate admin checks & tasks using power-shell scripting & helped to save a few
hundred man-hours.
Client: Deutsche Bank
Key Areas:
Worked on installation, configuration, upgrade, migration & administration of SQL and SQL
Clusters
Configuring & troubleshooting Log-Shipping & Mirroring/SRDF
Streamlining stored procedures & query and optimizing performance on SQL Server Engine
Maintaining import/export data using DTS/SSIS Packages
Conducting Root Cause Analysis and providing reports on the same
Ensuring SQL Server performance and memory
Taking back-ups and implementing recoveries as needed
Rendering Hotline support as part of on-call (24X7) rotation
Participating in planning/coordinating & execution of disaster recovery activities/drills.
Implementing script customized checks in Batch/PowerShell/SQL Script to perform organisation wide
validations on SQL Server
Liaising with the Engineering Team for improving existing builds/checks
Providing updates on availability, database usage, growth and performance metrics to
organisation's top management
Supervising technical planning and analysis of critical issues to ensure that these were resolved
within SLA
Performing database design and implementation tasks including design database naming convention
and physical storage configuration, database export & import, data migration/ conversion and
transition.
* Highlights: Automate admin checks & tasks using power-shell scripting & helped to save a few
hundred man-hours.
11/2012
-
09/2014
SQL Server Database Consultant
The Pythian Group
The Pythian Group, Hyderabad
Key Areas:
Reviewed & improved checklists for activities like upgrades, migrations, disaster recovery,
backup & recovery
Worked on configuration/ Troubleshooting of Log-Shipping
Analysed and troubleshot Blocker Issues and TempDB& DB Space Issues
Recommended improvements in the existing physical and logical architecture of the
database/database Engine and TempDB configuration
Improved performance of the system ad-hoc queries.
Oracle to SQL Data Migration.
Key Areas:
Reviewed & improved checklists for activities like upgrades, migrations, disaster recovery,
backup & recovery
Worked on configuration/ Troubleshooting of Log-Shipping
Analysed and troubleshot Blocker Issues and TempDB& DB Space Issues
Recommended improvements in the existing physical and logical architecture of the
database/database Engine and TempDB configuration
Improved performance of the system ad-hoc queries.
Oracle to SQL Data Migration.
02/2011
-
11/2012
Tech Ops Associate/Engineer
JP Morgan Chase
JP Morgan Chase, Bangalore, Karnataka
Key Areas:
Worked on installation, configuration, upgrade, migration & hardening of the SQL Server Instance
Monitored SQL Instances (Standalone & Clusters)
Maintained import/ export Data using DTS/SSIS packages
Operated on HADRON features of SQL 2012
Implemented automation of SQL installation/patches using tools like BBDA (GridApp)
Developed Batch/PowerShell scripts for certain automation tasks
Created and shared SOPs for the process
Identified and certified new SQL Server releases
Key Areas:
Worked on installation, configuration, upgrade, migration & hardening of the SQL Server Instance
Monitored SQL Instances (Standalone & Clusters)
Maintained import/ export Data using DTS/SSIS packages
Operated on HADRON features of SQL 2012
Implemented automation of SQL installation/patches using tools like BBDA (GridApp)
Developed Batch/PowerShell scripts for certain automation tasks
Created and shared SOPs for the process
Identified and certified new SQL Server releases
07/2010
-
02/2011
Database Manager
SPI India Financial Services
SPI India Financial Services, Mysore, Karnataka
Key Areas:
Recommended improvements in the existing physical and logical architecture of the database/
database engine
Administered the status of the server (OS & SQL) on AWS
Liaised with Developers/Data Team to enhance the process and Management to perform risk analysis
Monitored performance of stored procedures & query
Key Areas:
Recommended improvements in the existing physical and logical architecture of the database/
database engine
Administered the status of the server (OS & SQL) on AWS
Liaised with Developers/Data Team to enhance the process and Management to perform risk analysis
Monitored performance of stored procedures & query
02/2021
-
07/2010
Support Engineer
Microsoft India GTSC
Microsoft India GTSC
Bangalore, Karnataka
Key Areas:
Provided Technical Support for SQL Server 2000, 2005 and 2008 to Microsoft Premier Customer in
EMEA region on installations, configurations, upgrades, migration of stand-alone & clustered SQL
instances
Troubleshot Blocker Issues, issues related to SSMS GUI, TempDB& DB Space Issues and Performance
Issues
Worked on performance monitoring/ tuning of stored procedures & query
Monitored Import/Export Data using DTS
Rendered technical assistance in troubleshooting complex issues related to SQL Cluster,
Performance and memory
Bangalore, Karnataka
Key Areas:
Provided Technical Support for SQL Server 2000, 2005 and 2008 to Microsoft Premier Customer in
EMEA region on installations, configurations, upgrades, migration of stand-alone & clustered SQL
instances
Troubleshot Blocker Issues, issues related to SSMS GUI, TempDB& DB Space Issues and Performance
Issues
Worked on performance monitoring/ tuning of stored procedures & query
Monitored Import/Export Data using DTS
Rendered technical assistance in troubleshooting complex issues related to SQL Cluster,
Performance and memory
07/2007
-
03/2008
Database Specialist
Ascendum Systems Ltd.
Ascendum Systems Ltd., Bangalore, Karnataka
Key Area:
* Provided support for over 1500 SQL Server 2000/2005 Production Servers
Key Area:
* Provided support for over 1500 SQL Server 2000/2005 Production Servers
02/2006
-
06/2007
Software Engineer (DBA)
Vista InfoTech
Vista InfoTech, Bangalore, Karnataka
Client: Microsoft MSIT Hyderabad
Key Areas:
Managed installation, configuration, upgrade, administering & maintenance of Windows/ SQL/ IIS/
SQL & Windows Clusters/ NLBs for Microsoft Organization with a max database size of 3.4 TB
Prepared customized SP for administrative activities
Client: Microsoft MSIT Hyderabad
Key Areas:
Managed installation, configuration, upgrade, administering & maintenance of Windows/ SQL/ IIS/
SQL & Windows Clusters/ NLBs for Microsoft Organization with a max database size of 3.4 TB
Prepared customized SP for administrative activities
01/2003
-
02/2006
Project Coordinator/Technical Head/ DBA
Infoland Technologies
Infoland Technologies Hubli, Karnataka
Key Area:
Install& maintain WIN 2000/2003 Server and SQL Server 7.0/2000
Key Area:
Install& maintain WIN 2000/2003 Server and SQL Server 7.0/2000
Local Availability
Only available in these countries:
United Kingdom
