Sql Server Data

Mohammed H Islam

Phone: 703-***-****

Email: *********@*****.***

Career Objective: An experienced SQL Server DBA with detail oriented, analytical and troubleshooting skill, having more than 7 years of professional experience in different Microsoft products. Detailed experience includes SQL Server database administration, data modeling, gathering and analyzing business requirement and Operating Systems. Working experience in managing large databases, backup/recovery, developing and managing reports using SQL Reporting Services (SSRS), Monitoring, Performance Tuning. I am an effective communicator with strong work ethic, exceptional relationship, and management skills.

Summary of Expertise

Working experience in installing, upgrading, patching, administrating and maintaining Microsoft SQL Server 2014/2012/2008R2/2005/2000 in Production, Test and Development environments

Proactively monitoring and troubleshooting database issues and make tuning adjustments to ensure database integrity, security and system performance

Proficient in performance tuning of T-SQL queries, stored procedures and debugging the poorly written code and helping application teams in development life cycle

Working experience with developers, application owners, system administrators and users to deploy software release across Development, Testing, and promoting into Production or resolve issues

Highly proficient in database Backup, Restore, Point-in-Time Recovery, Linked servers, and Database Maintenance Plans

Expertise in RDBMS concepts and constructs. Working with data modelers on logical and physical data modeling and DBAs/Developers in implementing and updating physical data models in databases

Experience with SQL/T-SQL for creating, altering, and maintaining databases and database objects

Experience of Upgrading and Migration from earlier version of SQL Server to SQL Server 2012/2014 in different environments

Solid experience and outstanding knowledge of SQL Server high availability and Disaster Recovery solutions (Log shipping, Mirroring, Replication, SQL Server clustering and AlwaysOn)

Experience in creating, supporting and maintaining database administration scripts

Experience with schema management, database reorganization, Partition, database maintenance and optimization

Expertise in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) with good knowledge on SQL Server Analysis Services (SSAS)

Developing reports on SSRS on SQL Server (2005/2008r2/2012)

Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like Cascading, Conditional, Table, Chart and Sub Reports

Developed Stored Procedures to generate various Drill-through reports, Parameterized reports, Tabular reports and Matrix reports using SSRS.

Experience in developing, monitoring, extracting and transforming data using DTS/SSIS, Import Export Wizard, and Bulk Insert

Excellent in High Level Design of SSIS Packages for integrating data using OLEDB connection from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and union all

working Experience and good understanding of SSAS, OLAP cube and Architecture

Extensive work experience in applying latest Service Packs, patch and hot fixes

Maintain database and application documentation, including data standards, procedures, definitions for the data dictionary and logical and physical models of the databases

Manage Security Management: Securing SQL Servers and Databases, Manage users, Data encryption, granting/ revoking access, data masking

Expert in utilizing different Monitoring tools including third party tools like Toad Data Modeler, OpNet, Idera, ERWin, Redgate

Excellent ability to work as part of a team and independently and Able to manage time too effectively to meet deadlines and prioritize workload

Extensively worked in 24*7 Production environment

Education

Bachelor of Science in computer science, National University of Bangladesh

Key Skills:

Database Administration

SQL Server 2014/2012/2008/2005/2000, MS Access, Oracle 10g, 11g

Database Tools:

Profiler, BIDS,DTS, Management Studio/Enterprise Manager, Query Analyzer, SSIS

Operating Systems:

Windows Server 2012,2008R2, 2003, Windows 7 Professional, Windows XP Professional, NT 4.0, Unix, Linux (Red Hat)

Web Technologies:

XML, HTML, VBScript

ETL Tools:

DTS/SSIS,BIDS,SSDT,BCP

Languages:

T-SQL, PL/SQL, XML,JavaScript, ASP, ASP.net and C++

Databases Migration

Migrated Oracle 10gR2/11g, MySQL, MS Access

Reporting Tools:

Report builder, Crystal Reports, OLAP Tools, BIDS,SSDT

Third Party Tools:

Toad Data Modeler, OpNet, Idera, ERWin, Redgate, SolarWinds

Professional Experience:

Department of Labor, Washington DC Nov 2014 – To Present

SQL Server Database Administrator

Responsibilities:

Installed, Configured, and Maintained SQL Server 2008 R2, 2012, 2014 in development, test, and production environment

Upgraded/Migrated SQL Server Instances/Databases from older version of SQL Server to new version like 2005 /2008 R2 to 2012/2014

Migrated MS Access Databases into MS SQL Server 2008 R2, and 2012

Migrated Oracle 10gR2/11gR2 and MySQL databases to SQL Server 2008 R2/2012

Applied SP (Service Pack)/ hot fixes on SQL Server Instances to address security and upgraded related issues

Setup, Configured and maintained AlwaysOn SQL Server 2012.

Configured and Maintained Replications, Log Shipping for High Availability

