Database Administrator

RESUME

Robert Montgomery

Senior Database Administrator

Coral Springs, FL 33071

Education:

B.S.B.A. in Finance, University of Central Florida

AOS/VS Systems Management, Orlando, FL

VAX/VMS DCL Concepts, Washington, DC

VMS/VMS Systems Management I & II, Boston, MA

DEC/VAX Network Management, Orlando, FL

Oracle Introduction for Developers, Atlanta, GA

Oracle Version 6 Database Architecture, Denver, CO

Oracle Version 6 Database Administration, Denver, CO

Oracle Relational Database Design, Tampa, FL

Oracle Tuning Version 6 Applications, Tampa, FL

Ingres Version 6 Tuning and Configuration, San Francisco, CA

TCPware for OpenVMS, Nashville TN.

NT SQL Server Management, Nashville, TN

Unicenter TNG, Greenville, SC

Advanced PL/SQL Version 8, San Diego, CA

Dell SAN 3.0, FT Lauderdale, FL

Vantive, FT Lauderdale, FL

PeopleTools I & II, Ft Lauderdale, FL

DB2 UDB 7.1 Database Administration Ft Lauderdale, FL

PeopleSoft Data Management and Upgrade, Atlanta, GA

PeopleSoft Server Administration, Atlanta, GA

PeopleSoft Financials 8.8 Richmond, VA

PeopleSoft HRMS 8.4 Ft Lauderdale, FL

Peopletools 8.44 Ft Lauderdale, FL

Hardware and Operating Systems:

AIX 5.1

DEC VAX and ALPHA (OpenVMS and ULTRIX)

NT, Windows 2000, Windows 2003

SUN SPARCstation (SunOS UNIX)

UNISYS (MCPIX)

DATA GENERAL (AOS/VS)

IBM 3090 and 4381 (MVS/XA)

Dell Power Vault and SAN Technologies

NetApp Data OnTap 7.2.4, SnapDrive 5.0 and 6.0, SnapManager 2.1 and 3.0

IBM-x3950 (x86 and x64)

Servers, Workstations, Desktops, Laptops utilizing:

DOS Windows for Workgroups 3.11, Windows 95, Windows 98, NT Workstation & Server, Windows 2000, Windows 2003 R2, Windows XP, MAC OS 7.5, SCO.

Applications Development:

COBOL (68, 74, 85), BASIC, C, PL/SQL, SQL, SQL-FORMS, VIFred, ABF, 4GL, GQL, VB 4.0, Excel, Access, DCL, CLI, UDMS, ArcInfo, GeoVision, PeopleSoft Application Designer, DTS, SSIS.

Systems Management Software:

DCL, Sysgen, Authorize, Diskquota, SPM, ACL, CLI, Monitor, Install, TAPESYS, SPSS-X, Backup, PREDITOR, DUMP_II/LOAD_II, RACF, SMS, Unicenter TNG, Ckmenu, Diskkeeper, JAMS, SQL Enterprise Manager, Oracle Enterprise Manager, SMITTY, QUEST Spotlight for NT and SQL Server, QUEST Foglight, QUEST STAT, NDMP, SMTP, BLAT, NetApp DataOnTap, Netbackup Enterprise 5, 6, 6.5.

Database Management:

SQL Server (All Versions through SQL Server 2008), DB2 UDB, Ingres, Oracle, INFOSII, DMSII, DMT Tools, IPM, IIMONITOR, STATDUMP, NETU, MS-Access, DEFT/Erwin Case Tools, QUEST Central, QUEST Spotlight, QUEST Foglight, Microsoft Clustering , SQL Server Clustering, Embarcadero Enterprise (ER/Studio, EA/Studio, Repository).

Networking:

DECnet, NCP, LATCP, TSM, NDL, SUNlink (DNI), TCP/IP (UCX and TCPware), XODIAC, Pathworks, Novell Netware and Groupwise, Netbui, Ingres/Net, SQL/Net, FDDI, Network Sniffers, Protocol Analyzers, NNTP, SMTPm, SFTP, SSH.

Internet/Web/Office Automation/Desktop:

Teamlinks, Freehand, Framemaker, Pagemaker, IIS, Outlook, Exchange, SQL Mail, MTS/COM+, WebLogic, GQL, Excel, PowerPoint, MS Office Suite, MicroFocus COBOL, ODBC, Persuasion, Visual Basic, MS Project, Visual Source Safe, Peoplesoft PIA, Apache Tomcat, Terracotta.

Experience:

3/9/2010 - Present:

Senior Database Administrator - Independent Consultant

Rewards Network, Inc.

Hollywood, Florida

Returning Senior DBA consultant for the functional implementation and migration SQL Server 2005 databases onto a new version of NetApp SANs for a Sister/DR site located in Chicago. Current Data Center is located in Miami. All databases have been reversed engineered using ER/Studio and compared to existing flow diagrams. Meet with Data Owners, Systems and Network Management, Business Application Directors, Database Administrators, Security Administrators, and Developers (both OLTP and OLAP) to define precise requirements for new systems, upgrading infrastructure, redefining architectures. Saved 2.5 TB of redundant data currently by comparing old data models to new data models that will perform better due to index clustering, and convincing data owners to allow several hundred GB of older data to be archived via new processes that will work into the future (rolling partitions).

12/7/2009 – 3/12/2010:

Senior Database Consultant

OnSystem Logic, HP/EDS, United Health Group

Senior Database consultant for the logical design and functional implementation of Healthcare Business Intelligence and Decision Support Systems for the Department of Defense TRICARE T3 project with United Health Group. Data is being profiled from the current systems, business and government specifications are utilized to develop physical and logical models using modeling/case tools. Currently responsible for the Database Administration and Management of the development to production phases of SSIS, Reporting Services, Analysis Services, Database Instances, Database Schemas, and Database Security. Version Control Manager using Subversion 1.6.3, TortoiseSNV, AnkhSVN. Erwin data modeling, forward and reverse engineering.

1/29/2007 - 11/6/2010:

Senior Operational DBA - CTI, Inc Consultant

Rewards Network

Hollywood, Florida

Senior Operational DBA consultant for the functional implementation and migration SQL Server 2000 databases onto a new clustered IBM x3950 environments utilizing SQL Server 2005 x64, Windows 2003 R2 x64, and a NetApp SAN. The web facing environment has a minimum of 4200 connections to the database instances. The internal Data Warehouse and Decision Support Systems support Informatica, Microstragety, Cognos, and SAS, utilizing SQL Server 2005 and 33 TB of NetApp FAS3050 SAN storage. Currently responsible for the configuration of the new clusters, nodes within the cluster, cluster resources, SQL Server instances, SSIS, Reporting Services, Analysis Services, Database Mail, Disaster Recovery planning and implementation, performance monitoring and tuning, security, administration, integrity, and consistency of databases. Experienced with monitoring and performance tuning of x64 architectures and the use of Dynamic Management Views and wait types for SQL Server 2005 x64. Upgrade of Veritas Netbackup Enterprise from version 5.0 to 6.5. Quest Spotlight Enterprise expert. Installation of SQL Server 2008 for migration testing.

11/29/2006 - 1/26/2007:

Senior Database Administrator

Kaplan College

Ft Lauderdale, Florida

Senior DBA consultant and one of the functional operational consultants hired to migrate 29 active SQL Server 2000 instances onto 8 Window 2003 R2 x64 clusters, running in an Active\Active N+1 environment. This successful project was completed using in-house scripts were created to migrated physical backups files and transaction logs file from one site to the new site using RoboCopy. LiteSpeed was used to compress and encrypt certain databases as they required transported by armored carrier. The entire migration process from script conception to go live was less than 3 months and a flawless implementation with the assistance of the entire organization. Performance gains from database reorganizations completed in about 66% of the previous wall clock time.

