KRISHNA GOPALAN

Senior Oracle DBA

Phone : 978-771-6467 (cell)

978-692-4944 (work)

SUMMARY

¨ Senior Consultant with 16 years of overall work experience of which more than 6 years is in the IT field involving analysis, design, implementation and maintenance of business applications using Oracle 7.x & 8.x, Oracle Financials, Oracle SQL Plus and Microsoft SQL Server 2000.

¨ Full-fledged experience as an OCP Certified Oracle Database Administrator in Production, and Development Environments.

¨ Excellent SQL*Plus, Oracle PL/SQL, Microsoft TSQL skills with extensive experience in writing, deploying and debugging functions, procedures, triggers, packages etc.

¨ Sound technical knowledge in computer architecture, systems software, database architecture, programming tools, database tools and networking.

TECHNICAL EXPERTISE

Hardware: HP-9000, Sun E-450, Intel 80X86 Based Computers, Compaq Alpha Servers

OS: Unix - HP-UX 10.x, Sun Solaris 2.7 / 2.6, Windows-Microsoft

Windows NT, Windows 2000, Windows 9.x & DOS.

DBMS: Oracle 8i/8.x/7.x, Oracle SQL*Plus, PL/SQL, SQL*Forms, SQL Reports, SQL*Loader, Oracle SQL*Net 2.0, Net8, Microsoft SQL 2000, MS Access

Languages: C, PL/SQL, SQL, TSQL, Unix Shell Programming, JavaScript, HTML, and ASP

Tools: Oracle Enterprise Manager, Quest Spotlight, Quest SQLab, EZSQL, TOAD, SQL Enterprise Manager, SQL Query Analyzer, VivDba, SQL Profiler

Development

Tools: Developer 2000, Visual Basic, TOAD, SQL Navigator, and SQL Query Analyzer

Web Server: Internet Information Server

Designer Tools: Designer 2000

ACADEMIC QUALIFICATION

BS Mechanical Engineering, Osmania University, India

Diploma Management, I.G.N.O.U, India

MS Computer Applications, Madras University, India

CERTIFICATIONS

Oracle Certified Professional DBA

Brainbench Certified – Oracle 8.0 Administration

CORE COMPETENCIES

Database Administration:

¨ Installation, Configuration, DB Creation of Oracle 7/8/8i databases on various Unix and NT platforms. SQL Net configuration. Applying relevant OS patches. Configuration of different databases (Production, Test, Development)

¨ Database storage management and application deployment using RAID 5 and Veritas volume Manager.

¨ Backup and Restore: formulating backup strategies, developing backup scripts and backup automation. Creation of full-scale test procedure for backup and recovery to safeguard the databases against all kind of Media and instance failures.

¨ Performance tuning: Monitoring long running transactions. Using explain plan, utlstat, tkprof, Oracle Enterprise Manager and other Database tools to boost database performance.

¨ Working with development team: Participate in database design and data modeling and application performance enhancement/ debugging

Unix Administration:

¨ Administration / installation / upgrade and maintenance of SPARC Ultra with Solaris 2.7 & 2.6 and HP9000 with HP-UX 10.2

¨ Involved in tuning and maintenance of E450s with Solaris 2.6 and 2.7

¨ Installed Oracle on Sun and HP servers and configured client machines to connect to Oracle.

¨ Installation and configuration of Veritas Volume Manager

Application Development:

¨ Logical and Physical Design, Development and Implementation of a large Inventory Management project in a large Oil and Gas Company

¨ Extensive development of Oracle Stored Procedures, packages and triggers using PL/SQL

¨ Experience of data modeling using Designer 2000

¨ Worked extensively with Developer 2000, Forms 3.0 and Visual Basic6.

¨ Experience of developing complete web based applications in MS SQL and ASP

PROFESSIONAL EXPERIENCE:

Thomson Financial Treasury Systems, Boston MA Apr ‘01 - Sept ‘01

DATABASE ADMINISTRATOR

Description: Thomson Vision

Thomson Financial is a $1.44 billion provider of information services and work solutions to the financial and corporate communities worldwide and is a part of the Thomson Corporation, a leading e-information and solutions business. Thomson Vision is a complete treasury system that fulfils the needs of global banks and their dealers, incorporating financial control functionality that spans the treasury and capital markets areas. Worked on redesigning the Thomson Vision application, which used Oracle, SQL Server or Sybase as the back end, and C++ as the front end. He was involved with the following aspects:

Responsibilities

¨ Install administered and maintained Oracle 8i database

¨ Design, create and configuration of Production /Development/Test databases.

¨ Creation of tablespaces (datafiles), altering tablespaces and storage parameters.

¨ Rewriting SQL & PL/SQL statements and stored procedures, triggers etc.

¨ Installation and configuration of Oracle 8i database at Compaq test site on Alpha Servers for stress load testing the application using SilkTest tools

¨ Recommending Oracle database setup and tuning parameters at client sites.

¨ Generating database performance reports and application timing statistics using third party tools and SQL Profiler.

¨ Configuring Net8, SQL Net and ODBC.

¨ Use of Export and Import utility for backup / recovery and migration of databases.

¨ Use of SQL Loader to load data from flat files to Oracle databases

¨ Assist developers in tuning application through using Explain Plan, Tkprof, Utlstat and other third party tools like Quest TOAD, Quest SQLab, DBToolz, EZSQL, SQL Navigator etc.

¨ Regular Monitoring and Tuning of the databases using Database Tools like OEM, Quest Spotlight, VivDBA and self developed scripts.

Environment: Windows NT 4, Compaq Tru64 on Compaq Alpha Servers, Oracle 8i,

