Occupation:Database Administrator |
Location:San Diego, CA |
Education Level:Bachelor |
Will Relocate:YES |
Description
Experience Summary: * Established and managed on-site and offshore global IT departments (India, Costa Rica, USA, Canada and UK) to support multinational organizations across the globe. * Built and managed On-Site and Offshore teams in various projects involving multiple technologies that include Oracle Apps, Noetix views, Cognos Reports, MapR, Oracle MRO etc., -Comprehensive background & Good Functional understanding of various modules of Oracle Applications/Financials, MRP, Oil refinery Process apps, Impresa AMO, Media FLO Technologies. * Performed Strategic advisory roles related to value proposition, ROI analysis and business judgement in new software development, rollout strategies, Database upgrades, Critical Patch rollouts * Excellent technical, People management and customer relationship building skills have enabled building trust and customer satisfaction leading to successful delivery of global IT projects. * Strong hands-on functional and technical skills in Oracle Apps and MRP, Core DBA activities, BI, ETL, Internet related technologies, Oracle/MySQL databases and various flavors of UNIX operating systems and Windows environment. * Built a top-down metrics-driven IT organization which helped to boost productivity and improved customer satisfaction. * Configured and supported highly available Oracle/PervasiveSQL databases and MRO/ERP applications for several global organizations Key Individual Job Accomplishments till date * Installed and maintained different versions of Oracle databases, including 10g/11g/12c and other Oracle components. * Converted the MRP program in Pro*C to PL/SQL successfully. * Provided oracle DBA support the customers in performing day-to-day activities that include clones, backups, PITR restores, User Management, Password management, Data pump etc., * Developed solutions/scripts for various applications and implemented the same. * Developed Metadata model and trained the developers to create/convert reports from MRP system into Cognos reports technology. * Developed Check printing algorithm for AP module per the custom requirements. * Developed Packaged procedures and skeleton procedures/functions for the MRO development teams so that the development could be standardized and tuned for performance optimization * Successfully developed solution for integrating other databases Invoice processing in to Oracle Database using ETL * Setup TDE and implemented across the applications. Core Strengths: * Champion in cross-functional collaboration, team work, building effective teams and highly motivated individual for mentoring and building continuous improvement processes towards innovation. * Skilled in handling delivery of global IT projects comprising of Application Development & Maintenance projects: - Performing strategic advisory role related to value proposition, ROI analysis and business judgement in new software development, rollout strategies, product licensing evaluation, database upgrades and critical patch rollouts - Evaluating & establishing IT systems in AWS / Microsoft Azure Cloud Infrastructure & Dedicated Datacenters - Driving vision / road map & life-cycle management for software applications including value proposition & functionality, strategy elements (domain & business case), system integration, product implementation and training * Excellent oral and written communication skills, able to communicate practically at all levels of the organization, from the technical teams to the upper management * Proven capacity to think outside the box in architecting solutions, to meet speckled business and customer needs. * Hands-on contributor who enjoys working with ERP/MRP, AMO and managing functional, technical contributors to execute solutions * Ability to adapt new technologies like AWS redshift, Netezza, MapR with ease. * Well versed with multiple database technologies like Oracle, MySQL, Hadoop, Pervasive SQL to name a few Accomplishments till date * Installed and maintained different versions of Oracle databases, including 10g/11g/12c and other Oracle components. * Converted the MRP program in Pro*C to PL/SQL successfully. * Provided oracle DBA support the customers in performing day-to-day activities that include clones, backups, PITR restores, User Management, Password management, Data pump etc., * Developed solutions/scripts for various applications and implemented the same. * Developed Metadata model and trained the developers to create/convert reports from MRP system into Cognos reports technology. * Developed Check printing algorithm for AP module per the custom requirements. * Developed Packaged procedures and skeleton procedures/functions for the MRO development teams so that the development could be standardized and tuned for performance optimization * Successfully developed solution for integrating other databases Invoice processing in to Oracle Database using ETL * Setup TDE and implemented across the applications. Core Strengths: * Champion in cross-functional collaboration, team work, building effective teams and highly motivated individual for mentoring and building continuous improvement processes towards innovation. * Skilled in handling delivery of global IT projects comprising of Application Development & Maintenance projects: - Performing strategic advisory role related to value proposition, ROI analysis and business judgement in new software development, rollout strategies, product licensing evaluation, database upgrades and critical patch rollouts - Evaluating & establishing IT systems in AWS / Microsoft Azure Cloud Infrastructure & Dedicated Datacenters - Driving vision / road map & life-cycle management for software applications including value proposition & functionality, strategy elements (domain & business case), system integration, product implementation and training * Excellent oral and written communication skills, able to communicate practically at all levels of the organization, from the technical teams to the upper management * Proven capacity to think outside the box in architecting solutions, to meet speckled business and customer needs. * Hands-on contributor who enjoys working with ERP/MRP, AMO and managing functional, technical contributors to execute solutions * Ability to adapt new technologies like AWS redshift, Netezza, MapR with ease. * Well versed with multiple database technologies like Oracle, MySQL, Hadoop, Pervasive SQL to name a few