SUMMARY:

• 9+ years of experience as Database Administrator and Developer for very large and complex databases in SQL Server 2016, 2014, 2012, 2008 R2, 2008 and 2005 with Banking, Healthcare, Financial, Insurance and Retail Management Domains.
• Analysis, Design, Development, Testing, Maintenance, Capacity Planning and Performance Support of application systems of OLTP and OLAP databases in the client - server, internet\Intranet environments.
• Expertise experience in configuring Always-On High Availability concept with Availability Groups in SQL 2012/2014 with combination of Synchronous & Asynchronous Mirroring and HA/DR Troubleshooting .
• Installing, Upgrading and Migrating databases in and from SQL Server2016\2014\2012\2008R2\ 2008.
• Migrated DB2 and Oracle databases to Microsoft SQL server 2016 using SSMA.
• Knowledge of new features: Data Compression, Transparent Data Encryption (TDE), Resource Governor, Policy Based Management, Backup Compression and Change data capture.
• Disaster Recovery planning by configuring Clustering (Active-Active and Active-Passive), Log-shipping, Mirroring.
• Configuring Replication and troubleshooting the issues with snapshot, transactional, Merge Replication.
• T-SQL Programming; query optimization and performance tuning; using SQL Profiler, Execution Plan, Performance Monitoring and DBCC Commands.
• Experience using DDL and DML queries and use of Store procedures, Triggers and Constraints.
• Detecting and Resolving Locks, Deadlocks using Trace Flags and Native tools like Profiler and the Activity Monitor.
• Maintaining the Service Level Agreements (SLA’s) according to the client’s requirement.
• Creating and debugging Views, Functions, Indexes, Cursors, Store Procedures, Triggers, optimizing code and improving efficiency.
• Hands on experience in Batch Processes, Import, Export, Backup, BCP, DTS and SSIS (including data loading).
• Acted as DBA for Redshift Cluster and RDS DB engine such as SQL Server and MySQL.
• Developed and deployed reports using SQL Server Reporting Services (SSRS).
• Good knowledge in windows server and active directory configuration.
• Supporting and configuring SQL Server Analysis Services (SSAS).
• Knowledge about in Dimensional Data Modeling Star and Snow Flake Schemas.
• Experience in performing security access Gap Analysis.
• Expertise in SQL Server Storage Structures and Security Architecture for databases residing on SAN storage on distributed systems
• Data Modeling Experience including Physical and Logical data modeling using Erwin tool.
• Migration of on-premises applications/databases into AWS.
• Extensive experience in using AWS services EC2, RDS.
• Engaged in AWS Cloud services architecture, design, engineering & operations.
• Experience of migrating on-premises databases into Azure.
• Setting up connections strings and connecting SQL Server Azure databases from locally installed SQL Server Management Studio for developers.
• Proactive worker, excellent analytical, desire to excel, fast learner, hardworking and versatile team player.
• Worked in 24x7 production environment and provided On-Call and day-to-day support.

TECHNICAL SKILLS:

Databases: MS-SQL Server 2005/2008/2008 R 2 /2012/2014/2016

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

Operating system: Windows 2012/2008/2003/2000/ Professional

OLAP Tools: SQL Server Analysis Server 2008, 2005, SSIS (as ETL)

Monitoring Tools: Profiler, SolarWinds, Red Gate, Idera, Fog light, Quest Lite Speed, Zabbix

Tools: PowerBI, Splunk

PROFESSIONAL EXPERIENCE:

Confidential, NY

SQL Server DBA

Responsibilities:

