Sql Server Maintenance

VIKAS RAO

Senior MS SQL Server DBA

SUMMARY:

8+ years of IT experience as SQL Server Database administrator, especially in tuning and optimization of database, providing 24/7 support of both development and production databases.

Expertise in Performance Tuning, DTA and Query Optimization

Good experience in Debugging Stored Procedures, triggers and troubleshooting database issues.

Experience using database tuning adviser to get index recommendation for complex database queries.

Hands-on working experience in Installing, configuring, Patching, upgrading and managing SQL Server 2000,2002,2008 R2,2012, 2014 and required Service Packs.

4+ Years experience in upgrading and Migrating SQL Servers from lower version to Higher version

Proficient in creating maintenance plan to automate backup jobs, check database integrity, reorganize and rebuild indexes.

Test backups to ensure we can meet the business' Recovery Time Objectives (RTO). Experienced in implementing efficient Disaster prevention and Recovery Strategies by creating backup and restore plans according to business RTO and RPO.

Performed administrative activities like creating User logins with appropriate roles, granting and denying login privileges, granting database and application roles to users and groups.

Involved in automation of administrative tasks like creating jobs, schedules, alerts using SQL Server agent and created database mail using SQL Server database mail configuration.

Involved in Data Center Migration and Consolidation Project.

Experience in Setting up AlwaysON Availability groups for HA and DR

Implemented Database Mirroring with high-performance and high-safety mode.

Configured and maintain Log shipping, Clustering (Active/Passive), Always-on.

Experience in implementing different types of Replication Models like Snapshot, Merge and Transactional on basis of business specification.

Expert in EMC and SAN management for storage and database use

Experience handing Batch processes using BCP, SSIS packages, Import & Export wizard.

Configured and deployed SSIS and SSRS packages from development to the production environment.

Have exposure to Light Speed and Spotlight as a third-party backup and monitoring tool. Experience using spotlight to troubleshoot database performance issues like blocking, deadlocks and long running queries.

Experience in Disaster Recovery Planning, Execution and Testing at remote side

Experience in providing Logging, Error handling by using Event Handler, and Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations. And creating various types of reports like Table, Matrix, Chart Reports and Ad-Hoc Report.

Experience handling Batch processes using BCP, SSIS packages, Import & Export wizard.

Experience in report building using SQL Server Reporting Services (SSRS). Hands on experience in creating parameterized reports, Drill down, Drill through, Sub reports, Linked reports, Snapshot, Cached, Adhoc reports using SSRS.

Deployed, Upgraded, and maintained SSIS, SSRS, and SSRS in the Production server.

Experience in Batch processes using BCP, SSIS packages, Import & Export wizard.

TECHNICAL SKILLS:

Databases: MS SQL server 2014/2012/2008 R2/2008/2005/2000

Operating Systems: Windows NT/98/2000/XP/Vista/2003, 2007, VMWare

ETL Tools: SQL Server Integration Services (SSIS), INFORMATICA, SQL Server DTS

Other Tools: Microsoft Visual Source Safe, IDERA, Redgate, Foglight, Sentry

Data Modeling Tools: Erwin, Microsoft Visio 2007

SQL Server Tools: SQL server Management Studio, SQL server Query Analyzer, SQL server mail service, DBCC, DTS, BCP, SQL server profiler, Event Viewer, and Index Tuning Wizard, SQL Server Agent, SSRS Log Shipping, T-SQL, DDL, SQLCMD, BIDS, Triggers

PROFESSIONAL EXPERIENCE:

JP Morgan Chase, Columbus, OH June 2014 to Present

Title: Sr.SQL Server DBA

Role: My main job duties for this project are to provide Production support and the Migration of SQL 2005/2008 to SQL 2008 R2/2012/2014. These roles which include but are not limited to are Installing SQL Server, SQL Server Configuration, and giving updated advisor reports to the team for incompatible objects when the DB is moved to higher compatibility.

Monitored the complete environment for resource utilizations and to avoid any bottlenecks.

Creating and maintaining various databases on Production and development environments using SQL Server 2008/2012/2014.

Created jobs to import/ export data obtained from various States to update the GIS servers.

Installed and configured SQL Server Reporting Services. Installed necessary Service Packs for SQL server 2005.Installed SQL server 2005, 2008 and 2012 on a test environment to be the future production environment. Upgraded legacy 2000 databases to SQL server 2005/2008.

