SUMMARY:

To obtain a Senior Oracle PL/SQL architect/developer position

PROFESSIONAL EXPERIENCE:

Confidential

Technical Architect (Senior PL/SQL Developer)

Responsibilities:

• Work on the Confidential project, perform data reconciliation between the Obamacare website database and insurance company data
• Design/develop/support/tune PL/SQL code, Oracle 12c (SQL Developer)
• SVN/WinMerge/Linux

Confidential, Wayne, PA

Technical Architect (Senior PL/SQL Developer)

Responsibilities:

• Support/enhance the CCRIS system (commercial finance)
• Design/develop/support/tune PL/SQL code, Oracle 12c (TOAD)
• Design/develop/support Crystal Reports and the associated Business Objects server
• Convert SQR Reports to Crystal Reports
• Upgraded Oracle 11g to 12c

Confidential, Audubon, PA

Senior PL/SQL Developer

Responsibilities:

• Design/develop/support PL/SQL packages/triggers to dynamically generate HTML web pages used by electric power companies (eDart system)
• Create the tables/views/indices/constraints/grants needed for the eDart system
• Re - design the UI layout for several of the screens, implement the code changes
• Tune much of the code, re-write as needed to utilize newer features, such as bulk collects/DML, function-based indices, convert from dynamic to static SQL when possible
• Recommended and supported transition from interpreted to native PL/SQL compilation
• Assist other developers writing SQL and PL/SQL code

Confidential, Oaks, PA

Senior PL/SQL Developer / Data Architect

Responsibilities:

• Develop PL/SQL packages for processing financial data
• Tune the performance of various SQL and PL/SQL routines
• Perform data-modeling using ER Studio
• Purge large amounts of old data to alleviate production performance issues
• Re-partition large tables utilizing compound sub-partitioning scheme for performance improvement
• Implement frameworks for dropping and swapping partitions for ongoing data purges/archival

Confidential, Plymouth Meeting, PA

Senior Oracle DBA / PL/SQL Developer / Solution Architect (independent consultant)

Responsibilities:

• Solution Architect, responsible for all functional and technical aspects of approximately 10 home-grown Oracle-based systems, mostly running on UNIX/Linux
• Senior Oracle DBA, work with several other Oracle DBAs, performing all standard Oracle DBA functions
• Lead PL/SQL developer, design and implement major portions of the key Confidential retail and warehousing systems, approve all changes made by other developers
• Designed and implemented several PL/SQL frameworks (exception-handling, logging, table API, batch processing, email notification, date and time utilities, etc.)
• Gather business requirements, write analysis and design documentation for developers, approve A&D documents when written by other analysts
• Used Quest TOAD, SQL Navigator, CVS, WinMerge, SQL*Plus, Rational ClearQuest, Rational ClearCase, Oracle Enterprise Manager, Oracle Designer, Oracle Forms, Reflection, ControlM, HP ServiceDesk
• Prioritize functional and technical changes, based on cost, benefits, available resources
• Upgraded several databases from Oracle7 on OpenVMS to Oracle8i on AIX, then from Oracle8i to Oracle 10g on AIX and Linux. This included working closely with the AIX sysadmins regarding hard drive and filesystem sizing/layouts on the SAN.
• Converted from home-grown backup scripts to RMAN
• Converted from home-grown monitoring scripts to OEM/Grid Control
• UNIX shell scripting (mostly korn shell)
• Tuned multiple Oracle databases and instances, and countless SQL statements (mostly contained in PL/SQL packages)
• Assist/mentor junior developers and DBA’s, work closely with outsourcing partner, both on-site and offshore
• Interview applicants for PL/SQL developer and analyst positions

Confidential, Wilmington, DE

Senior Oracle DBA (consultant)

Responsibilities:

• Perform day-to-day production support
• Upgraded Oracle8i database to Oracle9i (AIX)
• Compelled developers to rewrite database apps using bind-variables
• Tuned databases with new features (index compression, temp tablespaces, etc.)
• Increased security (removed passwords from scripts, passwords on command-line, password security profiles, file permissions, etc.)
• Various development work, and assist developers and less senior DBAs

Confidential, Stamford, CT

Senior Oracle DBA/Database Manager

Responsibilities:

