Siva Swarup Ondranki
Senior Database Administrator & Analyst
Hyderabad
Summary
Experienced Senior Database Administrator with 13+ years of experience in database design, development, and administration. Skilled in creating and managing databases, optimization, performance tuning and high availability for high-volume, mission-critical applications in on-premise and cloud environments
Overview
14
14
years of professional experience
2
2
Certifications
Work History
SQL DBA & Analyst
Telebu Communications Pvt Ltd
10.2010 - Current
- Managed and implemented database systems for large scale enterprise clients on SQL Server on-premise and cloud platforms
- Experience in installing, configuring, managing, monitoring and troubleshooting SQL Server s 2000/05 and 2008/R2,2012,2014, 2016, 2017,2019 and 2022 standard alone and Cluster on Physical, Virtual and Cloud environments
- Deploy, Configure, Maintain databases and servers on AWS
and Azure - Migrating database from on-premises to Azure & AWS cloud
- Hands-on experience on Database high availability such as Log shipping, Mirroring, replication, always on and Clustering
- Experience in Applying service packs and hot fixes in standard alone and Cluster environment
- Implementation of SQL Logins, Roles. Security audit and Authentication modes as a part of security policies for various categories of user support
- Experience in upgrading/Migration SQL Server from lower versions to higher versions
- Experience in Database Backup and Recovery procedures
- Experience in Setting up cross database connectivity using Linked Servers
- Scheduled and maintained routine Jobs, Tasks, Alerts and Maintenance Plans
- Hands-on Experience on Performance Tuning (Query,
Database & Server) level - Hands-on experience on Database high availability such as Log shipping, Mirroring, replication, always on
- Analyzes and generation of all tables and index statistics
- Monitoring and resolving data lock issues
- Check all statistics related to memory, locks, I/O, database response time, wait events, top sessions and background processes
- Create indexes to achieve critical dataset response time for time sensitive reports
- Proactively monitor SQL Server maintenance tasks, troubleshoot failed jobs and resolve issues in a timely manner
- Troubleshoot application slowness and performance issues
- Logs analyzing using log parser & Web Log expert tools
Education
MCA -
Jawaharlal Nehru Technological University, Andhra Pradesh
TadepalligudemSkills
Database Management
Performance Tuning
Troubleshooting
High Availability
Replication Strategies
Backup/Restore
SQL Queries
Onpremise to cloud migration
Amazon Web Services
Microsoft Azure
Leadership
Teamwork
Time management
Certification
AZ-900: Microsoft Azure Fundamentals
Roles And Responsibilities
- Leading the team to develop & maintain Databases
- Install and configure new Microsoft SQL Server instances, including AlwaysOn availability groups and failover clustering
- Skilled at database design, installations, conversions Responsible for database backup and recovery procedures, access security and database integrity, physical data storage design and data storage management
- Participates in Database Management System selection and maintains database performance
- Experienced in Database Performance, Maintenance and Development to perform the following
- Install SQL Server service packs and updates
- Configure and manage SQL Security settings
- Manage database backup & recovery & DR planning in collaboration with IT manager and System Engineer
- Create, modify, and optimize SQL Server Agent jobs and maintenance plans
- Proactively monitor SQL Server maintenance tasks, troubleshoot failed jobs and resolve issues in a timely manner
- Troubleshoot application slowness and performance issues
Projects
1) www.smscountry.com
SMSCountry is the leading, bulk SMS provider in India. It is a pioneer text messaging service provider facilitating businesses to communicate with customers via SMS. With SMSCountry, we can send bulk SMS, notifications, and alerts to the customers.
2) reseller.smscountry.com
SMSCountry provides reseller business to their customers. Which means that SMSCountry acts as an aggregator and providing services to their customers along with the dedicated portal for each customer.Customers purchased credits from the SMSCountry and they will do their own business with the sub resellers.
3) orders.smscountry.com
Orders website is the one point Invoice generation portal for Telebu communications. Which provides the quotation & invoice generation facilities to all the SMSCountry products and customers of both Domestic and International.
4) www.wanasatime.com
WanasaTime Entertainment is a media & online ticketing company with extensive experience in the cinema advertising and online ticketing platform exclusively for the GCC market.
5) web.press3.io (Telebu Hub)
TelebuHub is a single-window cloud call centre software that's loaded with all the tools and applications you need to manage an inbound, outbound or blended contact centre. With Missed Call Services, Cloud IVR & Outbound calling.
6) 160by2.com
It is a free SMS website, by registering on this platform customers can able to send free messages to the other mobile numbers.
Timeline
SQL DBA & Analyst
Telebu Communications Pvt Ltd
10.2010 - Current
MCA -
Jawaharlal Nehru Technological University, Andhra Pradesh
Similar Profiles
Nagalakshmi ThotaNagalakshmi Thota
Lead Front End Developer at Telebu Communications Pvt LtdLead Front End Developer at Telebu Communications Pvt Ltd
KRUPESH PARMARKRUPESH PARMAR
Head Marketing and Operations at Ascent Brand Communications Pvt Ltd, Ascent Brand Communications Pvt. LtdHead Marketing and Operations at Ascent Brand Communications Pvt Ltd, Ascent Brand Communications Pvt. Ltd
VIRAJ T SVIRAJ T S
Senior System Engineer at Asianet Star Communications Pvt Ltd through Payroll of Frontier Business Systems Pvt LtdSenior System Engineer at Asianet Star Communications Pvt Ltd through Payroll of Frontier Business Systems Pvt Ltd