Systems Analyst Data

ST Sharon Thornton

New York, NY ***** 516-***-**** adwpe9@r.postjobfree.com

PROFESSIONAL

SUMMARY

Experienced DBA with solid background in designing and implementing data management solutions. Strong knowledge of database security, backup and recovery. Collaborative and dedicated to improving and optimizing database performance.

Was Bank's sole SME for UDB, developing the standards and the procedures currently followed. Designed the Kerberos implementation and HADR setups which required working with many areas of the Bank. Being well known for UDB expertise resulted in being the first person contacted for issues and information. ACCOMPLISHMENTS I received several awards culminating with a Best in Class award which is given each year to approximately 5 technology staff who out performed their peers. SKILLS Database Administration

Mentor and Group Leader for

UDB

Experience with ORACLE 11c

ORACLE schema changes,

performance tuning, patching,

problem determination

BNYMellon SME for UDB

Point person for UDB Data Base

Audits

DB2 LUW V8-V11.5.8

Install, Maintain all UDB

databases at BNYMellon . Db2

upgrades(single server and

HADR), installfixpack, special

builds

Successful implementation of

Kerberos for UDB requiring

cooperation across many

departments

Design and implement schema

changes

Backup, recovery, reorganization,

redirected restores, db2move,

db2pd, federated, memory

management for db2 and RHEL

DB2 Performance analysis, DSM,

dsmtop, snapshots,event

monitors

Problem determination, Root

cause analysis DB2 trace, DB2

support, CLI trace

DB2 Unix scripting. script to

perform part-roll for range

partitioned tables. Script to apply

proper privileges for a databases,

redirected restore generator,

reorg to reclaim space

Design/implement security

protocols. Kerberos for UDB

Space management. Automatic

storage implementation.

HADR design, setup,

implementation and integration

with VCS

WORK HISTORY DATA BASE ADMINISTRATOR 10/1994 to 01/2023 Bank Of New York Mellon*Technology New York, NY

Administered, supported and monitored databases by proactively resolving database issues and maintaining servers.

Tested programs and databases to identify issues and make necessary modifications.

Set up and controlled user profiles and access levels for each database segment to protect important data.

Created and implemented database designs and data models. Modified existing databases to meet unique needs and goals determined during initial evaluation and planning process.

Created scripts and processes for data integration and maintenance. Planned and implemented security measures to safeguard vital business data.

DATA BASE ADMINISTRATOR 09/1993 to 09/1994

Federal Reserve Bank Of New York. Consultant New York, NY IMS,DB2 zOS DBA.

Administered, supported and monitored databases by proactively resolving database issues and maintaining servers.

Tested programs and databases to identify issues and make necessary modifications.

DATA BASE SYSTEM PROGRAMMER 09/1980 to 12/1993

Grumman Data Systems Bethpage, NY

IMS system programmer.

Installed and maintained IMS systems.

Tested new releases.

Problem determination.

EDUCATION Certificate Unix Administration And C Programming 04/1994 Pace University, New York, NY

Certificate Systems Analyst 10/1980

Grumman Data Systems School, Woodbury, NY

Bachelor of Science 05/1977

University of New Hampshire, Durham, NH

High School Diploma 06/1973

Syosset Senior High School, Syosset, NY

Contact this candidate