We provide IT Staff Augmentation Services!

Sr. Sql Dba(consultant) Resume

NyC

SUMMARY:

  • Sr. MS SQL Server DBA at a private brokerage/trading firm since 1999.
  • Proficient in SQL Server performance tuning, installation, security, migration and upgrades, database design,DDL source control and change deployment.
  • Experience supporting large high transaction trading databases (600 GB+).
  • Designed and participated Disaster Recovery, Business Continuity procedures and drills.
  • Performed SQL Server upgrades.
  • Automated daily production cycle and SQL Server monitoring with IBM Tivoli Workload Scheduler and custom scripts.

TECHNICAL SKILLS:

Languages: T/SQL, Windows Batch Scripting, Perl, VB Script

Databases: MS SQL Server 6.5, 2000, 2008R2, 2012

O/S: MS Windows Server 2003 and cluster, 2008R2, VM Ware

Scheduler: IBM Tivoli Workload Scheduler 8.4, 9.2

SANS: NetApp, SnapDrive, SnapMirror, Snap Manage for SQL Server

Others: SmartGit, MS Visual Source Safe, Asana, Box, SharePoint

PROFESSIONAL EXPERIENCE:

Sr. SQL DBA(Consultant)

Confidential, NYC

Responsibilities:

  • Responsible for teh firms’ backend MS SQL Servers:
  • Trading and allocation (2000 clusters + NetApp SANs + Cold DR mirror + 3 devs)
  • Security pricing (2012 live + Hot DR)
  • Money manager and client web (2012 live/live load balancing + Hot DR + dev)
  • CRM/replication for SalesForce (2008R2 live VM + Hot DR VM)
  • Accounting/MS Dynamics GP (2008R2 VM + dev)
  • SalesForce ETL(2012 VM + dev)
  • SalesForce DBAmp (2008R2 VM)
  • Installed SQL Server over a varieties of Windows Server platforms:
  • 2003 cluster with NetApp SANs
  • 2008R2, 2008R2 VM
  • AWS (test)
  • 2000 and raw partitions (SQL Server 6.5) on NT
  • Installed IBM Tivoli Workload Scheduler on 2 node - VM-pair with controlled failover.
  • Designed Disaster Recovery procedures and programmed DR fail-over scripts.
  • Automated daily and weekly database maintenance with IBM Tivoli Workload Scheduler.
  • Tracked and analyzed SQL Server Performance Monitor counters for tuning.
  • Tracked long running queries with trading applications servers and custom maintenance scripts for analysis and tuning.
  • Analyzed collected performance data and applied correction measures on server and database settings, tables, indexes, store procedures and T/SQL.
  • Debugged, programmed and performance tuned stored procedures and T/SQL scripts.
  • Responded to complex ad-hoc data report requests, test data request from developers.
  • Set up custom alerts for SANs and acted as first response ahead of system group.
  • Coordinated with system group on hardware alerts in event log and monitoring tools.
  • Installed OS updates, and SQL Server patches and service packs.
  • Automated nightly, weekly or on-demand copying of complete production data set (600 GB+) to test SQL Servers with custom scripts utilizing NetApp SANs snapshot.
  • Redesigned nightly batch cycle to ensure overnight clearing firm and vendor files were processed according to business requirements and dependencies.
  • Added fault tolerant alerts and counter measures in nightly batch cycle for error handling, delay, missing file and etc. Minimized human intervention.
  • Automated encryption and backup critical business files and compliance reports to Box.
  • Performed database changes required by application deployments/changes.
  • Performed SQL Server system upgrades: from SQL Server 6.5 (NT raw partition) to 2000 (Win 2000) from SQL Server cluster (Win 2003) from SQL Server (Win 2008R2)
  • Upgraded scheduling software from AshWin to IBM Tivoli Workload Scheduler.
  • Automated nightly and real time data feed to web backend and accounting SQL Servers.
  • Set up replications to SalesForce data grid SQL Servers.
  • Installed and customized SharePoint for “Project/bug/Issue tracking”.
  • Performed data migration test to AWS.

DBA/Vice President

Confidential, NYC

Responsibilities:

  • Led 12-member IT team based in NYC and St.Vincent.
  • Implemented DeBari’s image based Litigation Support System in other facilities.
  • Headed rapid improvement and development of teh company’s IT system and workflow process as teh company experiencing rapid growth.
  • Coordinated system upgrades and application releases for its sister companies.
  • Managed MS SQL Servers in NYC and St.Vincent.
  • Performed SQL Server performance tuning to handle up to 300 users.
  • Performed SQL server maintenance and recovery, triggers and stored-procedures programming, debugging deadlocks, and etc.

Lead Programmer/DBA

Confidential, NYC

Responsibilities:

  • Designed, developed and implemented teh company’s image based Litigation Support Production System from ground up, including network design and installation, hardware selection and configuration, OS and software selection and configuration, application programming and deployment.
  • Teh system’s frontend were all in-house custom VB5 applications with MS SQL Server 6.5 as its backend.
  • A NT4 wide-area-network linked teh company’s NYC and St. Vincent facilities providing a combined capacity of 300 seats.
  • Teh system was teh first of its kind in teh Litigation Support field for high volume production using imaging and workflow technology.

Lead Programmer

Confidential, NYC

Responsibilities:

  • Led IS operations; Hardware and software selection installation; System planning development enhancement; Equipment and network maintenance; Staff support and training.
  • Completely upgraded company’s LAN with a new file server, a later version of NOS Novell 3.15, 100% rewiring, 100% NIC replacement, and increased workstations from 20 to 50.
  • Re-written and fully automated teh company's residential mortgage portfolio system with FoxPro.
  • Reduced evaluation reports generation time from average 3 days to 2 hours.
  • Designed and developed teh company's consumer and commercial mortgage portfolio systems with FoxPro.

Lead Programmer

Confidential, Carle Place, NY

Responsibilities:

  • Led IS operations; Hardware and software installation; System development enhancement; Network administration; Staff support.
  • Re-written and automated company’s mortgage portfolio evaluation pricing delivery system with FoxPro from Lotus Symphony.
  • Enhanced teh delivery subsystem to handle flexible import export data format and media.
  • Developed teh company’s mortgage portfolio re-underwriting system, capable of recording over 1500 variables.
  • Design and developed teh company’s portfolio tracking system, which links and controls all teh subsystems.

Hire Now