Resume

Sign in

Sql Server Maintenance

Location:
Florida, United States
Posted:
August 22, 2018

Contact this candidate

Resume:

Marina Thomas

PROFESSIONAL SUMMARY

*+ years of experience in Database Administration for very large and complex databases in SQL Server 2016/2014/2012 SQL Server 2008 R2, 2008 and 2005.

Experience in Database Design, capacity planning, installation, database creation & configuration, maintenance & administration of databases

Expertise in Always-On Availability Groups (AAG) Troubleshooting

Experience in Backup & Recovery operations in critical production environments

Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.

Strong technical background along with the ability to perform business analysis and write effective documentation and specifications.

Administering SQL Server High Availability and Disaster Recovery strategies.

Experience in using DMV and dynamic management functions for finding out long running queries.

Worked extensively on Clustering and server consolidation. Troubleshooting production issues and raising high availability.

Worked on configuring SQL Server with minimum privileged access.

Troubleshoot performance problems, fine-tuning of databases and index Analysis.

Worked on SQL Server 2016 migration from SQL Server 2012/2008 / 2005.

Maintained individual service accounts for SQL Server services on cluster with different Security groups to raise security mark.

Handling Memory configurations for SQL Server 2016/2014 and SQL Server 2012 on Windows 2012.

Working knowledge in Reporting Services(SSRS) and Clustering.

Strong experience in mentoring team members and writing documentation.

Technical Education

Bachelors in Electronics and Communication Engineering, Visvesvaraya

Technological University, Karnataka, India

Technical Expertise

Databases: MS SQL Server 2016,2014,2012,2008, MS SQL Server 2005

Programming: Visual Basic 6, Visual Basic 5, C, C++ & SQL

DBA: database administration of MS SQL Server 2016,2014,2012,2008, 2005

Operating System: Windows 2012/ 2008/2003 Advanced Server, Unix

Tools: Veritas Netbackup, Visio, ER- Studio

Professional Experience

Project #1

Title

Database Administrator

Period

August 2013 to present

Client

PricewaterhouseCoopers

Position

Database Administrator SQL server..

Description:

SQL Operations DBA team is part of the PWC Group providing complete database related services. It is responsible for Install/Configure and administration/maintenance of all PricewaterhouseCoopers databases.

Contribution:

•Installation: Configured Microsoft SQL Servers

•.Creation of database, tables, stored procedure, logins/users and user access management as per client standards.

•Implementing high availability techniques like replication and always on.

•Capacity Planning – Performing capacity planning to ensure disk will have sufficient storage for a specific period of time say about six months to 1 year.

•Migrating data to SQL 2016/2014 from SQL server 2008/2008 R2

•Backup all databases using third party netbackup tool

•Maintenance - Perform database maintenance on a weekly basis tasks such as Update statistics, re-org, rebuild etc.

•Restore backup – Restoring backups if any issues with production databases.

•Planning backup recovery strategy for all databases.

•Disk space monitoring and management.

•Use Performance monitoring tool to analyze the performance of the systems/databases.

•Debugging Locking and blocking issues on databases

•SQL Server Agent Jobs – daily basis review of failed SQL Server Agent Jobs.

•Storage – Validating disk space to have sufficient storage on drives to support databases, backups, batch processes, etc. in daily basis

•Fragmentation - Review the fragmentation level for production databases to determine if particular indexes must be rebuilt /re-org based on analysis from a backup SQL Server.

•Notification – Setting up alerts, e-mail notification for job failures, space availability, etc...

•Monitoring Ticketing tool – to analyze the issue raised and fix them.

•Volume Data Analysis - Production Database growth forecasting and capacity estimation. Configure SSL and TDE in order to encrypt the SQL Server databases.

Project #2

Title

Database Administrator

Period

August 2010 to July 2013

Client

AMEX

Position

Database Administrator SQL server..

Description:

The SQL Server DBA team provides Development Support, Production and Maintenance services to American Express. The project involves the full range of database services like data placement and reuse strategy, physical database design, sizing of databases, creation of databases, backup and recovery strategy, database monitoring and performance optimization. The team will be involved in conducting meetings with the business to understand their requirements. Further to these meetings, the team will come up with the physical database design. Subsequently, the design will be implemented through the creation of the database on the production environment. The team is also involved in enhancements to applications that already exist in production. TCS executes this project in an onsite-offshore model.

Contribution:

•Installing and configuring SQL server clusters.

•Migrate SQL Server 2005 databases to 2008.

•Build database objects in development environment and migrate them to Test and Production environment.

•Define Log shipping to synchronize primary and secondary server.

•Creating logins for users.

•Create SSIS packages for data transfer.

•Providing database access to users and applications.

•Backup and restore the database.

•Setting up SQL Server agent jobs for data archive and purge activities.

•Define maintenance plans on SQL servers.

•Disk Space monitoring and management.

•Defining transaction and snapshot replication across database servers.

•Recovery of lost objects and data files.

•Debugging Locking and blocking issues using system procedures.

•Debug database issues using DBCC commands.

•Performance tuning and monitoring.

•Monitoring of Database, Log space and filesystem/drives

•Linked server creation



Contact this candidate