What are the responsibilities and job description for the Database Administrator position at 4 Wheel Parts?
Transamerican Auto Parts (“TAP”) is a multi-national, multi-channel distributor (retail, wholesale, e-commerce and catalog) of aftermarket automotive parts as well as a manufacturer of several branded product lines. We are seeking a Treasury Supervisor to join our Accounting team.
Responsibilities:
- Administer SQL Server and Oracle database systems across Production, Staging, QA, and Development environments.
- Recognize system deficiencies, diagnose performance issues, and implement effective solutions.
- Migrate SQL Server databases, SSIS packages and SSRS packages from SQL server 2016 to SQL server 2019.
- Generate code to extract, transform, and load data from/to production data sources from/to external sources (excel, text comma and tab delimited files, other Access, SQL databases, XML, etc).
- Provide technical and/or administrative support within a specific area, including: develop and maintain documentation, manage processes, and coordinate activities, audit work, and analyze reports.
- Ensure ongoing effort to improve effectiveness, including: research and evaluate pending developments, identify areas of concern, recommend solutions, and implement upgrades and enhancements.
- Assess and troubleshoot escalated problems and apply advanced understanding to resolve problems of stakeholders; focus on root cause identification to achieve systemic improvement.
Experience & Qualifications:
- 5 years’ experience designing databases and in systems administration.
- Experience writing SQL(T-SQL and PL/SQL) and working with SQL Server and Oracle databases.
- Experience with database administration with skills including but not limited to: Security, Configuring Jobs, Backup and Recovery, Data Management, Performance Tuning, and Database Migrations.
- Advanced skills in analyzing data and constructing reports using appropriate tools like Microsoft Excel as well as being fluent with one more of the following applications: Reporting Services, SQL Server Management Studio, SQL Server Integration Services; Reporting skills using MS Access, SQL, MS Excel, Server Reporting Services, etc.
- Advanced skills in designing and building ETL solutions along with the ability to triage existing SQL Server Integration services packages and suggest/implement improvements.
- Ability to analyze processes and propose new automation solutions to improve efficiency using SSIS, or other available ETL tools.
- Ability to discuss issues at a technical and nontechnical level with developers and project stakeholders.
- Ability to multitask, with strong attention to detail required, ability to prioritize diverse work assignments in a timely and accurate manner.
- Ability to perform troubleshooting techniques to isolate, diagnose and repair data defects.
- Aptitude for variety and changing expectations and fast-paced environment.
- Experience with ACES, PIES, and VCdb data sources is a huge plus.
Candidate should be comfortable in a fast-paced, demanding, and cross functional team environment. Minimal travel required. In addition to a great compensation plan, we offer a wide range of benefits, including medical & dental insurance; vision plan; 401(k) Plan; paid holidays; paid vacation; paid sick time; employee purchase program; and many other perks.
To learn more about us, visit: http://transamericanautoparts.com/
Every new employee of Transamerican Auto Parts, 4 Wheel Parts or Dealer Services International must verify their eligibility of employment and satisfactorily complete a background investigation and pre-employment drug screening.
Transamerican Auto Parts is an equal opportunity employer and is proud of our diverse employee population. EEO/AA - W/V/D/M