09/06/2022 updated
KR
100 % available
Sr. SQL Server Database Admin, SQL Server Database Consultant
United Kingdom
United Kingdom
MCAMicrosoft WindowsAmazon Web ServicesAutomationAutomotive LightingMicrosoft AzureBackup DevicesCloud ComputingComputer NetworksDatabasesData MigrationIBM DB2Database DesignGraphical User InterfaceInternet Information Services (IIS)Problem Solving
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
Experience
Professional experience10+ years
Languages
EnglishNative speaker
Project history
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.
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.
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.