Prasanna More

848-***-**** ad115z@r.postjobfree.com

SUMMARY:

Over 12 + years of IT Experience in Database Administration, System Analysis, Database Design, and technical support of SQL Server 2005/2008/2008 R2/2012/2014/2016/2019/2022

Extensive industry experience in Installing, configuring, and maintaining of SQL server on physical and virtual platforms.

Experience in patching, upgrading, Troubleshooting and maintenance of SQL server stand alone and clustered environments.

Involved in Disaster recovery planning, designing and implementation of high availability on multi-subnet AlwaysOn.

Troubleshooting and tweaking of any kind of windows and SQL server performance issues to achieve optimum performance based on the demanding workload.

Collaborated with users, customers, and various team members in solving day-to-day issues.

Extensive experience in migrating, monitoring and troubleshooting SQL Server 2000/2005/2008 R2/2012/2014/2019 etc..

Excellent knowledge in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) with good knowledge on SQL Server Analysis Services (SSAS).

Hands-on experience in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views,User defined data types, functions, Cursors, and Indexes using T-SQL.

Good experience in Data Conversion and Data Migration using SSIS and DTS services across different databases like Oracle, MS access and flat files.

Hands on Experience in using performance Monitoring, SQL Profiler and SQL Sentry to optimizing queries, tracing long running queries, Extended events, and deadlocks.

Creating maintenance plans to perform index defragmentation, re-indexing and updating the index statics.

Developed automated PowerShell script to monitor log drive space and TempDB space and Maintaining Database inventory Reports

Proficient in technical writing and presentations and a good team player

Good Experience in Postgres and SQL RDS and Postgres Aurora instances In AWS cloud.

Hand an experience to resolving post migration issues for system stabilization.

Ability to work independently or as part of a team to accomplish critical business objectives and to make decisions under pressure.

Closely working with Network and Cloud Team to resolve the issue for highly intensive issues without SLA breach.

Hands on experience Configure the SQL server using the CA-UIM monitoring tool,Veeam backup and replication and Networker Backup Tool.

Good experience in Capacity planning and pre migration, and post migration Task for Cloud environments in Azure and AWS.

Directs root cause analysis on complex incidents and leads the problem management discussions related to incidents.

Develops reports of overall health of the portfolio of databases, escalating substantive capacity utilization variations from forecast to management.

Configured the Always on availability group for HA in SQl server 2019 servers

Reviews and approves data modeling processes and DBMS specific requirements for basic and intermediate application database requirements

DBA experience with architecture models, database creation, backup & recovery, performance tuning, integration.

Hands-on experience in Auditing and Sox Control in the DMZ environment.

Good knowledge in Mysql installations,providing access, assigning permissions, maintaining users and resolving problems on a business -critical database issues.

Very good experience in NoSql Mongo Db.

TECHNICAL SKILLS:

Operating System

Windows server 2000/2003/2008/2012, Windows XP/Vista/7

Database

SQL Server 2000/ 2005/ 2008/ 2010/ 2012/ 2014/ 2019/ 2022 Oracle 9i/10g, Azure SQL Server.

Scripting tools

VB Script, JavaScript, PowerShell

ETL Tools

SSIS, DTS(Data Transformation Services), Biztalk

Cloud Technologies

Azure, AWS

Report Tools

SSRS, Crystal Reports, PowerBI

Database Tools

VIM tool, CI-UI M tool, SQL, SQL profiler, Db Engine Tuning Advisor, Upgrade Advisor for SQL, SQL Sentry,Veeam Backup and replication

Networker Backup tool.

Virtualizations

Terraform, Kubernetes VMware Workstation Pro, VM VirtualBox

CyberArk, Okta

Others

MSOffice,MS-DOS,BMCRemedy,Control-M,AZURE, AWS,Servicenow,Sonargi,PGAdmin Tool,ServiceNow,BMC Remedy

EDUCATION:

MCA (Master of Computer Applications) Osmania University, India 2002.

BSC (Bachelor of Science)Osmania University, India 1996.

Administering Microsoft Azure Sql Solutions Certified. 2023

PROFESSIONAL EXPERIENCE:

SQL Server DBA

Client: AIG_INSURENCE,Jerseycity,NJ Mar 2022 – Sep 2023

Responsibilities:

Involved in the capacity planning to migrate sql server from on-prem to AWS cloud.

Hands on experience to configured SQL servers in a different landscape.

Migrated on premise SQL server to AWS SQL servers 2019 and 2022.