• Installed, managed and administrated the MS SQL Server 2016/2014/2012/2008 R2 Production and Non-Production Servers.
• Migrated MySQL, DB2 databases to Microsoft SQL server 2016 using SSMA.
• Managed and troubleshooted MySQL databases issues in Production Environment.
• Worked on Security Audit Logins, had deployed Audit on Development, QA, UAT, Prod environments.
• Suggested Disk Capacity, Processors and Memory based on the Capacity planning.
• Migration of SQL Server 2008R2 in place as well as side by side to MS SQL Server 2014.
• Configured and worked on Always-On High Availability concept with Availability Groups in SQL 2012/2014 with combination of Synchronous and Asynchronous Mirroring.
• Configured and Monitored Database Mirroring/Log shipping/Transactional Replication and troubleshooting of errors.
• Implemented Database Mirroring and Transactional Replication as a part of DR plan.
• Worked as DBA in AWS Cloud for Redshift Cluster and RDS DB engine such as MS SQL Server.
• Providing successful path towards Redshift Cluster and RDS DB engines.
• Created SQL Server logins on each SQL Server instance for the AD group.
• Experience in Maintaining SQL Server Security including the creation of logins and users, configuring permissions and assigning roles to users as required.
• Detected and Resolved Locks and Deadlocks using the Trace Flags and Native tools like Profiler and the Activity Monitor.
• Good knowledge in windows server and active directory configuration.
• Used SSIS to populate data from various data sources and in the creation of packages for different data loading operations for applications and to export data from other sources to SQL databases.
• Used SSRS to create reports that draw content from a variety of data sources.
• Created and maintained Crystal reports using SSRS.
• Implementation of SQL Logins, roles and Authentication Modes as a part of Security Policies for various categories of user.
• Expertise in Performance tuning, Optimization, Data integrity and Statistics by using SQL Profiler, PerfMon and DB Engine Tuning Advisor.
• Normalizing OLTP Environment with ERWIN tool.
• De-Normalizing and designing star schema or snow flake design for OLAP Environment.
• Performing ETL work from OLTP to OLAP environments.
• Performing analytical operations in OLAP Environment (SSAS).
• Worked with PowerShell scripts to monitor Disk usage and SQL Server databases and sends report to DBA team and many more automated DBA tasks using PowerShell.
• Extensive experience in Migration of on-premises databases into AWS environment.
• Worked on installation/configuration of AWS services like RDS, EC2.
• Engaged in AWS Cloud services architecture, design, engineering & operations.

Confidential, Minneapolis

SQL Server

Responsibilities:

• Installation and configuration of SQL Server 2012 and 2014 on VMWare and cloud environments.
• Migrated Databases from SQL Server 2008/2008 R2 to SQL Server 2012/2014 in Production and test Environments.
• Setup Always-on Availability on SQL Server 2012 and 2014 with multiple replicas synchronously and asynchronously.
• Worked on high availability SQL Server solutions, including SQL Server clustering, Log shipping and Transactional replication.
• Creating databases and logins and users with permissions in SQL server 2008 R 2/2012/2014.
• Implemented Backups, Re-index, DB Shrink and other database maintenance jobs using SQL Server Jobs.
• Experience in about the process and environment.
• Created SQL Server logins on each SQL Server instance for the AD group and monitor group membership as well as permissions on the instance.
• Monitored Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Experience in performing security access Gap Analysis.
• Creating and managing schema objects such as Tables, Views, Indexes and referential integrity and converting them into technical specifications.
• Backup and Recovery of Production Databases and Tuning them for better Performance.
• Creating and Modifying Tables, T-SQL Stored Procedures, Views, Indexes, User-defined Functions, and Triggers as required.
• Raising the change management request and following up with the customer approval, for making any changes in the production server.
• Worked with Transparent Data Encryption (TDE), table compression, database compression and merge statements using SQL server 2012.
• Perform backups using Redgate tool, also worked on Redgate SQL data compare and SQL Compare .
• Performed Backup and recovery & Automation of Backups using maintenance plans, created the alerts with Database Mail SMTP.
• Performed regular Administration activities from managing system resources, users and database to the fine-tuning level.
• Configuring and Troubleshooting Service Broker Objects in Service Broker for Stored Procedures
• Worked on different versions of MySQL like 5.6 and 5.7.
• Managed MySQL databases in Production, QA and development environments.
• Supported different Oracle Environments like Production, Development and Staging.
• Creating Linked Servers between SQL Servers and to Oracle databases.
• Used SSIS to populate data from various data sources, creating packages for different data loading operations for application, and to export data from other sources to SQL databases
• Migrated database from On-Premises to Azure cloud.

