SUMMARY

• 8+ years of experience in SQL Server Administration, Development and Database Design in Production, Development and Test environments with Microsoft SQL SERVER 2005, 2008, 2008R2, 2012, 2014.
• Development and Test environments with Microsoft SQL SERVER 2005, 2008, 2008R2, 2012,2014.
• Experience working with 32 - bit, 64-bit MS-SQL Server in Clustered and Standalone Server Environment.
• Handful experience and outstanding knowledge on High availability (HA) & Disaster recovery solutions (DR), Log Shipping, Mirroring (High safety, High performance & High availability), Replication (Snapshot, Merge, Transactional & Peer -to- Peer) and Clustering (Active-Passive & Active-Active).
• Experience installing, configuring, upgrading and maintaining MS SQL Server 2005,2008,2008R2, 2012,2014;updating with hot fixes and service packs.
• Performed PL/SQL tuning using various tools like EXPLAIN PLAN, AUTOTRACE. Implemented new SQL Server 2012 technique ALWAYS ON for High Availability.
• Implemented In-place and Side-by-Side Migration of MS SQL Server & 2014.
• Experience working with Azure SQL Database Import and Export Service.
• Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.
• Implementing, managing, troubleshooting and maintaining multiple complex SQL Server environments.
• Extensive experience in implementing Clustering and mirroring on physical and virtual machines.
• Expertise in Database Administration on Production Servers with server configuration, Performance Tuning and maintenance with outstanding troubleshooting capabilities.
• Experience working in both OLTP and OLAP environments.
• Experience working with data-tier application (DAC) for Migration.
• Implemented Secure SQL environment using SOX compliance standards.
• Experience in Database designing, RDBMS, and Normalization/De-normalization.
• Experience in Index Maintenance, Index tuning, Rebuild & Reorganizing according to Index
• Fragmentation, running DBCC checks and Update Statistics to check Data Integrity.
• Extensively used tools like SQL Profiler, Index Tuning Wizard, and Windows Performance Monitor for Monitoring and tuning MS SQL Server performance.
• Experience in identifying the I/O and memory, bottlenecks, blocking and deadlocks caused by complex queries using SQL Server Activity monitor/profiler, and handling them by implementing better Query Execution plans.
• Designing, testing, and implementing database triggers, stored procedures, scripts, and packages.
• Expert in Data Integrity, Performance Tuning and Query Optimization.
• Expertise in SSIS and SSRS development and deployment. Monitoring, managing and troubleshooting SQL Server Replication processes.
• Expert level skills in Objects creation such as Table, Normalization, Indexes, Stored Procedures, Cursors, Triggers and other SQL Joins and query writing.
• Experience in Error handling through TRY-CATCH statement, Common Table Expression.
• Experience in logical and physical data modeling of the database in ERWIN and MS-VISIO.
• Implemented the concepts like Data partitioning, Snap shot isolation, database mirroring, database snapshot, DDL triggers, try-cache blocks, online indexing, DMV's, DMF's, Mail Setup, Jobs and Alerts, DTA, SQLCMD and dedicated admin connection.
• Experience in using the DMV'S, DMF'S, SP PROCS, INFORMATION SCHEMA and SYSTEM VIEWS and in-built GLOBAL VARIABLES for the instant analysis.
• Experience in performing database regular Backups (Full/Differential/Transaction Log Backups) and Restoring on requirement.
• Experience in handling the Isolation Levels and Concurrency Effects. Good knowledge about Database Recovery models.
• Experience in implementing SQL Server security in terms of Access control, Policy based management, Server roles, Catalog security, Encryption, Network security, Auditing and Compliance.
• Performed BCP, BULK INSERT, Imported and Exported data from different Data Sources.
• Experience in Implementing best practices on database design, SQL server configuration, and scripting automation to support production, QA, and development SQL environments.
• Experience working with Active Directory Groups.
• Extensively worked on Hot, Warm and Cold Backups, Security Management, Managing server and client Connections.
• Experience working with Windows server, including Active Directory and proper disk configurations.
• Experience in daily database maintenance and administrative tasks like Space issues, Transaction log File size growth, Connectivity issues and regular monitoring of SQL Server error logs and windows Event viewer.
• Experience in using SSIS tools like Import and Export Wizard, Package Installation. Experience in Analysis Services (SSAS) OLAP Cubes, Star Schema and Snow Flake Schema, ETL and Data Warehousing.
• Worked with a team of business analysts, data architects, application developers, ETL developers and testers, my objective was to deliver projects within scope, time and costs while following department standards, methodologies and guidelines. Worked on call 24/7 availability of database Services.
• Migrating SQL instances on VMware to Physical boxes for performance improvement.
• Strong Analytical and problem solving abilities with excellent verbal and communication skills.
• Experience Designing and implementing solutions to complex problems.

