Sql Server Manager

ROLES:

Senior SQL Server DBA

Senior SQL Server Developer

SSIS Developer

SSRS Developer

TOOLS / METHODS:

RedGate

IDERA Diagnostic

FOGLIGHT

SQL Compare

ERWIN

VISIO

EDUCATION:

Bachelor of Science in Computer Science, Gujarat Technological University, India

Masters in Computer science, Texas A&M University, College Station, TX

EXPERIENCE SUMMARY

Senior Microsoft SQL Server DBA with a demonstrated ability to successfully architect and implement complex large-scale, N-tier, distributed, real-time Database Environment. Outstanding track record of driving the project to success through various phases of Software Development Life Cycle.

Achievements:

Over Five (5+) years of IT experience with Database Administration on MS SQL SERVER 2016/2014/2012/2008 R2 in Production, Development and Test Environments.

Hands-on experience with Installation/Troubleshooting, Managing and Configuration of MS SQL Server 2016/2014/2012/2008 R2/2008 on Windows 2016/2012/2008/2003 server.

Implemented MS SQL Server 2017/2016 on Production and Test Environment

5+ Years experience in managing and Installing Windows Server and AD

4+ Years’ experience in Implementing Always On Availability Groups

5+ Years experience in Active/Active and Active/Passive Clustering for HA

4+ Years experience in Async and Sync Mirroring for DR and Reporting

4+ Years experience in Microsoft Azure (IAAS), PAAS implementation and management

4+ Years experience in implementing and managing SAN configurations

4+ Years’ experience in tracing and reporting activity using SQL Profiler Trace and performance

Maintained databases with sizes ranging from Large to Very Large Databases (terabytes).

Strong experience with T-SQL, Stored Procedures, Functions and Excel macros

Excellent Experience in Managing Security through Logins, Users, Permissions, Certificates, Credentials, Encryption Schemes per Company’s Security Policies

Extensive knowledge with Backups, Restoration and Disaster Recovery Planning.

Extensive experience in developing Stored Procedures, Views, Triggers, and Complex Queries on SQL Server 2016/2012/2008 R2.

Experience in Upgrading of SQL Server from version 2005/2008/2012 to 2016/2014

Highly Proficient in migration of Databases, packages and Job activities from MS SQL Server 2008/2012 to MS SQL Server 2016/2014 and also migrating the database from development to production, and migrate the data between the databases.

Experience in Constructing Server Baselines and Performance Tuning using tools like Windows System Monitor, SQL Profiler, DMV's, and SQL Query Analyzer and performed Query Optimization.

Experience in designing & implementing high availability, clustering, log shipping and/or mirroring standby, large database management, and partitioning.

Experienced in Data Migration between Homogeneous & Heterogeneous Systems using various tools (SQL Server Upgrade Advisor, DTS Package Migration Wizard, Import Export Data, DTS Packages, Bulk Insert, BCP and SSIS).

Automated Database Consistency Checks, Fragmentation checks and Index Reorganization/Rebuilding Operations.

Hands on experience in creating database maintenance plans monitored the jobs by generating alerts to be sent to the operators via email & Pager notifications using SQL Server Agent.

Recommended automated testing tools and continuous Build integration procedures.

Eliminated DB access bottleneck to significantly improve response time to client queries.

Team Player with Excellent Communication Skills

TECHNICAL SKILLS:

Windows Server 2016/2012/2008 R2, Windows Server 2003, MS SQL Server 2017/2016/2014/2012/2008 R2/2008, Microsoft Azure (IAAS), Microsoft Azure (PAAS), Amazon AWS, Amazon EC2, Enterprise Manager, Query Analyzer, Oracle 10g/11i, DTS, MS SQL SSRS, SSAS, SSIS, SQL Profiler, DB2, AIX, ASP.Net 2.0, SQL, PL/SQL, Visual Studio 2016/2012/2008/2005, T-SQL, ERWIN, Database Modeling, Microsoft VISIO, IDERA SQL Diagnostic Manager, SQL Litespeed, IDERA, Lumigent Log Explorer, Dell PowerEdge, HP Blade, VMware.

CHRONOLOGICAL SUMMARY OF EXPERIENCE

Pitney Bowes, Danbury, CT December 2015 – present

Senior SQL Server DBA

Roles/Responsibilities

Provided 24/7 production support on a rotating roster schedule

Worked on Implementing SQL Server 2016/2014 on Production, Dev and UAT environments.

Managed SQL Server on Microsoft Azure IAAS cloud and Amazon EC2 instances

Migrated SQL Server from On-Premise to Microsoft Azure cloud

Installed and configured Windows Servers and configured Domains and AD on Windows environment

Implemented Always ON with Sync and Async configuration for multiple replicas.

Implemented Always ON availability groups with three replicas for reporting and backup on SQL Server 2016

Upgraded and Migrated SQL Server 2012/2014 to SQL Server 2016.

Good exposure on Cluster environment servers, to failover/failback (Automatic/Forced) to the cluster nodes.

Configured HP/Dell/EMC and EqualLogic SAN Boxes for Disk management and RAID configurations

Designed and implemented backups/restore strategies for point in time recovery purposes

Worked extensively on setting up SQL Server Profiler Traces and analyzing results in report format

Worked extensively on SQL Server DMV's for Performance tuning

Worked on Troubleshooting and Performance tuning of SQL Server Databases

Used IDERA SQL Safe backup tool to backup databases

Extensive work on debugging stored procedure and UDF for performance bottlenecks

