SUMMARY:

• Extensive SQL Server DBA experience in support on a 24x7 production environment
• Designing a successful backup strategy to ensure backups are done at regular intervals, Creating and monitoring jobs for automating daily tasks like backups, checking integrity of databases, updating statistics
• Experience on Replication setup and troubleshooting the replication problems on Production servers, Configuring Log Shipping and DB mirroring and testing the failovers manually to ensure high availability
• Strong in analyzing bottlenecks in SQL Server performance and tune it for optimum performance, Experience in creating databases based on functional requirements and Developing the successful Backup strategies based on Recovery models
• Strong experience in Migration and up gradation of business critical environments
• Automated regular DBA activities like Backup, Restore and DB refreshes using Windows Powershell
• Strong experience in setup and trouble shooting of High Availability features like Mirroring, Log Shipping, Clustering and Always On in Physical and VMware (Virtual Environments)
• Experience in Performance Tuning, Query Optimization, Execution Plan, Client/Server Connectivity, Database consistency checks using DBCC Utilities.
• Using Performance Monitor/Profiler to solve Dead Locks/Long running queries
• Extensive experience in performance tuning and monitoring and backup tools like Foglight, RedGate, Veritas Net Backup etc
• Experience in Database Backup, Recovery and Disaster Recovery procedures
• Experience in data warehouse development with Integration Services and OLAP report development
• Sound knowledge of software development life cycle (SDLC) with substantial experience with object oriented analysis and design methodologies
• Create, manage SQL Server AZURE Databases. Setting up Connection Strings and connecting SQL Server AZURE Databases from locally Installed SQL Server Management Studio(SSMS) for Developers
• Strong knowledge in database design features including ER Diagrams, normalization, tables, views, indexes, constraints, keys, data dictionaries, and data integrity
• Experience in writing SQL Queries involving multiple tables inner and outer joins
• Experience in optimizing the queries by creating various clustered, non - clustered indexes and indexed views
• Experience in Creating Tables, Views, Triggers, Stored Procedures, User Defined Functions and other T- SQL statements for various applications
• Worked Extensively on ETL process using SSIS package
• Excellent in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS), DTS, Bulk Insert, Bulk Copy Program(BCP)
• Expert in design and development of SQL Server Integration Services (SSIS) packages and using various control flow task and data flow transformation
• Excellent in creating SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all
• Absolute knowledge of software development life cycle(SDLC), database design, RDBMS, data warehousing and data modeling concepts
• Strong communication, collaboration & team building skills with proficiency at grasping new technical concepts quickly and utilize the same in a productive manner

TECHNICAL SKILLS:

RDBMS/DBMS: MS-SQL Server 2008/2005/2000

Database Technologies/Tools: SQL Server Entreprise Manager, Microsoft Management Console, SQL, T-SQL, Data Transformation Services (DTS), OLTP, BCP, SSIS, OLAP. Microsoft Visio, ER Studio

Reporting Tools: Microsoft SQL Server Reporting Services

Operating Systems: Windows XP, 2000, NT, Windows 2003,2008, Windows 7

Data Warehouse/ BI Tools: SSRS, SSIS, Visual Studio, Business Intelligence Development Studio (BIDS)

PROFESSIONAL EXPERIENCE:

Confidential, Ohio OH

Sr. SQL Server DBA

Responsibilities:

• Managing SQL Server 2008,nstallation, applying Service packs on all types of environment, providing 24x7 support for mission critical production databases
• Daily Maintenance of SQL Servers included reviewing SQL error logs, Event logs, Create and manage users, roles, and profiles to provide security for the database, Maintaining and configuring high availability
• Ensure all database servers are backed up in a way that meets the business’s Recovery Point Objectives (RPO)
• Troubleshoot SQL Server service outages as they occur, including after-hours and weekends
• Managed the Migration of SQL Server 2008 databases to SQL Server 2014, Working with customers on Application rollouts and server migrations
• Configure SQL Server monitoring utilities to minimize false alarms
• Deploy database change scripts provided by third party vendors
• Strong experience in setup of High Availability features like Mirroring, Log Shipping, Clustering and Always On
• Work on performance issues, determine the most effective way to increase performance including hardware purchases, server configuration changes, or index/query changes
• Designing a successful backup strategy to ensure backups are done at regular intervals, worked DB refreshes, Backup and Restores
• Worked on performance issues and generated reports using Foglight Performance analysis tool
• Create, manage SQL Server AZURE Databases.
• Setting up Connection Strings and connecting SQL Server AZURE Databases from locally Installed SQL Server Management Studio(SSMS) for Developers

