Sql Server Manager

Koushik

Email: ***.***********@*****.*** Cell: 904-***-**** Certified SQL Server DBA

PROFESSIONAL SUMMARY

Over 3+ years of experience in Administration & Development of MS SQL SERVER 2014, 2012, 2008R2, 2008, and SQL Server Business Intelligence Tools- SSIS, SSRS and SSAS.

Experience in database administration activities like Installation, Configuration, Migration, Upgrading, Monitoring and Troubleshooting SQL Server 2016/2014/2012/2008/R2.

Experience in implementing High Availability solutions like Replication (Snapshot, Merge and Transactional), Log shipping, Mirroring, Always On and Clustering.

Implemented Side-by- Side Migration of MS SQL SERVER 2008/2012.

Experience in using SQL Server Profilers, Index Tuning Wizard.

Experience in Partitioning tables to achieve better performance for access and writes.

Experience in creating roles and assigning permissions to the users.

Experience In Database Backup, Recovery and Disaster Recovery Procedures. Extensive knowledge in Tuning SQL queries & improving the performance of the database by creating and updating clustered and non-clustered indexes.

Experience in writing T-SQL (DDL, DML and DCL), Expert in implementing business logic in backend and reviewing T-SQL Code.

Expert in developing and designing Bulk Copy Program (BCP), and SSIS (integration services) with MS SQL Server 2005/2008/2012.

Experienced in creating deployment utility to deploy SSIS packages over Production, QA and Local systems.

Experience in creating Constraints, Defaults, Rules, Tables, Indexes, Views, Stored Procedures, Functions, Triggers, Cursors and Dynamic SQL queries.

Designed SSIS packages to export and import data from SQL Server to MS Access, Text files and Excel files.

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.

Experience in Design, deployment, and maintenance of various SSRS Reports in SQL Server 2008/2012.

Experience in Analyzing Execution Plan, managing indexes and troubleshooting deadlocks.

Performed SQL server patching on both Standalone and Clustered environment

Experience in creating SQL Server Analysis projects (SSAS).

Expert in creating SQL Server Reports using SSRS 2005/2008/2012.

Good at Creating documentation about the process and environment.

Provided 24X7 supports through on call rotation for Production and Non-Production Environments.

Very good in creating UML diagrams like Class, Use case, Activity, Sequence, ER diagrams for a software project.

Knowledge on Cloud/AWS/Azure.

Good understanding in AWS design and Administration with knowledge in EC2 and AWS.

Worked extensively on Data Warehouse setup on SQL Server 2012.

Excellent analytical and desire to excel, fast learner, Hardworking and versatile team player.

Capable of learning new technologies and processes, and successfully applying them to projects and operations.

Highly dedicated, dynamic, ability to meet deadlines within fast paced environments

Excellent communication, presentation, and interpersonal skills. Strong troubleshooting organizational skills.

CERTIFICATION:

Microsoft Certified SQL Server Database Admin

EDUCATION:

Masters in Computer Science from University of Central Missouri G.P.A: 3.6

Bachelors in Computer Science from JNTUH G.P.A: 3.4

TECHNICAL SKILLS:

Databases

MS-SQL Server 2008/2008R2/2012/2014, MySQL

Languages

C, C#, T-SQL, VB Script, Java Script, HTML, XML

SQL Server Tools

SQL Server Management Studio, Microsoft Visual Studio 2008/2010/2012, SQL Server enterprise Manager, SQL Profiler, Activity Monitor, SQL Server Report Builder.

Monitoring Tools

Red-gate, SCOM Monitoring, Windows Performance Monitor.

Data Modeling Tools

Erwin Data Modeling tool, ER Studio

OLAP Tools

SQL Server Analysis Server 2008, 2005

Software Packages

MS Office 97/2000/XP, 2003, 2007, MS Outlook 2003, 2007

Operating Systems

Windows 2012/2008/2003/2000, Unix, Linux.

PROFESSIONAL EXPERIENCE:

IT SYNTAX (Internship) Aug’16 – JUL’17

Role: Junior SQL DBA

IT SYNTAX is a software development firm specializing in implementing business critical applications. IT Syntax offers the expertise and resources to select and implement the right technology strategy, develop architectures based on new e-enabling technologies and integrating solution building blocks into powerful business solutions. They offer services for many different industries, such as Health Insurance, transportation, legal, manufacturing, retail, telecommunications and state and local governments.

Responsibilities:

Installed and configured SQL Server 2012/2014/2016 on production and non-production servers.

Implemented and monitored transactional replication for DR and reporting purposes.

Configured and Monitored Log Shipping and Trouble shoot the errors.

Created database objects such as tables, Stored Procedures, Views and Triggers.

Implemented User-Defined server roles in SQL Server 2012, default schemas for groups.

Created Jobs and maintenance plans for better performance of the server.

Created alerts with database mail Simple Mail Transfer Protocol (SMTP).

Worked extensively in Query analyzer and profiler for tuning queries using variable for characteristics and query costs.

Migrated 2008 SSIS packages to SQL 2012 project deployment model and configured SSIS Catalog, environments.

