SUMMARY

I am a very experienced database developer and administrator holding two MS Degrees in Foundations of Advanced Information Technology and Information Technology. I also have multiple Oracle database administration and development certifications relating to 9i, 10g and 11g. I have had over 6 years of hands on experience in the development, tuning and migration of various Oracle database version applications. In addition I have had over five years' experience of Oracle database administration - that is a total of well over 10 years' experience on various Oracle database releases either as a developer, administrator or both. I have had experience with Oracle 9i, 10g and 11g R1 R2 single servers and Real Application Clusters, RAC, databases and have performed optimization and performance tuning of SQL DML statements, and PL/SQL stored procedures, triggers and packages and database schema objects. I have also designed, modeled, and implemented creation scripts for the various Oracle database objects. I live in Hanover, Maryland and available, on 24-hours' notice, for a face-to-face interview and also available immediately for a new assignment. I have also had experience with Extraction Transportation and Loading, ETL, of enterprise data from multiple client OLTP databases to client data warehouse databases.

EMPLOYMENT/RESEARCH HISTORY

Tata Consultancy Services, Confidential

Oracle PL/SQL Developer at JP Morgan Chase, Wilmington, DE. Responsible for PL/SQL Development for financial services on Oracle Databases 11g and 10 g at JP Morgan Chase. Duties include UNIX Korn shell scripting, development, enhancement, and maintenance of PL/SQL package procedures and functions on Oracle 10 and 11g Databases.

Confidential

Successfully completed required academic course work, and passed the doctorate qualifying examinations that ultimately lead to Doctor of Science DSc. in Information Technology, Towson University fall 2012. Currently working on the required research/dissertation that is the required conclusion of the program, hopefully, in 2014. Now seeking a full-time employment, as what remains of the required dissertation can/will be completed on a part-time basis.

Part-time administration and maintenance of Oracle 11g Databases for EA Engineering services of Hunt Valley Maryland

Confidential

Database Engineer, Senior Professional

• Responsible for PL/SQL, and SQL development of new database packages, functions and procedures, tuning and upgrade of tens of existing Oracle database PL/SQL package applications running on Oracle 10 and 11g R1 R2 databases for the Centers for Medicare Medicaid Services, CMS to comply with upgraded client's requirements.
• Had previously been responsible for PL/SQL, and SQL development database server packages, tuning, and migration of Oracle 9i RAC and Data Guard database systems, including physical and logical standby databases to Oracle Database 11gR2 RAC database systems, including physical and logical standby databases running on Solaris 10 platforms and Oracle Automatic Storage Management file systems for the United States Citizenship and Immigration Service, USCIS. Implemented ETL processes for loading and periodic update of client data warehouses from multiple OLTP Oracle 10g and 11g R1 R2 databases.
• Had over the previous 4 and half years been responsible for PL/SQL, and SQL development and management of several production, standby, test and development Oracle 9i 10g databases for Department of Human Resources, DHR, the State of Maryland, Office of Home Energy Programs, OHEP, applications and CSC test and development laboratory on Solaris 8 and Windows 2003 Server platforms.
• My responsibilities have included design and implementation of database schema objects including tables and associated triggers, indexes, views and materialized views. Designed, coded, tested and implemented and deployed an extensive suite of stored procedure and package solutions in support of database application development and performance tuning solutions.
• Implemented high availability solutions, including RMAN backup and recovery solutions, Oracle Data Guard solutions, and Oracle Real Application Cluster, RAC, solutions.
• Also implemented an extensive suite of UNIX shell scripts for both Solaris system administration and database administration. In addition to the above development efforts I remained responsible for the administration and management of Oracle 10g, and SQL Server 2000 2005 databases for the State of Maryland, Department of Transportation, DOT.
• My responsibilities in this regard have over the years included the implementation and upgrade of several Oracle 9i databases to Oracle 10g databases and Oracle 9i and 10g databases to Oracle 11g databases on Microsoft Windows, Red Hat Linux, and various flavors of UNIX Operating systems.
• Most recently installed, tested and deployed Oracle Databases 11g R2 running on Solaris 10 and AIX 6.1 host servers for the DHR and MD Justice Information Systems, JIS, respectively, and successfully loaded production data through export/import utilities and Oracle Transport Tablespaces technology from Oracle 9i Database running on Solaris 8, and Oracle Database 10g running on AIX 5 respectively.

