Experienced IT professional with over 18 years in Oracle Database Administration (DBA). Specialized in installation, configuration, upgrades, patching, and cloning while ensuring data integrity and security through robust backup and recovery procedures. Expertise in optimizing database performance through meticulous monitoring, tuning, and space management. Committed to fostering a culture of continuous learning and improvement by mentoring team members, promoting open communication, and effectively resolving conflicts. Focused on emerging technologies to deliver high-quality programs and drive continuous improvement in IT operations, leveraging team strengths for maximum efficiency and coordinating with clients to provide tailored solutions that meet their needs.
Hi, I’m
RAJESH KUMAR BHARDWAJ
Oracle Database Lead
Bangalore
Summary
Overview
19
years of professional experience
6
Certificates
Work History
IBM INDIA PVT LTDBangalore
Business Manager
10.2021 - Current
Job overview
- Troubleshot database issues to create and resolve trouble tickets.
- Wrote and maintained technical and functional specifications to document database intentions and requirements.
- Participated in situation management of incidents to support database operations.
- Monitored and analyzed database activity to identify and prevent incidents and recommend performance improvements.
- Implemented capacity planning strategies, optimizing resource allocation and preventing system overloads.
- Streamlined backup processes, ensuring timely recovery in case of data loss or system failure.
- Reduced downtime by proactively monitoring and addressing potential issues with the Oracle Database system.
- Established working relationships across various departments to understand existing and emerging IT requirements.
- Assisted in migrating databases to newer versions or alternate platforms, minimizing disruption to business operations.
- Improved database performance by optimizing SQL queries and implementing indexing strategies.
- Developed custom scripts and PL/SQL procedures for efficient automation of routine tasks and data management operations.
- Provided technical support to end-users, troubleshooting database-related issues and offering guidance on best practices.
- Managed user accounts within the Oracle Database environment, granting appropriate permissions while adhering to security protocols.
- Provided resources and skill sets to support DBA functions for applications.
- Proposed database changes to ease monitoring and administrative effort.
- Conducted regular performance audits, identifying areas for improvement and adjusting configurations as needed.
- Reviewed database design to recommend enhancements or improvements.
- Served as a subject matter expert in meetings with stakeholders discussing project requirements related to Oracle Databases integration.
- Coordinated with vendors for hardware and software upgrades, ensuring timely implementation of new features and improvements.
- Collaborated with cross-functional teams to ensure seamless integration of Oracle databases with various applications.
- Liaised with system administrators to monitor, troubleshoot, triage and provide RCAs for incidents.
- Worked with customers and other third parties to support DBA functions.
- Led training sessions for junior team members on best practices in maintaining an efficient Oracle Database environment.
- Enhanced security measures by implementing data encryption and access controls for sensitive information.
- Maintained up-to-date documentation on database systems, ensuring accurate records of configurations, processes, and changes made over time.
- Supported application development teams by providing expert input on database design and optimization techniques.
- Participated in disaster recovery exercises, testing contingency plans to ensure minimal impact on business operations during emergency situations.
- Established effective communication channels between IT teams responsible for managing different aspects of the Oracle Database infrastructure.
- Modified databases to meet needs and goals determined during planning process.
- Set up and controlled user access levels across databases to protect important data.
ORACLE INDIA PVT LTDBangalore
PRINCIPAL SOFTWARE ENGINEER
02.2011 - 10.2021
Job overview
- Engaged in three primary responsibilities: SR support, GCS support for premium customers, and support for Oracle Database, Core DB, and Exadata customers.
- Monitoring database RAC performance issues, RAC node eviction issues, data migration issues, Oracle database patching and installation issues, Data Guard and upgrade-related issues, and ORA-600/ORA-7445/ORA-4030 errors.
- Hang Analysis and Analysis of System State Dumps. Data Guard switchover/failover issues.
- Performance assessment of customer environments. Conducting an analysis of AWR reports over a period.
- Analyzing wait trends, memory, and init.ora parameters.
- Migration of the database from one server to the other.
- Build a physical standby and cascaded standby (RMAN duplicate) using XTTS to transport data across endianness.
- Increased customer satisfaction rates through diligent collaboration with cross-functional teams on feature development and bug resolution.
- Mentored junior engineers to strengthen their technical skills and improve overall team efficiency.
- Configuring replication on the target export/import of the database.
- Conversion from standalone to RAC.
- Applying upgrade patches, maintenance, and interim patches on all the databases.
- Applied PSU on a standalone test environment using opatch, and the same PSU (grid and RDBMS patching) on the production cluster using opatch auto.
- Refreshing dev and test instances with data from production on a regular basis.
- Installation and configuration of 12c/19c container databases on standalone servers and clusters on Windows and Unix platforms.
- Upgraded multiple single-instance databases and grid infrastructure from 11gR2 to 12cR1 and 19c.
CAPGEMINI INDIA PVT LTDBangalore
CONSULTANT
11.2009 - 02.2011
Job overview
- Played a key role in designing the monitoring system using open-source tools, namely Nagios, MRTG, Cacti, and OpenNMS.
- I took care of the installation, configuration, and management of over 1,000 servers running various operating systems for monitoring the installation of supported Linux guest operating systems on the ESX server.
- Performance monitoring of servers, and providing application support for Oracle databases, RPM installations, and vSphere administration of virtual guests.
- Managed client relationships through regular check-ins and updates on project progress.
- Collaborated with cross-functional teams to successfully deliver comprehensive solutions for clients.
COOPERP SOLUTIONSBangalore
SERVER ADMINISTRATION
01.2009 - 09.2009
Job overview
- Primarily accountable for the installation and management of Active Directory, Domain Controller, DHCP, and Windows 2003 Server, as well as MS SQL Server 2005.
- Managed and supported servers in a Microsoft Windows and Linux environment to ensure system backups and performance are optimal.
- Administration, maintenance, development, and implementation of policies and procedures for ensuring system security and integrity.
- Installation of patches and updates, backup and restore procedures, configuring the network in Linux, etc.
- Evaluated third-party tools and software to determine their suitability for enhancing the efficiency of Windows Server administration tasks.
- Developed detailed documentation outlining server administration procedures, enabling efficient knowledge transfer among team members.
EPILLARS TECHNOLOGIES PVT LTDBangalore
SR TECHNICAL SUPPORT ENGINEER
10.2007 - 01.2009
Job overview
- Managed the installation, configuration, and management of Parallels Virtuozzo Containers and Communigate Pro on a Linux server.
- Handled firewall and web server (Apache) support for clients during the proof of concept (POC).
- Conducted a feasibility study for the enterprise wireless LAN.
- Increased customer satisfaction by efficiently resolving technical issues and providing exceptional support.
- Collaborated with sales teams to provide pre-sales technical assistance, helping secure new business deals and increase revenue.
KAVACH NETWORKS PVT. LTD.Bangalore
ASSOCIATE CONSULTANT
11.2006 - 10.2007
Job overview
- Engaged in a wide gamut of responsibilities involving Linux OS installation, such as CentOS, Red Hat, Ubuntu, etc. As per the client’s requirement.
- Mail server setup with Postfix as the MTA, with TLS and domain keys. AMAVISD is used for spam filtering with two antivirus scan engines, CLAMAV and AVSCAN.
- Enabling RBL on the mail server.
- Implementing incoming/outgoing DKIM.
- Installation and Configuration of Cyrus-SASL with TLS for SMTP Authentication.
- Courier IMAP configuration for POP, POPS, IMAP, and IMAPS.
- Installation of the Apache web server, MySQL, and PHP for LAMP development; setup of the Linux server as a gateway, firewall, and VPN server at the client's location.
- Firewall configuration as per company requirements using iptables.
Education
BITS, Pilani
M. Tech from Computer Science and Information Technology
University Overview
Biju Patnaik University of Technology, Rourkela
Master from Computer Application
University Overview
Delhi UniversityNew Delhi, India
Bachelor of Science from Mathematics
University Overview
Skills
Database Management
IT Infrastructure
People Management
Database Administration
Container Database
Database Migration
Certification
ITIL 4 Foundation
Timeline
Business Manager
IBM INDIA PVT LTD
10.2021 - Current
PRINCIPAL SOFTWARE ENGINEER
ORACLE INDIA PVT LTD
02.2011 - 10.2021
CONSULTANT
CAPGEMINI INDIA PVT LTD
11.2009 - 02.2011
SERVER ADMINISTRATION
COOPERP SOLUTIONS
01.2009 - 09.2009
SR TECHNICAL SUPPORT ENGINEER
EPILLARS TECHNOLOGIES PVT LTD
10.2007 - 01.2009
ASSOCIATE CONSULTANT
KAVACH NETWORKS PVT. LTD.
11.2006 - 10.2007
BITS, Pilani
M. Tech from Computer Science and Information Technology
Biju Patnaik University of Technology, Rourkela
Master from Computer Application
Delhi University
Bachelor of Science from Mathematics