John Xavier

JOHN XAVIER401-441-1054 (M) /201 484 7717

(D)E-Mail: jenijohnk@hotmail.com

SUMMARY: Over 3 Years of extensive experience in Big data (Hadoop Cluster) for building a fast, scalable,

reliable and cost effective system by performing PoT (Proof Of Technology), PoC (Proof Of Concept), designing, building, performance management, space management, hadoop cluster upgrade , hadoop cluster migration, Installation and monitoring the hadoop cluster with High availability.

End to End extensive experience in building Hadoop eco system on Cloudera platform (CDH 4.x/5/x & CM 4.x/5.x)

Over 13 years of experience in database project deliver and management, administration in various versions on various platforms in USA, Canada, UK, Qatar & India

Good hands on experience in 100 node Production cluster/ Dev Hadoop Cluster, Cloudera Manager, Hive, Impala, Ozzie, Hue, and worked on very large.

Experienced in implementing and maintaining commercial (Trading & Manufacturing), Banking & Finance, Digital Media and Airline applications and databases.

Excellent and extensive experience in Big data (Hadoop Eco System) / Database Project Delivery, Administration, Design, Development, IT Readiness, Project Management, System Administration & Hardware& Software Support, System Analysis/Design, Implementation of Commercial Application and Testing on Oracle 7.x/8.x/9i/10.x/11.x/12.x, Oracle RAC (2/3/4) node clusters, Ingres, Postgres, Netezza and SQLserver databases using Erwin, People Soft App Designer, Golden Gate, AWS , People Soft Data Mover, Stats 5.6.2, People Soft HCM (HRMS and Portal Modules), Developer 2000/4.5, PL/SQL Developer, Siebel CRM, OTM, Toad, Test Director, Tidal, Grafana, Autosys and Shell Scripting on Various plat form like Windows NT/2K/7x/ Sco Unix/ HP Unix/ Linux/ IBM Aix /Solaris and Z/os.

Strong trouble shooting, problem solving, re-engineering, Project Management and analytical skills. A Team player and managed teams with good communication and leadership skills

EDUCATION: Master of Business Administration in Systems (Alagappa University, India) Honors Diploma in Software Engineering (APTECH, India) Bachelor of Science (Bharthidasan University, India)

DOMAIN & CLIENTS: Online Media Trading - Mediamath Banking & Finance - Royal Bank of Scotland, Citizens Bank & Canara Bank Insurance and Risk – Marsh & McLennan Companies Airline – Qatar Airways Retail – British American Tobacco & Nordstrom Manufacturing & Trading – Viterra, GE and etc.

CERTIFICATION: ITIL (Information Technology Infrastructure Library) OCA DBA 9i (Oracle Certified Associate) MCSE 2000 (Microsoft Certified Systems Engineer) CompTIA A+ (Hardware Engineer)

TRAINING:♦ PMP ♦ ITIL ♦ MCSE ♦ ♦ AWS Architect ♦ Oracle Database Vault

Page 1 of 8

John Xavier

PRIMARY SKILLS: Cloudera Manager, Hadoop Eco System (HDFS, Hive, Impala, Map Reducer, Ozzie, Sqoop, Hue &

ZooKeeper) Netezza, Postgres, Amazon Web Service (AWS) and Oracle Golden Gate Oracle 10.x/ 11.x /12.x Database Administration, Monitoring, Backup & Recovery, Tuning & Security

of DB, Export / Import, DataPump, RMAN, SQL Plus, Statspacks & AWR, ASM, SQL loader and Real Application Cluster (RAC), Replication, Patching, People Soft Infrastructure Support, Database Upgrade/migration, Oracle BI, Shell Scripting, DR exercise, Data Guard and Oracle Grid.

Hardware Sizing and Capacity Planning, Shopping List, Installed Environments (Dev, Training, Live), Communication Network, Operational & Support Procedures, Localization of Data & Detailed (Architecture) Technology Analysis.

Maintaining Safe Environment by resolving IT Infrastructure issues such as Software, Hardware, Database, IT Security, Operations and etc.

MAJOR DEMONSTRATED STRENGTH: Extensive experience in Design, Build and Rollout the 100 Nodes hadoop cluster, Hadoop Cluster

migration and hadoop cluster upgrade. Worked on Proof of Concepts (PoC), Proof of Technologies (PoT) and implemented the best

practices. Worked on Component Design for Oracle databases. Result oriented, analytical and self-driven professional seasoned with years of working in a dual role

