Sql Server Database Administrator
Resume:
Scott Travis
Skilled DBA
North Little Rock, AR *2116
**********@*****.***
Professional Summary
Diligent DBA with multiple years of experience in database administration, focusing on Teradata, Oracle and SQL Server. Proficient in bash scripting, SQL, and PL/SQL, with expertise in data warehouse management, backup systems, and server security. Possess a strong background in business analysis, software development, and vulnerability resolution. Authorized to work in the US for any employer
Work Experience
Teradata Database Administrator Dillard's, Inc.-Little Rock, AR January 2023 to October 2024
Ensure database running smoothly and secure. Also worked with Teradata support staff to minimize vulnerabilities and keep database and servers properly upgraded.
• Built software (bash, SQL,awk) to scan servers for vulnerabilities and worked with vendors to ensure our vulnerabilities were properly resolved. This project addressed over 10000 vulnerabilities.
• Created documents detailing how to do user maintenance, ensuring that users were not left active longer than needed.
• Mastered management of Teradata backups and restores, and rearranged backups to keep footprint on disk to a minimum. Reduced the size of our backups by about 30% with no data loss.
• Identified and resolved database issues, such as locking conflicts or resource contention, to minimize downtime and maximize database speed. Also monitored database health using monitoring tools to proactively address bottlenecks or errors.
• Collaborated with development teams to optimize application code for better performance on the Teradata platform.
Solution Developer/System Engineer Acxiom-Little Rock, AR August 2010 to December 2022
Oversaw upgrade of both Oracle and AIX on development, test and production environments for large retail client.
• Worked with Admins to install Grafana on all servers. This allowed for real time monitoring of server performance.
• Migrated PHP website to new CENTOS server with new version of Apache, PHP, MySQL and MediaWiki.
• Worked with development team to deploy code changes with Git.
• Created multiple SQL Server stored procedures to monitor for changes in production data
(MSSQL).
• Redesigned multiple SQL Server tables by altering indices.
• Upgraded PERL/Crontab based automation system to run code 24/7. The tool is an Acxiom standard tool.
• Monitored production database to guarantee Oracle delivering required performance to meet SLA. The production team and I worked to tune any sql that was identified as an issue.
• Redesigned database backup to use IBM flashcopy and only required 20 mins of database downtime weekly since backup ran on a new backup server. Previously, a 12-14 database outage was required.
• Resolved vulnerabilities to keep servers secure. Data Analyst QualChoice of Arkansas-Little Rock, AR 2008 to 2010
Ran 77 reports per month to support business decisions in all departments of the company. The target was 95% on time, I increased the on time to an average of 99%.
• Worked with business users to obtain requirements for new reports, including data mining projects taking very loose associations in data and drawing conclusions from them. This was Qual Choice first exposure to data mining from the IT department rather than a third party vendor.
• Worked with members of Qual Choice staff to gather requirements then prepare the processes to pull requested data with either SSIS or Cognos.
• Maintained the actuarial data model which was responsible for Qual Choice hitting its profit targets in 2009. Used Excel to test logic planned for actuarial model.
• Worked with pharmacy vendors to ensure extracts and correct ETL of pharmacy data and set up automated processes to ensure the integrity of the data.
• Designed and built multiple Cognos dashboards to show information never shown before. Education
Graduate Certificate in Information Quality University of Arkansas - Little Rock, AR 2012 BA in Criminal Justice University of Arkansas - Fayetteville, AR 1994 Skills
• Linux
• HTML
• SQL
• XML
• Microsoft SQL Server0
• Oracle 19c
• PERL
• Sql Server
• Crontab
• MySQL
• Git
• Java
• Agile
• Unit Testing
• SVN
• Requirements Gathering
• APIs
• Business Analysis
• Test Cases
• Relational database
Contact this candidate