Environment: MS SQL Server 2008,2012,2014 Management Studio, T-SQL, SQL Server Integration Services (SSIS), SSRS, ASP.Net, vb.Net, VB Script, MS Access, Windows Server 2008 and 2012

Sr. SQL Server DBA

Responsibilities:

• Managing SQL Server 2008,2012 and 2014 Installation, applying Service packs on all types of environment, providing 24x7 support for mission critical production databases
• Daily Maintenance of SQL Servers included reviewing SQL error logs, Event logs, Create and manage users, roles, and profiles to provide security for the database, Maintaining and configuring high availability of SQL Cluster, Replication, Database Mirroring and Log shipping in Physical and VMware (Virtual Environments)
• Managed the Migration of SQL Server 2008 databases to SQL Server 2014, Working with customers on Application rollouts and server migrations
• Setup transactional replication between servers and supporting to run without outage, Performance tuning at database and server level Upgrading servers from SQL 2005,2008 to SQL 2012.MS SQL Server database administration like automating backups, shrinking, reindexing, changes for fixing the bugs
• Strong experience in setup of High Availability features like Mirroring, Log Shipping, Clustering and Always On
• Designing a successful backup strategy to ensure backups are done at regular intervals, worked DB refreshes, Backup and Restores
• Worked on performance issues and generated reports using Foglight Performance analysis tool
• Create, manage SQL Server AZURE Databases.
• Setting up Connection Strings and connecting SQL Server AZURE Databases from locally Installed SQL Server Management Studio(SSMS) for Developers
• Set up maintenance tasks such as database backups, consistency checks and Database optimizations, Create and manage users, roles, and profiles to provide security for the database
• Managing SQL Server full database backup, T log backups and data restore, Scheduling Jobs and Alerts using SQL Server Agent.
• Designing and developing SQL Server 2012 Databases, Tables, Indexes, Stored procedures, Views, Triggers.
• Strong experience with SQL Server performance tuning and optimization, query optimization, index tuning, caching and buffer tuning.
• Created and developed the stored procedures, triggers to handle complex business rules, history data and audit analysis.
• Worked on ETL SSIS Development, created packages using various transformation techniques and also created jobs that are scheduled to run on daily basis and thus load into the Data Warehouse.
• Hands on experience in using different transformations like Scrip task, Fuzzy Lookup, Derived column, Conditional split, Multicast transformation etc using SSIS.
• Used SQL Server profiler for auditing and analyzing the events which occurred during a particular time horizon and stored in script.
• Created traces using SQL server profiler to find long running queries and modify those queries as a part of Performance Tuning operations.
• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
• Involved in designing the physical databases model on SQL Server 2008 RDBMS using different Data Definition and Manipulation languages (DML/DDL) implementing constraints and triggers for data integrity in development database.
• Extensive testing on the Performance of the Stored Procedures by using the execution plan.
• Monitored performance and fine-tuned the database objects and server to ensure efficient data retrieval.

Environment: MS SQL Server 2008,2012 Visual Studio, MS SQL Server 2008,2012,2014 Management Studio, T-SQL, SQL Server Integration Services (SSIS), SSRS, Foglight, ASP.Net, vb.Net, VB Script, MS Access, Lite Speed Backup software, DTS, MDX, Sybase, OLAP, Windows 2007/XP, MS Visio

SQL Server DBA

Responsibilities:

