Data Database Administrator

STANLEY J. LIPINSKI

*** **** ***** ****** • Livingston, NJ 07039 • 973-***-**** • **********@***.***

Qualifications for MYSQL Database Administrator

PROFILE

Results-oriented and proactive IT professional offering over 15 years of experience spanning database and systems administration as well as backup/recovery strategy and software development. Adept at managing critical data during organizational mergers. Dedicated to ensuring reliable, high-availability, cost-effective, and efficient systems/databases through the installation and maintenance of quality products and services. Possesses proven process improvement capability concerning enhancing system response time and access. Additional core competencies include:

Technical Support • Strategic Planning • Software Management • Systems/Database Analysis

CAREER CONTRIBUTIONS

• Headed information technology activities during the merging of product, accounts receivable/payable, proprietary formula, and inventory data between the newly created and old companies, organizing efforts among eight programmers from the old and business leaders within the new organization.

• Improved response time by 25% through instituting performance and tuning strategies for sales order processing.

• Saved 33% in current resources by developing a customer analysis data mart.

• Increased access to the Foreign Trade Zone database by 50% through redesign efforts.

• Tuned the OAM system, increasing response time by 30% for subscriber relations.

• Collaborated with an IBM engineer to repair inherent bugs in AIX for the successful institution of Direct Talk and decreased lead times for physicians’ claims by 14 days through instituting a Direct Call system.

• Played a key role in the closing of a $2M sale by installing company products at a client site, along with creating a CICS region for the client.

• Developed and implemented a file backup and recovery system, ensuring the availability and recoverability of all CICS environments.

PROFESSIONAL EXPERIENCE

EXECU=SEARCH DATABASE ADMINISTRATOR/CONSULTANT 3/11 – PRESENT

Responsible for Performance Tuning Data Warehouse, normalization of innodb tables, stream limning data loads

and updates of database. Making recommendations for tuning sql statements. Input into future DB design

WHI, Database Administrator 3/07 – 6/10

Responsible for database activities for taking Company’s strategic software products to next generation. Using ,MYSQL, and Shell. Backup and Recovery of MYSQL Databases, Upgrades to MYSQL from ver 4 to ver 5.1. Data

Architect for migrating client data to ARTS Model using ERWIN. Performance Tuning by implementing better indexes

And normalizing tables. Implemented Stored Procedures, and common schemas, High Availability testing,Oracle 10G implementation for WHI Client Data Guard Grid Control,PLSQL

FCG, Oracle Database Administrator 9/06 -3/07

Oversaw daily inhouse systems administration. Installed Oracle 9i. Developed new logical and physical structures for New Database for Medical Records Application. Implemented two new Medical Record Production Systems. Wrote scripts for interface with Client Vendor. Wrote extracts for Interface with Seman Beeper and Pager System. Involved with Performance tuning exercise for legacy system. Reorged production Indexes. Created exports for logical backup of Legacy system. Installed Sql Server2005 and Created Sql Server DB

STANLEY J. LIPINSKI

973-***-**** • **********@***.***

PROFESSIONAL EXPERIENCE, CONTINUED

KERRY BIOSCIENCE, Oracle Database Administrator 2004-2006

Oversaw daily global systems administration. Performed analysis for the migration of Legacy data requirements. Developed new logical and physical structures in Oracle, Excel, and text formats for archiving and to load/unload data into the mapics database, ensuring adherence to the project budget by conducting successful negotiations with the outsourcer’s programmers regarding deadlines and data extraction. Using Oracle 10G

QUEST INTERNATIONAL, Oracle Database Administrator 1995-2004

Administrated replication between North American and European databases. Held responsibility for directing the activities of and supporting all databases in North and South America. Worked in conjunction with colleagues in maintaining databases throughout Europe, APAC, and Australia. Managed the installation of Oracle products. Maintained ten production and nine development databases, ensuring high availability. Provided database developers with technical support, assisted with applications problem resolutions, and devised methods of improving response times for OLTP instances. Secured database backup and developed recovery strategies. Instituted keep pool buffer and hot backup strategies as well as database tuning rules and global systems.

Monitored performance, security violations, SQLNET/alert logs, and I/O connection. Verified object compliance with specified rules. Informed programmers and management of technical issues and strategic direction concerning database functions. Developed simple UNIX scripts. Designed physical/logical structures for local and global databases. Performed SQL, DB, and system tuning in addition to developing, enhancing, and implementing backup/disaster recovery strategies. Administered system security.

• Created capacity planning reports showing quick demand growth and saved 50% in resources by purchasing a DASD earlier and at a lower cost.

IBM GLOBAL SERVICES, Systems Programmer 1992-1995

Installed, upgraded, and maintained DB2, Oracle, AIX, and Platinum products using SMP/E and non-SMP/E installs. Diagnosed and resolved system software problems. Developed and tested backup/recovery strategies, along with administrating system security measures. Created utility applications and tools, providing technical support as needed. Guided the DB2 DBA team in logical/physical database design initiatives. Collaborated with Platinum technologies to improve DB2 tools. Wrote documentation and procedures. Maintained the DB2 IMAGE environment supporting the largest market segment within the corporation.

• Redesigned outdated procedures, increasing access to the optical library by 20%.

Page 2 of 3

STANLEY J. LIPINSKI

973-***-**** • **********@***.***

PROFESSIONAL EXPERIENCE, CONTINUED

COMPUTER ASSOCIATES, Systems Programmer Prior-1992

Installed DB2 and associated program products, providing client consultations to ensure effectiveness. Implemented, customized, and sustained CICS. Provided support for the programming staff, including systems professionals and development personnel. Managed CICS production regions, supporting strategic applications. Reorganized table spaces as well as the system catalog to support efficient and reliable enterprise-wide computing.

• Created a database for a Fortune 500 healthcare company.

Previously served as a programmer at Hygiene Industries, a data processing supervisor at Hooton Chocolate, and a computer operator at Morristown Memorial Hospital.

ACADEMIC CREDENTIALS

Business Administration, Montclair State University (18 credits)

Certifications/Training:

ECPI (Computer Programming Major)

Data Processing Diploma

COBOL, RPG III, BAL, and BASIC

Proficiencies:

Oracle 10g, 9i, 8.1.7.4, 7.3.4, 7.3.3, 1.7; PLSQL, OEM, SQL Server 2005; MYSQL 5.0 AIX 4.2; OS/2; MVS/ESA; MVS/XA; VM/SP; VSE; CMS; JES2; DB2; DB2/2; Quest Software DBA Tools; SQL/DS; CICS Command Level; TSO/E; ISPF; ISMF; Platinum Tools for DB2; IPCS; DFHSM; COBAL; BAL; GENEROL; UFO; SMP/E; Automate; Omegamon; DADS; Abend-aid; OAM; FAF; IMAGE; SARS; FDR; DFDSS; File Safe; DFHSORT; ACF/2; ICCF/VSAM; CLIST; OWS.OEM; RMAN, Data Pump,Data Guard, Grid Control, ASSEMBLER,Kettle,SQLYOG,

Toad,Windows XP, 2000, Office 2000;

Page 3 of 3

Contact this candidate