Involved in designing, debugging and testing of reports in SQL Server Reporting Services (SSRS)

Developed and deployed different types of Reports using different data sources like SQL Server, Oracle, Excel, CSV files

Delivered reports to users in variety of formats like Report Server (Web based), excel, pdf, html, excel and CSV formats

Designed and developed stored procedures, queries and views necessary to support SSRS reports

Designed new reports and wrote technical documentation, gathered requirements, analyzed data, developed and built SSRS reports

Scheduled and managed daily/weekly/monthly sales and operational reports based on the business requirements

Experience in SQL Server SSIS (Integration Service) package design, constructing, and deployment

Experience in creating packages to transfer data between ORACLE, MS ACCESS and FLAT FILES to SQL SERVER using DTS/SSIS

Experience in maintenance and Administration of SSIS by creating Jobs, Alerts and schedule DTS/SSIS Packages

Requirements and design goals of data warehouse

Developed the dimension, fact tables and designed the data warehouse using star schema

Good understanding on data modeling projects and generated E-R Diagram

Backward & Forward Engineering with data modeling tools mentioned above

Performed database and SQL/TSQL Performance Tuning using Profiler, Execution plan, DMV, DBCC, Activity monitor, Performance monitor

Experienced in SQL/T-SQL queries, Stored-Procedures, functions, and Triggers

Scheduled jobs to automate different database related activities including backup, monitoring database health, disk space, backup verification, cleaning history, deleting old files, index and fragmentation managements

Work Environment:

Windows Server 2012, 2008-R2, 2003-R2, IIS 7.5, SQL Server 2014, 2012, 2008-R2, 2008, 2005, AD (Active Directory), and applications in JavaScript, ASP and ASP.net.

Department of Human Health Services, Rockville, MD May11–Nov14

SQL Server Database Administration

Responsibilities:

Installed, Configured, and Managed SQL Server 2005, 2008R2 and 2012 in development, test, and production environments

Securing SQL Servers and Databases, Manage users, Data encryption, granting/ revoking access

Data Encryption and Data Decryption for data security in Database & Column level

Managed Backup/Restore, Point-in-Time Recovery including backup verification, security

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

Setup, configured, monitored, troubleshoot and maintained Log Shipping, Database Mirroring

Monitored SQL Server activities/issues (such as CPU utilization, Memory utilization and IO utilization, disk space issues, blocking, deadlock, fragmentation, Identifying indexing issues, managing indexes, growth patterns, etc. ) and optimized performance using Execution plan, PerfMon, Profiler, Database Tuning Advisor, DMV

Prepared/designed and implemented backup strategy, maintenance and disaster recovery plan

Setup and configured Database Mail and configured notifications and alerts

Performed regular backups, restores and database

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

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

Regularly inspected SQL Server Logs, SQL Server Agent Error Logs, and Windows Event Viewer for Information, errors and warnings

Involved in resolving dead lock issues and performance issues and Health Check process for database

Monitoring of database size and disk space in Production, Staging & Development environments

Developed and Managed Report in SSRS (SQL Server Reporting Services) including managing securities

Work Environment:

Windows Server 2008 R2/2003 R2, SQL Server 2005/2008 R2/2012, Access, PHP Applications, ASP, ASP.NET, IIS, and Apache Tomcat

African Development Foundation, Washington, DC Nov 09-May11

SQL Server Database Administration

Responsibilities:

Installed, Configured, and Managed SQL Server 2000,2005, 2008 and 2008R2 in development, test, and production environment

Setup, Configured, monitors and Maintained Database Mirroring

Installed, configured, maintain and monitored troubleshoots SQL Server Clustering

Configured and Maintained Log Shipping as Standby database for Reporting Purposes

Expertise in database Performance tuning SQL profiler, Execution Plan, Database tuning Advisor, Activity Monitor, Performance Monitor

Monitored data activities such as logs, space utilization, locks, long transaction

Optimized the database by creating various clustered, non-clustered indexes and indexed views

Experience with SQL/T-SQL, Stored-Procedures, Triggers, Function, Views, Indexes

Processed data dump and Exported & Imported data from Flat file, CSV file, Oracle, My-SQL, and Access to/from SQL Server Database using DTS, SSIS, and EXP/IMP tool

Installed and Configured SQL Server Reporting Services (SSRS)

Developed Different Maintenance Plans such as backups, index management, fragmentation management, cleaning history, deleting old files

Working experience in point-in-time recovery

Monitored Servers activity, Error log, Space usage and worked with clients to solve different problems

Work Environment:

SQL Server 2000, 2005, 2008, IIS Server 6.5, Windows Server 2003, 2003R2, ASP.net, Java, ETL and AD (Active Directory)

Security Clearance: Clearable

Citizenship: Green Card

References: References available upon request

Contact this candidate