SQL Programmer Analyst

Overview

The SQL Programmer Analyst will be responsible for the efficient and effective management of the organization’s Merchandise and Finance applications, along with their databases and integrations. This position will focus on the development of SQL Stored procedures, database maintenance, and optimization efforts to ensure data integrity, confidentiality, and availability. You will play a key role in improving database integrations and ensuring these systems meet the growing needs of the business. This role reports to the IT Manager and collaborates with cross-functional teams to optimize Cavender’s application architecture, integration processes, and overall database health.

DUTIES AND RESPONSIBILITIES

• Support the “Cavender’s Culture” and drive the Mission, Vision, and Values
• Collaborate with D365 and middleware integration teams to identify integration issues, performance bottlenecks, and opportunities for improvement.
• Migrate legacy SQL integration procedures from Merch, Finance, and ERP to new ETL technologies. Reverse engineer legacy code and develop a comprehensive understanding of transaction flows between business applications.
• Manage application databases, optimize queries, ensure data integrity, and ensure the scalability of databases. Maintain database security and compliance with industry standards.
• Develop and optimize a SQL database knowledge base to automate regular tasks and allow for delegation to other IT team members.
• Acquire a strong understanding of Cavender’s key merchandise and finance applications and their interactions with backend databases and integration points.
• Evaluate current database automation practices and identify improvement opportunities. Be comfortable reverse-engineering SQL and other database objects.
• Contribute to the design and optimization of Cavender’s application architecture from a database and integration perspective, ensuring scalability, reliability, and performance.
• Develop incident response plans, perform risk assessments, and implement strategies to mitigate risks that could affect system availability or business operations.
• Ensure adherence to security protocols and manage up-to-date patching for compliance.
• Collaborate with application and integration owners to maintain security.
• Build a secure, scalable database and integration infrastructure to support the company’s growth.
• Perform additional duties as assigned.

QUALIFICATIONS AND REQUIREMENTS

• Bachelor's degree in computer science, Information Technology, or a related field experience
• 5 years of experience in SQL development, database administration, query optimization, application architecture, and integration management.
• Proficiency in MS SQL, SSIS, SSMS, PL/SQL, Oracle DB, Snowflake.
• Proven track record of managing complex application database and integration environments.
• Strong knowledge of database best practices, including performance improvements, health monitoring, and security protocols.
• Excellent leadership, communication, and interpersonal skills, with the ability to collaborate effectively with cross-functional teams and senior management.
• Self-motivated with the ability to work independently and as part of a team.
• Excellent time management and project prioritization skills, able to manage multiple projects and meet deadlines.
• Based in Tyler, TX at our home office; Tyler area residence.

PREFERRED SKILLS

• MS SQL Development and Architecture including deep knowledge on complex functions, stored procedures, SSMS, SSIS, Linked Server and performance tuning
• Experience in reverse engineering legacy SQL code and integrations
• Merchandising systems and application knowledge, financial application knowledge (D365), Service based integration experience and knowledge (Logic App, Boomi, Azure Service Bus, Snowflake)
• Experience with cloud platforms (eg, AWS, Azure), virtualization technologies
• Relevant Microsoft SQL Server certifications
• Experience working in a retail environment a plus

Cavender’s is an Equal Opportunity Employer. We do not discriminate based on race, religion, color, military status, national origin, sex, ancestry, age, sexual orientation, pregnancy, disability, genetic information, or any other personal characteristic protected under federal, state, or local law.

Cavender’s will provide reasonable accommodations for persons with a disability upon request. If you have a disability and need assistance completing the application, please call Customer Service at (888) 361 – 2555 or visit your nearest Cavender’s store.