anil joshi

EXPERIENCE

Principal Database Engineer                           Rogers Communications-Canada

                                                                                            (Jan 2022 – till now)

• Leading member in database Engineering team

• New Oracle hardware and software solution for BSS stack (10 million budget)
• Supporting applications for large complex operations in databases – tuning and infra
• Month-end, release, critical days support for databases 
• Defining and creating policies & guidelines 
• PoC’s for performance & high availability environments
• Migration and upgrade of databases near to 5 Petabytes

• Database infra solution for mainframe replacement (SDM)

• Design, estimate and creation of highly scalable Postgres database environment 
• Optimizing batch jobs and ad hoc runs – conversions from mainframe 
• OS/Storage configurations optimization 
• Postgres parameters optimization 
• Backup and recovery setup 

• Major Oracle Engineered Systems hardware refresh

• Hardware estimation – Hardware projection for procurement according to current 

           systems and future growth 

• New hardware design – Multiple physical clusters according to Environment & criticality
• Hardware setup – gathering requirement IPs, switches, cables, ports etc.
• Configuration – creating OEDAs according to clusters for Oracle to implement 
• Operation readiness – integrating with OEM, ZDLRA, CMDB, SNOW, ASR Gateway server etc.
• Tuning databases – SQLs/Codes/Infra

• High availability setup to planned/un-planned downtimes and long patching windows

• GDS infrastructure setup 
• Data guards/Observer
• Workload balance of databases in new infra
• Golden gate requirement gathering and setup

• Database migration to new hardware and version upgrade (large scale project – 1800 + DBs)

• Creating technical plans of migration & upgrade for technical team
• Integration with HA during migration & upgrade
• Cutover readiness and support
• Post GO-Live support (L3/L4)

• Latest version upgrade Oracle Key vault in new infra

• OKV installation in HA architecture 
• Installation of OKV clients at endpoints
• Upload all databases keys to OKV
• Handover to Operations team

Senior Database Engineer (Contract)                    Ontario Teacher Pension Planning

                                                                                                         (June 2020 – Dec 2021)

• Leading member in database Engineering team

• Database upgrades to 19c from 12c,11g 
• Migration of DR process for databases from storage replication to Data Guard 
• New custom security solution using Q-radar and service now for databases
• OEM 13.4 installation and migration from old version 
• Month end batch jobs optimization 
• Creating technical plans of migration & upgrade for technical team
• Integration with DR/HA during migration & upgrade
• Cutover readiness and support
• Post GO-Live support (L3/L4)

               Database Architect                                                 HCL Axon Canada (Multiple Clients) 

                                                                                                         (March 2016 – June 2020)

• Platform solution for database Environment – optimal hardware, OS, storage, database software planning and    implementation, cloud-oriented technologies adoption, cost reduction by automation, hardware and software optimization, budgeting.

• Guidance and advisory for solutions up to director and vice president levels of IT systems on scalability, performance subject to cost and budget

• Database support at L3/L4/L5 and architecture level - Oracle, Oracle Engineered Systems, MSSQL, MySQL, Mongo DB, and PostgreSQL

• Lead as technical manager and delivered transformation of 1000+ databases from legacy systems to oracle engineered systems in 2 years record time includes requirement gathering, designing, planning, business consensus, teams formation, project execution, milestones and operationalization till steady state.

• Performed manifold architectural changes in different OS, storage, application and database tier to get maximum performance, scalability and stability for critical days like Back to school, I-phone launch and boxing day

• Drive and lead multiple POC’s and stress testing’s successfully with required technical changes in databases for new product’s launch like Ignite TV

• Extensive involvement in client and vendor management – Rogers, Amdocs, Oracle, Microsoft, HP and other service providers 

• Performed multiple automations to bring stability in environment thru technical & process solutions 

• Training to cross functional teams

          Architect (Oracle Practice)                                                   HCL Technologies

                                                                                                          (Jan 2011 – March 2016)

As a part of HCL Center of Excellence for Exadata and database Technology 

Managing database multiple customers across globe for new technology and functionality adaptation in database environment to get maximum ROI and stability of business lines.

Database Performance improvements in Business process like Month Ends, critical days’ support, New product collaboration in existing system, Technical trouble shooting.

Resource optimization like CPU, Memory & storage – IO reduction thru code optimization, GC & other contention waits events reduction.

End to end Oracle engineered stack transformation (Exa Stack) – Foundation & design, implementation & migration, consolidation, performance & scalability. BAU operation stabilization.

Running systematic improvement program (SIP) for systems enhance performance and scalability. 

Mentoring & technical trainings to team members.

People Management –  strong experience in leading large team (up to 80 +), vendor management 

Stabilization & Scaling up systems to next level. 

POC’s on Engineered & Commodity systems.

Oracle Exadata Certification 

Post graduate diploma in Business administration