Paul Yerradoddi
Hyderabad
Summary
Experienced and versatile cloud database administrator with over 9 years of proven expertise in designing and testing database solutions across diverse environments. Proficient in Microsoft SQL Server technologies, adept at managing complex databases and ensuring optimal performance. Motivated self-starter with a strong drive for success, thrives in high-pressure environments, and consistently meets deadlines.
Overview
9
9
years of professional experience
1
1
Certification
Work History
DATABASE ADMINISTRATOR
S&P Global (IHS Markit)
01.2019 - Current
- Managed more than 5000 Databases across different regions and different products
- Troubleshoot SQL Server Always on Availability groups with more than 700 + Databases in Single Replica
- Configured, installed, and recovered DBMS systems, performing backups and updates to safeguard data
- Migrated Databases from Azure to AWS RDS and EC2
- Established hardware requirements and devised database storage solutions to accommodate client needs
- Worked closely with various departments to verify database operation maintains alignment with company standards
- Closely worked with Cloud Team and ensured the right RDS instances are created according to client requirement
- Worked on different AWS components like RDS, EC2, S3, AWS Backup, Simple Email Service.
- Monitored the RDS Instances using performance insights and provided related information to clients on Database performance
- Installed, configured Fog light Monitoring tool for different environments according to the client requirement
- Migrated the on-premises Databases to AWS Cloud environment
- Build same region and cross-region read replicas in AWS RDS
- Worked with Always on Availability groups for more than 800 Databases
- Coordinated with different teams and successfully done the Annual Disaster recovery tests for different client Databases
- Trained 2 Junior DBA's and other co-workers especially provided knowledge on application EDM (Enterprise Data Management)
- Analyzed the AWS cost and usage and help the organization to reduce the costs by planning capacity
- Tested database performance and functionality, implementing modifications to correct issues
- Document technology deployments by creating Standard Operating Procedures, training guides
- Automated the refresh activities from Prod to lower environments
- Created the backups and maintenance jobs according to client requirement
- Troubleshoot different performance issues and other SQL Server issues
- Created Logins and users for clients and provided necessary permissions according to their requirement
- Installed, Configured SQL Server Versions 2012, 2014, 2016, 2017 and 2019
- Configured SSRS in AWS RDS for SQL Server 2019
- Providing On Call Support.
SOFTWARE ENGINEER
Torry Harris Business Solutions
10.2015 - 12.2018
- Configured, installed, and recovered DBMS systems, performing backups and updates to safeguard data
- Worked on Telecom, Insurance domain Clients
- Developed and implemented security initiatives, protecting data to reduce company exposure and vulnerabilities
- Established hardware requirements and devised database storage solutions to accommodate client needs
- Worked closely with various departments to verify database operation maintains alignment with company standards
- Performed regular data validation and cleansing, optimizing database quality standards
- Tested database performance and functionality, implementing modifications to correct issues
- Specified user access levels for various segments to protect database integrity and company information
- Administered and monitored databases to identify and resolve problems with diverse servers
- Specified user access levels for each segment of databases, safeguarding against unauthorized use
- Recommend and execute modifications to database infrastructure to improve efficiency, reliability and Performance
- Provide guidance and support to the organization act as a single point of contact for DBA related issues
- Handled blocking and locking issues and troubleshoot accordingly
- Worked on various types of high availability technologies such as Log Shipping, Database Mirroring
- Administered SQL Server 2005/2008/2012 and 2014 Databases
- Understanding and working knowledge on ITIL process, responsible for designing ITIL practices and processes as per the organization standards
- Design and implement index management strategy according to customer requirement and create an automated jobs to perform Index reorg or rebuild operations.
Education
Master of Science IT Management -
Malardalen University
Vasteras05.2012
Bachelor of Technology Computer Science Engineering -
Jawaharlal Nehru Technological University
Hyderabad10.2006
Skills
- Database administration (Microsoft SQL Server)
- Cloud DBA, Application DBA
- Writing T-SQL queries as per requirement
- Knowledge in Oracle, MYSQL
- Optimizing and performance tuning
- Backup/Restore and Recovery Strategies
- Index Management
- Capacity Planning
- Document Management
- DR Activities
- Knowledge on SSIS, SSRS
- Knowledge on Windows Servers
- Worked on Performance Monitor, AD and Failover Cluster
- Knowledge on Power Shell
- Knowledge on Power BI
- Amazon Web Services (AWS)
- Azure Services
- Basic Knowledge in Linux
- Knowledge in Dev Ops
- Containerization (Docker)
- Foglight, SolarWinds
- Configured SSRS in AWS RDS
- Always ON
- High Availability, Replication, Log Shipping, Mirroring
- Clustering
- ITIL Process
- Incident, Change, Problem Management
Certification
70-462 - Administering SQL Server Databases 2012/2014(Microsoft Certified Solution Associate)
Languages
English
Advanced (C1)
Telugu
Bilingual or Proficient (C2)
Hindi
Intermediate (B1)
Swedish
Beginner (A1)
Timeline
DATABASE ADMINISTRATOR
S&P Global (IHS Markit)
01.2019 - Current
SOFTWARE ENGINEER
Torry Harris Business Solutions
10.2015 - 12.2018
Master of Science IT Management -
Malardalen University
Bachelor of Technology Computer Science Engineering -
Jawaharlal Nehru Technological University
70-462 - Administering SQL Server Databases 2012/2014(Microsoft Certified Solution Associate)
Similar Profiles
Aman GoelAman Goel
Lead Software Engineer at S&P Global (IHS Markit)Lead Software Engineer at S&P Global (IHS Markit)
Vyshok ShettyVyshok Shetty
Sales Associate at S&P Global (merged With IHS Markit In March 2022)Sales Associate at S&P Global (merged With IHS Markit In March 2022)
NIKHIL DUBEYNIKHIL DUBEY
Senior Consultant at S&P Global (formerly IHS Markit)Senior Consultant at S&P Global (formerly IHS Markit)