We provide IT Staff Augmentation Services!

Sr. Database Administrator Resume

Phoenix, AZ

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

Hire Now