SUDHA RANI KAKILETI

SQL Server DBA

Mobile: +1-848-***-****/ Email_Id: ad39k6@r.postjobfree.com

Career Objective:

A highly skilled and experienced Microsoft SQL Server Database Administrator with over a decade of experience in database management, system administration, and optimization. Demonstrated expertise in migrating databases to newer versions and cloud environments, ensuring high availability, disaster recovery, and robust security measures.

Professional Summary:

As SQL Server DBA with Azure, I have extensive 12+ years of experience in maintaining Production and Application Environment.

Expert in Installations, configurations, Backup Restores, Database Recoveries, Data Migration (SQL to SQL, Oracle, Postgre), AWS and Azure, Database Refresh, Log-Shipping, Mirroring, Replication, linked servers, security, DR drills, Performance tuning, troubleshooting, always on, and also having hands-on SQL Azure as well, SSIS, SSAS, SSRS, SCOM, JIRA tool and all other core DBA activities.

Database Administration: Expert in administering Microsoft SQL Server environments, including installation, configuration, maintenance, and optimization of SQL Server 2000, 2005, 2008, 2012, 2017, and 2019.

High Availability & Disaster Recovery: Proficient in designing and implementing HA and DR strategies utilizing technologies such as clustering, Always On.

Performance Tuning & Optimization: Skilled in database performance tuning, query optimization, and the use of performance monitoring tools like SQL Profiler, Solar Winds, and DMVs to ensure optimal performance and reliability.

Database Security: Knowledgeable in implementing robust database security measures, including encryption, auditing, and configuring SQL Server security controls.

Backup and Recovery: Adept at managing database backups, restores, and disaster recovery plans, ensuring data integrity and availability of RTO and RPO.

Extensive experience in understanding, troubleshooting and fixing Performance issues by optimizing server performance, by keeping up-to-date DB health, working with QueryStore, reviewing and fixing issues with existing indexes, statistics or by introducing new, reviewing queries/stored procedures for anti-performance pattern and suggest the fix.

SQL Server Updates & Migrations: Experienced in migrating databases across SQL Server versions and platforms with minimal downtime using native backups, for Azure using to assess using DMA, DMS Tools and also applying SQL Server updates and patches as per MS standard.

Troubleshooting & Support: Proficient in diagnosing and resolving complex database issues, including performance bottlenecks, job failures, and security vulnerabilities.

Agile Methodologies: Experienced in employing Agile methodologies for task and project management, enhancing team collaboration and project delivery and CI/CD.

Having knowledge in Powershell scripts can automate the backup and restoration of SQL Server databases.

Having knowledge in Python scripts in cloud formations for instances (RDS) in AWS and Creation of new instances based on ARM in Azure.

Documentation & Training: Skilled in creating detailed documentation and training materials for database administration activities and best practices.

I can handle Change Activities, (as well as entire shift) independently. Good knowledge of configuration management concepts, release management, change management concepts, industry standards and best practices.

Professional Experience:

Working as Sr. DBA (IT Operations) for Wirelesscar AB from Jan 2023 to Till Date.

Worked as DBA Consultant(IT Infrastructure) for Technologist 365 AB from Jan 2020 to Oct 2022.

Worked as Technical Application software specialist for Accenture from Jan 2019 to Jan 2020

Worked as Technical Specialist for Mindtree Pvt. Ltd. from Feb 2018 to Jan 2019

Worked as Technical Services Specialist for IBM India Pvt. Ltd. from May 2015 to Jul 2017

Worked as IT Analyst for Tata Consultancy Services from July 2010 to Jun 2014

Professional Certification:

Certified as Microsoft Certified Technology Specialist (MCTS) (70-432) in SQL Server2005

Certified Microsoft Azure Database Administrator Associate – DP-300

I have achieved Award from ABB for Customer satisfaction.

Technical Skills:

Databases : MS-SQL SERVER, MySQL, PostGre

Database Tools : SQL Profiler, Solar Winds DPA

Operating Systems : Windows Server 2003, Windows Server 2008R2, 2012,

2016, Linux.

Languages : TSQL, HTML, DHTML,C, .Net technology, Powershell, Python

