SUMMARY:

• Installation and maintenance of Oracle Database Products. Use of Enterprise Manager to perform periodic monitoring and maintenance.
• Application of periodic patches, SQL tuning, backup and recovery with RMAN, and scripting (Unix Shell, AWK, SED, PERL) to create processes for performing monitoring and administration tasks, and ETL Processing using Oracle Data Pump, and SQL*Loader.
• Software patch release and, software configuration management, quality assurance
• PL/SQL procedures, functions, triggers, SQL Query tuning
• Use of C, C++, in custom application development

TECHNICAL SKILLS:

Development Tools and Languages: HTML, JSP, Java, JDBC, PERL, Korn/Bourne Shell Scripting, JavaScript, COBOL, Pro*C, C++, Oracle PL/SQL, SQL, CGI, EDI, SED, AWK, TOAD, PL/SQL Developer.

Database Management and Operating Systems: UNIX (AIX, SUN Solaris, HP), Oracle DBMS, MS Access

PROFESSIONAL EXPERIENCE:

Confidential

Database Admin/Developer

Key Skills: Oracle Database Administration, Tuning & Upgrade/Migration Support, Production Support

Responsibilities:

• Oracle Database Administration and application tuning on Sun Solaris platform, Linux & AIX
• Manages & Coordinates off - shore team work assignments
• Develops physical data models and consults in the development of conceptual data models
• Writes and modifies and tunes SQL, PL/SQL Code
• Designs, develops, implements, modifies and maintains physical databases.
• Investigates and resolves operational problems
• Recommends DBMS and delivery platforms
• Performs database backup and recovery, performance and tuning of SQL
• Participates in database products and tool evaluations, procurement, and testing.
• Develops and recommends tools and processes to support the database administration function.
• Performs build and software release process management.
• Unix Shell, AWK, SED and Ant scripting for automating application deployment
• Use of CA AutoSys Job Scheduler, PVCS, Service Now
• Use of Oracle Data Pump and SQL*Loader, PL/SQL to load and transform data

Confidential

Sr. Confidential IT Associate

Key Skills: Confidential ERP Student, Accounts Receivables technical and functional support, Oracle PL/SQL Stored Procedures, Functions, SQL*Loader, Pro*C

Responsibilities:

• Functional and technical support for Confidential ERP Student, Accounts Receivable Modules
• Integration and implementation support for Confidential Student and Resource-25 Event Management System
• Designed Evisions Form Fusion print templates for Confidential Student and Accounts Receivables Modules
• Created and modifies Oracle Reports, PL/SQL and SQL*Loader program units to support reporting, conversion tasks
• Designed and implemented data synchronization and mapping between Confidential Accounts Receivables, Student Modules and the Adirondack Housing Director

Confidential

Consultant/Developer

Key Skills: Development using Java, C++, UNIX scripting, PL/SQL, AWK, SED, and Production Support

Responsibilities:

• Designed and wrote Java (JSP, Tomcat, Object Serialization), AWK, SED, Unix Shell scripts, and PL/SQL stored procedures for a refresh system that interfaces and modernizes various legacy systems together
• Provide support and defect resolutions for systems that are in production
• Installs and updated Java, UNIX and SQL scripts on development
• Creates and updated, maintenance and design documents
• Provides testing and deployment support
• Evaluates software & Tools
• Manage off-shore team work assignments
• Works on pro*c, C, C++, and shell program units which handle communication between Unix server and a Micro VAX in real-time via RS 232 ports/Modems

Confidential

Oracle Database Administrator/Analyst

Key Skills: Oracle Database Management, Data Conversion, System Upgrades, System Automation, SunGard SCT Student Management System

Responsibilities:

• Maintained ORACLE 8i databases on development and production areas running on an AIX/RISC 6000 system for Administrative Computing
• Provided System Administration tasks by managing printers, and RAID disk drives via AIX SAM (System Administration Manager)
• Wrote SQL, PL/SQL, Anonymous and named stored procedures, triggers, and Oracle SQL*LOADER scripts to aid in the conversion of data from the legacy system to the Oracle Database
• Installed upgrades and patches for the Oracle based SCT Confidential 2000/SunGard SCT and Developer 2000
• Provided defect resolutions for Pro*C programs which accessed the Oracle Database for updating and reporting
• Wrote Unix Shell scripts to automate regular processes such as backup, archiving and routinely scheduled runs
• Designed Pro*C++ program modules to work along side Confidential 2000 student administrative system
• Installed and configured GNU C++ compilers, Oracle 8 Servers and Clients for Academic Computing
• Installed and configured web, mail servers, as well as, wrote Confidential programs and JavaScript, Java/JDBC to provide database access via a web interface

Confidential

Technical Consultant

Key Skills: EDI Mapping, Gentran Server Installation on Unix, Unix Scripting, Use of C/C++ for text manipulation

Responsibilities:

• Worked for Sterling Commerce’s client services division as product specialist. Installed and configured Gentran Server Workbench (EDI) for Unix at client sites
• Wrote Cleo A, Cleo B communication scripts as well as Unix Shell scripts and C++ text manipulation scripts for Interface System’s CLEO software to facilitate EDI data transfer to Value Added Networks (VAN’s)
• Made extensive use of UNIX Shell Scripts to process inbound and outbound EDI flows and other maintenance requirements such as archiving, clean up, and error tracking
• Designed and implemented systems to store outbound, inbound lifecycle information into Oracle databases with data modeling tools such as MAC A&D and ERWin
• Mapped outbound, inbound EDI documents ( Confidential X12 and Confidential standards)

Confidential

Applications Specialist

Key Skills: Data Conversion between Legacy Systems and Oracle, Data Mapping

Responsibilities:

• Installed and maintained Netscape’s web, mail and news servers on a Windows NT platform
• Developed interface programs from PC applications to the administrative software running on a UNIX host
• Worked on data conversion programs and provided technical and functional support for the Alumni Development software Raiser’s Edge from Blackbaud Inc
• Installed and maintained Oracle 7.x databases on a Windows NT environment for academic computing
• Developed Confidential scripts in PERL to create custom applications such as online student account look-up, online admission application

Confidential

Graduate Assistant

Key Skills: Tutoring, and assisting students in Computer Labs

Responsibilities:

• Provided assistance to students in Computer Labs on programming projects involving COBOL, C++, Pascal, and Excel Macros
• Evaluated student programming projects and assignments