Sql Server Windows

Tamar Grant

**********.*@*****.***

SQL Database Administrator

Summary:

Over 8 years of working experience in SQL Server Database Administration, Performance Analysis, Database Design, Development and Support of SQL Server 2012/2008/2005/2000 in Production, Development, Test, Cluster and HA/DA Server Environment.

Expertise in Installation, Upgrade, Configuration and Migration of MS SQL Server in clustered and non-clustered environments.

Well versed with Backups and Restores using jobs to schedule full, differential, and transaction log backups to use in full, simple and bulk-logged restoring as well as experience with disaster recovery planning and execution.

Adequate knowledge of SDLC and ITIL Methodologies in regards to IT Infrastructure Management.

Address and resolve technical issues related to databases and provide 24*7 supports.

Experienced in Migration from SQL server 2000, 2005 to 2008, 2008R2 by using In-Place and side-by-side upgrade process and documented Pre-Migration and Post-Migration Steps

Worked with the databases of the size ranging from 100 GB to 1TB.

Experience in query optimization & performance tuning and Used SQL Profiler, Performance Monitor and DBCC Commands, trace.

Created and managed the Database Users, Login and Security.

Developing SQL scripts for maintaining administration tasks.

Experience in applying patches and service packs to keep the database at current patch level.

Experience in High availability configuration and Disaster Recovery setup, Server clustering, log shipping, Database Mirroring.

Experienced in working with SQL server in a clustered server environment (active/passive) on windows 2003 and windows 2008 server.

Expert in Database Normalization, De-Normalization, Backup/Restore, Data Import/Export, Troubleshooting, and Objects Creation such as Tables, Views, and User created Data Types, Index Optimization, Stored Procedures, Cursors, Triggers and Partitioning.

Experience in Microsoft SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS).

Technical Skills:

Operating Systems

Windows Server 2012, 2008R2, 2008, 2003

Databases

SQL Server

MySql

2014/2012/2008/2008R2/2005/2000

Programing Languages

T-SQL, SQL, PL/SQL, PowerShell, HTML, C#, C/C++, UNIX, Linux, AIX &XML

Database / ETL Tools

SQL Server Integration Services (SSIS), SSAS, DTS, Query Analyzer, SQL Profiler, TOAD, Data Guard

Reporting Tools

SQL Server Reporting Services (SSRS) and Report Builder

Third Party Tools

NetBackup, SQL Sentry, ERwin Data Modeler and SQL Compare, BMC remedy

Professional Experience:

South Carolina Department of Social Services, Columbia, SC Jan 2015 to Jan 2017

SQL Server Database Administrator

SCDSS is proud of its diversity, efficiency, and the services that the agency and its community partners provide to more than 800,000 South Carolina citizens. Whose service is to efficiently and effectively serve the citizens of South Carolina by ensuring the safety of children and adults who cannot protect themselves and assisting families to achieve stability through child support, child care, financial and other temporary benefits while transitioning into employment.

Responsibilities:

Supporting servers in the Dev/UAT/Prod environment for SQL Server 2012 and 2014 Databases.

Deployment of SQL DB and project codes using TFS Server 2012/2013 Ultimate.

Successfully Migrated/Upgraded SQL Server 2012 to SQL Server 2014 on Development, Testing Production Environments for various mission critical applications

Configuring AlwaysOn and TDE encryption for database in Dev/ SIT/ UAT/Prod environment.

Implementing SQL Server Failover Clustering for High Availability UAT & production server

Process and approve pending DBCR request for code implementation.

Managing Access Permissions to users and groups on SQL database Servers.

Consolidation of SQL server and databases based on physical memory, server memory, I/O waits, and linked servers..

Monitoring the databases on a daily basis and checking the Event logs and Error logs.

Performing DB refreshes between all environments for testing and new code deployment.

Involved in daily loads (Full & Incremental) into Staging and ODS areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS) 2014.

Effectively using DBCC commands, Dynamic Management Views (DMV), SQL Profiler, Performance Monitor, SQL Server Management Studio, Trace Analysis and Execution plans as part of troubleshooting and performance tuning.

Involved in Performance tuning and Query Optimization.

Resolving blocking and deadlock issues using activity monitor and system stored procedures.

Applying required Service Packs, Hotfixes and any Critical Security Updates in clustered and standalone servers.

Peach State Insurance, Atlanta, GA Jan 2014 to Jan 2015

SQL Server Database Administrator