ofDesign/architecture and production support.

Succeeded the Successful Transition of projects from the clients. Managed and lead large teams both onsite and offshore during the critical phases of projects. Succeeded in playing multiple roles like Hadoop Admin, Senior Data Engineer, Development DBA,

IT Readiness Consultant, Transition Coordinator, Project DBA, Application DBA, Production Support DBA and DBA Lead, Database/ Big Data Architect

PROJECT PROFILE

KEY COMPETENCIES AND EXPERIENCE:

Architect (MediaMath - www.mediamath.com ) - June 2013 – Till Date

Company : Mediamath - www.mediamath.comRole : Hadoop lead / Database ArchitectDuration : June 2013 – Till DateHardware : IBM Servers/ Super Micro Servers/ NFS Servers/ Netezza Skimmers/

Netezza Servers Big Data : Hadoop V2.0 Eco System - HDFS , Hive, Map Reducer, Zoo Keeper,

Impala, Ozzie, Yarn, Sqoop , Cloudera Manager 4.x /5.x and CDH 4.x /5.x, AWS , S3, EMR and EC2

Platform : linux (Redhat / Debian ) and WindowsDatabases : Oracle 10.x/11.x/12.x, Postgres 9.x and NetezzaTools : Putty, Toad, Grafana, Cloudera Manager, Oracle Enterprise Manager,

Aginity workbench for Netezza. PgAdmin III , Pg_bulkload 3.10.5, Jira, Ora2pg and IBM Netezza Admin

Language : Sql, Pl/Sql, Unix Shell Scripting and Perl Scripting

John Xavier's responsibilities include

As part of Solution Conceptualization, Definition and DesignPage 2 of 8

John Xavier Worked on PoT for CDH (Cloudera Hadoop Cluster)/ Postgres / Golden Gate Replication Implemented lzop compression to increase the performance

Worked on PoC for Global Performance Data (Real Time DW)/ Rollups (Aggregate Data Set)

Knowledge Management:• Publish Wiki Pages for documentation.• Using GitHub - Maintaining repository of technical solutions, technical best practices and design/coding guidelines/standards• Monthly Owner Knowledge Sharing Sessions - Conduct and facilitate knowledge sharing and learning sessions across the team.

Training & Mentoring:• Conduct Training sessions and also attending conferences• Ensuring all team members attend the webinars • Mentor new joinees on an ongoing basis

Designed the Hadoop cluster(100 nodes) with High Availability Installed Cloudera Manager, CDH (Cloudera Distribution Hadoop) and Managed Service. Managed Software Distribution (Packages and Parcels) Tested the hadoop Installation Deploying the hadoop Clients Troubleshooting hadoop Installation and hadoop Upgrade Problems Managing hadoop clusters / Services/ Roles/ hosts Backup and Recovery for smon,cmon,amon,scm and hive meta store Deploying UDFs (User Defined Functions) Performed hadoop cluster upgrade from CDH4.x to CDH5.x, Impala, Map Reducer Configuring the alerts, monitoring the hadoop cluster, Performance tuning User Management and Auditing Hadoop Migration Maintaining and administrating oracle, Postgres, Netezza databases on various environment. Hadoop, Amazon Web Service, Cloudera Manager Administration. Installation, Configuration of Oracle, Postgres, Netezza, Hadoop, Oracle gateway and their components Design, Creation, Optimization, Backup & Recovery, and Security of database Shared 24/7 “on-call” support of production database services to ensure the highest standards of

availability, resilience, integrity, security and performance required by our business systems Creating ETL tool for data migration / Configuring client workstations for application development. Performing Tuning activities / Provides technical support on problems in an operational environment. Monitoring growth of the database to take proactive action Keep updating the database standards and adhering the same. Working closely with QA team, Development, Product, Operations, Management and external vendors. Plan growth and changes (capacity planning) Database migration, Disaster Recovery Testing and upgrade Code Development / Shell Scripting / Infrastructure Support Users Management (Roles, Grants, Privileges, Permission and etc.) Providing the recommendation for process/ Technical enhancement, mentoring and transferring

knowledge to the team. Working on the Incident, Problem, Change Management, Scrum work, Database Adhoc Request and

New Projects.

Database Architect (Wipro Technologies - www.wipro.com) (May 2011 – June 2013):

Company : www.wipro.comRole : Database ArchitectDuration : May 2011 – June 2013Hardware : IBM Servers/ Dell Server/ Sun Servers/ Super Micro Servers / NFS

