SUMMARY

Experienced database with a proven track record in developing and implementing processes to increase efficiency, streamline productivity and improve accuracy in data inquiries. Ability to plan, build and execute complex projects incorporating quality assurance and testing, as well as the ability to effectively lead teams to identify problems and support project initiatives.

AREAS OF STRENGTH AND EXPERTISE

• Database Development
• Team Management & Effectiveness
• Database Administration
• Process Improvement
• Strategic Planning & Analysis
• Quality Assurance
• Data Analysis
• Project Management
• Problem Resolution

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

Database Management Lead

Responsibilities:

• Oversee server upgrade projects and monitor and tune both the replication and database server environments.
• Work directly with application developers to optimize the performance of database queries.
• Perform regular incident management to fix issues when they occur.
• Subject material expert for applications in CIO including the CAF application OPICS.
• Perform root cause analysis to prevent re - occurring issues
• Write and update scripts to monitor the server environment, improve efficiencies, and generate reports for audit security reconciliation.
• Manage various projects including database upgrades, standardization and auditing, DR run-book knowledge base and alert hygiene for CIO.
• Perform BAU Administration tasks for MSSQL including, scheduling and running dbcc, reindexing, update statistics, log shipping setup andmirroring setup,
• Perform new server builds for MSSQL including SSAS, SSIS and SSRS
• Perform new server builds for Sybase including ASE and IQ

Confidential, New York NY

Production Services Database Manager

Responsibilities:

• Implemented and executed a Database Production Services Roadmap project aimed at reducing incident tickets, identifying resolutions, and reducing time spent on tickets ultimately increasing department productivity.
• Analyzed incident ticket trends by establishing metrics to determine common occurrences, ticket turn-over time, and ticket longevity.
• Used Six Sigma methodology to identify ticket requests and developed a process and scripting to prioritize tickets and eliminate duplicate tickets ultimately reducing incident tickets from 10,000 per month to just 5,500.
• Developed a wiki web site with search capabilities to provide staff with troubleshooting information on common database issues reducing the escalation of these issues to the DBA department.
• Established a ten-person, first level support team utilizing the global workflow follow-the-sun model providing 12x7 support in both the New York and Singapore offices.
• Supervised department staff including creating shift and training schedules, holding weekly one-on-one meetings, and facilitating year-end reviews.

Database Engineer

Responsibilities:

• Served as project lead in the world wide rollout of the BMC Performance Manager analytics software.
• Collaborated with groups including storage, UNIX, DBA and business users to determine application enhancements and prioritize project planning and initiation.
• Built Sybase ASE servers, Sybase IQ servers, and Sybase Replication servers for coding, testing and certifying new database products and maintaining the current toolsets.

Confidential, New York NY

Senior Database Administrator Consultant

Responsibilities:

• Managed database servers handling all installations, upgrades and migrations. Implemented automated scheduling jobs to handle standardized maintenance tasks and database monitoring. Optimized query capabilities for client applications.

Confidential, New York NY

Sybase Database Administrator

Responsibilities:

• Monitored and maintained the replication server environment overseeing all database server upgrade projects and writing scripts to modify and create stored procedures. Created several processes improving database efficiency including the ability to drop and add databases to the system and rename replication definitions to avoid them being dropped.

Confidential, Jersey City, NJ

Senior Database Administrator

Responsibilities:

• Determined project priorities and assigned work to staff members addressing any concerns, questions and potential issues and followed workflow progress in adherence to deadlines.
• Implemented a staging environment for pre-testing applications prior to rolling them into live environment.
• Set up a full database backup and data recovery process through an automated scheduling system which allowed jobs to be run on several machines while monitoring could be done from a single location.
• Improved online transaction processing by 40% through the implementation of standardized naming, temporary caching and looping protocols.

Confidential, Weehawken NJ

Senior Associate/Database Developer

Responsibilities:

• Developed OFX. A product to allow a client to download their transactions into Quicken or Money. Responsible for database design, physical database development, production support and database tuning.
• Developed PaineWebber EDGE. The EDGE is an online account inquiry system allowing clients to view their statements, look at market data and do research. Responsible for database design and development.
• Built a tool using Perl and CGI allowing the dynamic updating of intranet web pages.
• Project manager in charge of migration of the production Unix hosts into the EMC environment.

TECHNICAL SKILLS

Software Sybase ASE Server, Sybase Replication Server, Microsoft SQL Server, Sybase IQ, : BMC Performance Manager,BMC Database Automation,Control-M, Veritas Cluster Services, SYBASE Open Client,

Autosys, IWatch, DBArtisan, Microsoft Office, Visio, : Oracle 11g

Operating Systems Unix, Windows NT, Windows XP, Windows 2000, Windows 7, Windows Server 2003 : Languages: SQL, Unix Shell Scripting, PERL