Senior Database Developer

Copart Dallas , TX 75201

Posted 4 months ago

Copart is seeking an experienced Data Architect to work closely with our business analyst and application development teams to recommend database model & structures based on the business data storage and retrieval needs. The Data Architect will be responsible for constantly monitoring our databases and immediately addressing database issues and problems. The successful candidate will also submit reports to management that outline the changing data needs of the company and come up with related solutions.

Job Responsibilities

  • Analyze data requirements for business applications and build conceptual model.

  • Develop physical data model and data migration/conversion strategies for internally hosted applications.

  • Reference data maintenance. Work with business analyst to keep the reference data as per industry standard.

  • Troubleshoot production data issues. Identify and Cleanup of junk data.

  • Program and write SQL code to support the creation of tables, views, stored procedures, functions, reports and triggers.

  • Develop and maintain complex stored procedures, views and functions on MariaDB, MySQL, DB2 AS400 and DB2 LUW databases.

  • Acquire business knowledge for: debugging model/data related issues, explaining the models to application teams or business.

  • Provide operational and system support as well as technical expertise to software developers and database administrators.

  • Utilize software development principles and experience to support the full lifecycle of software products.

  • Work with application teams to identify ways to optimize the database tier and work to implement improvements for future releases.

  • Develop application and database standards/architecture to help ensure the scalability, performance and maintainability of applications.

  • Create standards to monitor and enhance capacity and performance.

Required Skills:

  • Ability to be flexible and work well with changing priorities.

  • Strong time management skills with ability to participate in multiple projects/work streams simultaneously as well as strong analytical/problem solving skills.

  • A self-starter who thrives with minimal supervision.

  • Experience addressing production issues that involve SQL Database performance *Proven database query optimization, performance tuning/monitoring experience *Knowledge of physical database structures and best practices *Thorough understanding and hands-on application of the software development lifecycle and related methodologies.

  • Experience working with Agile development methodologies.

  • Understanding of performance tuning and database constraint concepts such as indexes & primary keys

  • Have the ability to express yourself well, verbally and on email.

  • Ability to work with all levels of staff, management and external vendors

Required Experience:

  • BS, BA in Computer Science, Computer Information Systems, MIS, or relevant technology degree.

  • Experience with complex custom-developed software applications.

  • Minimum 8+ years previous related experience with RDBMS systems

  • 2 years of AS400 system work experience.

upload resume icon
See if you are a match!

See how well your resume matches up to this job - upload your resume now.

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Senior Database Developer

Guidestone Financial Resources

Posted 2 months ago

VIEW JOBS 12/15/2018 12:00:00 AM 2019-03-15T00:00 GuideStone Financial Resources is a diversified Christian financial services provider that allows a flexible work schedule and great benefits that include every other Friday off. GuideStone serves more than 200,000 participants nationwide in the faith-based marketplace. We are the largest Christian-screened mutual funds family in the nation, with approximately $13 billion under management. In addition, GuideStone holds approximately $2 billion of alternative investments. We are seeking a full-time, Senior Database Developer to join our team. The ideal candidate will have a passion for creating and enhancing enterprise database, data warehouse, and business intelligence solutions. This position will provide opportunities in full lifecycle development, application integration, systems analysis, business process re-engineering, data visualization and reporting, and agile project management. The ideal candidate will be highly motivated, have a strong work ethic, exhibit a passion for learning technology, and will work well in dynamic team environments. What you will do: * Develop database solutions utilizing the Microsoft stack of technologies (SQL 2014+, Azure SQL DB, SSIS, SSAS, SSRS, PowerBI, etc.) * Deliver high-quality database solutions utilizing CI/CD pipelines and DevOps practices. * Utilize SSMS and the Visual Studio IDE with Git source control and Azure DevOps/Visual Studio Team Services. Opportunities include: * Help shape GuideStone's technology path with an emphasis on Cloud (Azure) IaaS and PaaS solutions. * Mentor IT software development staff on advanced database topics. * Drive continuous improvement and modernization in solution delivery. Requirements * Bachelor's degree in Computer Science, Software Engineering, Information Systems, or other related discipline, preferred. * Applied advanced data integration and ETL experience, including strategies, performance optimization and troubleshooting. * Applied data modeling experience for operational databases, data warehouses and analysis cubes. Apply OnlineSend This Job to a Friend All materials will be kept confidential. GuideStone Financial Resources is an equal opportunity employer. © Copyright , GuideStone. All Rights Reserved. Guidestone Financial Resources Dallas TX

Senior Database Developer

Copart