Description

Accelerate your Career!

At Swift, our greatest asset is OUR PEOPLE! We strive to be the best and give our best every day. We are passionate about learning and cultivating an environment of safety, honesty and mutual respect. We are a family where everyone has a voice and plays an essential role in our overall success and the success of our drivers. Your voice and perspective matter at Swift Transportation. We understand that you are the subject matter expert, and we trust you to ideate and execute those ideas based on the best interest of the company.

Be a part of something bigger. Be a part of the #1 full truckload carrier in the nation. Be a part of Swift Transportation.

Job Responsibilities: What you will do

Responsible for providing technical support for the database environment including overseeing the development and organization of databases, assessment and implementation of new technologies and providing IT with a long-term perspective on the relationship between database technology and business objectives.

• Maintain system level entity relationship diagrams, translate business requirements into transactional database schema designs.
• Assess the appropriateness of replicated data and verify compatibility of database tool and application software packages with existing database architectures and standards.
• Maintain meta data, administer the development and staging environments data repository.
• Determine data types and optimize the physical database design for the specific Database Management System (DBMS).
• Approve schema changes, call patterns and Sequel (SQL) code.
• Code and install changes to the database schema, stored procedures and replication processes utilizing DBMS or package-specific techniques as appropriate.
• Work closely with a team of developers and be actively involved in design decisions; consult developers on performance and optimizing SQL scripts.
• Develop and execute procedures to validate changes to the database infrastructure.
• Prepare required documentation and participate in change control.
• Work with production database administrators to migrate schema and stored procedure changes to production and participate in the verification processes.
• Model, define, create and maintain database resources.
• Create and/or review data models.
• Review and test new technologies and architectures that support and are aligned with applications.
• Proactively work to assist others in achieving the organization's objectives.

Copy and paste URL into browser to view full description: https://knxtrans.jdxpert.com/ShowJob.aspx?EntityID=2&id=3018

Qualifications: What you need to bring

• 5+ years in data analysis, database administration, or database replication in a high volume multi-platform transactional environment required.
• Experience with data warehousing technologies preferred.
• Bachelor's or equivalent combination of education and/or experience required.
• Must possess conceptual knowledge of project management techniques.
• Must possess solid technical skills with ability to research and solve complex problems.
• Must have excellent written, verbal, and documentation skills.
• Must be able to multi-task.

Pay Range: $80,000.00 - $112,500.00 Annual

What we offer:

• Competitive starting salary commensurate with experience and geographic location.
• Potential bonus pay based on company performance.
• Opportunities to volunteer and give back to local communities.
• Comprehensive Benefits Package which includes:
  • 401(K)
  • Medical, Dental, Vision, Disability, Supplemental and Life Insurance
  • Paid Time Off
  • Employee Stock Purchase Plan

The Company is an equal employment opportunity employer. The Company's policy is not to unlawfully discriminate against any applicant or employee on the basis of race, color, sex, sexual orientation, gender identity, religion, national origin, age, military status, disability, genetic information or any other consideration made unlawful by applicable federal, state, or local laws. The Company also prohibits harassment of applicants and employees based on any of these protected categories.