Oracle Manager

K.T.C.Indika

Humbahawatta, Baddegama Road,

Pinkanda,Dodanduwa

Sri Lanka

Email: ********@*****.***; Tel: +94-773-******

Oracle Certified Professional Database Administrator with experience

in database maintenance, security, backup and recovery

Summary of Qualifications

. Ten years of experience in the IT industry. Over four years of

experience as an Oracle Database Administrator.

. Good experience of Installation and configuration of Oracle Real

Application Cluster (RAC) database servers.

. Good experiences in creating UNIX shell scripts, PL/SQL procedures

and functions.

. Conducted training program about Oracle database related concepts for

development staff.

. Have got experiences and skills over designing and implementing

client server applications and web applications under different

programming development languages and tools.

. Superior analytical and problem solving skills. Work well with all

levels of businesses.

. Over two years of experience in Network Administration by

implementing and maintaining LAN and WAN.

. Proficient in an assortment of technologies, including Oracle 9i/10g,

DB2, Access, MS SQL Server, Apache Web Server, Java, XML, Windows,

AIX and Linux

Certifications and Technical Skills

Certification: Oracle Certified Professional in Oracle 10g Database

Administration (OCP).

Operating Systems: Windows NT/2000/2003/2008, AIX 5.2/5.3, Linux (RHEL

5.1, Fedora 6/8/9), IBM VSE/ESA(S390), OS400 (AS 400).

Hardware: IBM Mainframe(S390), IBM RS6000, IBM Power5 560, Power5

510, IBM Power4 670, AS400, HP, DELL, IBM DS8000,

DS4300 and DS4000 Storage systems.

Network: TCP/IP with Cisco Routers, Switches and Pix Firewalls.

Applications: IBM Tivoli with Oracle RMAN, Apache, IIS5/IIS6, Lotus

Notes 6.x/8.x, ISA, Squid Proxy, Sendmail and Qmail.

Languages: ASP, ASP.NET, VB 6.0, COBOL, RPG 400, PHP.

Professional Experience

Bell Solutions (Private) Limited

Colombo, Sri Lanka

ICT solutions provider in Sri Lanka

Also it is a subsidiary company of Lanka Bell Limited (Telecommunication

service provider).

Manager (Database): 2008-Present

. Supervise and direct database administration team to manage terabyte

(>20 TB) range oracle real application clustered (RAC) database.

. Installation and configuration of Oracle database servers on AIX and

Red Hat Enterprise Linux environments with either single instance or

multiple instances (RAC) architecture.

. Installation and configuration of both oracle standby (data guard)

database servers and Oracle Financial Server in addition to the Apps

DBA tasks

. Setup backup procedures using Oracle RMAN and IBM Tivoli with

automated tape library.

. Developing UNIX shell scripts and SQL scripts to carry out routine

checks on databases.

. Perform database recovery, performance tuning, database security and

capacity planning.

. Provide technical support for database maintenance and disaster

recovery plans.

. Identify, recommend and implement all new database technologies and

Oracle license management.

. Conducting awareness programs for developers about Oracle database

related topics.

Aiding developers to write efficient code and making efficient use of

the resources leading to better performance and optimization.

. Planning and implementing database migration between oracle versions

and among different operating systems.

. Performing system administration in AIX, Linux and HP-UX.

. Applying oracle patches to the production database server and oracle

financial application server.

Management Services Rakshana (PVT) Limited

Colombo, Sri Lanka

Subsidiary company of Sri Lanka Insurance Corporation Limited.

Assistant Manager (Database): 2006-2008

. Installation and configuration of oracle database servers.

. Created database storage structures (tablespaces) and objects

(tables, views, indexes) in the production database after application

developers have designed an application.

. Performed database recovery, tuning and capacity planning.

. Managed database security, enrollment of new database users and

backup.

. Accomplishment of general technical troubleshooting and consulting

development team to optimize their SQL queries.

. Reorganized databases and sized database objects to meet standards

and improve performance.

. Implemented and maintained database backup procedures and logs.

. Developed UNIX shell scripts and SQL scripts to carry out routine

checks on databases.

. Developed PL/SQL programs for data manipulation.

. Installed, configured and maintained MySQL and MS SQL Server database

servers to cater the requirement of small range business applications

on development and production environment.

. Performed the system administration in AIX, Linux, Windows and HP-UX

10.2.

. Configured and maintained IBM Personal communication server for

accessing IBM main frame session (VSE/ESA) via Ethernet LAN.

. Configured and maintained IIS web servers to host web applications

(ASP/ASP.Net)

. Created and maintained ODBC connectivity between application servers

and database servers.

. Created MIS reports using COGNOS and Crystal Reports.

Analyst Programmer/Acting Network Administrator: 2003-2006

. Designed, developed and implemented web based and client server

business applications according to software development standards

using the following development tools and databases.

. ASP, ASP.Net, COBOL (VSE/ESA in s390 Mainframe), Visual Basic

6.0 and RPG 400(AS400)

. Oracle 9i (in AIX 5.2) and DB2 (in AS400)

. Tested, debugged and documented in-house developed software systems.

. Carried out maintenance and support on existing computer systems.

. Planned how work is to be carried out to meet targets of the project

or team task.

. Gathered and analyzed user requirements to develop new computer

systems or modified existing computer systems.

. Prepared technical and user manuals for developed systems.

. Installed and maintained Lotus Domino, Sendmail and Qmail email

servers with Trend Micro IMMS email gateway support.

. As the team leader of the network team, involved to design, implement

and maintain LAN and WAN (with channelized E1 and IP VPN) by linking

more than 80 branches island wide to the Head Office of Sri Lanka

Insurance Corporation Limited.

. Configured and maintained PIX Firewall, Cisco Core Routers, DNS

Servers, ISA and Domain servers.

. Configured and maintained IIS and Apache web servers to support ASP,

ASP.net and PHP applications respectively.

Sri Lanka Insurance Corporation Limited

Colombo, Sri Lanka.

System Analyst/Programmer : 1999-2003

. Analyzed existing computer systems and proposed about improvements

where appropriate.

. Gathered user requirements to analyze and designed new systems.

. Identifying options for potential solutions and assessing them for

both technical and business suitability.

. Created logical and innovative solutions to complex problems.

. Developed and presented project proposals to internal clients.

. Worked closely with developers (Internal or External) and a variety of

end users to ensure technical compatibility and user satisfaction.

. Followed an end to end process from development to rollout.

. Looked after the newly implemented systems.

. Planned to work flexibly to a deadline.

. Wrote user manuals and technical documentation.

. Maintained the existing production systems in IBM Mainframe and

AS400.

Education

. Master of Science in Computer Science, University of Colombo, Sri

Lanka -2006.

. Bachelor of Science in Physics (honors), University of Colombo, Sri

Lanka -1998.

Training

. Oracle10g Database Administration I/II.

. AIX System Administration.

. IBM Mainframe System Administration.

Contact this candidate