Resume

Sign in

Sql Server Information Technology

Location:
Pittsburgh, Pennsylvania, United States
Posted:
January 23, 2018

Contact this candidate

Resume:

347-***-**** www.linkedin.com/in/mdullah**** ac3ubh@r.postjobfree.com

MD RAHMAT ULLAH

Skills

7+ years of Database Administration experience in all tiers of environment

Expertise in Upgrading and migrating from SQL server 2008R2 to SQL server 2012/2014/2016

Expert in capacity planning, performance tuning, troubleshooting and finding bottlenecks

Extensive experience in configuration, implementation and maintenance for Disaster Recovery solutions using Always ON AG, Database Mirroring, Log Shipping & Clustering

Replication solutions including Snapshot, Transactional & Merge Replication

Thorough understanding of SQL Server Internals, Disk I/O & Transaction Log Management

Data Security Solutions & Database Integrity/consistency.

SSIS/Data Transformation Services

Performance Optimization & Management of Stored Procedure Tuning/Indexes/Triggers/Views

Database Maintenance Solution Automation

Database Systems: SQL Server 2016/2014/2012/2008R2/2005, Oracle Database 11g

Data Design/Model: Erwin, SSDD

Operating System: Central Management Server System/Virtual Machines, Windows Server 2016/2012R2/2008R2/2003, Windows 7/8/10

MS Office: Word, Excel, Power Point, Access, Outlook

SQL Sentry/Sentry One, Service Now, PowerShell

Provided 24 x 7 Production support for the database and application issues.

Excellent Interpersonal, Management and Communication skills with ability to deliver quality results with minimum supervision

Education

Master of Science (MS) in Information Systems

Major- Database Modeling and Design - University of Maryland Bachelor of Business Administration (BBA)

Bangladesh Open University - Dhaka, Bangladesh

Certifications

Microsoft Certified Solutions Associate (MCSA) 2012/2014 Oracle Database 11g: SQL Fundamentals I

Information Technology Infrastructure Library (ITIL) Professional Experiences

BNY Mellon, Pittsburgh, PA

SQL Server Database Administrator June 2016 – Present

347-***-**** www.linkedin.com/in/mdullah4010 ac3ubh@r.postjobfree.com

Provided Production Support for SQL Server (Primarily) & Oracle Databases.

Ensured Database High Availability for large hosting environment consists of more than 700 SQL instances & 7,000 databases, including 24x7 supports.

Performed troubleshooting, resolution and root cause analysis for database & application- specific incidents/events.

Successfully implemented a project to upgrade from SQL Server 2008R2 to SQL Server 2014, including migration from Failover Cluster Instances to Availability Groups.

Participated in configuring and managing large SQL server platform using Center Management Sever.

Documented policies, processes and procedures including server build process and issue resolution.

Completed a project that involves working with EMC2 to implement Data Domain as backup device for all hosting databases.

Worked directly with developers to design databases and tune SQL code to increase query response time.

Worked closely with clients to ensure smooth transition from old to new systems with minimal disruption of workflow and daily process.

Performed troubleshooting & optimization for performance issues including performance tuning of SQL & PL/SQL code, as well as index & database-level changes to improve performance.

Implemented and managed Ola Hallengren maintenance solutions extensively across different environments.

United Parcel Services (UPS), Springfield, VA

SQL Server Database Administrator August 2014 – June 2016

Worked as a Database Administrator that includes Installation, Configuration, Backup & Recovery, Database Security and Performance tuning.

Planned and implemented Database Change Tracking processes and designed a problem- solution process by creating standard documentation for future references.

Used DBCC Utilities extensively and handled data corruption in user databases and identified the bottlenecks caused by complex queries using Activity Monitor, SQL Profiler, Extended Event and Performance Monitor.

Implemented SQL Server 2012 new features like Always On Availability Groups for high availability of multiple databases in place of database mirroring.

Provided daily support, troubleshooting, monitoring, optimization and tuning of SQL server environments across entire system using diagnostic manager from Idera.

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

Used SQL Server Integration Services (SSIS) to populate data from various data sources, created packages for different data loading operations for ETL applications. Principle MCD Inc., New York, NY

SQL Server Database Administrator March 2012 – August 2014

347-***-**** www.linkedin.com/in/mdullah4010 ac3ubh@r.postjobfree.com

Installed and Configured SQL Server 2008 R2/2012.

Involved in database design, database standards, and T-SQL code reviews.

Managed Active/passive SQL Server Clusters and implemented DR/High Availability solutions using Log Shipping, Mirroring.

Resolved blocking and long running queries issues and participated in various root cause analysis by using Profiler, Query Execution plan, Event viewer etc.

Created SSIS packages extensively and deployed them to various servers and scheduled them for execution.

Worked as the project lead for SQL Server upgrade and patching for various database servers.

Proactively involved in monitoring database Performance by monitoring Index fragmentation level and updating Statistics.

Created Schemas, Logins, Tables, Clustered and Non-Clustered Indexes, Views, Functions and Stored Procedures.

Neometrics, Hauppauge, NY

SQL Server Database Administrator January 2010 – February 2012

Involved in Analyzing and Upgrading of SQL Server 2005 servers to SQL Server 2008.

Designed and implemented comprehensive Backup plan using SQL Server Maintenance Plan.

Experienced in configuring log Shipping and Mirroring for SQL Server 2008 R2.

Worked extensively on troubleshooting performance issues and fine-tuning databases with high traffic.

Participated in the ETL process through using SQL Server Integration Service.

Updated database systems by reviewing, planning, testing and installing database security patches and service packs.

Involved in capacity planning and monitoring data/log file’s size growth and disk space.



Contact this candidate