09/06/2022 updated

KR
100 % available

Sr. SQL Server Database Admin, SQL Server Database Consultant

United Kingdom
United Kingdom
MCA
United Kingdom
United Kingdom
MCA

Profile attachments

CV - Khalid Roshan

Microsoft WindowsAmazon Web ServicesAutomationAutomotive LightingMicrosoft AzureBackup DevicesCloud ComputingComputer NetworksDatabasesData MigrationIBM DB2Database DesignGraphical User InterfaceInternet Information Services (IIS)Problem SolvingPython (Programming Language)System Center Operations ManagementMicrosoft SQL ServersNagiosNetBackupOracle ApplicationsWindows PowerShellNewrelicServer AdministrationShell ScriptStored ProcedureSQL DatabasesSQL Server Integration ServicesDatabase EnginesVirtualizationAlwaysonScriptingAdministrative OperationsSerial Peripheral InterfaceSolarWinds (Software)SQL Server Management Studio (SSMS)Servicing and Car MechanicsVeeamNetwork ServerServicenowVMware
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

Manager (Database Admin)

Manulife Singapore
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.

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.

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.

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

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

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

Database Specialist

Ascendum Systems Ltd.
Ascendum Systems Ltd., Bangalore, Karnataka
Key Area:
* Provided support for over 1500 SQL Server 2000/2005 Production Servers

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

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

Contact form

Log in to get in touch

You need to be logged in to use the contact form.

Sign upLog in