Data Architect/ Senior Database Administrator Resume New York, NY - Hire IT People

SUMMARY:

Accomplished IT professional with extensive experience, well - versed in database administration, production DB support, performance tuning, scripting/coding and enterprise job scheduling.

TECHNICAL SKILLS:

Applications: MySQL 5.0/5.1/5.55.7 on Linux and RDS(8 years; Certified MySQL 5.0 Admin), MS SQL Server (6.5-2014) on Windows Servers (10+ years), Sybase ASE (4.2-15.0) on Linux, Unix and NT (15+ years), Sybase Replication Server (8+ years), BMC Control-M/ECS (2 years), Oracle Goldengate (1 year)

Languages: SQL (18+ years), Perl (14+ years), Unix Shell Bourne, Korn/ksh, BASH (20+ years)

Systems: Unix Solaris, HPUX, AIX, Tru64 (20+ years), Linux (10+ years), Windows Server (15+ years), OSX (5 years)

PROFESSIONAL EXPERIENCE:

Data Architect/ Senior Database Administrator

Confidential

Responsibilities:

Support of over 250 development, QA and production MySQL instances
Support of over 50 development, QA and production Microsoft SQL Servers (DTS, backup/restore, etc) supporting typical internal business functions and websites
Support of over 50 MongoDB instances
Write/tune stored procedures to support business and DBA group
Assist developers in SQL performance tuning and logic
24x7 support of all Sybase, MySQL, SQL server and MongoDB installations plus overnight batch jobs (data feeds, reports, monitors, statistics collectors) on rotating schedule
Responsible for performance and tuning of MySQL, Sybase ASE and SQL Server
Responsible for most database automation

Senior Sybase/ SQL Server DBA

Confidential, New York, NY

Responsibilities:

Support of Development, QA, Staging and Production environments running Sybase ASE 12.5.1/Replication Server 12.5 and MS SQL Server on (respectively) Sun Solaris and Windows 2000 for global bond trading platform
Write database support scripts in SQL, Perl and Korn shell
Tune stored procedures, databases and servers
Advise developers for best practices in SQL coding
Establish cold and warm standby servers using log shipping and Replication Server

Contractor/ Sybase DBA

Confidential, New York, NY

Responsibilities:

Designed and implemented Confidential history database
Analyzed data and consolidated transactions going back 13 years from three different systems
Designed and implemented data import procedures in Perl and SQL

Database and Applications Manager/ Senior DBA

Confidential, New York, NY

Responsibilities:

Support of development, QA and production SQL Server and Sybase databases running on NT/Win2K and Unix (Solaris); SQL Server application support included online (both web-based and internal) trading system for equities, fixed income, and options, accepting up to 30,000 trades per day
Responsible for writing database stored procedures, scripting, replication, performance, monitoring, data import/export, backup and recovery, and physical database design
Installation of Sybase v. 11.9, 12.0 and 12.5, MS SQL Server 7.0 and 2000, and upgrades between versions
Assisted and/or advised developers in best practices for SQL coding
Implementation of BMC’s Control-M batch scheduler; supported approximately 1,000 jobs
Complete design and support of batch cycle including scripting (in Perl and Sybase/MS Open Client) for all data streams to and from data suppliers and WSA customers
Established and supported warm standby system at remote site for all real time databases using SQL Server and Sybase replication
Established cold standby system at remote site using log shipping for DSS databases
24x7 support of production database servers and batch cycle (using Control-M/ECS)
Involved in complete changeover (including database redesign and data conversion) of brokerage clearing house
Responsible for management of one employee

We provide IT Staff Augmentation Services!

Data Architect/ Senior Database Administrator Resume

New York, NY

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship