PROFESSIONAL SUMMARY:

• Nearly 8 years of experience in Database Administration, Development and Design Extensive experience with SQL Server 2008/2008R2/2012/2014 in professional services.
• Experience in managing Windows 2008/2008R2/2012/2012R2 servers in a clustered environment.
• Experience in supporting Very Large OLTP Databases of size 13 TB and troubleshooting teh performance bottle necks.
• Experience with SQL Server 2008/2008R2/2012/2014 installation, migration, configuration, SSIS, SSRS and administration.
• Hands - on experience and outstanding knowledge of high availability SQL Server solutions, including SQL Server Log shipping and SQL Server clustering and Always ON Availability Groups.
• Handled multiple SQL Instances on Cluster environment and worked on configuring logical disks and RAID levels.
• Experience in Replication - Snapshot and Transactional and extensive knowledge in Merge replication.
• Extensively worked on 32 bit, 64 bit and i64 clustered and standalone server environments.
• Experienced in physical, logical database design by using ERwin.
• Experience in Filtered Indexes and Data Compressions for Performance and Optimum space utilization in SQL Server 2008/2008R2/2012/2014.
• Hands-on working experience with analyzing query plans, using extended stored procedures, managing indexes and locks, troubleshooting deadlocks.
• Identifying teh bottle necks using SQL Server Profiler and Perfmon.
• Experience in performing Online Indexing.
• Experience with monitoring, troubleshooting related issues.
• Experience in using Data Partitioning for large tables of data to increase performance.
• Expert in implementing business logic by using TSQL, stored procedures, triggers (DDL, DML) and functions (Inline & Multivalued Table functions).
• Experience in planning and implementing Microsoft SQL Server Security and database permissions.
• Proficient with database backup and recovery models.
• Experience in Backup tools like SQL Safe and LiteSpeed for fast and efficient database backups.
• Experience in writing complex T-SQL.(DDL, DML, and DCL)
• Experience in using Dynamic Management Views (DMV) to troubleshoot and improve server performance.
• Configuration and Administration of SharePoint Server 2007/2010/2013.
• Experience in working with Share Point in MOSS.
• Experience with Normalized and de-normalized database design.
• Expertise in SQL Server 2008/2008R2/2012/2014 Reporting Services (SSRS) and SQL Server 2008/2008R2/2012/2014 Integration Services (SSIS) in Business Intelligence.
• Expert in data transformation services like SSIS, DTS, BCP and Bulk Insert from heterogeneous databases like Oracle, MS Access, and DB2.
• Proficient with SQL Server Analysis Services. (SSAS)
• Extensively worked on RDBMS concepts to design Relational Database model as per Business requirement.
• Extensively worked on VMware and Implemented SQL Server 2008/2008R2/2012/2014.
• Rebuilding teh indexes at regular intervals for better performance.
• Extensive experience in using version control system tools for deploying scripts in various stages of SQL Server.
• Worked extensively in query analyzer and profiler for tuning queries using variable for characteristics and query costs.
• Flexible and versatile to adapt to any new environment and work on any project.
• To provide 24x7 production support for SQL Server databases on Clustered Servers with sizes ranging above 13 Terabytes to achieve maximum performance and uptime in production environment.
• Strong time management skills and excellent team player.
• Ability to adapt quickly to changing environments.

TECHNICAL SKILLS

Programming Languages: C, C++, Java, Perl, SQL, TSQL, PL/SQL.

BI Tools: SQL Server Business Intelligence Development - SSIS, SSAS, SSRS, DTS, BCP.

DBMS/RDBMS: MS SQL Server 2008/2008R2/2012/2014, ORACLE 10g, MS Access, MySQL.

Database Tools: SQL Server Management Studio(SSMS), Enterprise Manager, SQL Profiler, Query Analyzer, Performance Monitor, SQL Mail, SQL Trace, OLAP, OLTP, DBCC, Redgate, LiteSpeed.

Reporting Tools: SQL Server Reporting Services, MS Excel, Crystal Reports.

Markup Languages: XML, HTML/HTML5, DHTML.

Data Modeling: ERwin, MS Visio.

