SUMMARY

• Over 7+ years of experiences as MS SQL Database Administrator and programmer. Responsibilities include daily SQL optimization, Performance tuning, production support, maintenance review, Disaster recovery planning and ensuring 24x7 supports.
• Excellent experience working on different versions of SQL server like 2000, 2005, 2008, 2008r2, 2012,2014.
• Expert in the areas of MS SQL Server installation, Configuration, Server upgrade, Database design and normalization, Performance tuning, Security administration, Backup and recovery, Disaster recovery techniques such as mirroring, log shipping and clusters.
• Strong T - SQL programming skills with real time experience in customizing applications by creating and managing database objects like tables, triggers, views, stored procedures, functions and indexes.
• Experience in creating Data Model for Data Warehouse.
• Securing Organization’s Data by implementing least privilege, choosing appropriate authentication modes, data encryption, defining need specific server/database/application roles and granting permissions at granular level as required.
• Setup and configured Always on Availability Groups for DR and Reporting.
• Ensuring high availability of databases for smooth running of the business by implementing high availability solutions like Database Mirroring, Log shipping and failover Clusters depending upon the criticality of the applications and as per Organizational requirement.
• Maintain Data reliability to proactively avoid Data corruption and unexpected performance issues by implementing Maintenance plans and performing Database Consistency Checks that ensures data integrity and consistency.
• Plan and implement Disaster Recovery strategies with effective Backup and Recovery policies, setting up replication, documenting the recovery process and a tested plan to recover the databases and users as quickly as possible.
• Expertise in Performance tuning, Optimization, Data integrity and Statistics by using SQL Profiler and DB Engine Tuning Advisor.
• Working on virtualization technologies on VMware and Physical windows server.
• Monitor database server resources and provide recommendations on hardware/software upgrade to increase server performance.
• Monitor databases and resolve any blocking issues. Identify slow running queries and perform performance tuning by examining the execution plans and creating missing indexes to boost the query performance.
• Monitor SQLServer using Error Log, Event viewer and application log, and activity monitor for any blocking or heavy locking or high number of suspended sessions and wait stats of top waits.
• Planned the complete Back-up of various Databases for Disaster recovery scenarios.
• Strong T-SQLdeveloper skills including stored procedures, indexed views, user defined functions, triggers, and distributed queries.
• Experience in solving Database issues with Index fragmentation, DBCC checks, Optimization of Query, Data Integrity, Index tuning, Update Statistics, Error and Event Handling.
• Installed and configured clustering i.e. active/active and active/passive.
• Handful of experience inPowerShellScripting.
• Maintaining and Monitoring Production, Pre-Production and Development database server environment.
• Ability to Build and maintain complex SQL queries for data analysis and data extract.
• Strong experience working with stored procedures, database tuning methodologies, naming conventions, extraction, transformation and query methodologies.
• Having Good Experience working with Onsite/Offshore Model.
• Excellent Communication and interpersonal skills, self-motivated, quick learner and determination to learn new technologies, strong troubleshooting skill and good Team player with excellent interpersonal and team work skills.
• Experience in providing 24X7 on call support on weekly rotation.

TECHNICAL SKILLS

Databases: SQL Server 2000/2005/2008/2012/2014 , MS Access.

Tools: Management studio, Quest Lite speed, Red gate SQL backup Pro, Idera Diagnostic Manager, SQL Profiler.

Reporting: Microsoft SQL Server Reporting Services(SSRS)

ETL Tools: MS Data Transformation services, SQL Server Integration Services

Programming Skills: T-SQL, C, HTML

Operating Systems: Windows 2005,2008,2012

Scheduling Tool: Windows scheduler, SQL Server Agent

Business Tools: Word, Excel, PowerPoint, Access, Outlook

PROFESSIONAL EXPERIENCE

Confidential, MADISON, WI

Database Administrator

Responsibilities:

• Migration and upgradation of databases from SQL Server 2005 to SQL Server 2008R2, SQL Server 2012 and SQL Server 2014
• Installed SQL Server 2012 and configured Always on with Primary and secondary Replicas, Read only databases, listener and with Application Intent.
• Created and maintained various instances for Production, Development and Testing environments on SQL Server 2012, 2008r2 and 2005.
• Installed and configured clustering i.e. active/active and active/passive.
• Improving the Performance of queries through Index tuning and by analyzing the Execution plans.
• Developed, modified, and optimized complex stored procedures, triggers to handle complex business rules, history data and audit analysis.
• Expertise in performance tuning, optimization, data integrity and statistics by usingSQLprofiler and DB engine tuning advisor.
• Experience inPowerShellscripts forSQLServer Maintenance activities.
• Modify database systems and build logical design models for database.
• Extensive experience in using SSIS, SSRS to import/export data from different sources of data intoSQLServerDatabases.
• Performed Export & Import of databases from/to Flat file, excel Access, Oracle and MySQL to/fromSQLServerDatabaseusing DTS, SSIS, and BCP.
• Create necessary T-SQLscripts, stored procedures, tables, views, functions, triggers and indexes.
• Maintained the database consistency using DBCC commands, Managed Disk space and memory and User connections and Monitored SQL server performance using profiler to find performance and deadlocks.
• Installed, authored, and managed reports using SQLServer 2012 Reporting Services.
• Plan, test and apply SQL patches on SQL servers to make sure we are up to date.
• Performed Update Database Statistics, Reorganizing the indexes, Rebuilding the indexes, for better performance.
• Working on Client/Server tools like SSMS, SQL SERVER Configuration Manager, Reporting Services Configuration Manager and SAC to Administer SQL Server.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of User Support via ACTIVE DIRECTORY.
• Created and managed schema objects such as tables, views, constraints, indexes, functions, procedures, and triggers and maintained Referential Integrity.
• CreatedPowerShellAutomations for various tasks.
• Experience inSQLprogramming, physicaldatabasedesign, andSQLperformance tuning, replication.
• Wrote basic batch file andPowerShellscripts to automate jobs.
• Developed SSIS packages to Extract, Transform and Load data into the data warehouse database from heterogeneous databases/data sources.
• Generated Scripts whenever changes are made to databases schemas.
• Provided High Availability to the databases by Implementing DR techniques like Log Shipping, Mirroring and Replication.
• Monitor SQLServer using Error Log, Event viewer and application log, and activity monitor for any blocking or heavy locking or high number of suspended sessions and wait stats of top waits.
• Proficient using DMVs, Wait-States and Performance monitor counters to quickly find the Root cause of performance slow-down.
• Work towards achieving 100% results with service level agreements by handling requests as per severity and getting back to the users well before SLA with resolution.
• Review SQL Server Agent jobs and take corrective actions for failed jobs on daily basis.
• Worked closely with developers, support and QA teams to maintain all DB environments.
• Monitor support ticketing systems SOLV for new work assignments.
• Strong T-SQLdeveloper skills including stored procedures, indexed views, user defined functions, triggers, and distributed queries.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies
• Provided 24 x 7 production support.

Environment: Windows 2003, Windows 2008, Windows 2012, SQL Server 2005, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014, SSIS, SSRS, SQL backup Pro, ITSM ticketing tool, SOLV, MS Outlook, MS Word, MS Excel, MS Project, and MS PowerPoint, PowerShell.

Confidential, Denver, CO

Database Administrator

Responsibilities:

• Design databases and apply normalization to minimize data redundancy.
• Support and co-ordinate merging DBA support across all newly acquired companies.
• Manage SQL Server security by granting appropriate server and databases roles/permissions and by having frequent security checks for inappropriate access.
• Wrote basic batch file andPowerShellscripts to automate jobs.
• Developed, modified, and optimized complex stored procedures, triggers to handle complex business rules, history data and audit analysis.
• Expertise in performance tuning, optimization, data integrity and statistics by usingSQLprofiler and DB engine tuning advisor.
• Create necessary T-SQLscripts, stored procedures, tables, views, functions, triggers and indexes.
• Performed Administrative tasks in SQL Server using PowerShell.
• Performed Export & Import of databases from/to Flat file, excel Access, Oracle and MySQL to/fromSQLServerDatabaseusing DTS, SSIS, and BCP.
• Setup monitoring jobs for monitoring Security changes, Administrative activities, Login failures, and DDL changes. Weekly, quarterly and daily reports are in place for review.
• Monitor database server resources and provide recommendations on hardware/software upgrade to increase server performance.
• Monitor databases and resolve any blocking issues. Identify slow running queries and perform performance tuning by examining the execution plans and creating missing indexes to boost the query performance.
• Modify database systems and build logical design models for database.
• Expertise in performance tuning, optimization, data integrity and statistics by usingSQLprofiler and DB engine tuning advisor.
• Experience inSQLprogramming, physicaldatabasedesign, andSQLperformance tuning, replication.
• Extensive experience in using SSIS, SSRS to import/export data from different sources of data intoSQLServerDatabases.
• Automation of frequent refresh requests are taken care of by creating SQL jobs that copy the backup from production, backup roles and users from development database, perform refresh and reapply the roles and users on to development.
• Check alerts from SQL Log and work with Server team to fix any I/O or operating system issues. Help troubleshoot error and perform Root Cause Analysis.
• Work towards achieving 100% results with Service Level Agreements by handling requests as per severity and getting back to the users well before SLA with resolution.
• Ensure daily and weekly Database maintenance jobs succeed. Also take care of other application related jobs that are critical for the application.
• Help application team identify the blocking process by collecting information on block processes after the fact using scripts querying DMVs.
• Document and gather information on the SQL server inventory list using MAP tool and help in decommissioning the servers that are no longer used in co-ordination with business owners. Server consolidation also helped in minimizing licenses required.
• Ensure standard backup policies are implemented across all servers depending upon the application criticality. Make sure we have backup cleanup tasks are in place.
• Plan, test and apply SQL patches on SQL servers to make sure we are up to date.
• Strong T-SQLdeveloper skills including stored procedures, indexed views, user defined functions, triggers, and distributed queries.
• Help improve performance of queries by analyzing the execution plans, monitoring resource utilization and Database engine tuning tool to identify indexes/statistics that can help in performance tuning.
• Gather service account information and document the same for all locations.

