(Email) info@sunrisecentury.com (Cell) 914-715-4204
Profile:
Ms. Shakman has worked the last 7 years as a development and production support
Sybase DBA. She has over 20 years IT
experience working on financial applications and projects for major
corporations. She is a responsible,
self-starting team player with excellent communications and interpersonal
skills.
TECHNICAL:
Certification:
Sybase ASE Administration
Sybase ASE Performance and Tuning
Languages and Software:
Sybase 11 thru 12.5.1, Replication Server
11.5 thru 12.5, SQL, Perl, C/Korn Shell, RapidSql, SqlExpert, DBArtisan,
SqlAnywhere, Sybase Central, SqlAdvantage, Rep Server Manager, Monitor Server,
Historical Monitor, BMC SqlBackTrack, Open Client 11.1.1 and 12, MySql, Informatica,
C, Cobol, MS Project Manager, MS Word,
Microsoft Outlook, Lotus Notes, Excel, Peregrine, Tivoli, Remedy, PCAnywhere,
PVCS,QALoad, XTerm
Hardware/Operating
Environments:
HP9000,
Sun SPARC, PCs, IBM 3090; UNIX (HPUX 11 and 11i, SunOS, Solaris 5.7,5.8), AIX,
Microsoft Windows NT/XP/ME/98/95, DOS, VMS
Experience:
·
Performed
SQL code reviews for application teams; implemented DBMS best practices,
policies and procedures
·
Wrote and maintained Korn shell scripts for database
maintenance including index reorgs, update statistics, dbcc’s, database backups
and to support systems integration, interfaces and overnight processing
·
Provided
daytime, off hours and on call production, QA and development DBA support for
Sybase 12, Sybase 11.9.2, Replication Server 12, and Replication Server 11.5 to
ensure 24/7 availability, reliability and accessibility; provided DBA hotline
user support, supported warm standby replication
·
Provided
day to day database and user account maintenance, troubleshooting,
backup/recovery, performance and tuning, Java app benchmarking, preventative
maintenance activities for 68 HP Sybase servers and 6 Replication Servers
·
Performed
outage reporting, root cause analysis and presentation at weekly Senior
Management Production Stability conference call
·
Performed
Sybase capacity planning and monitored performance
·
Managed
Sybase upgrades/releases, provided application development team and system
integration DBA support
·
Provided
DBA support for HP Operating system upgrades, application integration and
acquisitions
·
Provided pre-performance Sybase performance tuning for developers
·
Monitored and troubleshot overnight batch processing
including Sybase stored procedures and system integration scripts; supported HR
application package upgrades
Staff member of database administration
outsourcing and consulting firm. Assignments included:
Sanford C. Bernstein & Co., Inc, White Plains, New York, United Nations, Lehman Bros, Human
Genome Sciences (Maryland)
·
Analyzed
persistent performance problems in 11.9.2 Sybase production environment for
Sanford Bernstein and presented 11 recommendations, which were accepted and
implemented.
·
Wrote Korn
shell scripts to support overnight batch processing and supported server
migrations at all supported clients
·
Provided
onsite/remote DBA production operation support for the United Nations global
accounting/payroll package at the UN Secretariat
·
Provided
daily Unix SA support, DBA production support for 14 HP servers, Sybase 11.9.2,
1000+ users, JAM application front end at the UN
·
Provided
daily database maintenance, troubleshooting, batch and online monitoring,
performance tuning at the UN
·
Upgraded 7
servers from Sybase 11.0.2 to 11.9.2 at the UN
·
Supported
application package upgrades, provided application development and user
support; wrote Korn shell scripts to support overnight batch processing at the
UN
·
Provided
onsite and remote DBA support for Lehman Bros. firm wide budget and allocation
system.
·
Provided
overnight batch process monitoring and troubleshooting at HGS
Steinthal
Consulting, Inc, White Plains, New York
Performed
hands-on project management of a custom Trade Capture (VB4/Sybase) system for
the broker dealer Lazard Freres
Merrill Lynch (Smith New Court Inc)
Responsibilities
included project management, business and systems analysis for global integration
and internal trade confirmation systems. Responsible for analysis,
implementation and management of database applications and management
information systems in two locations of a New York international equities
brokerage firm.
Prodigy Service Company, White Plains, New York
Hands on
project team leader and senior programmer analyst/developer for design,
development, implementation and enhancements of Donaldson, Lufkin and
Jenrette’s on-line discount brokerage service.
Responsible for analysis, design, development and implementation of on-line financial systems. Analyzed business requirements in an IBM 308X OS/MVS environment.