MS SQL Server, SQL*PLUS,PL/SQL, Transact SQL, SQL Profiler, SQL Query Analyzer, Quest Spotlight, Quest TOAD, VivDBA, EZSQL, DBTools, Silk Test Tools

DishnetDSL (India) Jan ‘01 - Mar ‘01

DATABASE ADMINISTRATOR

Description: Oracle Financials Implementation

DishnetDSL is one of India’s largest Internet Service Providers and leaders in providing DSL services in India. Worked as a Data Base Administrator for Implementation of Oracle Financials and maintenance of the Database.

Responsibilities as Oracle DBA

¨ Installation, administration, and maintenance of Oracle 8i.

¨ Installation and Administration of Oracle Application Database

¨ Creation of Tablespaces & Datafiles (logical segments, extents & blocks)

¨ Creation of Views, Synonyms and Indexes.

¨ Creation of Users and Roles in Oracle SQL Plus and granting Privileges to them.

¨ Wrote numerous database triggers for tables.

¨ Planning, Designing & Administration of logical and physical model of the database.

¨ Monitoring, Sizing and estimating the number of Rollback segments.

¨ Configuration of temporary segments to minimize the I/O.

¨ Media recovery of accidentally deleted Data files or user Tables.

¨ Fixing Fragmentations in the Tablespaces, Tables and Indexes.

¨ Rebuilding of Indexes at regular intervals.

¨ Supporting users in tuning their application (Explain plan & Tkprof)

¨ Tuning of SQL statements, PL/SQL modules for optimal performance in the client server environment.

Responsibilities as Solaris Administrator

¨ Installation and upgrading of Sun Solaris 7 servers and Veritas Volume Manager

¨ Configuring and networking clients to connect to the Applications.

¨ Formulating backup and recovery strategy

¨ Adding and managing space for effective utilization of resources

¨ Security privileges and profile management.

¨ Regular auditing

Environment: Sun Solaris 2.7, Oracle Financials, Oracle 8.1.6, Oracle Enterprise Manager, Oracle SQL*Plus, Windows NT.

Oil & Natural Gas Corp. India Apr ‘84 – Dec ‘00

DATABASE ADMINISTRATOR /APPLICATION DEVELOPER/ARCHITECT

Worked with Oil & Natural Gas Corporation, a giant global Oil and Natural Gas Exploration, Production and Contracting company from 1984 to 2000 in the Systems and Engineering Departments in various areas such as Systems Development, Database Administration / Equipment Maintenance, Condition Monitoring, Material Planning & Procurement etc.,

DATABASE ADMINISTRATOR

Description: Integrated Materials Management System (Feb ’97 to Jan ’01)

Since Feb. 1997, was the Oracle Data Base Administrator and was responsible for the design / development / testing and administration of Integrated Materials Management System; an Oracle 8.x / Developer 2000 based OLTP Inventory Management System. He was also responsible for the co-ordination of installation, commissioning and testing of the Hardware, Software and Network.

Responsibilities:

¨ Installation and administration of HP-UX servers

¨ Installation, Administration and up-gradation of Oracle and all its associated applications.

¨ Logical and Physical design of the Inventory Management application.

¨ Monitoring the space usage across all the mount points and space study/analysis

¨ Maintaining archive log files.

¨ Keeping track of Alert log files and trace files.

¨ Adding / resizing data files

¨ Handling the problems of Development users.

¨ Writing application modules using Developer 2000 and creating Oracle procedures/ triggers

¨ Routine operations of the Oracle Database e.g. Allocation and management of resources, taking backups, starting/shutting down the database, etc.

¨ Generation of audit trails as and when required.

¨ Performance tuning of the Oracle database.

¨ Performing crash management and recovery.

¨ Generation of periodic inventory reports and writing SQL for one-time reports required by the management and providing expert advice and handholding support to users on all issues

¨ Liaison with application developers and the support service office of Oracle Corp. to ensure optimal performance of IMMS.

¨ Planning and procuring hardware/software etc.

¨ Document Maintenance.

Environment: HP 9000 Series servers, Windows NT, Windows 9.x, (Unix) HPUX,

Oracle 8.x/7.x, Oracle Enterprise Manager, Oracle SQL*Plus, Developer 2000, Oracle SQL Forms, SQL Reports, Visual Basic, Oracle Enterprise Manager, TOAD, EZSQL, VivDBA.

DATABASE ADMINISTRATOR /TECHNICAL ARCHITECT

Description: Equipment Management System ( Jun ‘95 to Feb ’97 )

From 1995 to 1997, Krishna was responsible for the design / development, testing and installation of the Equipment Management Information System developed in Oracle 7.x and Visual Basic. He was the technical architect of the project and carried out the logical and physical design of the business rules, application and database.

Responsibilities:

¨ Technical architect of the project

¨ Logical and physical design of the Equipment Management application

¨ Implementation of the application using Visual Basic 5/6 and Oracle 7.3/8.05, ODBC , Crystal Reports etc.

¨ Extensive experience in writing PL/SQL stored procedures / triggers etc

¨ Installation and administration of Windows NT servers and client machines.

¨ Configuration of client machines to connect to the Oracle applications

¨ Installation, Administration and up-gradation of Oracle and all its associated applications.

¨ Performance tuning of the Oracle database.

¨ Performing crash management and recovery.

Environment: Oracle 7.3, Visual Basic 5/6, Crystal Reports, Windows NT,

Windows 9.x, ODBC

Earlier to this he was involved in the design and maintenance of many systems for Computerized Equipment Monitoring and Material Planning and Control.