Page 3 of 8

John XavierServers / San Storage

Software : Oracle 10.x/11.x , Oracle gateway, Dos, Unix, Windows, Linux, Sun Solaris, Oracle PeopleSoft HRMS & Portal, Oracle RAC, Oracle ASM & Oracle Data Guard

Databases : Oracle 10.x/11.xTools : Putty, Toad, Oracle Enterprise Manager, Oracle Grid Control , Tidal &

Autosys, PeopleSoft Apps Designer, People Soft Data Mover and Stats 5.6.2

Language : Sql, Pl/Sql and Unix Shell Scripting

John Xavier's responsibilities include

Strategic Responsibilities include: Drive database strategies for meeting existing and new business requirements using Oracle

10g and 11g Defines and creates standards, guidelines, and quality of service criteria for enabling,

implementing and supporting architected database systems Maintaining an understanding of current technologies, their trends, business strategies and

capabilities and their implications on the database world Leads technical performance and compliance assessments of database applications and

products Responsible for reviewing and implementing processes that ensure quality of service for

customers through the governance of outsourced database support team Operational Responsibilities include:

PeopleSoft Infrastructure Support for People Soft HRM (HRMS and Portal) application, Database Management, Administration and Delivery on Linux and Solaris environment.

Database Performance Monitoring and tuning, Maintain Database backup/recovery environment, Install/upgrade database and related products

Single point of contact for onsite/offshore communication, DR Excise, Database Migration, Database upgrade, 24X7 on call support.

Schedules, Coordinates and Implements Oracle Patching, DR Testing & Database maintenance activities.

RAC, ASM and Grid Control Management, Performing Database refresh, Setting up the Dev./ Demo /UAT /PPE/Prod environment for People soft databases PeopleSoft DB migration using People tools and Stats 5.2, Supporting People soft Upgrade, Build the People soft database, Data Guard Check, Database backup and restore check and ensuring database availability.

Working on the Incident, Problem, Change Management, Database Adhoc Request and New Projects.

Working on Break Fix/ major outage calls and interacting with client to facilitate smooth operation.

Evaluate, test and provide recommendations for new tools for enterprise database management

Providing the recommendation for process/ Technical enhancement, mentoring and transferring knowledge to the team.

Working Daily/Weekly Reports, Dash boards and on critical/warning alerts in Grid Control. Work with outsourced support teams in the ongoing support of the operational environments Collaborate with business, analyze and interpret requirements for operational oversight of

database including determining SLA's Provide project management and oversight for database related projects The incumbent leads project teams including, operations, application developers and vendors,

to improve technical infrastructure, security, reliability and cost. Provides project and team leadership as well as day-to-day support of the production, QA,

test, and development mid-range database environments

March 2007 TO May 2011 – Senior Consultant (Infosys Technologies - www.infosys.com)

Page 4 of 8

John XavierCompany : Infosys Technologies - www.infosys.comRole : Database LeadDuration : March 2007 – May 2011Hardware : IBM Servers/ Dell Server/ Sun Servers/ HP Servers/ Super Micro

Servers / NFS Servers / San StorageSoftware : Oracle 9.x/10.x/11.x , Oracle gateway, Unix, Dos, Windows, Aix,

Linux, HP Unix, Sun Solaris, Z/os, Citrix, Autosys, Oracle RAC, Oracle ASM & Oracle Data Guard

Databases : Oracle 10.x/11.x & Sql ServerTools : Putty, Toad, Oracle Enterprise Manager, Oracle Grid Control ,Erwin,

Test Director, Autosys, Remedy, Oracle BI and OpswareLanguage : Sql, Pl/Sql & Unix Shell Scripting

INFOSYS CLIENTS:

Database Lead (CITIZENS Bank, RI, US) (May 2010 – May 2011): John Xavier's responsibilities included handling all kinds of DBA request, Ticket Management, working on Production readiness checklist, working on daily/weekly reports and on critical/warning alerts in Grid Control. Performing Data Guard Check, Interface with Oracle Corporation for technical support, Evaluate Oracle features and Oracle related products, Database backup and restore check and ensuring database availability. Attending problem and change management meeting and interacting with client to facilitate smooth operation. Single point of contact for onsite/offshore communication, DR Excise, Data Guard, 24X7 on call support, providing the recommendation for process/ Technical documentation & enhancement, mentoring and transferring knowledge to the team. Handled 1500 nodes and VLDB (i.e. 30TB) database.

