The DBA serves an important role at Datex, including:
- Supporting and assisting in the implementation of new and existing SQL systems, data conversions and migrations, stored procedure review, deployment, and monitoring of the system. This includes maintaining legacy system databases and assisting in the migration to new systems.
- Working with clients to optimize database performance. This includes day-to-day administration, performance tuning, and maintenance.
- Managing On-Premises SQL Servers and cloud-based Microsoft Azure SQL Services.
Role and Responsibilities
- Ensure system availability and recovery
- Execute performance tuning, backup, and restoration of databases
- Maintain all databases including Development, QA, Training, and Production environments
- Work with business users, developers, and infrastructure teams to ensure quality products
- Responsible for documenting all database maintenance procedures, data standards, procedures, and definitions for the data dictionary.
- Keep SQL servers up to date with necessary patches
- Provide daily management of Microsoft SQL Server infrastructure and assure service availability
- Other duties may be performed as the need arises.
Skillset
- Solid work ethic geared towards proving high quality service to clients
- People-oriented -- enjoys interacting with people and working on group projects.
- Adaptable/flexible -- enjoys doing work that requires frequent shifts in direction.
- Detail-oriented -- would rather focus on the details of work than the bigger picture.
- Achievement-oriented -- enjoys taking on challenges, even in the face of possible failure.
- Autonomous/Independent -- enjoys working with minimal direction.
- Skilled at prioritizing and organizing work
- Bachelor’s Degree in computer science or equivalent education, training, and work-related experience
- 4+ years of experience in database administration of SQL Server database environments.
- Knowledge of Microsoft SQL Server 2016/2019/2022
- Knowledge of On-Premises and cloud databases built with SQL Server and Azure SQL Services.
- Experience with SSRS, SSIS or SSAS
- Thorough understanding of Relational Databases, T-SQL Scripting, Database Normalization best practices, database technologies and concepts
- Experience with Performance Tuning, Index Analysis and Query Optimization
- Proficient with SQL Development – ability to write and troubleshoot SQL Code and design (stored procs, functions, tables, views, triggers, indexes, constraints)
- Experience troubleshooting and resolving database integrity and performance issues
- Database Design in a Software Development Environment as a contributor
- Experience with troubleshooting SQL Server Transactional Replication
- Medical Insurance
- Paid Time Off
- Paid Holidays
- Remote Work
Top Skills
What We Do
In business since 1978, Datex is the best kept secret in the WMS industry. Datex specializes in providing leading edge technology solutions and white glove service to supply chain logistics industry businesses. Our highly flexible warehouse management software is ideally suited for 3PLs, regulated goods and complex operations.
Datex has specialized experience in dealing with pharmaceutical industry inventory, helping to ensure regulatory compliance, especially with DSCSA and FDA CFR Part 11.
Validated for our software expertise and excellent service, Datex is a Microsoft Gold Partner, in the top 1% of the 640,000 partners in the worldwide Microsoft network.
What Makes Datex Different?
• Our adaptable low code/no code warehouse management software provides maximum flexibility
• We specialize in providing a WMS tailored to the needs of each of our clients at a fraction of the cost of Tier 1 WMS solutions
• Our WMS includes an innovative suite of features designed to make our software easier, less time consuming, and cost-effective to adapt
• White glove service is our specialty
• As an end-to-end supply chain technology solution provider, Datex simplifies and reduces the cost and time of WMS implementation.