Sql Server Maintenance

MOHAMMED FIRASATH AHMED

E-mail: *************@***-******-*********.***

Contact: 732-***-****

Offering over 7 years of experience in the field of SQL Database Administration; pine for a challenging career which

would give me an opportunity to achieve professional excellence and contribute significantly to the success of

the organization. To inspire and motivate the team to put in best efforts and ensure that team efforts are in

synchronization with the objective of the organization.

PROFILE

A dynamic and competent professional with over 7 years of experience in SQL Server Database Administration.

An Infrastructure architect in designing, performance tuning, supporting VLDB’s in highly transactional

environment and setting up HA/DR solutions as per business requirements.

Demonstrated excellence in understanding the application requirements while ensuring that the new database

developed meets company standards for readability, reliability, and performance standards.

Expert in configuring and maintaining high availability and disaster recovery concepts like AlwaysOn,

clustering, database mirroring, log shipping and replication.

An effective communicator with honed interpersonal, team player, problem solving and self-motivated skills.

Key Strength Areas:

SQL Server Performance Database Database T-SQL & SQL

2005/2008 Tuning & Creation, Mirroring, Server BI Suite

R2/2012 Capacity Installation & Clustering, (SSIS / SSRS /

Administration Planning Maintenance Replication SSAS)

NOTEWORTHY PROJECTS

Database Schema Standardization:

Designed and implemented process to standardize schema for all OLTP databases to improve overall performance

and stability.

Part of process was to define proper data types per business requirement, enforce constraints and define proper

indices based on index usage reports.

Storage Savings:

Identified key areas which needed immediate attention to improve performance of the OLTP applications; SAN

was one of the main areas.

We were able to reclaim 4 TB on SAN and save about $250K on SAN maintenance by retiring log-shipping and

deleting unused databases.

Reduced Maintenance Window:

Educated other team members and implemented partial replication, this reduced downtime window by 3 hours

and increased application availability by 60%.

Application Migration:

Successfully migrated and consolidated 120+ Wachovia applications to Wells Fargo domain which included

migrating databases, upgrading DTS packages to SSIS, moving logins/users and sql server agent jobs.

PROFESSIONAL EXPERIENCE

Senior SQL Server Data Architect/DBA June 2013 onwards

Accretive Health, IL

Growth Path:

Senior SQL Server Data Architect/DBA June 2013 onwards

Senior Lead SQL Server DBA June 2010 – June 2013

Roles & Responsibilities:

Designing, maintaining and optimizing SQL databases, framing architecture to support business application,

ensuring system scalability, security, performance and reliability.

Designing SQL Server platforms for OLTP and OLAP environments such that they are easily scalable and give

optimal performance.

Primary contact for maintenance of all sql server clusters.

Handle severity level 2 and 3 production support tickets like performance issues, connectivity issues from

internal and external web based applications.

Creating capacity planning procedures using custom t-sql scripts and third party tools by Idera.

Establishing, documenting and educating development team members about best coding practices.

Performance tuned queries by analyzing execution plans, thoroughly reviewing indices and statistics in

conjunction with analyzing server level metrics like I/O, CPU and memory.

Designing physical and logical models of database for OLTP environment using Power Designer tool.

Creating database users and getting them added to appropriate AD groups/roles.

Monitoring and troubleshooting standard database maintenance jobs like index/statistics maintenance,

backups and database consistency checks.

Reviewing and applying database changes to all production servers using Red Gate tools.

Assist in mentoring and coaching other team members.

Select Highlights:

Established standard sql server level settings like MAXDOP,CTP,memory and server level settings like RAID

levels for data/log files, tempdb configuration and memory allocation for OLTP/OLAP environments- Senior

SQL Server Data Architect/DBA

Performance tuned slow running queries for OLTP and OLAP databases ranging in size from 10GB to 2TB.

Tuned many queries and reports to perform 5 – 80 times faster - Senior SQL Server Data Architect/DBA

Primary production support contact for maintaining VLDB’s with database size ranging from 10GB to 1.5TB

spread across 120+ instances on standalone as well as Hyper-V servers. - Senior Lead SQL Server DBA

Setting up DR solutions like database mirroring and replication based on SLA of the application. Deploying and

troubleshooting SSIS packages in SQL Server 2005/2008R2. - Senior Lead SQL Server DBA

Senior SQL Server Production DBA May 2008 – May 2010

Wells Fargo Bank, MD

Roles & Responsibilities:

Perform production support database administration tasks like performing monitoring, tuning, backup, and

recovery of databases; maintaining database management systems software; analyzing and planning for

anticipated changes in data capacity requirements; analyzing and resolving database related issues.

Handled service desk tickets including granting of SQL access, setting up SIT and UAT environments besides

servicing change control and developers in migrating code from SIT to UAT then UAT to PROD environments.

Primary point of contact for 300 + SQL servers on standalone and VM’s and Primary contact for 4 node cluster.

PRECEDING ASSIGNMENTS

Lera Technologies, India as SQL Server Developer Jan 2004 – Aug 2005

CERTIFICATIONS

Microsoft Certified Professional – SQL Server 2012

Microsoft Certified Technology Specialist – SQL Server 2005/2008R2

EDUCATIONAL CREDENTIALS

MS, Computer Science, Monmouth University – 2008

B.Tech, Electrical Engineering, Jawaharlal Nehru Technological University - 2005

Contact this candidate