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, 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.