Sql Database Administrator Resume
4.00/5 (Submit Your Rating)
Highlands Ranch, ColoradO
SUMMARY:
- I have worked with SQL Server for several years as a developer, moved into developer\DBA, and for the past several years solely dedicated to database administration/programming.My database programming, architectural experience, and enterprise production support for an eclectic mix of SQL server environments, enables me to make enduring contributions to an organization.
- The descriptions on my resume’ focus on some of the differences between the positions, but all include these basics:
- Performance Tuning levels include Server, Instance, Database and Application
- Utilize the power of Indexing and Statistics for each application
- Regular reviews tease out problem queries, work with developers for remedies
- Backup design, including offsite, to ensure data recovery to meet SLAs
- Business Continuity and Disaster Recovery plans, practices and drills
- Infrastructure design and implementation to best suit the customer
- ETL optimization and refinement to create a speedy, efficient process
- Migration design from disparate systems
- Replication, AlwaysOn, Log Shipping, and Archiving, to move data efficiently for reporting
- Build appropriate HA combination, fail over clusters, AlwaysOn and Multi Subnet Clusters
- Tools include TSQL, PowerShell, SSIS, Visual Studio, several db monitoring tools
- Create reports - SSRS, Crystal Reports, Tableau-like applications, Data Warehouse
- Troubleshoot issues to uncover root cause and offer sound solutions for zero repeat
- Automate DBA processes as well as application processes to ensure timely data Exchange
- Deploy proactive style to address potential issues before reaching failure
- Amazon Web Services - deployed 60+ SQL Servers including HA, replication, repositories, data warehouse
- Extensive Production support, QA test design assistances, work with development with data design, data flow, storage and long term archive processes.
EXPERIENCE:
SQL Database Administrator
Confidential, Highlands Ranch, Colorado
Responsibilities:
- Assist with migrating multiple SQL Server systems to Amazon Web Services.
- Assist with day to day care and maintenance of a large MS SQL environment.
- Assist with scripting automation of DBA tasks and responses to ensure data integrity.
SQL Database Administrator
Confidential, Melbourne, Florida
Responsibilities:
- Part of a team of SMEs assembled to manage, improve and grow QA and production environment.
- Currently designing and implementing a hybrid global SQL Server and MySQL database infrastructure to optimize data flow for consumption and storage. Design includes Amazon AWS, HA, multi-subnet HA servers, replication, log shipping.
- Design included installation for Amazon Web Services, High-Availability, multi-subnet High-Availability servers, Data Warehousing.
- Continual assessment, remediation, and optimization work was applied to the QA and Production systems to meet security, configuration and troubleshooting scenarios.
- Structural changes were made for consolidation and distribution of processes and data.
- Designed HA systems and introduced offsite backup systems to ensure Business Continuity and Disaster Recovery.
Database Administrator/ Database Programmer
Confidential, Melbourne, Florida
Responsibilities:
- Database administration support and database programming for large scale, high volume SQL Server environment. Finance, SharePoint, and Manufacturing.
- Design of several automated DBA processes for protecting and monitoring across the environment.
- Working with developers and users to automate/optimize their data exchange processes, including between Essbase and SQL Server as well as oracle and SQL Server.
- Assisting development team with design and optimization as well as users to resolve usability and/or access issues.
- Advanced TSQL, PowerShell, .NET. SSRS, SSAS, BI, Autosys.
- Example of applications supported with database support, troubleshooting, and automating: Hyperion, BizTalk, SharePoint, Websense, Symantec, System Center, iNow and more.
Confidential
Technology Manager Lead Dev\ Lead DBA, Melbourne, Florida
Responsibilities:
- Lead Programmer and Lead SQL DBA. Focus on designing tools and automation processes that affect growth. Integrations and process tools to secure, in corporate, modify, QC, transfer data.
- Architect security and network systems, manage and motivate a tech team.
- Design, Implement to completion, complex short term and long term projects in a timely manner.
- Database and data design for every project. NET, TSQL, SSRS, BI, Advantage, Sybase.