Extensively worked on troubleshooting the performance issues

Managing database security by creating users and providing appropriate privileges using Hashi Corp Vault tool .

Worked on Database backups and Recovery procedures using the Networker Tool.

Hands on experience to configure Extended events, and query Tuning for better performance.

Good Experience in Always on Availability for 3 node and 6 node configurations in AWS cloud.

Hands on Experience using Hashicorp vault to set up the Devops Users to automate deployments.

Configured the monitoring jobs like Fragmentation report, blocking Alert and AG job failure alerts for SQl Health Checks

Troubleshooting space related issues for Data Files,Log file and TempDB.

Created proactive alerts using PowerShell scripts to monitor disk pace, index file utilization, memory utilization etc.

Hands on experience in Postgres Sql Table refresh,and Backup and restore Database.

Performance tuning postgresql in AWS cloud.

Hands on Experience create user using HashiCorp Vault for PostgresQL in AWS Cloud for automated deployment.

Good experience in schema refresh, Configure extensions, and performance issues in Postgresql

Created scripts to audit database users and privileges to integrate with the sonarji tool in AWS..

Hands on experience on Database refresh activities for Production database to QA or Development Environments.

Worked on configuring and maintaining SQL Server HA features like Log Shipping, Mirroring, and Replication.

Experience in using Performance Monitor, SQL Profiler and optimizing the queries, tracing long running queries and deadlocks.

Hands-on experience to resolve the P1 and P2 issues without SLA breach.

Closely worked with the Cloud team and network team for analyzing the SQL performance issues.

Hands on experience AWS RDS, S3, IAM, RDS Proxy.

Database Administration on PostgreSQL platforms operating within on premise & AWS installations.

Good knowledge on Unix/Linux commands and networking.

Hand on experience of monitoring tools like DataDog, New Relic, CloudWatch, etc.

Experience with Kubernetes or Docker, and/or cloud deployment technologies.

Ability to thrive in a fast-paced, high growth environment for critical Applications.

Hands on Experience In Terraform and Kubernates in Cloud environment.

Deployed in QA and Production environments for LIVE/DMZ environments using batch scripts..

Day-to-day activities like resolving the backup failures, integrity, and optimization jobs, handling suspect mode databases, analyzing error logs,

Expertise in SQl performance tuning Having good Experience handling 30Tb databases mysql and postgresql

Hand-on experience to configures Tempdb and Maxdop for heavy workloads in sql server performance tuning

Good Knowledge in Terraform.

Having Good Experience in End of Support (EOS) and End of License (EOL)

Involved in migrating and upgrading SQL server 2008R2 to 2016 as part of the EOL project.

Having good experience to create reports using PowerBI reports.

Good experience on ServiceNow ticketing tool.

SQL Server DBA

Client: Coty,INC sanford,NC Mar 2018 – Mar 2022

Responsibilities:

Upgrade different versions of SQL server instances to latest version SQL 2019,2022.

Creating and managing databases in SQL Server 2008R2/2012, 2014, 2016 & 2019,2022,

Managing database security by creating users and providing appropriate privileges.

Worked on Database backups and Recovery procedures,Performing the Full backups, differential backups, Transaction-log backups..

Worked on setting up SQL Server Jobs to monitor the disk space alerts and job failure alerts.

Created proactive alerts using PowerShell scripts to monitor disk space, index file utilization, memory utilization etc.

Created scripts to audit database users and privileges in Onprem and cloud Environment.

Managing and monitoring Azure virtual machines,Configuring and understanding Network Security Groups. And Azure virtual network connectivity.

Procedure to do the live migration of On-premise SQL servers to cloud SQL server and Cloud VM SQL server using Database migration Assistant tool.

Database Migration Service and backup methods using the storage credential keys.

Automating tasks using Azure Runbooks and using linked servers from On premise to cloud.

Automating DML operations using Azure elastic jobs on PASS SQL servers.

Involved in MS SQL Server Migrations from 2014 to 2019

Experience in using Performance Monitor, SQL Profiler and optimizing the queries, tracing long running queries and deadlocks.

Deployed SSIS packages in QA and Production environments and created scheduling jobs to run Packages.

Day-to-day activities like resolving the backup failures, integrity and optimization jobs, handling suspect mode databases, analyzing error logs,

Scheduling and running jobs in production server for backup of databases and timely recovery when required.

Having good experience in Failover and Failback for multimode server environments in AWS cloud.

Working with End users for Fixing the issues in Failover clustering in a multimode environment in AWS cloud

