SQL Server DBA
Resume:
Salman Kazi
*********@*******.***
Summary
* ***** ** *** ********** in SQL Server 2014/2012/2008/2005/2000.
Experienced in database administration activities like installation, configuration, backup & recovery, database Security and data transformation services.
Expert in installation, upgrade and configuration of MS SQL Server 2014, 2012, 2008, 2005 & 2000.
Experienced in Always On SQL Server 2012/2014.
Tested and implemented Log Shipping with SQL Server 2005/2008.
Successfully implemented Database Mirroring in SQL Server 2005, 2008 for high availability and disaster recovery.
Experienced in implementing Snapshot, Transactional Replication models.
Experienced in Installing, configuring and maintaining SQL Server Active/Active and Active/Passive cluster.
Experienced in creating maintenance plans, Jobs and sending alerts using database mail.
Experienced in installing Service Packs and Cumulative Updates for SQL Server.
Good Knowledge in preparing and updating cost cutting and disaster recovery documentation.
Developed backup and recovery strategies for production environment.
Experienced working with 24x7 Production support for 2014, 2012, 2008, 2005 and 2000 SQL Server.
Good knowledge of Relational Database Management Systems (RDBMS).
Conversant with all phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation Experience in working with high transaction OLTP systems in SQL Server 2000/2005/2008/2012.
T-SQL coding and testing: indexes, views, triggers, functions, cursors, stored procedures etc.
Experienced in Performance Tuning, Query Optimization, Client/Server Connectivity and Database Consistency Checks using DBCC Utilities.
Involved in Performance tuning of Stored Procedure.
Worked on partition table in SQL 2008/2012.
Worked on DMVs, System tables and Stored Procedures for performance tuning.
Extensively worked on Performance tuning of stored procedure.
Experienced in creating SSIS packages, Jobs, Sending Alerts using Database Mail.
Monitoring Event viewer, SQL Error logs for software and hardware related errors.
Experienced in using tools like SQL Profiler and performance counters for Monitoring and Tuning MS SQL Server Performance.
Creation and maintenance of Databases, creating Roles and managing user permissions.
Experienced in implementing Various RAID technologies.
Experienced in SQL Server Integration Services (SSIS).
Experienced in Extracting, Transforming and Loading of Data from Excel, Flat file, Oracle to MS SQL Server by using BCP and DTS Import/Export utility, SQL Server Integration Services (SSIS).
Migrated DTS Packages to SSIS Packages.
Deployed SSIS Packages to MSDB and file system from development to Production environment.
Worked with Popular Third Party monitoring solutions like Red Gate and Ignite.
Management of users including creation/alteration, grant of system/db roles and permissions on various database objects.
Worked on backup tools like Red Gate.
Excellent communication skills.
Good team player with strong analytical skills.
Flexible, enthusiastic and project oriented team player with solid leadership skills to develop creative solution for challenging client needs.
Hardware/Software Skills
Applications:
SQL Server 2000/2005/2008, Visio, Netscape, Internet Explorer, DNS Servers, Web servers using IIS, Netscape, Apache, Mail Servers using MS Exchange 5.5 and Mailer Daemon, FTP servers using Wu-Ftpd, NcFtpd, RADIUS, MS Ftp, Proxy/Cache server using Squid and MS Proxy 2.0, Microsoft Internet Security and Acceleration Server, PcAnywhere v9, Adobe Photoshop, Corel Draw, Page Maker, Microsoft Office Suite.
Internetworking
Configured and maintained Cisco routers (2500s, 1700, 1600s, 800s & 700s series) for WAN links.
Experienced in Implementation of Internet Service Provider’s Setup.
Operating Systems
Windows NT/9x, Windows Server 2003/2008/2012, Windows XP, Windows Vista, Windows 7 and Windows 8.
Professional Experience
GM Financial, Arlington, TX Oct’15 – Current
Sr. SQL Server DBA
Responsibilities
Designed and implemented Always-On on 4 node multi-subnet clusters.
Working on migration projects from SQL Server 2008R2/2012 to SQL Server 2014.
Installed/configured Windows Cluster -- installed/configured SQL Server 2012/2014 on a Failover Cluster.
Changed/implemented backup strategy to meet their RPO and RTO.
Implemented and Configured Data Domain environment for SQL Servers.
Responsible for reviewing, optimizing and deploying database scripts through change management.
Providing 24 X 7 on call support for production databases.
Intel Security (McAfee), Plano, TX Apr’12 – Sep’15
Sr. SQL Server DBA
Responsibilities
Migrated, Upgraded and consolidated different versions of SQL Servers for Data Center Migration.
Implemented SQL Server 2012 Always-On for Load Balancing and Disaster Recovery.
Installed SQL Server 2008R2/2012 service pack and cumulative update in STG, QA and PROD environments.
Implemented Log Shipping between PROD Servers.
Implemented centralized solution for monitoring jobs, Database Mirroring and Log Shipping.
Installed, maintained and monitored SQL Server 2008/2012 on 4 Node Clusters with mount points.
Installed SQL Server 2005/2008/2012 clusters for high availability and applied service pack and cumulative update.
Created Linked Server for Oracle connectivity.
Implemented Transactional Replication.
Implemented maintenance plans for Backups, DBCC, Clean ups, and Rebuilding Indexes.
Responsible for all the change in production using the Change Request standard procedure.
Provided on call support for major issues.
Implemented solution for backup and recovery based on SLAs.
Environment: SQL Server 2000/2005/2008/2012 Enterprise Edition, Windows 2003/2008/2012, TSQL, SQL Server Integration Services (SSIS).
Frontier Communications, Allen, TX Jul’10 – Mar’12
SQL Server DBA
Responsibilities
Installed SQL Server 2008 R2 with service packs in production and UAT environments.
Implemented Log Shipping between Production Servers.
Maintained and monitored SQL Server on 2 Node Active/Active Clusters.
Upgraded SQL Server 2005 to 2008 using Side by Side strategy.
Migrated servers in a Consolidated & Virtualized Environment for cost cutting.
Implemented Transactional Replication & Database Mirroring In SQL 2008.
Applied SQL Server 2005/2008 patches on production.
Configured Linked Servers between Oracle and SQL Server 2005/2008.
Setting up database backup and recovery procedures for production, test and development servers.
Designed and created user databases, tables, views, complex stored procedures and SQL joins and statements.
Worked on Optimization and Tuning of Stored Procedures and T-SQL queries.
Created maintenance plans for performing Optimizations, Backups, Rebuilt and Reorganize indexes.
Designed documents for Capacity Planning and System Maintenance for Production.
Resolved deadlocks and blocking issues using Performance Monitor, SQL Server Profiler.
Used BCP and Bulk Insert for transferring data between various environments.
Worked on DMVs, System tables and Stored Procedures for performance tuning.
Worked in SQLCMD mode in order to investigate/troubleshoot SQL Server Database Engine.
Created jobs and alerts for monthly and weekly Maintenance Plan.
Worked with T-SQL, DDL, DML and DCL statements.
Created tables, indexes, views, complex stored procedures, functions, defaults, rules and constraints.
Prepared documentation for cost cutting and management of Production Servers.
Actively participated in gathering requirements from business users to create new database objects.
Coordinated with Windows Net-Backup and System Management teams for resolving backup and performance issues on regular basis.
Creation of Jobs, Schedules, Alerts using SQL Server Agent and Notifications using SQL Mail and Database Mail.
Provided 24x7 production support.
Created, tested and Deployed SSIS packages from system test and UAT to production.
Environment: SQL Server 2005/2008 Enterprise Edition, Windows 2003/2008, TSQL, SQL Server Integration Services (SSIS) and DB2.
Verizon, Irving, TX Jul’08 – Jun’10
SQL Server DBA/Windows Server Admin
Responsibilities
Created databases and tables after thorough business analysis, technical analysis, and systems design.
Configured database replication and database mirroring for load balancing and redundancy.
Involved in design and development of disaster recovery plan.
Developed, deployed and monitored SSIS packages.
Migrated DTS to SSIS.
Performed daily database tasks including backup, restore using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Agent, and Database Engine Tuning Advisor.
Resolved issues and improvised the process to ensure a stable and accurate solution.
Used SQLCDM for resolving the issues related to SQL Server Database Engine.
Provided technical and systems knowledge to team members.
Work with architects, developers on business and technical issues, helping in designing of system; and testers to ensure all requirements are correctly translated.
Deployed database objects from development/UAT environments to production environment.
Responsible for monitoring and making recommendations for performance improvement in hosted databases involving index modification, file group modifications, and adding scheduled jobs to rebuild indexes and update statistics on tables.
Monitored SQL Server performance using SQL Server Profiler.
Monitored and modified performance using execution plans and Index tuning.
Involved in trouble shooting and fine-tuning of databases for its performance and concurrency
Prepared project management and technical documentations.
Export/Import data from other data sources like flat files using Import/Export through DTS, SSIS.
Analyzed and tuned long running slow queries using execution plan.
Configured transactional replication.
Created Linked Servers between SQL Server 2005 and DB2/Oracle.
Set up SQL Server configuration settings.
Implemented SQL Logins, Roles and Authentication Modes as a part of security policies for various categories of users.
Environment: SQL Server 2005 Enterprise Edition, Windows 2003, TSQL, SQL Server Integration Services (SSIS), Visual Source Safe and DB2.
Blackduck Sofware, Waltham, MA Apr’08 – Jun’08
Jr. SQL Server DBA
Responsibilities:
Installed and configured MS SQL Server 2005.
Designed SSIS packages in order to automate SQL Server administration.
Configured load balancer in order to distribute traffic among all web servers.
Extensively worked on DBCC commands and the DML commands to manipulate data.
Assisted in planning for the relocation of servers.
Responsible for all database in SQL Server environments
Performed task like backup, restore, code review, security planning and implementation.
Interacted with Windows administrators on almost daily basis.
Environment: SQL Server 2005, Windows 2003/2008, UNIX, Linux and Indexing applications.
Education:
BBA (Management Information Systems) from University of Central Oklahoma, Oklahoma 2007.
Contact this candidate