Job Overview:
The SQL DBA I designs, develops, documents and maintains database and business intelligence (BI) reporting environments to ensure that the performance, quality and reliability surpass the expectations of our internal and external customers.
The position also aids BI/SQL Developers to assist in troubleshooting and resolving issues when needs arise. This position typically requires a Bachelors degree in IT or related field plus 4 years experience in a developer role.
The ideal candidate will have strong Microsoft SQL Server, Windows Server, BI report/visualization, and overall data management skills. They will demonstrate excellent customer service skills, in-depth technical problem solving/troubleshooting ability, and be able to work independently.
Job Functions:
Development
Work autonomously to architect and develop database schema objects for reports and data management, including tables, views, stored procedures functions, and indexes
Work to architect and develop BI tabular reports and visualizations/dashboards across various reporting platforms: SSRS, Logi Analytics, PowerBI, etc.
Analyzes and profiles data for creation of operational and analytical tabular reports and visualizations, including dashboards
Perform analysis and profiling of application data for accurate report writing and data management development
Create and maintain report, database, and architecture documentation
Assist Project Managers and Quality Assurance in development and testing efforts
Production Support
Work with project management and support team on ensuring maximum performance and uptime of all customer systems including troubleshooting of complex problems
Work with internal IT teams to ensure performance optimization of internal database environments
Analyze query performance using execution plans and other techniques to optimize queries
Troubleshoot and resolve bugs, logic issues and performance issues (system, data, report, or DB code)
General
Be responsible for and/or be a contributor to documentation of artifacts including functional requirements documents, design documents, and data management plans
Follows proper change management procedures and other team processes
Create standards for our databases and decide whether developer database requests comply with our standards
Occasional travel to provide onsite implementation or troubleshooting support
24/7 internal and external support for critical issues via an on-call rotation
Preferred Skills and Required Qualifications :
- Bachelors degree in IT or Engineering
- 4+ years experience in a report developer role on any relational database platform
- 4+ years experience in Microsoft SQL Server, TSQL
- 2+ years experience in Azure SQL and Azure Data Factory
- Experience with Visual Studio, TFS, Azure DevOps, and GIT, including schema comparisons and source control
- Experience in the design and building of data models
- Experience in relational database design and tuning including reading and analyzing execution plans
- Experience in database monitoring (e.g. Traces, Extended Events, Perfmon) and troubleshooting
- Experience in database sizing estimating and monitoring
- Ability to design, develop and create database objects on Microsoft SQL Server platform. i.e. Tables, Indexes, Keys, Stored Procedures, Views, Functions, Triggers, etc.
- Strong troubleshooting skills
- Must be eligible to work in the USA long term without sponsorship.
Travel Requirements:
- 15% overnight travel (Travel expenses paid by Bastian Solutions)
To learn more about us, click the following link - https://www.youtube.com/watch?v=_wJsktTkF50
About Bastian Solutions:
Bastian Solutions, a Toyota Automated Logistics company, is an independent material handling and robotics system integrator providing automated solutions for distribution, manufacturing, and order fulfillment centers around the world. Our team specializes in consulting, system design, project management, maintenance, and installation, while sourcing the best equipment and automation technology. We take great pride in providing exceptional service and flexibility to our customers.
In addition to exciting work at a growing company, we offer the following benefits:
- Health, Dental, and Vision Insurance
- 401(k) Retirement Plan with a company match
- Vacation/Holiday Pay
- Tuition Reimbursement
- Volunteer Work
- Professional Associations, Conferences and Subscriptions
- Company Meetings & Events
Bastian Solutions does not work outside recruiting agencies. No solicitation phone calls please.
Top Skills
What We Do
Bastian Solutions, a Toyota Automated Logistics company, is a trusted supply chain integration partner committed to providing their clients a competitive advantage by designing and delivering world-class distribution and production solutions.
The expertise Bastian Solutions delivers includes exceptional results through a proven process of analytical consulting, engineering and design, simulation, project management, and installation services, while sourcing the best material handling equipment and automation technologies available.
With innovation at the forefront, the company also develops Exacta supply chain software, conveyor and sortation systems, custom automated material-handling equipment, robotics, autonomous vehicles and robotic shuttles, and state-of-the art industrial controls.
Bastian Solutions serves domestic and global markets, covering the United States, Canada, India, the Middle East, Mexico and South America.