Involved in Database Backup and recovery.

Planned and Implemented AlwaysON availability groups for 3 replicas.

Documented and managed AlwaysON availability groups.

Implemented high availability on the various servers using replication/mirroring.

Tuned databases for better performance using SQL Profiler.

Created and maintained various logins and managed security based on the required access.

Implemented and tested the point in time recovery of the production databases.

Involved in migrating share point from one server to the other.

Created various jobs to monitor resources on various servers and to mail the necessary information when threshold was reached.

Implemented high availability and disaster recovery using database mirroring with log shipping and Clustering.

Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes whenever necessary.

Expert in creating packages in SQL Server 2012/2008 R2 using SSIS

Loaded the data into another data sources (Oracle, SQL Server) using SSIS.

Created the DTS, SSIS packages to import the data from MS Access and Oracle server to SQL Servers.

Created various SSIS packages based upon the requirement. Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers and Fuzzy Lookups etc.

Created various reports using SSRS. Standardized company reports by implementing SQL Server Reporting Services (SSRS).

Created and managed database maintenance plans and design and implement backup and disaster recovery plans.

Scripting the Database Consistency Checks (DBCC), scheduling the scripts to run daily and weekly basis.

Responsible for fine tuning of the database, troubleshooting, user administration, memory management, and running DBCC (Rebuilding Indexes and fine tuning Stored Procedures).

Data migration using DTS services across different databases like Oracle, MS access & flat files.

Contacted various users in gathering the requirements and documented the necessary changes.

Analyzed various backup compression tools available and made the recommendations

Environment: T-SQL, SQL Server 2014/2012/2008 R2/2005,AlwaysOn, Clustering, Mirroring, Log Shipping, SSRS, SSAS, TCP/IP, SSIS, ETL, DTS, Windows 2003/2008 R2/2012, Red gate, Spotlight.

TD Ameritrade, Baltimore, MD January2013 to May2014

Sr.SQL Server DBA

Role: This role requires constant interaction with customers such as Application Developers, Clients and other DBA’s. This position is highly demanding therefore, requires me to provide 24 x 7 Production Support. Upgraded most of the SQL Servers to 2012 from 2005 and 2008

Responsibilities:

Upgrade and Migrate existing SQL Servers from lower version to higher version

Leverage Performance Tuning and Optimization, using native monitoring and troubleshooting tools.

Good experience in analyzing the execution plan and index management for better Query Optimization.

Good experience in identifying the bottlenecks caused by complex queries using Activity Monitor/SQL Profiler and handling them by implementing better Query Execution plans.

Proactively identify missing indexes and create them as necessary after testing to improve query performance.

Set up backup and recovery plans and monitor system performance.

Use of SCOM, Redgate Database tools set and Idera SQL Safe Archiving solution to improve the performance of the SQL Server.

Work with developers to implement best practices while programming database objects. Worked with them to optimize database before releasing it to into production.

Involved in General Database Administration, Query Performance tuning.

Installed and Configured SQL Server 2005/2008 R2/2012 Servers in Development, Staging, and Production Environments.

Created databases, logins, roles and granted appropriate permissions.

Created schedule jobs, alerts, activity logs, error logs to capture any possible errors.

Evaluated database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery.

Created SSIS packages to Extract and Load data from diverse source (flat file, excel, xml and oracle)

Installing packages on multiple servers in SSIS.

Deployed SSIS packages to MSDB database and file system using manifest file and the wizard utility inSQL Server 2008.

Supported 24*7 production support and solved all kinds of critical problems.

Participated in SDLC methodologies such as planning, analysis, design and implementation.

Setup Log Shipping and Mirroring for day one critical database as a High Availability Solution.

Setup Replication (both Transactional and Merge replication) for multiple point of presence for business data.

Setup, implement, and maintain industry standards in database management.

Created Database Maintenance Plan for the Performance of SQL Server 2012 which covers Database Integrity Checks, Update Database Statistics and Re-indexing.

Imported and Exported data (Migrated) from different sources other than SQL server (such as Access, Flat files) using Import/Export wizard.

Worked well with team members to bring the databases up to the business requirement.

Environment: SQL Server 2005/2008R2/2012, OLTP, TCP/IP, SSIS, ETL, Windows 2005, 2008, Redgate, Spotlight, SCOM, Clustering, Mirroring, Log Shipping

PNC Bank, Pittsburg, PA July 2010 to December 2012