• Managing SQL Server 2008,2012 Installation, applying Service packs on all types of environment, providing 24x5 support for mission critical production databases of sizes ranging from few GBs to 5 TB
• Setup transactional replication between servers and supporting to run without outage, Performance tuning at database and server level Upgrading servers from SQL 2005,2008 to SQL 2012.MS SQL Server database administration like automating backups, shrinking, reindexing, changes for fixing the bugs
• Performed the migration of SQL Server 2005 to SQL Server 2008R2 with DB size of 3TB.
• Worked on performance tuning using RedGate
• Automated regular DBA activities like Backup, Restore and DB refreshes using Windows Powershell
• Set up maintenance tasks such as database backups, consistency checks and Database optimizations, Create and manage users, roles, and profiles to provide security for the database
• Strong experience in setup of High Availability features like Mirroring, Log Shipping, Clustering and Always On
• Designing and developing SQL Server 2008 Databases, Tables, Indexes, Stored procedures, Views, Triggers.
• Created and developed the stored procedures, triggers to handle complex business rules, history data and audit analysis.
• Identify, analyze and review technical requirements for MEDD/RDS.
• Analyze current work flow and initiate process improvements to enhance the efficiency of existing work flow.
• Comprehend technical feasibility and define database specifications of reporting requirements.
• Translate the requirements to technical specification for development.
• Provide quality assurance/testing and analysis for deployed reports under UAT and post production deployment as per Software Development Life Cycle (SDLC) Process.
• Create Stored Procedures, User Defined Functions, Views, T-SQL Scripting for complex business logic.
• Created SSIS Packages to validate the accuracy of the report with the previous generated report.
• Worked extensively with Slowly Changing Dimension and lookup Transformation for implementing Inserts and Updates.
• Identify SQL Server performance issues through the use of dynamic management views and server statistics monitoring and offer solutions (execution plan optimization, index tuning, and query modification). In cases of hardware bottlenecks, identify the culprit and work with System Administrators to resolve the problem.
• Assist in performance assessment of the project.
• Responsible for monitoring, DB tuning and maintenance activities
• Managing SQL Server full database backup, T log backups and data restore, Scheduling Jobs and Alerts using SQL Server Agent.
• Performed unit and system testing, troubleshooting and bug fixing in development and QA environments.
• Worked on Performance Tuning, Query Optimization, using SQL Server Profiler, Data Base Engine Tuning Advisor and other troubleshooting tools.

Environment: MS SQL Server 2008 Visual Studio, MS SQL Server 2008 Management Studio, T-SQL, SQL Server Integration Services (SSIS), SSRS, SQL Server CE client, ASP.Net, vb.Net, VB Script, MS Access, Lite Speed Backup software, DTS, MDX, Sybase, OLAP, Windows 2008/XP, MS Visio, Cognos, RX Claim, RX track

SQL Server DBA

Responsibilities:

• Designing a successful backup strategy to ensure backups are done at regular intervals, worked DB refreshes, Backup and Restores
• Set up maintenance tasks such as database backups, consistency checks and Database optimizations, Create and manage users, roles, and profiles to provide security for the database
• Managing SQL Server full database backup, T log backups and data restore, Scheduling Jobs and Alerts using SQL Server Agent.
• Performed the migration of SQL Server 2005 to SQL Server 2008R2.
• Designing and developing SQL Server 2008 Databases, Tables, Indexes, Stored procedures, Views, Triggers.
• Created and developed the stored procedures, triggers to handle complex business rules, history data and audit analysis.
• Perform refreshes of development, reporting and staging environments from production database, Designing Database and estimation of future requirements, Monitoring and auditing users, Monitoring disk spaces on all the servers
• Weekly meetings with CCB (Change control board) & Infrastructure Administrators to ensure quality delivery & standard setup throughout the LOBs (Line of Business) and projects, aligned with defined process.
• Managing security roles in SQL Suite.
• Diagnosing and tuning the server optimal performance using SQL Server 2005 SQL Profiler and Database Engine Tuning Wizards.
• Coordinate with business and end users and gather all data design specifications as per customer requirements.
• Analyze business requirements and assist in appropriate configuration for all solution architecture.
• Design communication process and prepare plans for all work assignments and ensure completion within deadline.
• Monitor all data projects according to development life cycle and ensure compliance to quality standards.
• Administer design of Business Intelligence projects and develop dashboards and operations for reports.
• Develop reports and dashboards on SQL servers.
• Prepare test cases and plans and perform tests on systems.
• Install and assist to configure various Business Intelligence tools.
• Perform troubleshoot on all Business Intelligence tools and assist in resolution.
• Assist all clients to choose appropriate Enterprise Business Intelligence tools.
• Coordinate with enterprise systems and applications and assist in merging various platforms.
• Design and fabricate various SQL Server Integration packages and prepare appropriate reports for data collection.
• Good hands on experience with SQL Server Integration Services, SQL Server Reporting Services and SQL Server Analysis Services.

