RESUME
Robert Montgomery
Senior Enterprise Operational DBA – Consultant/Contractor
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, 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, SMTP.
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.
1/29/2007 – Present:
Senior Operational DBA - CTI, Inc Consultant.
Confidential
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.
11/29/2006 – 1/26/2007
Senior Database Administrator
Kaplan College
Ft Lauderdale, Florida
Senior team contractor
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 2000 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
|