Kamlesh Shrivastava
New Delhi
Summary
IT professional with 20 years of experience, including over 10 years as a Database Administrator in the Indian Air Force. Proficient in Oracle (11g–19c) and PostgreSQL, with a strong track record in performance tuning, backup and recovery, and automation. Led teams to significantly improve operational efficiency and minimize infrastructure downtime. Dedicated to ongoing professional development and implementation of advanced database and network solutions.
Overview
20
20
years of professional experience
1
1
Certification
Work History
Oracle Database Administrator Team Lead
Indian Air Force
06.2021 - Current
- Oversaw installation, configuration, and maintenance of Oracle database software across multiple environments.
- Deployed patches and upgrades on existing installations as per best practices guidelines.
- Provided 24x7 on-call support for critical incidents related to databases.
- Managed database structures, tablespaces, schemas, and users to ensure data integrity and security.
- Designed A/RDG solutions including Oracle Data Guard and standby databases for enhanced reliability.
- Established and tested failover and failback procedures to support business continuity.
- Conducted performance analysis to identify bottlenecks and optimize database efficiency.
- Implemented tuning strategies like indexing and partitioning to enhance query execution.
Senior Oracle Database Administrator
Indian Air Force
10.2017 - 05.2021
- Developed and maintained robust backup and recovery strategies to minimize data loss and ensure high availability.
- Conducted regular backups and recovery tests to validate system recoverability.
- Managed database systems, including Oracle, MySQL, and PostgreSQL, ensuring stability and performance.
- Implemented database design modifications based on evolving business requirements.
- Performed routine maintenance tasks, including updates, patches, and system checks for optimal performance.
- Automated repetitive tasks using SQL and Shell scripting to enhance efficiency.
Oracle Database Administrator
Network Operation Center(IAF)
08.2015 - 10.2017
- Assisted in routine database maintenance tasks such as backups, updates, and patches to ensure system reliability and security.
- Monitored database performance and assisted in identifying potential issues.
- Contributed to database design tasks, including assisting with schema modifications and data model adjustments based on senior team guidance.
- Assisted in implementing and maintaining basic security measures, including user access controls and permissions.
- Monitored database performance and tuned accordingly.
- Performed backup and recovery operations using RMAN utility.
Technical Support Engineer
Indian Air Force
06.2005 - 07.2015
- Documented technical issues and solutions to enable tracking history and maintain accurate logs.
- Installed and maintained hardware and computer peripherals to store tangible components.
- Upgraded operating systems and computer software to perform compatibility with programs.
- Helped streamline repair processes and update procedures for support action consistency.
- Resolved complex technical problems through root cause analysis techniques.
- Provided technical support to customers by troubleshooting and resolving hardware and software issues.
Education
MBA - Information Technology And Finance
Swami Vivekanand Subharti University
Meerut05-2025
Master of Computer Applications - Computer Science
Jain University
Bangalore 05-2023
Bachelor of Science - Electronics
IGNOU
New Delhi06.2011
Diploma in Electrical and Electronic Engineering -
IGNOU
New Delhi05.2011
Skills
- Linux and Windows server management
- Shell scripting and automation
- Incident resolution and troubleshooting
- Data management and optimization
- Oracle database administration
- Performance tuning and monitoring
- Snowflake analytics and reporting
- Backup and recovery solutions
- Disaster recovery planning
- Patch management strategies
- Team leadership and collaboration
- Database technologies: Oracle 11g/12c/19c
- PostgreSQL (v12/13)
- Tools: SQL Developer, pgAdmin, TOAD
- Replication technologies: Oracle GoldenGate
Affiliations
All India Oracle Users Group, Delhi, Part of the group which brings people together to know the latest advances in Oracle community.
Accomplishments
- Led major Oracle database upgrade: Successfully upgraded the Indian Air Force’s largest operational database from Oracle 12.1c to 12c R2 and subsequently to 19.21c with minimal downtime, achieving this in-house for the first time without outsourcing.
- Ensured uninterrupted nationwide recruitment operations: Delivered a zero-disruption Agniveer recruitment process by developing and managing an in-house application with real-time data replication using Oracle GoldenGate between a standby and production database.
- Optimized operational efficiency: Automated key workflows to reduce processing time by 4 hours daily, enhancing productivity and reducing manual intervention.
- Maintained high availability and resilience: Achieved 99.99% uptime across all IAF data centers, and successfully defended critical systems against simulated cyberattacks during national-level Red Force IT exercises
Certification
- AWS Solutions Architect – Associate
- Cloud Computing, IIT Kharagpur
- Oracle Autonomous Database Cloud 2022 Certified Professional
- AGILE Methodology, Cognizant
- Information Security for Leaders, Skillsoft
- Oracle 12c Database: SQL Fundamental, Hacker Rank
- Oracle Cloud Infrastructure Certified, Oracle
- Programming Foundation of Database, LinkedIn
- Red Hat Certified Architect: DevOps
- Leadership Tips, Tactics, and Advice: LinkedIn
- Agile Project Management with Jira Cloud: LinkedIn
Personal Information
Projects
Upgradation of Oracle 11g database to Oracle 12c with Data guard Disaster recovery site configuration Upgradation of Oracle 12c to Oracle 12c R2 with data guard Implementation of Oracle GoldenGate for exchange of data through API MySQL Disaster Recovery Configuration Weblogic 12c cluster configuration and implementation with transparent application failover Configuration of Mail and Messenger Server. Upgradation of Oracle 12c R2 to Oracle 19c with data guard Online Complaint System with MySQL DB Virtualization Infrastructure Deployment
Awards and Honors
Commendation of Air Officer Commanding (AOC) , Coimbatore 2024
Commendation for Best Automation Unit by GOV of India (PM Shri Narendra Modi) 2017
Best Air warrior (Station Commander) 2017
Commendation of Air officer Commanding (AOC) NOC Mumbai (2015)
Recommendation for Chief of Air Staff Commendation, NOC Mumbai (2012)
Languages
Hindi
First Language
Timeline
Oracle Database Administrator Team Lead
Indian Air Force
06.2021 - Current
Senior Oracle Database Administrator
Indian Air Force
10.2017 - 05.2021
Oracle Database Administrator
Network Operation Center(IAF)
08.2015 - 10.2017
Technical Support Engineer
Indian Air Force
06.2005 - 07.2015
MBA - Information Technology And Finance
Swami Vivekanand Subharti University
Master of Computer Applications - Computer Science
Jain University
Bachelor of Science - Electronics
IGNOU
Diploma in Electrical and Electronic Engineering -
IGNOU
Similar Profiles
WING COMMANDER SANJEEV SINGHWING COMMANDER SANJEEV SINGH
Chief Security Officer at AIR FORCE STATION AGRA, INDIAN AIR FORCEChief Security Officer at AIR FORCE STATION AGRA, INDIAN 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)
NIRMAL BAKSHINIRMAL BAKSHI
Helicopter Pilot at Indian Air ForceHelicopter Pilot at Indian Air Force
Rajesh KumarRajesh Kumar
Flight Engineer at Indian Air ForceFlight Engineer at Indian Air Force
NIRMALENDU BARDOLOINIRMALENDU BARDOLOI
Product Release Manager at Sapiens TechnologiesProduct Release Manager at Sapiens Technologies