We provide IT Staff Augmentation Services!

Data Architect/ Senior Database Administrator Resume

New York, NY

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

Hire Now