Environment: Windows 2003, Windows 2008 and Windows 2012, SQL Server 2005, SQL Server 2008, SQL Server 2012, Red gate SQL backup Pro, ITSM ticketing tool, MS Outlook, MS Word, MS Excel, MS Project, MS PowerPoint.

Confidential, Portland, ME.

Sr. SQL DBA

Responsibilities:

• Installed and maintained MS SQL Server 2005, Server 2008 on Windows 2003 Server. Worked on SQL Server 2003 failover clustering which is built on top of a Windows 2003 server cluster.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
• Performed Export & Import of databases from/to Flat file, excel Access, Oracle and MySQL to/fromSQLServerDatabaseusing DTS, SSIS, and BCP.
• Developed, modified, and optimized complex stored procedures, triggers to handle complex business rules, history data and audit analysis.
• Extensive experience in using SSIS, SSRS to import/export data from different sources of data intoSQLServerDatabases.
• Create necessary T-SQLscripts, stored procedures, tables, views, functions, triggers and indexes
• Configuring, tuning and optimizing SQL Server 2005, SQL Server 2008.
• Experience inSQLprogramming, physicaldatabasedesign, andSQLperformance tuning, replication.
• Responsible for Stored Procedures optimization, Performance tuning & index tuning.
• Administrator tasks like managing users, roles and permissions. Extensively worked on Log shipping for synchronization of databases for SQL Server High Availability.
• Implemented new features in SQL Server 2008 like Policy based Management, Table Compression, Backup Compression, SQL Server Auditing, Resource Governor and Merge statement in T-SQL.
• Performed data partitioning for efficient management of database tables and indexes.
• Involved in complete database design including conceptual, logical and physical models.
• Participated in the designing and development of software using agile development practices.
• Creating Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Maintained high availability of databases using Database Mirroring and Log Shipping.
• Used third party tool, Lite Speed, Red Gate to speed up backup operations.
• Created and maintained logical/physical data structures.
• Creating views and stored procedures and optimizing them as required by front-end developers for easier implementation on web pages.
• Performed Administrative tasks inSQLServer usingPowerShell.
• Developing stored procedures, triggers, views and adding/changing tables for data load and transformation and data extraction.

Environment: Windows 2003, Windows 2008, Windows 2012, MS SQL Server 2005, MS SQL Server 2008R2, SQL SERVER 2012, SAN, T-SQL, Visual Studio, Business Objects 6.1b, IIS, Lite Speed, MS Access, DTS, SQL Profiler.

Confidential, Cranston, RI

Database Administrator

Responsibilities:

• Maintain SQL Server Production databases and ensure high availability.
• Analyze slow running queries across environments and find the root cause for the same and resolve by introducing missing indexes, partitioning tables and placing them in different file groups on different drives to improve performance.
• Attend requirement gathering meetings along with application team and understand the requirement or change to be incorporated in the existing.
• Database objects design and normalization, review and implementation.
• Interact with the client, understand and gather requirement, identify the DB objects to be modified and new objects to be created.
• Manage space on database servers by proactively forecasting the DB growth.
• Back databases before change implementation and ensure rollback capability.
• Restore development and staging databases to help development team work on the current version of the database to avoid errors during production move up.
• Create roles and grant permissions to users upon proper approval from business.
• Performed Export & Import of databases from/to Flat file, excel Access, Oracle and MySQL to/fromSQLServerDatabaseusing DTS, SSIS, and BCP.
• Ensure the change process is followed religiously and suggest changes required.
• Document the changes made to the database objects and update ER diagrams.
• Attend weekly change control meetings and participate in discussions
• Experience inSQLprogramming, physicaldatabasedesign, andSQLperformance tuning, replication.
• Strong T-SQL developer skills including stored procedures, indexed views, user defined functions, triggers, and distributed queries.

Environment: Windows 2003, Windows 2008, SQL Server 2005, SQL Server 2008, Sybase 9, MS Outlook, MS Word, MS Excel, MS Project, MS PowerPoint, Westar ticketing tool.

Confidential

Database Admin

Responsibilities:

• Installation and configuration of SQLServer 2000, 2005, on Window 2000/NT,2003 OS.
• Managing of database objects like Tables, views, stored procedures, indexes etc.
• Written complex stored procedures and functions according to business requirements.
• Implementing Backups and restoring when necessary.
• Creation and management of Database maintenance plan for various database consistency checks.
• Extensively working on performance issues like update statistics, Auto Stats.
• Creating monthly transaction report for all sections. Developing of Multi-Lingual Reports using Crystal Reports.
• Designed and Implemented Reports using Business Objects Full Client.
• Reports were developed using Crystal Reports utility.
• Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.
• Managing of users including creation/alteration, grant of system/db. Roles and permission on various database objects.
• Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables.
• Develop documentation that sufficiently describes technical deliverable as required for internal controls so that the maintenance responsibility can be passed on to production support team.

Environment: SQL Server 2000, SQL SERVER 2005, Enterprise Manager, Windows 2000,Windows 2003 SQL Profiler, DTS, Business Objects, T -SQL, SAN, DTS, Crystal Reports.