Database Lead (Viterra, SK, Canada) (Nov 2009 – Apr 2010): John Xavier's responsibilities include handling all kinds of DBA request, Single point of contact for onsite/offshore communication, 24X7 on call support, Diagnose and recommend the solutions for current Oracle environments, including improving performance, capacity planning, forecasting and backup strategy, providing the recommendation for process/ Technical enhancement, mentoring and transferring knowledge to the team. Handling 175 databases on various platforms.

Database Lead - Oracle Projects (Royal Bank of Scotland, London/ India) (June 2007 – Oct 2009): John Xavier’s responsibilities included the following activities

Configure, Test and implement enterprise oracle database infrastructure solution for Unix or Windows systems, which support business system requirements.

Configure appropriate Oracle Infrastructure components and help define appropriate DR / Recovery steps for all Unix or Windows systems( Regardless of Size, SLA and recovery time)

Ensure that test backups and recoveries happen before projects go live and make sure that backup designs fir the business requirements and SLAs

Ensure that full capacity and performance testing is completed for all components of the Oracle design, when appropriate, for oracle RAC and NON-RAC environments.

Ensure all Oracle Components are designed to meet security standards and use encryption where appropriate.

Ensure we deliver Fit-For-Production systems with all required supporting documentation. Work with operational Services Oracle Support Team to ensure any new Oracle technology is

fully productionised and documented. Work with Oracle Development DBA team to ensure all Oracle Systems meet development

standards Provide ongoing consultancy to projects where there is an Oracle component. Maintain the Oracle RAC environment and troubleshoot performance problems.

Transition Coordinator (NORDSTROM, India) (Mar ‘07 – June ‘07) : Page 5 of 8

John XavierJohn Xavier’s responsibilities include to support Transition for Various small accounts like Oracle, SQL Server, Solaris and Windows with respect to Knowledge Transfer / Due Diligence / Transition Plan / Execution / Steady State

IT Consultant (British American Tobacco) (Mar ‘05 – Mar ’07 - ITC Info Tech - www.itcinfotech.com)

Company : ITC Infotech - www.itcinfotech.comRole : Database Administrator/ IT Readiness ConsultantDuration : March 2005 – March 2007Hardware : IBM Servers/ Dell Server/ Sun Servers/ HP Servers/ Super Micro

Servers / NFS Servers / San StorageSoftware : Oracle 10.x/11.x , Oracle gateway, Unix, Dos, Windows, Linux, Sun

Solaris, Oracle CRM, Siebel 7.x, Autosys, Oracle RAC, Oracle ASMDatabases : Oracle 10.x/11.x, Sql Server, Tools : Putty, Toad, Oracle Enterprise Manager, Test Director 8.x / VSS/

Oracle Grid Control , Autosys, Business Objects & VSSLanguage : Sql, Pl/Sql & Unix Shell Scripting

As an Off Shore Database Administrator activities performed are Maintaining and administrating the large no of 100 (20 X5) databases in various environment Installation of Oracle / Siebel / BO/ Toad and other applications Design, Creation, Optimization, Backup & Recovery, and Security of database Shared 24/7 “on-call” support of production database services to ensure the highest standards of

availability, resilience, integrity, security and performance required by our business systems Creating ETL tool for data migration / Configuring client workstations for application development. Performing Tuning activities / Provides technical support on problems in an operational environment. Monitoring growth of the database to take proactive action Keep updating the database standards and adhering the same. Plan growth and changes (capacity planning)

As an IT Readiness activities performed are Detailed (Architecture) Technology Analysis Hardware Sizing and Capacity Planning Shopping List/ Installed Environments (Dev., Training, Live) Communication Network/ Operational & Support Procedures Localization of Data/ Applications Developed & Tested/ Data Conversion Responsible for IT Infrastructure issues such as Software, Hardware, Database, IT Security and

Operations. Maintain a safe environment Enforce the team ground rules/ Resolve conflicts as they arise/ Keep the group on track Ensuring the ITC & BAT Security compliance/ Build data gathering instruments Controlling systems capacity for existing requirements and plan for future needs and recommend to

the management accordingly

