RAMU MIRIAMPALLI

Mobile: +1-857-***-****

Email:adg602@r.postjobfree.com.

PROFESSIONAL SUMMARY:

11+Years of IT experience in SQL Server Administration, Development and Database Design using MS SQL Server 2019/2017/2016/2014/2012/2008R2/2008/2005/2000 in both on-premise and azure environments.

Expertise in Database Administration on Production Servers with Installing,Patching,Upgrading, configuration, performance tuning, Migrating SQL Server and maintenance with outstanding troubleshooting capabilities.

Hands on experience with High Availability &Disaster Recovery Solutions – Log Shipping, Mirroring (High safety and High performance), Replication (Snapshot & Transactional) and Clustering (Active-Passive and Active - Active).

Excellent skills in database Back Up, Restore, Recovery, Updating statistics, Rebuilding and Reorganizing Indexes, Defragging Tables, Replication, Linked Servers, and Database Maintenance Plans.

Configuring Database Mirroring between two partners in any of the three modes (High Availability, High Safety and High Performance) and ensuring the synchronization between partners.

Configuring HADR (Always-ON) in SQL Server 2016/2017 and configuring Listeners to HADR.

Adding and Joining New Availability Databases to existing HADR Availability Group.

Experience in implementing Business logic by using T-SQL (DDL, DML), stored procedures, triggers and user defined functions (UDF),scripts, batch files, T-SQL, BASH, PowerShell scripting.

Experience in performing database regular Backups (Full/Differential/Transaction Log Backups into Disk and striping for large Databases) and Restoring on requirement.

Experience in automation of administrative tasks like creating Maintenance plans, creating Jobs, Alerts using SQL Server agent and monitoring and troubleshooting the jobs.

Extensive experience in Installation, Configuration and Administration for SQL Server in a Clustered and Non-Clustered environments.

Experience in Performance Tuning and Query Optimization by using tools like SQL Profiler.

Experience in architecting, designing and administrating in multi node clusters with Active/Active, Active/Passive

Experience in Configuring, Implementing and Maintaining Database mirroring synchronous and Asynchronous.

Experience in implementing Replication using different Replication Models (Snapshot, Merge and Transactional) with different topologies.

Managed stored procedures, jobs, and utilize Server Side tracing to identify performance issues with deadlocks & other locking issues.

Maintained User Permissions, Logins, and Security Issues. Monitored Event Viewer, SQL Error Logs, and Log Files for S/W and H/W errors.

Knowledge in using DMVs and DMFs in finding and solving Performance Issues.

Hands on experience in Planning & Scheduling Maintenance Tasks, Scheduling Jobs, and Alerts using SQL Mail.

Expert in Creating & Debugging Views, Functions, Stored Procedures, Triggers, Optimizing Code, and improving Efficiency.

Experience in Maintenance Index Tuning, Rebuild & Reorganizing according to Index Fragmentation, running DBCC Checks and, Update Statistics to check Data Integrity.

Hands on experience in Batch Processes, Import, Export, Backup, BCP, DTS and SSIS.

Experience in Installation, configuration, monitoring and managing OLAP Database Warehouses using Analysis Services (SSAS), Integration Services (SSIS), and Reporting Services (SSRS).

Experience in Migration of Data from Excel, Flat file, Oracle to MS SQL Server by using SSIS, BCP and DTS utility.

Experience in Data Extraction, Transforming and Loading (ETL) using For Each Loop in SQL Server Integration Services.

Performing the Cluster installation and adding the nodes in the respective servers

Performing the Failover and Failback operations in the cluster environment and adding the new Disks and troubleshooting activities.

Configuring Log shipping between two servers and troubleshooting at the time of synchronization issues. Performing role swapping and failover depending on the situation.

AZURE EXPERINCE:

Creation of Virtual Machines, Storage account creations, Virtual Networks and Deploying SQL Server and

configuration of Always On (Azure IaaS).

Created Blob Storages in the Azure environment to store backup files and copied files from Azure Blob to local using Azure CLI.

Good knowledge on configuring VM scale sets and load balancers

Created SQL Server Databases in Azure PaaS like Single Database, Elastic pools and Managed Instances

Migrated Databases from On-Premise to Azure using tools like DMA, DMS, BACPAC and Export/Import.

Configured Geo Replication for Azure SQL server Databases

Good knowledge of DTU, eDTUs and DTU calculator

Good knowledge on networking concepts like Vnet creations, subnets, Vnet Peering, P-S, S-S and Express route.

Good knowledge on Azure migration service like Azure Migrate, Recovery site vault and DMS

Good knowledge about SQL server general purpose and Business critical licenses.

Created SQL Server Databases in Azure PaaS like Single Database, Elastic pools and Managed Instances.

Backup Azure SQL DBs in Azure and Automation of SQL DB backups

Good knowledge with Data Lake, Data factory, Data spikes.

Education:

Master of computer applications (M.C.A) from JNTUniversity Hyderabad, India 2004 - 2007

Bachelor of Computer science (B.Sc. (comp) from AN University, Guntur, India. 2001 - 2004

Technical Skills:

Operating Systems:

Windows Vista/XP/2000/NT, Windows Server 2003, 2005 Exchange 2003, Linux, Unix.

Databases:

MSSQLServer 2019/2017/2016/2014/20012/2008R2/2008/2005/2000, MYSQL, Oracle11g/12c. MS Office Access 97/2000/2003. Azure and AWS Cloud basics

Microsoft Business Intelligence Tools:

SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS)

Database Tools:

SQL profiler, SQL Query Analyzer, Index Analyzer, SQL Server Management Studio.

Third Party Tools:

Erwin, Red gate (SQL Compare and SQL Data Compare), Lite speed, Fog lite, SSAM (System Status Alarm Monitor), RS Scripter, DB Artisan

Languages:

T-SQL, SQL, PL&SQL, power shell

Applications:

Microsoft Office Suite, Acrobat Reader/Writer.

Azure Services/Tools

SQL Server on IaaS and PaaS, Storage explorer, Azure Data Studio, Azure CLI, Azure Portal, Storage accounts, vNet, Subnets, NSG, Azure AD, SQL Database, Elastic pools, Managed instance, DMA, DMS, bacpac

Professional Experience:

Project 1: Acadian Assessment LLC, Boston MA May 2019 – June2020

Sr SQL DBA consultant

Responsibilities:

Involved in Planning for Upgrades and migration of major applications from SQL Server and MySQL 2014 to SQL Server 2017 and from SQL Server 2014 to 2017. Maintained and Supported large DB’s around 15 TB for each DB.

Designed, implemented and maintained the SQL Always ON for the 2017/2014 versions and Implemented.

Worked on Data Extraction, Transformation and Loading from different data sources using ETL tool like SSIS as per client requirements. Creating the ispac files and deploying the SSIS projects and creating the configurations for the projects and run those projects through SQL agent jobs. Use Autosys tool to run the batch jobs. Monitor and troubleshoot ETL, BCP,SSIS and application jobs and other tools.

Install SQL clusters in Active/Active and Active/Passive Topology. Remote monitoring of SQL server 2012, 2014 and 2017.

Configuring HADR (Always-ON) in SQL Server 2016/2017 and configuring Listeners to HADR.

Adding and Joining New Availability Databases to existing HADR Availability Group.

Knowledge with ITIL Process involved Incident Management, Problem Management and Change Management.

Creation of Virtual Machines, Storage account creations, Virtual Networks and Deploying SQL Server and configuration of Always On (Azure IaaS).

Created Blob Storages in the Azure environment to store backup files and copied files from Azure Blob to local using Azure CLI and Power shell

Good experience in deploying azure resources using ARM templates

Good experience in using tools like Azure portal, Storage explorer, Azure Data studio and CLI

Performed SQL server on premise database backups to Azure Blob storage using power shell

Good knowledge on configuring VM scale sets and load balancers

Created SQL Server Databases in Azure PaaS like Single Database, Elastic pools and Managed Instances

Migrated Databases from On-Premise to Azure using tools like DMA, DMS, BACPAC and Export/Import

