SUMMARY:

• Highly accomplished and motivated dynamic leader with 16Years of Database administration and 21+ years of versatile and rich overall experience in various technologies majorly Oracle Based, seeking a challenging role focusing on DBAarchitect and Data architect/DevOps role using Oracle/Oracle Apps/ services, which utilizes hands on technical expertise, leadership and excellent people management skills.
• Established and managed on - site and offshore global IT departments 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,MediaFLO 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.
• 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.
• 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 andbusiness judgement in new software development, rollout strategies, productlicensing 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 applicationsincluding value proposition & functionality, strategy elements(domain & businesscase), 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,MapRwith ease.
• Well versed with multiple database technologies like Oracle, MySQL,Hadoop,PervasiveSQL to name a few

TECHNICAL SKILLS:

Databases/RDBMS/tools: Oracle 12C,11g RAC,11g Non RAC,10G RAC,9iAS,8i Oracle ASM, TDE,OEM Oracle Data Guard HA configuration Oracle Golden Gate 11g,12C 12C New features MapR Hadoop Agile PLM9.3.5,SOA,FMW,WLS Oracle Apps R12,11i,Ad utilities, ADOP,OATM,OAM SOA,Noetix,Vertex,ECM,OBIEE Cognos reportnet 1.1MR2/1.1MR3 Frame Work Manager.

Hardware & Operating Systems: Sun Solaris, HP - 9000, DEC Alpha 2000, VAX, Intel Pentium UNIX (Most Major Flavors), Solaris, HP-UX 11.00, Windows (till the latest 10) SCO UNIX,NAS, NFS, LINUX RHEL release, SAN Storage

Others: MS-Access, SQA Testing Tools, MSOffice, UNIX Shell Script, PERL scripts, JavaScript, Vi Editor, VSS, Microsoft Project, PL/SQL developer, TOAD, Edit Plus.

PROFESSIONAL EXPERIENCE:

Senior DBA Manager

Confidential - San Jose,CA

Responsibilities:

• Managed DBA Activities and teams both Oracle Apps DBAs and Core DBAs. Analyzed and built Knowledge base for Maintenance activities, Patching, Improved the turnaround times for customers by 40%
• Worked with the team on automating repeated tasks that were scheduled to run per predefined times
• Implemented Oracle features like TDE at tablespaces
• Installed / upgraded the Agile PLM 9.3.5 and trained the teams
• Managed the BI Teams and Lead activities related to the customizations
• Managed the SOA and Data warehousing teams
• Installed and configured 11g and 12c GG.
• Installed and upgrade XAG for GG high availability.
• Upgrade 11g GG to 12c GG.
• Configured uni and bidirectional replication.
• Switchover application to source to target.
• Troubleshooting extract and pump and replicate abbened issues.
• Analysis data in trail files using logdump utility.

Staff DBA / Manager

Confidential - San Diego, CA

Responsibilities:

