SUMMARY:

Key Decision Maker in Administering MS SQL Servers in Highly Transactional EnvironmentsHands - on and results-driven senior database administrator, design, and maintenance professional with more than 18 years’ experience with the highly-coveted blend of business savvy and database technical expertise. Proven ability to lead mission-critical must-win projects to implement supplementary database support and ancillary functionality. Well-versed in defining project direction towards improved team and client experience. Skilled at analyzing requirements and translating corporate business needs into comprehensive strategic road maps and implementation plans. Well-regarded for shedding the status quo and embracing fresh and alternative thinking to address complex business matters.

• Consistently promote strong relationships with vendors and partner organizations.
• Excellent reputation for clearly and effectively communicating to audiences from a variety of cultural, educational, and economic backgrounds.
• Robust history in delivering sophisticated projects to be on-time and within budget despite shifting priorities, demanding expectations, and stringent deadlines.
• Manage datasets upwards of 6 Petabytes of data, 500+ servers, 6000+ CPU cores, with over 600 million site members.

CORE COMPETENCIES:

• IT Strategic Planning & Leadership, Disaster Recovery, Environmental Performance Tuning, Vendor Relations, Staffing & Resource Management, Technology and Security Risk Assessment, Policy and Procedure Development
• Security Compliance (SOX, PCI, HIPPA), Budgeting and Cost Controls

PROFESSIONAL EXPERIENCE:

Confidential, El Segundo, CA

Director

• Lead global database operations in support of 300+ enterprise-level production databases to include stand-alone, clustered,
• virtualized, geographically dispersed environments encompassing e-commerce, business intelligence, reporting, human
• resources, warehouse distribution facilities (WMS-warehouse management systems), monitoring applications, and finance
• for JustFab.com, Shoedazzle.com, Fabkids.com, and Fabletics.com.
• Part of a large-scale layoff affecting over 30% of the company workforce.
• Maintained full compliance with Sarbanes-Oxley Act requirements and Payment Card Industry standards.
• Sustained a hybrid position, lead the Database Operations Team as well as acted as hands-on operational DBA.
• As a Senior DBA, planned and implemented proper backup/restore, High Availability (HA) and Disaster Recovery (DR) solutions for critical business systems. Analyzed emerging industry and database technology trends translating implications for new capabilities within functional and technology domains. Developed and maintained detailed documentation relating to procedures, processes and standards. Led efforts in code, database migration, and database change management. Provided production support in a 24x7 environment, including after hours and weekend support as required. Ran diagnostics as required and automated operational processes.
• Served as the environmental solution architect for all SQL OLTP & OLAP environments consisting of development, quality assurance, staging, and production systems within the database infrastructure to help support our business objectives. Designed database systems to support applications, ensuring system scalability, security, and performance and reliability.
• Owned and maintained all data storage appliances attached to all SQL environments including Dell Compellent, StorSimple, SOFS, Nimble, EMC, and Purestorage.
• Highly valued mentor and team leader providing staff with autonomy to deliver quality work while building strong interpersonal relationships to improve communication and advance business development efforts.

Confidential, Beverly Hills, CA

Senior Database Administrator

• Served as one of seven Database Administrators in charge of the production farm overseeing all replication, mirroring,
• service broker, performance, and maintenance processes. Performed heavy troubleshooting and maintenance, critical
• performance tuning, and all maintenance and architectural design of mission-critical systems to include the development
• environment, support, and monitoring of said systems.

Confidential

• Administered more than 6 petabytes of data distributed over 500+ enterprise class MS SQL 2005/2008R2 servers equating to 6,000+ CPU cores within the database farm containing 1,200+ databases and 1,000,000+ TPS.
• Manager of the SQL Development systems and creator of the company DevOps team, to include administration, maintenance, upgrading, migrations, troubleshooting, and partnering with database architects on developing new databases and performance tuning in the development, quality assurance, and staging environments.
• Redesigned the complete development environment; created, upgraded, and configured the SQL backend of the development environment, sandbox, staging, and quality assurance to mimic production farm, based on 500+ enterprise-level servers for all Confidential .

Confidential, Pasadena, CA

Database Manager

• Served as the Principal Senior SQL DBA, responsible for the administration, maintenance, monitoring, and point person for all
• MS SQL environments spanning production and DR systems encompassing all OLTP and OLAP SQL environments from two
• divisions and various Business Units geographically dispersed. The SQL database layer consisted of SQL 2000 and SQL 2005, with several active\active SQL 2005 clusters.
• In charge of consolidating Shared Services databases from end-of-life stand-alone hardware to SQL 2005 active\active clusters. Developed migration plans to provide a side-by-side upgrade to minimize the down time of each production database and sustain business continuity. Involved in the planning, spec design, and implementation with the divisions and Business Units, on various highly visible projects; developed and revised various requirement documents and system documentation through the life cycles of each project
• Managed four engineers composed of the Unix\Linux Team, Informix Database Administrator, and Cold Fusion\Web developer.
• Initiated a project to relocate the data layer by rebuilding all stand-alone SQL environments as a high availability SQL Cluster farm, secured from all internal and external threats within a newly built secured VLAN and DMZ.

Confidential, Santa Ana, CA

Senior SQL Database Administrator

• Responsible for consolidating new SQL environments from various Merger and Acquisition projects. Highly involved in the
• planning, spec design, development, and implementation with other key engineers responsible for the overall environment
• migration of e-commerce and data warehouse environments. Developed and revised various requirement documents and
• system documentation through the life cycles of each migration project.
• Primary DBA in Confidential ’s Corporate Data Consolidation project. Responsible for migrating over 150 SQL Servers from an old data center in Anaheim to Confidential ’s newly built Corporate Data Center in Santa Ana, CA.
• Through acquisitions, became the lead DBA over five developers, administrating two SQL data warehouse environments, along with multiple SQL 2000 and SQL 2005 Analysis Service environments. Principally utilized by various clients for reporting purposes through Excel, MicroStrategy, and Sybase IQ.
• Designed, implemented, and supported the company’s database Disaster Recovery strategy, which encompasses a dispersed geographical topography. Established a bi-directional DR plan that enabled either location, Santa Ana, Ca or Dallas, TX to become the Disaster Recovery site for numerous database environments. Utilized many of SQL’s native technologies, i.e. transactional and merge replication, along with log shipping, and SAN to SAN replication to establish the Disaster Recovery program.

Confidential, Newport Beach, CA

SQL Server Database Administrator

• Responsible for the support and administration of a large enterprise-wide SQL Server environment for 300+ database servers supporting several hundred databases within a variety of domains and DMZs. Administered all SQL 6.5, SQL 7, and SQL 2000 within all development, QA, staging, and production environments.