SQL Server DBA, Azure SQL DBA, Octopus, Powershell

Chandan Kumar Mishra Mbl.No : +91-931*******

E-Mail : *************@**********.***

Over 13 years of experience in SQL Azure, SQL Database Administration, Development, Performance Tuning.

PROFESSIONAL SUMMARY

SQL Azure

Excellent knowledge and hands on experience in Migrations from on-premise to Azure IAAS and PAAS servers

Having very good knowledge on Pricing models of DTU/eDTU vs Vcore Model

Having good experice into Geo-Replication, Avialabilty Group(s) and Data Sync

Implemenetd Data Partitioning, Purging and Archiving solutions in the Azure model databases

Having very good knowledge on saving the cost on Azure models

Deploy, Configure, Maintain Compute on Azure IAAS and PAAS servers

Troubleshoot Azure related issues and engage internal teams and vendor issue resolutions

Automate deployment and troubleshoot mechanisms for quick service.

Create and configure Logical SQL servers, databases, elastic pools in Azure Cloud.

Monitor performance and setup alerts to avoid performance issues occurring on Azure databases.

Having hands on experience in Elastic Jobs and Run Books.

Having good knowledge on External tables and Elastic pool Model(s)

Having hands on experience into the Reservations and Azure hybrid benifits

Import and Export data within Azure Cloud environment.

Creating and Managing logins/Access levels in Azure IAAS and PAAS environments.

Installation

Experienced in installation MS SQL Server 2016, 2012, 2008 R2, 2008, 2005 and 2000 on stand alone and cluster servers.

Experienced in configuring windows failover clusters Active<->Active, Active<->Passive.

Expert in configuration of Microsoft Azure environment and also doing migration from data SQL machine to SQL Azure.

Upgrade and Migration

Experienced in inplace upgrade and side by side upgrade and upgrade to new hard ware.

Experinced in migration from dBASE database management system to SQL Server 2012 and SQL Azure.

Highavalability and Disaster Recovery

Implemented and supported Always On Avialbility Groups, Clustering, Database Mirroring, Logshipping, Replication.

Experienced in creating Maintenance plans and backing up databases and restoring databases.

Creating jobs and experienced in rebuilding master database and restoring Master database and user databases.

Automations:

Automated Daily DB Severs check Report on multiple servers which includes Disk Spaces, Last Boot Up information, Database sizes, Transaction log file sizes, Scheduled job running history, Any job schedule disabled, DB Backup history, Any Errors in error log or in event viewer.

Automated Instant Blocked Process Alerts.

Automated Deadlock Alerts.

Automated Low Disk Space Alerts.

Monitoring and performance Tuning

Experienced in implementing the database mail, operator and implementing the alerts

Monitor the production server using tools like SQL Profiler, Windows Performance Counters and SQL server logs for Monitoring and Tuning SQL Server.

Experienced in performance tuning by using DBCC cammands, Execution plans, system stored procedures, DMV’s and tools like DTA and SQL profiler.

SSIS,SSAS,SSRS

Working knowledge in Reporting Services (SSRS) and Integration Services(SSIS).

Stored Procedure, Functions, Views and Cursors

Excellent knowledge in creating Tables, Stored Procedure, DDL/DML Triggers, Views, User defined data types, Cursors and Indexes using T-SQL.

Experience in using T-SQL in SQL Server 2012,2008, 2005 platforms

Implemented complex business logic into database design and maintained the referential integrity via triggers and constraints.

Work Experience

Organization:- R Systems International

Designation:- Senior Technical Architect

Duration:- June 2019 – Till now

Responsibilities

Implementation of Hosting SQL services in azure IAAS and PAAS servers.

Create and configure Logical SQL servers, databases, elastic pools in Azure Cloud.

Deploy builds on multiple databases in Azure cloud.

Manually take the schema and data backups of the databases and restore/copy databases and restore deleted databases in Azure cloud.

Import and Export data within Azure Cloud environment.

Creating and Managing logins/Access levels in Azure IAAS and PAAS environments.

Migration of databases from On premise to Azure Cloud environment.

Setup maintenance plans for databases using Azure Elastic jobs and Azure automation methods.

Setup Audit and threat detection logs to ensure the security of the databases in Azure cloud and recover any in case required.

Monitor performance and setup alerts to avoid performance issues occurring on Azure databases.

Troubleshooting issues occurred with the databases in Azure cloud environment.

Suggest Cost optimization solutions in Azure PAAS environment.

Enabling and Managing data masking and encryption in Azure cloud environment

Enabling Geo replication to ensure availability of the Azure databases as DR plan.

Enabling Long time retention backup policy for Azure databases.

Creation of indexes, Partitions of the data in the Azure databases.

Monitor the health check of the SQL server and review and apply azure recommendations.

Enable and manage query store for the azure sql databases

Manage SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems.Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.Working with Devops tool OCTOPUS for developing new projects for any new implementation on mass DB servers

Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end.