IDE Tools: Visual Studio.Net 2008/2010/2012, SharePoint Server 2007/2010/2013, MS Office Suite 2007/2010/2013/2016.

WORK EXPERIENCE

Confidential - Washington D.C

SQL Server DBA

Responsibilities:

• SQL Server Database Administrator
• Installed SQL Server 2014 Clustering on Windows Failover Cluster 2012R2 environment.
• Migration of Replicated databases from SQL Server 2012 to SQL Server 2014.
• Worked extensively on setting up SQL Server Transactional Replication.
• Involved in monitoring and troubleshooting replication issues.
• Configured and maintained High Availability solutions like Always On Availability Groups on WSFC Nodes.
• Rebuilding / Monitoring and consolidating teh indexes at regular intervals for better performance and disk space usage.
• Analyzed SQL server performance using profiler and to audit SQL Server Databases.
• Used SQL Monitor Tool from Redgate for setting up alerts and notifications and also analyzing CPU, locks, Blocking and Memory Utilization.
• Refresh teh Production databases to DEV and QA environments for new releases.
• Used Dynamic Management Views (DMV) for monitoring teh performance of teh server.
• Introduced Archiving process to minimize teh database foot print and effective disk utilization.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Performed Database Integrity Checks, updated Database Statistics and performed Re-indexing through Maintenance Plans.
• Creating SQL Server Logins and assigning Roles and Autantication Modes as a part of Security Policies for various categories of User Support.
• Created Maintenance Plans that halped in effective disk utilization, Database recovery and index maintenance.
• Created, Scheduled and monitored SQL Server Jobs, making sure jobs run successfully every night.
• Tuned stored procedures, triggers, views and adding/changing tables for data load and transformation, and data extraction.
• Worked in JIRA ticketing system and resolved tickets ranging from P1 to P4.
• Extensively worked with native compression Backups.
• Extensively used Confluence tool to document, track, authorize and record implementation details of changes made to teh various applications in teh firm.
• Extensively worked on Documentation of run books and release documents with various application teams for production deployments and other processes.

Environment: Windows 2012/2012R2, MS SQL Server 2012/2014, MSCS, Microsoft IIS 6, SharePoint2013, Microsoft.NET, SSRS, SSAS, MS Visual Studio 6.0, JIRA, Redgate.

Confidential - Los Angeles, CA

SQL Server DBA

Responsibilities:

• SQL Server Database Administrator
• Installed SQL Server 2014 on windows 2012R2 environment.
• Worked across 90 servers and more than 200 databases with OLTP Database Size 13 TB.
• Worked extensively on SQL Server Transactional Replication.
• Configured logical drives and RAID levels Using HP Array Configuration Utility.
• Involved in monitoring and troubleshooting replication issues.
• Configured and maintained High Availability solutions like Clustering and Mirroring.
• Configured Server Memory for maximum Performance and effective utilization.
• Configured Temp DB to increase teh performance of SQL Server.
• Monitoring SQL server performance using profiler to find performance and deadlocks.
• Used SQL Diagnostic Manager and SQL Compliance for analyzing locks, Blocking and Memory Utilization.
• Involved Design, Troubleshooting and Deployment of SSIS packages.
• Experience in adding databases to Always ON Availability Groups on WSFC Nodes.
• Involved in deploying XMLA scripts to SSAS and also maintained teh security of SSAS databases.
• Deployed Custom Reports to QA and PROD environments by working with QA and Engineering team.
• Refresh teh Production databases to DEV and QA environments for new releases.
• Used Dynamic Management Views (DMV) for monitoring teh performance of teh server
• Used Change Data Capture (CDC) to audit DML and DDL Operations on various tables.
• Used new security feature called AUDIT in SQL 2012 on both server level and database level.
• Worked with IDERA Tool by setting up alerts for teh Monitors of various SQL Servers.
• Worked and generated reports using SQL Server 2012/2014 Reporting Services (SSRS).
• Performed Database Integrity Checks, updated Database Statistics and performed Re-indexing through Maintenance Planner.
• Maintaining teh database consistency with DBCC at regular intervals.
• Creating SQL Server Logins and assigning Roles and Autantication Modes as a part of Security Policies for various categories of User Support.
• Created Maintenance Plans that halped in effective disk utilization and index maintenance.
• Worked on TORTOISE SVN and maintained teh data in Source control.
• Created, Scheduled and monitored SQL Server Jobs, making sure jobs run successfully every night.
• Tuned stored procedures, triggers, views and adding/changing tables for data load and transformation, and data extraction.
• Extensively worked on 24X7 Production support and also involved in on call rotation.
• Worked in REMEDY ticketing system and resolved tickets ranging from P1 to P4.
• Extensively worked with Native and SQL SAFE compression Backups.
• Extensively used IT Change Request (ITCR) tool to document, track, authorize and record implementation details of changes made to teh various applications in teh firm.
• Extensively worked on Documentation of run books and release documents with various application teams for production deployments and other processes.

