Sql Server Technical Support
Resume:
Tyler Miles
**** ******** *****, ******* *******, 30349
Email: ***********@*****.***
Objective To become a Sql Server Database Administrator with a company that is growing
SUMMARY
As a core SQL Server DBA, Tyler, with over 4 years of expertise, has been actively involved in database design, implementation and management tasks including (but not limited to);
SSIS ETL Performance Tuning Migration
Backup and Recovery Database Security High Availability Disaster Recovery
Database Upgrades/patches Integration Services Troubleshooting Database Design
Replication Log shipping Store Procedures Partitioning
(Third Party Tools) T-Sql Language SSAS SSRS
JOIN Group Consulting
MS SQL DBA Consultant (2012 February – Present)
Supporting SQL Server 2005, 2008r2 production environments in a 24x7 on-call basis.
Installed and configured multiple SQL Server instances in production environments.
Implementation and support of High Availability Solutions by configuring log shipping and mirroring across multiple SQL Server instances.
Engaged in disaster recovery (DR) strategic planning and implementation in SQL Server.
RESTORE VERIFY option when creating backups.
Performed data refreshes on SQL Server production and test databases.
Responsible for the Production support of more than 200 SQL Server databases.
Managed SQL Server database security by granting permissions on securable to the principals.
Proactively engaged in various tuning techniques to maintain high performance production database environments and ensuring minimal to zero downtime.
Automated various routine maintenance tasks like backups, index reorgs, index rebuilds on all production databases.
Responsible for the daily maintenance tasks and Health Check of all SQL Server databases.
Ensured that all database related trouble tickets are delivered upon within the SLA.
Identified issues inhibiting the attainment of project goals, developed and implemented corrective actions.
Interfaced with Microsoft and other vendors for technical support through service Request tickets and technical Assistance (TARs).
Reorganize and Rebuilding of indexes at regular intervals for better performance.
Experience with working with VLDB consisting of 500GB-1 Terabyte
Extracting Transforming and Loading of data from My-Sql, Oracle into MS SQL.
Erotser Government Solutions
MS SQL DBA Consultant (2009 January – 2011 December)
Used SQL Profiler for troubleshooting, monitoring, optimizing store procedures.
Performed DBA duties including: database backups, restores, performance tuning, and capacity analysis.
Developed, modified, and optimized stored procedures, triggers to handle complex business rules.
Managed the products and development databases including performance tuning, capacity planning.
Understand SQL Server clustering environment, database security configuration, and database continuity.
Designed and implemented SQL Server 2005 databases for mission-critical business.
Developed and optimized stored procedures, triggers, and SSIS packages.
Troubleshoot databases and custom application issues.
Developed and created stored procedures, advanced queries, triggers, views, indices, and functions for databases.
Work with end users to define, implement, and maintain their reporting requirements.
Participated and coordinated the creation, modification and maintenance of database structures with minimal supervision.
Performed other duties assigned by management.
Worked with stored procedures and scripts for maintenance and reporting purposes.
Stored large documents in tables as XML types.
TECHNICAL ENVIRONMENT
RDBMS: SQL Server 2005, 2008, 2008r2 and 2012
LANGUAGES: T-SQL
OPERATING SYSTEMS: Windows NT, 2000. 2003. Windows 7
TOOLS: SQL Server Profiler, SSIS, SSMS,SSRS, Idera, Redgate
EDUCATION
Pacific Institute of Technology MS SQL Server 2008 R2
Clark Atlanta University Masters of Business Administration 2010
Clark Atlanta University Bachelor of Science/International Relations 1997
CERTIFICATIONS
Microsoft Certified Technology Specialist (MCTS)
Microsoft Certified IT Professional ( MCITP)
ORGANIZATIONS
Professional Association of SQL Server (PASS)
SQL SATURDAYS
Microsoft Database Forum (MDF)
Contact this candidate