SUMMARY:

• Around 10 years of experience in Database Administration, Development and Design with SQL Server 2000/2005/2008/2012/2016 in logistics and Insurance sectors.
• Around 3 year of experience in NOSQL (MONGO) and MYSQL.
• Experience in supporting Development and Production environments.
• Experience in troubleshooting the performance bottle necks.
• Experience with SQL Server 2000/2005/2008/2012/2016 installation, Migration, configuration, SSIS, SSRS and administration.
• Experience with NOSQL Databases like MONGO DB installation, configuration and administration.
• Experience with MYSQL installation, configuration, Replication and administration.
• Hands on experience in high availability SQL Server solutions like SQL Server Log Shipping, Always ON and SQL Server clustering.
• Experience in Replication - Snapshot and Transactional
• Hands-on working experience with analyzing query plans, using extended Stored Procedures, managing indexes and locks, troubleshooting deadlocks.
• Hands on experience with native tools like SQL Server Profiler and Perfmon for identifying bottle necks.
• Experience in planning and implementing Microsoft SQL Server Security and database permissions
• Proficient with database backup and recovery models.
• Experience with Fog light for taking backups and monitoring performance issues.
• Experience in writing complex T-SQL (DDL, DML, and DCL).
• Implemented business logic by using TSQL, Stored procedures, triggers (DDL, DML) and functions (Inline & Multivalued Table functions.).
• Experience in using Dynamic Management views (DMV) to trouble shoot and improve server performance.
• Experience with Normalized and de-normalized database design.
• Working experience on SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS).
• Experience in automating SQL Server tasks using shell scripting and power shell.
• Hands on experience with data transformation services like SSIS, DTS, BCP and Bulk Insert from heterogeneous databases like Oracle, MS Access, and DB2.
• Extensively worked on RDBMS concepts to design Relational Database model as per Business requirement
• Extensive experience in using Version control system tools for deploying scripts in various stages of SQL Server.
• Ability to adapt quickly to changing environments.

TECHNICAL SKILLS:

Database Management Systems: Microsoft SQL Server, MySQL, MongoDB.

Programming and Scripting Languages: T-SQL, Python, XML, PowerShell, Python AND SHELL.

Monitoring Tools: SQL Profiler, Windows perfmon, Dell Foglight Performance Analysis, Microsoft,SCOM, AppDynamics, Splunk, etc;

High Availability Solutions: SQL Server AlwaysOn, Replication, Logshipping, Clustering and backup/Restore/Recovery

Operating Systems: Windows Server, CentOS, RHEL.

Reporting Tools: SSRS

Cloud Technologies: AWS and AZURE.

PROFESSIONAL EXPERIENCE:

Responsibilities:

• Worked as Database admin with responsibilities divided between development and administration.
• Worked on SQL version upgrade project from SQL 2008 version to SQL 2016.
• Worked on 2012 SSIS Environment setup and automated SSIS Package deployment.
• Working knowledge of TFS for moving database code between multiple environments.
• Experience with writing Stored procedure, Function and trigger.
• Worked extensively on SSIS Package development.
• Developed python script for migrating data from SQL Server to Kafka and it is incorporated into docker image.
• Worked on converting SQL 2008 SSIS Package to 2012 SSIS version.
• Worked with development teams on data conversion projects.
• Helped with maintaining database standards before changes goes into the production.
• Worked with developers for projects involving data staging.
• Worked with developers for optimization of SQL Stored procedures and functions.
• Installed and configured Mongo 3.2 replica set using operations manager and configured cluster.
• Installed and configured MYSQL database systems. Configured enterprise backup and failover clustering using pacemaker.
• Installed MySQL 8.0 InnoDB Cluster for new Alfresco system.
• Installed SQL Server 2012, SQL Server 2008 and configured Replication and Always on.
• Worked on setting up alerts for slow running stored procedures and dead locks using DMV’s.
• Worked on index maintenance based on fragmentation of databases.
• Experience with identifying heavy utilization queries and optimizing them.
• Experience with perfmon to capture application and system performance counters.
• Worked on automating SYNC process between production and pre-production environments.
• Worked closely with build and release teams to make DB changes goes with release cycle.
• Implemented alert system so that Backups and maintenance occurs regularly without any issues.
• Implemented security using roles and users.
• Experience with identifying errors using SQL Server error logs.
• Experience with migrating databases from lower versions to higher versions.
• Experience with SQL Server tools like Management studio, Profiler, SSIS and SSRS.
• Experience with Fog light for taking backups and monitoring performance issues.
• On call 24/7 support to database systems.

Responsibilities:

• Installed and Configured SQL Server 2000, SQL Server 2005 and SQL Server 2008.
• Worked on upgrading SQL Server 2000 to SQL Server 2005 and from SQL Server 2000 to SQL Server 2008.
• Configured Database Mail for SQL Servers for the Positive Mail Notification.
• Configured Server Memory for maximum Performance and effective utilization.
• Creating SQL Server Logins and assigning Roles and Authentication Modes as a part of Security.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies.
• Created, Scheduled and monitored SQL Server Jobs.
• Worked on setting up Transactional replication.
• Worked on issues related to running Cubes.
• Involved in Monitoring and troubleshooting replication issues.
• Configured Temp DB for to increase the performance of SQL Server.
• Experience with monitoring SQL server performance using profiler to find performance issues and deadlocks.
• Used Dynamic Management Views (DMV) for monitoring the performance of the server.
• Extensively worked on Production support and involved in trouble shooting SQL servers in various levels.
• Performed Stored Procedures optimization, Performance tuning & index tuning.
• Worked and generated reports using SQL Server 2005 Reporting Services (SSRS).
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Extensively worked on writing Stored Procedures, Triggers, Views and Functions.
• Responsible for Stored Procedures optimization, Performance tuning & index tuning.