Isaac Roda Email & Phone Number

1601 Market St, Philadelphia, Pa 19103

• Primary responsibilities include supporting numerous Oracle and SQL Server databases as required by the business users.. • Provided Oracle 9i, 10g, 11i, and 12c database design, sizing, automated installation scripts, and backup/recovery on HP/Ux and Linux based servers. • Provide SQL Server 2000, 2005, 2008R2, 2012, and 2014 database design, sizing, automated installation scripts, and backup/recovery support on x64 clustered and non clustered servers.• Provide programming support to develop server/user management scripts and application using shell, perl, cgi, and html scripting as required.

• Primary responsibilities include managing development resources and overseeing Oracle database and related items as they pertained to the database core R&D group. • Managed DBA projects for database core R&D group.• Create technical requirements documents (TRD), high level design documents (HLD), and detailed design documents (DDD) in support of DBA projects• Provided Oracle 8i and 10g database design, sizing, automated installation scripts, and backup/recovery on AIX, Digital, HP, and Linux based servers. • Provided on demand support to tier 4 tech supported when needed.• Developed Technical Requirements, High Level Designs, and Detailed Designs for database core group as related to new products.• Developed Marimba implementation for software delivery.

• Primary responsibilities include managing development resources and overseeing SQL Server and Oracle database operations and procedures. • Maintain a 24x7 database environment that meets stringent client uptime demands.• Served as interim DBA department manager in addition to Development Team manager during personnel transition period.• Interface with internal business managers to gather requirements and assess change requests.• Mentor junior DBA’s and developer staff on various best-practice methodologies.• Maintain Shire related software applications.

• Provide complete DBA and development support for production and development Oracle and SQL Server Data Warehouse including physical and logical design, implementation, support, development and review. Team leader providing training and mentoring for junior level DBA's and developers.• Team provides support of physical Oracle, SQL Server, and upload servers. • Provide backup Unix/Linux support to IT dept. • Installed and support various versions of Oracle including 9i and 8i, SQL Server 2000 and 7, as well as other DBMS's. Wrote routines to daily load SQL Server data marts from Oracle warehouse, many stored procedures, functions, etc. Provide developers support with sql tuning and programming. • Installed MicroStrategy schema and meta data schema on Linux/Oracle and W2K/SQL Server platforms. • Installed and customized SalesLogix CRM product used for physician management. • Developed numerous web and client server applications in support of various projects related to network relations, accounting, development and production systems. • Installed and provide database support for MAS200 accounting system. • Data Warehouse support includes data modeling using ERWin and Microsoft Visio, software development using PL/SQL, TSQL, Perl, HTML, Javascript, Visual Basic, and Microsoft .net framework.• Perform physical DBA functions including database creation, storage sizing, users, backups, recovery, data migration, OS support, etc.

• One of 4 DBA's, helped, designed, develop, and support CRM DSS Product Allegiance. Allegiance is based on a two database (transactional + data warehouse) model. Developed any combination of SQL Server (6.5, 7, and 2K), Informix (Redbrick), and Oracle 8i DBMS for production clients. Also developed an MSDE and VFP single database product for local demo's.• Used Erwin for the initial data modeling processing and to reverse or forward engineer the model to the various DBMS. Used UML diagrams and Visio in support of various design or documentation tasks. • Perform physical DBA functions including database creation, storage sizing, users, backups, recovery, data migration, etc.• Write PL/SQL, TSQL, Perl, Java, and VFP procedures, classes, functions, packages, etc. in support of nightly data loading operations, journal processing, internal and customer requests. Also write HTML and Perl CGI for internal support intranet, and special data processing needs as required• Help Java and VFP developers write SQL or review their SQL to optimize query performance.

• Managed the IT department in support of Penn Bottle corporate and all remote locations. • Developed various database and multi-user applications in support of Pro IV manufacturing application which used an Oracle 7 database. • Administered Oracle on both Windows and UNIX platforms. • Provided user support and training to Corporate and remote offices.• Developed initial corporate web site and installed company wide e-mail system using Mercury Mail relay and Pegasus Mail clients. • Developed various VFP applications to analyze sales and inventory data.

• Fulfilled contract consulting positions with several large clients including Cape May Foods, Palko Continental, BMG, and HIP Philadelphia. • Primary role was developing custom client-server applications with Visual FoxPro and building relational databases.

• Worked within the engineering group providing project management and programming support. • Installed administered, and supported Unix Systems and Netware Servers. • Wrote automated Log Book software to replace manual log books used throughout the Naval Fleet for Marine Gas Turbine Engines.

• Performed finite element analysis & modeling as well as stress • and life analysis of various turbine components. Field service • engineering in support of marketing department at General Dymanics, Fort Worth, Texas.