Database Administrator (GE Consumer Finance) (Nov ‘04 – Feb ’05 – Patni Computers (www.igate.com) : As a Production Cum Development DBA, activities performed are Development of the data models using E-R diagrams Execution database change requests for all the production Schema Management and Performance tuning Data Migration and Replication Space Management Backup and Recovery Creation / Edition shell scripts for various database maintenance activities Keep updating the database standards and adhering the same.

Page 6 of 8

John Xavier Working on the multiple scope documents which includes Requirement analysis, Time Estimation,

Coding, Testing, Documentation & Implementation Support Creating / Editing Shell Scripts for various database maintenance activities Development of the data models using Erwin

Database Administrator (CanBank Factors) (Jan ‘04 – Nov ’04) (www.canbankfactors.com) Ingres Installation of Ingres 1.2 on Sco Unix & Ingres II on Windows Create and destroy database, Define alternate locations for database files Manage public Database Objects, Maintain database and query performance Backup & Restore the database. Maintenance of INGRES Application Software packages of the Company Training the IT staff of the Company in maintenance of Application Software Ensure database performance by analyzing and resolving database / application related problems Modifying the software application as per the changed policies of the Management and ensuring the

version control across the branches Developing additional / new reports using Ingres Reporting tool as per the requirement of the users /

management Ensuring timely day-end / month-end operations and ensuring error-free rollover to the next day /

month Controlling systems capacity for existing requirements and plan for future needs and recommend to the

management accordingly Migration from Ingres to SQL server

Oracle Installation, configuration and upgrading of Oracle server software and related products Design, Creation, optimization, Backup & Recovery, and Security of database Schema management Analysis for logical / physical optimization Developer Support in developing Procedures, Functions and Triggers Set up oracle standby database Unix Shell Scripting Establish and maintain sound backup and recovery policies and procedures Implement and maintain database security (create and maintain users and roles, assign privileges) Configuring client workstations for application development. Monitoring , Maintaining the database Proficient in Windows NT and Windows 2000 Administration Knowledge of Microsoft SQL Server 2000 / MSDN administration Database migration and Performance tuning Data Consolidation, Partitioning and Replication

Systems Analyst (Qatar Airways) (Jun ‘03 – Oct ’03) (www.qatarairways.com)Provided support for all IT systems within the Technical, Flight Operations and Qatar Amiri Flight departments in order to enable the departments achieve high productivity required for the cost-effective and efficient running of the Airline. Provided client/technical support for computer based applications and messaging systems in order to enable users access the required information.Responsibilities: System Analysis and Providing Recommendations Provide System Support Maintaining and Administration of Database Provide support to manage the data network Provide client/technical support for all computer based systems and applications Installation of latest software patches & Installation, configuration of Windows 98/2000 System Administrator for LOMS/Win Pep Reporting Systems, AIMS & Win basis Data backups

Database Admin/ Senior Systems Engineer (Ador Fontech) (Jan ‘98 – Jun ’03)Responsibilities:

Page 7 of 8

John Xavier Design and implement physical and logical database structure for the commercial application like

Trading and Manufacturing applications Developed and deployed the applications using oracle Forms and Oracle Reports (Developer 2000) Building database objects, stored procedures, pl/sql functions, Cursors, Partitioning and triggers. PL/SQL code review and modification for the development of new requirements. Tuning the queries and database performance tuning using statspack Established and maintained sound backup and recovery policies and procedures using RMAN Applying Oracle Patches / Database migration Setting up the basic/advanced replication and Standby Database. Provides technical support on problems in an operational environment. Actively involved in Re-engineering, Design, Development, Testing and Implementation Designing and developing Business logic in oracle for product group-wise sales comparison reports,

contribution reports, sales reports, stock reports etc. Identification of deliverables / Preparation of time estimations Oracle installation, configuration, upgrade, migration, patch management, Hardware sizing and

Capacity planning Database Refresh, re-org, Export/Import, SQL*Loader, Analyze system and session level waits & Locks

and clear bottlenecks Creating the database, tablespaces, schemas, rollback segments, tuning of logical and physical Oracle

structures Creating and managing users, profiles, privileges and roles Analyze business systems requirements and design technical solutions based on those requirements Scheduling/ Executing/ monitoring the Unix shell scripts using cronjobs Debugging the Unix shell scripts for the troubleshooting Writing UNIX shell scripts for backup and recovery, adhoc reports, Import and export procedures Automate deployment, log file rotation, account creation, adhoc reports and system monitoring using

the shell scripts Worked on Proof of Concepts and implemented the best practices. Creating and maintaining the Knowledge base document / Design and updating the Operational Manual Providing the recommendation for process/ Technical enhancement, mentoring and transferring

knowledge to the team. Keep updating the database standards and adhering the same.

Page 8 of 8