Customer Service Oracle
Resume:
Apt *
Boston, MA *****
****.******@*****.***
Lyle Steere
Summary Of Qualifications
Proven track record for building up architecture frameworks that supports
•
core business processes and overall enterprise IT strategy
Strong expertise in creating guidelines and best practices for developing,
•
selecting, and implementing enterprise information systems, data
models/architecture, and compliance policies to support large scale
organizations in core industries (Defense, Financial Services,
Pharmaceuticals, Software, and Nonprofits)
Interacted with Enterprise Architecture (EA), developers, project
•
managers and IT focus groups to help control expenditures, avoid
redundancy, and improve overall data synergy within organizations
Strong knowledge of software, hardware, applications, networking, and
•
system engineering
Excellent presentation, communication, and organizational skills
•
Professional Experience
2007 Present GENERAL DYNAMICS IT Needham, MA
Senior IT Manager – Enterprise Data & Database Architecture
Senior IT Manager supporting all of GDIT’s enterprise data, including
•
enterprise applications (Oracle E Business Suite, Siebel, PeopleSoft,
Hyperion, OBIEE/BIAPPS)
Responsible for managing a team of highly skilled engineers and
•
architects in various regions of the country supporting 1500
enterprise applications
Responsible for managing and maintaining the overall enterprise data
•
architect/model for all enterprise applications and open systems
interfaces
Responsible for managing and maintaining an annual budget of
•
$6.5M (personnel, software, hardware, maintenance)
Designed and implemented High Availability (HA) and Disaster
•
Recovery (DR) solutions for all major enterprise applications using
Oracle Real Application Clusters (RAC), Oracle Data Guard, VMware,
and data domain
Designed and implemented Information Lifecycle Management (ILM)
•
solutions using Oracle Partitioning, Advanced Compression, and
tiered Storage Area Networks (SAN)
Responsible for managing and maintaining the core financial systems
•
consisting of a 4 node Real Application Cluster E Business Suite
(r12) environment (5TB), OBIEE/BIAPPS Warehouse (5TB), and
Hyperion
Successfully upgraded, patched, and maintained an Oracle E
•
Business Suite 11i and r12 supporting $7B in revenue
Lead data/database architect consultant for external government
•
programs (Secret Clearance)
Designed and built 4 enterprise private database clouds to leverage
•
hardware resources and control licensing costs
Designed and implemented a unified enterprise support model using
•
home grown PERL/shell scripts, Grid Control, unified deployment
model, with a dominate focus on customer service and quality
Worked with storage engineers to design and implement storage
•
devices for mission critical enterprise applications
2007 2007 TARGET SOFTWARE/BLACKBAUD Cambridge, MA
Senior Database Architect
Tasked with providing DBA/Application support services for 30+ hosted
•
CRM clients, and technical database consulting for 60+ in house clients
Tasked as a Lead DBA to design an enterprise class Oracle Platform
•
Architecture that promotes scalability and ease of management
Responsible for designing and implementing a High Availability (HA) and
•
Disaster Recovery (DR) service offering using Oracle 10g Real
Application Clusters (RAC), Transparent Application Failover (TAF), and
Data Guard
Responsible for designing an infrastructure support model using PERL
•
and shell scripts
Responsible for the overall performance and availability of the company’s
•
10 terabyte data warehouse
2005 2007 FIRST MARBLEHEAD CORPORATION Boston, MA
Senior Database Architect
Tasked with architecting an infrastructure to support the company’s newly
•
formed Oracle environment which included designing logical and physical
design standards, release engineering standards, and an infrastructure
support model using Oracle Management Server (OMS), Recovery
Manager (RMAN), PERL, and shell scripts
Worked with storage engineers to design and implement a backup and
•
recovery solutions that would adhere to Sarbanes Oxley (SOX) and
business continuity requirements
Responsible for re factoring the company’s Enterprise Data Warehouse
•
(EDW) which resulted in ease of management, consolidation of schemas,
and a less complex security model
Lead participant in the company’s Oracle Center of Excellence committee
•
with a primarily focus on RDBMS best practices and overall strategic
database initiatives
Lead Data Architect for the company’s workflow automation project which
•
consisted of integrating and collapsing 5 legacy systems into a central
loan origination system
Responsible for extending the overall enterprise data model to support
•
workflow automation
Designed, documented, and built a high availability, continuous operation,
•
and disaster recovery service offering using Oracle 9/10g Real
Application Clusters (RAC) with Veritas Cluster Server (VCS), Data
Guard, and Veritas Volume Replicator (VVR)
Documented proof of concepts to conducted benchmark tests for network
•
latency and network saturation using Oracle 9/10g Real Application
Clusters (RAC) and various Data Guard protection modes in relation to
recovery time objectives (RTO) and recovery point objectives (RPO)
Worked with management to document Software Development Lifecycle
•
(SDLC) methodologies with a primary focus on accountability/ownership,
governance, collaboration, business continuity, and corporate audit
2001 2005 STATE STREET CORPORATION Boston/Westwood, MA
Officer – Senior Database Administrator (Architecture)
Tasked as a senior database administrator supporting the Securities
•
Finance division and Deutsche Bank migration strategies
Responsibilities included 24/7 production support, logical and physical
•
design, selection of database software (utilities and solutions), data
placement, database creation and expansion, security, monitoring and
tuning system performance, troubleshooting, maintaining backup library’s,
research and development (R&D), and documentation
Assisted in standardizing and streamlining a smooth transition for
•
ongoing support for market database servers to enhance technology
solutions to help streamline operational processes
Primary technologies included Oracle 7, 8, 8i,9,10g (development),
•
Sybase 11.x/12.5, and MSSQL 6.5/2000
Assisted in architecting and migrating applications from the Deutsche
•
Bank acquisition into a high performance data warehouse totaling 2
terabytes of data using Oracle Real Application Cluster (RAC) with 5 year
growth projection of 10 terabytes
Provided 24/7 production support on a group level for over 900+ Sybase
•
servers, 400+ Oracle databases, and 100+ MSSQL Servers
Provided 24/7 production support on a team level for the largest
•
application in the company (2002) totaling 2.5 terabytes of data, spread
across 1 Oracle8i cluster and 50 Sybase servers
Worked with a team of 6 senior DBA’s on successfully migrating 44
•
Sybase servers totaling 2.5 terabytes of data to 1 Oracle9i database
instance on a fully loaded Sun E10k cluster concentrating on TCO,
fragmentation, and ease of management
Responsible for administering, maintaining, and upgrading over 100+
•
Oracle database instances (8 thru 9i) and 20+ MSSQL Servers (6.5 thru
8.0) across all environments (development, QA, UAT, and production)
Primary support for 20 Oracle database instances (8 thru 9i) and 7
•
MSSQL Server (6.5 thru 8.0)
Responsible for successfully architecting a corporate wide auditing
•
initiative for both Oracle and MSSQL Server to monitor
unauthorized/privileged access using stored procedures, BCP, DTS,
P ERL, and Shell while integrating the process into the open systems
security model
Acted as a lead DBA in the consolidation of the UNIX development
•
environment while concentrating on file management, and shared RDBMS
binaries
Acted as a lead DBA for company wide Windows 2000 consolidation
•
initiative
Performed proof of concept (POC) and documented disaster recovery and
•
failover strategies across all RDBMS platforms for direct report to the
Business Continuity Management (BCM) committee
Performed benchmark tests for in memory databases using Oracle9i
•
(SQL*Loader) and MySql
Performed benchmark tests comparing RMAN and SQL Backtrack
•
functionality
Developed and maintained all automated RDBMS maintenance scripts
•
using Shell, PERL, and stored procedures
Provided satellite production support for London, Sydney, and other
•
international locations
Worked with outsourcing steering committees for select DBA function
•
2004 EXTRAPRISE GROUP INC. Boston, MA
Senior Database Consultant/Architect
Tasked as a Lead DBA consultant for the world’s largest pharmaceutical
•
company (Pfizer) for outsourced Siebel hosting, data management, and
campaign management with co hosted data centers in Wakefield, MA and
Dallas, TX
Responsible for logical and physical design of the Siebel Marketing
•
(OLTP) and Analytics (OLAP) environments consisting of 6 oracle 9i
databases running on IBM pSeries 650’s using AIX5L and IBM Enterprise
Storage Servers
Responsible for 24/7 production support, database creation, upgrades,
•
security, monitoring system performance, disaster recovery,
documentation, and schema/data integration
Responsible for designing and documenting an infrastructure support
•
model that would be reusable for future clients using PERL and
Embarcadero
Lead DBA for the companies new service platform “Insight to Interaction”
•
(i2i), offering data management, business insight, demand generation,
and customer segmentation
1998 2000 NEOGENESIS Cambridge, MA
System Administrator/Website Designer
1998 2000 INTERLOCK MEDIA Cambridge, MA
Website Design Team Participant (Nonprofit/Volunteer)
Clearance
Secret
•
Education
S IEBEL UNIVERSITY Burlington, MA
3 week, instructor led, hands on training, April 2004
Siebel Core Consulting Course
•
CLARK UNIVERSITY Cambridge, MA
9 week, 365 hour, instructor led, hands on training, December 2000 February
2001
Microsoft Windows 2000 Administration Certification Program
•
ORACLE UNIVERSITY Boston, MA
Oracle 8i Database Administration
•
Oracle 9 Database Administration
•
Oracle 10g RAC
•
Oracle 11i E Business Suite Administration
•
HARVARD EXTENSION SCHOOL Cambridge, MA
Undergraduate Studies
Coursework: Applications for Managers, Communication Systems and
•
Technology, Advanced Information Technology Management, Information
Systems Management, and Computer Architecture Desktop
References
Available Upon Request
Contact this candidate