SUMMARY

• I am an accomplished Information Systems professional with over 20 years of diverse experience across the design, build, installation, development, analysis, troubleshooting, Database/Windows administration, testing and recovery of complex IT systems.

TECHNICAL SKILLS

• SQL Server Design/ Implementation - Installation/Configuration/ Administration/Upgrades/Migrations 2000- 2017 Always on Availability Group / Clustering
• Database design (logical/physical)
• Performance Tuning and Optimization (PTO)
• Backup/Recovery Operations
• Collaborate with Dev teams on projects and deploys
• Application development T-SQL/ ETL/ DTS/ SSIS/ SSRS/ SSAS
• Scripts/DMV/Perf Mon/Profiler and third-party tools to troubleshoot and monitor performance and issues
• VMWare vCenter and Linux experience
• DevOps/ Agile/ Ansible / some AWS/ Datawarehouse /OLTP / OLAP
• Storage capacity planning for servers
• Disaster recovery design and testing (Mirroring, Replication, AOAG, Log Shipping, Distributed Databases, BCP)
• Change/Release Management
• PCI/SOX/HIPPA compliance/ TLS upgrades experience
• CA/PKI admin
• PCI Audit experience
• Windows System Admin knowledge and experience
• Power Shell/VB scripting
• Project management and supervisory experience
• Application Load balancing
• Patching Servers/ Decom-Cold Storage
• Reporting - Crystal Reports - Tableau
• Programming and design skills
• Solarwinds (Orion/DPA), Dynatrace, ExtraHop, Rapid7, Wireshark, Nessus, Zenmap
• Database, Windows Active Directory and Network security
• Work with business units on projects
• Excellent verbal and written skills - ability to convert technical language into business language and vice versa

PROFESSIONAL EXPERIENCE

Confidential - Phoenix, AZ

Sr. Database Administrator

Responsibilities:

• Design, configuration, implementation and administration of SQL Servers (Production, Test & Dev) (SQL 2008 - 2016) - All aspects of SQL Server maintenance
• Plan, design, configure, security, testing, troubleshooting, maintenance, optimization and support of database servers (SSIS, SSAS, SSRS)
• Work with developer groups to deploy projects to Test and Production using Wherescape and SQL - regression, UAT, troubleshooting
• Troubleshoot, backup and maintain server health and performance
• Write and troubleshoot T-SQL code/perform code reviews for developers - including ETL procedures (SSIS, sFTP, etc.)
• Design Disaster Recovery and testing
• Creating AD security groups and maintaining user access

Confidential - Phoenix, AZ

Lead Database Engineer (Administrator)

Responsibilities:

• Enterprise design, configuration, implementation and administration of over 300 SQL Servers (Production, QA & Dev) (SQL 2k - 2016) and 50 Oracle databases. Some exposure to Azure.
• Team Lead and architect for Oracle and SQL DBA team
• Level 3 Engineer responsible for all triaging, managing and/or working escalated SQL and Oracle issues
• Work with other ICS Engineers to maintain high up-times on servers and build reliable solutions for the enterprise
• Plan, design, configure, security, testing, troubleshooting, maintenance, optimization and support of database servers (SSIS, SSAS, SSRS)
• Write and troubleshoot T-SQL code/perform code reviews for developers - including ETL procedures (SSIS, etc.)
• Server/database health (DMVs, Extended Events, T-SQL Scripts, PowerShell, etc.) for performance, storage, etc.
• Working with other engineers to transition to Ansible for database resource management
• Provide support and mentoring/training to other DBAs for SQL and Oracle environments
• Design, build, test and manage backup and recovery solutions of servers - restore as needed
• Upgrade/Migrate SQL versions prior to 2012 to 2016
• Experience with Always On/Availability Groups, Clustering
• Work with Kafka, Grafana to design data repository for on-demand data
• Plan, design and test BCP/DR solution for SQL/Oracle/Mainframe environments
• Design overall monitoring solution for production environments – train Level 1 and Level 2 operations support personnel
• Update existing data structures as needed through re-design of SQL models and creating new architectural models as needed
• Control security and auditing to servers and databases with Always Encrypted, obfuscation, firewalls, auditing, limited views, etc.
• Plan and develop enterprise policies and procedures to all developers/end-users in relation to database standards
• Strong PCI Auditing experience
• Patching servers as required
• Work with DevOps group for projects, outages, best practices, deploys, UAT, regression testing, growth potential, restructuring, etc.

Confidential – Phoenix, AZ

Sr. Developer

Responsibilities:

• Oracle development – tables, packages, functions, stored procedures, objects, types, etc.
• TK/TCL programming
• Writing batch jobs for production deployment
• SQL development
• Add new and edit existing code for system upgrades
• Troubleshoot production errors and fix

Confidential – Scottsdale, AZ

Advisor, Systems (Database)

Responsibilities:

• Performance tuned and optimized servers for Dev, QA and Prod
• Designs, develops, maintains, troubleshoots, analyzes, and manages SQL databases and web applications.
• Lead administrator for SQL and Windows (SSIS, SSAS, SSRS)
• Lead administrator for web reporting platform for federal CMS programs
• Responsible for disaster recovery operations
• Production support for SQL/Oracle/Teradata operations
• Coded migration from multiple platforms to single platform for reporting
• Streamlined reporting processes and converted obsolete code to new platform and improved processing – some Tableau
• Successfully migrated Win 2003 to Win 2008/2012 and Physical to Virtual conversions as well as SQL 2005 to SQL 2008 and 2008 to 2012 conversions.
• Automated many manual processes using VBScript/batch files/PowerShell scripts/ and SSIS
• Served as project manager and developer/administrator for dozens of small to large projects
• Designed, documented and executed maintenance procedures, including system upgrades, patch management and system backups.
• Assisted with migration of data from Oracle to SQL as well as another SQL to Teradata
• Provided senior technical support to both in-house staff and user departments for all in-house applications.
• Provided team direction on projects and best practice for SQL development and SQL/Windows administration

Confidential

Sr. Pharmacy Analyst

Responsibilities:

• SQL/Oracle design, development and administration (SQL 7 - 2005) of Data Warehouse and Data Mart
• Performance tuned Data Mart
• Business Objects (Crystal Reports) analytics and reporting