Resume

Sign in

Sql Server Ms

Location:
New York, New York, 10001, United States
Salary:
$60/ Hr on c2c
Posted:
January 31, 2017

Contact this candidate

MD ENAMUL SARKER

201-***-****

Summary

* + Years of experience in Database Administration, Design, Development and Support MS SQL Server 2014/2012/2008R2/2008/2005 in Production, Test, Development, Clustered, and Azure environments.

Extensive experience in 24*7 Production Support on oral basis.

Hand on experience in installation and configuring 2014/2012/2008R2/2008/2005 MS SQ Server version with service packs and hot fixes on standalone, clustered servers and private/on premise cloud environments.

Experience in RDBMS database design, performance tuning, optimization, backup and recovery and security in SQL Server2014/2012/2008R2/2008/2005.

Experience in side by side upgrades and in place upgrades using upgrade advisor/migration wizard from 2000/2005/2008/2008R2/2012.

Experience in High Availability, Always on, Clustering, Replication, DB Mirroring, Log Shipping, Disaster Recovery Planning, Execution and Testing at remote side.

Extensive work experience on system analysis, design, development, testing and implementation of projects with full SDLC (Software Development Life Cycle).

Excellent communication and interpersonal skills with ability to co-ordinate activities and work in a team environment to meet the deliverables.

TECHNICAL SKILLS

RDBMS

MS SQL Server 2005/2008/2008R2/2012/2014. Oracle 10, 11, 11g, Mongo DB

Database Tools

Management Studio, Enterprise Manager, Query Analyzer, SQL Profiler, DTS, SSIS, Upgrade Wizard, LiteSpeed,Idera.

Programming languages

T- SQL, XML, C++, Java, VB 6.0, C, C++.

Scripts

Java Scripts, VB Script, HTML and XML.

Testing Tools

Quality Center 9.0/9.2, ALM, QTP 9.X.

Applications

Microsoft Office, Visio and Visual SourceSafe, TFS.

Operating Systems

Windows Enterprise 9X/NT/2000/XP/2003/2008R2/2012R2.

Reporting Tools

SSRS, Cognos, Business Objects, Micro Strategy, Quick View, Tableau.

WORK EXPERIENCE

OPTUM, MN MAY 2013 - TILL DA

Job Title: MS SQL Server DBA

Responsibilities:

Responsible for installing, configuring, managing, monitoring and troubleshooting SQL Server 2014/2012/2008R2/2008/2005.

Involved in migration from MS SQL Server 2005 to MS SQL Server 2008, 2008R2 and MS SQL Server 2012.

24 X 7 dedicated support on rotation to all Production and DR Servers.

Responsible for applying the service packs to MS SQL Server 2005/2008/2008R2/2012 Standalone and multi node clustered instances. Applied patches to more than 200 MS SQL Server Standalone instances, two node, three node, four node and five node clustered instances.

Configured Database Mirroring to create a Disaster Recovery Stand by Server in the environment.

Experience in working with application teams and vendors to configure database to application. Worked with Citrix data store application to one of our Shared SQL Server environment.

Experience in database DR Failover for the SharePoint External facing sites i.e. in restricted network (DMZ).

Dedicated MS SQL Server admin responsible for the installation, configuration and maintenance of SharePoint application databases for the past 6 years.

Involved in migration MOSS 2007 Databases (MS SQL Server 2005) SharePoint 2010 databases (MS SQL Server 2008R2).

Analyzing long running slow queries and tuning the same to optimize applications and system performance using IDERA.

Responsible for standardizing the MS SQL Server Team Backup policy and back process re – engineering to new windows boxes from Linux boxes.

Responsible for Active Directory account cleanup consolidation project.

Recovered the databases lost due to hardware failures, software failures, database corruption issues, including renaming, moving and copying databases to new locations and new devices.

Overall database design, such as creating normalized databases, authentication, query tuning, assigning proper indexes, creating stored procedures, functions, triggers and data types using T- SQL statements.

Involved in replication of data like snapshot and transactional replication.

Installed Oracle 11g client tool and prepared step by step process document for the installation.

Designed implemented and maintained ETL process using MS SQL Server Integration Services.

Used Data Transformation Services, SSIS to populate data from various data sources by creating packages.