Having good experience to create reports using PowerBI reports.

Used ServiceNow to support daily issues.

Involved in 24/7 support and On-Call responsibilities for Production Servers.

Worked on onsite –offshore coordination.

Hands on experience HA-DR sync wait-stats for sql server performance tuning in High availability Always on Serves.

Worked VEEAM backup and Replication tool, CI-UIM tool to monitor the SQL server.

SQL Server DBA

Interpublic Group,

New York, NY Nov 2015 – Mar 2018

Inter public is a leading provider of Media and Advertising services around the world. The aim of the project was to design and develop Enterprise Data warehouse and migrate the data from different sources into the databases using SSIS and generating various simple and dynamic reports using SSRS.

Responsibilities:

Installation and configuration of SQL server 2008R2, 2012 2014 and 2016 in different landscape.

Applying latest service packs for vulnerability checks.

Creating and Managing Database for SQL Server 2008R2/2012, 2014 and 2016

Managing Database security by creating Logins, Users and by Granting appropriate privileges.

Working with users to recommend the query tuning techniques for performance.

Hands on experience in SQL Server Jobs to monitor the Disk space and AG failover alerts.

Worked on configuring and maintaining SQL Server HA like features like Log Shipping, Mirroring, and Replication.

Monitoring Log Shipping related Jobs such as Backup, Copy, and Restore Jobs.

Involved in MS SQL Server Migrations from on prem to cloud for different SQL Versions.

Experience in using Performance Monitor, SQL Profiler and optimizing the queries, tracing long running queries and deadlocks.

Deployed SSIS packages in QA and Production environments and created scheduling jobs to run Packages.

Day-to-day activities like resolving the backup failures, integrity, and optimization jobs, handling suspect mode databases, analyzing error logs,

Scheduling and running jobs in production server for backup of databases and timely recovery when required.

Hands on experience in sql server performance tuning using column level index.

Involved in 24/7 support and On-Call responsibilities for Production Servers.

SQL Database Administrator

RR Donnelly, NJ Feb 2013 - Nov 2015

Responsibilities

Worked on replication, mirroring, setup SQL cluster environments and support day-to-day activities.

Optimized database authentication and optimized user access rights. Identified users having SYSADMIN rights and relegated them to the appropriate rights.

Planned and coordinated, phased implementation of security patches with the application team to minimize downtime to end users.

Installation and configuration of MS SQL Server 2008, SQL server 2008 R2, SQL server 2010

Migrating databases from SQL Server 2000 to 2005 and SQL Server 2005 to 2008.

Resolving Remedy Tickets, which include creating and maintaining databases, monitoring Disk Space, database integrity, identifying missing Indexes, handling deadlocks etc.

Implemented Database Mirroring with High Availability Mode in SQL 2008

Maintained & Monitored Alert/Schedule to make a smooth replication process.

Ensure and maintain sound backup and recovery policies and procedures.

Database performance monitoring and tuning when required as per application and business requirements.

Involved resolving blocking processes related issues.

Involved Executing scripts in production environment and QA environments.

Performing data refresh activities from production to Dev/Test as needed,

Involved in Database Performance tuning, Creating, and reviewing Security features for all the servers.

Configuring and monitoring the Database Mirroring and Log Shipping.

Involved in troubleshooting Query blocking, database space issues, Ensuring Data consistency in the database through DBCC commands.

Worked closely with the Development team and Support team and provided solutions for current and future projects.

SQL Developer/DBA

Gemstar TV Guide, Radnor, PA May 2011 - Dec 2013

Gemstar TV Guide relays program schedules for television program listings and also publishes a bi-weekly magazine as well as television-related news, celebrity interviews and gossip, film reviews, crossword puzzles and in some issues, horoscopes.

Responsibilities

Involved in installation and maintenance of multiple SQL Server 2008R2 instances in a clustered environment.

Created and maintained user and user roles across the landscape.

Setup Database backup and transaction log Backups, Restore database whenever necessary.

Created and maintained scheduled jobs.

Monitor the disk space utilization and perform necessary steps to keep a healthy environment.

Create both logical and physical data models of all databases.

Develop disaster recovery plans.

SSIS Packaging using ETL

Developed new SSIS packages for data import from multiple sources.

Created test plans for approval.

Deployed SSIS Packages and scheduled to run using Control- M.

SQL Server 2008R2 - SSRS

●Installed and configured Microsoft reporting server.

●Deployed several reports and configured as required.

Contact this candidate