March 9, 2004 at 5:05 am
18630 N 4th St. Phoenix AZ 85024
H 623-582-9454 C 623-330-2109 djbranscome@cox.net
________________________________________
Senior Database Administrator/Analyst
Technical Summary:
OS:Windows Xp, 2003 Server, Windows 2000 Server, Professional and Enterprise, NT 4 Server & Workstation, Novell 4.1
Software: MS Sql2005 Enterprise, MS Sql2000 Enterprise MS Sql 6.5, Erwin, Red-Gate, Progress 9.1D 10.1A, MS Office, Cisco & Nortel VPN, Veritas, PCAnywhere 10, Outlook, PKI
Networking: TCP/IP, DHCP, IPX/SPX, Setup and administer Microsoft networks including
DHCP, DNS, SNMP, Wins, IPX/SPX, NetBios, FTP Setup and administer Novell networks.
Education & Certification: Bachelor of Science Education and Psychology Univ. Southern Miss.
United States Army Transportation Officers Basic & Engineer Officers Advance Course MCSE NT 4.0 MCDBA Sql2000 #1336946
Work Experience Summary
•14+ years Relational Database design, administration and optimization
•7 years Domain Administrator NT4/Win2k 1 yr Novell 4.1 administrator
•2.5 years Powerbuilder & Case tool development
Encore Legal Solutions
Senior Sql Database Administrator 10/2007/Present
•Implement Logging and Crack for Recovery/Reset of SA password, Document Sql Security
•Re-implement Sql Server scheduled maintenance and backups Sql2000/Sql2005
•Trouble shoot & Document DTS/SSIS packages used in business processes.
•Provide email reporting in support of business objectives
•Implement SSIS to collect baseline Sql performance measures
•Review and Aid in 3rd party Database upgrade, server support and version control
•Provide instruction to Sql Developers in support of business objectives
•Develop and Document procedures to Archive and Reload data to business applications
Bear Stearns
Senior Sql Database Administrator 10/2006 – 10/2007
•Review, Test and Apply ddl scripts to BSRM database in Development and MSCS
•Administration and Version control of Sql Environments
•Coordination with 3rd party app/dba on version control and implementation
•Work with 3rd party in development, testing and implementation of partitioned view
•Performance analysis and capacity planning of 400+g BSRM database on MSCS
•Work with Enterprise Server Administrators to establish server performance monitoring standards
•Design and Implement ETL into 3rd party data warehouse using DTS
•Upgrade of Sql2000 environments to Sql2005
Universal Technical Institute1/2005 – 9/2006
Database Administrator
•Administration of Progress and MS Sql Server databases.
•Move of Enterprise MS Sql and Progress Environments to New Hardware and San.
•Dump and Load of Corporate Progress Databases.
•Administer and Document procedures to improve control of Progress environments and development cycle.
• Evaluation of Progress Dev, Test, Train environments on VM servers.
•Review, Optimization and Testing of backup and recovery strategies for corporate databases.
•Development of DTS packages passing data between Progress, MySql & MSSql
•Upgrade from Progress 9.1D to 10.1A
•Troubleshooting and Administration of ImageNow document handling system.
•Provide Data feeds to 3rd party Auditing firm.
•Above and Beyond Award for Achievement
David M. Branscome
18630 N 4th St. Phoenix AZ 85024
H 623-582-9454 C 623-330-2109 djbranscome@cox.net
________________________________________
Database Administrator/Analyst
Ajilon Consulting10/2004 – 1/2005
Sr. Database Analyst
•Development of ETL procedures in support of Wells Fargo Human Resources web site.
•Manage Sql changes to Development and QA Sql Servers.
•Query/Stored Procedure and Index Optimization.
OurVacationStore.com4/2004 – 10/2004
Sql Developer
• Provide VBA Financial Reports from Corp Sql Servers.
•Setup and Evaluate Crystal Reports & MS Reporting Service for implementation
of Centralized Reporting.
•Integration of Corporate Sql Servers with MS Great Plains through Sql DTS packages.
Choice Hotels International12/1996 – 2/2004
Programmer Analyst/Database Administrator
•PowerBuilder: Design and Code user defined reporting processes for Profit Manager.
•Aid in database design and optimization, query optimization in enviormnents ranging from small to 100+gig and Sql2000 on MSCS (Microsoft Cluster Service)
•Develop TSql script to analyze and removes indexes that do not improve performance.
•TSql upgrade scripts. (Upgrade scripts run without direct supervision and include triggers, stored procedures, index modification, table migration, server configuration and scheduled job changes. Upgrade scripts include pre-upgrade backup, logging of script progress, Email notification and auto restore from pre-upgrade backup on failure.)
•On call rotation 24/7 Tier 3 support for over 2800 NT4/Win2k domains each with Sql6.5 or Sql2000.
•Support of QA and upgrade staff on Sql and NT issues during upgrade.
• Administration of development databases, servers and domain.
•Design & code migration process for use at 2800+ remote Sql6.5 sites migrating to Sql 2000.
•Setup and Administration of Corporate Data collection servers and processes.
•Corporate Data Collection ( Retrieved over 1 million records a day and included automated FTP of pgp.zip to Visa, MasterCard and IBM for processing of guest transactions)
•Intra Sql Server DTS packages and jobs to access Informix database.
•Ad hock queries and Cross Tab reports from 2800+ Sql Server installations.
•Configure ad hock test environment; implementing available hardware to provide an independent Windows Client / Server LAN.
Billing Supervisor 2/1994 – 12/1996
Presbyterian Service Agency
2001 North 3rd Street, Phoenix, AZ 85004
•Insure PSA received proper authorization for all services provided and billed.
•Data Normalization and migration to Sybase database with relational integrity
•Develop Powerbuilder application to replace Paradox user interface and reports
(The application automated manual processes and provided summary reports with
Dynamic grouping. The application included bulk import and export functionality. The import functionality automated the load of Electronic Authorization Forms and Electronic Explanation of Benefits and offered the ability to reload of archived data. The Export functionality provided the ability to archive data and supported data migration to other platforms and disaster recovery. )
Viewing post 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply