Vijay Mallela
About Vijay Mallela
Vijay Mallela is a Senior Oracle/SQL DBA at Yale University, where he has worked since 2019. He specializes in database migration, performance optimization, and monitoring, with extensive experience in both Oracle and SQL Server environments.
Work at Yale University
Currently serving as a Senior Oracle/SQL DBA at Yale University since 2019, Vijay Mallela is responsible for managing and optimizing database systems. His role involves migrating Oracle databases and performing database tuning to enhance performance. He has contributed to various database management tasks, ensuring the integrity and availability of critical data for the university.
Education and Expertise
Vijay Mallela holds a Master's degree in Computer Science from Sri Krishnadevaraya University, where he studied from 2001 to 2003. His educational background provides a strong foundation for his extensive experience in database administration, particularly with Oracle and SQL Server technologies.
Database Migration Experience
Vijay has extensive experience in migrating databases, including moving Oracle databases from AIX to Linux and SQL Server databases from AWS to Azure. His work encompasses both production and non-production servers, demonstrating his versatility in handling different operating systems and cloud environments.
Database Performance Optimization
Vijay Mallela has implemented various performance optimization techniques, utilizing tools such as TKPROF and EXPLAIN PLAN for database tuning. He has also developed a native SQL Server solution using T-SQL code to monitor database connectivity, alerting the DBA team to any issues. These initiatives enhance the overall performance and reliability of database systems.
Oracle Database Management Skills
Vijay has demonstrated proficiency in Oracle database management by upgrading databases from version 12.1 to 12.2 and further to 19C. He has set up and configured new server targets for Oracle Enterprise Manager 13.3 and interacted with Oracle Support to resolve critical database issues, showcasing his capability in managing complex technical challenges.