SENIOR ASSOCIATE DBA Resume RIVERWOODS IL - Hire IT People

SUMMARY

Obtain a challenging position in the areas of analysis, design and database administration with opportunities for career advancement.

PROFESSIONAL EXPERIENCE

Hardware platforms: Appl 2750, 2700, 2670, RS/6000, Mainframe

Operation systems: Linux, UNIX (AIX), Windows 7, OS/390

Data Bases: TERADATA, UDB/DB2, MS Access

Database Tools: Abinitio, Optiload, DB2 Connect, JDBC

Programming Languages: SQL, Korn Shell, Visual Basic, SAS, COBOL

PROFESSIONAL EXPERIENCE:

Confidential, RIVERWOODS IL

SENIOR ASSOCIATE DBA

Responsibilities:

Manage System hardware and software upgrades.
Support DB2/Oracle databases migration to Teradata.
Create Teradata database objects based on DBA's analysis of logical/physical db models.
Implement Teradata security structure for Discover Data Warehouse and OLTP applications.
Design and maintain Teradata security SOPs, DR SOPs, various Teradata development and
implementation standard documents.
Advise, develop, implement and test disaster recovery strategies for Teradata systems.
Design and implement Teradata scripts, store procedures and macros for the info security to
collect Teradata servers performance and systems analysis statistics.
Work with the company Command Center, MidOps, NetOPS, Internet teams to implement
Teradata security and Internet applications on Teradata platform.
Design, develop, test and implement Teradata security reports.
Develop database structure and bteq scripts to integrate Teradata security with DFS LDAP system.
Serve as an application DBA for a large number of Data Warehouse, Data Marts and OLTP projects.
Responsible for new application space estimates and future projects capacity planning.
Perform database Data Store, EDW and Data Marts logical models analysis, physical models
implementation, database security roles and role rights setup.
Provide WAS tuning performance analysis, design primary and partitioning indexes for batch jobs and
applications with high performance on Teradata.
System applications performance monitoring after initial production implementation.
Perform Teradata database objects compression, Teradata database backups /restores.
Provide Teradata 24x7 users support.
Implement performance and tuning recommendations of all components in the database servers.

Confidential, BANNOCKBURN IL

DATA WAREHOUSE DBA

Responsibilities:

Implemented UDB - EE v7.1, UDB-EEE v5.2 and UDB-EEE v.7.1
Worked on database conversion and migration from DB2-PE to UDB-EEE, UDB v5.2 to UDB v7.1.
Performed software installations and upgrades for the several RS/6000 servers and SP2. Worked on database conversion and migration from NT (UDB EE/VB 7) to AIX (UDB EE/Java).
Physical database design for OLTP and DS applications.
Designed physical disks layout for the UDB-EE /Web sphere databases.
Performed estimates and analysis of the current and future Data Warehouse disk space capacity.
Worked on Data Warehouse expansion from 6 physical nodes to 12.
Supported database ADSM online (using User Exit) and offline backups.
Provided 24 by 7 on-call production systems support.
Supported Micro Strategy, Actuate, Web java applications on performance tracking and tuning. Performed database restore, recovery, monitoring and tuning for the UDB-EEE, UDB-EE environment.
Developed system monitoring and load scripts using Unix Shell and SQL.
Performed analysis of users static and dynamic SQL using Explain and Visual Explain.
Performed daily, weekly and monthly Data Warehouse loads, using IBM utilities and Opt load. Successfully trained new DRM team members and consultants.

Confidential, BANNOCKBURN IL

SR PROGRAMMER/ANALYST

Responsibilities:

Server and workstation software installation, database back - ups, EPM server support.
Set up of the system default parameters and definition of the validation tables.
Troubleshooting, system recovery, reorganize and update utilities.
Extensive support of 300 system users.
Testing and implementation of the new software versions.
Direct vendor (Platinum) contact.
Design and development of weekly and monthly business analysis reports and queries for IS
management, financial department using ODBC and MS Access.
Analysis, design, development, coding and testing of financial reports and status reporting.
Database and IS planning applications using ODBC and MS Access.

We provide IT Staff Augmentation Services!

Senior Associate Dba Resume

Riverwoods, IL

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship