REDI

Contact:aczi6m@r.postjobfree.com

571-***-****

Professional Summary

Microsoft certified professional in SQL Server Database Administrator (DBA) with more than five years of experience in managing, monitoring, Performance Tuning and administering databases on production and non-production servers.

Installed, Configured, and Managed SQL Server, Reporting Services (SSRS), Integration service (SSIS) in development, test, and production environment

Applied SP (Service Pack),hot Fixes and cumulative update on all versions of SQL Server

Configured Log Shipping as Standby database on Production database for Reporting

Upgraded SQL Server 2000 to 2005/2008 and SQL Server 2005 to 2008/R2 and 2012

Upgraded and migrated 1500+ databases from previous versions to recent versions.

Created Database objects using T-SQL like tables, Index, Constraints and Views.

Wrote T-SQL, Trigger, Stored-Procedures, Functions and Views.

Expertise in DML & Managing security using data control language like Deny, Grant, Revoke.

Assisted Database Developers to optimize SQL queries and Stored Procedures

Implemented HADR using Clustering, Replication, Mirroring and Log shipping.

Installed, Configured and managed SQL cluster on windows Cluster Server

Configured Snapshot, Transactional Replications and Merge Replication

Bulk Export & Import data between Flat file, CSV file & Server by DTS, SSIS, BCP

Monitoring, Performance Tuning and Optimization using DTA, DMVs & profiler.

Provided DBA support to application developers, technical support staff, and business area professionals throughout the full Software development life cycle.

Monitor SQL Server using Error Log, Event viewer and application log

Experience in Database Backup and Disaster Recovery

Restored Database from backup and experienced with Point-in-Time Recovery

Scheduled jobs to automate different database related activities including backup, monitoring database health, disk space, backup verification

Setting up maintenance plan to regularly take a Full, Differential and Transactional log backup, index management, database integrity check and update statistics.

Used DBCC commands and DMVs and DMFs to check database and server state

Monitor Server Activity, and solving problem using activity monitor and profiler

Evaluates database integrity and security Audits using SQL commands.

Education and Certification:

Administering Microsoft SQL Server 2012 Databases

Professional Experiences:

Charter, St.Louis, MO December 2015 to present

Role: SQL Database Administrator

Description: Charter Communications is an American cable telecommunications company, which offers their services to consumers and businesses under the branding of Charter Spectrum. Providing services to over 25 million customers in 41 states, it is the second-largest cable operator in the United States by subscribers. The role was to support production and non-production databases of various version and editions including High Availably and Disaster Recovery solutions.

Responsibilities:

Install, Configure, Upgrades and apply Service packs SQL Server 2005/2008/2008R2/2012 .

Created, removed and rebuilt the indexes at regular intervals for better performance of queries.

Confirm all servers/databases are up and running fine.

Performed daily tasks like backup and restore and Verified backups and test on a regular basis.

Regularly monitor and identify concurrency issues like blocking.

Periodically monitor performance using both System Monitor and DMV.

Check the fragmentation and rebuild/ reorganize the indexes. We can use a native procedure which takes care of the task.

Worked on SSRS – Report migration and Generated reports from SSRS.

Make sure all Stats Update/ Index Rebuild jobs are completed without any issue.

Monitored sql servers by both SQL Server logs and Windows logs

Set up and monitored high availability and/or disaster recovery process like Log Shipping, Clustering, Replication, Database Mirroring, AlwaysOn

Monitor all backup and log history is cleaning if it is designed.

Verify the free space on each drive on all servers using custom scripts..

Check for the failed jobs, investigate the route cause and resolve the issue.

Automated the SSIS Packages using the SQL Server Agent Jobs.

Setup and configured Database mail for notification purposes.

Created alerts and notifications for system errors, resources, fatal database errors.

Created, scheduled and monitored SQL server jobs, making sure jobs run successfully.

Developed database objects; Tables, Views, Indexes, Triggers, Stored-Procedures, etc.

Established backup and recovery of SQL server 2008 R2 by using SQL Server Agent Jobs

Worked on planning and implementing MS SQL server security and database permissions.

Worked on configuring and managing Linked Servers for Data transfer between SQL Server and other heterogeneous relational databases

Generated script files when changes applied to stored procedures and functions.

Designed Maintenance plans for System and User Databases.

Environment: SQL Server 2008 and 2008/R2,2012 Fail-Over Clustering, SSRS, SSIS

Kennedy Brothers LLC, Chicago, IL May 2013 to Oct 2015

Role: SQL Database Administrator

Description: Kennedy Brothers Construction provides construction service in contracting, construction management, design and restoration. The role was to migrate databases from previous version to the recent and from smaller editions to enterprise with High Availably and Disaster Recovery solutions.

Responsibilities:

Installed, configured and maintained Microsoft SQL Server 2012 and 2008r2 in Windows 2008r2 and Windows 2008 server environment.

Tuned database configuration for optimal system performance.

Managed proper setting of system memory and system parameters in consultation with windows administrators.

Strong production experience in managing MS SQL Server clustered environment for mission critical systems.

Created and maintained databases with optimal data file and log file sizes.

Detected performance problems including analysis of SQL, Transact-SQL.

Provide continuous monitoring, troubleshooting, historical and real time performance monitoring of the MS SQL Server environments.

Provided backup and restore functions for MS SQL Server databases

Developed and maintained T-SQL scripts supporting the database function.

Periodically refreshed development and test databases using copy of the production.

Participated in On Call weekly shift supporting off hours and weekend activity.

Manage the setup of MS SQL Server databases at Business Continuity site.

Configured and managed database as per security guidelines and industry best practices.

Maintained highly available SQL Server databases using SQL Database Mirroring, log shipping, clustering Technology.

Maintain highly secure SQL Server databases using SQL Transparent Data Encryption, SQL Line Encryption, and enhanced SQL Server Auditing features.

Strong backup and recovery experience in SQL Server 2008/R2 & SQL 2012.

Environment: Microsoft SQL Server 2012/2008/R2/2005, Windows 2008/2008r2/2003

Hisoft solution LLC, Lorton, VA April 2010 – March 2013

Role: Junior SQL Database Administrator

Description: Hisoft Solutions provides Assessments, Conferencing and Computer Consultations to its customers. My role was administering production and non-production MS SQL server database administration and monitoring.

Responsibilities:

Monitored Server Activity, Error Log, space usage, and solving problem

Developed Different Maintenance Plans for database monitoring

Applied SP (Service Pack) on SQL Server 2005 and 2008

Writing T-SQL to create and delete tables, store procedures, triggers.

Working experience in creating, modifying tables, Index (Cluster/Non-Cluster), Constraints (Unique/Check), Views, Stored Procedures, Triggers

Installed, Configured, and Managed SQL Server 2000 & 2005 and 2008/R2 in development, test, and production environment

Installed, Configured and Maintained Fail-Over Clustering using SQL Server 2008/R2

Installed and Configured SQL Server Reporting Services (SSRS)

Configured and Maintained Snapshot and Transactional Replications

Configured Log Shipping as Standby database from Production database

Upgraded databases from SQL Server 2000 to 2005 in testing and production environment

Troubleshoot job failures, performance issues, database integrity etc

Expertise in database Performance tuning.

Developed Different Maintenance Plans for database monitoring.

Scheduled jobs to automate different database related activities including backup, monitoring database health, disk space, and backup verification.

Owned problems/tasks/issues and work them through completion.

Managed data base backups and execute disaster recovery plans for a system.

Developed strategies for database tuning and optimization.

Optimize application development software and improve efficiency in production databases.

Provided guidance to DBAs by coordinating their efforts to support business applications.

Environment: SQL Server 2005 and 2008/R2, Fail-Over Clustering, SSRS, SSIS

Contact this candidate