3/1/2006 - 11/23/2006:

Senior Database Administrator,

Contractor

Steven Douglas Associates

AutoNation, Inc

NW 33rd Ave

Ft Lauderdale, Florida

Senior team contractor in a group of Database and System Administrators, responsible for the 24*7*365 operations of information systems with one of the largest automobile retail operations. Several Widows Enterprise clusters, utilizing active/active and active/passive clustering of SQL server 2000 and 2005. Experienced with migration and implementation of SQL Server 2000 onto SQL Server 2005 in production with X64 consideration. Experience in the use of DMV to troubleshoot and tune. Clusters are fiber attached to Storage Area Networks with physical storage capacity in the terabytes. Databases average size of 150-300 GB, with transaction replication being used to populate Reporting servers. Primary duties to ensure the production operations by proactively monitoring, scheduled the capture of performance critical statistics and traces, proactively tuning, and the reanalysis of information to ensure the non-stop uptime required. Reviewing all operational requests for impact of changes on production SQL Server environments and databases. Reviewing all releases of production database object changes. Refresh staging, and development as needed to assist in a high throughput operation for Project Administrators and Development teams. Keep DR sites in synch with production for fail-over and weekly DR testing. Provide technical support as needed to the entire organization. Interfacing and assisting in Peoplesoft\Oracle issues including Weblogic Multi-Domain NT Web services.

3/22/2004 - 3/1/2006:

Senior Database Administrator,

TuVox Inc.

Boca Raton, Florida

Management of the physical and logical distribution of databases and objects across Windows 2003 in a high throughput data capture, replication, and data warehousing environment for a voice recognition telecommunication company headquartered in California. 24*7*365 uptime require for customers to access databases using IIS interfaces. Databases located in Boca Raton, Florida and Houston, Texas for fail over and disaster recovery. Standardize real-time reporting and analysis achieve maximum throughput of web based applications across environments. Recovery and fail-over planning and execution during hurricane Wilma's direct hit, 0% operations downtime. Senior SQL Server support of Production, Test, Development, QA environments and customers.

12/14/2004 - 3/31/2005:

Senior Database Administrator,

eDiets.com

Deerfield Beach, Florida

Windows 2000 and Windows 2003 Advance Servers using SQL Server 2000 and several Microsoft Clusters. 24*7 uptime required for the e-commerce site comprised of 40+ web servers and 3 terabytes of SQL Server data files across 4 Production SQL Server Clusters. Performance monitoring of SQL Server Clusters and SQL server databases, objects, queries, and DTS packages to achieve maximum throughput of web based applications across environments. Recovery and fail-over planning. Senior SQL Server support of Production, Test, Development, QA environments and customers.

3/2004 to 11/2004:

Senior Database Administrator/Peoplesoft Technical Administrator,

Contractor

Synigent Technologies

Richmond, Virginia 23225

Senior SQL Server DBA and Peoplesoft Administrator for a Peoplesoft Financials installation utilizing Peopletools 8.19.08 with Financials/SCM 8.0 SP3 on Windows 2000, Windows 2003, and Windows XP, with SQL Server 2000 databases. Current responsibilities support Production, Test, Development environments and customers. Installation of Peopletools 8.44.08, Weblogic 8.1, BEA Tuxedo, PeopleSoft Financials 8.8 for Upgrade Project. Administration and configuration of Application Servers, Process Schedulers, WebLogic, and SQL Server 2000. 8.44.08 working experience with the configurations of the Environmental Hub Agents for 8.44.08 Peopletools and the 8.8 Application environments. Working with the Change Assistant and its connection to the GSC for bundles, patches, fixes (8.44 Peopletools). Manage Quest's Foglight 3.0, Spotlight for NT and SQL for performance monitoring/reporting, capacity planning, and trend analysis. Primary GSC contact, primary Quest products contact. Establishing training plans for new Peoplesoft DBA's and Administrators.

4/2000 to 12/2003:

Senior Systems Manager/Operational Data Store Database Administrator/PeopleSoft Administrator,

Spherion Corporation

2050 Spectrum Blvd

Ft Lauderdale, FL 33309

Senior SQL Server DBA and PeopleSoft Administrator for FS 8.4, HRMS 8.18, Front-Office 8.4, Portal 8.4, DB2 UDB AIX Series EEE environment, several LPARS, Sharks, McData switches. Intel systems are use for Batch Schedulers (Crystals, Nvision), SQL Server DBA and Senior Systems Manager for Training and Operational Data Stores (converting to EPM). Major accomplishments: PeopleSoft Financials, HRMS Payroll, building and deployment of PeopleSoft on AIX and NT in a complex ERP environment. Additional responsibilities for SLAs on Windows 2000, SQL Server 7.0 & 2000 delivering 99.98% production uptime for the Operational Data Stores and Data Warehouses. SQL Server 7.0, SQL Server 2000, Oracle Rdb, IIS, Weblogic, COM+(MTS), VB (ADO) are utilized to populate, stage, analyze, and distribute information. Responsible for the production, test, and development environments. Client Services support for systems and developers in a large distributed environment. Systems Support for production, development, testing operating systems, hardware, and third party software. Technical Support for the logical and physical systems design, in-house database design, ERD diagrams and Data Models, hardware and software installation, disaster recovery, security, database systems administration, systems and software performance monitoring and tuning. Managed the configuration of more than 40 NT & Windows 2000 production, development, and test servers. Terabytes of production data utilizing SAN technology. Visual Source Safe Administrator.

12/98 to 3/2000:

Information Systems Consultant,

Data Processing Services, Incorporated

521 East Morehead Street

Suite 580

Charlotte, North Carolina 28202

Major accomplishments: Reviewed database designs for recoverability, integrity, and consistency. Reviewed embedded SQL programs for coding standards, SQL performance, and logic. Reviewed physical and logical database designs, documented, modified, staged, released designs using Erwin Database systems configuration, management, and performance tuning consultant. Areas: Disaster recovery, technical support, database systems administration and tuning for Oracle (7.333 Server, 7.34 Server, and 8.05 OEM), Ingres 6.0 through 1.2, SQL Server 6.5 and 7.0). Client/Server and Raid configuration expert. Client service projects included: OpenVMS ALPHA applications systems review and modification using DCL, Ingres, VIFred, ABF, 4GL, COBOL; NT Oracle 7.34 Server with WIN98 Oracle 8.05 OEM installation and configuration; OpenVMS DEC BASIC DecTalk sales application programming project; Data General UX Cimpro application migration to AS400 SupportNets N/Compass G/L package.

3/97 to 12/98:

Corporate Database Administrator,

Bowater Incorporated, 55 East Camperdown Way,

PO Box 1028

Greenville, SC 29602-1028

Major accomplishments: Reduced response time of relational database client server applications from 2 to 10 times (up to 1000% performance gains) by tuning operating systems, database server parameters, distributing data and indexing, IO technology (Raid0+1 and Raid5), and reviewing/modifying SQL statements. Ingres, Oracle, SQL Server Administrator/DBA. DEC OpenVMS and NT Systems Administrator . Designed database performance models using DMT tools, GQL, and Microsoft Office products. Project leader for corporate applications conversion to a client/server/network architecture model substantially improving Service Level Agreements compliance. VAX to ALPHA Migration Project leader. Experienced in installing, managing, upgrading, configuring, and tuning NT 4.0, OpenVMS 7.1, Ingres 6.4.05, Oracle 7.334, SQL Server 6.5 (NT Alpha and Intel platforms) and associated tools/products. Implemented NT Oracle 8.05 (OEM) to assist in managing 7 Oracle instances (7.334) running on OpenVMS 7.1 Alpha. Implementation of CA-Unicenter TNG and associated TNG enterprise management products. Innovator of Intranet management reporting of systems and applications performance.

