OBJECTIVE:

Senior Netezza Administrator or Storage Engineer position

SUMMARY:

• Netezza certified, 10 years solid experience with the Netezza data warehouse platform (Mustang, TwinFin, Striper).
• Strong experience with managing EMC/Dell VNX 8000 storage platform
• Strong experience managing Netapp 6240 NAS
• Strong experience in managing EMC Data Domain backup system
• Some experience managing EMC Isilon storage system
• Familiar with all phases of software life cycle. 3 years Oracle 9i/10g administration/maintenance.
• 18 years’ experience in relational database design and SYBASE ASE administration/maintenance.
• Sybase certified ASE version 12.0 DBA. Oracle 9i certified (OCA). 25 years’ experience using/administering Unix/Linux systems

TECHNICAL SKILLS:

• Dell 2650, SUN SPARCSTATION, SUN ULTRA SPARC, Sun Blade
• IBM PC, DG MV Family, VAX, PDP
• UNIX, SOLARIS, Red Hat Linux, SUNOS, HP - UX, VMS, RSX-11M, MS DOS
• Java, JSP, JDBC, PERL, C/C++, JavaScript, HTML, SQL, PL/SQLsh, ksh, bash, csh
• Netezza Data warehouse (TwinFin, Striper, Mustang models)
• EMC VNX 8000 NAS/SAN
• Netapp 6240 NAS
• EMC DATA DOMAIN 9500
• EMC Isilon
• SYBASE, INGRES, ORACLE, MySQL database servers

EXPERIENCE:

Confidential

Responsibilities:

• Member of a project serving as the senior Netezza DBA where work was performed on Confidential ’s.
• Advised client developers on how to write optimal SQL queries, distribution techniques, monitored/tuned performance of the ETL jobs, performance tuned NPS system, troubleshot/fixed system problems and managed backups and upgrades.
• Responsible for managing/administering a Netapp 6240 using Ontap 8.1.2 operating system to provide file system storage (NAS) within our data center environment.
• Also responsible for managing/administering EMC/Dell VNX 8000 hybrid storage platform (NAS/SAN) to provide both file system storage within our data center environment and block level storage with several Oracle RAC servers used in processing the data within our enclave.
• Utilized EMC Data Domain backup system to provide backups for Oracle RAC servers and backups for file level storage.
• Assisted with various Linux system administration tasks.

Confidential

Responsibilities:

• Member of a project serving as the senior Netezza DBA where work was performed on Netezza TwinFin’s and then migrated to the Striper model.
• Advised client developers on how to write optimal SQL queries, distribution techniques, monitored/tuned performance of the ETL jobs, performance tuned NPS system, troubleshot/fixed system problems and managed backups and upgrades.
• Also responsible for managing/administering a Netapp 6240 using Ontap 8.1.2 operating system to provide file system storage within our data center environment.

Confidential

Responsibilities:

• Member of a project serving as the senior database engineer developing a major data warehouse.
• Work was performed on Netezza Mustang 10200 and 10400. Developed/designed schema’s, stored procedures, views.
• Advised client developers on how to write optimal SQL queries, monitored performance and managed backups. Helped with the development and troubleshooting of the ingestion code which was originally written in Pentaho Kettle, but, was re - developed as Java processes.
• Wrote various Kettle based SQL scripts to produce various metrics reports for analysts/management review.
• Managed and attended monthly briefings with the customer.
• Worked with testers to establish system and integration testing to verify integrity of data being populated into the data warehouse and documented the results.
• Member of the Netezza pilot project.
• Evaluated, managed, and administered Netezza 10200 to evaluate the system as a viable alternative data warehouse platform for a high profile project.
• Performed numerous benchmarking tests to determine the 10200’s potential query performance and transaction rate.
• Converted Several complex analytic queries to execute on the Netezza appliance on a 20 Terabyte dataset to determine whether these analytics could be run in the required time frame. Wrote numerous reports describing the results of the testing for senior management review.

Confidential

Sybase/Oracle/MySQL DBA/developer

Responsibilities:

• Designed database using Borland Together ER diagramming tool.
• Evaluated two reporting tools (Jreport, Cognos ReportNet) which were to be utilized as a reporting interface for analysts and administrators in the first release.
• Confidential was chosen as the reporting tool due to its ease of integrating it in with our JEE architecture. Wrote multiple metric and analysis reports using this JEE based interface against the Sybase ASE 12.5 and Oracle 10g databases.
• Also involved with developing and maintaining the server side based Java classes utilized within the DAO and EJB layer of our application server (JBOSS 4.0).
• Responsible for the development and maintenance of all the stored procedures in support of the application, SQL query and system performance tuning, backup and data administration DBA tasks and procedures, and other DBA administrative duties.
• Client application was a JEE application utilizing the JSP, JSF, EJB (stateless session beans) JEE components and Java server side classes (DAO layer) deployed to a JBOSS 4.0 application server.

Confidential, Frederick, MD

Oracle and MySQL DBA

Responsibilities:

• Designed the database using Oracle 9i designer CASE tool. Administered an Oracle 10g database server hosted on a Red Hat Linux AS 3.0 server.
• Helped to administer and maintain the production systems MySQL database server.
• Helped to design the hardware architecture for the new production version of the database server.
• New architecture design employed a cluster of 3 Dell 7250's running the Oracle 10g RAC option connected by fiber to an EMC CX 700 SAN used to store up to 10 terabytes of data. Familiarized myself with Oracle OLS (row level security) for a future requirement.
• Project member on a project serving as a DBA and software developer.
• The project utilized a Sybase ASE database server version
• 12.5 and Sybase Replication server version 12.0.
• Responsible for developing stored procedures, Transact SQL scripts, TriggersJava/JDBC programs, design and maintenance of database tablesperformance tuning and other DBA administrative duties.
• Also responsible for maintaining and enhancing a Sybase Repserver 12.0 server which included designing replication definitionssubscriptions, and routes.

Confidential, Bethesda, MD

DBA and software developer

Responsibilities:

• Responsible for developing stored procedures, triggers, Transact SQL scripts, CT
• Lib C/Unix functions, design and maintenance of database tables, and performance tuning.
• Also assisted in developing a set of Java Servlets to port the projects existing query tool as a web application.
• Also responsible for maintaining and enhancing a Sybase Repserver 12.0 application which included designing replication definitionssubscriptions, function replication definitions, and routes.

Confidential, Frederick, MD

Oracle and MySQL DBA

Responsibilities:

• Project member on a project Developing C/UNIX process’ to parse flat files containing metadata and loaded the data into an Oracle 8i database server through Oracle OCI C library function calls.
• DevelopedPowerbuilder version 6.5 GUI application to display, insert, updateand delete data from a Sybase ASE version 12.0 database server.

Confidential, Columbia, MD

Oracle and MySQL DBA

Responsibilities:

• Project member of a project developing and enhancing C/Motif/Sybase/Unix processes to automate the collection of signal data.
• Designed Sybase database tables, stored procedures, triggersdblib and ctlib functions to store, query, update and insert the data for collection, management, identification and signals analysis purposes.