BA / Software & Services Manager Resume Gaithersburg,MD - Hire IT People

SUMMARY:

MS SQL Server database administration (DBA) web application and database development requirements gathering process improvement project management technical writing consulting

TECHNICAL SKILLS:

Operating Systems: Windows Server 2003, 2008 R2

Databases: MS SQL Server 2000 - 2008 R2 (standard editions), MS Access

Languages: SQL, T-SQL, ASP, VBA, ColdFusion, JavaScript, win32 batch, HTML, XML, CSS

Tools: SSMS (2005, 10), VS (2008, 10), VSS, Crystal Reports, NewRelic, CompareDB, PerfMon, Visio

PROFESSIONAL EXPERIENCE:

DBA / Software & Services Manager

Confidential,Gaithersburg,MD

Responsibilities:

Confidential is a fast-paced, niche CRM software company that serves the association industry and a handful of Fortune 100 clients. I was the de facto DBA since 2004, responsible for security, recovery, performance, and high availability for the 250+ production databases (instances up to 200 GB) that spanned a dozen web applications and a handful of physical locations. The databases were primarily OLTP, with some warehousing and OLAP. A few recent achievements include:
Led the transformation of OMNI’s software to mature SaaS model to reduce risks and operational costs. Major projects included: redesign the software’s data model for multi-tenancy, migrate client data to new schema, designed new db server architecture (disk/files layout, RAID, etc), and plan and assist hosting facility migration
As DBA, delivered 99.9+% uptime, secure data, and DR best practices. Also optimized queries, monitored logs, performed backup/restores, planned and tested recovery
Led 8-person Technology & Services team: managed projects, gathered requirements, analyzed designs and plans, resolved escalated issues, developed database and software components, defined roadmaps

DBA / Application Developer

Confidential,Gaithersburg,MD

Responsibilities:

As DBA for 250+ SQL Server databases, monitored logs, optimized queries, performed backup/restores, planned and tested recovery upgraded SQL Server, from 2000 to 2008R, using SQL Server upgrade advisor; resolve issues prior migrated 250+ production databases and users as part of a hardware & OS upgrade
Developed 100+ complex reports using SQL and various reporting packages (Crystal, CF, etc.)
Designed and developed 20+ complex data ETLs
Designed and developed three data warehouses, including schema, loaders, UI, and reports
Developed hundreds of features for software applications using ColdFusion, SQL, JS, HTML, and XML.
Led hundreds of requirements discovery sessions with internal and external client executives

Access Database Administrator & Interactive Media Developer

Confidential,Ashburn,VA

Responsibilities:

Designed, built, and administered MS Access databases: projects, contacts, partner deals, products, ads
Led analysis efforts in process improvement projects: rebate promotions, monthly reporting for new member registration, welcome screen popup activity
Developed AOLTV site templates and a TV channel guide using a subset of HTML3 and JavaScript1