Results-driven IT professional with 20 years of experience in the Indian Air Force. Deep expertise in Oracle Database Management, including performance enhancement, Upgrade Planning, and Data Guard implementation. Skilled in streamlining Production Databases with resource plans and optimizing performance using AWR/ASH reports to achieve cost reductions. Proficient in Full-stack development, Network Security, and CI/CD. Demonstrated leadership in managing critical IT infrastructure and projects. Strategic Leader with experience in team management, fostering collaboration, ensuring clear communication, and providing guidance to achieve project goals while maintaining a positive work environment.
Hi, I’m
Pramod M Nair
Kochi
Summary
Overview
20
years of professional experience
13
Certification
Work History
Air Force Record Office
Principal Database Administrator
01.2017 - 06.2025
Job overview
- Company Overview: Indian Air Force
- Led a team of dba, network professionals and developers for upkeep of data centre and 200+ critical applications for air force
- Implemented A.I Chat Bot using Ollama on premise with integration to Oracle 23ai using vector search capability in a RAG setup for Airforce Human Resource Policies and provide personalised answers.
- Managed Production oracle database and data guards at local and remote data centres.
- Implemented log monitoring using Splunk for servers virtualised using VMware and 600 plus windows clients.
- Implemented local data guard and remote data guard for disaster recovery
- Designed API services using Oracle Rest Data Service for data exchange pan air force environment.
- Lead and implemented upgradation of production database with data guards with minimum downtime from 12c-to-12c R2 and further to 19c release 24 resulting in cost benefit of more than 60 lakhs for this was awarded the commendation by chief of air staff in oct 2024.
- Implemented hardening of web servers and successfully defended applications during various red team exercises
- Improved query performance of the production database by 80% by streamlining process flows and data structures.
- Implemented Oauth 2.0 security for API authentication
- Implemented Sophos and Fortinet NGFW using VPN, SSL tunnelling for securing data centres
- Designed and implemented Zabbix for monitoring of services
- Implemented GitLab Community edition for code repositories and CICD pipeline for devops
- Created data warehouse for data archival and designed data aging and expiration.
- Implemented oracle transparent data encryption and data redaction for securing sensitive data.
- Implemented oracle auditing for objects and created apex dashboard for easy monitoring
- Implemented enterprise backup veritas net backup, backup exec for backup solutions across the data centre.
- Designed and implemented backup strategies for minimal data loss.
- Designed and implemented crisis management plan for eventualities.
- Implemented Microsoft SCCM and later ECM for organisation with seamless patching and infrastructure baselines.
- Implemented Oracle Golden gate replication of data for Agni veer recruitment in air force
- Analysed SIEM and various monitoring system and created corrective actions for it.
- Improved overall system design with emphasis on security and reliability.
- Conducted training sessions.
- Indian Air Force
Education
Bharathiar UniversityCoimbatore, Tamil Nadu
MBA from Information Systems Management
01.2014
University Overview
Bharathiar UniversityCoimbatore, Tamil Nadu
BSc from Computer Science
01.2007
University Overview
Skills
- Oracle Database Administration
- SQL
- PL/SQL
- Database Performance Tuning
- AWR Reports
- ASH Reports
- SQL Tuning Advisor
- Data Guard
- Database Upgrades
- Resource Planning
- Index Design
- Maintenance Window Configuration
- Optimization
- Oracle Forms
- Oracle Reports
- Oracle BI
- Oracle APEX
- PHP
- Reactjs
- Python
- Nodejs
- REST APIs
- Oracle ORDS
- OAuth
- API integration
- VMware Virtualization
- Server Management
- Disaster Recovery
- High Availability
- Fault Tolerance
- Scalability
- Monitoring
- Firewall Management
- VPN Configuration
- Web Application Filtering
- Network Security
- Splunk Log monitoring
- CI/CD
- GitLab
- Pipeline Development
- Deployment
- Linux
- Windows Server
- Aix
Accomplishments
Accomplishments
Upgraded biggest database of Air Force with minimum downtime from 12.1 to 12 R2 and subsequently to 19.21 . First time done in house by airforce without outsourcing.
Deployed Pan IAF API services for consumption by other agencies.
Conducted Agniveer recruitment without any disruption using in house application and with real time replication using golden gate to production database.
Deployed on premise gitlab server with cicd pipeline for web and Oracle forms and reports.
Certification
- Oracle Vector AI Search Professional, Oracle, 02/01/25
- Databricks Fundamentals, Databricks Academy, 02/01/25
- Oracle Cloud Infrastructure 2024 Generative AI Certified Professional, Oracle, 06/01/24
- Oracle Cloud Database 2023 Migration and Integration Certified Professional, Oracle, 08/01/23
- Oracle Cloud Fusion Analytics Warehouse 2023 Certified Implementation Professional, Oracle, 08/01/23
- Foundations of Project Management, Google, 06/01/23
- Oracle Autonomous Database Cloud 2022 Certified Professional, Oracle, 08/01/22
- Designing Data lakes on AWS, Coursera, 07/01/22
- Oracle Forms and Reports, NIIT, 03/01/17
- Oracle Certified Associate, NIIT, 02/01/17
- Microsoft Certified Systems Engineer - Windows Server 2003, Microsoft, 06/01/08
- Microsoft Certified Systems Engineer - Messaging, Microsoft, 06/01/08
- Microsoft Certified Professional, Microsoft, 05/01/08
Languages
English
Hindi
French
Malayalam
Awards
Awards
- Commendation by Chief of Air Staff (CAS), IAF, 10/08/24
- Commendation by Air Officer Commanding (AOC), AFRO, IAF, 10/08/22
- Commendation by Air Officer in Charge (AOC-IN-C), MC, IAF, 10/08/16
- Commendation by Air Officer Commanding (AOC), 24 ED, IAF, 10/08/16
- Best Air Warrior (Station Commander) 49 WG, IAF
Timeline
Principal Database Administrator
Air Force Record Office
01.2017 - 06.2025
Bharathiar University
MBA from Information Systems Management
Bharathiar University
BSc from Computer Science
Similar Profiles
Francisco DomondonFrancisco Domondon
Attached and Un Assign at Philippine Air Force Personnel Management Office, Philippine Air ForceAttached and Un Assign at Philippine Air Force Personnel Management Office, Philippine Air Force
Vidhu UnnikrishnanVidhu Unnikrishnan
Senior Non Commissioned Officer at Indian Air Force (Office of the Chief of Air Staff)Senior Non Commissioned Officer at Indian Air Force (Office of the Chief of Air Staff)
Alexander Cuellar-MorazaAlexander Cuellar-Moraza
Special Agent (Captain) at United States Air Force Office of Special InvestigationsSpecial Agent (Captain) at United States Air Force Office of Special Investigations
HITHA E BHITHA E B
Senior Power BI Developer at Difinity DigitalSenior Power BI Developer at Difinity Digital
ANJALY MARY VARUGHESEANJALY MARY VARUGHESE
Senior Quality Analyst at Muthootttu Infotech Pvt. Ltd.Senior Quality Analyst at Muthootttu Infotech Pvt. Ltd.