Maintains databases by determining structural requirements; developing and installing solutions, including ETL work with the data warehouse.
Determines database structural requirements by analyzing client operations, applications, and programming; reviewing objectives with clients; evaluating current systems.
Develops database solutions by designing proposed system; defining database physical structure and functional capabilities, security, back-up, and recovery specifications.
Installs database systems by developing flowcharts; applying optimum access techniques; coordinating installation actions; documents actions.
Maintains database performance by identifying and resolving production and application development problems; calculating optimum values for parameters; evaluating, integrating, and installing new releases; completing maintenance; answering user questions.
Provides database support by coding utilities, validating accuracy of reports, responding to user questions, and resolving problems.
Designs, develops and deploys base queries, stored procedures, and reports based on defined business requirements
Uses knowledge of the data warehouse data model to map required attributes and identify data gaps to be addressed
Defines the data extraction, load processing, source-to-target mappings for loading operational system data into the data warehouse
Uses knowledge of the data warehouse data model to determine the required data fields and metadata requirement
Learn, manage, and admin multiple database platforms (SQL Server, MariaDB, MySQL etc.)
Minimum of 5 years of total IT experience including at least 2 years' experience as a Database Analyst.
Strong written and verbal communications skills.
Customer and goal focused; needs to understand the importance of the application to the business and is able to set client expectations appropriately.
Ability to display strong sense of urgency and work with minimal supervision in a fast paced, dynamic, team oriented environment.
Extensive experience using T-SQL, writing stored procedures and efficient SQL queries
Experience rendering charts, graphs and other visualizations where appropriate
Preferred but not required: Experience with Microsoft SQL Server 2012, SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Team Foundation Server (TFS), Excel PowerPivot, Report Builder
EDUCATION and/or EXPERIENCE
Bachelor Degree in Computer Science, Industrial Engineering, Business Administration, or equivalent area with relevant job experience; advanced degree desired, but not required
Trucking, transportation, distribution or manufacturing industry experience desirable, but not required
As an EEO/Affirmative Action Employer all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status
A. Duie Pyle, Inc