SHILLER FRANCIS E-

Mail:acgirq@r.postjobfree.com Contact:+91-966*******

Seeking senior level assignments with a growth oriented organization of

high repute

Bangalore

CAREER ABSTRACT

[pic]

o Over 15 years of experience in Oracle database technology and Informix

database on multiple platforms and environments with both Technical and

management skills.

o Togaf 9,PMP Certified, ITIL Trained,IBM Certified Specialist - Midrange

Storage Technical Support V2 and Informix Certified professional,

Enterprise Cloud computing by Zapthink with over 16 years of experience

in Database Administration and Management skills.

o Dedicated and committed with good team leadership skills.

o Currently associated with Tech Mahindra, Bangalore as System Architect.

o Adept in end-to-end development of software products from requirement

analysis to system study, designing, coding, testing, de-bugging,

documentation and implementation.

o Skilled at Oracle 11g and below versions on UNIX, Windows NT and Windows

2000,DBA Activities such as Database Design (Physical & Logical), Data

Modeling, Data Architect, Oracle Server Installation, Administration,

Backup and Recovery, Migration, Application Tuning (SQL Tuning), Memory

Tuning (SGA), I/O Tuning, Database Auditing, SQL, SQL* Plus, NET 8.0.

Oracle Utilities: Export, Import, SQL* Loader, DB Verify. Experience in

Application development using PL/SQL, Forms, Reports, Designer 2000, C,

UNIX Shell Scripts, Client/Server architecture and Relational Databases.

o Gained sufficient exposure in managing all phases of Data Warehousing

projects and in relevant Data Warehouse specific Technical Specification

and Data Modeling and Documentation.

o Expertise in real application clusters, data guard, written cloning

scripts for Application DB's, customizing automation, troubleshooting

skills on Oracle database.

o Excellent skills in database administration, backup and recovery

activities, performance tuning of Oracle, patching and troubleshooting.

Strong problem solving & technical skills.

o Developed and established department standards and procedures, and

coordinate the technical support and direction to programming, operations

and other departments.

o Coordinating & delegating assignments for team.

o Experience in Data Modeling and Design,Migration of data from

Informix/sqlserver to oracle.

o Hands on experience in installing, upgrading and managing 9i/10g/11g

databases on various flavors of UNIX platforms.

o Capable of effectively managing internal databases, from logical and

physical design, planning and testing stages through implementation and

support.

o Experience as On-Call 24x7 production DBA support,

application/development DBA.

o Good knowledge of Informix database.

o Prototyped oracle DATAGUARD for creating and managing standby databases.

o Extensive experience in database growth monitoring and CAPACITY planning.

o Experience in implementing, upgrade and managing oracle ENTERPRISE GRID

CONTROL.

o Experience in planning backup and recovery operations using RMAN.

o Hands on experience in performing logical backup using DATAPUMP for non-

production database, schema refreshes.

o Proactively monitor the database systems to ensure secure services with

minimum downtime.

o Experience in performance tuning using AWR and ADDM reports.

o Hands on experience in evaluating the performance of SQL statements using

utilities like AUTOTRACE, TKPROF & Explain plan.

o Frequent interaction with development, network, system and storage teams.

o Good understanding of the business, follow the ITIL process and adhere to

customer's SLA's.

o Interface with ORACLE SUPPORT for technical assistance.

o Ability to learn new technologies and adapt to a dynamic environment.

o Successful in meeting new technical challenges and finding solutions to

meet the needs of the customer.

SCHOLASTICS

[pic]

2012 PGDMBA-IT from ICFAI.

2005 MBA in Information Technology in Business Management from University

21 Global -Singapore.

1995 PGDCA from Institute of Research and Services.

1994 B. Com. from Gulbarga University.

1991 12th from PUC, Bangalore Board.

1989 10th from Central Board of Secondary Education.

EMPLOYMENT RECITAL

[pic]

Tenure Company

Designation

Aug'13-Aug 14 Tech Mahindra

System Architect

Oct'00- Jul'13 Satyam Computer Services Ltd.,Hyderabad/Bangalore

Senior System Analyst

Apr'96-Oct'00 AFL, Bombay

System/Database Administrator

Notable Highlights:

o Responsible for customer data service management, project/program

management, people management and infrastructure availability

o Proactively identify issues and make sure services are meeting SLA's.

o Proactively identify issues and make sure services are meeting SLA'sData

modeling/Capacity Planning/Backup strategies.

o Managed database administrators on various infrastructure projects

improving service level agreements by reducing time to deliver IT

