Sql Server Maintenance
Resume:
GHULAM ABBAS
Professional Summary:
• Over *+ years of experience in database administration, modeling, analysis, implementation,
performance monitoring and tuning using SQL Servers 2012/2008R2/2008/2005.
• Experience in Installing, Configuring, Managing and Troubleshooting SQL Server
2012/2008R2/2008/2005.
• Experience in upgrading SQL Server to new versions and applying service packs and hot fixes
and unattended Installation.
• Experience in Migration from SQL Server 2005 to SQL Server 2008
• Good understanding of Normalization /De-normalization and the database design methodology.
• Installed new Instances, created databases, tables, Indexes, Stored Procedures, and Views for
the developers.
• Performed database and instance security activates creating user login with appropriate role,
granting login privileges, monitoring the user accounts, created groups and granted database
application roles to users for groups.
• Experience scheduling jobs, alerts and operators with SQL Server Agent, handling
Backup/Recovery of databases, Replication, Linked Servers, and Database Maintenance
Planning. Experience in implementing different types of Replication Models like
Transactional and Snapshot. Excellent skills in creating SQL objects like Tables, Stored
Procedures, Views, Indexes, Triggers, Rules, Defaults, user defined functions .
• Proficient with SQL Server Disaster Recovery, Backup/Restore.
• Experience in implementing SQL Server Security and Database Permissions.
• Well experienced in scheduling SQL Server Jobs, Maintenance plans and executing them.
• Hands-on working experience with analyzing query plans, using extended Stored Procedures,
managing indexes and locks, troubleshooting deadlocks.
• Solid experience and outstanding knowledge of high availability SQL Server solutions
including Mirroring, Log shipping, Replication.
• Knowledge and experience in dealing with Constraints, Querying, Joins, Keys, Indexes.
• Expertise in Performance Tuning, Index Tuning, Maintenance, Troubleshooting, Query
Optimization and Database Consistency Checks using DBCC Utilities, DMVs and DMFs
also using (DET) to get recommendation what query need to work on.
• Knowledge of using (SSIS) in the development (ETL) Extract Transform Load
• Well experienced in performing root cause analysis and using SQL Profiler for troubleshooting.
• Knowledge in deploying multiple reports ( SSRS) in Drill mode using tables, financial tables,
crosses tabs and charts.
• Knowledge in SQL Server Clustering, Non-Clustering, heap and balance Tree.
• Experienced in implementing efficient Disaster prevention and Recovery Strategies and High
availability like Database Backup and Restore, Database Snapshot, transactional, Replication,
Log shipping, and Clustering (Active/Passive).
Technical Summary:
Operating Windows Server 2003, Windows 2000 Server/ Advanced Server, Windows
Systems 98/XP/Vista/7/8/8.1
Database Tools Profiler, Management Studio/Enterprise Manager, Query Analyzer, SSIS, SSRS
Web Technologies HTML, CSS, JavaScript
GUI Tools Visual Studio 2005/2008
Languages C++, C#, .Net, ASP.Net, VB.Net,
Databases SQL Server 2012/2008R2/2008/2005/2000, Microsoft VS 2010/2012/2013
OLAP Tools SQL Server Reporting Server 2008/2005, SSIS (as ETL)
Third Party Tools Spotlight and Redgate
Education
BS In Computer Science and Mathematical
Cerner Corporation, North Kansas City, Missouri June 2012 – Present.
Role: SQL SERVER DBA
Description: Cerner Corporation is a global supplier of health care information technology solutions,
services, devices and hardware. My job was there to schedule jobs, back up, recovery and both from an
application view as well as disaster recovery. Provide 24/7 online support to production.
Environment: Windows 2003/2007/2008, MS SQL Server 2012/2008/2005, SQL Server reporting
services, T-SQL, SQL Query Analyzer, replication, monitoring.
Responsibilities:
• Installed SQL Server 2005/2008R2/2012 Servers on windows 2003/7/8/8.1 Platform.
• Monitoring the Schedule job, Backup, SQL Server database and Replication.
• Managing database backup and recovery Create database objects including tables, triggers, views,
stored procedures, indexes, defaults and rule.
• Experienced in trouble shooting, performance tuning, query tuning, index tuning using DBCC
command, Wizards and SQL Profiler.
• Set database access privileges for different users and user groups.
• Perform optimization of SQL queries.
• Maintenance of clustered and non-clustered indexes. Create jobs and monitor job history for
maximum availability of data and to ensure consistency of the databases.
• Developed DTS, SSIS Packages to transform data from excel file to SQL Server database.
• Perform database consistency checks at regular intervals.
• Monitor SQL Server activity through profiler.
• Developed backup & restore scripts for SQL Server as needed.
• Monitor server space usage and generate reports.
• Developed standards for SQL Server maintenance / updates.
• Design and implementation of database maintenance plan.
• Performance optimization and normalization of database.
• Tuning and optimizing queries and indexes.
• Job, Scheduling, batch, alert and E-mail notification setting.
• Maintained Disaster recovery strategies for the database and fail-over methods.
• Monitor SQL Server log files.
TCF Bank, Minneapolis, MN May 2011 – May 2013
Role: SQL Server DBA
Description: TCF Banks are affiliated with TCF Financial Corporation, a financial holding corporation
based in Minnesota. TCF has 444 banking offices in Minnesota, Illinois, Michigan, Colorado, Wisconsin,
Indiana, Arizona and South Dakota. My job was there to perform migration, log shipping, store procedure
and troubleshooting the issue that cannot be resolved within the establish timeframes.
Environment: Windows 2003/2008, SQL 2000/2005, T-SQL, Replication, SSIS, SSRS, Database
Mirroring, Lite Speed, BMC (Ticketing).
Responsibilities:
• Managed the migration of SQL Server 2000 databases to SQL Server 2005.
• Implemented new SQL Server 2005 concepts like Data partitioning, Snapshot isolation.
• Created Documentation for steps need to be taken while upgrading the SQL server 2000 to
SQL server 2005.
• Rebuilding indexes at regular intervals for better performance.
• Expertise in SQL server Reporting Services (SSRS).
• Scheduled package execution in SSIS.
• Installing packages on multiple servers in SSIS.
• Extensively worked on SSIS for data manipulation and data extraction, ETL Load.
• Created extensive reports using SSRS (Tabular, Matrix).
• Installed, configured and maintained MS SQL Fail over clustering to provide server high availability
solution for 6 different environments.
• Involved in tuning SQL Server databases using available tuning methods like index tuning wizards,
profiler and execution plans.
• Monitored & modified Performance using execution plans and Index tuning.
• Used log shipping for synchronization of databases.
• Worked in Active passive cluster environment.
• Prepared Documentation for the Disaster Recovery plan.
• Wrote and debugged Stored Procedures, (DDL) triggers, functions as per client requirements
and (DML).
• Extensively worked on troubleshooting and fine-tuning of databases for its performance.
• Designed and implemented comprehensive Backup plan and disaster recovery.
• Hands on experience in trouble shooting database issues. Update statistics, database integrity
check and Backup operations.
• Worked on call 24/7 Support on weekly basis.
Gain Capital, Bedminster, NJ Mar 2010- April 2011
Role: Senior SQL DBA
Description: Gain Capital a fortune 500 company dealing with Financial products. The role was to
manage SQL Server instances and give 24/7 support. Managed SQL servers in HA/DR and replicated
environments and gave On-call support
Environment: MS SQL Server 2008/2005Windows 2000/2003/2008 Server Operating systems, SSIS
and SSRS.
Responsibilities:
• As a Production and development DBA managed 63+ SQL Servers with size ranging 20 GB to
1 Terabyte in a 24x7 Production environment.
• Installed SQL Server 2008 and SQL Server 2005 on Windows 2003 and 2008 servers, applied
service packs and security fix for all servers.
• Successfully Upgraded most of the MS SQL Server from SQL 2000/2005 to MS SQL Server
2008
• Installed SQL Server 2008 and SQL Server 2005 on windows 2003 and 2008 servers on
VIRTUAL Servers, applied service packs and security fix for all servers.
• Extensively used VMware for Virtual environment.
• Configured and maintained Log shipping architecture to provide backup server solution for 4
environments.
• Managed SQL Servers in Clustered environments.
• Installed, configured and maintained MS SQL Fail over clustering to provide server high
availability solution for 6 different environments.
• Experience in upgrading from SQL Server 2000 to SQL Server 2005 servers.
• Upgraded server from MS SQL Server 2005 to MS SQL Server 2008.
• Did extensive Database design and Modeling using ERWIN.
• Created the DTS, SSIS packages to import the data from MS Access SQL Servers.
• Created SSIS packages to Extract and Load data from diverse source (flat file, excel, xml and
oracle)
• Used Send Mail, Bulk Insert, Execute SQL, Data Flow, Import Export control extensively in
SSIS
• Performed Multi File Imports, Package configuration, Debugging Tasks and Scripts in SSIS
• Involved in securing the SQL Server environment and involved in setting up the user
permissions.
• Experienced with creating database maintenance plans for efficient operations.
• Created the backup schedule for production, test and development servers.
• Involved in restore operations to refresh the data from production to test servers.
• Experienced in troubleshooting production servers and fixed the user and application issues.
Pfizer Inc, New York City, NY Dec 2008 – Feb 2010
Role: SQL Server DBA
Description: Pfizer is a world leader in the Pharmaceuticals and Healthcare industry. It is well known
for its large variety of products. It leads the list of companies of its kind in terms of sales. The project was
about the backend maintenance of their huge databases which supported the company’s numerous
applications. Mostly the applications were designed to monitor their daily sales and orders.
Environment: Windows Server 2005, MS SQL Server 2008 Enterprise Edition, SQL Profiler, SSIS, and
SSRS.
Responsibilities:
• Responsible for the Installation, daily monitoring, maintenance of SQL Server 2005 installations in
both the production and development Environments and also upgrades to SQL server 2005.
• Involved in the configuration of new SQL Server Instances on Windows servers with appropriate
parameters
• Participated in the migration of the databases and managed the location of database files, log files and
their sizes.
• Migrated and validated users and logins in the new environment.
• Granted roles and permissions to SQL server users.
• Developed, implemented, and maintained procedures for ensuring the security and integrity of SQL
Server 2005 and the corresponding databases.
• Created tables, Views, Indexes, Functions and advanced queries for databases by using SSMS.
• Generated database SQL scripts and deployed databases including installation and configuration.
• Automated and enhanced daily administrative tasks including space management, database backup
and recovery.
• Involved in setting up SQL Server Agent Jobs for periodic backups with backup devices, Database
maintenance Plans and Recovery.
• Configured and maintained transactional, snapshot and merge replications.
• Performed Log shipping to a standby server to safeguard valuable data.
• Performed Database Mirroring in SQL Server 2005.
• Modified and optimized complex queries for data retrieval.
• Involved in converting DTS Packages to SSIS Packages.
• Managed the production and development databases for performance tuning, capacity planning and
database security configuration.
• Scheduled and monitored all maintenance activities of SQL Server 2005 including database
consistency check, and index defragmentation. Monitored database status including CPU, memory,
I/O, space, and deadlocks using SQL Server utilities.
• Performed Root cause analysis to track down problems and used SQL profiler for troubleshooting.
• Generated different reports using SSRS. Manage more than 20 databases running on different
Windows platform.
National Commission for Human Development (NCHD), Pakistan Aug 2006 - Nov2008
Role: SQL Server DBA/Developer
Environment: MS SQL Server 7.0/2000/2005, Windows 2000/200, Create and maintain databases after
logical and physical database design.
• Installed SQL Server 2005, 2000 Servers, multi instances and service packs for existing 7.0/2000
servers.
• Managing database backup and recovery create database objects including tables, triggers, views,
stored procedures and indexes.
• Experienced in troubleshooting, performance tuning, index tuning using DBCC command,
Wizards and SQL Profiler.
• Set database access privileges for different users and user groups.
Perform optimization of SQL queries.
• Maintenance of clustered and non-clustered indexes. Create jobs and monitor job history for
maximum availability of data and to ensure consistency of the databases.
• Developed SSIS and SSRS Packages to transform data from excel file to SQL Server database.
• Perform database consistency checks at regular intervals.
• Monitor SQL Server activity through profiler.
• Developed backup & restore scripts for SQL Server as needed.
• Monitor server space usage and generate reports.
• Developed standards for SQL Server maintenance / updates.
• Design and implementation of database maintenance plan.
• Performance optimization and normalization of database.
• Job, Scheduling, batch, alert and E-mail notification setting using maintenance plan.
• Maintained Disaster recovery strategies for the database and fail-over methods.
• Monitor SQL Server log files.
Contact this candidate