• Successfully built the DBA teams and trained them all to be functional at expert level in core skill set and moderate to expert level in other DBA technology areas like MySQL, Netezza,postgres and MapR to add value to the organization by utilizing the bandwidth appropriately. This process has saved the company 30% of resources to support the internal customers with different technology areas.
• Managed 7 direct reports with a total team size of approximately 30+ across the globe.
• Strong hands on technical skills played a key role to guide/mentor developers, Database Administrators. Functional analysts, business analysts and end users.
• Monitored IT SOX compliance execution, including continuous improvement of the processes, and procedures to ensure ongoing compliance.
• Interacted professionally with all internal and external customers with strong interpersonal skills and managed costs and personnel needs for projects according to approved budget.
• As a lead, Performed numerous applications cloning, patching and database tuning assignments on oracle applications, legacy, custom and third party systems,
• Successfully coordinated leads of all the teams to address service gaps, review all service protocols, escalation procedures, SLA’s and inter-team communications which helped teams productivity.
• Taken responsibilities as Primary for Global activities listed below and successfully carried out the activities without any hiccups from time to time and kept the business running with least down times.
• Password change activity at a regular cycle as per the MSB compliance and improved the activity by reducing the timelines by 50% with automation where required
• Lead the activity of DB/Host Audit of all the production databases and defined the standards to comply with MSB guidelines for audit purposes. Increased the efficiency of auditing both the Server at OS level and Databases at least by 75% by adopting scripts customized and OEM metrics
• Lead Regular RFC activities both scheduled and unscheduled. Improved the process by building the DOD and making it seamless for the stakeholders
• New functionality improvements at DB level and application level from time to time by taking ownership of POC and reaching out to upper management and convince the same by regular demos and implementing the same. A few examples would include Amazon Redshift for Audit Vault extended feature for performance improvement of DB audit and reports and DOD to communicate the downtimes with customers and stakeholders at management level.
• Implemented DB upgrades from 10g/11g to 11.2.0.5 in shortest time by negotiating with the customer stakeholders and Offshore management and stayed current with the Oracle recommended versions based on the requirements from time to time
• Improved performance of Database activities by identifying and automating the same by realizing them in to PERL scrips that could be useful repeatedly. They include "11g/12c Client install", "10g/11g/12c Single Instance with Standard parameters creation", "11g/12c RAC databases creation ", "Resizing the data files" to name a few.
• Managed the DB Audit project and collected the audit parameters both custom and standard and have accomplished with global teams participation to audit the databases and publish the results and correct the deviations and bring them in 100% complied mode.
• Established and managed common monitoring process that measures key performance indexes (KPI’s) on various aspects of service delivery, hardware software and program management with focus on customers.
• 10g/11g/12C OEM implementation to monitor the KPIs both custom and standard specific to the Organization.
• Engaged the team members and lead the AWS Redshift POC for auditing purposes BI
• Installed and configured MapR Hadoop as a POC.
• Lead the activity of process improvements as an on-going process and achieved an improvement of 40%
• Produced reports showing the bandwidth and projects distribution across the team members and brought visibility of the team activities to management.
• Collaborated with team leads of development and testing to bring in best practices and improve the performance of both the applications and Databases
• As a member in MediaFLO technology architecture team, designed and developed several algorithms like Program Guide etc.,
• Installed and trained the DBA group, Admin group on operational aspects of 10g OEM
• Provided leadership and direction to project team by understanding business processes, gathering requirements, identifying potential usability issues, managing scope, and ensuring that an appropriate level of application quality was maintained at all times.
• As a key member of architect team installed and demonstrated the load testing of MediaFLO application using Hammora and swing Bench. This has enabled the business to meet with the customer requirements of 3sec billing successfully.
• As database architect, participated in the core development team and designed schema,implemented the same. Conceived the application upgrade scripts and upgraded the applications successfully.
• Lead a team of 8 members to architect a solution for Carousel application using Pervasive SQL database and integrated the same with EBS for Picklist process of components for work orders to build the chipsets.
• Lead the effort of installing and implementing of Noetix views and enhancing the same in collaboration with the vendor Noetix. Successfully integrated the same with EBS and discoverer.
• Lead the Vertex application for AP module, install and integration with EBS activities.

Principle DBA/Senior business Analyst

Confidential - San Diego,CA

Responsibilities:

• Played a key role in developing high performing offshore (India) and onsite (USA) teams, comprising of developers, DBAs and functional teams to support new applications modules development (IMPRESA) / implementations, upgrades and 24 X 7 production support.
• Implemented Cognos BI and developed a team for conversion of the Oracle reports into Cognos reports for MRO customer DAI, Texas by building a Metadata model and module wise packages have been bulit for reporting purposes.
• Built an ETL team comprising of 15 members to integrate three locations across the globe of a key customer Messier Bugattiand implemented the AMO invoice process successfully.
• Lead a team of 50 both in-house and customersite, for production implementation and customizations for one of the prestigious customers ATK (Thiokol) and received an award for accomplishing the same in shortest time and saving $1.3million for the customer. This successful implementation has enabled the customer to carry out the rocket booster testing program on time.
• Successfully built a team of 13 to architect a plan for converting Oracle forms/reports in to PL/SQL,JAVA and ADOBE FLEX technologies and achieved the deployment of cross-platform rich internet AMO applications.
• Built and demonstrated many demo systems for Asset Management Operations teams for Aerospace industry customers like Turkish Airlines etc.,

System Analyst/Programmer

Confidential

• Worked as Oracle / EBS Developer and worked on several projects involving EBS versions 10.6/10SC and oracle Forms 4.5