Resume

Sign in

Sql Server Microsoft

Location:
Windsor, Ontario, Canada
Posted:
August 23, 2018

Contact this candidate

Resume:

Muhammad Naveed Aslam Master in Computer Science

ac6r1j@r.postjobfree.com 519-***-****

SQL Server DBA Certified professional

Analytical, a highly adaptable database administrator (DBA) with extensive experience of designing, supporting database solutions in SQL Server enterprise environments. Proficient in an assortment of technologies, including MS SQL Server, Oracle, Windows, and Linux. A fast learner and willing to accept new challenges to enhance my professional capabilities to a new level.

Professional Competencies

MS SQL Server Database Administration (Cluster/Non Cluster) Versions 2008R2, 2012, 2014,2016

MS SQL Server Log Shipping/Mirroring/Replication /AlwaysOn Availability Groups

Microsoft Windows SQL Clustering

Microsoft Windows OS Administration

Backup and Recovery

Microsoft Access Database

T-SQL, PowerShell

Performance Tuning and Monitoring

DB Refresh, Patching, Migration, Upgrading

Data Security - Audit

Azure Web Services

Capacity Planning

Stakeholder and Vendor Management

Professional Experience

Auto parts Centrum

database Administrator Canada SEP 2014 – TO Date

Install, configure, manage, administration and support of Microsoft SQL Server 2005,2008R2, 2012, 2014, 2016

Configured SQL AlwaysOn AGs and Microsoft SQL Server Cluster for business-critical applications

Design and implementation of High Availability (HA) and Disaster Recovery (DR) database solutions using SQL Server Log Shipping, Mirroring, Replication, SQL Server Clustering and AlwaysOn

Very good experience in Performance Tuning and Optimization (PTO) using native monitoring and troubleshooting tools

Successfully designed and developed backup and recovery strategy and procedures for databases

Performing database maintenance activities like rebuilding/reorganizing indexes and update statistics

Operating system Windows installation, administration, and troubleshooting

Experience with troubleshooting and resolving database problems

Successfully upgraded the database from SQL Server 2012 to 2014

Good experience in planning and implement software upgrades, Application upgrades and database moves

Successfully migration between Oracle 11g and SQL Server 2014 using SQL Server Migration Assistant (SSMA)

Successfully fulfilled security and IT audit requirements using application/database audit capabilities

Provides opinion and technical details for business applications by performing capacity planning, workload modeling, and prediction

Identification and optimization of slow running queries and automate routine operations tasks with scripts

Prepared TEST/DEV/UAT database instances for applications support team

Checking database integrity and clean up history on regular intervals

Managed and monitored the Database space requirements

Good knowledge of SSIS and SSRS administration

Prepared documentation such as process documents and application specific documents

Virtual University Of Pakistan

Database Administrator Pakistan May 2010 - Feb 2014

Administration and management of operational databases

Providing technical input on the configuration of MS SQL Server

Plan, design, and databases upgrade from SQL 2005 to SQL Server SQL Server 2008R2

Design of High Availability (HA) and Disaster Recovery (DR) options

Pro-active monitoring of databases both from performance and capacity management perspective

Troubleshooting and handling all databases related issues and tracking them through to resolution

Performing database maintenance activities such as backup and recovery, rebuilding indexes etc.

Troubleshooting databases and applications related issues and providing support to end users

Established and maintained Security and Integrity controls

Enable database auditing capabilities

Migration of Oracle Database 11g to SQL Server 2012 by Microsoft SQL Server Migration Assistant (SSMA)

Planning and Administration of backups and recovery strategies for SQL Server

Identifying performance bottlenecks and tuning for performance

Implementation of database and applications patches

Managed and monitored the Database space requirements

Ensuring that all database releases are properly assessed and measured from a functionality and performance perspective

Providing technical subject matter expertise on all database design and development projects

Ensuring that all databases are updated with the latest service packs, patches, and security fixes

Achieved higher SLA by implementing SQL Server Mirroring which provided high availability to critical business applications

Planned and provided specifications for hardware and software for new Servers

DWP technologies

Data IT Specialist Pakistan Jun 2007 - Apr 2010

Installed and Configured Oracle 10g and SQL Server 2008 R2

Administration and management of operational databases

Provided DBA support to development team

Managed and monitored the Database space requirements

Established and maintained Security and Integrity controls

Troubleshooting databases and applications related issues and providing support to end users

Identifying performance bottlenecks and tuning for performance

Install and replace the internal server and mid-range computer components

Design and develop physical databases

Perform and manage system and database backups

Planned and provided specifications for hardware and software for new Oracle and MS SQL Servers

Identified performance bottlenecks and tuning for performance

Created schema objects like tables, triggers, database links, views etc.

Troubleshooting databases and applications related issues and providing support to end users

Technical Competencies

Databases:

Microsoft SQL Server 2016,2014,2012,2008R2,2005, Oracle 9i,10g, 11g

Operating Systems:

Microsoft Windows Server 2012R2,2008R2,2003, Red Hat Linux

Languages:

SQL, T-SQL, PL/SQL, Shell Script, PowerShell

High availability:

MS SQL Server Log Shipping, Mirroring, Replication, Always On, Oracle RAC, Oracle Data Guard

Tools:

Microsoft SQL Server Management Studio (SSMS), SSRS, SSMA, Microsoft MAP Tool, Microsoft Office Suite, Microsoft Project, Microsoft Visio, Toad, SQL Developer, PL/SQL Developer, RMAN, Data Pump, SSH, Putty

Other Skills

Good analytical and planning skills

Strong verbal and personal communication skills

Good decision-making skills

Self-motivated and initiator

Ability to work under pressure

Good presentation skills

Certifications and Training

Certifications:

Microsoft SQL Server 2012/2014 R2 Administrator (2013)

Oracle Database 11g Administrator (2013)

Oracle Database 10g: Real Application Clusters Certified Professional (2009)

Oracle Database 10g Administrator (2008)

Oracle Database 9i Administrator (2008)

Linux Foundation Training (2008)

Training:

Implementing Microsoft Azure Infrastructure Solutions - Dubai, UAE (2013)

Education

Masters in Computer Science University of Engineering and Technology, Pakistan 2007

References

Will be provided on Demand.



Contact this candidate