Confidential

Consultant Senior Oracle Database Administrator

• Worked at the Office of the Inspector General, Social Security Administration in Baltimore, Maryland, and was responsible for the administration and support of 4 production Oracle9i databases, and 4 Oracle9i test and development databases running on a mixture of Sun Solaris servers and HP-UX servers.
• Duties, in addition to routine production database administration and support, included design and implementation a database high availability scheme and disaster recovery strategy, including both logical and physical backups, database refresh, and disaster recovery schemes, regular scheme testing and DBA training schedules.

Confidential

Consultant Oracle Database Developer

• Consultant to the World Bank Group in Washington DC
• Responsible for development and maintenance of Oracle back-end applications for financial services and portfolio management for the Treasury Division of the World Bank Group.
• My duties included design, implementation, and performance tuning of Oracle 9i database objects tables, views, materialized view, triggers, stored procedures/functions and packages and applications in SQL and Oracle PL/SQL.

Confidential

Software Analyst

• Responsible for development, enhancement, customization, and maintenance of a suite of distributed N-tier Object Oriented application software for supply chain and transportation execution, management and optimization for tens of business customers, in C , Java, PL/SQL, SQL, and CORBA, on various flavors UNIX, Linux and Windows 2000 Server platforms and Oracle 9i database. My duties included implementation of Oracle9i PL/SQL stored procedures, packages, Java call methods and triggers on relational and object tables.
• Performed optimization and performance tuning of SQL DML statements, and PL/SQL stored procedures, triggers and packages.
• Designed and implemented database schema object scripts, SQL Loader data load and migration scripts. Implemented UNIX shell scripts tools for system and database administration.
• Provided direct support to production Oracle DBA in various schemes like performance tuning, implementation of data load schemes, implementation of Oracle Data Guard High Availability schemes, and Oracle Recovery Manager, RMAN, backup and recovery strategies and scripts.

Confidential

Software Engineer

• Consultant software engineer to Computer Sciences Corporation, Egg Harbor Township NJ, July 1999 - December 2003.
• Was a member of team of software engineers/developers responsible for formal requirement analysis, design, coding, system Integration testing, and maintenance of the Departure Scheduling Programs DSP and En Route Traffic Control Suites of software for departures and en-route air traffic control, capacity optimization and management for the Federal Aviation Administration, FAA. My responsibilities included requirement analysis, preliminary software design prototyping, final design and implementation/coding, unit testing, maintenance, and enhancement of various software modules. Implemented the layout design, database creation scripts and initialization parameter files, and creation of Oracle 8i/9i development databases as models for the production databases.
• Performed DBA duties, including RMAN backup and recovery, performance tuning, and layout design on the Oracle 9i development database, including production of scripts and methodology for deployment at the client's production database.
• Implemented various UNIX Shell scripts for both software development and system management and productivity tools.
• Designed, modeled, and implemented creation scripts for the various Oracle 8i/9i database objects tablespaces, tables over 100 tables , indexes, views, packages, stored procedures function, and triggers using SQL, and the PL/SQL programming language on HP-UX 11.I tuned the database, SQL queries and statements, and the PL/SQL subprograms and blocks. I designed, developed, tested and deployed numerous Oracle 8i/9i Packages, standalone PL/SQL stored procedures and functions, DML and System triggers for efficient database access, update, audit, and complex data integrity constraint implementations.
• Also designed and implemented user interface GUI and database access functions in Motif and Oracle Pro C/C pre-compiler on X-Windows and HP-UX10/11.
• Was also responsible for the design, deployment and administration DBA of the development/test Oracle 8i/9i databases close replicas of the production databases , the development and implementation of Oracle 8i/9i server backup and recovery and archiving strategies, including a recovery catalog database, recovery manager, RMAN backup, restore and recovery scripts for the production database using the development database for testing as the target database.
• Consultant software engineer to First USA Bank NA, Wilmington, DE March 1999 July 1999 :
• Designed, coded, tested, and deployed software from user requirements and specifications documents to process delinquent customer accounts for daily electronic delivery of the resultant files to VISA Corp., USA. A completely Object Oriented implementation to specifications mandated by Visa Corp., and implemented using C , Pro C , PL/SQL, SQL on a UNIX AIX platform and an Oracle 8 database.

