Senior Cloud A

Ravi Kumar Makkena E-Mail : ***********@***.***

Frisco, Texas, USA Mobile : +1-646-***-****

LinkedIn: www.linkedin.com/in/Ravimakken

SUMMARY:

** ***** ** ** ********** in Database Administration, Design and Development and support of MSSQL Server from 2005 to 2022 in production, Development and cluster environments with Azure and AWS Cloud.

Around 8.0 Years of experience as an Infrastructure Engineer with J.P Morgan Chase & Co.

from Jun’17 to Mar’25(Plano, Tx)

Worked 2.3 Years as a Senior DBA with Charter Communication from Mar’15 to May’17(St.Louis, MO)

Worked 3.3 years of experience as a Sr.Database Specialist with WIPRO Technologies

from Nov’11 to Feb’15(Plano, TX)

Worked 2.3 years as Technical Service Specialist with IBM from Sep’09 to Nov’11(Austin, TX)

Hands on experience in maintaining application databases. Involved in configuring Replication, Log Shipping, Mirroring, Always-On setup and Clustering.

Experience in Installations, Configuration and Maintenance of MSSQL 2005 to 2022.

Hands on Experience to set up Always on Availability on SQL 2012 to 2022, maintenance and troubleshoot issues.

Configured Transparent Data Encryption (TDE) for production databases, Create, backup and restore Certificates of TDE.

Enabled the Accelerated Database Recovery (ADR) in always on for faster fail-overs to avoid database recovery time.

Hands on Experience using BMC Automation Blade Logic Tool to Apply Base Line service packs/hot fixes/Cumulative updates.

Very much acquainted with SQL log, Cluster Log and event viewer reading to narrow down to the root cause of the issue.

Experience with handling Critical Issues like p1/p2, involved in Bridge Calls and co-ordinate with respective teams to resolve the issue within the SLA timelines.

Effective and Efficient Collaboration with many towers (Storage/Network/Windows/Backup) to drive the business requirements.

Design DR and deploy HA to extremely minimize the RPO duration and recover quickly the services as per the RTO timelines.

Installation, configuration and maintenance of SQL Server Active/Active and Active/Passive cluster and configured the Always-on high availability technique in SQL server 2012 to 2022 environment

Provide value ads by recommending data security solutions to customer databases are secured through implementing SSL (TLS 1.2), Always Encrypted, TDE and symmetric keys.

Upgrade/Migrate Database servers from 2005 to 2022 and ensure to application connectivity.

Hands on Experience as SQL Server Database Administrator with proven track record of Administration experience, competent team member and technical skills.

Migrate On-premises database to Azure cloud, Windows server using VHD to Azure cloud.

In PaaS created SQL Database, Auto backup schedule to storage account, Geo Replication configuration, and Dynamic Data Masking configuration.

Involved in migration of on-premises SQL DBs to AWS EC2 instance.

Migrated on-prem DB's to AWS RDS using AWS Data Management Services (DMS).

Expertise in Performance Tuning, Optimization, Data Integrity and statistics by using SQL Profiler, PerfMon, and Database Tuning Advisor.

Increasing EBS backed volume storage capacity when the root volume is full using AWS EBS Volume feature.

Created S3 backups using versioning enable and move objects to Amazon Glacier for archiving purpose.

Created load balancers (ELB) and used Route53 with fail-over and latency options for high availability and fault tolerance.

Adhere to follow the standard change management ITIL V3 process and co-ordinate with CAB team to get the changes approved on-time.

TECHNICAL SKILLS:

Operating Systems : Windows 2003 to 2022 Servers and Linux.

Databases : MS SQL Server 2005 to 2022, AWS Cloud RDS, PostgreSQL.

Tools : Lite Speed,SQL profiler, BMC Automation Blade Logic Tool, SQL 360,GitHub, Bitbucket.

Programming Language : T-SQL, Windows Power Shell Scripting.

Knowledge Exposure : DevOps Tools like Ansible, Jenkins, Docker, Maven, SonarQube, Kubernetes, and Terraform (IAC).

EDUCATION CERTIFICATIONS:

Graduation B.Sc. completed from Acharya Nagarjuna University since 2003.

PGDCA (Post Graduation Diploma in Computer Applications) completed from Cyber World Computer Education since 2006 Recognized by Govt. of Andhra Pradesh(A.P), IND.

Microsoft Certified Specialist (MCTS&MCP) in SQL SERVER 2008/2012.

Azure Administrator (AZ-104) Certified Professional.

AWS Database Specialty Certified Professional

PROFESSIONAL EXPERIENCE:

JPMC Plano, TX Jun 2017 - Mar 2025

Projects # : 1.Chase Merchant Services 2. Digital DRO SQL

Role : Sr. SQL DBA Cloud Migrations AZURE AWS RDS.

Environment : Microsoft SQL Servers 2014 to 2022 on Win Servers 2012 to 2022.

