Mc Cous Fevrier

MSDBA, MCP

* ******** **

Jackson, NJ 08527

E-Mail: ac1t0m@r.postjobfree.com

Cell: 973-***-****

Home: 732-***-****

Technical Summary

Twenty two years of solid database experience in database administration, design, performance tuning and support, along with an extensive technical background and training in Microsoft SQL Server, and Oracle; included is sixteen years of solid experience working in the financial industry. I am currently responsible for managing and maintaining the largest Fix Income securities electronic trading database system in the US.

MSSQL Technical Skills

Experience in installing, upgrading and configuring Microsoft SQL Server 2005, 2008R2, 2012, 2014 and 2016 including SQL cluster installations and upgrades.

Expert in Database Administration, configuration, performance tuning and maintenance with outstanding troubleshooting skills.

Expert in writing and tuning complex TSQL queries, including stored procedures, triggers, functions and TSQL batch jobs.

Experience in backup strategies and database recovery.

Expert in database log shipping, replication – snapshot, transactional and merge replication, mirroring and AlwaysOn.

Experience in backup strategies; restore and data recovery procedures and Disaster recovery and planning.

Experience creating and scheduling maintenance tasks for Index/Statistics Maintenance, backups/Restores, DB integrity checks, tracing long running/deadlock queries

Experience in Database and Business Intelligence Technologies and Reporting using SQL Server 2005, 2008, 2012, 2014 and 2016 SSIS and SSRS.

Experience in Data Modeling - requirement Analysis, Physical, Logical design, using Ewin and Power Design.

Experience in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS), DTS, Bulk Insert and BCP

Expert in creating various types of reports such as complex drill down & drill through reports, matrix reports, sub reports and charts using SQL Server Reporting Services (SSRS) .

ORACLE Technical Skills

Experience in installing, upgrading and configuring Oracle 11g and 12c, including Oracle RAC Cluster-ware setup and configuration, and ASM Grid Installation on Solaris and Linux servers.

Experience in configuring active Data Guard and Service Broker.

Experience installing Patch Set Update (PSU) and Critical Patch Update (CPU) installations.

Experience in Backup strategies and Recovery techniques using RMAN, including duplicating/cloning Databases with point-in-time recovery option.

Expert in writing and tuning complex PLSQL queries, including stored procedures, triggers, functions and batch jobs.

Expert in managing and maintaining Oracle utilizing Toad for Oracle.

Expert in tuning Oracle databases using the following tools/utilities: OEM, OEM 12C, AWR, ASH, Explain plan and ADDM

Experienced in Administering Oracle Database using Oracle Enterprise Manager and PL/SQL Developer

Experience in Data Migration using Data pump utility.

Experience

9/2006 – Present Tradeweb Direct – Retail division of Tradeweb.

Tradeweb Direct is the largest over the counter market destinations for electronic trading in Municipals, Corporates, Agencies, MBS and Certificates of Deposits.

Sr. - Lead Database Administrator/Developer

MSSQL

Responsible for MSSQL database systems- production, staging, QA and development used by the Tradeweb Retail Fix Income Security Trading web application. This includes monitoring database servers using Quest Enterprise Spotlight, and ensuring all database servers are always at optimal performance.

Provide developers with data models in the development and design of new trading features.

Installation and upgrade of Microsoft SQL Server databases 2005, 2008R2, 2012, 2014 and 2016 including SQL cluster installations and upgrades.

Setup, monitor and maintain transaction replication to offsite DR servers, Read Only production and reporting servers.

Established baseline procedures to help identify unusual performance anomalies and identify potential performance problems caused by new release.

Capacity planning to ensure database system optimal performance prior to integrating high value trading clients. This involves the collection of performance metrics such as CPU, memory usage disk read and writes and produced capacity planning reports for future hardware expansion.

Responsible for evaluating and tuning Microsoft SQL Server stored triggers, function, procedures which also include adding and maintaining indexes.

Create, reviews, and assist developers in writing triggers, functions, stored procedures dynamic queries.

Responsible for replication setup and maintenance to DR server, reporting severs and read only distribution databases.

Rewrote procedures that archives completed daily trades to history tables decreasing archiving process execution time from 1.5 hours to 30 minutes.

Installed and manages Reporting Server (SSRS) including creating over 200 management and client reports that are scheduled and email to clients daily, weekly and end of month.

Setup and maintain production distribution databases system using transactional replication where writes occur only on the Primary database and application reads on the subscriber servers.

Designed and develop SSIS packages that transfers and transforms trading data between Oracle and SQL Server

ORACLE

Installation of Oracle 11g and 12c database and Grid Infrastructure software on Solaris and Linux standalone servers and 2 node RAC servers.

Patching 11g and 12c Oracle Database and Grid installations.

Configured Active Data Guard and Data Guard broker service between the primary and standby databases.

Utilize data pump tool for exporting and importing the data between oracle databases.

Performance tuning of queries consuming excessive resources or slow running queries by providing required hints and query re-writes.

Manage Daily Online backups (Level-0 and Level-1) and Archive Backups using RMAN.

