SQL Server DBA

Keyur Gondalia

MS SQL Server DBA

Email: *****.******@*****.*** Contact: 224-***-****

Summary

MS SQL Server DBA with extensive knowledge in Managing SQL Server environment.

Thirteen years of IT experience with 5+ as Database Administration in MS SQL SERVER 2012/ 2008 R2/ 2008/ 2005 in Production, Development, Testing Environments and 7+ as Software Developer, Team Lead and Project Manager.

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

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

Experience with upgrading SQL Server, database migration from version 2005/2008 to 2008/2012.

Excellent knowledge of Database concepts such as Entity-Relationship Modeling, Transactional Management, Normalization, Indexes etc.

Knowledge on Installing, configuring and maintaining SQL Server Active/Active and Active/Passive cluster.

Experience with server build and Performance Tuning using tools like Windows System Monitor, SQL Profiler, DMV's and SQL Query Analyzer and performed Query Optimization.

Hands-on experience with SSIS (SQL server Integrated Services) and SSRS (SQL server Reporting Services).

Experience in designing & implementing high availability, clustering and mirroring on standby, large database.

Automated database consistency checks, Fragmentation checks and Index Reorganization/ Rebuilding operations.

Experience in creating roles and managing user permissions, Jobs, Alerts, SQL Mail Agent, and using performance monitor/profiler for resolving deadlocks.

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

Technical Skills

Operating Systems: Windows 2012/2008 R2/2008/2003, Windows 7/8 Professional

RDBMS: SQL Server 2012/2008 R2/2008/2005/2000, MS Access

Database Tools: SQL Profiler, DTS, Management Studio/Enterprise Manager, Query

Analyzer, SSIS

Web Technologies: XML, HTML, JAVA Script

Languages: T-SQL, C, JAVA, .NET

Reporting Tools: SQL Server Reporting Services, Crystal Reports

Applications: Microsoft Office, ERWin, MS Visio

Other Tools: Power Designer, SQL Nexus, PSSDiag

Education

Master of Computer Application, Gujarat University, India.

Bachelor of Science, Gujarat University, India.

Professional Experience

Northwestern Mutual- Milwaukee, WI August 2015 – Present

MS SQL Server DBA

The role is to manage multiple SQL Servers in Production, Stage and Test environments. Support all major SQL Servers in Physical/Virtual, mirrored and replicated environments.

Responsibilities:

Provided 24/7 on call production support.

Managed 250+ Production SQL Servers in Virtual and Physical Environments.

Experience on installation, configuration and migration of SQL Server 2005, 2008 R2, 2012 on Windows 2012, 2008 R2 and 2003 servers, applied service packs and security fix for all servers.

Involved in development activities like database design, architecture and SQL scripting.

Implemented Database Mirroring on SQL Server 2008 R2 environments.

Experience with SQL Profiler and Query tuning Wizard to troubleshoot problems and queries.

Working knowledge on HA and Always on clustering.

Upgraded SQL Server 2005/2000 to SQL Server 2012/2008 R2.

Managed multiple SQL Server instances in Active/Active and Active/Passive clusters.

Installed and configured Async and Sync Mirroring for Production and DR environments.

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

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

Planned the complete Backing up of Database and restoring the Database from Disaster Recovery.

Used extensive SQL Server DMV's for Performance and System Monitoring.

Involved in migrating SQL Server Databases from Test Server to Development Server and from Development to Production Server.

Creating, Scheduling and deploying SSIS packages from Development to Production.

Used third Party tools for monitoring SQL Servers and Backing up Databases.

Hands on experience with IBM Netezza (PureSystems) appliance and Linux, which is use for analytics purpose.

Hands on experience with Powershell scripting to automate process.

Environment: Windows 2012/2008 R2 Server, MS SQL Server 2012/2008 R2/2005, T-SQL, Netbackup, DTS, SSIS, SSRS, Performance Monitor, SQL Profiler, SQL Nexus, IBM Netezza (PureSystems), Powershell, Linux.

UPS - Atlanta, GA April 2014 – July 2015

SQL Server DBA

The role was more of fine tuning performance related issues and supporting SQL Server environments. Resolving user issues related to performance. The role was also to create SSIS packages for various different ETL tasks.

Responsibilities:

Installed SQL server 2008 and Migrated SQL Server 2005 databases to SQL server 2008 by using Backup-Restore, Detach-Attach, Management Studio Wizards and custom scripts on a test environment to be the future production environment.

Worked on resolving major performance issues for databases.