24*7 production Database On Call support. Providing support for the clustered and Non-Clustered SQL Server 2014/2012 instances in Production, Development and UAT environments.

Planning the backup strategies, Maintenance plans using Native & Third-party tools (Lite Speed SQL Backup) and automated Backup and restore through Lite Speed SQL and shell scripting.

Encrypt SQL data bases by using Microsoft Transparent Data Encryption (TDE). Experience with analytics platforms and other business intelligence tools((Tableau, Power BI).

Actively worked on performance tuning by analyzing the Windows, SQL, Memory and Query optimization by using the Spot light, Fog light Tools and T-SQL debugging and actively worked on capacity planning, submitted the best plans to customer for successful implementation.

Improved query performance by analyzing the stats, Query Execution Plans, system performance by system Performance Analysis, and used 3rd party tools(Spot Light and Fog light) for performing root cause analysis.

Configured the Cluster as part of all AO configurations and applied the monthly patches and service packs to achieve the security and performance metrics.

Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented and Technical Analysis, Code Review, Implementation, and production support

Developed Power Shell scripts in place of TSQL batch script for daily maintenance activities to improve performance and scheduled scripts in central management server.

Environment: MS SQL Server 2000/2005/2008/2008R2/2012/2014/2017 64 Bit, Enterprise, Windows server 2003/2008 64 bit, SSIS, SSRS, Performance Monitor, IIS.

Project 2: Santander Bank, Boston MA Jan 2019 – May 2019

Sr SQL DBA consultant

Responsibilities:

Extensive experience in SQL Server Performance tuning and performing root cause analysis.

Monitoring SQL server performance using profiler for identifying performance issues and deadlocks.

Create and Maintaining Database Maintenance Tasks, including Database Consistency Check, Re-Index Update Statistics and Backups.

Managing around 210 servers and 3800 databases and supporting max size of 1.5 TB

Applying SQL Server patches and hot fixes to stand alone and cluster servers.

Analyzing and Modifying Stored Procedures to improve execution process.

Using Sentry one tool o monitory disk performance dead locks and disk performance

Configured Database Maintenance Plans for Backups, Re-indexing, and Reorganization of Indexes, Cleanup History, and Update Statistics.

Performing the Cluster installation and adding the nodes in the respective servers

Performing the Failover and Failback operations in the cluster environment and adding the new Disks and troubleshooting activities.

Configuring Log shipping between two servers and troubleshooting at the time of synchronization issues. Performing role swapping and failover depending on the situation.

Configuring Database Mirroring between two partners in any of the three modes (High Availability, High Safety and High Performance) and ensuring the synchronization between partners.

Designed and developed SSIS packages using different control flow tasks, Transformations and dataflow tasks.

Good experience With Windows Azure Cloud Administration which includes services like: EC2, S3, EBS, VPC, ELB, AMI, SNS, RDS, IAM, Route53, Autoscaling, Cloud Front, Cloud Watch, Cloud Trail, Cloud Formation, LAMBDA,OPS Work, Security Groups.

Setup Database Security and maintain accounts and access levels by creating suitable Logins and Roles and assigning object level permissions.

Managed Disk space, Memory, and User Connections.

Scheduled and monitored maintenance activities including database consistency checks and index fragmentation.

Environment:MS SQL Server 2000/2005/2008/2008R2/2012/201464 bit, Enterprise, Windows server `2003/2008 64 bit, SSIS, SSRS, Performance Monitor, IIS.

Project 3: Wells Fargo, Charlotte, NC. July 2018 – Jan 2019

Sr SQL DBA consultant

Responsibilities:

Experience on installing, configuring, Managing and Monitoring of all SQL server with Service packs, Cumulative updates and hot fixes. Involved in Physical and Logical design and Schemas for databases of new application.

Tuning of SQL Server Memory structures and troubleshooting the existing issues with Buffer Pool and Paging.

Checking the Server roles and health during failover in clustering and mirroring and implementing the SQL server 2012 transaction replication and working on the alerts/issues

Migrated the SQL Servers from on premise to Microsoft azure (IaaS) and Amazon cloud (AWS) environment for the business-critical applications and working on the all alerts with in minimal time.

Enabled the Server and DB level audit to all the critical production DB’s for tracking all the DML and DDL changes.

Extensive experience in SQL Server Performance tuning and performing root cause analysis.

Experience in PAL (using power shell script)

Highly experience in creating performance dash board reports.

Migrated on premises SQL databases to Azure SQL Cloud.

Providing support for the Clustered and Non-Clustered SQL Server 2014/2012/2008/R2instances in Production, Development and UAT environments.

Configuring and managing transactional replication.

Highly experienced in Always-On Availability Group as a High Availability solution on SQL Server 2016/2014/2012.

Monitor and troubleshoot ETL,BCP, SSIS and Application Jobs and other tools

Installed SQL Server Clusters in Active\Active and Active/Passive Topology.

Remote Monitoring of SQL Server 2008r2, 2012, 2014 and 2016.

Monitor Microsoft SQL Server activity on a proactive basis and tune the system for optimal performance

Performed Physical and Logical Data Modeling for databases of varied sizes including VLDBs. F

24 X 7 Production Database On Call Support.

Troubleshoot Blocking and Deadlocking issues by making appropriate changes to Transaction Isolation levels and the types of locks being held; avoiding keeping transactions open for long durations, breaking large transactions to smaller ones.

Upgraded the existing Servers from SQL Server 2008 to SQL 2014 and 2016.

Environment:MS SQL Server 2000/2005/2008/2008R2/201464 bit, Enterprise, Windows server `2003/2008 64 bit, SSIS, SSRS, Performance Monitor, IIS.

Project 4:Citi Group, Tampa, Florida. Aug 2016 – July 2018

Senior SQL Server DBA

Responsibilities:

Managed and Administered SQL Server 2014/2012/2008R2 Production and Non-production Servers.

Migrated SQL Server 2005 databases into SQL Server 2008R2 databases by In-place upgrade process and also used upgrade advisor tool in up gradation.

Used SQL Profiler for troubleshooting, monitoring, and optimizing T-SQL code from developers.

Analyzed long running slow queries and tune the same to optimize application and system performance.

Implemented Database Mirroring and Log Shipping as part of DR plans.

Implemented and maintained Replication (Transactional, Snapshot) using Dynamic Scripts.

Maintained Database Consistency with DBCC at regular intervals.

Setup, deployment and configuration of Microsoft System Centre Operations Manager (SCOM) 2007 R2 multiple Server Scenario with Microsoft SQL 2008 Reporting Services in Windows Server 2008 Hyper-V Cluster environment.

Scheduled weekly jobs and Maintenance tasks for better performance and created alerts with Database Mail SMTP.

Configured Database Maintenance Plans for Backups, Re-indexing, and Reorganization of Indexes, Cleanup History, and Update Statistics.

Designed and developed SSIS packages using different control flow tasks, Transformations and dataflow tasks.

Setup Database Security and maintain accounts and access levels by creating suitable Logins and Roles and assigning object level permissions.

Managed Disk space, Memory, and User Connections.

Scheduled and monitored maintenance activities including database consistency checks and index fragmentation.

Environment:MS SQL Server 2000/2005/2008/2008R2 64 bit, Enterprise, Windows server `2003/2008 64 bit, SSIS, SSRS, Performance Monitor, IIS.

Project 5: Ericsson Global Services, Bangalore, India. Oct 2012 – Nov 2015

Sql DBA Consultant

Responsibilities:

Install, Manage and administer SQL server 2005\2008R2\2012\2014 SQL servers

Migrations of SQL server from one version of SQL server to another

Implemented new SQL Server 2012 technique ALWAYS-ON High Availability groups

Building SQL 2008R2 cluster environments on VMware/ Physical environments

Adding nodes to already existing clustered servers as a part of data load\High availability Configured Transactional Replication and Log Shipping

Usage of new compression Techniques in SQL Server 2008(R2) for backup and restore jobs

Implementation of SQL server logins, Roles and Authentication modes as a part of security policies.

Creating and scheduling maintenance plans for updating statistics, checking fragmentation, checking database integrity and backup plans

Configured Database mail, linked servers,Transparent Data Encryption (TDE) and Auditing

Performance tuning of databases by windows performance monitor and SQL Profiler

Used Index tuning wizard to redesign and created the indexes for better performance

Conducted various meetings and conferences with application teams to meet corporate milestones for database consolidation and data migration

Responsible for numerous Change Management requests on production servers

Configured Transactional replication on migrated server

Involved in Data Compression, Hot add CPU, Fact Table size reduction and improved performance using SQL Server 2008

Environment: Microsoft Windows Server 2008/2003 MS SQL Server 2008R2/2008/2005/200/7.0, T-SQL, SQL Query Analyzer, SQL Server Profiler,.NET, Lite Speed, VSS, SSIS 2008R2/2005/2008/2012

Project 6: Johnson& Johnson, Inc., Bangalore, India Nov 2009 – Sept 2012

SQL DBA Consultant

Responsibilities:

Highly worked on Administration, Database Design and Performance Analysis on very large and highly transactional production databases.

Performed installation of SQL Enterprise 2005 32bit version on Windows 2003 servers on Enterprise systems of clustered and standalone HP servers in enterprise Data Centers.

Implemented the disaster recovery models like Clustering, Database Mirroring & Log shipping.

Monitored Log shipping/ Transactional Replication for trouble shooting of errors.

Created Logins at Server level and Users at Database level and mapped Roles by assigning permissions.

Used Performance monitor and SQL Profiler to optimize queries and enhanced the performance of database servers.

Extensively worked on IMS performance issues like update statistics, rebuilding the indexes at regular intervals for better performance.

Successfully implemented the Capacity planning for different servers.

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

Routine DBA jobs like monitoring the data loading jobs, Backups (Full, Differential &Transactional), disk space, database status, handling the maintenance jobs and checking the error logs.

Expert in using and implementing DMV’s, DMF’s, data partitioning and Indexing.

Scheduled and monitored all maintenance activities including database consistency check, index defragmentation, update statistics and backups.

Applied hot fixes, Patches and Service Packs and create script for Unattended Installation.

Implemented and maintained database security, policies and procedures

Transferred data (ETL) to Data warehouse Environment using SQL Server Integration Services.

Performed all basic Database activities like moving databases between servers, copy databases etc…

Performed code reviews to ensure high Software quality and participated in weekly team meetings.

Provided 24/7 Support for Production, Development & Test Servers of MS SQL Servers

Environment: Microsoft Windows Server 2008/2003 MS SQL Server 2005/200/7.0, T-SQL, SQL Query Analyzer, SQL Server Profiler,.NET, Lite Speed, VSS, SSIS 2008R2/2005/2008

Project 7: HSBC Bank, Hyderabad. Oct 2007 – Nov 2009

Jr. SQL Server DBA

Responsibilities:

Tuned aggressively stored procedures in order increase the performance with no cost effective.

Index tuning for almost 46 databases associated with production and non-production databases.

Worked with SQL Server 2005 side by side upgrade from SQL server 2000.

Installed couple of SQL Server 2005 on cluster environment.

Configured the new servers using failover clustering and SAN technology.

Integrated SQL server profiler traces with Performance monitor to have better graphical analysis to find system bottlenecks.

Expertise in setting up and troubleshooting Database mirroring.

Worked on log shipping for synchronization of database.

Expertise in working with Transactional Replication Environment and handled the publication conflicts manually depending on last changed date.

Expert in Using DMV’s, Performance dash board, Mirroring, database snapshot.

Checked the configuration and performance of the existing databases including data file allocation, index fill factor, fragmentation and the impact on system performance. Analyzed potential problems (response delay, locking, server down time, etc) to avoid and optimize.

Rebuilding the indexes at regular intervals for better performance based on level of fragmentation.

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.

Tuned servers to the peak for maximum performance by configuring memory and various server level parameters.

Environment:Microsoft SQL Server 2000 Enterprise Edition on Windows Server 2003 Enterprise Edition, Management Studio, Query Analyzer, BCP, Profiler, T-SQL.

Contact this candidate