Pranay Reddy
Data Analyst | SQL DataBase Administrator
- Role
- Data Analyst at PENNYMAC
- Location
- Lees Summit, MO, US
- LinkedIn followers
- 500 followers
About Pranay Reddy
With around 4years of hands-on experience managing large-scale databases in production…
Experience
Data Analyst
Jun 2024 — Present · Tallahassee, FL, US
As a Database Administrator Managed Azure SQL Servers and worked on AWS Redshift & RDS MySQL.Optimized SQL queries & indexing, improving system performance by 40%.Implemented High Availability & Disaster Recovery (HADR) for SQL Servers.Developed PL/SQL procedures, triggers, and stored functions for database automation.Migrated on-premise MSSQL & MySQL databases to AWS RDS & Azure SQL, ensuring minimal downtime and improved scalability-Optimized complex SQL queries, indexing strategies, and implemented HADR (High Availability & Disaster Recovery), improving system performance by 40%-Automated SQL deployments & backups using PowerShell & Jenkins, reducing manual intervention by 60%-Strengthened database security measures by implementing encryption, access controls, and GDPR compliance policies-Developed ETL pipelines using SSIS & Python to extract, transform, and load data across various platforms.
Education
Loyola Academy, Hyderabad
Bachelor's degree, Computer Science
University of Central Missouri
Master's degree, Computer Science
Find verified contacts for anyone on LinkedIn
Unifers gives sales teams verified emails and direct dials, enriched profiles, and outreach that lands in the inbox.
Free plan included · No credit card required
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.