Jimmy John

Experience

• 

  SKM

  Jan 2003 - Jul 2007

  Database Administrator
• 

  HCL Technologies

  Oct 2007 - Jun 2011

  - Responsible for the knowledge transition from a Singapore-based vendor to the HCL offshore for one of the major pharmaceutical companies in the US. - Managed database support for over 700+ Oracle databases in the EMEA Region. This included the installation of Oracle 10.2.0.5 binaries on Solaris and HP-UX platforms, creating databases, Quality Gate checks, and backup configurations using RMAN and OEM. - Patched the Oracle home using the Opatch utility to fix different kinds of bugs and coordinated with the UNIX and Linux teams for OS-level security patching. - Refreshed application schemas and tables from production to non-prod environments using exp/imp and data pump utilities, and cloned Oracle databases using RMAN. - Created users, roles, and profiles based on standard naming conventions and followed the client processes. - Attended GOC calls for production issues, developed corrective and preventive actions, and created SR with Oracle support for internal errors and bugs. - Troubleshooted production performance issues for OLTP and OLAP application databases. - Carried out SOX DB auditing and monitoring for critical table alerts, login failures, etc.- Provided 24/7 on-call support for production databases in result-oriented and time-critical environments. - Documented the processes and Oracle engineering standards specific to the client and trained the team members. - I was responsible for service level management for the EMEA database group and monitored database alerts from OEM, backup failure, and availability checks for production databases. - Implemented the resource group for better utilization of CPU resources among databases in shared database servers. - Set up ACL/UTL MAIL in the database per the applications' requirements. - Interacted with other IT teams to promote and ensure compliance with Oracle database standards. - Carried out incident, asset, configuration, and change management using Mercury and BMC Remedy. Show less

  • Senior Consultant

    Oct 2008 - Jun 2011

  • Consultant

    Oct 2007 - Oct 2008
• 

  HCLTech

  Jul 2012 - now

  Roles and responsibilities: - Gathering infrastructure requirements, designing, developing, and implementing scalable cloud-based database solutions for various projects. - Establish and ensure that all databases meet standard requirements such as security, reliability, availability, and scalability. - Identify opportunities for optimizing database infrastructure and reducing costs in the AWS cloud. - Performing root cause analysis of all production-related database issues and implementing corrective and preventive actions. - Develop innovative solutions to complex business and technical problems. - Responsible for physically implementing databases, storage structures, and high-availability solutions, such as multi-AZ, replication, and disaster recovery solutions. - Manage, support, and maintain cloud database environments while adhering to architectural guidelines and policies. - Provide technical expertise and hands-on support in consolidating and migrating databases from on-premises to AWS cloud (EC2 and RDS). - Additionally, responsible for implementing Virtual Private Database (VPD) access control on integration databases to securely access market-specific data. - Interact with other IT teams to promote and ensure compliance with Oracle database standards. - Build application databases in EC2, RDS, and other cloud-native databases (MySQL, PostgreSQL, Redshift) in AWS. - Migrate Oracle databases to Redshift using DMS and SCT and migrate to RDS using data pump utilities. - Experience in continuous integration (CI) and Continuous Deployment (CD) environments with Build, Release, and Deployment.- Review DM changes and deploy them in various environments based on Sprint Release plans.- Responsible for managing DBA resources, planning, and utilizing them globally on various database tasks that are part of multiple project deliverables.- Create AWS Redshift Clusters for data warehouse applications and reporting tools. Show less Roles and responsibilities: - Involved in migrating Oracle data warehouse and local application databases from Germany, Italy, and Spain to a regional data center in Belgium as part of a data center consolidation project. - Migrated several databases in different character sets into AL32UTF8 and consolidated them into HP-UX, Linux, and Solaris servers. - Provided database L3 support for regional databases in EMEA on a 24/7 availability and support model. - Installed Oracle code trees and created OTLP and data warehouse databases for various projects. - Migrated databases from PA-RISC to Itanium and Linux servers as part of a platform modernization project. - My responsibilities also included DB build, upgrade, and patching of Oracle databases in HP-UX, Solaris, and Linux. - Decommissioned application databases and facilitated archiving of the DB using OPTIM. - Participated in Disaster Recovery Exercises for Class-A and Class-B mission-critical applications. - Involved in problem management of incidents, and RCA of all database-related issues in the EMEA Region. - Performed database duplication/cloning using RMAN and database refresh using Data pump utilities.- Performed performance tuning of various critical application databases using AWR, ADDM, EXPLAIN PLAN, SQL Monitoring, etc. to analyze and troubleshoot the issues. - Configured and implemented ASM and proficient in using ASMCMD and ASMLIB, Flash-Back Technology, and Log Miner. - Provided support as a Production Support DBA and application/Project DBA. - Performed Incident, Change, Configuration, and Problem Management using the BMC Remedy tool. - Prepared IQOQ validation documents for database installation, configuration, and operation.- Applied critical patch updates (CPU) released by Oracle quarterly based on the maintenance schedule following client processes.- Conducted in-depth technical problem analysis and resolution for Oracle databases and dependent applications. Show less

  • Sr. Project Manager/Technical Manager

    Jul 2022 - now

  • Project Manager/Technical Manager

    Jul 2016 - Jun 2022

  • Lead Consultant

    Jul 2012 - Jun 2016