Created Indexes and Statistics for faster query performance

Used Performance Monitor and SQL Server Profiler to optimize long running queries and improved the performance of the Queries

Worked extensively on Database space management, performance monitoring and alert management.

Managing Security of SQL Server Databases by creating Database Users, Roles and assigning proper permissions

Involved in development of automated daily, weekly and monthly system maintenance.

Created Jobs and scheduled jobs according to the requirements

Monitored the jobs by generating alerts to be sent to the operators via email & Pager notifications using SQL Server Agent

Worked with different teams (Off shore) to deploy projects to UAT (Testing), Development, and Production environments.

Monitoring SQL Server Instances with IDERA diagnostic Manager

Evaluating SQL Scripts of Developers and Build the Test Environments and implemented them.

Performed Builds and Release.

Worked on Advanced Level T-SQL programming, creating stored procedures, views and UDF’s

Created Custom Jobs for certain DML and DDL Scripts

Environment: Windows 2016/2012/2008 R2 Server, Microsoft Azure IAAS, Microsoft Azure PAAS, Amazon AWS, Amazon EC2, VMware, MS SQL Server 2016/2014/2012/2008 R2, SSIS, SSRS, SSAS, T-SQL, SAN, SSMA, IDERA SQL Safe backup, IDERA Diagnostic Manager and other IDERA tools, Performance Monitor, SQL Profiler.

CITIGROUP, Warren, NJ September2014–November 2015

Senior MS SQL Server DBA

Roles/Responsibilities

Extensively worked in OLTP & OLAP environments that include Production, UAT and Development databases in SQL Server.

Provided 24/7 production support and resolved Level III, Level II tickets.

Worked on on-Call and Off-Shore support model to resolve and escalate production issues

Worked extensively on Microsoft Azure and Amazon EC2 cloud instances

Migrated database servers and databases from on-premise and physical instances to Microsoft Azure cloud

Migrated physical and virtual instances to Amazon EC2 instances

Worked on setting up HA and DR with Always On availability groups and clusters

Worked extensively with writing T-SQL, Stored Procedure, Functions, Views and Triggers

Implemented SQL Server 2014 Active/Active cluster setup on Windows 2014 servers.

Worked on Cluster environment servers, to failover/failback (Automatic/Forced) to the cluster nodes.

Configured and Monitored MS SQL Server 2016/2012 in Log Shipping for Disaster Recovery.

Installed and configured SQL Server 2014/2012 with Service Packs in UAT, Development & Production environments

Worked with SAN Technology and SAN boxes.

Created Maintenance Plans for checking database integrity, rebuilding indexes and updating statistics.

Designed and implemented high level backups/restore strategies for point in time recovery purposes.

Used IDERA SQL Safe backup tool to backup databases.

Used Performance Monitor and SQL Server Profiler to optimize long running queries and improved the performance of the queries.

Worked with different teams to deploy projects to UAT (Testing), Development, and Production environments.

Migrated 40+ SQL Server instances from SQL Server 2008/2012 to SQL Server 2014 version.

Converted and migrated SSIS packages from 2008 R2/2012 to SQL Server 2014 environment

Created solid ETL packages with SSIS using various transformations, sources and destinations

Created packages in SSIS with solid error handling, logging and error re-direction

Deployed SSIS packages from one server to another and scheduled the packages for automation

Configured SSRS report server and created SSRS reports

Monitoring SQL Server Instances with IDERA diagnostic Manager and Foglight

Environment: Windows 2014/2012/2008 R2/2003 Server, Microsoft Azure, Amazon AWS, VMWare, Excel, SAN, MS SQL Server 2014/2012/2008 R2/2005, T-SQL, SSMA, IDERA SQL Safe backup, IDERA Diagnostic Manager and other IDERA tools, SSIS, SSRS, SSAS, Performance Monitor, SQL Profiler.

TD Ameritrade – Columbia MD June 2013 –August 2014

MS SQL Server DBA

Roles & Responsibility

Installed Standalone and Clustered SQL Server 2008 R2/2012 instances in Production, Development, Test, Staging environments.

Managed database instances on Active/Active and Active/Passive clusters.

Created and monitored Database maintenance plans for checking database integrity, data optimization, rebuilding indexes and updating statistics.

Worked extensively on Database space management, performance monitoring and alert management.

Configuring, administration and troubleshooting multiple databases which include databases in QA and Production environments in clustered and stand-alone environments.

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

Managing Security of SQL Server Databases by creating Database Users, Roles and assigning proper permissions according to the business requirements

Suggested backup strategies, scheduled backups and Performed restoration operations.

Created Jobs and scheduled jobs according to the requirements.

Created linked server between SQL servers.

Designed and created ETL process and design in SSIS

Implemented various transformations and created SSIS packages

Created SSRS simple and Drill-down reports depending on client requirement

Dropped and recreated the indexes on tables for performance improvements.

Written complex stored procedures and functions and integrated it with the front-end application.

Tuning Queries and Database performance using tools SQL Server Tuning Advisor, SQL Server Profiler.

Data transfers between various servers using BCP and SSIS.

Extensively used SSIS to move data from text files to SQL Server.

Created packages successfully using SSIS to transfer large volume of Data.

Environment: Windows 2012/2008/2003 Server, MS SQL Server 2012/2008 R2/2005, Business Intelligence Development Studio, T-SQL, SSMA, Lite Speed, SSIS, SSRS, BCP, SQL Profiler.

Contact this candidate