Data Base engineer Resume Vienna Va - Hire IT People

SUMMARY:

Over twenty years of progressive experience in the design and implementation of information technology software.
Oversee database enhancements, responsible for providing hands - on technical direction as well as task execution in the support of database software applications.
Provide as a Senior Database Administrator capacity planning efforts, operations activities and drive related DBA activities to task completion.

TECHNICAL SKILLS:

TECHNICAL: DB2 v10, LUW UDB V9, z/OS, IBM Utilities, JCL, TSO, ISPF, SDSF, SPUFI, CLIST, REXX, LINUX, COBOL, CICS, Assembler, Data Propagator, Data Joiner, Information Integrator V8, ORACLE, DATACOM, IMS, QMF, DQRY, SQL, PL/SQL, ERWIN, FILEAID, ENDEVOR, OMEGAMON, TMON, MQ, VSAM, BMC LOG MASTER, BMC Utilities, CONTROL-M, My Eclipse, JIRA, Agile

WORK EXPERIENCE:

Confidential

Data Base engineer

Responsibilities:

The modernized SEACATS system replaces the mainframe DATACOM/CICS application and uses ORACLE 12C as the relational database with JSON structures being accessed by Java J2EE. The reporting uses COGNOS 10.2 built on an ORACLE warehouse.
Responsible for the definition of the Entity Relational Diagram logical and physical, and the migration and validation of the data from current to new, and writing PL/SQL, SQL scripts.

Confidential

Senior Application DBA

Responsibilities:

Developed and maintained database backup and recovery systems and procedures for recovery of lost or damaged data.
Performed database reorganizations and performance tuning regularly and proactively.
Created the database objects including table spaces, buffer pools, tables, indexes, and constraints.
Conducted SQL optimization and tuning to improve performance including visual explain plan, index and access path analysis.
Provided the technical assistance to systems designers and application programmers in the efficient use of databases.
Created the logical and physical data model diagrams using Erwin. The Data models were created for design integrity an adherence to standards using scripts, utilities, stored procedures and triggers

Confidential, Vienna Va

Senior DB2 DBA

Responsibilities:

Analyze and resolve database software problems.
DB2 Mainframe (Z/OS) and UDB/DB2 performance and tuning.
Database analyzing and tuning bottlenecks and/or issues in: Buffer pools, ZPARMS, IRLM, Lock management.
Database reorganizations for performance reasons or to adjust database sizes.
Database backup and recovery based on application requirements.
Provide 24 hour support for Production Control and Operations
Provide support for disaster recovery
Provide general technical assistance for application developers as requested.

Confidential, Vienna Va.

Senior DB2 DBA

Responsibilities:

I was responsible for the requirements gathering, design, development and integration of new database applications as well as production maintenance of existing databases across heterogeneous platforms. DB2 & ERP Experience, Physical Database Design using entity relationship modeling (ERWIN) designed and implemented a client server replication system that maintains the synchroneity of data on disparate database platforms.
The replication system populates data to ORACLE 8I/Windows, DB2 UDB V8 LUW on LINUX and windows, and DB2 Zos390/IBM mainframe and required extensive knowledge of the IBM Data Propagator/Data Joiner /Information IntegratorV8 software.
The successful implementation of this system involved the development of implementation plans, the design of test scenarios, the coding of COBOL II application in programming teams, the unit/system testing on the databases and the participation in all phases of the database application development.

Confidential, Washington D.C.

COBOL/CICS developer

Responsibilities:

I developed the logical and the physical design model for a relational client server application using the ERWIN CASE technology tools. I wrote application specification for OS390, WINDOWS, and OS2 platforms and coded COBOL II programs which had dynamic and embedded SQL that executed application business rules stored in different RDMS tables. Installed the application and executed across local and remote RDMS databases via DRDA and DDCS.
Tested and implemented programs written in MICRO FOCUS COBOL, APS for Client Server, C, and COBOL II. I created REXX utilities for transferring data between remote and local databases.

We provide IT Staff Augmentation Services!

Data Base Engineer Resume

Vienna, VA

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship