Application & Database Analyst

Job highlights
Identified by Google from the original job post
Qualifications
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
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, implementing, and maintaining database health monitoring
Excellent leadership, communication, and interpersonal skills
Ability to collaborate effectively with cross-functional teams and senior management
Self-motivation and ability to work well independently and as part of a team
Dedicated team player with excellent collaboration skills
Commitment to organization and committing to meeting customer expectations and deadlines
Proven ability to meet project deadlines and budgets and to manage multiple concurrent projects
Excellent written and verbal communication skills
Ability to effectively prioritize and execute tasks in a fast-paced environment
Must be hands-on and capable of working independently
Ability to interpret documents
Associate must be able to read and understand English
Associate must be able to stay alert during work hours assigned
Ability to travel up to 15%
Responsibilities
The Application & Database Analyst is responsible for ensuring all aspects of Cavender’s Merchandise and Finance applications, and their respective databases and integrations, are running efficiently and effectively
Reporting directly to the Director of IT, Merchandise and Financial, this position will play a crucial role in safeguarding the integrity, confidentiality, and availability of our applications and data, and optimizing our database integrations between systems to meet our fast-growing business needs
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 all 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 at Cavender’s, and how they interact with the back-end databases and integration points between systems
Review current database automation and identify opportunities for improvement
Must be comfortable reverse-engineering 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 latest security vulnerabilities and own the strategy to maintain compliance through up-to-date patching, coordinating with application and integration owners as needed
Prioritize requests from business partners and reconcile these with Cavender’s strategic vision
Build a secure database from business partners and reconcile these with Cavender’s strategic vision
Build a secure database and integration landscape that can scale, meeting the demands of a growing company
Duties may change and associates may be required to perform other duties as assigned
Job description
Overview

The Application & Database Analyst is responsible for ensuring all aspects of Cavender’s Merchandise and Finance applications, and their respective databases and integrations, are running efficiently and effectively. Reporting directly to the Director of IT, Merchandise and Financial, this position will play a crucial role in safeguarding the integrity, confidentiality, and availability of our applications and data, and optimizing our database integrations between systems to meet our fast-growing business needs.

Duties and 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 all 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 at Cavender’s, and how they interact with the back-end databases and integration points between systems
• Review current database automation and identify opportunities for improvement
• Must be comfortable reverse-engineering 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 latest security vulnerabilities and own the strategy to maintain compliance through up-to-date patching, coordinating with application and integration owners as needed
• Prioritize requests from business partners and reconcile these with Cavender’s strategic vision
• Build a secure database from business partners and reconcile these with Cavender’s strategic vision
• Build a secure database and integration landscape that can scale, meeting the demands of a growing company
• Duties may change and associates may be required to perform other duties as assigned

Qualifications and 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.
• 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, implementing, and maintaining database health monitoring.
• Excellent leadership, communication, and interpersonal skills. Ability to collaborate effectively with cross-functional teams and senior management.

Self-motivation and ability to work well independently and as part of a team
• Dedicated team player with excellent collaboration skills
• Commitment to organization and committing to meeting customer expectations and deadlines
• Proven ability to meet project deadlines and budgets and to manage multiple concurrent projects
• Excellent written and verbal communication skills
• Ability to effectively prioritize and execute tasks in a fast-paced environment
• Must be hands-on and capable of working independently
• Ability to interpret documents
• Associate must be able to read and understand English
• Associate must be able to stay alert during work hours assigned
• Ability to travel up to 15%
• Based in Tyler, TX at our home office. East Texas area residence

Preferred Skills
• 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

Cavender’s is an Equal Opportunity Employer. We do not discriminate based on race, religion, color, military status, national origin, sex, ancestry, age, ****** 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.

United States
Texas
Tyler Show on map Get directions