• Managed small team of Oracle DBAs, developers, and a junior UNIX sysadmin
• Lead Oracle DBA on private investor website
• Solaris system administration (mainly Solaris 2.6, 7) on Sun E250’s
• Performed all necessary upgrades, patches, and maintenance of servers, OS, databases, and other software
• Installed and configured Veritas Cluster Server on Solaris for database clustering, utilizing two Sun E250’s, and two mirrored Sun A1000 drive arrays
• Built and configured Sun servers used for web servers and app servers (Solaris 2.6, NES 3.6, NAS 2.1, WebLogic, Oracle Client, Java 1.2)
• Built and configured Sun servers for Veritas NetBackup, Samba fileservers, DNS and DHCP, and several Oracle servers
• Secured Solaris using such tools as SSH, IPSec and Titan
• Installed and configured all Oracle software (Oracle8i, Designer 6i, Developer, Enterprise Manager, Oracle Client)
• Data modeling with ERwin and Oracle Designer
• Worked with Sapient consultants on building the front-end of the website
• Created Oracle databases required for website, created all necessary schemas and objects
• Utilized Oracle Partitioning to ease data loads and minimize downtime during loads
• Wrote a large PL/SQL package, containing dozens of functions and stored procedures needed for ETL (extraction, transformation and load) of the data from various investment tracking systems
• Used SQL*Loader, export/import, and shell scripting to implement the database loads
• Tuned the database, instance, SQL and PL/SQL
• Implemented backup/recovery, using RMAN and Veritas NetBackup
• Used Oracle Enterprise Manager (OEM) and Toad for monitoring and development
• Assisted developers with database concepts, SQL tuning, and other concepts
• Designed, developed, and implemented web-based HR application utilizing an Oracle database, Oracle Application Server (Oracle9iAS), Oracle Forms, Oracle Reports, and JInitiator on Windows 2000
• Maintained MS SQL Server 7.0 databases
• MS Exchange 5.5 Administrator
• Tested, implemented, and supported the mail virus-scanner from Trend Micro
• Migrated the DHCP and DNS functions from Solaris to Windows NT, and then to Windows 2000.
• Assisted with network administration (Extreme switches, Checkpoint firewall)

Confidential, Stamford, CT

Director of Customer Support Services/Senior Oracle DBA

Responsibilities:

• Managed four employees (two DBAs, one QA tester, one help desk support analyst)
• Lead Oracle DBA (Oracle8, Oracle8i)
• Beta-tested Oracle8i, suggested several enhancements which were implemented
• UNIX system administrator for SUN, IBM, and HP servers
• Windows NT administrator (domain controller, print server, DNS, DHCP, web server, file server, applications)
• QA tested Confidential software
• Suggested Confidential product enhancements
• Tuned the Oracle components of Confidential ’s products
• Performed on-site demonstrations of product
• Performed installations onsite at clients’ facilities
• Trained customers on Confidential products’ usage
• Supported clients with all technical issues relating to Confidential ’s products
• Consulted for several clients (mainly Oracle database tuning)
• Remedy Administrator (designed help desk forms, ticket tracking system)
• Intranet development and administration (FrontPage, IIS, Windows NT)
• Assisted other departments (sales, marketing, accounting, management) with PC hardware and software issues

Confidential, Piscataway, NJ

Oracle Premium Support (Oracle DBA)

Responsibilities:

• Oracle onsite support expert - Focal point between Confidential and Confidential
• Assisted Confidential ’s DBAs and developers with Oracle installations, backup and recovery, tuning, designing applications and databases, bug and TAR research, upgrade strategies, conflict resolution, TAR escalations, etc
• The two main Confidential projects I was involved with were Pro*C applications on HP/UX, one called PAWS (Provisional Analyst WorkStation), the other called MEDIA ONE
• Had access to knowledge about Oracle’s products that is impossible to gain elsewhere
• Attended several courses only offered to employees of Oracle, that reveal many “features” and internal workings not made available to non-Oracle employees

Confidential, Boston, MA

Oracle and Sybase DBA

Responsibilities:

• Worked with a team of 30 DBAs, mostly Oracle, Sybase, DB2, and IDMS
• Lead Sybase DBA for DCA application (Distributed Computing Architecture), running Sybase on Solaris
• Performed major server, OS, database, and application upgrade on 30 DCA servers
• Supported databases used for multi-billion dollar trading systems, mostly on Sun Solaris
• Performed standard DBA tasks, both development and production support
• Helped design Fidelity’s Corporate Repository, and administered Solaris and the Netscape web server on the machine
• Relocated a large datacenter from Boston to Marlboro, Massachusetts, which was accomplished with zero downtime (received Presidential Award and bonus for this accomplishment)