Muhammad Afzal Email & Phone Number

Birmingham, Gb

Dubai, United Arab Emirates

Working for an offshore client in Saudi Arabia, I am a MSSQL Database Administrator and Developer.

Islamabad, Islāmābād, Pakistan

• Managed our continuous integration and delivery pipeline to maximize efficiency. • Maintenance of databases on cloud services like AWS, AZURE & Terraform.• Working on AWS RDS Database, Ec2 Database• Data export and import using S3 buckets to RDS.• Azure container services for database backups• Experience with programming tools (Shell scripting, PL/SQL,), automation and collaboration tools (Jira, Confluence), AWS Cloud services.• Developed and maintained solutions for operational administration, system/data backup, disaster recovery, and security/performance monitoring. • Continuously evaluated existing systems with industry standards, and made recommendations for improvement. • Ensured systems are highly available and resilient.• Enabled product development team to deliver new code daily through Continuous Integration and Deployment Pipelines.• Protected customer data with continuous security practices and monitoring.• Auto Schedule database Backups on Blob storage.• Troubleshooting/Optimizing database performance and slowness issues using different tools & methods like SQL Sentry / (Dynamic management views, Profiler, Perfmon, Execution Plans)• Maintain Development Data and refresh it with production data where required• Application performance monitoring , troubleshooting & tuning• Replication configuration, monitoring & troubleshooting• Monitor Database Infrastructure & maintain Database Structures

Northern Punjab Rawalpindi, Pakistan

• Create a secure production infrastructure with multiple resources across different platforms.• Design, and scale infrastructure.• Good understanding on Azure Cloud concept.• Architect and build continuous deployment pipelines.• Create tools to empower developers to manage production infrastructure.• Upgraded development, UAT & Production environments from SQL Server 2008 & 2012 to SQL Server 2014 & SQL Server 2016 & SQL Server 2017 & SQL Server 2019 AZ .• Developed & implemented enterprise wise automated maintenance infrastructure.• Automated DBA’s daily tasks like Index rebuild & reorganization, and weekly maintenance for statistics updates.• Installation, configuration, up-gradation and migration of systems.• Capacity planning for DB Servers, and recommendations for hardware upgrade, and change in architecture.• Managing deployments on development, staging and production environments.• Designed & implemented database backup & recovery SOP for all databases, i.e. Production and development.• Configured and administered Database replication with Mirroring• Disaster recovery of databases and SQL server

Rawalpindi Pakistan

Lead Database Administrator (Oracle 11g) • Installation, configuration of Oracle Database 10g,11g,12c,19c on Oracle Linux, Redhat, Oracle Linux & other Oracle server software and related products• Working on Oracle Tools Toad & Oracle SQL Developer• Oracle Database Administration 10g,11g,12c,19c • Implementation of Oracle Data Guard (Physical/Logical/Active) Technology on Windows and UNIX family.• Implement and maintain database security (create & maintain users & roles, assign privileges)• Perform backup and Recovery using RMAN. Command on Export, Import and Data Pump.• Responsible for maintenance and support for company 24/7production database.• Take care of the Database design and implementation• Scheduling Crontab Jobs & Password Policy Periodically in Oracle 10g,11g,12c,19c .• Create Users, Grant, Revoke Responsibilities in Oracle 10g,11g,12c,19c • Daily Monitoring of Production Servers• Reset Password of Users in Oracle Apps & Reporting to concern Departments.

Northern Punjab Rawalpindi, Pakistan

• To perform day-to-day database system administration, including daily checklists, backup verification, log review, security maintenance, performance tuning (analysis, indexing, etc.).• Create, update and maintain database objects in coordination with our reporting team.• Create, review and maintain code in our database systems to optimize, standardize and/or prepare for upgrades.• Perform data/database/process consolidations as coordinated with applicable internal staff.• Upgrade, configure and maintain server and database monitoring software to baseline system performance and proactively identify (and remedy) potential issues. Resource monitoring and capacity planning.• Review, test, update and document detailed disaster recovery/business continuity plans for key production SQL Servers (database mirroring, log shipping, replication, clustering) in a VM/SAN environment.• Performs database backup and recovery as required, including periodic testing.• Reviews, tests, recommends and installs upgrades of database software, including patches and major releases.• Ongoing review and completion of trouble tickets related to the database systems.• Train and mentor junior team members on process and technology.• Performs data analysis and other reporting tasks. This involves data investigation and cleansing.• The primary duties of this position occur during business hours; however, there is some weekend work related to projects, planned maintenance, and on-call support.Administer database replication among global servers.• Implemented and administered replication on production servers between multiple datacenters spanning different geolocations.

Rawalpindi, Punjab, Pakistan

• Good experience with Reporting Services,• Create functions, scripts, stored procedures and triggers to support application development.• Design, develop and implement database systems based on customer requirements.• Develop database tables and Views.• Participate in database design and architecture to support application development projects.• Troubleshoot database related issues in a timely fashion.• Develop best practices for database design and development activities.