Database Administrator
Atlanta, Georgia, United States
• Installed and configured SQL Server 2005, 2008, 2012 and 2016.• Administrative and Development DBA experienced in ETL, Backup, Recovery, job scheduling and database tuning.• Managed database migrations from SQL 2005 to SQL 2012 to include SSRS reports and subscriptions.• Managed SQL access adhering to access by AD group guidelines and provided a report by subscription to department owners. This was useful for auditing purposes and aided in keeping AD accounts clean as possible.• Maintained SSIS packages and processes for server monitoring and notifications. • Established and maintained sound backup and recovery policies and procedures.• Created, optimized and maintained database objects, i.e., stored procedures, views, triggers. • Worked with cross functional teams to architect database designs for custom in house applications.• Written DML scripts to add or modify data due to customer enhancement requests, resulting from a job/transactional process failure and/or acquisitions of additional business segments.• Added indexes where appropriate for optimized queries, defrag and rebuild indexes when needed. Use T-SQL daily for schema changes, analytics, BI, data modeling, data cleansing.• Worked as part of a team and provided 24 x 7 support on a rotational basis.• Consulted with support teams on processes, security and data integrity and other related SQL Server issues.