RDBMS Specialist Resume


Title
RDBMS Specialist


Primary Skills
Oracle, MS Access, SQL query optimization, Data/Root cause Analysis, Report generation


Location
US-MI-Detroit

Posted
Nov-22-09

RESUME DETAILS
PROFESSIONAL SUMMARY

o 19 Years experience as an Information Technology Professional. Creating full life cycle solutions as Database Administrator/Senior Analyst, Technical Lead in Automotive Web-based applications, Inventory control, Health-Care industry, Retail Web--Site HR applications.

o RDBMS (Oracle, Informix, MS Access) Database Administration / Application Design and Development -- Implementation, Design, Administration, DB security, Performance Tuning, Data Modeling, migration, 24 / 7 On-Call. Extensive OEM, DDL/DML design / data quality analysis / ETL work. SQL- Query optimization expertise, including data integrity analysis for application customization testing, and creating analytical metrics.

o LINUX / UNIX Systems Administration -- Database and application integration efforts; CVS system installation experience; Heavy UNIX shell scripting, CRON jobs.

o MS ACCESS --Designed / deployed an Access-based inventory tracking system at Ford, enjoying ISO-9002 controls audit success. Extensive Sarbanes-Oxley compliance work, implementing database security controls that led to GAO and FCS internal Quality/Audit success; Created numerous MS Access other ad-hoc applications as needed

o Process and Application Documentation Author -- Authored scores of technical specification and process documents, which arose from the Ford Inventory control application I designed; basis of ISO-9002, GAO and internal QA audit success.

PROFESSIONAL TRAINING
Oracle University Modules:
Introduction to Oracle9i: SQL (PL/SQL-SQL-plus) May 2004
Oracle 9i DBA Fundamentals I (architecture, OEM, Schema design) June 2004
Oracle 9i DBA Fundamentals II (RMAN-backup-recovery) July 2004
MS Access Intermediate Database design and Administration Dec 2001
INFORMIX-Online Database Administration October 1995
SCO Unix Systems application development September 1995
'ZenaComp' Informix-4GL application development April 1995

EDUCATION

Bachelor of Arts - Interdisciplinary Degree from Eastern Michigan University, Ypsilanti, MI
Major - Language (German) and International Trade Minor - Business Computers (Programming)
All college funding self-generated.

LANGUAGES HARDWARE OPERATING SYSTEMS
SQL - PL/SQL Sun Solaris AIX LINUX
Informix 4GL IBM RS6000 HP/UX
Progress 4GL HP 3000/6000/9000 Windows 98/NT/2000
ASP HTML Pyramid Tech DOS
PHP JSP IBM PC SCO/UNIX

DATABASE SOFTWARE/ANCILLARY
Oracle RMAN UNIX Shell Scripting SQL+ OEM/DBCA
Informix MS Office Suite (Excel, Word, Access, Powerpoint, Visio)
MS Access VI CVS ISQL / DBACCESS RMAN TOAD
Progress CVS ASP ODBC Oracle Reports Developer
MYSQL StockMaster SUN-GUARD/Bi-TECH

PROFESSIONAL EXPERIENCE

Ciber Corporation Southfield, MI 6/07 -- current

For Thyssen-Krupp As Data Architect (Environment:SQL Server, Access)

o RDBMS Application design architecture -- DB Schema design/architecture for all database objects and processing procedures
o Application design for national pricing team's materials costing requirement -- Executed the entire design, creation and deployment in MS Access.
o Direct technical liaison with business sales and resale executive teams, translating needs analysis into technical solutions.

For R.L. Polk As Consultant (Environment: Oracle 10g; SUN Solaris, LINUX)

o Oracle Database development / report programming within multiple test, development and production applications -- GM strategic financial and sales experience projects
o Oracle Report Developer application reporting development
o RFD to JSP migration, using extensive HTML coding techniques.

For Visteon Corporation As Oracle DBA (Environment: Multiple Oracle 8,9i,10g; SUN, LINUX, AIX)