12/91 to 2/97:

Technology Specialist,

Willis Corroon Corporation,

26 Century Blvd., Nashville, TN 37230

Major accomplishments: Reduced cost of data center operations by $5 million per year relocating decentralized systems to Corporate HQ located in Nashville, allowing the closing of data centers in 4 states. DEC/VAX and DEC/ALPHA Systems Management (OpenVMS 5.5.2, 6.1, 6.2, 7.1) and Ingres Systems Administrator. Management of VMS production systems comprising of 25 7630's and 6630's divided into 4 regional VAX and ALPHA clusters centralized in Nashville. Administration of 200+ production Ingres databases distributed across the clusters. Research and development of desktop/laptop client tools for integration with relational databases. Experienced in the integration of Microsoft products via SQL Server, ODBC, and Ingres/NET. Guide developers in the design and performance tuning of embedded SQL applications. Perform code reviews for all production release software (8+ million lines of developed 3Gl and 4Gl code) written in COBOL, C, C++, FORTRAN, Basic, and Visual Basic. Experienced in preparation and delivery of presentations on Database Administration and Management. Instructed developers in the use of new and existing development tools on servers and client nodes. Guest speaker at the 1993 Ingres World on "How to Solve the Outer Join Problem". Production and development applications technical support and database administrator. Guided developers in the design and performance tuning of embedded SQL applications. Coded sharable runtime library routines for use by technical support and applications development.. Internet/Intranet Application Team member.

3/89 to 12/91:

Technical Support Assistant Director,

Orange County Supervisor of Elections,

119 W. Kaley St., Orlando, FL 32806

Major accomplishments: Deployment of Sun platforms, Oracle, and GeoVision for GIS systems to assist in the 1990 Census redistricting. Installed and managed the interface to Orange County's GIS Oracle database and TIGER files integration. Division Manager for Orange County's Supervisor of Elections. Responsible for Staff of 15+: Technical Support; Mapping; GIS, Electronics; MIS Operations/Programming; Data Entry. Technical support for Data General minicomputers, SUN SPARCstations, IBM PC's, SUNlink's DecNET interface (NCP), and TransLAN bridges. Prepared and presented division's budgets to Board of County Commissioners and Elections Supervisor. Negotiated vendor hardware/software purchases and performance contacts. Oracle DBA Masters. Clients consisted of Congressmen (persons), Senators, Judges, and elected officials needing data processing from the Elections office.

4/79 to 3/89:

Computer Technology Specialist/ VAX & Ultrix GIS Systems Manager/ Unisys Systems Programmer,

Systems Technology Group,

Orange County Data Center,

100 E. Pine St., Orlando FL 32801

Major accomplishments: Installation, configuration, and testing of nodes/clusters, operating and client systems software, patches/upgrades/releases, printers, terminals, queues, terminal servers, plotters and digitizers in a county-wide environment. Support of systems development programmers and systems; end-users; and remote sites; proactive monitoring of hardware, software, and networks for efficiency and capacity planning; technical implementations of database modifications and reorganizations; systems/network access security; implemented vendor supplied software changes; network/data communications software upgrades, evaluated hardware and software for purchasing; primary vendor support contact for all software and hardware; prepared field communication reports; creation of technical bulletins, procedures and standards; physical security of the facility. Specialized in Oracle 5.0 (DBA Duties for distributed GIS Systems using Oracle, UNIX, and VMS), COBOL, DMSII, INFOSII, VMS, NCP, LATCP, DCL, AOS/VS, CLI, SPSS-X, MCPIX, MS-DOS, Windows, ULTRIX, DECnet, TCP/IP, database design, recoveries, and reorganizations, XRAM (Btree) and ISAM recoveries, data collect systems, networking/communications troubleshooting. Starting in Operations in 1979, to Programming in 1982, to Senior Programmer in 1984, to Computer Technology Specialist in 1986.

Contact this candidate