Confidential,

Jr SQL Server DBA

Responsibilities:

• Installations and configurations of SQL Server 2008/2008 R2/ 2012 both enterprise edition and standard edition.
• Upgraded from SQL Server 2008/2008 R2 to SQL server 2012 on Various Production Servers.
• Setup clustering both Active/Active and Active/passive on 2008/2008 R2 servers.
• Setting up and Monitored transactional replication, Database mirroring on Production and QA servers.
• Implemented Database Mirroring and Transactional Replication as a part of DR plan.
• Configured Database alert scripts like database size increase, log size full, maintenance script for all SQL Server versions.
• Created new database objects like Tables, Procedures, Functions, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2005.
• Worked with table partitioning (SQL Server 2008) mechanism to allow the SQL Server engine to escalate locks to the partition level before the table level.
• Worked with Transparent Encryption, table compression, database compression and merge statements using SQL server 2008.
• Created Power shell script to run update statistics on objects parallel on large databases to minimize the run time.
• Tuning queries which are running slow using Profiler and Statistics Io by using different Methods in terms of evaluating joins, indexes, updating Statistics and code modifications.
• Created complex stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL.
• Working with third party tools SolarWinds for performance monitoring.
• Experience with SCOM to monitor and manage critical database servers from a centralized location.
• Expert in Performance Tuning of the Stored Procedures.
• Checking Database Health by using DBCC Commands and DMV’s.
• Monitored and modified Performance using execution plans and Index tuning.
• Developed complex canned reports using SQL Server 2012/2008 Reporting Services (SSRS).
• Created and maintained data flow diagrams for existing and future ETL processes.
• Created and maintained detailed source-to-target ETL mapping specifications.
• Daily routine DBA tasks like handling user’s permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.
• Responsible for database security of the operational and developmental application system databases.
• Managed MS SQL server (storage, memory, processing) and their dependencies/performance bottlenecks.
• Extract Transform Load (ETL) development using SQL Server Integration Services (SSIS).
• Reduced systems downtime risk through automatic offsite backup and recovery over network.

Confidential,

SQL Server Developer

Responsibilities:

• Involved in various stages of SDLC like Design (Logical & Physical), Development, Implementation and Testing.
• Collaborate on configuration of servers to support a variety of business applications, data warehouse infrastructure, database platforms, open source, custom developed and web applications.
• Monitoring the server for High availability of the servers solving the raised by user support.
• Configuring and Troubleshooting Service Objects in Service Broker for moving the Message queue in Database and Instance Level.
• Working with third party tools Quest Lite Speed for log shipping and Fog light and Idera for performance monitoring.
• Performed application program enhancements, troubleshooting and bug fixes as required.
• Management of users including creation/alteration, grant of system/dBs roles and permissions on various database objects.
• Deployed the SSRS reports in Microsoft share point portal server.
• Transformed data from various data sources using OLE DB connection by creating various SSIS packages.
• Implementation of Backup, Re-index, DB Shrink and other database maintenance jobs through Stored Procedures.
• Performed query tuning & optimization using Query Plans & SQL Profiler.
• Implementing different Development and Test Server instances for the Application Development Team and to co-ordinate Development and Testing Environments and keep them updated.
• Creation and maintenance of databases, creating roles and managing user permissions.
• Maintained Service Level Agreements (SLA’s).
• Wrote stored procedures to get the fields required for the reports.
• Created datasets using stored procedures and reports using multi value parameters.
• Created sub reports, bar charts and matrix reports.