Team Size : 10

Roles & Responsibilities in SQL Admin Front:

Leading a team of 10 members both Offshore and Onshore.

Respond quickly and effectively to production issues and taking responsibility.

Experience in Handling Critical issues like p1/p2, Involved in Recovery Bridge Calls and co-ordinate with respective teams to resolve the issue within the SLA timelines.

Experience with the design, Implementation and support of SQL Server Integration(SSIS) and Reporting services(SSRS) and power-bi, including scale-out design for reporting services,

Experience in Proof Of Concept(POC) and prototyping activities to evaluate whether proposed architecture and database components meet functional and non-functional requirements.

Developed Automation scripts using Power-Shell and integrate with AAAS tool (JPMC developed internal tool) which will reduce the manual efforts like we use for script deployments, DB refresh from Prod to QA/UAT Servers.

Design a framework, SQL360 Performance Dash board for SQL server platform, its designed to get 360-degree visibility into real time and historical performance data to troubleshoot performance issues and check system health, SQL360 will help DBA’s, Application Developers, and production management team to check the SQL metrics as a self-service portal through web. Key features include, Monitor CPU\Memory\Tempdb utilization, Waits, Active Process, Query Plan, long running Queries\IO Intensive Queries, locking\Blocking\Deadlock\Missing Indexes etc. the reporting dash board is widely used all other Lobs actively across the firm.

Deploy NexGen DB maintenance program on new built servers, which has been designed to replace the legacy maintenance jobs by rewritten the existing frame work and use intelligence and new futures are added to meet to the modern-day business needs, the new maintenance package will be able perform index work (rebuild\reorg) and update stats without causing outage to the application.

Run PSSDIAG and upload the logs in MS work space and coordinate the MS Engineer to identify the root cause of the issue and remediate with fix.

Developed AAAS micro service package to fail-over Databases from one

Configure Geo-Clusters, Setup Always-on DC to another DC and co-ordinate with AD teams and ensure the Application pointing to new primary site.

Involved in configuring Log-shipping/Mirroring from one DC to another DC as per the application requirement and flip the DB fail-over and fail-back when required.

Involved in storage Configuration like disk mount/UN-mount and adds in Cluster dependencies.

Involved in Performance issues and resolved, raise MS Case and work with them.

Involved in DB Tech Refresh activities which migrate the databases to higher versions and to use DB Engine new features and services to improve the performance.

Performing Security Administration tasks like creating users and Delegating appropriate permissions.

Involved in Account Audit Remediation process.

Apply service packs (SP) and Meltdown Patching to keep servers up to date.

Monitor Database Error logs/event viewer after apply the patches if any issues noticed then perform problem determination when necessary.

Involved in implementing Always on Availability set up and trouble shoot issues.

Performed day-to-day tasks like Monitoring jobs, Alerts, SQL Server Error Logs, Event Logs, Disk spaces, Alert logs including backup and restores.

Involved in SAN Migration from Old array to new array using VMax 250 SSD disks.

Involved Tech Refresh activities like we migrate SQL 2008r2 to 2012/2016/2017 new versions.

Performed DB Fail-over and fail-back as per the Application requirement and ensure App connectivity.

Involved in execution of Quarterly/Monthly releases (CR’s/MR’s) and coordinate with AD teams and ensure to complete the releases flawless within the change time frame.

Involved in SSL Cert implementation and renewal before expiry and ensure the App connectivity after the cert renewal.

Adhere to follow the standard procedures to create Change Requests and implement as per the scheduled down time and sent an email communications to the respective app team to ensure the application connectivity post CR implementation.

Configure Azure services PAAS/IAAS and migrated database from on-premises to Azure Cloud.

Remote Login to Virtual Machines to troubleshoot, Monitor and deploy Applications.

Designed Network Security Groups (NSGs) to control inbound and outbound access to network interfaces (NICs), VMs and subnets.

Setup Azure Virtual Machines (VMs) to meet security requirements and Grant (RBAC) role based access for the required users and groups.

Setup Local, Geo Redundant servers for Data Resiliency.

Migrate SQL server databases to Microsoft Azure Hosted DBs, Managed Instances, Configure High Availability HADR solution.

Migrated VMs, SQL Databases from on-premise to AZURE, Configure Geo-replication for High Availability, Azure site recover and manage database on Elastic pools and manage instances.

Setup/Manage Amazon web services (AWS) – ELB, EC2, S3, RDS, SNS, Cloudwatch.

Expertise in architect secure VPC solutions in AWS with the help of Network ACLs, Security Groups, public and private network configurations.

Create S3 buckets and also managing policies for S3 buckets.

Experience in managing and maintaining IAM policies for organizations in AWS to define groups, Create Users, Assign roles and define rules for role based access to AWS resources.

Create snapshots and Amazon machine images (AMI’s) of the instances for backup and creating clone instances.

Create and maintain user’s accounts, profiles, security rights, disk space and process monitoring.