Environment: Windows 2012/2012R2, MS SQL Server 2012/2014, MSCS, Microsoft IIS 6, SharePoint2010/2013, Microsoft.NET, SSRS, SSAS, MS Visual Studio 6.0, REMEDY, IDERA.

Confidential, Atlanta, GA

SQL Server DBA

Responsibilities:

• Created and managed schema objects such as Tables, Views, Clustered and Non-Clustered Indexes and referential integrity depending on user requirements and converting them into technical specifications.
• Responsible for MS SQL Server 2008/2008R2 configuration, tuning and provide 24 X 7 dedicated support to all Production, development and clustered servers.
• Performed all aspects of database administration, including data modeling, backups and recovery.
• Configured Transactional replication between Primary Server and three Read-Only servers, with separate Distributor server and experience in troubleshooting replication problems.
• Configured teh Log shipping and created teh Standby server.
• Created teh logical and physical data modeling using Erwin tool.
• Maintained Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules.
• Monitored connections, locks and performance of SQL server.
• Assigned permission to users, roles and object, Supported column level permission.
• Administered server's logins (Windows and SQL Accounts).
• Created and granted permissions on various Objects.
• Prepared teh reports for teh day-to-day as well as weekly/monthly purposes.

Environment: Windows 2008/2008R2 Server, MS SQL Server 2008/2008R2, DTS, Erwin, MS Access, ASP, Perl, MS Analysis Services, Diagnostic Manager, Linux.

Confidential, Minneapolis, MN

SQL Server DBA/ Developer

Responsibilities:

• Installation of MS SQL Server 2008R2 on Production, Test and Development boxes.
• Provided recommendations for improvements on existing topology, documentation for overall Database performance and estimations for future expansion of Databases.
• Created stored procedures/Packages, DB-links, triggers using T-SQL and PL/SQL programming according to teh business logic.
• Setting up teh Transactional Replication in between SQL Server Databases.
• Experience in installing and configuring SQL Server 2008/2008R2 clusters in Active/Active mode.
• Worked on creating teh SSIS package for monitoring teh Database status and SQL Error logs for teh mission critical servers.
• Created maintenance plan for consistency checks, maintaining indexes and statistics, performing fine Tuning of Database Application, Cleansing and solving Database troubles.
• Daily support, troubleshooting, monitoring, optimization, tuning, blocking and deadlocking issues across entire system.
• Resolved Database space issues by sizing Table spaces, data files and log files.
• Responsible for monitoring Jobs, SQL auditing, Disk spaces, error logs and making recommendations for performance improvement in hosted Databases which involved file group modifications, and scheduling jobs to rebuild/reorganize indexes, update statistics and security.
• Creating Schemas, Logins, Tables, Clustered and Non-Clustered Indexes, Views and Functions.
• General Database Administration, Performance tuning, and validated some of teh existing schema.
• Experience in backup tools LiteSpeed and Redgate SQL Compare.
• Created documentation, schema designing, ER Diagrams, MS Visio and involved in architecture and Monitoring, optimizing teh performance of teh Database servers.
• Created Weekly status reports for teh issues.

Environment: Windows Server 2008/2008R2, MS SQL Server 2008/2008R2, SSIS, Clustering, Replication, LiteSpeed and Redgate.

Confidential

SQL Server DBA/ Developer

