PROFESSIONAL SUMMARY:

• Experience on different versions of SQL Server i.e. SQL Server 2000/2005/ 2008/2008 R2/2012/2014
• Developing the successful backup strategies based on recovery models.
• Recovery of database at the time of instance/database crash.
• Experience on Delphix Masking Tool, Creating and maintain different environments.
• Involving in Suspect Database & Master Database Rebuild
• Strong Experience on PL/SQL like Creation of SQL server objects as follows:
• Databases
• Windows / SQL logins
• Job scheduling and Maintenance plans
• Data Encryption on databases
• Database up gradation in development & production environments
• Performance issues
• T - SQL Query optimization
• Experience in Migrating databases from SQL Server 2000 to 2005 and 2008,2008R2,2017
• We migrate from SQL server to SQL Azure
• Monitoring database performance and optimizing performance
• Hands-on experience Mirroring, Log-Shipping, Replication and clustering
• Following the Change Management process for effectively tracking changes on the production
• Maintaining and troubleshooting Replication
• Good experiences in resolving blocking/locking and dead lock Issues
• Work as part of a team and provide 24x7 supports

TECHNICAL SKILLS:

Operating System: Windows Server 2000,2003 and 2008, Windows XP

Languages: T-SQL, PL/SQL.

SQL Server Tools: Performance Monitor, Profiler, SSIS, SSRS, SSAS.

Ticketing Tools: Remedy 7.0, Service Now, Service Desk, JIRA.

Work Force Management Tools: Natural Insight, Infor and Salesforce

Work Tools: Snare Monitoring tool, Delphix masking Tool, BI tools, Git Labs

Databases: SQL Server 2000,2005,2008,2008 R2,2012, 2014 &2017, Azure SQL Service

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, GA

SQL Server DBA/Developer

Responsibilities:

• Responsible for installation and configuration of SQL server 2017
• Knowledge and experience with the Azure Data Platform
• Troubleshoot and resolve database problems.
• Designing and supporting high availability SQL Server solutions that include Log shipping, Replication, Database Mirroring & Clustering.
• SQL Server upgrades with new service packs.
• Creating SQL account for users and assigning permissions.
• Diagnosed and resolved data corruption, locking, security, and connectivity issues.
• Apply data modelling techniques to ensure development and implementation support efforts meet integration and performance expectations
• Independently analyse, solve, and correct issues in real time, providing problem resolution end-to-end
• Developing PL/SQL packages.
• Creating Blob storage archive the databases and tables.
• Migrated SSIS packages from SQL Server 2008 R2 to SSIS 2012.
• Developing SSIS packages
• Creating SP’S and views for Reporting.
• Monitoring all server jobs daily fix failures accordingly.
• Involved in document enhancements and modifications to the existing DB infrastructure.
• Identify the missed and unused indexes. Handling the indexes.
• I organize Data refreshes decency on the request.
• Designing and supporting high availability SQL Server solutions that include Log shipping, Replication and Database Mirroring.

Environment: Windows 2008/XP, Visual Studio .Net 2010/2012, MS Access 2000, SQL Server 2008,2012 and 2017, SSIS and SSAS, Web Server, JIRA,GIT Labs, GitKraken

Confidential, Alpharetta, Georgia

SQL Server Database Administrator

Responsibilities:

• Created new databases from scratch based on the business requirement.
• Responsible for installation and configuration of SQL server 2008R2/2012/2017
• Knowledge and experience with the Azure Data Platform
• Troubleshoot and resolve database problems.
• Designing and supporting high availability SQL Server solutions that include Log shipping, Replication, Database Mirroring & Clustering.
• Creating FTP sites and acts as sysadmin.
• Creating AD account and SQL account for users and assigning permissions.
• Migrating VM’S from the Azure classic to ARM environment.
• Install and configure new SQL Servers 2012,2014 and Data tools
• Diagnosed and resolved data corruption, locking, security, and connectivity issues.
• Apply data modelling techniques to ensure development and implementation support efforts meet integration and performance expectations
• Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end
• Working as SME on masking project using Delphix.
• Developing PL/SQL packages.
• Creating Blob storage archive the databases and tables.
• Migrated SSIS packages from SQL Server 2008 R2 to SSIS 2012.
• Developing SSIS packages for Commercial programs to integrate data from/to Salesforce
• Creating SP’S and views for Reporting.
• Monitoring all server jobs daily fix failures accordingly.
• Involved in document enhancements and modifications to the existing DB infrastructure.
• Identify the missed and unused indexes. Handling the indexes.
• I organize Data refreshes decency on the request.
• Designing and supporting high availability SQL Server solutions that include Log shipping, Replication and Database Mirroring.
• Am able to work a rotating on call schedule

Environment: Windows 2008/XP, Visual Studio .Net 2010/2012, MS Access 2000, SQL Server 2008 R2/2012,2017, SSIS and SSAS, WinSCP, MS Office 2013, CoreFTP, Tubule, Delphix and Service Desk

Confidential, Auburn Hills, Michigan

Tech Lead on DBA Team

Responsibilities:

• Responsible for installation and configuration of SQL server 2008R2/2012 database on Azure Servers.
• Migrated SSIS packages from SQL Server 2008 R2 to SSIS 2012.
• Involved in the Requirements Analysis, Data gathering and Database design
• Identify data issues and Address any issues that impact the business
• Rebuilding / monitoring the indexes at regular intervals for better performance using maintenance plans.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Experience in using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor (DTA).
• Timely Database Backup (Differential, Complete, Transactional) and Recovery.
• Designing and supporting high availability SQL Server solutions that include Log shipping, Replication, Database Mirroring & Clustering.
• Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
• Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files.
• Configure Transparent Data Encryption on databases
• Developed PL/SQL Packages.
• Converting PL/SQL object collections into a result set, bulk operations and pipelined functions.
• SQL Server upgrades with new service packs and hot fixes.
• Developed SSIS Packages to automate the complex data flow processes (ETL)
• Working on incidents and change controls based on the client requirements.
• Creating users and assigning permissions
• Scheduling ETL’s as SQL Server Jobs
• Monitoring all server jobs daily, weekly and monthly basis

Environment: Windows 2000/XP, Visual Studio .Net 2008/2010, MS Access 2000, SQL Server 2008 R2/2012, SSIS and SSRS, WinSCP, MS Office 2010/2013

Confidential, Nashville, Tennessee

Database Engineer

Responsibilities:

• Created new databases from scratch based on the business requirement.
• Troubleshoot system issues, monitored, scheduled jobs and set up maintenance plans proactively monitoring the performance of SQL Server databases Responsible for database management.
• Involved in document enhancements and modifications to the existing DB infrastructure.
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Developed and optimized database structures, stored procedures, views, triggers and user-defined functions.
• Tuning T-SQL and Developed PL/SQL Packages
• Involved in performance tuning by tuning indexes and creating new indexes where necessary
• Timely Database Backup (Differential, Complete, Transactional) and Recovery.
• Configured SQL mail with Data Transformation Services (DTS)Involved in day to day administration of the SQL Servers (Backup and Restores, Scheduled jobs, Database Tuning, Query Tuning, Performance Monitoring)

Environment: Windows 2000/XP, Visual Studio .Net 2008, SQL Server 2005/2008/2008 R2, SSIS and SSRS,MS Office 2010

Confidential

Database Engineer

Responsibilities:

• Created new databases from scratch based on the business requirement.
• Managed and the migration of SQL Server 2000 databases to SQL Server 2005, developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Developed and optimized database structures, stored procedures, views, triggers and user-defined functions, coding in T-SQL.
• Troubleshoot system issues, monitored, scheduled jobs and set up maintenance plans proactively monitoring the performance of SQL Server databases Responsible for database management.
• Involved in performance tuning by tuning indexes and creating new indexes where necessary
• Timely Database Backup (Differential, Complete, Transactional) and Recovery.
• Involved in document enhancements and modifications to the existing DB infrastructure.

Environment: Windows 2000/XP, Visual Studio .Net 2008, MS Access 2000, SQL Server 2000/2005/2008

Confidential

Jr. SQL Server DBA

Responsibilities:

• Created new databases from scratch based on the business requirement.
• Managed and the migration of SQL Server 2000 databases to SQL Server 2005, developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Developed and optimized database structures, stored procedures, views, triggers and user-defined functions.
• Troubleshoot system issues, monitored, scheduled jobs and set up maintenance plans proactively monitoring the performance of SQL Server databases Responsible for database management.
• Involved in performance tuning by tuning indexes and creating new indexes where necessary
• Timely Database Backup (Differential, Complete, Transactional) and Recovery.
• Configured SQL mail with Data Transformation Services (DTS)Involved in day to day administration of the SQL Servers (Backup and Restores, Scheduled jobs, Database Tuning, Query Tuning, Performance Monitoring)
• Involved in data import and export using scripts and DTS wizard

Environment: Windows 2000/XP, Visual Studio .Net 2008, MS Access 2000, SQL Server 2000/2005/2008

Confidential

Assistant Professor

Responsibilities:

• Conducted the subject lectures regularly, keeping an eye on the understanding of the students
• Lectured graduate IT students in C, DLD, Principles of programming language, Software engineering.
• Carried out practical sessions with explanation about the purpose of the experiment and the procedures that follow to seek results
• Carried out debate sessions in regular classes to help students to understand the subject better
• Arranged expert meets for students on a periodic basis to create an interest about the subject
• Carried out an additional responsibility as the student organization's adviser for one academic year
• Encouraged students to build committees among themselves
• Provided students with information outside the classroom such as the future prospects in the subject, the competitive exams, etc.