Provide technical support by trouble shooting day-to-day issues with various servers on different platforms.

Creating DNS records on amazon route53 and go-daddy panel.

Involved in Creating AWS EC2 instances and attach EBS Storage volumes.

Experience and understanding of Data-bricks, data lakes and/or data warehouse.

Experience in handling SSIS and ADF ETL (Extract, Transform, Load) processes and cloud-based data warehousing solutions like snow flake.

Charter Communicaton St.Louis, Missouri Mar 2015 - May 2017

Role : Senior DBA

Environment : Microsoft SQL Servers 2008 to 2016 on Win Servers 2003 to 2016.

Team Size : 6

Roles & Responsibilities:

Diagnosed and resolved all production issues and errors, enhancing system reliability.

Provision SQL servers through Automation via Power-Shell Scripting, expediting setup processes.

Efficient Backup and restoration plans of system and user Databases.

Experience in Handling Critical issues like p1/p2, Involved in Recovery Bridge Calls and co-ordinate with respective teams to resolve the issue within the SLA timelines.

Monitoring backups for all databases on daily bases basis, if any job failed troubleshoot the issue.

Taking backups from production servers and restore on Dev/UAT Servers as part of database refresh activity requested by Application Teams.

Involved in implementing Always on Availability set up and trouble shoot issues.

Performed day-to-day tasks like Monitoring jobs, Alerts, SQL Server Error Logs, Event Logs, Disk spaces, Alert logs including backup and restores.

Creating weekly maintenance jobs like rebuild index/update stats/check db to ensure database optimization.

Extensively use SQL Profiler, Perfmon, DMV’s to identify performance issues related to databases, servers, long running complex queries.

Involved in resolving locking and blocking issues.

Monitoring SQL Server Incidents, Change Requests, and mission critical databases and providing 24x7 production supports to ensure the issue to be resolve within the time frame to Adhere to project SLAs.

Performing Security Administration tasks like creating users and Delegating appropriate permissions.

Creating storage provisioning work requests and liaising with windows/storage teams to ensure the WR implemented.

Conducted routine monitoring of jobs, backups, and restores to maintain operational integrity.

Aetna, Insurance WPRO Plano, TX Nov 2011 - Feb 2015

Role : Specialist

Environment : Microsoft SQL Servers 2005/2008r2 on Win Servers 2003/2008.

Team Size : 5

Roles & Responsibilities:

Monitor the Server and fine tune to obtain optimal performance by advising and assisting testing and development teams.

Handled/Involved in Bridge call when critical Issues arisen like p1/p2 and also prepared RCA.

Troubleshooting any SQL related issues in client Servers.

Backup client databases and perform database restore as required.

Effective implementation in running consistency checks from SQL Server and application. Perform and monitor daily database operations and set-up backup schedules.

Monitor the status of Maintenance jobs schedule to run daily and on weekends (tasks like rebuilding indexes, defragmenting Databases, Shrink Database, and Database complete backup).

Maintenance and troubleshooting Transaction Replication.

Build cluster environment and troubleshoot if any issues arisen.

Installing latest service packs/patches on production server on both standalone/Cluster nodes.

Migrated MSSQL 2000/2005 to 2008r2 on production environment.

Expertise in configuring and troubleshooting Mirror.

Maintain DR Servers for Production Servers.

Creating users, roles and giving appropriate permissions to the members as part of the implementation.

Monitor databases for Errors\ Alerts and perform problem determination when necessary.

Apply service packs (SP)/Cumulative Updates(CU) and keep the servers up to date.

Maintain Database changes from Development, QA to Production.

Walt Disney IBM Austin, TX Sep 2009 - Nov 2011

Role : Technical Service Specialist

Environment : Microsoft SQL Server 2005/2008r2 on Win Server 2003/2008.

Team Size : 12

Responsibilities & Tasks:

Involved in upgradation to Yukon from SQL server 2000, planning and determining the appropriate upgrade strategy.

Configure High Availability(HA) solutions, Mirroring, Log-Shipping, Clustering as part of Disaster Recovery(DR) Solutions

Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of user support.

Maintaining the database consistency with DBCC at regular intervals

Monitoring SQL server performance and to find performance and dead locks.

Designed and implemented comprehensive Backup plan and disaster recovery strategies.

Monitored and modified Performance using execution plans and Index tuning.

Export or import of data from other data sources like flat files using Import/Export of DTS.

To analyze long running queries and tune the same to optimize application and system performance.

Execute customized GSD331 Health check script to found if any security violations on servers and remediate those vulnerabilities.

Performed day-to-day tasks like Monitoring jobs, Alerts, SQL Server Error Logs, Event Logs, Disk spaces, Alert logs including backup and restores.

Adhere to follow the standard procedures to create Change Requests and implement as per the scheduled down time and sent an email communications to the respective app team to ensure the application connectivity post change implementation.

Contact this candidate