Cloud Platform : Azure (IAAS & PAAS)

Professional Experience:

CLIENT: WIRELESSCAR, SWEDEN/ NC SENIOR DBA JAN 2023 TO TILL DATE

Description:

WirelessCar is one of the world's leading innovators of digital vehicle services. For twenty-five years, we have accelerated service creation and turned connected vehicle data into business value for automotive consumers, mobility providers, vehicle makers and society. Easily maintain Microsoft products and support with .NET 200+ Application and also in cloud technologies. My role involved leading L3 support in the team and support managing Databases of and 2008, 2012, 2014, 2016, 2017, 2018 and 2019 sql servers and mixed flavours of databases like Mysql, Postgre and Azure (IAAS, PAAS) installation, migrations from On-Premise servers. Administration of 90,000 database servers, this includes more than 10TB High End Databases across different datacenters. Task also involves 24X7 uptime of database, maintenance of database, performance tuning, Backup & Recovery, Security Management, server Patching, monitoring & fixing issues.

Responsibilities:

Install, configure, upgrade and administer database platforms, tools and utilities (Primarily, but not limited to, MS SQL Server)

During migration DMA to analyse the databases for compatibility issues and estimate migration efforts. Sometimes migration based on bacpac files as well. Fully managed service for migrating databases with minimal downtime.

Establish regular maintenance routines for backup, recovery and optimization plans

Proactively monitor and performance tune databases and troubleshoot bottlenecks and system performance at the network, storage and database levels.

Use DMV’s, SQL Profiler, SQL Sentry and other resources to troubleshoot and work on performance issues.

Review complex T-SQL queries for various tasks such as functions, store procedure, triggers, cursors and various DML, DDL statements.

Support developers to design performance, scale-able and optimized objects and queries

Provide support to Production/Staging/Development databases, jobs and transactions processes

Follows and enforces the change control polices and database lifecycle management process

Track and report daily metrics on up-time, utilization, logins, blocking, locking, etc.

Installation and configuration of cluster, Alwayson, and troubleshooting issue.

Understanding, implementing and fixing Encryption, Compression, CDC, CT, Resource governor, partitioning.

Monitor, troubleshoot and fix IO subsystem and other resources as and when needed.

COMPANY:ESSITY, SWEDEN Microsoft (MS-Supply Chain) DBA Consultant(IT Infrastructure)

JAN 2020 TO OCT 2022

Project Summary:

Essity is product based renowned organization where IT platform is mainly operated in Gothenburg, Sweden. My role involved leading L3 support in the team and support managing Databases for 50+ share-point, CRM applications and like SQL Server 2008, 2012, 2014, 2016, 2017, 2018 and 2019 sql servers Azure (IAAS, PAAS, SQL MI) installation, migrations from On-Premise servers. Task also involves 24X7 uptime of database, maintenance of database, performance tuning, Backup & Recovery, Security Management, server Patching, monitoring & fixing issues.

Responsibilities:

Handson SQL IAAS, and PAAS migrations in Azure. Newly creates Azure sql db and also creation of backup using Recovery vault configuration. Troubleshooting the issues related to this.

Handled SQL connectivity issues related to SQL MI.

I have worked on installations of new SQL instances, issues related to fix during installation failure.

Troubleshoot and identify performance to Optimize systems and ensure quality performance at Operating System (OS) and Database levels.

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).

Installation and configuration of cluster, Alwayson, and troubleshooting issue.

Daily standup calls with internal team and clients.

COMPANY: ACCENTURE,INDIA Microsoft (MS-CSS)Procurement Technical Application software specialist

Jan 2019 to Jan 2020

Project Summary:

Microsoft, headquartered in Redmond, US, has a Bangalore development center, operating mainly in SQL server technology areas. Easily maintain Microsoft products and Disaster Team events. Disaster Team events provides disaster team members with information about their meetings as well as minutes/newsletters of the meetings. My role was to lead L3 support in the team and support managing SQL Databases for .NET application and SQL over Cluster Servers, Azure migrations, AWS followed with ITIL process. I have supported Microsoft cases.

Responsibilities:

Handson on troubleshooting issues from Microsoft cases using MS Solve Tool.

Worked on Configure and manage database replication, failover, and clustering for HA

SQL Azure installation and backup configuration. Troubleshooting the issues related to this.

Scale database resources to accommodate growing workloads.

I always identify and resolve performance issues by analysing query execution plans and database statistics

Optimize database schema and configurations for improved efficiency

My role involves configuring new clustered and standalone boxes, Always on and BI components.

Troubleshooting issues on Cluster, HA like Logshipping, Replication and also performance issues.

COMPANY: MINDTREE, INDIA Microsoft(MS-CSS) Technical Specialist Feb 2018 to Jan 2019

Project summary:

MS is a Microsoft multinational corporation headquartered in Redmond, US, operating mainly in SQL server technology areas. Easily maintain microsoft products and Disaster Team events. Disaster Team events provides disaster team members with information about their meetings as well as minutes/newsletters of the meetings. I have worked as a Technical specialist with Mindtree one of the prestigious clients at Hyderabad. My role involves member of leading L3 support in the team and support managing Databases of and SQL over Cluster Servers which is ITIL process. We are supporting Microsoft cases.

Responsibilities:

Handson Microsoft cases on various SQL issues using MSSolve Tool.

My role involves configuring new clustered and standalone boxes, Alwayson and BI components.

SQL Azure installation and backup configuration. Troubleshooting the issues related to this.

Troubleshooting issues on Cluster, HA like Logshipping, Replication and also performance issues.

Handson Migration task from SQL server to cloud and Upgradation of SP, Hotfixes, Version, vulnerability.

Troubleshooting issues based MS Cases, few can be on CDC, Replication failure, SQL installation setup failures, Login failures.

COMPANY: IBM PVT LTD, INDIA ABB (Asea Brown Boveri) Technical Services Specialist May 2015 to Jul 2017

Project Summary:

As a Production support cum migration DBA with IBM one of the prestigious clients ABB at Hyderabad. My role involves member of leading L3 support in the team and support managing cross plat-forms of databases like Mysql, DB2, MSSQL versions for SQL 2005 & 2008, 2012, 2014, 2016, 2017 over Cluster Servers, Azure migrations which is ITIL process. We are supporting more 50 Applications and managing more than 300 sql instances and SQL DB Hotels having more than 1TB in size.

Responsibilities:

Handson change, incident and problem management using Snow Tool, Remedy.

Migrations SQL server to SQL server or Oracle, Postgre using DMA to analyse the databases for compatibility issues and estimate migration efforts.

I have worked in troubleshooting the SQL server connectivity issues. Providing solutions to the Ad-Hoc SQL Server Requests and issues reported by the users.

My role involves configuring new clustered and standalone boxes, Alwayson and BI components.

Involved in SQL SSIS deployment as per customer request and fulfilling till the completion of the task.

COMPANY: TCS, INDIA ASML, Verizon, Microsoft IT Analyst Jul 2010 to Jun 2014

Project Summary:

I have worked as a Production support cum migration DBA with TCS one of the prestigious clients Microsoft, Verizon (Telecom project), ASML at Hyderabad. My role involves Leading the team and support managing Mixed flavor of Databases like Mysql, DB2, MSSQL versions of 2005 & 2008, 2012 over Cluster Servers which is ITIL process. We are supporting 176 SAP and Non-SAP Applications and managing more than 350 sql instances. Task also involves 24X7 uptime of database, maintenance of database, performance tuning, Backup & Recovery, Security Management, server Patching, monitoring & fixing issues.

Responsibilities:

I have worked on change, incident and problem management using SMIS Tool, Remedy.

Related to DBA tasks in many aspects of working.

My role involves configuring new clustered and standalone boxes and sql servers. And maintenance of SQL activities like patching tasks.

Educational Qualification:

B.Tech (EEE) in P.v.P. S.I.T (Siddhartha Institute of Technology), from JNTU University in 2006

Intermediate (M.P.C) in Srichaitanya College, from AP.Board in 2002

10th grade in St.Ann's High School, from ICSE

Contact this candidate