Senior SQL Server DBA

Role: As a Senior DBA, my main role consisted of Production and Application Support while working with a team of DBAs and developers. I Interacted with DBAs and developers to resolve ongoing and arising issues. I participated in builds and releases while maintaining maximum uptime in SQL Server environments.

Responsibilities:

Installed SQL Server using standard checklist.

Query Optimization for fast and prompt data processing.

Strong Knowledge of Query performance tuning.

Recovered databases in the event of a disaster by developing and maintaining relational structures including backup/recovery and log shipping procedures.

Created and managed clustering environment such as active/passive clustering.

Configured and managed log shipping and database mirroring.

Monitoring the servers using Spotlight third party Quest software to detect CPU usages, performance issues, and disk performance.

Using indexes, fine-tuned databases to perform query faster.

Worked with DTA to improve performance of queries by implementing indexes to the missing tables.

Created Triggers to enforce data and referential integrity.

Work with Product Managers and a development team to implement integrated solutions with various technology platforms between internal technologies & outside vendors.

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

Supported 24/7 support to the team members and other clients on call during business and non-business hours.

Environment: SQL Server 2000/2005/2008 R2, Log Shipping, Transact-SQL, Enterprise Manager,

Query Analyzer, SQL Profiler, SSIS, Spotlight, Clustering, Mirroring, AlwaysON

Bristol Myers Squibb, New Brunswick, NJ October 2008 to June 2010

Title: SQL Server DBA

Role: I worked primarily as a Junior SQL Server DBA doing database administration and managing SQL Servers in production and development environments. T-SQL development and database design

Responsibilities:

Performed side-by-side migration and following both pre and post checklist for database migration.

Migrated SQL Server databases from SQL Server 2005 to SQL Server 2008 R2 and installed patches and service packs on the SQL Server 2008 R2.

Troubleshoot all migration issues on the destination servers and created all maintenance plans, jobs, logins while performing database integrity checks.

Used various methods to tune queries such as DBCC commands, DTAs and implementing indexes.

Provided excellent 24X7 Production support with on call pager support.

Automated daily, weekly and monthly system maintenance tasks such as database backup, replication verification, database integrity verification and indexing updates.

Creation and maintenance of Databases, creating Roles and managing user permissions, resolving blocks and deadlocks.

Configured Replication (Creating Distribution Databases, updating Publishers, creating & managing Publications, managing Replication monitors).

Expertise in SQL server technologies for Clustering, non-clustering, High Availability and Disaster Recovery

Worked with LightSpeed as a Backup solution for large database backups.

Configured and deployed SSIS and SSRS packages from development to production servers.

Implement best practices for Database Monitoring, Backups and Restores.

Environment: SQL Server 2000/2005/2008, Snapshot replication, Transactional replication, Merge replication, SSIS, SSRS Query Analyzer, Performance Tuning.

Polaris, Pune, India February 2007 to September 2008

SQL Server DBA

Role: Worked primarily as a Junior SQL Server DBA, gaining experience in Database administration and gradually doing senior level database administration in managing and supporting SQL Servers.

Responsibilities:

Installed, configured SQL Server 2005 R2 for both development and production environment and applied necessary hot fixes.

Setting up database Backup and Recovery procedures for development and production servers.

Configured Database mail Agent for sending Automatic emails on Errors to designated individual.

Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log issues, connectivity issues, security issues etc.

Identified and resolved the query performance using SQL Profiler and Index tuning wizard.

Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.

Worked closely with developers to recommend indexes to improve query optimization and performance.

Configured linked servers to enable the SQL server Database Engine to execute commands against OLE DB data sources outside of the instance of SQL Server.

Setup, configure and administer Snapshot and Transactional Replication on MS SQL Servers.

Participated in project team activities prior to release and contributes to documentation requirements consistent with methodology.

Worked with the transaction processing area to develop both the physical and the logical database administration functions and assists in the development of our processing database and computing environments.

Participated and worked with Data Center teams on the infrastructure, network and storage issues while defining database maintenance windows.

Provide off hour support during peak business activity period and during application deployments.

Environment: SQL Server 2000/2005 with clustering, Replication, mirroring, T-SQL, Windows 2000/2003, SSIS, Query Analyzer, SQL Profiler, Database tuning Advisor.

EDUCATION:

Bachelors of Engineering, Gujarat, India

Contact this candidate