Refine and automate regular processes, track issues, and document changes

Assist developers with complex query tuning and schema refinement.

Perform scheduled maintenance and support release deployment activities after hours.

Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members.

Organization:- IBM India Ltd

Designation:- Senior Technical Expert

Duration:- Nov 2014 – June 2019

Job Profile:-

Migrated SQL server 2008 to SQL Server 2012 in Microsoft Windows Server 2012 Enterprise Edition.

Worked on new features of SQL Server 2016,

Migrated SSIS packages from SQL Server 2008 R2 to SSIS 2012.

Expertise in Always-On Availability Groups (AAG) and HADR Setup and Configuration

Expert in Using DMVs, Performance dash board, Mirroring, LogShipping, Replication, database snapshots and tracking Performance Counters.

Rebuilding / Monitoring the indexes at regular intervals for better performance.

Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions.

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.

Organization:- Birlasoft India Ltd

Designation:- Senior Database Administrator

Duration:- April 2012 – Oct. 2014

Job Profile:-

This project is using technology of Database management in SQL server(2000,2005 & 2008). Involved in Database management activity. Initiating call with client, requirement gathering and preparing technical specifications.

Roles:

Extensively worked in Database Administration in SQL Server 2000/2005/2008,

Taking backups restore databases creating new databases

Creating new user ids

Giving or revoking permissions to new and existing users

Monitoring Databases

Creating, Monitoring and supporting for DR activities(Log shipping, Mirroring)

Working with Replication

Creating and Monitoring Jobs and Sql agent services and support whenever needed

Creating and Deploying SSIS packages

Running scripts on DBs

Performance tunning for user applications

Involved in debugging and troubleshooting.

Environment: Windows 2000, SQL Server, Microsoft BI Tools

Organization:- Spice Retails Ltd

Designation:- Senior Executive-IT.

Duration:- Aug 2008- April 2012.

Job Profile:- Here at SPICE I was the member of the team that designed and implemented the whole it-infrastructure. I have been responsible for creating Database Servers and Software Implementation for new stores. To manage and maintain all client side IT related activities for the store like issues related to s/w, mail, Antivirus

Key Functional Areas:

DBA Works

Involved in Performance Tuning on Production, QA and Staging servers of the current project.

Planning the location of data, index, and Transaction log files on the disk.

Performance tuning, and optimization of procedures and queries.

Worked with SQL server Profiler.

Created the backup and restore strategy for production and development environment.

Created Database Maintenance Plan for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Indexing.

Worked with Replication

Using SQL Server Integration Services (SSIS) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application.

Creating Report as per requirement of client in SSRS 2005

Managing schema objects such as tables, views, clusters, indexes, procedures, triggers & maintaining Referential Integrity depending on user requirements and converting them into technical specifications.

Administering the MS SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.

Database and Transaction log backups & restoration, backup strategies, scheduling the backups. Backing up system & user databases and restoring them.

Performing fine Tuning of Database Application. Cleansing and solving Database troubles.

Application Support And Database Maintenance

oCreating, and managing database.

oBackup and Recovery.

oSetting up Transactional Replication

oDR modal setup (Database mirroring, Log Shipping,Replication)

oSQL Sentery (Creation of JOBS and Alert)

oSpace Management for Databases.

oSQl Scripting, Creating MIS

oCreating reports in SSRS for various purpose

oData Migration from client databases to Server database (all in sql).

oSoftware Implementation.

oApplication Support and Maintenance.

oCreated SSIS Applications for database maintainance task

oHandling/Managing client-server based ERP.

oUser Training.

oHandling FTP for online Data synchronization.

Organization: -Express Retail Pvt Ltd. (Big Apple)

Designation: - IT EXECUTIVE

Duration:- May 2007-August-2008.

Job Profile

oSoftware Implementation and Up gradation at client end.

Giving support to clients of time office Software developed in D2K and Oracle 9i as Database.

oData Updation and Integration

oIT Solutions

oDatabase maintainance in ORACLE

oORACLE (9i) installation

oDatabase creation and Import

oTaking backup.

oWorking with ORACLE queries for amendments

oOther Retail related IT works like SKU, Vendor Creation, Inventory analysis etc.

oWorking on a FTP project under Co-ordination of Team Leader

oMail server support

oAntivirus support

Summary of Qualifications

M.C.A from IGNOU, NEW DELHI (2005-2008)

B.C.A from IGNOU (2002-2005).

10+2 from B.I.E.C

Matriculation from B.S.E.B.

Additional Qualification

Microsoft Certified Professional (MS SQL Server 2012)(Year 2014)

764 - Administering a Microsoft SQL Database Infrastructure (Year 2020)

Interests:

-Sports (Indoor & Outdoor)

-Cultural Events

Personal Details

Father’s Name Arun Kumar Mishra

Date of Birth 23th Nov. 1981.

Gender Male.

Martial Status Married

Strengths Ability to take full responsibility of the task assigned to me.

Zeal to learn new things fast

Contact this candidate