Database Administrator
University Hospital Sharjah
Total years of experience :19 years, 10 Months
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.
• 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).
•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.
• 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.
• 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.
GPA 3.25
-Secured 3.33 GPA -Received 50% scholarship in a semester for scoring 3.75 GPA
-Secured A-Grade (75%) in the Exams -Received an award of Honour from the college on securing A grade in the final exams