Prem Gan
About Prem Gan
Prem Gan is a Senior Database Engineer (DBA/Architect) at Jefferies, known for implementing significant technological advancements and enhancing database security and efficiency.
Current Position at Jefferies
Prem Gan currently holds the position of Senior Database Engineer (DBA/Architect) at Jefferies. He has been with the company since 2014. His primary location of work is at 101 Hudson. Prem's responsibilities include designing, configuring, and implementing database systems, focusing on significant technological advancements and overall efficiency improvement.
Education and Academic Background
Prem Gan pursued his higher education at Osmania University. He studied Mechanical Engineering and earned his Bachelor of Engineering degree, completing his studies from 1991 to 1995. His background in engineering provides him with a strong foundation for his technical roles in database engineering and architecture.
Notable Projects and Technological Contributions at Jefferies
During his tenure at Jefferies, Prem Gan has spearheaded several key projects. He designed and implemented the first Oracle 12c RAC/ASM cluster, marking a significant technological milestone for Jefferies. He also architected the consolidation process for applications onto the 12c RAC cluster, which resulted in considerable cost savings in storage and server resources.
Security Enhancements and Automation Initiatives
Prem Gan played a pivotal role in enhancing database security at Jefferies by implementing Oracle Database Vault and data masking processes. These measures effectively prevent unauthorized data access in production environments. Additionally, he automated the addition of datafiles for over 200 databases and utilized Python 3.x to streamline and improve the reliability of backup processes.
Mentorship and Enterprise Software Management
Prem Gan has contributed to the professional growth of his colleagues by mentoring developers in writing optimal TSQL/SQL programs. His guidance helped improve code quality and performance. Furthermore, he served as the PeopleSoft Admin for the upgrade of Financial/HRMS systems from PT 8.51 to PT 8.54, showcasing his expertise in managing and upgrading enterprise software systems.