Researching on database/index fragmentation and running rebuild indexes and update statistics.

Using latest SQL Server DMV’s for finding performance bottlenecks.

Running Index tuning wizard and rebuilding indexes for faster query response.

Configured the Log shipping and scheduled jobs to setup log shipping between production servers.

Implemented Transactional Replication between Primary Server and Sub Systems.

Involved in development of automated daily, weekly and monthly system maintenance tasks such as database backup, replication verification, and database integrity verification and indexing updates.

Created Users and Roles, and managed security and permission of different SQL Server objects.

Running DBCC consistency check and fixing data corruption in user databases.

Experience in Tuning Databases using Performance Dashboard.

Developed several reports using SQL server Reporting services (SSRS).

Maintained stand by servers using log shipping and replication concepts.

Prepared the coding guideline documents for SQL server developers.

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

Coordinating with the development team regarding tuning the SQL queries and stored procedures.

Environment: Windows Server 2008 R2, Microsoft SQL Server 2012/ 2008/ 2005, T-SQL, SSIS, SSRS, Database Tuning Advisor, SQL Profiler.

Coach- Secaucus, NJ March 2013 – March 2014

SQL Server DBA

Participate in a big team of DBA’s and give 24/7 support and on-call support for SQL Server databases.

Responsibilities:

Installation of SQL server 2005/2008 on Production and Virtual environments.

Implemented transactional and snapshot replication in development environment.

Used dynamic management views (DMV’s) to monitor the health of a server instance, diagnose problems, and tune performance.

Interacting with Business Analysts & Developers in identifying the business requirements, designing and implementing the database schema.

Installation of SQL servers on Development, Stage and Production Servers.

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 privileges to users and groups.

Provided 24/7 on call production support during off hours/ weekends/ holidays.

Experience in using Crystal Reports for designing reports.

Created batch files for executing the SQL server database objects.

Imported data from text files and excel spread sheets into SQL Server 2000 databases using DTS packages.

Writing new stored procedures and modifying existing ones and tune them such they perform well.

Implemented auditing using triggers and enforcing business rules via checks and constraints.

Automated processes using SQL Server jobs.

Proper use of views to prevent unauthorized access.

Environment: Windows Server 2008/ 2003, MS SQL Server 2008/ 2005/ 2000, SSIS, SSRS, SQL Compare.

Rite Aid Corp – Camp Hill, PA August 2011 – February 2013

SQL Server DBA

Primary responsibility was to interact with developers and carry out migration, build/releases, give level I support and support major performance related issues on SQL Server. The role also was to develop extensive SSIS/SSRS packages for ETL and daily maintenance.

Responsibilities:

Provided 24/7 production support on a rotating roster schedule.

Suggested design and architecture structure for Databases and servers.

Implemented SQL Server 2012/2008R2 Active/Active cluster setup on Windows 2008 R2 servers.

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

Configured and Monitored MS SQL Server 2008R2 in Log Shipping from primary server to DR server (different geographical location) and also carried out role changes and role reversals.

Installed and configured SQL Server 2008R2 and 2005 with Service Packs as per the Business Requirements in UAT, Development & Production environments

Creating, Monitoring and Troubleshooting Maintenance Plans for checking database integrity, rebuilding indexes and updating statistics.

Used Performance Monitor and SQL Server Profiler (ran Trace) to optimize long running queries and thereby improved the performance of the queries.

Worked with different teams (Application, Active directory, Engineering & QA) to deploy projects to UAT (Testing), Development, and Production environments.

Used SQL Server Upgrade Advisor to analyze SQL server 2005 in the process of migration.

Hands on experience with SQL development like stored procedure, function.

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

Routine tasks but not limited to: Monitoring and Maintaining the security, integrity and availability of Servers, performance tuning, building packages, responding to users and developer issues and monitoring database backups.

Environment: Windows Server 2008 R2/2003/2000, MS SQL Server 2012/ 2008 R2/ 2005 /2000, Business Intelligence Development Studio, T-SQL, SSMA, SQL Safe backup, IDEARA Diagnostic Manger, DTS, SSIS, SSRS, Performance Monitor, SQL Profiler

Kera Designs - Ahmedabad, Gujarat January 2011 - June 2011

Project Manager

Avid Technosys - Ahmedabad, Gujarat September 2009 - December 2010

Project Manager

URL Software Pvt. Ltd. - Ahmedabad, Gujarat June 2007 - August 2009

Web Manager

Work as Software Developer from Aug 2004 - Jun 2007 in different companies.

Contact this candidate