o Oracle Database administration in support of multiple test, development and production applications -- extensive DDL/DML and Schema design work for strategic projects using OEM, StatsPack, DBload processing. Executed schema and DB-level database refresh projects.
o Administered Database Security and userID creation for development and applications side access
o Installation of Oracle Software / migrations / patching, OEM installation, process engineering.
o Oracle Database Client installation, data modeling, DB creation and application development support/instruction/guidance, conforming to IBM technical requirements for both OLTP and OLAP platforms.

Daimler-Chrysler (through Wel-Tek) Auburn Hills, MI 9/06 -- 6/07
As Systems / Process Engineer (Environment: Oracle, MS Access)

o Process design, extensive DDL/DML/Schema analysis in support of prototype engineering applications (Data Warehouse/Star Schema)
o Engineering/financial parts application administration, planning, security and design (FastCar).
o MS Access Application creation, development and data analysis in support of engineering prototype costing assessments (Oracle data warehouse backend, MS Access front end).

EDS -- (through Apex Systems) Troy, MI 10/05 -- 6/06
As Oracle Database Administrator (Environment: Multiple Oracle on HP-UX and Windows)

o Oracle DDL/DML/Schema design,DB performance tuning and analysis for ~40 multi-platform databases, all Oracle back-ends for the major GM retail websites, including userID/DB access and security.
o Oracle DBA supporting (24/7 on-call rotation) most eGM worldwide customer service-based websites. Worldwide, remote/VPN-based DBA support team (OnStar, Club Holden, etc). > 50% dial-in support.
o Heavy Oracle SQL-plus based data analysis, intensive UNIX scripting to create implementation solutions in support of Oracle-based application development initiatives.
o Backup and recovery exercising, DB stress test analysis, Oracle software installation and patching experience.
o Technical reviewer for Oracle-based database application implementation approval/peer review process.
o Substantial OEM StatsPack, SQL Analyze to record and aid in performance analysis and tuning.
o Heavy UNIX Scripting creation/auditing for Oracle-based application solutions implementation.

AT&T -- (through Agneto Corporation) Ann Arbor, MI 9/04 -- 9/05
As Database Administrator (contract) (Environment: Multiple Oracle, Informix, MS Access)

o Database administrator for the ACUS Division, part of a remote/VPN-based technical team.
o Oracle OEM console installation experience in support of relatively small production database instance.
o UNIX scripting to facilitate Oracle database export process for backup purposes.
o Substantial TAR work for Oracle database problem resolution and OEM install.
o Project lead for Informix version migration (to 7.31). Installation, configuration, DB/Schema management/ Design and applications testing for new version.
o Creation and deployment of MS Access-based user ID tracking and reporting application.
o DB Cloning, disaster recovery, performance tuning, process engineering and development support.


Munder Capital - (through Sierra ITS) Birmingham, MI 1/04 -- 5/04
As Database Administrator (contract) (Environment: UNIX/AIX-Informix SQL)

o Informix DBA and application development activities for the GIM Application, serving Munder Capital Investment, supporting their financial reporting and forecasting tool.
o DB maintenance and performance tuning, disaster recovery, process design and documentation.
o Data processing documentation. Created controlled documents (MS Word) covering application architecture and daily processing tasks.
o Support for application developers, data integrity/quality testing and UNIX systems integration.

Ford Motor - (through VisionIT) Detroit, MI 9/01 -- 1/04
As Systems Analyst (contract) (Environment: MS Access (Windows) - AIX-Informix SQL)

o Application design/data modeling, development, deployment and analysis of an MS Access-based inventory reconciliation and parts forecasting process for Ford Component Sales. Technical lead for team of 6 reconcilers and data entry personnel.
o Extensive Sarbanes-Oxley compliance work, implementing controls that led to audit success performed by ISO-9002, Ford's GAO and internal QA departments. Created MS Access Database/application security controls and userID access administration.
o Extensive controlled MS Word-based documentation for the entire project (including VISIO charting). The documentation that I authored covered application controls, data processing methodology, systems disaster recovery, vendor requirements and staff training.
o Data analysis, cleansing and remapping of legacy data elements (using MS Excel).
o Root cause analysis, data integrity/quality testing and processing streamlining in a UNIX/Informix environment.





St. Clair County ISD -- (through CCI) Southfield, MI 2/01 -- 8/01
As Consultant (Contract) (Environment: HP/UX-Informix SQL)

o DB and Systems Administration, development and support, backend and application duties for the Bi-Tech accounting systems software package.
o Performing maintenance, customization, performance tuning and user troubleshooting functions in support of 21 School District Databases, running IFX 7.31 on HP-UX/UNIX HP9000.
o Executed systems backup and recovery and application and database development duties.


American Blind and Wallpaper Factory Plymouth, MI 3/00 -- 2/01
As Database Administrator (Environment: UNIX/AIX-Informix SQL)

o Informix (7.3 Online) Database Administrator for the company's E-Commerce Websites. Performed Design, maintenance and performance tuning.
o ODBC configuration setting for Windows NT application platform data transfer.
o Work on the OS side included installation and propagation of the CVS change control package.
o Other activities include data integrity/quality testing, backup and recovery efforts and UNIX shell scripting. 4GL development, ASP, JAVA, and PERL with regard to problem solving and development.


Ford Motor -- (through MSX) Dearborn, MI 6/98 -- 3/00
As Database Administrator (Contract) (Environment: UNIX/AIX-Informix SQL)

o System and DB Administration, development and users support issues for Ford Motor Company's Pre-Production Prototype Plant.
o Analyzed and effected changes to existing code, as well as developing custom standalone report and application functionality and data integrity/quality testing.
o System Administration (UNIX-IBM Aix) duties include users access, restart, backup, disaster recovery, peripheral support using SMIT, TB/Onmonitor utilities.
o Hands on experience in DB and OS version migration ( Informix Online 5 to 7
o Executed Web-page updates including page and supporting data file updates and modifications for the Process Locator section of the Ford International web page.

Business Support Group Farmington Hills, MI 4/97 - 5/98
As Senior Programmer/Analyst (Environment: UNIX/AIX-Progress SQL)

o Customization, development and upgrade activities using the MXP light industrial manufacturing process package, a Progress/UNIX-based software application.
o Upgrades involve process analysis, table and index creation/population and custom and package program retro-fitting activities.
o Table/index manipulations, data integrity/quality testing , process evaluation/optimization, and other DBA activities were accomplished.

Domino's Pizza Ann Arbor, MI 1/96 - 4/97
As Senior Programmer/Analyst (Environment: UNIX/AIX-Informix SQL)

o In Distribution Systems, I led a team of consultants customizing, enhancing and supporting the Equipment and Supply (International) division's Order Entry/Inventory Control System, on an Informix/Unix platform.
o Application and data Processing MS Word-based documentation, including user training.
o Table/index manipulations, process optimization. Executed system and software upgrades
o Data integrity / quality testing. Custom table creation and population, custom and package index analysis and maintenance in relation to process performance.
o Other experience includes application utility analysis and enhancement, and some hardware/connectivity exposure.

Johnson Controls -- (through Indecon) Southfield, MI 7/95 -- 12/95
As Consultant (Contract) (Environment: UNIX/SCO-Informix SQL)

ValueRx Bloomfield Hills, MI 10/94 -- 7/95
As Programmer/Analyst (Environment: UNIX/AIX-Informix SQL)

Medstat Systems Ann Arbor, MI 4/91 - 1994
As Client Team Analyst (Environment: HP/Fortran) 9/93 - 10/94
As Database Processor - Database Operations 8/92 - 9/93
As Computer Operator - Database Operations 4/91 - 1992


Certifications
See above

CONTACT DETAILS

You must be logged in and have a current resume access subscription. Login or Register »

Related: IT Manager Resumes | IT Resumes in Detroit, MI | IT Resumes in Michigan