Database Architecture, VP Resume Mellon - Hire IT People

EXPERIENCE:

Confidential, Mellon

Database Architecture, VP

Responsibilities:

Have over 19 years of experience in supporting MS SQL database
Train and support AlwaysOn High Availability environments for critical applications. Setup Available databases for reporting purpose as well as for DR
Supports for Production, UAT and Dev Servers - including daily maintenance tasks, SQL optimization, testing Disaster Recovery, customize database installation, and troubleshoot database problems.
Support large databases - 2 TB to 7 TB
Familiar with SSAS, SSIS as well as SSRS.
Write powershell scripts to automate tasks like health check, maintenance plan, redirect restore, migrate login IDs
Migrate Sybase, Oracle databases to SQL Server.
Setup Linked Server so application can access data from different RDBMS.
Strong knowledge in using Foglight and DMV to identify performance issues.
Leverage open publish codes to monitor and troubleshooting performance - sp who3, sp whoisactive etc.
Write DBA best practices, database standards, and database security policy affecting a world wide customer base.
Provide training for first level, junior DBA in support bank applications
Upgrade, migrate SQL Version and implement patches.
Assist, work with 3rd party vendors to ensure the software is complying with bank security standards. Also work with Vendor to identify any performance, bug and security issues.
Involved in capacity planning in estimating large database size

Confidential

Sr. Database Systems Analyst

Responsibilities:

Provided 24/7 support for all SQL Databases, covering over 3000 SQL instances.
Created scripts to automated DBA tasks such as backup, restoration, installation, re-indexing, database integrity, and the health of the SQL databases.
Set up replication to move data across Confidential regions and nations.
Set up SQL Clustering for high availability applications by using MS Cluster Server and SQL Log Shipping.
Monitored the health of databases using MS SQL Profiler, System Performance Monitor, and BMC Patrol.
Created a Business Continuity Plan for Confidential critical applications such as Payrolls, Confidential Capitals and Exchanges, and Global Trading Systems.
Study the new features of SQL 2005, such as unattended installation, Security, Database Mirroring, Database Snapshots, Mirror Backup, and new SQL Utilities.
Consolidated the footprints and reduce TCO of the SQL Databases in the Confidential Data Centers by using third party software.
Architected a SQL Common Production Environment to host all in-house Application databases by integrating MS SQL Server, PolyServe, SAN.

Confidential

Database Developer

Responsibilities:

Developed Sybase SQL Stored Procedures for an Equity Trading application called International Orders Routing System.
Provided 24/7 support to the IORS database like replication issues, synchronized the data between Hong Kong, London, Tokyo, New York and Sydney.

Confidential

Database Systems Analyst

Responsibilities:

Installed Oracle database for Confidential internal applications on UNIX and NT platforms.
Created and wrote NT shell scripts to automate the Oracle server/client install.
Develop short programs in C and PL-SQL for daily administrative tasks, backup, and optimizing database performance.
Provided 2nd level technical support for Oracle Database issues for Confidential applications such as Automated Inventory Management System (AIMS), Package Claims Systems (PCS), Dimensional Weight Systems (DWS), Helpdesk, Resume Tracking Systems, Plant Engineering Project Administration (PEPA)
Implemented BMC Patrol Monitor tools for all Confidential database servers; wrote different programs in C or NT shell script to automatically resolving the known Oracle issues for the alert filter processes.
Implement Tivoli software to monitor the performance of the NT Enterprise Server.
Evaluated and tested different features of Microsoft SQL Server 7.0.
Created and simulated the production environment in the Database System Programming Lab to test and evaluate new application databases.
Tested and certified all Oracle products for Y2K bugs.