Rafael Orta
Senior Oracle Database Administrator
Certified Oracle 7.3, 8.0, 8i Database Administrator
12 Longbridge Drive, Mount Laurel ,
NJ 08054
USA
e-mail: rorta4@home.com
WORK EXPERIENCE:
Comverse Inc. Senior Oracle DBA. 11/01 - Present
Dimension Data
Oracle Corporation Principal
Consultant 11/97
– 11/00
Bluestone Consulting Database Administrator 04/97 -11/97
Oracle Corporation Technical Associated 10/94 -04/97
Conduven Oracle Database Administrator 03/94 - 09/94
Laboratorios Fisa System Analyst 05/92 - 03/94
Distribuidora Tejitex Data Processing Analyst 01/89 - 05/92
- Oracle
Products:
Oracle 5.0, 6.0, 7.0,7.1,7.2, 7.3, 8.0, 8i,9i, SQL, SQL*Plus, SQL*Forms V3.0, SQL*Menu 5.0, PL/SQL V1, V2, Oracle Forms 4.0, 5.0, Developer 2000, Designer 2000, SQL*Loader, Oracle Enterprise Manager, Oracle Advance Replication, Parallel Query, Oracle Parallel Server, Oracle Distributed Database, SQL*Net V1, V2, Net8, Oracle Office, Oracle Power Object, Oracle Mail, Oracle Power Browser, Oracle General Ledger, Jdeveloper, Oracle Application Server, Oracle Fail Safe, Oracle Names Server.
- Operating
Systems:
UNIX ( SCO UNIX, HP UX, AIX, Sun Solaris, Sun OS, AT&T, Tru64), Windows 2000, Windows Me, Windows 98, Windows 95, Windows 3.1, Windows for workgroup, MS DOS, APPLE MAC, Windows NT, Novel Netware, Open VMS.
- Management/Leadership
Skill:
Practice leader for Dimension Data
Project Manager for the CommerzBank.
Project Manager in an Oracle Application Development.
Duty Manager in Technical Support.
Coordinator of a System’s Department.
- Database
Administration:
Oracle Installations on UNIX, Windows 95, Windows 98, Novel Netware, Windows NT, MS-DOS, Windows 3.1, Windows for Workgroup, Windows 2000, MS OS/2, Open VMS, Database Design and implementation, Design and implementation of Backup and Recovery policy , Migrations, Upgrades, Design and Implementation of Symmetric Replication , Parallel Query, Distributed Databases, Tuning of RDBMS and applications (SQL Tuning). Design of Database Benchmarks. Design and implementation of Security and auditing policies Setup and implementation of OEM to control, maintain, administrate and monitor the customer’s databases. Oracle Parallel Server tuning and administration.
- Life
Cycle Expertise:
Data Modeling, Business Analysis, Implementation, Product Installation, Requirements Analysis, System Support.
- Specialty
Skills:
Basic, PL/1, Pascal, FORTRAN 77, Rex, SQL, COBOL, PL/SQL, HTML, SQL*PLUS, Administration, Installation, Configuration, Upgrades, Migrations, Tuning, Support of Oracle Databases and Oracle Tools, Logical and Physical Database Design and Implementation, Design and Implementation of Backup & Recovery strategies. Design and Implementation of Security and Auditing policies. OEM setup and implementation (including setup of jobs and even to facilitate maintenance), Onsite Support, Working with Oracle Support to make customer’s environment bug’s free, Patch installations, excellent analytical skills.
- Other
Products:
MS Office, Mac Paint, Mac Draw, Work, Lotus 123, Norton Utilities, Visual Basic, Word Perfect, Word Start, Harvard Graphics, Ominis 7, Mac Write, Norton Antivirus, Sapphire Web, Netscape, Lotus Ami Pro, Exceed, Windows Explorer, Visio, Microsoft Project, Erwin,
Toad, Reflexion, PCAnywhere, etc.
- Methodologies:
Structured Analysis, Structured Programming
- Instructor:
Conduct Oracle technical training. Courses taught include Relational Data Modeling, Oracle Apps. Functional foundation Release 11, SQL*Plus, PL/SQL, Advanced Database Administration.
- Communication/Networking:
TCP/IP (Telnet, FTP, RCP, rsh, ping, rlogin), Internet, Intranet, SPX/IPX, Ethernet LAN.
PROJECT EXPERIENCE:
- Comverse Inc, Senior Oracle DBA, November
2001 – Current.
Currently engaged in a project to redefine all the security (roles, privileges, accounts, resource consumer groups, password policies, auditing, etc) of the pre-paid application. Fifth level of technical Database Support for Comverse customers around the world. Oracle OPS Tuning, Implementation of Oracle Auditing mechanism, Creation of intelligent shell script to diagnostic the health status of the database, creation of scripts to diagnostic replication status of the database, creation and implementation of a Mechanism (totally designed in shell script) to automatically fail over the pre-paid application to the surviving node (OPS). Benchmark and Oracle Diagnostic / Tuning using Oracle Enterprise Manager in order to meet the required calls per second. Creation of mechanism to prevent Oracle deadlocks caused by the same application.
- Didata – TimeBdrige
Technologies, November 2000 – November 2001.
CommerzBank,
November 2000 – August 2001
Project Manager for the Wall Street Frankfurt replication Project, Responsible for the fail over strategy in the EMC migration project. Member of the team designing the new OFA structure under the EMC hardware. General Oracle Technical support for the Bank. Creation of Documentation about Names Server configuration and Oracle Enterprise Manager Configuration. Knowledge transfer to the new members of the DBA staff for the Bank.
Oracle internet Directory Deployment, Member of the migration staff that Migrated 27 Databases to EMC running oracle 8.1.7
- Oracle
Corporation, Principal Consultant, November 1997 – November 2000.
CommerzBank,
March 2000 – November 2000
Onsite Support for all the Bank specially for the Data warehouse users, and
developers, Database Administration of 19, 10GB databases. OEM Installation,
setup and Implementation in order to help me with the control and
administration of this databases. Performance tuning,
SQL tuning. Upgrades and Installation of Oracle Software and
databases. Design and Implementation of security and auditing policies,
Design, Programming
and Implementation of a new application in order to facilitate
the rebuild of corrupted indexes and analysis of tables. Recovery
of Databases and evaluation of the backup and recovery policies in order to
optimize it, Patch application. Worked with Legato
Support and Oracle Support to solve a problem that Networker
was having backing up Oracle databases. Member of the
Data warehouse team, Member of the Oracle financial Installation and
Implementation team. Upgraded 22 production databases
of 20GB each from 8.1.5 to 8.1.6 in 2 weeks. This upgrade was used as a
pilot to upgrade all the branches of Commerzbank
around the world. Installed and configured OAS v4.0.8.1 in all the customers nodes.
Etravel.com, October 1999 -
March 2000
Technical Support, Database
Administration tasks, Performance Tuning, SQL Tuning ,
Backup & Recovery strategy, Member of the capacity planing
team, Member of the team to design the new hardware and network architecture
for e-travel. Member of the team to lead the integration of the new release of
the application, Participated in the process of Hiring a new DBA. Provided knowledge transfer to several members of the e-travel
staff regarding to DBA tasks and new features. Reviewed the Entity
Relationship diagram of the new application and suggested changes. Provided
Database Tables documentation and identified the changes made between releases.
Dice.com, September 1999
Completed
re-creation of the database, database administration, performance tuning, and
technical support. Helped to design intermedia
applications using PL/SQL and tune them for best performance. Worked with Oracle Technical Support to fix bugs.
MyCNN.com, September 1999
Database Administration,
Performance Tuning. Part of the team to migrate from Oracle
7.3 to Oracle 8i and from Context to Intermedia for
the web page myCNN.com. Monitored the database.
Created several shell scripts that will help to reduce the manual maintenance
of the database.
Cendant, Mortgage, July 1999
Performance tuning based on
statistics & Technical Support.
Sempra
Energy Trading, March 1999 - Jun 1999
Conducted migration
from Lotus Notes to Oracle 8.0.4. Provided technical
support for users, conducted performance tuning, and created procedures for
backup & recovery. Created Standards and
Procedures. Provided technical support for the DBA.
Oracle Corp. (Cleats), March
1999
Oracle Apps.
Rel 11
Installation on NT Server. Configured CLEATS.
Oracle Corp. (D&B),
February 1999
Oracle Apps.
Rel 11 Installation on Sun Solaris 2.6 and on 2
NT’s servers.
Jos. H. Stomel
& Sons, January 1999
Designd Backup and Recovery policy for a Oracle 8.0.5 Database on a Sun Solaris 2.6 using Backup Manager.
CAPCOM, January 1999
Installed and configured 3 Oracle Database servers, completed ODBC configuration, SQL*NET configuration, OEM installation and configuration. Migrated from MS Access to Oracle 8.0.5. Trained customer in OEM and Oracle architecture.
NEOUCOM, December 1998
Installed and configured Oracle
databases on 2 Unix Servers.
Oracle Corp. COE (
Member of a team that installed 10.7 NCA and 10.6 Smart Client Application. Designed backup and recovery strategy for these installations, and created automated maintenance scripts.
Electronic Document System,
December 1998
Assisted in
migration from Oracle 6.0.36 on Novell Netware to Oracle 8.0.4 on Novell
Netware.
Installed and configured Oracle
8.0.3 on AIX. Installed and
Configured OEM, Designer2000 and Developer2000 on Windows NT.
Charming Shoppers, November
1998
Provided technical
support and performance tuning on 2 Oracle 8.0.5 databases.
Jos. H. Stomel
& Sons, October 1998
Designed backup and recovery
policy for a Oracle 8.0.5 Database on a Sun Solaris
2.6 using Backup Manager.
General Cigar, DBA, October
1998
Performed performance tuning and diagnosis of problems on two HP9000 machines.
Encore Computer, DBA, October
1998
Created replication environment master site to master site, asynchronously, between two Sun Solaris machines.
Chase Manhattan Bank, DBA, November,
1997 - October 1998
Migrated four production databases (7 x 24 80Gb e/o approx) from RDBMS V6.0.35 to RDBMS V7.1.6 and from Open VMS V6.2 to Sun Solaris 2.5. It also included the migration of the application (sql, frm, rex, pc, mnu). Migrated two production databases from Oracle v6 to Oracle v7.1 on Open VMS V6.2. Tuned RDBMS and customer’s application. Completed database design and implementation. Provided technical support for the Globalnet Department on Oracle (7.1 , 7.3) and UNIX (Sun Solaris 2.5). Trained developers on Oracle Database Administration. Maintained four production databases. Provided technical support for Chase Manhattan Bank World Wide Technical Support Staff, Developed Complex reports using SQL*PLUS for Globalnet Database Administration.
TV Guide,
DBA, May 1998
Diagnosed replication related performance problems on a pre-production environment.
EPS (Electronic Payment Services Inc.), DBA, January 1998
Helped recover two production databases (7 x 24)
HIDTA (Federal Bureau
of Investigations), DBA, November 1997
Designed and implemented Backup and Recovery policy for two Production databases
(7 x 24). Conducted performance tuning.
- Bluestone Consulting Inc, Database Administrator, April
1997 - November 1997
General
Wireless, DBA, October 1997
Provided Oracle technical support, database administration, performance tuning, and database installation.
Solbright, DBA, August 1997 - September 1997
Designed, installed, and configured Oracle Database. Did database administration, performance tuning, and Oracle technical support.
Designed and implemented the backup and recovery policy. Maintained the replicated environment, and did database administration, performance tuning and user training.
Robert Wood Johnson Foundation, DBA, April 1997 - May 1997
Designed, installed, and configured Oracle Workgroup 7.3 on NT. Installed and configured Oracle Enterprise Manager on Win95. Installed and configured Sapphire Web for Windows NT. Technical Support on Oracle 7.3.
Internal
Projects:
Proposals for Colonial Pipelines Project, Tyco Project and Delaware Prosecutor’s Office.
- Oracle Corporation, Technical Support Consultant,
October 1994 - April 1997
Software installation, upgrades, and migrations. Provided technical assistance in administration and tuning of Oracle databases. Resolved customers’ database problems. Conducted customer training. Developed internal applications. Coordinated tasks. Assisted in development with Oracle tools. Assisted in backup and recovery strategy and database structure strategy, Oracle Database Administration V5, V6, V7.
- Conduven
Designed the development and production environment. Evaluated RDBMS (Sybase, Informix, Oracle). Evaluated and designed hardware and network topologies. Designed database benchmarks. Designed downsizing project. Developed application. Selected network and database. Oracle Database Administration.
- Laboratorios Fisa, System Analyst, May 1992 - March 1994
Developed application as Programmer Analyst and Leader Project. Tuned application. Migrated Database (Oracle V5 to V6). Development of interfaces between COBOL and Oracle. Oracle Database administration V5, V6. Provided internal training. Performed maintenance of systems such as purchasing, general ledger, human resource, billing.
- Distribuidora Tejitex, Data Processing Analyst, January 1989 - May
1992
Data transcription. Developed applications in Basic and Oracle. Application maintenance. Control and distribution of task. Analysis and interpretation of accounts and bill balances. Provided hardware and data design. Completed statistical projection of hardware and data growth requirements. Oracle Database Administration V6.
CERTIFICATION:
- Oracle
Certified Professional Program (OCP)
Certified Oracle 7.3 Database Administrator
Certified Oracle 8.0 Database Administrator
Certified Oracle 8i Database Administrator
Candidate for Oracle 9i Database Administrator
EDUCATION:
Instituto
Universitario de Nuevas Profesiones,
Candidate for M.S. In Computer Science specialization in Database and Knowledge-Based Engineering at NJIT.
TRAINING
- Oracle Training:
Very Large Database/Terabyte Database Administration 8i.
Parallel
Server Administration 8i.
Designer 2000 -- Design and Construction of Systems
Developer2000
Oracle7 Advanced Database Administration.
Oracle7 Database Administration Workshop
Oracle Internals V7.0 Workshop
Oracle7 New Features Option Workshop
Design of Applications with Oracle Forms 4
Oracle Gemms
Backup
and Recovery Workshop
Introduction to SQL*Forms V3.0
Administration of Oracle Database V6.0
Applications Tuning V6.0
Database Architecture V6.0
Introduction to PL/SQL V1.0
Introduction to SQL*Report Writer v1.1
Introduction to SQL*PLUS v3.0
Introduction to SQL*MENU v5.0
Design of Relational Database V1.0
Mastery in Technical Support V6.
Mastery in Analysis and Design of Systems
Mastery in Database Administration V6
Oracle Technical Training (BAP)
Oracle Office
Oracle General Ledger Release 10SC.
Oracle Financial Technical Foundation.
Oracle Applications System Administration Rel. 11
Advance Symmetric Replication
Oracle 8i New Features for Database Administrators
Java for Oracle Developers.
Oracle Context Cartridge.
- Other Training:
General Ledger
Workshop of Total Quality
English as Second Language
Basic
Seminar Internet Today
P.E.C.E.S. in the Company
Sapphire/Web NT Training Course
Visual Basic 4.0 -- Basic
Visual Basic 4.0 -- Advanced
Introduction to UNIX Operative System
Basic Use of UNIX Commands
Advanced Use of UNIX Commands
Problem Solving & Decision Making
Professional Software Support
HTML