Peach State is Care Management Organization that provides health care services through its providers is using the TAP (Tailored Account Processing) system, which has been tailored from the Series III applications for the specific needs of CNA. The entire application has been developed using IAP (Integrated Application Platform). The task involves maintaining and supporting the system, by providing timely resolutions to problems reported to the Help desk and to implement any enhancements to the application.

Responsibilities:

Supporting servers in the Dev/UAT/Prod environment for SQL Server 2012, 2008 R2, 2008 and 2005 Databases.

Deployment of SQL DB and project codes using TFS Server 2005/2010/2012.

Successfully Migrated/Upgraded SQL Server 2008 to SQL Server 2012 on Development, Testing Production Environments for various mission critical applications

Configuring Log shipping for database in Dev/ SIT/ UAT/Prod environment

Implement SQL Server Failover Clustering for High Availability UAT & production server

Monitoring the Database Server's Health, Tuning, and using Profiler whenever required.

Managing Access Permissions to users on SQL database Servers.

Consolidation of SQL server and databases based on physical memory, server memory, I/O waits, linked servers, active servers, and offline database.

Monitoring the databases on a daily basis and checking the Event logs and Error logs.

Experience in database redundancy strategies, and disaster recovery (Data Mirroring, Replication, Log Shipping, and Clustering).

Setting up logical/physical backups for the databases.

Involved in daily loads (Full & Incremental) into Staging and ODS areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS) 2008.

Effectively using DBCC commands, Dynamic Management Views (DMV), SQL Profiler, Performance Monitor, SQL Server Management Studio, Trace Analysis and Execution plans as part of troubleshooting and performance tuning.

Involved in Performance tuning and Query Optimization.

Resolving blocking and deadlock issues using activity monitor and system stored procedures.

Applying required Service Packs, Hotfixes and any Critical Security Updates in clustered and standalone servers.

Configured SNAPSHOT Replication using Snapshot agent. (Creating Distribution Databases, creating & managing Publications, managing Replication monitors)

Implemented in new T-SQL features added in SQL Server 2005 that are Data partitioning, Error handling through Common Table Expression (CTE) Implemented Snapshot replication.

Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.

Analyzed long running slow queries and tune the same to optimize application and system performance.

Environment:

Microsoft SQL Server 2012/2008 R2/2008/2005, Windows 2008, SSIS, TFS, Oracle Streams, Data Guard, TOAD, T-SQL, SQL Loader.

Target Corp, Minneapolis, MN Aug 2012 to Jan 2014

SQL Server Database Administrator

Target Corporation is one of the biggest retail store business in USA. All the stores and POS registers use SQL Server databases to ring the sales and update. The project is to support all the existing SQL Servers used by the applications. Project responsibilities involved setting up SQL Servers, fixing issues, setting up High Availability and Disaster recovery process.

Responsibilities:

Installing, Applying patches to the existing SQL servers and Upgrading SQL servers.

Installing SQL Server Active-Active and Active-Passive clusters.

Configuring SQL Server jobs for Index maintenance, Database Consistency jobs, Database backup jobs and Alerts.

Ensure regular database backups and recommend the appropriate recovery models for the production databases as per the database usage.

Automating weekly and monthly non-production database refreshes.

Configuring High Availability practices like Log Shipping, Database Mirroring and Replication.

Setting up database snapshots on the secondary mirror database for reporting purpose.

Responsible for maintaining SQL Server security and granting access to users as per requirement.

Optimizing SQL Server long running stored procedures and queries.

Used ERwin data model tool to develop the Data model of the Database objects in Oracle database before migrating to SQL Server.

Built SSIS packages to extract, transform and load DBA metrics data to monitor the database growth, huge tables and wait stats.

Developed SSRS reports on the DBA metrics data.

Worked closely with developers to fix the performance issues during production hours.

Maintain and up to date inventory of the SQL Servers.

Configured schedules to capture counters on regular basis to bench mark the SQL server performance.

Environment:

SQL Server 2012/2008R2, Windows Server 2008, SSIS, SSRS, Report Builder 2.0 SQL Sentry, NetBackup, Idera, ERwin Data Modeler

Caterpillar, Radnor, PA Jan 2011 to Aug 2012

SQL Server Database Admin

Role was to provide production support to all SQL Server instances in Production, Development and QA environment. Implement Installation best practices and configure patches

Responsibilities:

Installed SQL Server in production, test and development environments.

Managed servers in Clustered, Mirrored and Log Shipping environment

Managed SQL Servers in Virtual and Standalone environments for OLTP and DSS systems

Provided technical support for the database environment including overseeing the development and organization of the databases, assessment and implementation of new technologies.