Confidential

Software Engineer

Responsible for the design, implementation and coding of software application for the analysis of geophysical data from off onshore oil and gas wells. Project involved Object Oriented implementation of oil industry artifacts with C class objects. Oracle 8 database access methods and functions were implemented using Pro C/C , PL/SQL and SQL. GUI interface Objects were developed using Motif of X-Windows environment and Solaris 2.6 platform while maintaining strict POSIX compliance to guarantee portability to other platforms e.g. AIX, HP-UX .

Confidential

Software Engineer

• Part of a team of that successfully accomplished the development of call center client/server business applications to link call center front ends to the client's mainframe/legacy systems and heritage stores. My responsibilities included the implementation of Oracle 7 database objects and access functions using Pro C/C , SQL, PL/SQL, Java and C programming languages.
• Was a member of a team of three developers on the Logica's communications Gateway product to process credit cards employing third party communications API's in a completely Object Oriented design using C implementation on a Solaris platform.
• Analyzed, developed, and implemented Motif and X-Windows GUI Components and objects and their callback functions using Rogue Wave C implementation and class library.
• Developed applications for air traffic control and simulations for the training of air traffic controllers in Object Oriented development using C , with a Motif GUI interface on a Solaris platform.

Department of Computing

• Responsibilities included software development, and implementations in C/C on a UNIX platform, including implementation of applications for parallel, message passing, distributed memory parallel computers using C and MPI message passing interface standard. I ported applications written in COBOL to C , and provided other software optimization and enhancement to the applications. Researched and implemented several applications for scientific and engineering computations in C and MPI on the distributed memory parallel multi-processor computer on the UNIX platform.
• Also implemented and ported a flat text file database to a relational database, Oracle 7. This involved the implementation of database object creation scripts, creation of logical and physical database objects, and the implementation of data load scripts. Skill used included UNIX shell scripting, SQL, PL/SQL, Pro C, and C programming language.
• Researched and implemented several protocols/algorithms for distributed computing including reliable fault tolerant broadcast algorithms in C on a UNIX platform, including an application for solution of differential equations and a library of linear algebra solvers running on massively parallel distributed memory computers. Applications were developed in C and Fujitsu native message passing library.

Confidential

Teacher/Computer Network Manager

Taught Information Technology and mathematics at Stockwell Park High School, London. Responsibilities included training of teaching and non-teaching staff on basic computing/IT skills and application software packages. I installed and commissioned a PC LAN network of 2 Servers, 80 IBM Compatible PCs, and peripherals. I also installed and commissioned a LAN a network of 30 Apple Macintosh PCs and application software. I configured and commissioned more than 20 stand-alone IBM compatible PCs, peripherals and applications software in various locations around the school. I designed and established a database inventory for the school's equipment and resources using Microsoft Access.

Confidential

Design Engineer

Led teams of engineers and technicians in the preliminary and final engineering design, preparation of working drawings, and tender/contract documents for several civil engineering and building works. I developed and tested software aids for civil and structural engineering design computations and project management using the Fortran 77 programming language. Ported, optimized and enhanced several software aids for engineering design and project management from Fortran 77 to Object Oriented C . Designed and implemented in C , on an AIX platform, several of the software aides for civil/structure engineering design, project management.

SKILLS/TECHNOLOGIES

Oracle 9i, 10g 11g RDBMS, SQL, Oracle PL/SQL Developer, Oracle Pro C/C , C/C , Java, SQL Developer, Korn Shell Scripting, Microsoft SQL Server 2000 and 2005 RDBMS. All these had been on UNIX AIX, HP-UX 10/11, and Solaris 8/10 , Linux, and Microsoft Windows 2000 2003 Servers.