Sr. Sql Server Dba Resume
Summary:
- In a results-oriented career, have led cross-functional teams meeting budgetary bottom-lines and project deadlines, while handling multiple assignments and coordinating deliverables with sponsors and key stakeholders from multiple business units.
- Using a mentoring and creative problem-solving style that marries hands-on leadership with experience and communication to drive team focus toward unified strategies in databases solutions, application, and enterprise architecture, business intelligence, enterprise security, and data center operations.
- Technology Snapshot: Windows Server (00 thru 08 EE-DC ed.), MS SQL Server (6.0 thru 2K8), MS SQL Server Services (SSRS, SSIS, SSAS), Oracle (8i, 9i, 10g RAC - RMAN), MS Exchange (03, 07), Vertica (Data Warehouse), MS SharePoint (MOSS 2K3, 2K7 & WSS 2.0, 3.0), Virtualization (Hyper-V, VM Ware 3.0/3.5/4.0), MS Clustering (2K3, 2K8), MOM (2K5), Erwin, Toad (SQL, Oracle), WSUS, SCCM, SCOM, .NET (ASP, C#), OCS/LCS, TCP/IP, FTP, XML, IIS, DNS, DHCP, WINS, AD, DTS, HTTP, MSMQ,
Expertise:
- Extensive experience in Planning, Installing Windows Cluster Environments
- Extensive experience in ETL methodologies, Data Management, Enterprise Solutions, and SDLC
- Involved in Architecture, Design, Management, Support, Troubleshooting of SharePoint environment
- Experience in handling multi-terabyte OLTP, DR, Warehouse production environments
- Extensive experience in database administration, backup, recovery, performance and tuning.
- Extensive experience in planning and implementing SQL 2000 to 2005 to 2008 migrations, Oracle 8i to 10g upgrades
- Extensive experience in writing Stored Procedures, Triggers, queries, data mining (SSRS, SSAS, SSIS/DTS)
- Extensive experience in planning, configuring, maintaining and troubleshooting Transactional, Snapshot and Replication
- Good problem solving capabilities
Core Competencies/Accomplishments:
- 18+ years Database Administration/Development/Architecture
- 18+ years overall IT/infrastructure exp
- 11+ years Systems Administration
- 5+ years IT Management
- 8 + years Application Architecture/Development
- 5+ years VM Ware Architecture
- 8+ years Networking
- 12+ years Strategic IT Planning
- Six Sigma – Yellow Belt
- ITIL methodologies
- Microsoft White Paper/Case Study (completed, SharePoint)
Professional Experience
Confidential
Principle, VMware/Database Architect January 2010 – Present
- Architect and build VMware/SQL database environment.
Confidential. February 2004 – Nov 2009
Manager, Data Center Operations (Hands-on DBA/SA) March 2005 – Nov 2009
- 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).
- Re-Architected Frequent-Flyer clustered database environment for HA and improved performance.
- Support and maintain High Availability SQL Server Clustering running in SAN environments for the corporate Intranet.
- Daily Monitoring of SQL Server, Application Logs, Database Performance and network issues.
- Built Marketing Sandbox to replicate with SQL databases for data mining summary data (BI).
- Built new Maintenance environment: migrated Oracle 8i to 10g-RAC, employing RMAN backup, on Dell servers and EMC SAN (Fibre Channel).
- Running Performance and Index tuning wizard in association with troubleshooting e-commerce, web services, and OO developed Applications.
- Carried the responsibilities for daily database operations, security administration, object administration, and capacity planning of SQL Server database environments
- Owner of the capacity planning for both Virtual and Physical server environments, while remaining hands-on in the physical management of IBM & EMC SAN.
- Developed BI solutions that integrated SharePoint, SS Analysis Services, SS Reporting Services, SS Integration Services and Dashboards for enterprise consumption.
- Architected virtualized MS Hyper-V (Server2K8) and VM Ware for Application and Database life cycle environments: Development, testing, Q/A, Staging and Production.
- Monitor SQL Server logs, fragmentation, statistics and event notifications for trouble shooting.
- 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.
- Architected SharePoint 2K7, intra- and extranet portals. Entire environment built on Server 2008, SQL 2K5 (A/A Cluster), SRS 2K5, IAG, Exchange 2K7, on ESX Virtual Machines – managed, supported, developed web parts, coordinated reporting, integrated Active Directory (security) – Microsoft wrote Case Study on SharePoint Environment (“ShareTran”)
- Increased security presence with initiatives involving Tripwire (security control), HIPS (host intrusion protection), Stealthwatch (client activity monitoring), SCOM/SCCM/MOM (enterprise monitoring), In-Trust (e-mail watch-dog), and McAfee (virus protection), which standardized SOX (Sarbanes-Oxley) and PCI compliancy (Credit Card transaction).
- 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.
- Large Scale initiatives included: AD/GP clean-up; SAN migration from Clariion to CX3-80; DR re-architecture; NAS replacement; HA Exchange 2K3 migration to 2K7 (6,500 users), BES upgrade; Patch Management (WSUS/SCCM) re-Architecture; Enterprise Backup migration from Tape to Electronic; SQL database conversion (environment-wide 2K to 2K5/2K8); assist deployment of CISCO IPCC strategy – all core components fundamental for positive IT/corp. growth.
Confidential February 2004 – March 2005
Sr. SQL Server DBA
- 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.
- Set up, monitor, and support ETL encryption process for credit card transactions and PCI compliance.
- Set up and monitored SQL Server maintenance and alerts.
- Monitored for failed and long running SQL Server jobs as well as database sizing and disk storage usages.
- Monitored, analyzed, and tuned SQL Server database performance and utilization and allocated server resources to achieve optimum database performance using self-developed SQL scripts, Groundwork, Profiler, Dynamic Management Views and Windows Performance Monitor.
- Performed backups, restores, performance tuning, stored procedure writing and tuning, capacity planning, disaster recovery planning, data conversions, data imports/exports, and system upgrades.
- 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. Built Vertical/Oracle 11g Data Warehouse solution for forecast reporting and Data Modeling.
Confidential. October 2002 – February 2004
Principal Consultant
- Monitoring SQL Server logins, logs, activities, connectivity, blocking, SQL Server Agent jobs, database and server performance, and database space and disk space usages using home-grown scripts and Quest Spotlight. Backup and recovery using native backup and SQL-BackTrack. Trouble shooting related database issues.
- 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.
- Database design, development, implementation and administration using Enterprise Manager, Query Analyzer, Transact-SQL, stored procedures, functions, triggers, DTS packages, etc.
Confidential May 2000 – October 2002
Sr. DBA II
- Develop 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;
- Architect and Model (Physical and Logical) database layouts for Production release, Backup plans, SQL Security;
- Install, maintain, and upgrade the following products: SQL Server Enterprise Edition Product Suite, Analysis Services (SSAS), Data Transformation Svc (DTS), and Reporting Services (SSRS).
- Monitoring SQL server, Application logs and analyzing the logs.
- Designed and developed a STAR schema for a Business Intelligence project; developed SSIS packages to extract, transform, and load data from the various OLTP system environments to the data warehouse.
Confidential March 1999 – May 2000
Technical Consultant
- 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 December 1998 - March 1999
SQL Server DBA
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- Columbus, OH December 1994 – November 1998
Data Center Manager / Database Administrator
- 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 ETL 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 object-oriented Developer of VB/SQL client-server applications.
Technical Skills:
Network, 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, 2K8r2), 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), WSUS/SCCM, ISA (2K4, 2K6), IAG/UAG, MQSeries, TCPIP, DNS, DHCP, FTP, IIS
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), IIS (1.0, 2.0, 3.0), 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), Shell Scripting
HW/SAN: Dell (Servers/Blades/Switches), IBM (Servers, Blades, SAN), EMC SAN (FC4700, CX3-80, Symmetrix, Clariion), NetApp, CISCO (routers, switches), APC (Symmetra 80k, SmartUps), HP DL100 (NAS), Barracuda Load Balancer/Spam Filter (400, 600, 1000 series), Brocade (Fibre switches), Data Domain (backup), Dell DLT Tape, Proteus (DNS appliance).
Education:
Management Information Systems)
Marketing