Sql Server Professional Experience

Terry Tamar Oliver

Snellville, GA. ***** (***************@*****.***) 678-***-****

Programming Applications

Operating Systems

Database

Development

C, C++,C#

Java Script

ASP.Net

Java, Visual Basic

HTML, PHP, XML

MS DOS

Windows XP, 7 & 8

Unix

Linux

Oracle,

SQL

Access

IBM DB2

DBMS

Capacity Planning

Architecture

Testing

Competencies:

Data Warehousing Security Recovery Disaster Planning Programming Software

Information Systems Security Troubleshooting Development Supervisor Data Mining

Education:

Bachelor of Science Computer Information Systems, DeVry University, Alpharetta, GA. 2011

Concentration in Enterprise Computing

Dean’s List 3.6/4.0 Worked full-time while attending school.

Professional Experience:

Terry Oliver

SQL Server Database Administrator

Summary:

•5 plus years of experience as SQL Server DBA (2014, 2012, 2008, 2005, and 2000) in Production, Development and Staging, Data Warehouse environments (OLTP and OLAP).

•Experience in MS SQL Server Installation, Configuration, Performance Tuning, Client/Server Connectivity, Query Optimization, Backup/Recovery and Running DBCC Commands.

•Experience in applying latest Service Packs and Rolling Patches and Upgrades for SQL Servers in Clustered (Failover) and Non-Clustered environments.

•Experience in Configuration and Maintenance of Disaster Recovery solutions like Clustering, Database Mirroring, Log Shipping, Transactional & Merge Replication in SQL Server 2012/2008/2005

•Installed and Configured SQL server 2014 on VMware environment.

•Prepare, document and conduct Disaster Recovery exercises.

•Migrated SQL Server 2005 databases to SQL Server 2014 and configured Always on availability group.

•Involved in Implementing of multiple multi-node clustered community environments, which supported multiple instances of SQL Server 2005 and later.

•Actively involved in setting up Active-Active/Active-Passive clustering in production and Testing Environments and also troubleshoot issues with the same. Applied Hotfixes and Service Packs in clustered environments

•Configured Database Mirroring in High Performance and High Availability mode and troubleshoot issues with the same

•Expertise in Query Optimization, Performance tuning, Database consistency using DBCC utilities and server connectivity, DMV’S, DMF’S, analyzing Locks, Deadlocks and Handling the Isolation Level and Concurrency Effects.

•Verifying and tuning stored procedures created by developers by using Execution Plans, SQL Server Profiler and Database Tuning Advisor. Debugging stored procedures, optimizing code and improving efficiency in database including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks

•Experience in administrative activities comprising Database Health Check, Index Optimization (Rebuild and Reorganizing Indexes with different fill factors), Updating Statistics, Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Security.

Education:

•Bachelor of Science Computer Information Systems, DeVry University, Alpharetta, GA

Technical Skills:

Relational Databases

SQL Server 2014/2012/2008/R2/2005, MS Access, SQL*PLUS

Operating System

UNIX, Windows 8.1/7/2000/2003/2008/2012 Server, Windows NT, XP

Programing Languages

C, C++, PL/SQL, Java, VB and T-SQL

Other Tools

VERITAS, IDERA, Crystal Reports, Test Director, PVCS Tracker, Rational Clear Quest, Compuware, TOAD, MS Visual Source Safe

Reporting Tools

SQL Server Reporting Services (SSRS), SSAS, and Report Builder

Data Modeling

Business Intelligence Development Studio, Erwin 7.2/4.5, MS Visio 2003/2007, JIRA

Professional Experience:

CBS, Atlanta, GA April 2016 to till date

Database Administrator

CBS Corporation (NYSE: CBS.A and CBS) is a mass media company that creates and distributes industry-leading content across a variety of platforms to audiences around the world. I was involved in installation and configuration of SQL Server 2014 and Business Intelligence, Work with Agile Methodology for Analyzing DBA. Work on Managing migration of complex infrastructure and support of critical production environment.

Responsibilities:

•Installation and Configuration of the SQL Server 2014 and Business Intelligence.

•Worked in the agile environment as Database Administrator to analyze the call data.

•Collaboration with project management teams, vendor’s, and technical subject matter experts to implement database and application migrations.

•Successfully managed migration of very complex infrastructure and critical production environments with minimal impact to business.

•Monitoring SQL Server and Windows event logs to find root cause for the problem.

•Creating the jobs, manually executing and troubleshooting the jobs. Identifying orphaned users and fixing them after restoring the backups.

•Troubleshooting database level problems like suspect/emergency/single- user/restoring/stand-by modes.

•Created and configured an OLTP replication database for disaster recovery purpose.

•Implemented SQL Server OLTP services (SSAS) for building data cubes.

•Defined MDX scripts for querying the data from OLAP cubes (SSAS) and build reports on top of cube.

•Monitoring the disk space and removing unnecessary backup files and shrinking large T-Log files to free up space on the disk Drive.

•Configuring, maintaining and monitoring the Log-shipping, troubleshooting the problems in Log-shipping.

•Configuring Mirroring between the databases and maintenance and failover from Principal to Mirror and troubleshooting the issues in the mirroring.

•Monitoring the database, data file and log file sizes and checking the available free space in that.

•Creating, monitoring and troubleshooting maintenance plans created for rebuild-indexes, reorganize-indexes, statistics updates and database consistency checking.

