Sql Server Quality Assurance

Mohammad Jashim Uddin Patwary

301-***-**** ****************@*****.***

姕싰

Professional Summary:

About 9 (Nine) years of experience as a SQL Server DBA with detail oriented, analytical and troubleshooting experience in different Microsoft products like SQL Server, SharePoint, and Operating Systems. Depth knowledge and experience in data modeling including gathering and analyzing business requirement. Solid working experience in managing large databases in 24/7 data processing environment including backup/recovery, performance tuning, developing and managing reports using SQL Reporting Services (SSRS), Monitoring, Performance Tuning, stored procedures, triggers, functions, constraints and views etc. Working experience details: strong knowledge in using database third party tools (SpotLite, RedGate, SQLDoctor, ERWin) and Graphs as well.

Technical Skills:

Database Migration

SQL Server 2012/2008 R2/2008/2005/2000, MS Access 2003 & 2000 and Excel etc.

ETL/BIDS Tools

SSIS and SSAS/DTS with using BIDS

Reporting Services

SSRS (SQL Server Reporting Services) with BIDS, Crystal Report and Dash Board presentation

Operating System

Windows Server 2008/2003/2000, Windows XP/NT4.0, MS-DOS, VMware, SCOM, SSCM

Hardware/Storage

RAID, SAN and NAS and Trouble shooting any Hardware and Software related Issues.

Performance Tuning

Performance Tuning with native tool and third party tools also.

DR/HA Solutions

Configuration, Management, Troubleshooting, Administer Replication, Mirroring, Log Shipping, Clustering and Always-On-Availability

Database Development

T-SQL programming, Windows Powershell and SQLCMD

Education:

* BS in Computer Science and Information Technology, Univ. of Dhaka, BD

Certification:

* MCITP - (Microsoft Certified IT Professional - Database Administration: 2008)

AREAS OF EXPERTISE:

Database:

* Installation, Upgrading and Patch Management of 2005, 2008, 2008R2 and Installation of 2012.

* Data Modeling (Logical, Conceptual and Physical Design).

* Strong working experience with SQL Server Database High availability using Failover Clustering, Standby/Replication, Database Mirroring and Log shipping (Configuration, Management and Administer for more than Six Years) and specialty in Installation and maintain Failover Clustering.

* Database Monitoring, Performance Tuning, Query Optimization, Backup/Recovery, Security Management

* SQL/T-SQL Programming

* Strong Database Administration experience with MS SQL Server ( 2005, 2008 and 2012).

* Deployed databases to development, test and production environment

Operating Systems:

* Working experience on Operating Systems (O/S) include Windows Server 2008/2003/2000 Server, Windows 2000/XP/7/8 and MS-DOS.

* Working experience also includes installing, configuring, and administering the above operating systems.

* Administered user accounts AD (Active Directory) in Windows 2000/2003/2008 Server, Managed file and backup server.

Professional Experiences:

Client: SMS (Systems Made Simple), Falling Waters, WV Nov 2013 to Present

Role: SQL Server DBA

Database High Availability:

* Installed, Configured and Maintained Fail-Over Clustering using SQL Server 2008/2005

* Installed, Configured and Maintained Database Mirroring using automatic fail-over option in SQL Server 2008

* Configured Log Shipping as Standby database from Production database for Reporting purposes

* Configured and Maintained Replications.

Database Monitoring/Performance Tuning:

* Strong on database Monitoring and Performance tuning

* Scheduled jobs to automate different database related activities including backup, monitoring database health, disk space,

* Jobs Monitoring and setup

Database Programming:

* Writing T-SQL, Trigger, and Stored-Procedures

* Assisted Database Developers to optimize SQL queries and Stored Procedures

* Using PowerShell and SQLCMD commands.

DTS/SSIS/SSAS:

* Export & Import data from Flat file, CSV file to/from SQL Server Database using DTS, SSIS, and BCP

* Export & Import data from/to databases like Oracle, My-SQL, and Access to/from SQL Server

Backup Verification

* Monitor SQL Server Error Log, space usage

* Backup/Recovery:

* Strong knowledge and working experience in Database Backup and Disaster Recovery

* Experienced with Point-in-Time Recovery

* Restored Database from backup

Client: IDS, Alexandria, VA Aug 2009 to Oct 2013

Role: Database Administrator

Responsibilities:

* Installed and Configured SQL Server 2008 for testing different features and stability

* Use Windows Powershell for Manage the file system, Manager services, Manage processes, Manage Registry.

* Use CMD command for recovery Master and Tempdb databases and other necessary tasks.

Database High Availability:

* Installed, Configured and Maintained Fail-Over Clustering using SQL Server 2008 R2

* Installed, Configured and Maintained Database Mirroring of SQL Server 2005, 2008, 2008 R2 and 2012

* Configured Log Shipping as Standby database from Production database for Reporting purposes

* Configured and Maintained Replications.

Report Development:

* Installed, Configured, and administered SQL Server Reporting Services (SSRS)

* Developed Reports using SSRS

* Deployed Reports

Database Upgraded (development, testing and production environment):

* SQL Server 2000 to 2005/2008

* SQL Server 2005 to SQL Server 2008

Patch Management:

* Applied SP (Service Pack) on SQL Server 2005, 2008 and 2008 R2

* Applied HOT Fixes on SQL Server 2005, 2008 and 2008 R2

Database Monitoring/Performance Tuning:

* Strong on database Monitoring and Performance tuning

* Scheduled jobs to automate different database related activities including backup, monitoring database health, disk space, backup verification

* Monitor SQL Server Error Log, space usage

* Used DBCC to check database conditions, Rebuilding indexes and other database Maintenance purposes as well

* Strong working experience in creating, modifying tables, Index (Cluster/Non-Cluster), Constraints (Unique/Check), Views, Developed Different Maintenance Plans for database monitoring

* Monitor Server Activity, and solving problem as needed

Client: Hewlett-Packard (HPQ), New York, New York June 2007 to July 2009

Role: Database Administrator Jr.

Responsibilities:

* Installed, Configured, and Managed SQL Server 2000, 2005, 2008 and 2008R2

* Configured and Maintained Replications (Transactional)

* Configured Log Shipping as Standby database from Production database

* Upgraded databases from SQL Server 7.0/2000 to 2005 in testing and production environment

Internship

Client: Jahangirnagar University, Savar, Dhaka, Bangladesh Sept 2005 to May 2007

Role: Jr. SQL Server DBA

Responsibilities:

* Provide direct support for approximately 200 software developers, testers, database modelers and Quality Assurance staff members for SQL Server 2000 and SQL Server 2005.

* Extract, transform and scrub fact data using DTS.

* Monitor resource allocation of approximately 300 Windows and Solaris servers in Test, Staging and Preproduction staging environments. Approximately 80 of the servers are dedicated MS SQL Server 2000, servers on a mixture of Windows 2000 and 2003.

Contact this candidate