Profileimage by Asad Mahmood Certified MSSQL Server DBA/Database & ETL Developer from islamabad

Asad Mahmood

available

Last update: 01.02.2021

Certified MSSQL Server DBA/Database & ETL Developer

Graduation: BS software Engineering
Hourly-/Daily rates: show
Languages: English (Full Professional)

Attachments

Database Engineer_ETL_Developer.pdf

Skills

An experienced certified database professional with hands-on expertise in managing the different aspects of DBMS like data modeling, Data & Schema Migration, and administration on large scale data platform solutions. I make every effort to understand business needs and deliver precisely what is the required deadline. I'm a Microsoft Certified Professional who easily adapts to the rapidly changing requirements.
  • Certified experienced Azure Database Administrator
  • Strong experience in the implementation of large-scale
  • Experienced Engineer specializing in analyzing and solving complex data problems
  • Performance optimization
  • Planning and implementation High Availability solutions (Log Shipping, Mirroring, Always ON AG, Clustering)
  • Years of experience installing/configuring/troubleshooting SQL Server
  • Design, build and maintain T-SQL scripts and complex queries for data extraction
  • Build SSIS packages for data conversion/sharing between databases
  • Report creation and deployment through SSRS and PowerShell
  • Implementing a new database system from concept
  • Migrating your existing data to a new system
  • Automating repetitive or time-consuming tasks
  • Plan, design, and implement application databases code objects, like stored procedures, views, and triggers

SOFT SKILLS
  • Effective communicating
  • Task management
  • Leadership
  • Mentoring
  • Logical thinking
  • Problem-solving

Project history

oDesk Freelancer
SQL Server Migration DBA
10.2013 - today
Responsible for migrating Schema of Different databases like SQL Server to SQL Server
Oracle to Oracle , 1. Data Backup (Manual, Auto Backup, Schedule Backup, Schedule Backup to a Different Server- Make Share folder of other Server as a Drive)

2. Data Restore

3. Data Migration (MySql to SQL Server, among different BDMS (MySql, SQL Server, Oracle, MS Access, XML, Excel, FoxPro, Text etc) )SQL SERVER to Oracle, Oracle to SQL SERVER etc.
Information Technology and Services


Protege Global
SQL Server DBA
03.2013 - today
Develops a methodology for the ongoing assessment of database performance and the identification of problem areas. Develops a security scheme for the database environment, as well as assisting in disaster recovery if necessary. Provides leadership during the development and Responsible for the enhancement of production applications including working with applications, technical support and operations during the design, development and implementation of applications. Work with the transaction processing area to develop both the physical and the logical database administration functions and assists in the development of our processing database and computing environments. Work with others in IT to build the logical database area and provide technical guidance during all phases of the development process. Work with vendors in evaluating and implementing new technologies.
Information Technology and Services
201-500 employees

MTBC
Database Developer
05.2012 - 03.2013
Comprehensive database management and migration from Diffrent database tools to SQL SERVER.
Configuring and monitoring Replication Issues among different servers placed at differnet locations
Configuring and creating Automated Jobs for Database Maintenace.
Design RDBMS Databases for other teams.
Working with Functions, Procedures and Triggers.
Information Technology and Services
1001-5000 employees

Local Availability

Only available in these countries: Pakistan
Available 24/7
Profileimage by Asad Mahmood Certified MSSQL Server DBA/Database & ETL Developer from islamabad Certified MSSQL Server DBA/Database & ETL Developer
Register