SUMMARY:

• An IT and data professional, most recently employed as a Senior Database Administrator where my core areas of focus included management of Microsoft SQL Servers, SQL RDS, HP Vertica and MongoDB clusters.
• Some recent project highlights include; working to implement Always - On for Tier 1 applications, on-prem to cloud migrations into EC2 and RDS platforms, building out SQL Reporting Services, deploying monitoring and proactive alerting solutions to reduce ticket volumes, database and solutions design reviews, supporting server patching and upgrades, system design and builds.
• I enjoy working closely with internal business partners, customers and colleagues to design, deliver and support technical solutions that meet business requirements and provide real world value.

APPLICATIONS AND TECHNOLOGIES:

SQL Sentry, Solarwinds, TOAD, Redgate SQL Toolbelt, Oracle SQL Developer, T-SQL, PL-SQL, ASP.Net, VB.Net, C#, CA Workload Automation, PowerShell, Tableau.

PROFESSIONAL EXPERIENCE:

Senior Database Administrator

Confidential

Responsibilities:

• Managed day to day operational support for databases on SQL Server 2000 thru 2016. Responsible for the monitoring and management of databases, backups, server builds, patching, leading data restore, and recovery efforts as required, ensuring backups are functioning and that recovery processes are documented and tested regularly.
• Designed and managed database solutions to meet enterprise High Availability and DR requirements.
• Built and configured SQL Servers, including the installation and validation of security patches and service packs. Wrote, maintained and optimized PowerShell scripts library to leverage in dba task process automation, maintenance and health checks.
• Partnered with DevOps and Cloud Engineering teams to support various design, automation and cloud migration initiatives. Projects included migrating on-premise SQL to SQL Server on Amazon EC2 instances as well as data migration to SQL on RDS.
• Managed and extended reporting dashboard functionality and designed and deployed new SSRS reports.

Senior Infrastructure Architect

Confidential

Responsibilities:

• Served as a senior Microsoft SQL server database escalation point for all aspects of the enterprise database systems including configuration, backup/restore, high availability and disaster recovery.
• Provided support for teams in developing, testing, debugging and deploying SSIS packages, SSRS reports and SSAS cubes.
• Managed SQL, Oracle and HP Vertica Analytic Database environments.
• Created and maintain database documentation, standards and policies.

Senior DBA Analyst

Confidential

Responsibilities:

• Served as the senior technical subject matter expert for all aspects of the 300+ global database systems.
• Provided guidance/oversight to contractors regarding priorities, standards and managed vendor relationships.
• Monitored and managed databases, backups, log files and archives, new installation, maintenance and upgrades, and led data restore and recovery efforts as required.
• Collaborated with Management and other business unit leaders to define policies and provide regional guidance for implementation of compliance policies, including SOX and Security.

Senior Database Developer

Confidential

Responsibilities:

• Designed, and deployed T-SQL stored procedures, functions and ETL components in support of new software feature development.
• Participated in technical design and provided guidance as an individual contributor on an Agile application development team.
• Managed and deployed reports, schema changes and database refreshes into development, testing and production environments.
• Provided technical leadership and, as Technical Lead on the Production Support team.
• Monitored, troubleshooted and resolved system performance issues on web, application and database tiers.

Database Systems Manager

Confidential

Responsibilities:

• Initially hired as a Business Systems Analyst and promoted to Database Systems Manager.
• Managed Oracle 9i/10g and SQL Server databases, including users, security, storage, backup and recovery.
• Led design and project management efforts for software and tool development projects for the IT department.
• Mentored, trained, hired and managed application development, application support, GIS and database teams.
• Developed and documented best practices and database management procedures for the enterprise.
• Developed budgets, application road maps and system support plans.
• Supported enterprise applications and database systems for our customers in the Construction, Private Equity, Finance, Oil & Gas, Government, Health and Safety, and Utilities business focus areas.

Technical Team Lead

Confidential

Responsibilities:

• Managed new software rollout and upgrade project teams.
• Compiled and presented trend analysis and weekly metrics reports to management and customers.
• Resolved escalated support issues in conjunction with Testing and Development special teams.
• Performed system configuration and database recovery as part of disaster recovery process.
• Worked with developers to troubleshoot and apply SQL scripts to patch and upgrade servers.
• Mentored and trained Tier 1 and 2 technicians as well as new hires.