Worked with architecture, application development and operations to help achieve a state-of-the-art environment that meets current and future business objectives.

Help in-house developers improve performance of their stored procedures, TSQL codes and database design.

Managed health of SQL Servers including backups, restores and monitoring.

Configuration and troubleshooting of maintenance plans, backup remediation, job failures.

Provide a working model of transaction processing environment for capacity assessment and planning.

Develop a security scheme for the database environment, as well as assisting in set up of disaster recovery.

Provided technical support during the development, design enhancement and implementation of production databases.

Worked with the transaction processing area to develop both the physical and the logical database administration functions.

Reviewed and tune up SQL queries, stored procedures, views and triggers.

Work with others in IT to build the logical database area and provide technical guidance during all phases of the development process.

Worked with the implementation team in the installation of the new servers, migration and documentation.

Environment:

Microsoft SQL Server 2008, Windows Server 2008, SSIS, SSRS, TSQL.

Fifth Third Bank, Cincinnati, OH March 2009 to Jan 2011

SQL Server Database Admin

The Shared Services and Corporate Applications Group under Fifth Third Bank provide customer-focused, cost-effective and high-quality technology services across all divisions of the bank. The main goal is to deliver value to the Bank by creating experienced and knowledgeable centers of excellence for strategic technologies, exploiting opportunities to improve service delivery, and encouraging collaboration and best practice sharing within the Bank.

Responsibilities:

Installed and configured SQL Server Enterprise/Standard edition in the production/DR/Test/Dev environment.

Monitored the Daily Full Back-up and Transactional log backup jobs.

Involved in the configuration and maintenance ACTIVE/PASSIVE Cluster Environments for the production servers

Involved in Database and SQL Query Tuning to improve performance, identifying locking and blocking issues by utilizing DBCC commands, DMV’s and DMF’s for monitoring.

Implemented and maintain database security (create and maintain users and roles, assign privileges).

Perform general technical trouble shooting and give consultation to development teams.

Identified issues related to poor performance of complex SQL queries by analyzing missing indexes and unused indexes.

Reduced the deadlocks by using the SQL Server Profiler and setting up Trace flags for every day monitoring.

Troubleshoot and Resolved issued problems with the production server via the ticketing system BMC remedy.

Involved in taking backups of database and restoring and validating them when needed.

Experience in working in Change Data Capture (CDC) for auditing data objects in SQL Database.

Analyzed values of performance monitor counters to identify potential disk, I/O subsystem issues.

Created and Deployed RDL in SSRS server to maintain Disk space monitoring of all servers including Stage Environment.

Actively involved in development of automated daily, weekly and monthly maintenance tasks such as backups, verifying database integrity and re-indexing.

Provided dedicated supports for SQL Server production server 24/7 shifts.

Environment:

Windows server 2008/2008R2, Microsoft SQL 2008R2/2008, SQL, SSRS, BMC remedy

Highmark Blue Cross Blue Shield, Camp hill, PA Jan 2008 to March 2009

SQL Server Database Administrator / Developer

Highmark is one of the largest Health insurance companies in US. As one of the leading health insurers in Pennsylvania, Highmark's mission is to provide access to affordable, quality health care enabling individuals to live longer, healthier lives. Based in Pittsburgh, Highmark serves 4.6 million people through the company's health care benefits business.

Responsibilities:

Administering the MS SQL Server by Creating User Logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.

Perform Full Backups and Transaction Log Backups. Restore them whenever necessary. Creating back up strategies and scheduling them for execution.

Managing of database objects like Tables, views, indexes.

Worked with stored procedures for data set results for use in Reporting Services to reduce report complexity and to optimize the run time. Exported reports into various formats and resolved formatting issues.

Optimized the performance of queries with modification in T-SQL queries, normalized tables, established joins and created indexes wherever necessary.

Created views for easier implementation on web pages, and wrote triggers on those views to provide efficient data manipulation.

Backing up entire user’s database and scheduling backup process.

Successfully resolved deadlock issues by creating traces on objects using SQL Server Profiler.

Worked with DTS to load text files to SQL Server.

Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server and develop Distributed Queries.

Created logical and physical design of new database to fit new business requirements and implemented new design into SQL Server 2005.

Actively participated in gathering of User Requirement and System Specification.

Used DDL and DML to writing triggers, developed stored procedure, functions, views and triggers.

Environment:

SQL Server 2005, SQL Server 2008, T-SQL, Windows Server, HTML, VBScript, JavaScript, MS Access

Contact this candidate