Sr. Database Administrator Resume
3.00/5 (Submit Your Rating)
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