anil joshi
Services provided: Oracle SQL , Oracle E-Business Suite , Oracle
About anil joshi:
Energetic and highly skilled IT professional with rich and solid 16 years technical experience in Oracle Technology. Very rich practical technical expertise in L3/ L4/L5 support for Oracle Products - Oracle Engineered Systems, Database, fusion middleware, Oracle ERP, OCI.
New Solutions, existing enhancement, fixing current issues thru technical expertise, estimation, procurement, hardware setup, installation for Oracle products (DC support and configurations). Leaded huge projects for hardware refresh/migration/currency upgrade. Leaded solutions implementation work till hand over to operations.
Cost effective solutions for short and long-term business goals
Headed Oracle practice with 20+ team members.
Experience
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.
Education
Oracle Exadata Certification
Post graduate diploma in Business administration
Professionals offering similar services to those of anil joshi
Professionals in the same Technology / Internet sector as anil joshi
Professionales offering Oracle SQL services
Professionales offering Oracle E-Business Suite services
Professionales offering Oracle services
Professionals from different sectors near Brampton, Ontario
Other users who are called anil
Jobs near Brampton, Ontario
-
Nurse Specialized in Wound, Ostomy and Continence
Found in: beBee S2 CA - 5 days ago
Saint Elizabeth Health Care Mississauga, Canada Part timePosition Summary: · As a member of the Wound Ostomy Continence (WOC) Team in the Mississauga, Halton, and Central West area, you will provide specialized holistic assessment and management as an interprofessional team member to meet the needs of individuals/families with ostomies ...
-
Remote Camp Steward
Found in: beBee S2 CA - 3 weeks ago
Impala Canada Ontario, Canada Freelance, Full timeWho We Are: · Impala Canada is the owner and operator of the Lac des Iles Mine, located 90 minutes northwest of Thunder Bay, Ontario. In operation for 30 years, the LDI Mine is one of only two known pure palladium sources in North America. Palladium contributes to a cleaner globa ...
-
business consultant toronto
Found in: Talent CA C2 - 2 days ago
Management Solutions, S.L Toronto, CanadaCanada BUSINESS CONSULTANT TORONTO Toronto / Graduate / Number of vacancies: 5 · You will be working in key projects for leading organizations in the strategy, commercial effectiveness, transformation: organization and processes, risk management and control and marketing, financ ...