Systems Administrators, Dba Resume
UsA
Highly accomplished, IT Executive who has successfully leveraged staff, and resources, to push boundaries in technology, while keeping an eye on capital expense and customer needs. In a 19+ year results-oriented career, have led cross-functional teams meeting budgetary bottom-lines and project deadlines, while managing multiple assignments and coordinating deliverables with sponsors and key stakeholders from multiple business units.
Using a mentoring and creative problem-solving management style that marries hands-on leadership with experience and communication to drive team focus toward unified customer strategies in capacity planning, database, application, and enterprise architecture, business intelligence, enterprise security, and data center operations.
Technology Snapshot: MS SQL Server (6.0 thru 2K8), Oracle (8i, 9i, 10g RAC), RHEL (4.0, 5.0), Vertica (Data Warehouse), MS Reporting Services (SSRS - 2K, 2K3, 2K5), MS SharePoint (MOSS 2K3, 2K7 & WSS 2.0, 3.0), Virtualization (Hyper-V, VM Ware 3.0, 3.5), MS Clustering (2K, 2K3, 2K8), MOM (2K5), SCCM/SCOM, .NET (ASP, C##), Tomcat, TCP/IP, XML, IIS, DNS, DHCP, WINS, FTP, DTS, SSIS
CORE COMPETENCIES/ACCOMPLISHMENTS
18+ years Database Administration/Development/Architecture 18+ years overall IT/infrastructure exp
11 + years Enterprise Solutions Architecture 5+ years IT Management
11+ years Systems Administration 5+ years VM Ware Architecture
8+ years Networking 12+ years Strategic IT Planning
Six Sigma Yellow Belt ITIL methodologies
Microsoft White Paper/Case Study (SharePoint)
PROFESSIONAL EXPERIENCE
Confidential,
(Publicly-Held (NYSE(AAI) Transportation); Airline Industry; Fortune 1000 company with $2.3B in total revenues)
Create a new foundation of organization, procedure, best practices, SLA standards, and resource management in a 24x7 environment. Be escalation hub for executive, senior management and staff on emergency issues and resolutions. Work directly with corporate vendors and business units to ensure new technologies meet common goals. Maintain ownership of all AirTran technologies, while managing a staff of 12 comprised of Systems Administrators, DBA’s, and Hardware specialist, and 4 data centers (ATL, MCO, SAV, and ATR).
- Owner of $8 million budget that includes hardware, software licensing, staff and data center operations.
- Owner of the capacity planning for both Virtual and Physical server environments, while remaining hands-on in the physical management of IBM & EMC SAN.
- Manage Microsoft EA and 3rd party vendors relationships - from licensing and SLA, to negotiations and terms
- Architected SharePoint 2K7, intra- and extranet portal solution. Entire environment built on Server 2008, SQL 2K5, SRS 2K5, IAG, Exchange 2K7, on clustered Virtual Machines Infrastructure created DR solution for station operations that can be entirely run from a laptop, offers greater communication among departments, and expands information/document sharing, while emphasizing VPN elimination, HA stability and an ROI over $100K --- Microsoft wrote Case Study on SharePoint Environment (“ShareTran”)
- Created SharePoint Global Knowledgebase for Sys Admins, Field Service, Networking, and Help Desk as part of ShareTran streamlining trouble ticket resolution, asset management, and increased SLA standards.
- Recommended and architected strategic move to data center virtualization. Converting 750 physical servers, into 20 farmed environments, on 109 servers, while enhancing our HA, DR, and backup strategies.
- Architected virtualized MS Hyper-V (Server2K8) and VM Ware lifecycle environments: Development, testing, Q/A, Staging and Production ASP/.NET infrastructures.
- Increased security presence with initiatives involving Tripwire (security control), HIPS (host intrusion protection), Stealthwatch (client activity monitoring), SCOM/SCCM/MOM (enterprise monitoring), ISA/IAG/UAG (VPN alternative), In-Trust (e-mail watch-dog), and McAfee (virus protection), which standardized SOX (Sarbanes-Oxley) and PCI compliancy (Credit Card transaction).
- Architected and Implemented new physical environments for core operations (IT, Financial and Industry centric applications: decision maker from equipment recommendation, to the hands-on physical build of environments).
- Architected ERP solution linking Great Plains (Financials, HR), ADP eTime (HR, Payroll), and TRAX (Aircraft Maintenance, Inventory) allowing for improved resource planning and streamlined operations.
- Large Scale initiatives included: AD/GP clean-up; SAN migration from Clariion to CX3-80; DR re-architecture; NAS replacement; HA Exchange 2K3, Implement OWA access; BES upgrade; Anti-virus conversion; Enterprise Backup migration from Tape to Electronic; SQL database conversion (environment-wide 2K to 2K5/2K8); created scorecard metrics for staff measurement; assist deployment of CISCO IPCC strategy all core components fundamental for positive IT/corp. growth.
The goals set forth were simple protect AirTran Airways most precious asset: Data. Was the decision maker on all database initiatives ranging from OLTP architecture to database optimization, ETL and Architecture.
- Built Vertica/Oracle 11g Data Warehouse solution for forecast reporting and Data Modeling.
- Interact with Web/Intranet Developers on web services and internal application builds for ad-hoc and customer-facing (data exchanged) applications.
- Built and implemented Reporting Services (2K3 and 2K5, Analysis Services) and SharePoint Test & Production Environments (2K3 and 2K7), ad-hoc tools to capture reporting elements built in .NET, C# and HTML
- Implement Active/Active & Active/Passive Database Environments (Win 00/03/08 Servers & SQL 2K/2K5/2K8).
- Developed complex DTS and SSIS SQL data conversions in concert with stored procedures, triggers and indexes (clustered/non) to integrate 3rd party, FAA, and Manufacturing data.
- Upgraded Oracle 8i to 10g RAC for mission critical Maintenance Program.
- Aid in System Administration problem solving when emergency issues require assistance, established MOM environment for monitoring, SharePoint environment for dashboard results.
Confidential,
(Privately-Held; Formed out of a need for customized client-server auditing application with an emphasis on database design; Application development led to absorption of customer into AIG)
IT Specialist for Construction Auditing Firm.
- Developed application (VB/SQL) for calculating and tracking multi-million dollar audits of default construction companies. Emphasis had to be put on the db design (SQL2K) as this aided financial analysis.
Confidential,
(Privately-Held; 2b2/e-commerce dot-com start-up; spawned an entire industry shift in the Insurance web-space) Sr DBA II May 2000 October 2002Develop and implement strategic SQL operations to increase Web Site availability, speed and data security:
- Responsible for DBA functions involving development (TSQL, triggers, SP, Profiler).
- Handled strategic planning of database operations and OLTP data mart.
- Created and automated ELT imports (ASP, DTS, BCP data pumps) of carrier data for quoting, rating and retrieving purposes, from multiple health insurance carriers;
- Develop complex TSQL procedures for Production and Development, Web Applications and Reporting, thus created health insurance rating engine;
- Implemented Data Warehouse solution in SQL via Analysis Services, Business Objects and OLAP reporting;
- Architect and Model (Physical and Logical) database layouts for Production release, Backup plans, SQL Security;
Confidential,
(Publicly-Held (NYSE(MCK) Biotechnology & Drugs); International Market Share holder in Healthcare IT; First company to offer electronic medical file conversion; $101 total revenue.)
Technical Advisor - Imaging Solutions Group, March 1999 May 2000.
Project Manage implementations for the Hospital centric LaserArc and PIM4.0 software product lines, nationally and internationally:
- Pre/Post-sales engineering (client network/HW assessment / Implementation)
- Install, configure and customize stored procedures (SQL) and VB applications per client site needs
- Analyze and Resolve database requirements before implementation and provide client support (24 x 7)
- Establish download processes for HOST systems on either SQL or Oracle databases (via Unix scripting or BCP)
- Tutor/Train clients on application management and use (all levels of users, per back-end db SQL 6.5 or Oracle 8i Server)
Confidential,
(Privately-Held; b2b dot-com startup; innovators to pay-per-event IT customer support for small business and private contracts; at its peak, saw revenues of $12.7M)
Contract DBA, December 1998 - March 1999.
Carry out standard DBA and Network Engineer functions for client customers. Primary client was YUSA, INC. (Japanese manufacturer of rubber hoses and rings for Honda) and oversaw mid-size medical practices.
Projects included:
- Lead DBA specialist, SQL database/server Projects Installs (8), Troubleshoot (10+), Architect/Implement Data Warehouse (5), Oracle builds (6) / migrations (4), Integrations AS400 (2)
- Product life-cycle builds - (3) SQL Server/NT clustered environments (2-Active/Passive, 1-Active/Active);
- Other responsibilities included Analyze data of database reliability per Customer needs, Emergency 24/7 Support, implement Best Practices, data modeling (ERWin), and assist with in-house Network Engineering.
Confidential,
(Privately-Held; was sold to COM-ED in December 1995, would eventually be sold 4 times; Innovator of home energy consumption reporting)
Data Center Manager / Database Administrator - Columbus, OH, December 1994 November 1998
Build and Manage the network operations for 3 24-hour Call-Centers with 150 CSR, 15 management and 20 administrative workstations, in a Client/Server environment. Managed staff of 5 System Administrators and maintained hands-on responsibilities that included:
- Decision maker on systems, personnel, strategy and direction for Call Center Technologies, of which presented to Executive teams;
- Provide Exec. Management with capacity planning, cost, and project statuses of Call Center Operations;
- Perform ELT migrations, conversions and create SP’s on SQL databases (ver. 6.5 and 7.0);
- Architect, Model, Implement SQL Server databases, in a Call-Center Application environment;
- Data Mining of SQL databases with Crystal Reports (OLAP) analytical reporting for all departments;
- Implemented Active/Passive Cluster for call-center production databases;
- Responsible for site Replication with Corporate office and storage solutions for those offices;
- Managed the Columbus, OH, Atlanta, West Nyack, NY and Chicago Call-Centers - IT operations;
- Execute all Network/Database/Software/Hardware related functions for maintaining operations;
- Up to this point in my career had been an object-oriented Developer of VB/SQL client-server applications.
DB & Server OS: Windows Server (3.11, 4.0, 2K, 2K3, 2K8), MS Virtual Server (05r2) & PC (04, 07), VM Ware Ent. (3.0, 3.5), Red Hat Linux (7), MS SQL Server (6.0, 6.5, 7.0, 2K, 2K5, 2K8 RC1), Oracle (8i, 9i, 10g RAC), MS Great Plains (7.0, 8.0, 9.0), MS Reporting Services (SRS - 2K, 2K3, 2K5), Vertica (Data Warehouse), MS SharePoint (MOSS 2K3, 2K7 & WSS 2.0, 3.0), MS Systems Center Manager, ISA (2K4, 2K6), MQSeries,
Applications, Languages & S/W: Microsoft Virtual Server and PC (2K5, 2K7), XML, SourceSafe, Visual Studio.NET (2K, 2K3, 2K5 VB, ASP.NET 2.0, C##), MS Exchange (5.5, 2K3, 2K7), VISIO, Microsoft Project (v4.1, 98, 2K, 2K3, 2K7), MS Prof. Office Suite (XP, 2K3, 2K7), InfoPath 2K7, ERWin, Business Objects, Red Gate, Office Communications Server (LCS2K3, OCS2K7), BusinessObjects 5, Paradox (3.5, 4.0, 4.5, 5.0, 7.0), MS Operations Manager (2K, 2K5), MS Access (95, 98, XP, 2K, 2K3 and 2K7), FTP, IIS, HIPS (McAfee), SolarWinds, Stealthwatch, SecureFusion, In-Trust (Quest), SpotLight (Quest), Veritas/Symantec BackupExec, NetBackup (5, 6.0, 6.5), Virus Protection (McAfee and MS ForeFront), Tripwire (security management tool), TOAD (Oracle, SQL), SpotLight (Quest), MS LiveMeeting, OpenManage (DELL), PowerPath(EMC), AMM (IBM),
Network/HW/SAN: Dell (Servers/Blades/Switches), IBM (Servers, Blades, SAN), EMC CX3-80 (SAN), NetApp, Clariion (SAN), CISCO (routers, switches), APC (Symmetra 80k, SmartUps), HP DL100 (NAS), Barracuda Load Balancer/Spam Filter (400, 600, 1000 series), Brocade (switches), Data Domain (440-series), Proteus (DNS appliance), TCPIP, DNS (MS, Proteus), DHCP, Active Directory,
Preparing for Microsoft Certified Architect-Infrastructure certification.
EDUCATION: Confidential