Environment: MS SQL Server 2008 Visual Studio, T-SQL, SQL Server Integration Services (SSIS), SSRS, SQL Server CE client, ASP.Net, vb.Net, VB Script, MS Access, Lite Speed Backup software, DTS, MDX, Sybase, OLAP, Windows 2008/XP, MS Visio.

SQL Server DBA

Responsibilities:

• Managing remote SQL Server clustered environment, Installation, patching, for SQL Server 2008R2 /2005 /2000 Installing, Configuring and Administering SQL server 2005,2008 and 2008 R2 in 2node clustered and stand alone servers
• Configuration and maintenance of all SQL High Availability environments as per client requirementPerform refreshes of development, reporting and staging environments from production database
• Designing Database and estimation of future requirements, Monitoring and auditing users, Monitoring disk spaces on all the servers
• Installation, configuration and upgrading Microsoft SQL Server software and related products, Evaluate Microsoft SQL Server features and related products, setting up Log Shipping from primary to secondary server, Establish and maintain sound backup and recovery policies and procedures
• Designing and developing SQL Server 2008 Databases, Tables, Indexes, Stored procedures, Views, Triggers.
• Created and developed the stored procedures, triggers to handle complex business rules, history data and audit analysis.
• Written complex SQL statements using joins, sub queries and correlated sub queries.
• Migrate the data from an Access database to SQL Server 2008.
• Fetch the data from Oracle 11g by creating a linked server and use SQL Server to query Oracle database.
• Designed the packages in order to extract data from SQL DB, flat files and loaded into Oracle database.
• Wrote and maintained database documentation, including data standards, procedures, definitions for the data dictionary and logical and physical models of the databases.
• Involved in re-design, re-code, and deploy new data extractions using SSIS, and designed and produced documentation of data transformations for all extractions.
• Used SQL Server Profiler for troubleshooting, monitoring, and optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.
• Used SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.

Environment: MS SQL Server 2008, Visual Studio, VB.Net, C#, Oracle, MS SQL Server Management Studio, SSIS, SSRS, SSAS, MS Excel, Teradata.

SQL Server DBA

Responsibilities:

• Installing, Configuring and Administering SQL server 2000 and 2005, Designing Database and estimation of future requirements, Monitoring and auditing users, performing backup strategy, backup and recovery, Monitoring and optimizing the performance of the database
• Performing Database maintenance activities like Backups, Restoring, Reindexing etc, Analyzing, Identifying and Resolving performance issues of the server, as part of the DBA team providing 24/7 production support to the clients
• Involved in the creation of the databases and designing Normalized database objects.
• Developed Indexes, Stored procedures, Views, Triggers and user-defined functions as per business requirement.
• Modified current database by adding tables and relationships to support online system.
• Defined constraints, rules and defaults.
• Created views as required by front-end developer for easier implementation on web pages, and triggers on those views to provide efficient data manipulation.
• Created complex stored procedures and functions to support efficient data storage and manipulation.
• Create the SSIS reports. Fixed the reports exporting issues and paging issues.
• Scheduled jobs for backup, and created alerts for error reporting.

Environment: MS SQL Server 2003, Visual Studio, VB.Net, C#, Oracle, MS SQL Server Management Studio 2005, SSIS, MS Excel, Windows NT.