Monitoring and report generation for the database infrastructure. These reports are presented to management on regular basis for the development of Meta data application.

Experience in installation and configuration of SSAS and SSRS. Migrated reports from non – production to production.

Experience in configuring SQL agent jobs for executing SSIS packages. Also deployed SSIS packages to package store.

Well versed with Testing Methodologies, Testing Strategies and SDLC.

Tested new service manager forms, database process forms like Application work request, Production release request and database creation forms.

ENVIRONMENT : MS SQL Server 2014/2012/2008R2/2008/2005, Windows 2012R2/2008R2/2003, IDERA, PPM, LiteSpeed, MS Integration Services, MS Analysis Services, MS Reporting Services, Citrix, SharePoint 2014/2012/2010, MOSS 2007, Service Manager, Remote Desktop, .Net, TFS, PCS, Alarm Point.

Company: SIRIUS XM RADIO,

Washington DC April 2011 – April 2013

Job Title: MS SQL Server DBA

Responsibilities:

Hands on experience in installing, configuring, managing, monitoring and troubleshooting SQL Server 2008/2005/2000/7.0.

Involved in migration from MS SQL Server 2000/2005 to MS SQL Server 2008.

24 X 7 dedicated support to all Production Servers.

Involved in documentation and implemented a disaster recovery system.

Experience in Data center migration and relocation.

Performed aspects of database administration, including data modeling, backups and recovery, Security Issues, long running slow queries such as creation of various objects and granting permission to user(s), role(s).

Analyzing long and tuning the same to optimize applications and system performance. Performance DBCC checks.

Rebuilding Indexes and Tables as part of performance tuning exercise.

Overall database design, such as creating normalized databases, authentication, query tuning, assigning proper indexes, creating stored procedures, functions, triggers and data types using T – SQL statements.

Hands on experience with Bulk Insert and Database Consistency check using DBCC commands.

Developed ETL packages with different data sources (SQL Server, Flat File, Excel source Files, XML files) and loaded the into target tables by performing different kinds of transformations using MS SQL Server Integration Services.

Used Data Transformation Services to extract data from source databases, transforming the data as needed and loading the finished data into the cube.

Monitoring and Report generation for the database infrastructure on regular basis.

Environment : MS SQL Server 2008/2005/2000, DTS, Windows 2003 Server, Citrix, SharePoint 2010, MOSS 2007, .Net, Executive Source Card, SMS, MS Access, Oracle 9i, MS Integration Services 2005, MS Analysis Services 2008, MS Reporting Services 2008/2005, HTML.

Company: Honda Motors, CA

Jan 2008 – Mar 2011

Job Title: MS SQL Server DBA

Responsibilities:

Installing, configuring, tuning and providing 24 X 7 support for SQL Server 2000/2005/2008R2.

Created and scheduled jobs to setup log shipping between production servers.

Implemented Database Mirroring on the SQL Server 2005 production databases.

Job Monitoring and making sure all jobs run successfully every night.

Creating databases and logins with permissions in SQL Server as per the developer’s request.

Worked extensively on SQL Server Reporting Services to generate reports.

Created Linked Servers between 2005 and 2008R2 servers.

Involved in Migration from SQL Server 2000 to 2005 and 2008.

Created Database Diagrams using ERW in Data Modeler.

Developing store procedures, triggers, views and adding/changing tables for data load and transformation and data extraction.

Migrated and Tested DTS packages to SQL Server 2005 Integration Services.

Created Database Maintenance Plans for the Performance of SQL Server, with covers Database Integrity Checks, Update Database Statistics and Re-indexing.

Restore Development and Staging databases from production backups as per the requirement.

Extensively used SSIS to move data from text files to SQL Server.

Monitor backup jobs daily and run the jobs manually in case of failure depending upon the necessity.

Prepare daily report on the job failures, backup failures and disk space.

Extensively used Database Performance Monitoring tools for performance tuning.

Designed and implemented database maintenance plan.

Used Index tuning wizard and rebuilding indexes for faster Query Performance.

Involved in resolving dead lock issues and performance issues.

Environment: MS SQL Server 2005/2008R2/2012/2014 Windows 2000/2003/2008 Servers, .NET, MS Access.

Education: Masters in Science, National University, Dhaka, Bangladesh.



Contact this candidate