Makesh Babu Nattamai Athmalingam
Oracle DBA, PostgreSQL DBA, AWS Cloud Engineer, Azure DevOps
Chennai
Summary
Dynamic and results-driven Oracle Database, AWS Cloud engineer, Azure DevOps with over 17+ years of IT industry experience, specializing in systems administration, change management, software configuration management, build and release management, and process engineering. Expertise in PostgreSQL database administration complements a solid foundation in web development using PHP, MySQL, Oracle, Joomla, WordPress, and CodeIgniter. Proven ability to deliver 24/7 production DBA support while effectively applying various SDLC methodologies, including Agile and Waterfall. Strong background in incident and service management through ITIL processes underscores a commitment to operational excellence and continuous improvement.
Professional consultant equipped to deliver impactful solutions and drive success. Strong analytical skills, strategic thinking, and adept at managing client relationships. Highly collaborative, adaptable, and focused on achieving optimal results. Proficient in project management, data analysis, and business process improvement.
Overview
18
18
years of professional experience
4
4
Certifications
4
4
Languages
Work History
Associate Consultant
TATA Consultancy Services
05.2016 - Current
- Currently working at TATA Consultancy Services, India, from May 2016 to the present.
- Customer and Location: AXA Konzern AG, Germany.
- Increased system reliability with the development of comprehensive backup and recovery plans.
- Enhanced database performance by optimizing query design and indexing strategies.
- Installed and configured 12c/19c RAC databases and storage servers.
- Exposure to cross-platform migrations and performed documented data migration from Oracle database to PostgreSQL/Aurora in AWS Cloud SCT and DMS services.
- Executed data migration projects, transferring data from legacy systems to modern platforms for various clients.
- Collaborated with cross-functional teams to develop scalable, high-performance database architectures.
- Led the migration of a large on-premises Oracle DB to a MongoDB database on the AWS platform using AWS Database Migration Service (DMS), resulting in a reduction of infrastructure costs and improved performance.
- Developed and implemented data mapping strategies to ensure accurate data transfer.
- Managed and monitored PostgreSQL databases in PgAdmin.
- Administering and maintaining the PostgreSQL database for critical applications, ensuring high availability and performance.
- Experience in Oracle Data Guard setup and Active Data Guard setup.
- Installed and configured GoldenGate Active-Passive and Active-Active.
- Implementing RMAN backup, query tuning, AWR/ADDMAH report generation, and PSU patch updates in Oracle 19c via Grid Control and manually.
- Experience in performance tuning with OEM, SQL Tuning Advisor, SQL Profiles, and AWR/ADDMAH, and knowledge in PL/SQL (stored procedures, triggers, packages).
- Experience in tuning ERP jobs, time-consuming SQL queries, and restructuring object design for performance.
- Experience in automating, configuring, and deploying instances in AWS environments; also familiar with EC2/RDS through Terraform, CloudWatch, CloudFormation, and managing security groups on AWS. Migrated databases from on-premises to AWS Cloud (EC2/RDS).
- Amazon IAM service enables granting permissions and resources to users.
- Extensive experience in homogeneous and heterogeneous database migration from on-prem to private cloud (IBM – IaaS) and public cloud (AWS RDS).
- Included security groups, network ACLs, Internet Gateways, and Elastic IPs to ensure a safe area for the organization in the AWS public cloud.
- Created scripts in Python (Boto) that integrated with the Amazon API to control instance operations.
Oracle DBA
Verizon Data Services
12.2010 - 05.2016
- Worked at Verizon Data Services, Chennai, India, from December 2010 to May 2016.
- Reduced server downtime by conducting regular maintenance and implementing proactive monitoring systems.
- Conducted thorough analysis of existing systems to identify areas for improvement, resulting in significant cost savings and increased efficiency.
- Improved query response times through the creation of efficient stored procedures and views.
- Active-active to reduce latency based on the geographical location from where the user connects, load balancing. Set up alert monitoring for lag, locks, and network issues.
- Configured Oracle GoldenGate downstream integrated capture.
- Analyzing the Time Model statistics, wait event statistics, session and system statistics, active session history statistics, and high load SQL statistics for performance tuning.
- SQL tuning report for database query and instance tuning recommendations.
- Applying Oracle hints and SQL Profiles as a temporary fix to improve query performance.
- Recommending redesigning the DB objects to improve query performance, such as converting tables to partition tables, creating new indexes based on the tuning report, and performing Oracle defragmentation to improve queries where large DML (updates/deletes) changes resulted in fragmentation.
- Ensure the latest patches are applied for better performance and bug fixes.
- OEM setup to monitor and administer Oracle databases.
- Optimized database performance by redesigning architecture and implementing advanced indexing techniques.
Web Developer
First Page Software Services Pvt Ltd.
03.2009 - 11.2010
- Worked as a Web Developer at First Page Software Services Pvt. Ltd. in Chennai for PHP and MySQL applications from March 2009 to November 2010.
- Coded websites using HTML, CSS, JavaScript, and jQuery languages.
- Planned website development, converting mockups into usable web presence with HTML, JavaScript, AJAX, and JSON coding.
Web Developer
Pyramid Saimira Theatre Ltd.
03.2008 - 03.2009
- I worked as a Web Developer at Pyramid Saimira Theatre Ltd. At Chennai for PHP, MySQL applications from March 2008 to March 2009.
- Created web applications and components using PHP programming language.
- Developed responsive web designs, ensuring compatibility across multiple devices and platforms.
- Developed user-friendly web applications for seamless customer experiences.
Web Developer
Cheers Technologies Pvt. Ltd.
07.2007 - 03.2008
- I worked as a Web Developer at Cheers Technologies Pvt. Ltd. in Chennai for PHP, MySQL applications from July 2007 to March 2008.
- Troubleshot and resolved technical issues, providing timely support to clients and team members.
- Collaborated with cross-functional teams to design and implement new features for client websites.
Education
Computer Applications
Tamilnadu Open University
04.2001 -
Bachelor in Computer Applications - Computer Applications
Madurai Kamaraj University
01.2006
Skills
Agile
undefinedCertification
Oracle Certified Expert – Database performance tuning
Service Management
- Incident Management
- Change Management
- Problem Management
- Knowledge Management
- Capacity Management
- Process/Performance Improvements
Timeline
Associate Consultant
TATA Consultancy Services
05.2016 - Current
Oracle DBA
Verizon Data Services
12.2010 - 05.2016
Web Developer
First Page Software Services Pvt Ltd.
03.2009 - 11.2010
Web Developer
Pyramid Saimira Theatre Ltd.
03.2008 - 03.2009
Web Developer
Cheers Technologies Pvt. Ltd.
07.2007 - 03.2008
Computer Applications
Tamilnadu Open University
04.2001 -
Bachelor in Computer Applications - Computer Applications
Madurai Kamaraj University
Similar Profiles
Vrunda ChindhadeVrunda Chindhade
HR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services LimitedHR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services Limited
Sreya BasuSreya Basu
Procare Analyst at Tata Steel(Tata Consultancy Services)Procare Analyst at Tata Steel(Tata Consultancy Services)
Arun VArun V
Program Manager at Tata consultancy services | Financial Ombudsman ServicesProgram Manager at Tata consultancy services | Financial Ombudsman Services
Naimish AgnihotriNaimish Agnihotri
Assistant Delivery Manager at Tata Consultancy Services, Global Shared ServicesAssistant Delivery Manager at Tata Consultancy Services, Global Shared Services
Zaheer Syed.SZaheer Syed.S
Team Manager at GSR Global ServicesTeam Manager at GSR Global Services