•Shrinking the temp Database and resolving the disk space issue.

•Moving the databases / database files from once location to other location.

•Creating users and mapping users with the appropriate databases and assigning the roles.

•Performing the Database refresh by taking the backup and restoring and making the production equivalent.

•Creating alerts for the databases to take necessary action before files reaches max size.

•Identifying users’ workload and active transactions and what operation is going on take decision and killing the transactions when required for any other operation.

•Monitoring and Troubleshooting SQL Server Performance using Query Tuning, SQL Server Profiler, System Monitor, Database Engine Tuning Advisor, Dynamic Management Views and Functions and Resolving Blocking and Deadlocking Issues.

Environment:

Agile/Scrum, Windows 2008, Microsoft SQL Server 2014/2012, SQL Profiler, T-SQL, Crystal Reports, MS Visio, MS Office, MS Project.

M &T Bank, Buffalo, NY Jan 2014 to April 2016

SQL Server Database Administrator

M&T Bank is one of the largest US headquartered commercial bank holding companies. The project was to installation and administration of SQL Servers and improving the performance of the system. Reports are also created for the banking process on the daily and weekly basis. These reports are reviewed by directors and analysts to calculate different categories like banking calculation. It also involved in creating new database from different scatter database.

Responsibilities:

•Installed SQL SERVER 2008/2008r2/2012 FAILOVER Cluster and standalone installation on Windows Server 2008 r2 64-bit system in PROD/TEST/DEV from scratch.

•Practiced the DR (disaster recovery exercise) at SunGard for SQL Server 2008/200r82/2012.

•Setup the Transactional Replication for the reporting purpose

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

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

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

•Implemented Transactional Log shipping and mirroring for database high availability.

•Regularly installed service packs and hot fixes for both clustered and standalone environment.

•Configured the alerts and jobs for the regular monitoring of the database Server.

•Used native tools DATABASE TUNING ADVISOR, PROFILER, PREFMONCE and ACTIVITY MONITOR.

•Regularly deployed the reports and configured the subscriptions for automated email delivery of the reports.

•Scheduled agent jobs for database backup and windows task to clean up the file system using VB Script

•Configured Linked Servers between different servers.

•Setting up logical/physical backups for the databases.

•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.

•Used the DMV and DMF for the performance data collection and monitoring.

•Involved in Performance tuning and Query Optimization.

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

•Created and configured an OLTP replication database for disaster recovery purpose.

•Implemented SQL Server OLTP services (SSAS) for building data cubes.

•Defined MDX scripts for querying the data from OLAP cubes (SSAS) and build reports on top of cube.

•Implemented SQL Audit 2012 and Server Side trace for auditing at server and database level on SQL Server 2012.

•Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.

•Administered the SQL Server 2008 r2 for the Microsoft Dynamics GP 2010(Great Plains Software)

•Developed stored procedures, functions, triggers in T-SQL and batch scripts.

•Used the TFS and Rational Clear case for change management in the SDLC cycle

Environment:

Microsoft SQL Server 2012/2008 R2/2008, Windows 2008, TFS, Oracle Streams, Data Guard, TOAD, T-SQL, SQL Loader, DMV, DMF, VB Script, MS Office, MS Visio, Visual Studio, SQL Profiler, SQL Server Management Studio.

Medtronic, Minneapolis, MN Jan 2013 to Jan 2014

SQL Server DBA

Medtronic is one of the leading Healthcare companies in the USA. It is ranked as one of the top 50 companies in the US for diversity. Medtronic’s focus is on improving the lives of the people they serve and the health of our communities. Medtronic incorporates a sense of integrity and respect for work ethics in generation of employees that are associated with it.

Responsibilities:

•Installed and configured SQL Server 2008/2008R2 on both cluster and stand-alone environment.

•Installed SQL SERVER Service Packs to keep the SQL Server up to date.

•Maintained DB Security by creating logins, users, roles and permissions for the business people.

•Responsible for activities daily routine backup restore, refreshing databases as per requirements.

•Scheduled and created Maintenance plans on databases and also created automated jobs.

•Performed Database consistency checks with DBCC, Defrag, Index tuning and monitored error logs

•Configured and managed log shipping between DC and DR servers for Disaster recovery solution.

•Involved in planning load balancing based on application’s physical design.

•Performed the DR Drill (Cutover) on Log shipping database routing the application from DR Servers and testing the Application connectivity.

•Configured SQL Server 2008 multi Node Cluster (Active-Active and Active passive).

•Implemented different types of replications Transactional, Snapshot and merge replications.

•Provided On-Call support to Mission Critical Environments and expertise with Disaster Recovery mechanisms

•Upgraded SQL Server 2005 to SQL Server 2008/2008R2 in windows server 2008 64bit.

•Experience in migration and maintenance of data using various utilities like DTS, SSIS, Import and Export, ATTACH/DETACH Data Migration tools.

•Provided support for 24x7 availability of database Services and ensure to meet the SLA.

Environment:

SQL Server 2008/2005, MS-Access, Windows 2008, DTS/SSIS, SSAS, Visio, Lite-speed, SQL Diagrams, Activity Monitor, Spotlight. Index tuning wizard, SQL Profiler, Query Analyzer, Enterprise Manager, SCOM, Silverlight.

Contact this candidate