mobile: +1.678.576.2942
email: greg@ferdinandsen.com
v Graduate study, Economics Old Dominion University 1996
v B.A., Economics Pennsylvania State University 1996
v
SQL Server 6.5/7/2000/2005, SQL OLAP/Analysis Services/SSAS, SQL
Integration Services/DTS
v Exchange, IIS, MOM
v Visual Basic, VB Script,
ASP, HTML
v Windows NT, Windows 2000 Server,
Windows Server 2003, Windows Server 2008
v TCP/IP, DHCP, DNS, Active
Directory, Terminal Services, Clustering Service
v Legato, Veritas, CommVault,
Senior SQL DBA Interactive Communications, Inc . February 2009 - Present
v Responsible for numerous OLTP SQL production databases over 1TB with over 7,500 concurrent connections
v Responsible for several datawarehouses, the largest being 5TB
v The enterprise contains over SQL database servers on four distinct domains (without trust), including SQL 2000, 2005, and 2008 running on x86, x64 and x64 datacenter
v Our databases handle 90% of all gift card activations in the U.S., U.K., Canada, and Japan, including iTunes Cards, Target Cards, Wal-Mart Cards, and Best Buy Cards
v Lead the migration from SQL 2000 to SQL 2008 for legacy database servers
v Our SQL group does heavy T-SQL analysis and tuning (studying execution plans before implementing code in production environments)
v 100% responsible for index creation and rebuilding/re-organization/de-fragmentation (due to the inherited nature of the position, there was no automation of index maintenance)
v Created countless automation scripts (user creation, index re-org, fragmentation analysis)
v Implemented numerous DR solutions including SAN Mirroring, transactional replication, database mirroring, and log shipping
Contract DBA SunTrust
Bank's January 2008 - Present
v Solely responsible for
production databases for the SunTrust Mortgage line of business (excluding the
on-call DBA for emergency situations)
v High transaction OLTP environment
(peaking at 25,000+ transactions/sec;
averaging 900 TPS)
v The application uses four
production SQL Clusters (SQL2k x86 and SQL2k IA64) and numerous Dev/BF/QA
clusters
v Significant database growth
(65GB to 135GB over six months)
v Databases are considered
amongst the highest visibility of the mission-critical databases within the SunTrust
enterprise
v
Assisted developers with T-SQL code development for more efficient
execution
v
Responsible for all database and database environment documentation
v
Responsible for database performance analysis and database tuning
v
Significantly reduced deadlock volume by 70%
v
Maintained close to 99.99% database uptime
v
Worked extensively with OS and SAN teams to increase database
performance through system modifications (different SAN configurations, OS
modifications, etc...)
v
Assisted in engineering the DR solution for the databases
v
IA64 and x86 environments for SQL 2000; IA64, x64, and x386 for SQL
2005
v
Participated in the on-call rotation for SQL Server (at-least 50
production SQL cluster's in SunTrust's environment)
Designer Norfolk-Southern
Corp. August
2004 – August 2007
v Responsible for the
administration of over 60 SQL Database Servers (SQL 7, SQL 2k, SQL 2005), an
increase of more than 400% during my tenure at NS
v Responsible for in excess of
550 databases ranging in size from 5MB to over 2TB
v Implemented a enterprise-wide
solution for the consolidation of existing SQL Servers to virtual SQL Servers
using named instances and virtual server technology
v Implemented a new back-up solution
utilizing Galaxy/CommVault for SQL Server for off-site backups and data
retention
v Designed a log-shipping
solution for DR from two tertiary data centers to the DR data center
v Worked with my collogues to
ensure maximum performance of existing servers
v T-SQL code review for
developers
v Performance-tuning (indexes,
memory, physical IO)
v Standard SQL Server
Maintenance (DBCC, re-indexing, statistics)
v Partitions (Views, Tables
[SQL 2005])
v Configured MOM and NetIQ for
server health monitoring
v Oversaw the migration from
an existing NetIQ environment to a new MOM environment
v Assisted in the enterprise architecture
of the new MOM monitoring environment
v Architected a new
geographically-dispersed cluster solution for high-availability and DR
v Migrated from 15 stand-alone
servers to an environment consisting of 2 seven-node geographically-dispersed
clusters
v Maximized availability by
leveraging three data-centers, proprietary SAN technology (HDS TrueCopy and EMC
MirrorView), and large bandwidth to provide the highest level of availability,
disaster recover protection, and 99.999% uptime
v Designed the solution to
provide for fail-over within either facility as well as fail-over to the
secondary facility
v Eliminated log-shipping and
replication for the primary corporate database servers
v
Acted as team-lead for the relocation of the primary data-center from
an existing facility to a newly acquired data center
v Responsible for the
migration plans for 21 production SQL Servers
v Assisted application teams
in architecting a solution utilizing the DR data-center to minimize down-time
during the migration
v
Worked with the architecture group to implement the migration in the
most efficient manor minimizing disruption to the user community
Senior
Technical Analyst Unisource
Worldwide July 2003 – August 2004
v Responsible for the
administration of 41 SQL Database Servers (SQL 2k) an increase of 140% during
my tenure
v Responsible for over 80
databases (production, QA, development) in two NOC’s ranging from 5MB to 900GB
v Planned for disaster
recovery by increasing back-up frequency and off-site storage of data
v Utilized SQL-Mail to
streamline SQL Server administration
v Set-up monitoring of all
database servers for quick off-hours support
v Responsible for installation
of SQL Server, OS, and Cluster Service (2k, 2003) on all SQL database servers
v Documented all existing
databases (job schedules; scalability; schema; data retention)
v Designed and architected all
new database environments
v Architected a redesign
back-end database servers for all mission-critical applications
v Redesigned for scalability a
single-tier environment utilizing three servers to a multi-tiered environment
utilizing eleven servers incorporating fail-over clustering
v Architected a split for
Analysis Services incorporating separate servers for SQL and OLAP
v Responsible for implementing
a new standards for all database servers
v Increased I/O throughput by
increasing the number of physical disk arrays and controllers
v Enlarged the database
group’s usage of SAN space by over 1300%
v Restricted developer access
to production database servers
v Increased usage of
clustering from one cluster (2-node) to four clusters (2-node, 4-node)
v Designed and enforced T-SQL
programming best-practices
v Implemented replication and
log-shipping for reporting servers
v Served as database team-lead
for the migration from Georgia-Pacific to an independent, privately-held
corporation
v Moved from the
Georgia-Pacific NOC to a new NOC
v Migrated over fifty
applications/databases from Georgia-Pacific administration to Unisource administration
v Actively provided assistance
to development teams in the development of T-SQL code for best-practices (stored
procedures, DTS, triggers, OLAP)
v Re-architected numerous
existing databases for increased performance and scalability
v Reduced the incidences of
blocking and deadlocks by changing the index structure
v Increased performance by
reducing the usage of cursors
v Physically partitioned
databases into several database files to increase I/O
v Implemented normalization to
reduce table size and overhead
v Mentored two junior SQL
Server database administrators
v Attended the SQL-PASS 2003
conference as the representative of Unisource
v Administered 32 production
databases for Consumer Web Portal and Physician Web Portal (SQL Server 6.5, 7,
2k)
v Responsible for 71
databases, on 15 servers, in 3 NOC's
v Responsible for installation
of SQL and configuration of Cluster Service on production database servers
v Performed routine database
maintenance and tasks (backup/restore, dbcc, index tuning, data export’s [bcp,
dts], usage statistics)
v Developed and implemented
disaster recovery plans
v Served as database architect
for all new enterprise-level databases
v Oversaw the redesign of
existing databases for normalization and increased performance
v Documented all database
related functionality and schema (ER/WIN, Visio)
v Implemented transactional
replication between different NOC's
v Implemented merge
replication within NOC’s
v Architected numerous
full-text indexes
v Served as ad hoc DBA for DB2
and Oracle databases
v Oversaw migration from
DB2/Sun to SQL2K/Win2K for numerous production databases
v Participated in numerous
migrations to and from Oracle, Informix, DB2 and SQL Server (6.5/7/2K)
v Directed migration from
SQL7/WinNT4 to SQL2K/Win2K (without down-time)
v Managed Operating System for
several high-availability/clustered NT/2K machines
v Assisted development team
with T-SQL development of stored procedures and triggers
v Supported migration from SQL
based web-user membership to Active Directory membership
v Lead and mentored a team
three DBA’s with MS SQL Server
v Developed numerous full-life
cycle client/server applications utilizing VB6 and MS SQL Server 7
v Developed a Document
Management System (Client/Server and Web Based ASP)
v Developed an ERP for HR and
Professional Development (Client/Server)
v Developed a Conflict Search
System (Client/Server)
v Designed numerous web-based
and client/server-based Crystal Reports projects
v Assisted with development of
the firm’s intranet
v Administered several SQL
Server databases (SQL 6.5, SQL 7.0)
v Provided IIS support for
intranet
v Assisted with network
administration (NT4, Exchange 5.5)
v Participated in the
development of a new enterprise-wide HR/Practice Management System using VB6
and SQL 7
v Integrated new system to
replace legacy systems, and to integrate with SAP and another proprietary
practice management system under development
v Administered the LAN
(Novell)
v Developed numerous
client/server applications utilizing VB5 and Access
v Accounting/Expense Reporting
System integrated with Access
v Data retrieval and analysis
of client data utilising Access
v Statistical modeling and
analysis with SAS
v Taught the following
classes:
v Introduction to the Personal
Computer
v Presentation Graphics
v Database Management (MS
Access)
v Advanced Programming (VB5)
v Developed numerous
statistical models
v Implemented models by
developing client/server forecasting application utilising VB5 and SQL Server
v Designed econometric
modeling and statistical forecasting models
v Developed analysis and
reporting of client portfolio’s utilizing MS Access
Atlanta, Georgia, SQL, DBA, Resume, SQL Server, Database, Administrator, Job Search, Database Administration, Database Administrator, Georgia USA, GA, 30308, 30309, 30342, 30303, 30326, Buckhead, Midtown, Downtown, Perimeter, Galleria, CV