Archana Kiron Kondavalsa
Toronto
Summary
Systematic Database Developer with [10+] years of experience in designing, engineering architecture and data modeling. Proven track record managing all phases of software development lifecycle (SDLC). Analytical thinker quickly and effectively identifies and resolves technical problems.
Overview
10
10
years of professional experience
Work History
Database Administrator
Client - PNC Bank(USA)
06.2018 - Current
- Optimized database performance by monitoring health and implementing tuning recommendations.
- Reduced data retrieval times for business users by creating indexed views and optimizing stored procedures.
- Ensured database security with implementation of role-based access control and regular vulnerability assessments.
- Increased efficiency in software development processes through effective collaboration with developers to design databases that support application requirements.
- Developed comprehensive documentation on database architecture, simplifying future upgrades and maintenance tasks.
- Monitor and troubleshoot Dataguard environments. Recover standby databases to keep them in-sync with primary databases.
- Rebuild of standby databases.
- Create Compartments, Security Lists, Route Tables, Subnets, in Oracle Cloud as per the clientrequirements.
- Performance Tuning from the DB and Query Level
- Perform Data Centre migration activities with the use of Oracle tools like Datapump, RMAN ortapes restoration techniques.
- Database Backup (Export, Hot backup, RMAN).
- Development of Dashboards with Microsoft Power BI, Reporting Services.
- Conducted regular audits of data quality, identifying inconsistencies and implementing corrective actions as necessary.
Oracle Consultant
Client - UBS (Zurich)
11.2013 - 03.2018
- Streamlined Oracle database operations by implementing efficient data management techniques.
- Enhanced system performance by optimizing SQL queries and stored procedures.
- Developed custom Oracle applications for improved business process efficiency.
- Reduced processing time with the implementation of automated scripts for routine tasks.
- rovided 24x7 supports for 10g Oracle databases
- Created primary database for Development/UAT/Production for GE Commercial finance on Solarisservers
- Implemented RMAN, Export Backup Strategies for corresponding Dev, Test and ProductionDatabases
- Database Backup (Export using Data Pump, OFFLINE and ONLINE backups using RMAN)
- Provided production support to maintain data integrity, performance, security and availability ofthe production environment database
- Process, Schema and Log maintenance and Auditing
- Database Backup (Export, Hot backup, RMAN)
Education
- Bachelor's in Computer Science Engineering
Jawaharlal Nehru Technological University
HyderabadSkills
- Oracle 11g, 12c, 19c
- Oracle Dataguard
- Microsoft SQL Server (2016)
- MongoDB Azure, AWS, PostgreSQL
- Power BI
- Running backups
- Disaster Recovery
- Database Development
- Linux
Languages
English
Full Professional
Timeline
Database Administrator
Client - PNC Bank(USA)
06.2018 - Current
Oracle Consultant
Client - UBS (Zurich)
11.2013 - 03.2018
- Bachelor's in Computer Science Engineering
Jawaharlal Nehru Technological University
Similar Profiles
John WischmeierJohn Wischmeier
Senior Operations Manager at USASenior Operations Manager at USA
Melissa KelleyMelissa Kelley
Cook at USACook at USA
Xinyi PengXinyi Peng
Freelancer at ClientFreelancer at Client