Responsibilities:

• Involved in upgrading teh instance of development environment of SQL Server 2005 to SQL Server 2008.
• Migration of DTS to SQL Server Integration Service (SSIS).
• Designing/ Implementing Backup policies for databases.
• Created DDL/DML triggers in SQL Server 2008.
• Designed data models and generated Entity-Relationship diagram (ERD) using Erwin.
• Generated DDL scripts for database schema and created all other database objects.
• Developed stored procedures, functions, views and triggers in T-SQL.
• Designed, developed and maintained teh reports.
• Maintained database performance by normalization, indexing, collecting statistics, etc.
• Created new database objects like Stored Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in SQL Server 2008.
• Validated change requests and made appropriate recommendations.
• Standardized teh implementation of data.
• Promoted database objects from test/develop to production.
• Coordinated and communicated production schedules within development team.
• Retrieved data from cubes and generated OLAP reports using SSRS and SSAS.
• Collected requirement and generated stylish reports using SSRS.
• Modified database structures as directed by developers for test/development environments and assist with coding, design and performance tuning.
• Managed SQL database user accounts, user logins, permissions, database and server roles.
• Planned teh Complete Backing up of Database and Restoring teh Database from Disaster Recovery.
• Developed and implemented database and coding standards, improving performance and maintainability of corporate databases.
• Provided back-end support for functional testing and performance testing.
• Developed front-end/UI for easy data access and submission in C#.

Environment: Windows Server 2008/2008R2, MS SQL Server 2008/2008R2, SSRS, SSIS, SSAS, Erwin, Oracle 10g, C#.

Confidential

SQL Server DBA/Developer

Responsibilities:

• Installed, configured and troubleshoot Windows OS on Desktops, Notebooks and Servers.
• Assign permission to user(s), role(s), and object.
• Support column level permission and Administrate security for server’s logins.
• Integrated several Access Databases to SQL Server 2008 from 2005.
• Involved in design and development of moving company websites.
• Involved in various stages of SDLC, Design (Logical & Physical), Development, Implementation and Testing.
• Worked closely with teh developer’s team and teh end users while teh system is being under development phase.
• Created user-friendly GUI and Web pages using HTML, DHTML and PHP.
• Run diagnostics on servers to identify issues.
• Planned teh complete Backup of Database and restoring teh Database for Disaster Recovery.
• Configured Log shipping from one production server to teh staging server.
• Responsible for MS SQL Server 2008 configuration, tuning and provide support to all production/staging/development servers.
• Written and fine-tuned creating tables, views, indexes, cursors and stored procedures.
• Using BCP and DTS utility for Meta data transfer across servers.
• Involved in designing teh system models using UML and ER Diagram.
• Generated Reports using Crystal Report tool available in Visual Studio.Net to make teh application user friendly.
• Performed System Study and Requirements Analysis, prepared Data Flow Diagrams, Entity Relationship Diagrams, Data Diagrams, Table Structures, with a lot of interaction with teh client.

Environment: Windows Server 2008, MS SQL Server 2008, Visual Studio 2008, T- SQL, DTS, Crystal Reports, MS Office Suite 2007.

Confidential

SQL Server DBA/Developer

Responsibilities:

• Developed stored procedures and triggers.
• Optimized SQL queries for efficiency and teh front end developer with their queries and procedures.
• Backing up master & system databases and restoring them when necessary.
• Supported production environment.
• Logical and Physical design of database for projects on basis of user requirements using Erwin.
• Reporting on a weekly basis to teh project manager.
• Determine teh SQL Server Installation options.
• Install SQL Server Management tools using SQL Server Setup Program.
• Test teh Installation of SQL Server.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
• Created Database Maintenance Planner for teh Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Planned teh Complete Backing up of Database and Restored teh Database.
• Fine tuning of database objects and server.
• Job Monitoring and making sure all jobs ran successfully every night.
• Configured Server for sending automatic mails to teh respective people when a job is failed or succeeded.
• Moved teh entire phase from teh Staging to teh Production.

Environment: Windows Server 2008, MS SQL Server 2008, SQL, T-SQL, SQL Query Analyzer, Profiler.