solutions to business.

o Data Modeling using Oracle Designer/Installation and Configuration of

Databases/Data Migration.

o Adapted and managed change across cross-cultural/functional teams. Have

worked in various global location (US, Japan, UK, Singapore).

o Performance tuning for RAC database for retail online application.

o Managed database administrators on various infrastructure projects

improving service level agreements by reducing time to deliver IT

solutions to business.

o Developed stronger ties between customers and Infrastructure team

resulting in collaborating and working together to effectively use IT for

business.

TECHNICAL SKILLS

[pic]

Hardware: HP-9000, SUN Enterprise servers

4000/6000/6500/10000/25000, Pentium, Digital Servers

Operating Systems: HP UX, Solaris, TRUE64, Windows NT 4.0, Windows95,

Linux

Languages: C, Shell programming

Databases: ORACLE 9i, ORACLE 8i, Informix, DB2,My SQl,Mongo Db

GUI: Business Object, Visual Basic

Case Tools: Designer 2000, Erwin

Web Related: HTML, Apache Web Server, Tomcat

Tools & Utilities: Import / Export, SQL*Loader, Server Manager, Oracle

Enterprise Manager, SQL*Net, Backup Manager, RMAN, DB-

Artisan

Database: Oracle7.3,Oracle 8,Oracle 9i, 10g, 11g SQL, PL/SQL

Languages: C,Java,Python

Application Server: BEA Web Logic Application Server, SOA Suite, IBM Web

Sphere Application Server and Queue server.

TRAININGS ATTENDED

[pic]

. Attended the following trainings:

o Informix Database Administration training conducted by Informix

India.

o Advance DB2 Database training conducted by IBM

o UNIX training on System and Networking Administration conducted

by HP.

o Project Management Training -Satyam.

o Togaf 8 and Togaf 9 training

o Enterprise Cloud computing -Zapthink (Jason Bloomberg)

PERSONAL DOSSIER

[pic]

Date of Birth: 26th June, 1973

Address: Hebbal,Bangalore 560024.

Linguistics: English and Hindi.

PROJECTS HANDLED

[pic]

Client/project: Target India Ltd/Everest and Canada

Role: Oracle Performance Tuning/Database Build

Duration: November 2010- March 2014

Environment: Oracle 11 G and 11g Rac (4 Node) /Windows/Linux

Role:

. Providing Performance tuning and performance analysis of Oracle 11g Rac

and standalone Database

. Generate and analyze AWR, ASH and ADDM report after each stress run.

. Analysis of database object which is accessed frequently.

. Assisting developers in SQL tuning after reviewing the SQL PLAN and

Mentoring and guiding junior DBA's.

. RMAN backup and recovery.

Client/Project: Philips/Tech support manager

Role: Manager (IT)

Duration: May 2009- September 2010

Environment: Oracle/Windows/Solaris/Linux

Role:

. Incident management and Problem management and some of change management

in Central Data warehouse/WMS and Chainware.

. Managing and motivating the team. Appraisals and select the team members

for quarterly awards.

. KPI report on the performance of team with related to the incidents

resolved on time and escalating appropriately. Day to day handling of

escalations

. One point contact for SCM from business point of view.

. Meeting SLA and OLA for the issues. Coordinating with other teams for

issues resolution

. Planning of transition activities for the projects. Planning and

Execution of 24*7 support by a set of consultants.

. Technical support for Central Data ware house, Transport management

system and Business Object.

. Creating users and roles for Business Object as per the standard.

Client/Project: Satyam Computers Services Ltd

Role: Oracle DBA

Duration October 2008 - April 2009

Environment Oracle 9i, Oracle 10 G HP UNIX.

Project Description

. Provide Database Consultancy for Qantas and Internal Projects.

. Performance tuning of the database and SQL.

. Analysis of the data model and suggesting partition strategy.

. POC of application on RAC system on Linux.

. Completed PMP certification.

Client/Project: Palm Inc/MCDB

Role: Database Architect

Duration: August2008- September 2008

Environment: Windows/Solaris/Linux

Contribution

. Understand the scope and features legacy system.

. Analysis of the legacy system database design and contents of the

database.

. Working with the SAP team to understand the feasibility of migrating

legacy system to SAP.

. Database modeling for the new version of legacy system in SAP conceptual,logical and physical SAP Z table .

. Review of the design by team and implement the changes.

. Doing the Sizing and estimation for the database based on the assumption

and Signoff of Database Design.

. Suggesting and creating various types of indexes to improve performance.