Assists developers in writing and tuning stored procedures and PLSQL queries.

Write, develop and schedule shell script jobs that performs database maintenance functions.

05/2004-09/2006 Mellon Financial. Jersey City, NJ

Promoted: Database Architect

Redesigned and scripted the Employee Stock Option Import/Export module which resulted in an 80 percent reduction time in the nightly batch Import/Export.

Co-Authored Mellon Investor Services Data Modeling Best Practices specifications document

wrote the technical specification document for the conversion of Microsoft SQL Server databases 7.0 to 2000.

Responsible for modeling and approving all database changes made to the Employee Stock Option database.

Maintain database models and data dictionary for Stock Transfer, Employee Stock Option, Employee Stock Purchase Plan, Interactive Voice Recorder (IVR) client repository, and IVR Contact History database systems.

Designed the following database systems: Restricted Stock for Employee Stock Option, Interactive Voice Recorder (IVR) client repository, and IVR Contact History database systems and HRIS Benefits Client History.

Created and Assisted developers in writing triggers, stored procedures and scripts for DB2, Sybase, Oracle and Microsoft SQL Server databases.

Responsible for evaluating and optimizing Microsoft SQL Server and Sybase stored procedures, triggers and database servers.

Approves all production stored procedures and triggers created by the development team

Analyze database performance and design the necessary indexes or stored procedure changes to improve performance.

Assists and provide guidance to DBAs on staff

Responsible for reviewing and approving database systems created by outside contractors and vendors.

Created C## application for maintaining Interactive Voice Recorder (IVR) client repository data.

Designed DTS Packages

07/2001- 05/2004 Mellon Financial. Ridgefield, NJ

Sr. Database Administrator/Modeler

Microsoft SQL Server 7.0 and 2000 and Sybase 11.2 and 12 database Administrator.

Designed logical and physical model using Power Design for new database system used for pre-clearance of all employees stock purchases and sales.

Maintained logical and physical database model used for the management of employee stock options database system using Power Design.

Maintained Data Dictionary for employee stock option database system.

Designed and implemented transaction replication for the Employee Stock Option Database.

Designed and developed database and Visual Basic front end used for keeping track of databases and database servers issues.

Installation of MSSQL 2000 clusters.

Managed and implemented database backups for all production databases.

Designed and developed database and Visual Basic application used for recording and reporting Sybase and MSSQL tape and disk backups.

Worked closely with manager in developing strategic direction for DBA group.

Installation of MSSQL Server 2000 and 7.0

Provided DBA support to developers

04/98-07/2000 Cahners Travel Group. Secaucus, NJ

Database Administrator

Microsoft SQL Server 7.0 and 6.5 Database Administrator.

Designed Logical and Physical data models for new database systems using Erwin design modeling tool.

Designed and developed project plans for new database system and VB client front end.

Upgraded production MS SQL servers from SQL 6.5 to 7.0.

Designed and developed VB parsing programs and SQL scripts for data import into MS SQL Server from legacy systems.

Wrote and supported SQL Server triggers, stored procedures and scripts.

Wrote Crystal reports for management and end users.

Provided DBA support to developers.

MagicSolution, Inc. Paramus, NJ

01/95-04/1998 Systems Engineer

Responsibilities included database manipulation, administration support for Sybase SQL Anywhere, Oracle 7.x and Microsoft SQL Server 6.5 databases.

Wrote and supported Sybase SQL Anywhere, Oracle 7.x and Microsoft SQL Server 6.5 triggers and scripts.

Co-wrote the integrated crystal report programs for the Support Magic 4.x release (Oracle, Microsoft SQL and Sybase Anywhere databases) using Crystal Reports 6.0.

Provided technical support to System Integrators in the installation, configuration and integration of Support Magic on Novell and NT networks using Sybase SQL Anywhere, Oracle 7.x, Microsoft SQL Server 6.5 and Btrieve 6.x database engines as well as Support Magic Web on IIS and Netscape web servers.

Provided third tier support for help desk on high-level database and complex environmental issues.

On-site evaluations involving troubleshooting and/or resolving high level technical issues in complex environments for high profile or key strategic clients.

05/94 - 01/1995 Network Integration Services, Inc. New York, NY

Consultant to JP Morgan, New York, NY

Responsibilities included the installation of PC, Macintosh and SUN computers to token ring and Ethernet networks

Education

02/92 - 01/94 Baruch College, New York, NY

MBA Computer Information Systems

GPA: Major 3.75 Overall 3.56

02/88 - 06/90 Baruch College, New York, NY

BBA Computer Information Systems

GPA: Major 3.75 Overall 3.52

09/85 - 01/88 New York City Technical College, Brooklyn, NY

AA Data Processing

GPA: Major 3.94 Overall 3.56

Technical Skills:

Software: SQL Server 97, 2000, 2005, 2008, 2012 and 2014; Oracle 11g and 12c; Toad for Oracle; Sybase 11 and 12; ERWIN; Power Design; Crystal Reports, MS Word, Excel

Languages:

Visual Basic, C##

References:

Available upon request

Contact this candidate