Senior Database Developer - Application Database Developer IT IV

  • Signet Jewelers
  • Dallas, TX, USA
  • Oct 12, 2019

Job Description

Employee Contract Type Responsible for work on the complete life cycle of the development of a project, providing technical expertise and direction in developing and supporting application software of new and existing applications/systems to ensure development meets business requirements and performance objectives of the Zales and Pagoda Point of Sale system. ESSENTIAL DUTIES AND RESPONSIBILITIES Ability to analyze and troubleshoot application issues by scanning thru the application logs, utilizing SQL Profiler and querying databases as needed Ability provide support on mission-critical applications, which may require off hours support Collaborate with IT operations to provide mission critical support by providing assistance in troubleshooting and root cause analysis Ability to write complex SQL statements, custom scripts and stored procedures Designs technical specifications for application changes or new systems Works with Developers to design, develop, and test software to meet business requirements Creates and maintains application documentation according to established SDLC Participates in structured walkthroughs and technical reviews Tunes SQL queries Provides technical consultation in new systems development and enhancement of existing systems Provides status reports on project development to management on a regular and timely basis Provides technical direction and training to development and support team members

QUALIFICATIONS

Deep understanding of MS SQL Server, MS SQL Replication and Estimated Execution Plan Strong technical knowledge of SQL queries, scripts, indexes, and triggers is required Knowledge of PowerShell version 3.0 or higher is preferred and would need to be learned Technical knowledge of Java 1.8 or higher is preferred Strong analytical, problem-solving and conceptual skills Good verbal and written communication skills Ability to effectively adapt to rapidly changing technology and apply it to business needs Problem solver who can add value even when working outside of normal scope of duties Strong organizational and time management skills with proven ability to set goals and meet deadlines

EDUCATION and/or EXPERIENCE

Bachelor's Degree with a preferred field of study in Information Systems or Computer Science is preferred; equivalent experience is required otherwise 3 years of experience on MS SQL Server 3 years of experience with MS Replication 3 years of experience using Estimated Execution Plan 5 years of development experience using SQL Experience in retail is preferred but not required Experience in customizing Point of Sale or Point of Service systems is preferred but not required