Ganesh Bojan
Irving,TX
Summary
With 18 years of experience in IT, highly skilled DBA+Manager leading a team of 120 DBAs in ORACLE, MSSQL, SYBASE, MONGO and POSTGRESQL. Extensive knowledge and hands-on experience in database administration, including backup and recovery, patching, upgrades, security, and compliance. Excels in capacity planning, installations, upgrades, and migrations. Expertise extends to incident and change management using ITSM tools. Successfully implemented processes contributing to long-term business success and maintaining best-in-class SLAs. Scrum Master Certified professional.
Overview
17
17
years of professional experience
Work History
DBA Manager – Production DB Support Team
Wipro Technologies
04.2019 - Current
- Company Overview: Client: Citi bank
- Managing 24/7 database operations support for All sectors of bank
- Accountable for ITSM Service operations and service availability of databases
- Demand management, capacity management, Disaster Recovery & Business Continuity Planning
- Supporting RDBMS flavours - Oracle, Mssql, PostgreSQL,Mongo and Sybase databases
- Managing customer requirements and handling escalations
- Addressing potential or critical incidents on time and challenges
- Joining major incident call and involving teams/other stakeholders and solving issue
- Sending major incident communication to business stakeholders
- Analyzing risk and standardizing SOPs
- Preparing timelines for major incident and handling problem management call, providing RCA
- Weekly, monthly operational reports generation and represent with customer
- Resource management and project planning and invoice
- Mentor team and Initiating service improvement plan
- Managed and motivated employees to be productive and engaged in work.
- Enhanced customer satisfaction by resolving disputes promptly, maintaining open lines of communication, and ensuring high-quality service delivery.
- Reduced waste and pursued revenue development strategies to keep department aligned with sales and profit targets.
Project Lead
Wipro Technologies
11.2012 - 03.2019
- Company Overview: Client: Lloyds Banking Groups (LBG)
- Responsible for delivering the standards for the implementation of Oracle technologies and all supporting technical documentation and build processes
- Upgraded Oracle RAC, Data guard, and Restart and Standalone environment databases from version 11.2.0.3 to 11.2.0.4 and from 11g to 12C
- Prepared the base document for upgrade process and circulated to team for referring
- Supported in building new Automation tool called HP DMA in LBG environment to automate Oracle database binaries security patching activity
- Provision and configure the Oracle Database software, including testing and ability to work effectively with other infrastructure teams
- Formulate estate wide maintenance plans and supporting documentation
- Lead the creation of technical documentation and playbooks to be followed by the wider team
- Patching and maintenance of the Oracle Database Software
- Represent Oracle SPM team in conference calls with other stakeholders involved in maintenance of software and the change management process
- Work effectively with the wider Oracle team to ensure no impact to service
- Identify risks and identify and drive through service improvements
- The maintenance and updating of these standards are also the responsibility of the team ensuring that all latest PSU's and security fixes released by Oracle are included in new builds and the standards updated to reflect this
- Documented database standards and procedures, including software installations, upgrades and maintenance procedures
- Ensured timely delivery of critical deliverables by closely monitoring progress against milestones and adjusting plans as necessary.
Oracle DBA
TCS
03.2008 - 11.2012
- Company Overview: Client: AC NEILSEN IS (Infrastructure)
- Database installation, configuration, and oracle client installation
- Database upgrade (9i, 10g to 10gR2, 9i/10g to 11gR2)
- 10gR2 & 11gR2 RAC installation, patching, maintenance, and upgrade
- Clusterware installation, upgrade, and maintenance
- Performing RMAN backup, refreshing database through RMAN hot backup, performing all kind of recovery including specific schema/table/tablespace/block (BMR) level recovery by RMAN
- Index creation, analyzing, rebuilding, tables analyzed, gather statistics
- Dataguard creation, upgrade, and maintenance
- Analyzing AWR, ADDM, ASH reports, waiting events and having good experience in SQL tuning by taking explain plan/session trace/ORADEBUG 10046 event trace
- Establishment backup and recovery procedures using SQL and maintenance including hot and cold backups to support point-in-time recovery of database on data tapes or drives
- Manage/modify database security and database schema, creating users, granting privileges roles and profiles as needed
- Data migration using EXPDP/IMPDP of schema, tables, tablespace
- Provide assistance to development staff for issues relating to performance tuning and SQL creation
- Monitored tablespace size, resized tablespace, alert log, trace files, tkprof
- Liaising with application developers, system administrators and storage administrators as per need
- Trained junior DBAs in best practices for Oracle database management, improving overall team performance.
- Worked with customers and other third parties to support DBA functions.
Education
MCA -
Bharathidasan University
Kumbakonam04-2006
Skills
- Project Management
- Operations Management
- Customer Engagement
- Build Strong Relationships
- Analytical Skills
- Team collaboration
- Strategic planning
- Written Communication
- ITIL Implementation
- Lean Process Improvement
- Automation
- Oracle 9i/10g/11g/12c/23c
- Upgrade and Patching
- RAC
Visa Status
H1B work permit, 12/31/29
Timeline
DBA Manager – Production DB Support Team
Wipro Technologies
04.2019 - Current
Project Lead
Wipro Technologies
11.2012 - 03.2019
Oracle DBA
TCS
03.2008 - 11.2012
MCA -
Bharathidasan University
Similar Profiles
Sourav PalSourav Pal
Senior Software Engineer at Wipro Technologies, WiproSenior Software Engineer at Wipro Technologies, Wipro
Rintu Merin VargheseRintu Merin Varghese
Immigration Specialist at Wipro TechnologiesImmigration Specialist at Wipro Technologies
Sajin Madhavan SSajin Madhavan S
Machine Learning Engineer at Wipro TechnologiesMachine Learning Engineer at Wipro Technologies