Syed Omair Ilyas PMP, Database Administrator

Syed Omair Ilyas PMP

Database Administrator

University Hospital Sharjah

Location
United Arab Emirates - Sharjah
Education
Master's degree, Finanace
Experience
20 years, 9 months

Share My Profile

Block User


Work Experience

Total years of experience :20 years, 9 months

Database Administrator at University Hospital Sharjah
  • United Arab Emirates - Sharjah
  • My current job since August 2012

MSSQL Database Administration Aug. 2012 to Date

• Administration, maintenance and trouble shooting of MSSQL Databases.
• Installation of new DB servers using MSSQL 2008 R2.
• Security management of all the databases.
• Ensuring high availability of databases by implementing log shipping and mirroring.
• Conducting Disaster recovery exercises.
• Planning and implementation of proper backup strategies.
• Database Performance Tuning, maintenance plan for consistency checks.
• Tuning Queries and Database performance using tools SQL Profiler, Query Analyzer, Database engine tuning advisor etc.
• Patch management.

Cache Database Management (Proprietary database of InterSystems for TrakCare HIS)

• Patch management.
• New Environment creation and refresh.
• User creation and rights management.
• Performance monitoring.
• Backup planning and scheduling.

Senior MSSQL DBA at emiratesnbd bank
  • United Arab Emirates - Dubai
  • My current job since June 2011

• Administration, maintenance and trouble shooting of 100 + MSSQL DB servers with 200 + databases.
• Installation of new DB servers on either 2005 or 2008R2 depending upon the user’s need.
• Patch management based on MBSA report.
• MSSQL servers hardening for security reasons.
• Monitoring the performance of DB servers and DBs through alerts.
• Clusters management.
• Performing routine DR activities by shifting the instance to DR site and then the application connects for live transactions to DR site for few days.
• Database Performance Tuning, maintenance plan for consistency checks.
• Tuning Queries and Database performance using tools SQL Profiler, Query Analyzer, Database engine tuning advisor etc.
• Automated Backup jobs for centralized servers.
• Automated log files backup / Re-Indexing jobs.
• Running DBCC, and fixing data corruption in user databases.
• Failure Diagnosis (Database failures, Physical server failures, Server service failures).

Database Administrator / T24 Application Administrator at Silkbank (formerly Saudipak Commercial Bank)
  • Pakistan
  • October 2007 to June 2011

•Experienced with installing 2 - node SQL Fail over cluster for 4 different production servers.
•Providing primary DBA support to developers for various levels and privileges.
•Import/Export of Data to/from SQL database.
•Involved in entire life cycle including database design, development, testing, optimization and deployment on development and production servers.
•Acted as a Production and development support DBA for 24 * 7 critical 15 Production and Test servers.
•Database Performance Tuning, maintenance plan for consistency checks.
•Tuning Queries and Database performance using tools SQL Profiler, Query Analyzer, Database engine tuning advisor etc.
•Database Shrinking.
•Involved in creating Schemas, Logins, Tables, Clustered and Non-Clustered Indexes and Triggers.
•Experienced with configuring log shipping for backup purpose
•Administering the MS SQL server by creating user logins with appropriate roles, dropping of logins, monitor the user account.
•Involved in implementation of replications like mirroring, snapshot and transactional in production environment.
•Created and monitored Database maintenance plans for checking database integrity and automated backups.
•Maintaining MIS server having different databases of more than 300 GB of size.
•Implemented the SQL login security for developers and other critical servers on SAN (Storage Area Network).
•Created DTS packages to pull data from all branches to central server.
•Automated Backup jobs for centralized servers.
•Automated log files backup / Re-Indexing jobs.
•Running DBCC, and fixing data corruption in user databases.
•Failure Diagnosis (Database failures, Physical server failures, Server service failures).
•Protection against Threats and Attacks.
•Development of Triggers.
•Environment: Administration and management of full range of IBM x series servers with Windows 2008 R2, 2003 Enterprise operating systems with MS SQL Server 2000-2005/ TSQL, Phoenix.

Database Administrator at Alpha Adhi Securities (Pvt) Ltd
  • Pakistan
  • August 2005 to September 2007

• Daily Backup restoration of Oracle 10g on AIX platform.
• MSSQL backup management.
• Installation of new MSSQL and ORACLE database servers.
• Troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, access and security issues.
• Troubleshooting SQL Server related CPU, memory, I/O, disk space, system processes, services and other resource contentions
• Database shrinking operations, DBCC analytical commands, Clustering, Database Mirroring, Replication, and Log Shipping.
• Storage and Capacity Planning.
• Restoration of backups.
• Extraction of data through DTS packages.

Banking Application support / Assistant DBA at Saudipak Bank
  • Pakistan
  • July 2004 to July 2005

• ATM (Phoenix) administrator.
• Phoenix server management/maintenance.
• Phoenix user management.
• MSSQL 2000 backup management.
• Providing DBA support to branches running the banking system on MSSQL 2000 server.
• Extraction of data through DTS packages.
• Adding new hosts.
• Phoenix test server for testing purposes.
• Phoenix Backup Management.
• LINUX administration.
• Monitoring the Phoenix interface and provide support to branches
• ATM Card production and management using ACCESS card management system
• Involved in major Banking related I.T. operations.

Education

Master's degree, Finanace
  • at IQRA University
  • August 2007

GPA 3.25

Bachelor's degree, Computer Sciences
  • at IQRA University
  • December 2003

-Secured 3.33 GPA -Received 50% scholarship in a semester for scoring 3.75 GPA

Diploma, Computer Sciences
  • at APIIT
  • December 1999
High school or equivalent, Sciences Pre-Engineering
  • at Govt. National College
  • August 1998

-Secured A-Grade (75%) in the Exams -Received an award of Honour from the college on securing A grade in the final exams

Specialties & Skills

SQL Server 2000 2008
Disaster Recovery
VMware ESX
hardware/networks
Routers and Switches
Windows2003 Server
Windows 2008 R2

Languages

English
Intermediate
Russian
Beginner

Memberships

PMI
  • PMP
  • August 2016

Training and Certifications

PMP (Certificate)
Date Attended:
August 2016
Valid Until:
August 2019
VCP DCV (Certificate)
Date Attended:
June 2016
Valid Until:
June 2018