SUMMARY:

• 20+ years with 1 TB SQL Database Server architecture, design, modeling, development, testing and administration.
• Compliance Subject Matter Expert committed to the enforcement of regulatory and internal control requirements.
• Thought Leader that curates longterm business strategy based on emerging technological trends and capabilities.
• Detail - oriented Project Manager that audits architecture, design choices, and roadmaps for their practical application.
• Active Member of the Architect/Design Community that successfully leverages engagement of partner organizations.
• Dependable Team Player that demonstrates a willingness to collaborate, innovate, and remain versatile.

EXPERTISE AREA:

• System Management
• Capacity Planning
• Disk Space Management
• Data Management
• Security Management
• Backup & Recovery Protocols
• Sensitive Information Encryption
• Storage & Capacity Management
• Process & Design Standardization
• Performance Engineering & Testing
• Enterprise Architecture Governance
• System & Code Migration
• Strategy & Roadmap Development
• Data Modeling & Normalization
• Stakeholder Communication

TECHNICAL EXPERIENCE:

Operating System: Windows 2012 / 2008 / Vista / XP / 2003 / 2000 / NT / 4.0 / 5.0 / 98 / 95.

Database: SQL Server 2017/2016 / 2014 / 2012 / 2012 R2 / 2008R 2 / 2005 / 2000 / 7.0 / 6.5.

Software Tools: Idera Diagnostic Manager Monitoring Tool, Visio, PDF Merger, Acrobat Pro DC, Confidential One, ClosingMarket, Complete Closing Enterprise, CDF (Cumulative Disclosure Form), SQL Safe, Skynet, IE7, Oracle Products, Clarity, Tidal, Backup Exec, Erwin, ER Studio and Microsoft Office Suite.

PROFESSIONAL EXPERIENCE:

Senior DBA / Senior Data Architect

Confidential, Irving, TX

Responsibilities:

• Generates reports/emails outlining daily failed jobs, daily backups failed, low disk space alerts, and other key stats.
• Performs on-call DBA support and real time crisis management on a rotation basis, providing full-service excellence.
• Accountable for ER diagrams, data transformations, normalization, and modeling (both logical and physical) using Visio.
• Writes scripts to BCP the flat file to and from SQL Server; uses VSS to retain versions of stored procedures and functions.
• Writes complex reports using SQL Server Reporting Services (SSRS), and data transformations using SSIS.
• Tests SQL Server features such as piece meal restore, snapshot features, mirroring features, fast recovery, online index operations, and transact SQL enhancements like nvarcharMax, ntextMax, etc.
• Leverages Data Transformation Services (DTS) and SSIS for data conversion from external databases like Oracle to SQL.
• Spearheaded longterm planning for data and analytics organizations that offer competitive and/or differentiated solutions informed by market research and a comprehensive assessment of the competitive landscape.

Senior SQL Server DBA

Confidential, Plano, TX

Responsibilities:

• Generates reports/emails outlining daily failed jobs, daily backups failed, low disk space alerts, and other key stats.
• Performs on-call DBA support and real time crisis management on a rotation basis, providing full-service excellence.
• Accountable for ER diagrams, data transformations, normalization, and modeling (both logical and physical) using Visio.
• Writes scripts to BCP the flat file to and from SQL Server; uses VSS to retain versions of stored procedures and functions.
• Writes complex reports using SQL Server Reporting Services (SSRS), and data transformations using SSIS.
• Tests SQL Server features such as piece meal restore, snapshot features, mirroring features, fast recovery, online index operations, and transact SQL enhancements like nvarcharMax, ntextMax, etc.
• Leverages Data Transformation Services (DTS) and SSIS for data conversion from external databases like Oracle to SQL.
• Spearheaded longterm planning for data and analytics organizations that offer competitive and/or differentiated solutions informed by market research and a comprehensive assessment of the competitive landscape.

Confidential, Grapevine, TX

Responsibilities:

• Monitors servers, database backups, capacity management and trending for Software as a Service (SaaS) team (OP2).
• Common maintenance responsibilities include reindexing, CheckDB, updating statistics for SaaS Servers, security patching, exclusion of .mdf and .ldf files from Security Scans, and disk defragmentation.
• Implements weekly PROD change requests using Track IT and ChangeMan Systems; uses Backup Exec for tape backups.
• Works closely with operations and basis (engineering) team to maximize server time and proactively foresee issues.
• Provides evaluations and recommendations for all aspects of data architecture: data, hardware, application design, etc.
• Deploys SQL Server High Availability solutions in Synchronous Automatic Fail Over and Asynchronous Mode using database mirroring and replication; implements Red-Gate backups for full/transactional/log backup models in PROD.
• Develops strategies for data acquisitions and archive recovery; troubleshoots customer issues from software products.
• Generates logins and provides sensitive authentication information to developers; securely stores data in Password Vault .
• Handles change management and work orders using Clarity; uses Tidal to schedule and manage all SQL and Batch jobs.

Senior Database Architect/Administrator

Confidential

Responsibilities:

• Monitors servers, database backups, capacity management and trending for Software as a Service (SaaS) team (OP2).
• Common maintenance responsibilities include reindexing, CheckDB, updating statistics for SaaS Servers, security patching, exclusion of .mdf and .ldf files from Security Scans, and disk defragmentation.
• Implements weekly PROD change requests using Track IT and ChangeMan Systems; uses Backup Exec for tape backups.
• Works closely with operations and basis (engineering) team to maximize server time and proactively foresee issues.
• Provides evaluations and recommendations for all aspects of data architecture: data, hardware, application design, etc.
• Deploys SQL Server High Availability solutions in Synchronous Automatic Fail Over and Asynchronous Mode using database mirroring and replication; implements Red-Gate backups for full/transactional/log backup models in PROD.
• Develops strategies for data acquisitions and archive recovery; troubleshoots customer issues from software products.
• Generates logins and provides sensitive authentication information to developers; securely stores data in Password Vault .
• Handles change management and work orders using Clarity; uses Tidal to schedule and manage all SQL and Batch jobs.