Kamlesh Shrivastava
New Delhi
Summary
Results-driven IT professional with 20 years of experience in the Indian Air Force. Extensive expertise in Oracle database administration and disaster recovery. Background in Information Technology and Project Management. Successfully led teams and executed strategic projects to enhance operational efficiency and minimize critical infrastructure downtime. Over 8 years of hands-on experience excelling as a team leader. Utilizes effective communication and collaboration skills to resolve complex issues related to database performance and intricate network infrastructure problems. Enthusiastic about continuous learning, consistently updating skills and applying newfound knowledge in daily tasks. Firm believer that nurturing a passion for learning is the key to continual personal and professional growth.
Overview
20
20
years of professional experience
1
1
Certification
Work History
Solution Architecture Database
Indian Air Force
10.2021 - Current
- Developed conceptual, logical, and physical data models based on business requirements.
- Collaborated with stakeholders to design functional and technical specifications.
- Evaluated and selected appropriate database platforms based on project needs and scalability requirements.
Oracle Database Administrator Team Lead
Indian Air Force
06.2019 - 10.2021
- Oversaw the installation, configuration, and maintenance of Oracle database software across multiple environments.
- Managed database structures, tablespaces, schemas, and users, ensuring data integrity and security.
- Designed and implemented A/RDG solutions such as Oracle Data Guard, Real Application Clusters, or standby databases.
- Ensured failover and failback procedures were in place and tested for business continuity.
- Conducted performance analysis, identifying and resolving bottlenecks to optimize database performance.
- Implemented tuning strategies including indexing, partitioning, and caching for improved query execution.
Senior Oracle Database Administrator
Indian Air Force
10.2017 - 06.2019
- 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 and administered database systems (e.g., Oracle, MySQL, SQL Servers) in various environments, ensuring their stability and performance.
- Implemented database design changes and schema modifications based on evolving business needs.
- Performed routine database maintenance tasks, such as software updates, patches, and system checks, to ensure optimal performance.
- Automated repetitive tasks and maintenance activities using scripting languages (e.g., SQL, Shell scripting) for efficiency.
Oracle Database Administrator
Network Operation Center(IAF)
08.2013 - 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.
System and Datacenter Administrator
Network Operation center (IAF)
06.2011 - 08.2013
- Managed and maintained server infrastructure, including installation, configuration, and maintenance of operating systems (Windows Server, Linux, etc.).
- Monitored system performance, conducted regular system health checks, and applied updates and patches as required.
- Oversaw datacenter operations, including rack and stack, cabling, and hardware provisioning, ensuring efficient use of space and resources.
- Managed power, cooling, and environmental monitoring systems within the datacenter.
- Managed virtualization platforms.
Technical Support Engineer
Indian Air Force
06.2005 - 05.2011
- 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.
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
06.2011
Diploma in Electrical and Electronic Engineering - undefined
IGNOU
05.2011
Skills
- Skilled in troubleshooting errors
- Development of scalable solutions
- System performance monitoring
- Network security management
- Virtual private network configuration
- Web application security measures
- Risk management in cybersecurity
- Skilled in log performance monitoring
- Version control and automation skills
- GitLab expertise
- Pipeline process optimization
- Linux server management
- Expertise in Windows Server operations
- AIX operating system support
- Capacity planning
- Vulnerability remediation management
- Disaster recovery planning
- Shell scripting expertise
- Incident resolution coordination
- Data management practices
- Effective team engagement
- Time management
- Analytical skills
- Oracle database management
- PL/SQL development
- Query efficiency improvement
- Data Guard
- Database migration expertise
- Efficient resource management
- Scheduled maintenance and configuration
- Performance optimization
- Oracle Business Intelligence
- Oracle APEX database integration
- Python
- Proficient in RESTful services
- Proficient in Oracle ORDS
- Oauth implementation
- API implementation
- VM ware infrastructure management
- Proficient in server administration
- Crisis management solutions
- Redundancy implementation
- Golden Gate
- Snowflake analytics proficiency
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.
- Deployed enterprise-grade API services: Implemented Pan-IAF API services using Oracle ORDS on Oracle WebLogic Server, enabling secure and scalable data consumption by multiple external agencies.
- 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
Affiliations
All India Oracle Users Group, Delhi, Part of the group which brings people together to know the latest advances in Oracle community.
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)
Timeline
Solution Architecture Database
Indian Air Force
10.2021 - Current
Oracle Database Administrator Team Lead
Indian Air Force
06.2019 - 10.2021
Senior Oracle Database Administrator
Indian Air Force
10.2017 - 06.2019
Oracle Database Administrator
Network Operation Center(IAF)
08.2013 - 10.2017
System and Datacenter Administrator
Network Operation center (IAF)
06.2011 - 08.2013
Technical Support Engineer
Indian Air Force
06.2005 - 05.2011
Diploma in Electrical and Electronic Engineering - undefined
IGNOU
MBA - Information Technology And Finance
Swami Vivekanand Subharti University
Master of Computer Applications - Computer Science
Jain University ,Bangalore
Bachelor of Science - Electronics
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)
Rohit PajhalRohit Pajhal
Director Network Operations at Indian Air ForceDirector Network Operations at Indian Air Force
KRISHNA KUMAR SINGHKRISHNA KUMAR SINGH
Logistics, Supply Chain Management, Warehousing at Indian Air ForceLogistics, Supply Chain Management, Warehousing at Indian Air Force
Manvendra KumarManvendra Kumar
Manager- Finance & Costing at Genpact India Private LimitedManager- Finance & Costing at Genpact India Private Limited