SUMMARY:

• Talented SQL Server Database Administrator with significant experience in SQL Server Management Studio, Visual Studio and Tableau. Proficient in a wide range of development languages, including C#, T - SQL and Python. Excellent presentation and communication skills. Seeking a SQL Server Database Administrator position; to work with an organization which will utilize my competencies to achieve company goals and also enhance my overall development.
• Experience in Data Centre Migration Activities
• Good knowledge and understanding of Virtualization
• Extensively worked on system analysis, design, development, testing and implementation of projects (SDLC) with different methodologies like Agile, Scrum & Waterfall etc. and capable of handling responsibilities independently as well as a proactive team member
• Experienced in Security and Support of MS SQL Server 2012, 2008, 2008r2, 2005 and 2000 in Production, Testing, Development Environments.
• Performed Normalization and built Referential Integrity Constraints.
• Extensive knowledge and experience in developing Stored Procedures, Views, Triggers, cursors and Complex Queries on SQL Server 2000/ 2005/2008/2008 r2/2012.
• Conducted Database Backup and Restore, Attach and Detach, Recovery and Disaster Recovery procedures.
• Experience in Capacity planning, Performance Tuning, troubleshooting, backup and restore procedures.
• Experience in implementing efficient Disaster Recovery Strategies and High availability like Replication (Snapshot and Transactional with updatable subscriptions), Log shipping, Clustering (Active-Active) and Database Mirroring.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, SSRS and SSIS services.
• Excellent backend skills in creating SQL objects like tables, stored procedures, views, Indexes, triggers, rules, defaults, user defined data types and functions.
• Experience in Performance Tuning by Index Defragmentation, optimizing execution plans, proper usage of indexes, horizontal and vertical partitioning.
• Experience in creating Packages, Jobs, sending alerts using SQL Mail and custom extended procedures, Creation and maintenance of Databases, creating Roles and managing user permissions.
• Experience in data Import/Export utilities tools like SSIS, SSRS, BCP, BULK INSERT.
• Experience using DBCC commands, SQL Profiler, SQL Server Management Studio, Trace Analysis and Execution plans as part of trouble shooting and performance tuning.
• Experience in monitoring and tuning SQL Server database performance using SQL Profiler, DMV's, Index Tuning Wizard and Windows Performance Monitor.
• Experience in Database Designing/Modelling for new applications (OLAP & OLTP systems) and database changes to existing applications.
• Experience in T-SQL programming for writing DDL & DML queries, stored procedures, user-defined functions, Triggers, Cursors, Views setup
• Involved exclusively in Disaster Recovery plans like Backup/Restore, Database Mirroring, Log Shipping
• Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.

TECHNICAL SKILLS:

Programming Languages: SQL, Transact SQL, C#, HTML, CSS 3, C# / ADO .Net, jQuery, WordPress

RDBMS (Databases): Microsoft SQL Server 2012, 2014

SQL Server Tools: SQL Server Management Studio, SQL Profiler, SQL Query Builder, Tuning Advisor

Business Intelligence: SSRS, SSIS, MS Visual Studio 2015

Data Modeling: Visio, Use Case Diagrams.

Operating Systems: Windows 7/8/10, Windows Server 2003/2007/2012

Others: Microsoft Office, Agile development methodologies (SCRUM)

PROFESSIONAL EXPERIENCE:

Confidential, Berlin, CT

SQL Server DBA

Responsibilities:

• Installation and configuration of MS SQL Server 2005/2008/2008 R2/2012
• Creates Stored Procedures, User defined functions, Views and Wrote T- SQL codes maintaining query standards for the project.
• Extensively uses Joins and sub-Queries to simplify complex queries involving multiple tables, added Columns and Worked on Index tuning, stored Procedure tuning.
• Involve in Optimization and normalization of database and tables.
• Develops stored procedures, triggers and functions and added/changed tables for data extraction and transformation, and data loading (ETL).
• Part of team for analyzing and implementing the physical design for database.
• Designs logical and physical database structure to facilitate analysis of data from both operational and customer perspectives.
• Creates new database objects like Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production for SQL Server 2008/2008R2/2012.
• Designs and builds data load procedures, using MS SQL Server import and export.
• Responsible for transferring of database and database objects from Development to Production Server using DTS.
• Uses SQL Profiler and Query Analyzer to optimize queries and Stored Procedures.
• Creates Database Maintenance Plan for the Performance of SQL Server which covers Database Integrity Checks.
• Involve in analysis and tuning complex queries or stored procedure in SQL Server 2008/2008R2/2012 for faster execution and developed database structures.
• Plans the Complete Backing up of Database and Restoring the Database from Disaster Recovery.

Environment: MS SQL Server 2008/2008R2/2012, T-SQL

Confidential

Database Administrator

Responsibilities:

• Installed, configured, tuned and provided 24X7 support for SQL Server 2005/2008R2/2012/14
• Created and scheduled jobs to setup log shipping between production servers.
• Implemented Database Mirroring on the SQL Server 2008R2/2012 production databases.
• Monitored SQL agent jobs and make sure all jobs run successfully every night.
• Created databases and logins with permissions in SQL Server environments as per the developer's request.
• Worked extensively on SQL Server Reporting Services to generate reports.
• Created Linked Servers between different SQL server environments.
• Involved in Migration from SQL Server and 2008
• Created Database Maintenance Plans for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Restored Development and Staging databases from production backups as per team member requirement.
• Monitored backup jobs daily and run the jobs manually in case of failure depending upon the necessity.
• Performed database enhancement and modification as per the requirements in SQL Server.
• Prepared daily report on the job failures, backup failures and disk space.
• Extensively used Database Performance Monitoring tools for performance tuning.
• Designed and implemented database maintenance plan.
• Used Index tuning wizard and rebuilding indexes for faster Query Performance.
• Assisted in capacity planning, space management and data maintenance activities for database system in SQL Server.
• Involved in resolving deadlock issues and performance issues.

Environment: SQL profiler, SQL Query Analyzer, Index Analyzer, SSIS, SSRS, SSAS, DTA, Upgrade Wizard, Bulk Insert and BCP, SQL Server Management Studio.

Confidential

IT Analyst

Responsibilities:

• Managed sensitive, high-profile client financial information.
• Installed and configured computer operating systems and applications.
• Designed and implemented SQL Server 2005, SQL Server 2008 R2 databases for mission-critical business.
• Knowledge of Disk and Server configuration through Raid for SQL Server.
• Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and SQL code.
• Developed and modified stored procedures, queries, triggers, views, indexes, and functions to handle business rules, history data and audit analysis.
• Used Data Transformation Services DTS /SQL Server Integration Services SSIS and Extract Transform Loading ETL tools of SQL Server to populate data from various data sources, creating packages for different data loading operations for application.
• Configured and supported SSIS and SSRS for SQL Server 2005 and 2008 R2.
• Troubleshoot databases and custom application issues.
• Worked with end users to define, implement, and maintain their reporting requirements
• Assisted in the design, coding, testing and implementation of high volume transactional OLTP SQL databases instances.
• Developed and documented SQL coding guidelines.
• Generated the weekly, monthly, and quarterly report by using SQL Standard Report.
• Created reports that ran daily for jobs running in SQL Server Agent.
• Maintained and monitored server room, wireless network and other server infrastructure.