Title: DB Lead/Developer.

Client/Role: Cisco

Role: Oracle DBA /PL/SQL Developer

Duration: June 2007- August 2008

Environment: Windows/Solaris/Linux

Contribution

Role: Tech Lead for 4 member team.

Deliverables:

. Planning the task for each member of the team using Microsoft Project

manager. Working closely with the Project manager in achieving the goal

of the project.

. Designing a process for extraction of data from ERP databases and writing

PL/SQL for extraction of data automatically as well as on demand through

front end.

. Space management, User management and coordinating with other teams when

required to create user/add space.

. Space estimation with the help of row size and retention period for any

new tables.

Title: Data warehouse DBA/Developer.

Client: Erickson Services Ltd

Role: Oracle DBA /PL/SQL Developer

Duration: November 2006- June 2007

Environment: Windows/Solaris/HP (High End Servers)

Role:

. Part of a team in administration of data warehouse / data mart and

staging databases. Managing the partitions of huge

tables.(Move/Add/Drop/Split/Compress).

. Assisting in deploying new projects by getting the requirement from

developers. Working with Unix and oracle group.

. Space estimation with the help of row size and retention period for any

new tables.

. Automating the compress/purge and other routine dba jobs using Unix shell

script and pl/sql.

. Assisting developers in tuning SQL and creating right indexes when

required.

. ETL development using PL/SQL. Understanding the requirements, preparing

detail design, development, UTP and then releasing the code for Dev Int.

. Creating Work Orders as and when required and Fixing the defect as and

when assigned.

. Assisting in effort estimation of upgrading databases to 10 G and in

upgrading Oracle Designer to 10 G.

Client: KVH Company ltd(Tokyo)/Database design for Inventory

management system.

Role: Oracle DBA

Organization Satyam Computer Services Ltd

Duration September 2005) - October 2006

Environment Windows/Solaris/Oracle Designer

Contribution

Data modelling from conceptual, logical and physical by understand legacy

application and new requirements.

Used oracle designer for database design

Client: BSNL/DBA and BO for Implementation of Interconnect

billing system

Role: Oracle DBA/System Administrator

Organization: Satyam Computer Services Ltd

Duration: August 2004 - August 2005

Environment: Sun Solaris 5.9

Installation of oracle database and implementing disaster recover for the

database using logical standby database at different location.

Assisting the application team in implement and taking care of server side

and business object. Coordinating with customer/product team and

configuring the database as required.

Client: DST Innovis/Concord(Database design for sales order

management module)

Role: Oracle DBA

Organization: Satyam Computer Services Ltd

Duration: March 2003 - December 2003)

Environment: Sun Solaris 5.6, True 64, HPUX

Role:

. Understanding the requirements and Class model for the application

. Design the database for major components of the Application.

. Using the database designer creating logical model and physical model and

sizing and estimation of db

. Implementing the physical model for the development and performance

tuning of SQL

. Review the Code and SQL and suggest efficient method to improve the

performance and follow the standard.

. Automating dba jobs by writing Shell Scripts and maintaining and support

database

. Upgrade from oracle9.2.0 to oracle 9.2.03.

Client: Satyam Computers Services Ltd/Rating Enging

Role: Oracle DBA

Organization: Satyam Computers Services Ltd

Duration: June 2002 - February 2003

Environment: Oracle 8.1.7, HP UNIX.

Summary: This Application is to be a one-stop rating for all the

telecom and utility Companies.

Design database for the rating application for Telecom. Conceptual,logical

and physical by understanding CDR and products.

Title: Oracle DBA Support for Starhub

Client: Star hub Ltd Singapore

Role: Oracle DBA

Organization: Satyam computers services Ltd

Duration: January 2001) - June 2002)

Environment: Oracle 8.1.7, oracle 7.3,HP UNIX, Solaris Windows NT

Production DBA for Telecom application like BSCS, Vantive, provisioning.

Reorg of database for better performance .

Backup and recovery and cloning of database to test and dev env as and when

required and MQ Series .

Title: Tankha, Astra Cargo, Astra Voucher

Client: Air Freight Limited

Role: Informix DBA/System Administrator

Organization: Air Freight Limited

Duration: 1996-2000

Environment: Informix 7.3,HPUX,Sco-Unix,Linux

. Database Design & administration.

. Unix system administration for HP UX and SCO unix.

. Supported application like TANKHA(payroll application),Voucher and

Astra Cargo

. Plan, control and improve the production process

. Given training on Informix Database Administration.

Contact this candidate