Balbir Saggu

Balbir Saggu

$30/hr
Oracle DBA | RAC, Data Guard, GoldenGate, Performance Tuning & Cloud Migrations
Reply rate:
100.0%
Availability:
Full-time (40 hrs/wk)
Location:
Lucknow, Uttar Pradesh, India
Experience:
8 years
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%)
Get your freelancer profile up and running. View the step by step guide to set up a freelancer profile so you can land your dream job.