Balbir Singh Saggu
Career Objective
To work in a prosperous company offering a position in a quality environment, where functional & technical skills are
shared and enriched so I can learn more and use my skills to contribute towards the growth and prestige of the
organization.
Summary
• Oracle DBA with 8-10 years of experience in Database Administration.
• Proficient in Oracle 9i, 10g, and 11g installation, administration, monitoring, performance tuning, database backup,
and recovery.
• Ability to work on triage calls for urgent issues and successfully solving those before they become incidents.
• Good understanding of the fundamentals of Oracle DB Architecture and its processes.
• Complete understanding of ITIL processes used for incident management and change management.
• Involved in database refresh, installation, patching, and Data Guard.
• Hands-on experience in database creation and configuration.
• Backup & Recovery and database maintenance for consistency in production environments.
• Managing schema using Data Pump and import-export.
• Error detection using alert logs and trace files.
• DB replication and standby configuration.
• DG broker configuration for Data Guard and Fusion Middleware installation.
• Creating triggers, wallets, and various other DB configurations.
• Agent installations and associated prerequisites.
• OEM 12c configuration and OSB Cloud module installation.
• Role switchover and database upgrades to higher versions.
• Channelizing backup and recovery strategies using RMAN.
• Storage Grid configuration using ASM as storage media.
• Multi-tenant architecture and clustering of databases.
• Maintaining RAC databases for high availability.
• Query analysis and performance tuning.
• Maintaining AWR and ADDM reports.
• Manually upgrading databases using SQL scripts.
• Golden Gate processes and capture methods.
• Managing multiple instances using Oracle Enterprise Manager.
• Possess strong communication and problem-solving abilities.
• Good knowledge of JAVA programming and its concepts.
• Knowledge of automation tools like Jenkins and Chef.
• Basic understanding of PostgreSQL database, Exadata Architecture, and Oracle DB Migration.
• Experience with Oracle Cloud Infrastructure and Oracle Maximum Availability Architecture.
• Well-versed with the basics of AWS/cloud infrastructure.
• Database migration experience from on-prem Oracle DB to AWS cloud.
• Oracle Apps DBA experience with hands-on R12.2 experience.
• ADOP patching/cloning experience.
• Collaboration with application development teams to support Oracle Application on R12.
• Familiar with Agile (Scrum/Kanban) process and experience on program management software, Jira.
Certifications
• IBM Certified – Data Science Level-1
• Microsoft Azure AI Engineer Associate
• Great Learning – Data Visualization using Tableau
• Techgig – C++, Python
• Oracle University Training Class
• Oracle Certified Java SE7 Programmer
• AWS Training Certifications
• Udemy – GenAI
Technical Competencies
• Ticketing Tools: Jira, Confluence, UST, ServiceNow, UBS My Hub, Central Station, Espresso, BMC Remedy, Azure
DevOps
• Operating Systems: Linux, Unix, Windows, Citrix VDI, Solaris, AIX
• Databases: Oracle 9i, 10g, 11g, 12c, 19c, Oracle FMW, PostgreSQL, DB2, MySQL, MS SQL, MongoDB
• Tools & Technologies: RMAN, Data Pump, Streams, OEM 12c, Golden Gate, Fusion Middleware, ASM, RAC,
Exadata, ZDLRA, Jenkins, Docker, IBM Cloud, Microsoft Azure AI, DevOps
• Enterprise Grade databases: Aurora, Redshift
• Automation/Coding: PL/SQL, Shell, Java, C, C++, Python
• DB/Server Monitoring: OEM, Grid Control, OpsManager, Solarwinds
Professional Experience
• Amdocs – DB Specialist (March 2024 – November 2024)
• HCL Technologies Ltd – Technical Specialist (September 2023 – March 2024)
• Infosys – Senior Software Consultant (May 2021 – September 2021)
• NIIT Technologies – Senior Associate (June 2019 – January 2021)
• Tata Consultancy Services – Associate (September 2017 – July 2018)
• IBM India Pvt Ltd – Senior Operations Professional (March 2016 – September 2017)
• HCL Technologies – Senior Analyst (January 2014 – March 2016)
Educational Qualifications
• University Canada West, Vancouver, Canada – MBA in Business Analytics – 2022 (CGPA: 3.7)
• Inderprastha Engineering College, Ghaziabad – B-Tech in Electronics & Communication – 2013 (63%)
• City Montessori School, LDA, Lucknow, India – Indian School Certificate – 2009 (91%)
• City Montessori School, RDSO, Lucknow, India – Indian Certificate of Secondary Education – 2007 (88%)