CHARAN KUMAR MG
Summary
High performance professional with extensive experience in database administration with close to 8 years of experience in designing and implementing database solutions. Goal-oriented team player succeeds working with various colleagues and clients by maintaining communication. Motivated with keen analytical, problem-solving and task management abilities.
Overview
8
8
years of professional experience
1
1
Certification
Work History
Associate Senior Database Administrator
Oracle Cerner Corporation
05.2019 - Current
- RAC over ASM environment on oracle 11g, Startup/Shutdown RAC Database, Managed OCR and Voting disk backups and Migration from one Storage to another.
- Managed daily backup/recovery through RMAN or Export & Import.
- Implemented robust backup strategies to safeguard essential data against potential loss or corruption incidents.
- Built databases and table structures for web applications.
- Handled performance issues related to CPU utilization, I/O Contention, Enqueues, blocking sessions, and tablespace issues.
- Played an instrumental role in Monitor, Optimize & Performance tuning of Production Databases using Oracle Enterprise Manager, SQL Scripts and Database views.
- Effectively managed, monitored and resolved the archive log gaps between production and standby. Precisely managed the Logical backups using Data pump utilities.
- Managed tablespace and data file sizing as well as monitoring database usage and growth.
- Evaluated the performance of Database using utilities like AWR reports and OEM 13C.
- Various production improvement workplans to fix the problems proactively for multiple clients.
- Optimized database performance by conducting regular maintenance and implementing best practices.
- Provided expert advice on database design, leading to improved efficiency and scalability in new projects.
- Conducted tests to identify issues and make necessary modifications.
- Coordinated with project management on database development timelines.
- Reduced downtime during system upgrades by planning and executing seamless migration processes.
- Adhered to set schedules to test databases for flaws and reduce downtime.
- Set up and controlled user access levels across databases to protect important data.
- Collaborated on cross-functional teams to integrate various databases and optimize overall system performance.
- Facilitated strong communication between IT departments and business stakeholders through clear reporting on key metrics related to database health and performance indicators.
- Served as a mentor to junior administrators, fostering professional development and skill growth within the team.
- Used strong analytical and problem-solving skills to develop effective solutions for challenging situations.
- Proven ability to develop and implement creative solutions to complex problems.
- Self-motivated, with a strong sense of personal responsibility.
Oracle Database Administrator
4SPL Technologies India Private Limited
03.2016 - 09.2018
- Involved in Installation and configuration of Oracle Database and configured client machines.
- Monitored and resolved the archive log gaps between production and standby.
- Performed the conversion of the client machine as a server as per the client requirements.
- Improved database performance by optimizing SQL queries and implementing indexing strategies.
- Created users and managing the User quota over User default tablespace and temporary tablespace.
- Maintained Physical Standby Database. Provided support for 57 depots across the state.
- Monitored and analyzed database activity to identify and prevent incidents and recommend performance improvements.
- Reviewed database design to recommend enhancements or improvements.
- Streamlined backup processes, ensuring timely recovery in case of data loss or system failure.
- Assisted in migrating databases to newer versions or alternate platforms, minimizing disruption to business operations.
- Coordinated with vendors for hardware and software upgrades, ensuring timely implementation of new features and improvements.
- Effective Backup and Recovery strategies for depot database using expdp/impdp, cold and hot backups. Weekly physical backup of whole database.
- Evaluated the performance of Database using utilities like STATSPACK and AWR reports.
- Refresh non-production database from production database using hotbackup or cold backup.
- Maintained production, development, test databases which includes tablespace space management, user creation, privileges, roles etc.
- Participated in disaster recovery exercises, testing contingency plans to ensure minimal impact on business operations during emergency situations.
- Liaised with system administrators to monitor, troubleshoot, triage and provide RCAs for incidents.
- Used critical thinking to break down problems, evaluate solutions and make decisions.
- Skilled at working independently and collaboratively in a team environment.
- Worked well in a team setting, providing support and guidance.
Education
Bachelor of Engineering Technology - Computer And Information Sciences
Visvesvaraya Technological University
Bangalore, INDIA05.2015
Skills
- Real Application Cluster
- Disaster Recovery
- ASM
- Patch Maintenance and Monitoring
- Database upgrades
- Linux, AIX and Windows Server
- Oracle 11g and 19c
- Database Performance Tuning
- Backup and Recovery Strategies
- Database Troubleshooting
- Performance tuning
Accomplishments
- Achieved 100% result by completing successful upgrades for more than 100+ production and non-prod environments with accuracy and efficiency.
- Tested databases to identify and resolve relocating singleton 19c databases between the cluster nodes.
- Collaborated with internal and external teams for the implementation of out of place patching activity.
Certification
OCI Foundation Certificate
Timeline
Associate Senior Database Administrator
Oracle Cerner Corporation
05.2019 - Current
Oracle Database Administrator
4SPL Technologies India Private Limited
03.2016 - 09.2018
Bachelor of Engineering Technology - Computer And Information Sciences
Visvesvaraya Technological University
OCI Foundation Certificate
Similar Profiles
Hannah LarkinHannah Larkin
Senior Requirements Analyst at Oracle Cerner CorporationSenior Requirements Analyst at Oracle Cerner Corporation
ANDY BEUGELSDIJKANDY BEUGELSDIJK
Configuration Test Analyst at Cerner/Oracle CorporationConfiguration Test Analyst at Cerner/Oracle Corporation
Venkatesh KVenkatesh K
Associate Software Engineer at ORACLE CERNER CORPORATIONAssociate Software Engineer at ORACLE CERNER CORPORATION