Design DTS/SSIS Package, DTS Import/Export for transferring data.

Export or Import data from other data sources like flat files using Import/Export through DTS, SSIS.

Expert in using SSMS (SQL Server Management Studio).

Performed data analysis for designing, developing data marts, cubes for BI Reports and analytical purposes.

Implemented Transparent Data Encryption (TDE) to protect sensitive data and backups.

Used Database Consistency Checks – DBCC Commands for database maintenance.

Developed database administration reports for disk utilization, backup check, daily Replication status check, Job status and other daily monitoring tasks.

Created maintenance plans for integrity checks and resolved issues related to it.

Experience with SCOM to monitor and manage critical database servers from a centralized location.

Modified Stored Procedures and complex T-SQL Queries to improve query execution process.

Used SQL Profiler, Server side trace to identify performance issues on the server.

Improved query performance by analyzing the stats, Query Execution Plans, system performance by system Performance Analysis, and used SQL Profiler for optimizing stored procedures.

Resolved issues related to blocking, deadlocks, connectivity issues, replication issues.

Environment: Windows Server2008 R2 and 2012, SQL Server 2014/2012/2008 R2/2008, SQL Query Analyzer, SSRS, SSIS, SSMS (SQL Server Management Studio), SCOM, Data Tools, Internet Information Server 6/7.5, JavaScript, CSS, HTML, .Net Framework 3.5/4.5, SSAS

ALSTOM TRANSPORTATION INC May2013 – July2015

Role: Junior SQL DBA and Developer

Alstom Transportation Inc Alstom is a French multinational company operating worldwide in rail transport markets, active in the fields of passenger transportation, signaling and locomotives, with products including the AGV, TGV, Eurostar, and Pendolino high-speed trains, in addition to suburban, regional and metro trains.

Responsibilities:

Installed and Configured SQL Server 2008/2008R2.

Implemented side by side migration of SQL Server 2005 to SQL Server 2008/2008R2.

Implemented high availability solutions for SQL Server databases with Mirroring.

Implemented and monitored the replication between two sites, support and maintenance of MS SQL Server Transactional Replication.

Worked in 24X7 production support with on call rotation system.

Proactively monitored, determined and solved issues at SQL database/server levels with the help of Idera SQL Diagnostic manager.

Responsible for Physical Storage Structures and Index Design and Tuning.

Restored and recovered databases to point in time for testing, pre-prod and production environments.

Used SQL Profiler to find badly performing queries and deadlocks.

Performed Query tuning to improve performance for long run queries.

Used 3rd party tools like Idera SQL Diagnostic Manager in taking the backups to optimize performance and restoring.

Testing and resolving issues related to database Connectivity.

Applying service packs to the SQL Server instances.

Used SQL Profiler, Windows Performance Monitor for troubleshooting, monitoring, optimization of SQL Server.

Monitored database status including CPU, Memory, I/O, Space and dead lock using SQL Server Utilities.

Developed SSIS packages to export data from OLTP database to OLAP database.

Involved in loading the Warehouse databases and performing maintenance tasks on these databases.

Involved in design of SQL triggers, and correcting database errors.

Configured and worked on SSRS in SharePoint integration and native mode.

Environment: MS SQL Server 2008R2/2008, Windows Enterprises, Standard 2003/2008 servers, JavaScript, CSS, HTML, Microsoft CRM, SSIS, SSRS, SharePoint 2010, Idera SQL Diagnostic Manager, ERWIN, C#, VB.Net and ASP.Net.

Graduate Research Assistant JAN2016– MAY2016

University of central Missouri

Responsibilities:

Work under the support and guidance of senior Professor.

Assist with collecting and analyzing qualitative data.

Reviewing and analyzing research, including meta-analysis.

Produce reports and assist with general analysis of data it relates.

Data collection, data entry, merge and manipulate collected information, database management, create and run queries from various databases

Tune the queries to get optimal results.

Writing reports on the data analyzed.

Academic Projects:

Test Simulator

Role: Database Designer Languages Used: C#, T-SQL Tools: Visual Studio, SQL Server

Test Simulator is a computer game designed for schools which wants to check the arithmetical ability of a student in wide range of topics.

Responsibilities:

Created data model for the project.

Designed UML diagrams for the project.

Installing and Giving connection between the application and SQL server.

Creating tables and implementing the relation between the tables.

Implementing joins on tables

Performing manual testing on the application.

Design Modules for the project.

Assist and Support other team members in designing the windows forms.

Develop logical and physical data models that meet application requirements.

Hospital Management System

Role: Database Designer Languages Used: C#, T-SQL Tools: Visual studio, SQL Server

Hospital management system is designed to cover a wide range of hospital administration management processes. It stores entire patient information, reports and billing and helps hospital administration to manage patient reports and financial accounting.

Responsibilities:

Design data model for the project and create tables, add constraints to it.

Writing queries to insert the data and retrieve the data.

Giving connection between the application and SQL server.

Finding the relationship between the entities.

Implementing normal forms on tables to decrease data redundancy and improve data integrity.

Contact this candidate