Application and Database Analyst

Cavender Stores - Tyler, TX

Full-time

Tyler, TX

Clothing, Clothing Accessories, Shoe, and Jewelry Retailers

About the position

The Application & Database Analyst is responsible for managing and optimizing Cavender's Merchandise and Finance applications and their databases. This role ensures the integrity, confidentiality, and availability of applications and data while optimizing database integrations to support the company's growth. The analyst will report directly to the Director of IT, Merchandise and Financial, and will play a crucial role in safeguarding data and enhancing system performance.

Responsibilities

• Support the 'Cavender's Culture' and drive the Mission, Vision, and Values.
• Manage all aspects of the Merchandise and Finance applications, including daily incidents, break-fix, vendor management, and integrations to other systems.
• Manage all aspects of application databases, including query and job optimization, health, data integrity, and scalability.
• Ensure databases are robust, secure, and compliant with industry standards.
• Build upon, optimize, and maintain our SQL knowledge base to ensure regular tasks can be automated or delegated to other IT resources.
• Quickly learn the key Merchandise and Finance applications and their interactions with back-end databases and integration points.
• Review current database automation and identify opportunities for improvement.
• Reverse-engineer SQL and other DB objects written by others.
• Develop and maintain major incident response plans.
• Conduct risk assessments and implement mitigation strategies to prevent production outages or business disruptions.
• Ensure compliance with the latest security vulnerabilities and maintain compliance through up-to-date patching.
• Prioritize requests from business partners and reconcile these with Cavender's strategic vision.
• Build a secure database and integration landscape that can scale to meet the demands of a growing company.

Requirements

• Bachelor's degree in computer science, Information Technology, or a related field experience.
• Extensive experience (5+ years) in database analysis, query optimization, application architecture, and integrations between critical business applications.
• Proficiency in MS SQL, SSIS, SSMS, PL/SQL, Oracle DB, Snowflake.
• Proven track record of successfully implementing IT database initiatives and managing complex application database and integration environments.
• Strong knowledge of database and integration best practices, including performance improvement and database health monitoring.
• Excellent leadership, communication, and interpersonal skills.
• Self-motivation and ability to work well independently and as part of a team.
• Commitment to organization and meeting customer expectations and deadlines.
• Proven ability to meet project deadlines and budgets and manage multiple concurrent projects.
• Excellent written and verbal communication skills.
• Ability to effectively prioritize and execute tasks in a fast-paced environment.

Nice-to-haves

• 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 (e.g., AWS, Azure), virtualization technologies, and network protocols (TCP/IP, DNS, DHCP).
• Relevant certifications (e.g., CISSP, CISM, CCNP, ITIL) preferred.
• Experience working in a retail environment.