Sr. SQL Developer in Memphis, TN at Advance Auto Parts

Date Posted: 6/4/2021

Career Snapshot

  • Employee Type:
    Full-Time
  • Location:
    Memphis, TN
  • Career Type:
  • Date Posted:
    6/4/2021

Career Description



Job Description



SUMMARY

The Catalog Development team is vital to developing and supporting a growing number of critical enterprise selling processes within Advance Auto Parts.  We partner with many different teams across the organization to understand their needs and are frequently involved in design, development, implementation and support of mission-critical processes that are leveraged by our Customers and Business team.  We take pride in developing these mission critical processes that are optimized for the best customer experience.

As Senior SQL Developer of this team, you will work with business stakeholders, project managers, business analysts, and other IT teams to understand the business needs and their requirements. You will be working closely with agile teams of data architect and software developers to determine the best architectural and design decisions, find innovative and practical solutions to meet our business needs in a fast-paced environment.  Additionally, you will be involved in the entire development cycle, conduct design and code reviews, and have a heavy input throughout the process, from requirements all the way to production deployment. The day-to-day work is interesting, challenging and fast-paced!

Successful candidates will be strong leaders who can work proactively and independently, prioritize well, communicate clearly, and have a consistent track record of delivery and support of high quality data and ETL solutions. The ideal candidate is one that is not only passionate about data/software development and architecture but also focus on business needs and customer experience.

NOTE: Open to remote work



QUALIFICATIONS

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

  • Deep hands-on technical experience with the following technologies:
    • Relational databases primarily Postgres and secondary Oracle. This includes knowledge of tools used for running queries, performing DB schema changes and analyzing database activity/performance.
    • Migrating Oracle custom SQL to Postgres compatible SQL while maintaining better or same performance
    • Basic Postgres administration
    • Experience with popular Postgres utilities
    • Writing advanced SQL, analyzing developer SQL and make recommendations for performance tuning SQL, rewriting SQL or adding indexes for efficiency and creating/updating stored procedures.
    • Creating stored procedures, triggers, functions, packages, Logical and Physical database design.
    • Experience with any cloud platform (AWS/Azure)
  • Proficient in the following technologies:
    • Postgres, Oracle 11g/12c databases
    • Design and developing stored procedures
    • Unix/Linux
    • Scripting- Shell/Perl/Python 
    • GIT skills to maintain scripts
  • Good to have technologies:
    • ETL tool experience with Datastage, Symmetric DS, and KAFKA
    • Terraform database automation
    • Liquidbase table automation
    • SOLR administration

Education and/or Experience

  • Bachelor's degree in Computer Science or related technical discipline; or equivalent practical experience with strong competencies in SQL and database design.
  • Experience developing underlying data models and databases (Oracle, and Postgres).
  • Experience maintaining and managing all versions of data models for production, testing and developing databases.
  • Experience developing, managing and maintaining data dictionary and or metadata.
  • Experience ensuring compliance of standards and conventions in developing programs.
  • Experience designing, developing and implementing complete development life cycle
  • Experience responding to user requests for data and reports.
  • Communication Skills
    • Exceptional customer relationship skills including the ability to discover the true requirements underlying feature requests, recommend alternative technical and business approaches, work with architects to come to an agreed technical approach, and lead development efforts to meet aggressive timelines with optimal solutions.
    • Ability to work collaboratively with or lead cross-functional teams with minimal supervision.
    • Ability to drive consensus within a team and influence outcomes in significant technical decision-making.
    • Excellent interpersonal, written and verbal communication skills to work with different business groups as well as IT partners (data and enterprise architects, vendors, etc.)
  • Problem Solving
    • Extreme attention to detail and organization in all aspects of the system development. 
    • Resolve and troubleshoot complex issues as required to ensure the availability and performance of developed ETL solutions, reports and dashboards for both external and internal users.
  • Time Management
    • Ability to effectively plan, organize and prioritize multiple streams of activity.  Adapt well to changes.
    • Demonstrated ability to meet commitments and multi-task in a fast-paced work environment with a high-level of accuracy and efficiency.
  • Analytic Skills
    • Demonstrated critical thinking skills.
    • Open-minded, willing to consider multiple options, sources, perspectives, and possible solutions.  Careful assessment of the importance, relevance, and validity of all options.
    • Inquisitive.  Ask probing questions and research as a basis for making design decisions and judging quality; understand the true reason behind the request rather than just accepting an initial thought or proposed solution.
    • Proactive and willing to contribute ideas.  Not afraid to ask questions.