SUMMARY

• Around 6 years IT experience in SQL SERVER DATABASE ADMINISTARSTION and its related activities.
• Hands on experience with High Availability & Disaster Recovery Solutions - log shipping, Mirroring Always on and Replication (Snapshot & Transactional).
• Mastered in Online Transaction Processing (OLTP)&Online Analytical Processing (OLAP).
• Developed many SQL queries depending on the requirements in the project.
• Developed Dimensional Modeling, ER Modeling, Star Schema, Snowflake Schema.
• Experience with Clustering (Active-Passive and Active-Active) and database migration.
• Good understanding and experience in Object Oriented Methodologies.
• Good experience with powershell scripting.
• Developed and implemented complex business rules in tsql using functions, triggers and stored procedures.
• Expertise in complete ETL cycle including data analysis, database design, data mapping conversion and data load.
• Experience in production support of data loading and making the data available in data marts.
• Experience in performance tuning, maintaining & schedulingSQL Server Jobs, Query Optimization and Indexing of database using SQL profiler and Query Analyzer.
• Familiar with SQL Server third party tools(Litespeed, Idera, Spotlight, Redgate) used for backup, restore and performance tuning of databases.
• Administered, maintained policies and procedures for ensuring the security and Integrity of the company database.
• Experience in different phases of Software Development Life Cycle (SDLC) including Planning, Design, Development and Testing during the development of software applications and in Agile/ Scrum Methodology.
• Expertise in generating reports usingSQL Server Reporting Services and Crystal Reports.
• Worked closely with project management, applications development teams to resolve business hampering database problems.
• Adaptable new technologies at greater pace for fulfilling the project goals and objectives.
• Good team member with strong interpersonal and communication skills combined with self-motivation and the ability to think outside the box.
• Quality of learn ad-infinitum provides the space to think outside the box.

TECHNICAL SKILLS

Framework: .NET Framework, MVC

Languages: C, C++, C#, T-SQL, Oracle, LINQ

Scripting Languages: Java Script, J-Query

Web Technologies: Azure, HTML, HTML5, DHTML, CSS, Web Services (SOAP, RESTFUL)

Operating Systems: Windows 7,8,10, Windows Server 2003/2008, LINUX, UNIX

Databases: MS SQL Server 2008R2, 2012, 2014, 2016

Protocols: TCP/IP, HTTP, FTP

Tools: SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS), Visual Studio, TOAD, SQL Developer.

Reporting Tools: Crystal Reports, SQL Server Reporting Services (SSRS)

PROFESSIONAL EXPERIENCE

SQL SERVER DBA

Confidential, GA

RESPONSIBILITIES:

• Installation and Maintenance of SQL Server 2012, 2014, 2016 instances on production and test environments along with configuring the drives according to standards and policies.
• Implementing Disaster Recovery solutions like Transactional Replication and log shipping for high availability.
• Setting up proactive database performance monitoring and tuning.
• Maintained system security, users and their roles, assigned privileges as well as concentrates on capacity planning of database.
• Developed DTS packages to extract, transform and load into the Campaign database from OLTP database.
• Involved in loading the partner flat files into the OLTP database. Also, developed the T-SQL stored procedures/functions to process these data and populate them in the appropriate destination tables.
• Created and configured an OLTP replication database for disaster recovery purpose.
• Worked with developers to tune the SQL queries using SQL Profiler.
• Worked with Star Schema, Cubes and Analytical services.
• Capacity planning of databases according to client requirements.
• Provided on call support for the server maintenance and incident issues.
• Worked on very large and complex database and in a highly transactional environment.
• Back up and restored master, system databases depending on the requirements.
• Maintained field office database backups through SQL mail scripts through SMTP.
• Maintained documentation throughout whenever and wherever required.
• Designed and implemented comprehensive Backup plan and disaster recovery with and without compression.

SQL Server DBA

Confidential, PA

RESPONSIBILITIES:

• Server maintenance of SQL Server 2012, 2008R2 updating with latest service packs and security patches.
• Administrating MS SQL Server by creating user logins with appropriate roles,dropping and locking the logins, monitoring the user accounts, creating roles, granting privileges to users by adding them to roles.
• Implementation of log shipping for production server as part of the disaster recovery.
• Responsible for General Server maintenance and Performance tuning.
• Experienced in resolving deadlock and blocking issues for concurrent users.
• Worked with DTS packages to load the data into Data warehouse.
• Data Migration from legacy systems using DTS-Import and Export wizard.
• Developed Database Backup Scripts and automated this process.
• Deploy and scheduled SSIS package and reports as per user requests. Migrated SSIS package fromSQL Server from Dev to higher environments.
• Using PowerShell scripts on regular basis for getting instance specific details.
• Partially participated in system study and analysis of software applications.
• Experienced in production support and applications development.
• Coordinating implementation of performance tuning actions with application development teams.
• Analyzing and implementing requested modifications to existing database structures for change requests.
• Maintained Transactional Replication on production servers.
• Worked on SQL Server tools like database tuning advisor, profiler and activity monitor for performance analysis.
• Managing scheduled tasks for the servers and also automating all the maintenance activities and data flow tasks.

SYSTEMS ADMINISTRATOR

Confidential

RESPONSIBILITIES:

• Administrating MS SQL Server 2008 R2 by creating user logins with appropriate roles,dropping and locking the logins, monitoring the user accounts, creation of roles, granting privileges to users and roles.
• Responsible for General Server maintenance and Performance tuning.
• Analyzing and implementing requested modifications to existing database structures for change requests.
• Backing up master & system databases for restoring them when necessary.
• Implementation of SQL in writing stored procedures, Triggers, Views, Sql functions and locking issues.
• Experienced in production support and applications development.
• Troubleshooting the problems involved with the existing stored procedures by debugging.
• Managing scheduled tasks for the servers and also automating all the maintenance activities and data flow tasks.
• Tutor for undergraduate students with main focus on Engineering development Skills.
• Responsible for a role in providing guidance for Coding, Implementing and test validation of both software and hardware of an Embedded System Controller.
• Providing an overview of Basic C, C++ and object oriented programming which is the backbone of software industry.
• Under the guidance of professor trained many students with the introduction to MATLAB commands and codes using different Simulink.
• Provided technical support and managed Active Directory users, printers, rights and permissions for the 100 + computers available in the computer facility.
• Part of the team responsible for maintenance and installation of Software in various operating systems and equipment available.