Ghazanfar Ali Rafiq

I am an Internationally Certified Database Administrator since 2010 and working as Programme Manager Core Database Administrator and is responsible for the implementation, configuration, maintenance, and performance of critical SQL Server /oracle database systems and ensure the availability and consistent performance of various corporate applications.

Database Administrator

• Implementation, Management and Maintenance of SQL databases
• Performance Monitoring and Tuning of Databases
• Routine Maintenance including Log Management and Monitoring
• Developing recovery procedures for each database
• Managing Database Users and Security
• Supporting Development Teams with RDBMS related Issues
• Monitoring performance and managing parameters to provide fast responses to end users
• Maintain documentation and procedures to ensure adherence to database / data storage / data backup policies, procedures and regulations
• Controlling access permissions and privileges
• Understanding of ETL process
• Provide required database management, operations, and support and upgradation capabilities for the Teams
• Incorporate changes in database structure by following proper change control mechanism.
• Installing and testing new versions and upgrades of the DBMS
• Selection and Implementation of the appropriate Business Intelligence Solution for the organization which can be integrated with all “off the shelf” and “customized IT Systems” used in the organization.
• Arrange configuration of proper dashboards and reporting for the management.
• Reports development, SQL Query Optimization

Backup Operations
• Management, Monitoring and Maintenance of Backup and Storages Devices
• Establishing standards and schedules for database backups
• Ensuring that the backup schedules meet the recovery requirements
• Keeping proper record of all database backups
• Ensure the availability of database backups both onsite and offsite
• Managing and testing back-up and recovery plans

I have served 11 years meritorious service in Pakistan Air Force as Database Administrator and made remarkable contributions in sustaining the high degree of efficiency, imagination and professionalism in the fields of Database Administration and Information Technology. During my stay at Pakistan Air Force i have performed the undermenioned duties but not limited to these . . ..

implementation, configuration, maintenance, and performance of critical SQL Server RDBMS systems and ensure the availability and consistent performance of various corporate applications.
Manage SQL Server / Oracle databases
Configure and maintain database servers and processes

Monitor system's health and performance

Ensure high levels of performance, availability, sustainability and security

Analyze, solve, and correct issues in real time

Provide suggestions for solutions

Refine and automate regular processes,
track issues, and document changes

Assist developers with query tuning and schema refinement

Provide 24x7 support for critical production systems

Perform scheduled maintenance and support release deployment activities after hours

Windows/linux Server installation, Configuration,

Operation and Maintenance. Active directory configuration, system disaster recovery and incident handling etc.

Design, Install, Configure and maintain Local Area/Wide Area Networks, troubleshooting at Server/Client level issues, Implementing Network Security policies.


Moreover i have the following skill :-

Critical thinker and problem-solving skills
Team player
Good time-management skills
Great interpersonal and communication skills

Database Aministration,
Backups and Restorations
Monitoring of Databases
Troubleshooting
Error Handling
Client issues resoloutions
Users handlings
System Administrations etc