SR Database Administrator Resume

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Confidential

SR Database Administrator

Responsibilities:

Worked on the Unemployment Compensation project for both the Claimant and Employer side.
Was a lead on Disaster Recovery on multiple occasions and lead the implementation of new releases of database upgrades.
Performed performance tuning both at the application and system level.

Confidential

Sr. Database Administrator

Responsibilities:

We are running a 4 way Datasharing environment.
My responsibilities include the setting up sizing partitioning of production and development environments.
Performance tuning and application debugging.
We are utilizing the BMC software toolset to include Apptune.
We are using IBM DB2PM for batch reports.
Administered SQL/Server database to include backup and recovery strategies.
Performed installations and migration as necessary.

Confidential

Sr Database Administrator

Responsibilities:

The application is an N-tier application. The 390 was used as a database server.
The application was written in Visualage for JAVA and the transaction server was Websphere.
I managed the development and production environments.
We utilized the CA(Platinum) toolset for data management and Omegamon and TMON for online monitoring.
I set up the CAE software on the client. I also help set up the EE connect server.
I supported a UDB 6.1 development database on the AIX platform.
This platform was used for development before moving to the OS/390.
I also supported two datamarts as well, one for financial data the other for the child support system.
Both used the 390 as a database server. I participated in Disaster recovery testing and created procedures.
I primarily supported the online trading system.
The trading system was in the process of being converted from CA-Datacom to DB2.
We were 8 way datasharing and moving towards a metro plex environment.
I worked wif the data administration team to perform physical table design.
I also worked wif the application team on program/process design and SQL tuning.
We utilized the BMC software toolset for data management and Omegamon for online monitoring.

Confidential

Lead Database Analyst/ Sr Database Administrator

Responsibilities:

Responsibilities include Performance application tuning, DB/2 Subsystem Tuning, Setting up and executing Disaster Recovery Procedures.
Setting up Landmark reports for Online and Batch Reporting.
Setting up ongoing Time-out and Deadlock Monitoring.
Setting procedures to execute Database Releases through the development environments into production.
Assisting in Data Model and Application reviews.
Worked on a team to implement DB2 Datasharing in a Sysplex environment.
This included sizing of the Group Bufferpools.
Setting up RMF reports to monitor performance of the coupling facilaty and balancing the workload on the plex.

Confidential

Lead Database Analyst

Responsibilities:

Responsibilities include leading a team of 3 DBAs in a development and production environment I also worked on a team to plan and implement DB2 Datasharing in a SYSPLEX Environment.
Activities include group bufferpool sizing and tuning, coupling facility sizing.
Creating reports to monitor false contention and inter system write activity.
Other responsibilities include Performance tuning and monitoring using DB2PM, MICS, SMF42 Type 6 Boole and Babbage.
Performing Database Release, Disaster Recovery Procedures, Monitoring DB/2 contention.
Assisted in planning testing and installing new releases of DB/2 and third party tools.

Confidential

SR Technical Specialist.

Responsibilities:

Responsibilities include using Case tools to develop logical and physical diagrams of the data base.
Creation of tablespaces, tables, indexes and designing DB2 and application referential integrity.
Monitor DB2 using DB2PM for performance and System tuning.
Assist programmers wif fine tuning application programs using DB2PM and EXPLAIN.
Served as a Data Base Administrator for a large school system.
Responsibilities include the design and creation of tables and setting up referential constraints.
Installation of new releases of the Database, performance tuning, backup and recovery strategies.
Installed and customized CA Infopoint Mortgage and CIF system for a medium sized mortgage company.
Developed a POINT OF SALE interface system for a large retailer using ISPF, CLIST and DB2.
Developed and ON-LINE Manual System for a Human Resource System using TELON and IMS/DB/DC