SUMMARY:

• Detail oriented IT professional with 7+ years of proven expertise in supporting and optimizing performance of SQL Server 2014/2012/2008 R 2/2008/2005/2000 as Database Administrator and Developer.
• Experience in Upgrade/migration of several instances and databases from SQL Server 2000 to SQL Server 2005/2008, SQL Server 2005 to SQL Server 2008/2008 R2, from SQL Server 2008/2008R2 to SQL Server 2012/2014/2016 .
• Experience in documenting and implementing Disaster Recovery Plans using Always On, Database Mirroring, Log shipping and Replication with different topologies for production databases.
• Experience in Server administration in various environments - Window 2000/2003 with Active Directory Services (AD, DNS and DHCP).
• Monitored Sybase data servers and replication server for performance.
• Experience in handling very large databases in OLTP and data warehouse environments, which are in Terabytes size.
• Good working experience in maintaining SQL Server Active/Passive cluster environment.
• Experience in implementation of SQL Server new features like Always on Availability Groups, Contained Databases, change data capture (CDC), online index rebuilds, Central management server, Transparent Data Encryption (TDE on 2014/2016), User-Defined server roles.
• Strong in monitoring and optimizing the performance of Applications, databases, Stored Procedures, Queries and Indexes using Extended Events, SQL Profiler, server-side trace, Activity Monitor, Dynamic Management Views and Functions, Execution Plans, Performance Monitor, DBCC commands, Database Engine Tuning Advisor and other third-party tools like Red Gate SQL Monitor, Idera SQL Diagnostic Manager, Quest Spotlight.
• Worked on SQL Server tools Like Enterprise Manager and SQL Query Analyzer.
• Administered DB2 subsystems in Prod, QA/Test and Development regions.
• Strong in Power Shell scripting and automating day to day maintenance tasks using Power Shell scripts, converting existing TSQL batch scripts to Power Shell scripts and improving SQL Server maintenance jobs performance.
• Experience working with Cloud services like Microsoft AZURE and AWS.
• Experience in BI Development and Deployment of SSIS packages and loading data in to SQL Server from MS-Access, Excel, Oracle, and Teradata.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Extensive experience in end-to-end life cycle of SSRS using Scale-Out, Scale-Up and Local topologies.
• Experience in designing and deployment of Reports for the End-User requests using Web Interface and SSRS (Ad-hoc Reporting).
• Experience in programming tasks like developing Stored Procedures, Functions, and Triggers, ad-hoc queries for reports, TSQL batches, PL/SQL packages and procedures, Power Shell scripts.
• Experienced in SDLC life cycle for Design, Development and Staging phases of the projects with support of Data-Flow, Process Models and E-R Diagrams.
• Good working knowledge in .Net Framework 2.0/3.0/3.5,VB.Net, C#, ASP.Net, ADO.Net, XML and Web Services.
• Monitored Full/Incremental/Daily Loads and support all scheduled ETL jobs for batch processing.
• Experience in writing T-SQL (DDL, DML and DCL), Expert in implementing business logic in backend reviewing T-SQL code.
• Provided 24X7 supports through on call rotation for PROD and NON-PROD Environments.

TECHNICAL SKILLS:

MS: SQL Server 2000/ 2005/2008/2008 R 2/ 2012/2014/2016 , MS Access 2003/2007, DB2, Oracle Database 10g/11g

Languages: C, C++, T-SQL, VB Script, Java Script, HTML, XML

SQL Server Tools: SQL Server Management Studio, SQL Navigator, Microsoft Visual Studio 2008/2010/2012 , SQL Server Enterprise Manager, BIDS, Sybase Data Tools, SQL Profiler, SQL Networking, Activity Monitor, DTA, Performance Point, PLSQL Developer, Oracle SQL Developer, DB2, Toad, Excel Macro 2007/2010, Erwin, MS Visio, Perf Mon, Quest Lite Speed, Active Directory, Spotlight for SQL Server, red-gate SQL monitor, Elite Time, Idera SQL Diagnostic Manager, SCOM Monitoring.

OLAP Tools: SQL Server Analysis Server 2012/2008, 2005

Software Packages: MS Office 97/2000/XP, 2003, 2007, MS Outlook 2003, 2007

Operating Systems: Windows 2016/2012/2008/2003/2000/ Professional/ NT 4.0 Advanced Server, Unix, Linux.

PROFESSIONAL EXPERIENCE:

Confidential - Milwaukee, WI

SQL Server DBA

Responsibilities:

• Manages and maintains all aspects of SQL 2008, 2012, 2014 and 2016 database servers in clustering and standalone environment.
• Test and apply latest service packs for SQL Servers.
• Ensure all database servers are backed up in a way that meets the business's Recovery Point Objectives (RPO) and Test backups to ensure we can meet the business' Recovery Time Objectives (RTO).
• Experience in creating, managing SQL Server AZURE Databases and setting up Connection Strings and connecting SQL Server AZURE Databases from locally installed SQL Server Management Studio (SSMS) for Developers
• Working with ServiceNow Tickets (Any changes on Production, staging and development environment need to Create ServiceNow Tickets).
• Maintaining both DEVELOPMENT and PRODUCTION Server to make sure they are in sync if not implementing Data refresh on regular bases to achieve this goal.
• Running Index tuning wizard and rebuilding indexes on large tables for faster query response for front end users.
• Working with windows team, app team to streamline the data processes and implement policies to ensure security on all SQL Servers.
• Developed SSRS reports for the internal reporting dashboard.
• Created Merge Replication between different data centers. Resolved issues; designed and managed database security. Wrote PowerShell scripts for deploying SQL Server Databases ran that scripts in VSTS.
• Developing, modifying, supporting and maintaining AWS-based components for public facing infrastructure and application back-end. Managed, developed and delivered the code Using VSTS.
• Installed and managed SSIS, SSAS and SSRS services on different environments.
• Handled Performance Tuning and Optimization, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments located globally.
• Created Database Diagram using Erwin Data Modeler, Data Dictionary Document, Database Installation and Configuration Document and Merge Replication Setup Document.
• Involved in Change Management, Problem management activities before implementing database changes in production and development activities.
• Reviews and implements database production code changes for all development staff and enforcing development standards to all database objects.
• Involved in development of automated daily, weekly and monthly SQL server agent jobs such as but not limited to Database backup, Integrity checks, Indexing Maintenance and Update statistics.
• Managing logins, roles, assigning rights and permissions.
• Use native tools like Database Tuning Advisor, SQL Server Profiler, Performance Monitor, Activity Monitor and Spotlight for performance tuning.
• Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.
• Identify and troubleshoot SQL Server related CPU, memory, I/O, disk space and other resource contention.
• Experience in integrating different database environments like Sybase SQL Server, Oracle SQL Server etc.
• Worked on DTS Package, DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server. Performed Capacity Planning, data modeling and Logical/Physical database Design.
• Experience in Designing Data Mart and Data Warehouse using Star Schema and Snowflake Schema and OLAP Technology Analysis Services and Cognos using SQL Server 2008.

Environment: SQL Server 2005/2008/2008 R 2/ 2012/2014/2016 , T-SQL, SSIS, SSAS, SSRS, Azure, Query Analyzer, SQL Profiler, Performance Monitor, Remedy, Lite Speed, Data Compression, SAN, PowerShell, Active Directory, AWS, Windows 2012/2008R2/2008/2003/NT/XP.

Confidential - St. Louis, MO

SQL Server DBA

Responsibilities:

• Creating various Jobs, scheduling & running jobs and troubleshooting the failed jobs.
• Monitoring and Troubleshooting SQL Server Performance issues using Microsoft System Centre Operations Manager (SCOM) and Spotlight.
• Plan for growth and changes (database capacity planning) and request additional SAN/NAS storage.
• Ensuring that Tivoli Storage Manager (TSM) scheduled backups run and that data is backed up according to requirements. Coordinating Tivoli Data Protection (TDP) installation with System Administrators.
• Performance Tuning of Slow Running Queries or inefficient Queries for Optimal Performance using SQL Profiler and Managing Indexes and Statistics.
• Involve in general Database Administration and validated some of the existing schema.
• Develop administrative tasks of performing daily Backups in a way that meets the business Recovery Point Objectives (RPO) and test the backups to ensure we can meet the business' Recovery Time Objectives (RTO).
• Implemented high availability techniques Always On, mirroring, Log shipping, Replication and involved in planning and monitoring of the HA/DR methods.
• Performance monitoring and taking steps to improve the I/O is one of the most important factors when setting up SQL server.
• Installed and Configured Transactional and Snapshot Replication for production servers to other production servers available in remote location.
• Successfully implemented Always On Availability group in SQL 2012 and installed SQL server in a cluster Environment.
• Ensure backup and recoverability of all enterprise SQL server databases using Native SQL and Symantec NetBackup. Created Databases on Azure SQL Server and Migrated On-Premise databases to Azure SQL.
• Daily routine Developer/DBA tasks like handling user's permissions, monitoring Blocking, Deadlocks, long running jobs, and space issues on Production and Semi-Production servers and handling maintenance jobs..
• Setting up High availability DR solutions over Azure. SQL Server Patching on 2005, 2008, 2008R2, 2012, 2014.
• Configured Azure SQL Server Firewall for Performance Tuning.
• Migrated the production SQL server schema to the new AWS RDS.
• Used Cloud watch for basic and detailed monitoring of AWS resources.
• Installed, Configured, managed security for SSIS, SSAS, and SSRS (2008 R2, 2012 &2014)
• Creating SSIS packages to load data across different servers.
• Re-Designed Siemens model cubes (SSAS) by partitioning the cubes yearly and then monthly.
• Involved in Cube Partitioning, Refresh strategy and planning and Dimensional data modeling in Analysis Services (SSAS). Responsible for tuning complex SQL queries and Stored Procedures to increase performance.
• Involved in integration/system testing and backup/restore testing for all components.
• Solid testing experience in working with SQL Stored Procedures, triggers, views and worked with performance tuning of complex SQL queries. Experience with Team Foundation Server and BI Documenter tool.
• Used TFS for source control and managing development via tasks/bugs.
• Responsible for deploying code changes, code review and code releases in all environments with respect to release deadlines. On Call 24X7 support, request queue, daily maintenance and application support.

Environment: SQL Server 2012/2014/2016 , Visual Studio 2008/2010, BIDS, T-SQL, SSIS, SSAS, SSRS, Azure, Red Gate SQL Compare, Lite Speed, Performance Analysis (PA), HP Quality Center, Crystal Reports, TFS, MS-Excel, XML, Windows

Confidential - Ellicott city, MD

SQL DBA/Developer

Responsibilities:

• Established and Scheduled Database Backup and Other Maintenance plans for User and System databases right after SQL server Installation process is done.
• Recovered the databases from backup in disasters. Implemented Point-In-Time Recovery solutions.
• Performed migration from 2005/2008-R2 SQL server databases version to SQL Server 2012 and SQL Server database consolidation.
• Managed SQL server high availability and disaster recovery strategies including Mirroring, Log shipping, Clustering and Always on availability groups.
• Implemented and Maintained Transactional and Snapshot Replication for reporting purposes.
• Monitor, troubleshoot, Optimize and fine-tune databases' Performance issues using DBCC, DMVs SQL server Profiler and third party tools like Tivoli.
• Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
• Resolved blocking and deadlock issues using activity monitor and system stored procedures.
• Worked with developers to develop and optimize SQL code for database scripts, triggers and stored procedures to implement database logic and maintenance.
• Responsible for reviewing, optimizing and deploying database scripts requested by Application Development Team.
• Auditing for changes to users, groups and computers, Directory Service Access events.
• Used database utility programs and 3rd party utilities to monitor database performance, such as Blocking, expensive queries, Memory utilization.
• Worked with developers to optimize the code if required to minimize the duration and look if the indexes were used appropriately.
• Configured and maintained transactional replication for flow of data from QA and Dev. Server to the replica servers.
• Report Development: Installed, Configured and administered SQL Server Reporting Services (SSRS 2008 R2, 2012), Deployed and Managed Reports/Ad-hoc Reports.
• DTS/SSIS: Export & Import data from/To Flat file, CSV file, Excel file, Oracle, and Access to SQL Server using DTS, SSIS, and BCP.
• Create, deploy, configure and monitor complex ETL/SSIS packages Wrote stored procedures to audit SQL servers, establish and enforcing security auditing mechanism and performance tuning, optimization.
• Create and manage database maintenance plans and design and implement backup and disaster recovery plans
• Extending post-implementation, application maintenance and enhancement support to the client.
• Responsible for overall system Maintenance, jobs/schedules, performance troubleshooting, daily Reports on delivery status, creating RFC's (Changes).
• Conducted DR tests periodically for group of Business Units and Normalize the environment after DR.
• Align and set up database policy standards and security procedures for all servers globally.
• Ensuring the Individual and Group level permission to the Database and Server Level.
• Implemented project timelines and standards for SQL Server builds capturing pre-build phase.
• Supported SQL server developers working on different projects with various requests.

Environment: SQL Server 2012/2014/2016 , Visual Studio 2008/2010, BIDS, T-SQL, SSIS, SSAS, SSRS, Azure, Red Gate SQL Compare, Lite Speed, Performance Analysis (PA), HP Quality Center, Crystal Reports, TFS, MS-Excel, XML, Windows

Confidential

SQL DBA/Developer

Responsibilities:

• Migrated SQL server 2000 databases into SQL server 2005 and SQL server 2005 databases into SQL server 2008databases by In-place upgrade process and also used upgrade advisor tool in up gradation process.
• Setting up and Monitored Clustering, transactional replication, Database mirroring on Production environments.
• Migrated DTS packages into SSIS packages.
• Handled up to 2 TB Size databases with clustered and standalone environment
• 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.
• Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks.
• Planned the Complete Backing up of Database and Restoring the Database from Disaster Recovery.
• Used DTS packages to move logins and jobs from one server to another server.
• Used log shipping for synchronization of database.
• Created Stored Procedures, Triggers, Views and Functions for the Application.
• Extensive testing on the Performance of the Stored Procedures.

Environment: SQL Server 2000/2005/2008 R2, T-SQL, Excel, Windows 2003/2008 Server, Windows 2003/2008

Confidential

DBA/Developer

Responsibilities:

• Installed and configured SQL Server 2005/2008/2008 (R2)/2012 on new servers with service packs.
• Support and troubleshoot very large databases (VLDB).
• Involved in ETL process under development, testing and production support environments.
• Extensively use SSIS tool to load data from MS Access, Excel spreadsheets, and flat files into the target SQL Server database.
• Develop complex mappings and tune mappings for better performance.
• Implement various Data Flow Transformations, such as Copy Column, Row Count, Merge Join, Aggregator, Sort, and Lookup.
• Fix data issues and write various SQL scripts and procedures for migration process.
• Involved in Data Compression, Hot add CPU, Fact Table size reduction and improved performance using SQL Server 2008.
• Expert in using and implementing DMV's, DMF's, data partitioning, DDL triggers, Mirroring and Online indexing.
• Develop all the required stored procedures, user defined functions, and triggers using T-SQL and PL/SQL.
• Hands on experience with the third party tools (Erwin, Fog Light, VERITAS )
• Restore Development and Staging databases from production backups as per the requirement.
• Maintain the database consistency with DBCC, DMF and DMV's at regular intervals.
• Troubleshoot and fine-tune databases for performance and concurrency.

Environment: MS SQL Server 2000/2005, Windows 2000/2003, SSRS, SSIS, SSAS, PL/SQL, MS Access, VB, C#, Erwin and SharePoint 2007.