TECHNICAL SKILLS

SQL Server Tools: SQL Server Management Studio, SQL Server Business Intelligence Development Studio

Languages: C# ASP. NET, T-SQL, My SQL, VB.NET, HTML, XML, C/C++, CSS, HTML, Java Script

Operating Systems: Windows 2000/2003/2008/ XP/VISTA/7/8, UNIX (Sun Solar), LINUX (Red Hat)

Databases: MS-SQL Server 2014/12/08R2/08

ETL Tools: Data Transformation Services (DTS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting (SSRS).

DB Utilities: SQL Server Management Utility, Query Analyzer

Application Software: Visual Studio 2008/2010, Visual Source Safe, TFS, MS Office Suite

Third party Tools: Erwin, Red gate, Litespeed, Idera, Comvault.

Storage Management: Semantic Net backup, IBM Tivoli Storage Manager, EMC Data Domain Boost.

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

SQL Server DBA

Environment: MS SQL Server 2008 R2, 2012,2014,Windows 2008 R2 Server, Windows 2012 R2 Server, MS Visual Studio 2010, SSIS Packages, Excel, HTML, LiteSpeed, SQL Azure Database

Responsibilities:

• Installation, managing and troubleshooting SQL Server 2014, 2012, 2008R2 instances.
• Configuring ALWAYS-ON HADR setup between on Multi Subnet Cluster, in which 2 nodes sitting in New York and 3rd DR node sitting at Houston.
• Setup SQL 2012 with Always-On availability group for my databases in sync and secondary readable mode. I completed failover tests with sync mode and it is functioning as expected.
• Configuring and Managing Transact replication and Database Mirroring.
• Extensively using DMV's to fix the performance issues on production systems.
• Migrating 2008 R2 SQL servers to 2012 and also 2012 SQL servers to 2014 with minimal downtime.
• RAID level suggestions for storage team to improve database performance.
• Configure multimode clustering (Active-Active and Active-Passive) on physical and virtual machines.
• Migrating SQL instances on VMware to Physical boxes for performance improvement.
• Creating Jobs and Schedule them for execution on Daily, Weekly, and Monthly bases.
• Experience in doing Automation tasks like monitoring Disk Space, Server Ping Status, Database health checks using customized SQL scripts, batch file and Power shell.
• Utilized Power shell to execute commands on servers.
• Continuously monitoring and updating Backup and Recovery strategy to recover data using RPO and RTO solutions based on requirements.
• Responsible for monitoring and making recommendations for performance improvement in hosted databases.
• Maintain a detailed understanding of the Deployment team's tasks and activities on a project, including status, release dates, issues/risks, and report status.
• Implemented Microsoft tools such as Microsoft security baseline analyzer for SOX security analysis.
• Experience working with Windows server, including Active Directory and proper disk configurations.
• Worked with Multi-Dimensional Expression (MDX) for querying and manipulating the multidimensional data stored in OLAP cubes.
• Coordinated seamless handoffs between phases of the development lifecycle, driving adherence to the planned release milestones.
• Configured all release CI's and dependencies including related systems, devices, and documented them.
• Capacity planning all the databases beforehand.
• Implemented Change control and Configuration Management.
• Periodically checking the health of the servers and providing recommendations.
• Performance tuning and monitoring of databases, data archiving and purging, troubleshooting and Management of production databases and disk space management.
• Involved in creating SSIS packages to migrate large amounts of data.
• Export or Import data from other data sources like flat files using Import/Export through SSIS.
• Analyzing long running/slow queries and tune the same to optimize application and system performance.
• Upgrading of SQL server software 2008/2008 R2 to 2012 and .
• Designing and creating backups & recovery strategy.
• Implement and manage SQL Azure database for cloud server. Working with customers on Application rollouts and server migrations.
• Perform SQL Server service pack and Windows Service pack upgrades. Designed and implemented comprehensive Backup plan using Lite Speed.
• 24*7 Production support.
• Established compatibility with third party software products by developing program for modification and integration.
• Ensured network, system and data availability and integrity through preventative maintenance and upgrades.
• Worked independently and as a part of team.

Confidential, Hartford, Connecticut

SQL Server DBA

Environment: MS SQL Server 2008R2, 2012,2014 Windows 2008 R2 Server, ERWIN, MS Visual Studio 2010, SSIS Packages, Excel, VSS (Visual Source Safe), HTML, Idera, RedGate.

Responsibilities:

• Worked on Client/Server tools like SQL Server Management studio 2008/2008R2/2012/2014, SQL Server Enterprise Manager 2005 and Query Analyzer to Administer SQL Server.
• Migrated SQL server 2005 databases into SQL server 2008R2 and SQL server 2008R2 databases into SQL server 2012 databases by In-place upgrade process and also used upgrade advisor tool in up-gradation.
• Setting up and Monitored transactional replication, Database mirroring on Production, QA and Development servers.
• Managed SQL Server using Power Shell.
• Worked extensively on Data Refreshes from Production to Test environments, automated the whole data refresh process at database level using Power Shell scripts, stored procedures, Backups and SQL Agent jobs without having any performance impact on Production server.
• Migrated DTS packages into SSIS packages.
• Handled up to 2 TB Size databases with clustered and stand-alone environment.
• Configured Transactional replication on migrated server.
• Wrote the packages using SSIS in SQL 2008R2.
• Extensively worked on Dynamic Management Views (DMV's) and Dynamic Management Functions (DMF's).
• Meet with other Healthcare Analytics and Business programs to align release schedules and timeline to minimize outages and/or production risks to ensure successful implementation of all release components to meet the company commitments.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Implementation of SQL Principle, Securable, Permission, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Maintaining SQL Script for creation of Database Objects using VSS (Visual Source Safe).
• Created Database Maintenance Planner for SQL Server which covers Database Integrity Checks.
• Planned the Complete Backing up of Database and Restoring the Database from Disaster Recovery.
• Used log shipping for synchronization of database.
• Monitoring SQL server performance using profiler to find performance and deadlocks.
• Created Stored Procedures, Triggers, Views and Functions for the Application.
• Provided documentation on start-up, shut down and first level troubleshooting of processes to help desk staff.
• Coordinated with Project Managers & Program Managers to monitor and track project and release risks and issues.
• Consistently met deadlines and requirements for all production work orders.

Confidential, Tampa, Florida.

SQL Server DBA/BI Developer

Environment: SQL Server 2005/2008/2012 Enterprise, Windows Enterprise Server 2003,IIS 6.0, T-SQL, Microsoft Reporting Service, VMware, SQL Server Reporting Services and SQL Server Integration Services.

Responsibilities:

• Worked extensively on installation and configuration of MS SQL Server /2008 R2 on standalone and clustered Environments.
• Involved in migration of MS SQL Server 2008 to MS SQL Server 2008 R2.
• Handled clustering between two Production Servers and performed daily backups and developed recovery procedures.
• Experience in the field of Unit Testing, have tested codes of T-SQL and SSIS packages in the testing environment.
• Expertise in SSIS and SSRS development and deployment. Monitoring, managing and troubleshooting SQL Server Replication processes.
• Ensured Properly that Configuration Items (CI) are linked to the Change.
• Perform installation, setup, configuration, and maintenance of configuration management tools.
• Calculated measures and dimension members using MDX, mathematical formulas and user defined functions.
• Configured DB mail for sending automatic mails to respective people when SSIS process fails.
• Migrated DTS packages to SSIS 2005 packages.
• Administered the MS SQL Server by creating User Logins with appropriate Roles, dropping and locking the logins, monitoring the User Accounts, granting and privileges to users.
• Scheduled the Backups for Databases and performed Restoration operations.
• Created, a built and deployed successfully SSIS package by using BIDS.
• Created SSIS packages to validate, extract, transform and load data from Oracle into SQL Server database.
• Implemented and Maintaining Replication.
• Assisted in diagnosing and debugging installation and configuration failures.
• Generate every day morning Replication reports from branch SQL Servers and Resolve Issues.
• Created jobs and scheduled jobs according to Requirements and Data-warehousing.
• Assisted in Deploying 2 NODE failover clustering.
• Implemented Transactional Replication between Primary and Secondary Servers.
• Created Databases, Tables, Indexes and Views.
• Created Linked Server between SQL Servers.
• Experience in SQL Server security and maintenance of security objects.
• Implemented SQL Server Clustering on VM Ware.
• Configured Mirroring and Transactional Log Shipping between Primary and Secondary Servers depending on the business requirements.
• Worked with SQL Server Profiler to Generate Traces.
• Developed documentation that sufficiently describes technical deliverable as required for internal controls so that the maintenance responsibility can be passed on to production support team.
• Continuous monitoring server health with Idera.
• Effectively configured MySQL Replication as part of HA solution.
• Managed VERITAS net backups and LiteSpeed backups, Used SQL Profiler to capture the activities of the database and used the trace file as workload file to the Database Tuning Advisor for index recommendation.

Confidential, Rosemead, California.

SQL Server DBA/Developer

Environment: Microsoft Windows 2008 Server, Microsoft SQL Server 2005/2008/2008 R2, Microsoft SQL Server 2005, MS Visual Source Safe, IIS 6.0, XML, LiteSpeed, Idera.

Responsibilities:

• Manage and administer SQL server 2005\2008\R2 servers.
• Migrations of databases from SQL 2005 to SQL 2008.
• Deployment of databases, jobs, cubes from pre-production to production.
• Imported Oracle databases ODBC into SQL through linked servers. Monitored Oracle DBAs along with the SQL DBAs in a team.
• Building SQL 2008/2008R2 cluster environments on VMware or Physical windows.
• Performed installations of SQL 2008/2008R2 on clustered and standalone servers.
• Up gradations of SQL server versions and applying patches and hot fixes.
• Responsible for development and implementation of Configuration Management system.
• Adding nodes to already existing clustered servers as a part of data load\High availability.
• Configured Transactional Replication and Log Shipping with SQL Server Management.
• Implementation of SQL server logins, Roles and Authentication modes as a part of security policies.
• Work on weekly Issues reports which are generated as a part of infrastructure setup.
• Extensive use of Team Foundation Server (TFS) for build and configuration activity.
• Creating and scheduling maintenance plans for updating statistics, checking fragmentation, checking database integrity and backup plans.
• Configured Database mail, linked servers, Transparent Data Encryption (TDE) and Auditing.
• Extensive hands-on experience with MSSQL Server upgrades/migrations and VMware environments.
• Performance tuning of databases by windows performance monitor and SQL Profiler.
• Involved in configuration activities for build release and deployment, maintained around 17 environments for application deployment and configuration setting.
• Fine-tuned Stored Procedures using Execution Plan in T-SQL for better performance.
• Working on tickets\incidents with in the SLA's, as a part of operations support DBA.
• Conducted various meetings and conferences with application teams to meet corporate milestones for database consolidation and data migration.
• Resource planning and coordination for application migrations with project managers, application and web app teams.
• Involved in capacity planning, sizing and database growth projections. Worked with Data warehousing team in VLDB environment for archiving the old data.
• Worked in an environment with Change management process (Service-now tool) in place for all kind of production and non-production changes.
• 24*7 on call production support.
• Developed functions, views and triggers for automation. Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables and also optimized the procedures and triggers to be used in production.
• Developed documentation that sufficiently describes technical deliverable as required for internal controls so that the maintenance responsibility can be passed on to production support team.

Confidential

SQL Server Developer/DBA

Environment: TSQL, MS SQL Server 2005/2008, SSRS, Query Analyser, Visual Studio 2005, VB.NET, C#, Windows Server 2008, IIS 5.0, SSAS

Responsibilities:

• Developed physical data models and created DDL scripts to create database schema and database objects.
• Designed data models using Erwin. Wrote user requirement documents based on functional specification.
• Created new tables, written stored procedures, triggers for Application Developers and some user defined functions.
• Gathered requirements from business analyst.
• Created SQL scripts for tuning and scheduling. Involved in performing data conversions from flat files into a normalized database structure.
• Developed source to target specifications for Data Transformation Services.
• Developed functions, views and triggers for automation. Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables and also optimized the procedures and triggers to be used in production.
• Provided disaster recovery procedures and policies for backup and recovery of Databases. Performance Tuning in SQL Server 2005 using SQL Profiler and Data Loading.
• Installing SQL Server Client side utilities and tools for all the front-end developers/programmers.
• Created DTS package to schedule the jobs for batch processing.
• Involved in performance tuning to optimize SQL queries using query analyzer. Created indexes, Constraints and rules on database objects for optimization.
• Creation/ Maintenance of Indexes for various fast and efficient reporting processes.
• Monitored the Database Growth and Space Requirement.
• Handling Users/Logins/User Rights. Managing historical data from various heterogeneous data sources (i.e. Excel, Access).
• Used linked tables, pass through queries and many other access features also wrote code in Visual Basic to perform some complex reporting tasks.

Confidential

SQL Developer

Environment: SQL Server 2000/2005, Windows NT server.

Responsibilities:

• Actively participated in gathering of Requirement and System Specification.
• Worked on complex T-SQL statements, and implemented various codes and functions.
• Involved in creating Stored Procedures, views, tables, constrains.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent Data entry into the database.
• Wrote complex stored procedures to process employee’s requirement and generating reports.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
• Created Database Maintenance Plans for the Performance of SQL Server, which covers Database Integrity.
• Debugged the T-SQL queries for performance tuning.
• Checked & updated Database Statistics and Re-indexing.
• Created Users and Roles, and managed security and permission of database.