Jagannathan C
Kanchipuram
Summary
Highly motivated database expert with 6+ years of experience. Successful at implementing and maintaining smooth operation and physical design of databases. Strong aptitude to learn and adapt to new technology.
Overview
7
7
years of professional experience
Work History
Senior Database Administrator
Cognizant Technology Solutions
chennai
01.2023 - Current
- Developed data models and designs to address complex data challenges effectively.
- Designed life-cycle data flows to create high-performing data management systems.
- Collaborated with developers and product teams to shape application development and database integration.
- Conducted data validation and cleansing to improve database quality and reliability.
- Performed patching activities regularly on standalone and RAC environments for updates.
- Deployed patches and upgrades to ensure optimal performance of Oracle Cloud infrastructures.
- Automated daily tasks through shell scripting, streamlining operations and enhancing team efficiency.
- Assessed customer needs and modified databases to align with client specifications.
Database Administrator
Tata Consultancy Services
Chennai
06.2019 - 12.2022
- Executed capacity planning, installation, configuration, database design, migration, performance monitoring, security, troubleshooting, and backup and data recovery to ensure optimal database performance and reliability.
- Worked on ASM and RAC instances for patching,upgradation, Installation and performance tuning activity
- Dedicatedly Worked on many Installation, Upgradation and Migration of oracle and postgres servers to current versions
- Worked on Quarterly Patching activities like PSU patching on all oracle databases on standalone and RAC environments.
- Maintained databases and controlled their loads during critical activities, performing backup and recovery during the month-end process.
- Contributed to crucial live production deployments as DBA, ensuring smooth operations and receiving client appreciation for performance.
- Organized many DRS and mainly was responsible for managing and syncing of drs along with on-prem servers and to perform switchover - Failover activities
- Worked on Informatica instances and ETL tools and provided maximized efforts on ETL critical production deployments
- Streamlined processes on Jenkins to enhance production deployments and facilitate efficient data fix runs.
Education
BE in Electronics and Communication Engineering -
Rajalakshmi Engineering College
ChennaiHSC - Bio- Maths
MLM Mamallan matric higher secondary school
Kanchipuram01.2015
10th - General
MLM Mamallan matric higher secondary school
Kanchipuram01.2013
Skills
- Database administration
- Oracle RAC and ASM management
- RMAN and Data Guard
- Standby and failover administration
- Data security
- Performance tuning
- ETL management
- Database installation
- Job automation
- Shell scripting
- PL/SQL, PEM, PGAdmin, C, C
- RAC patch management
- Oracle Cloud infrastructure
Accomplishments
- Best Paper award for our project "Hand Rehabilitation Glove for Passive Therapy of Brachial Monoplegia," 07/2018, 01/2019, 2nd International Conference on Recent Trends in Science and Technology conducted by GKM College of Engineering.
- Won 2nd place in the open national-level throwball competition conducted by Rajiv Gandhi Institute.
Timeline
Senior Database Administrator
Cognizant Technology Solutions
01.2023 - Current
Database Administrator
Tata Consultancy Services
06.2019 - 12.2022
BE in Electronics and Communication Engineering -
Rajalakshmi Engineering College
HSC - Bio- Maths
MLM Mamallan matric higher secondary school
10th - General
MLM Mamallan matric higher secondary school