Sr. SQL Developer
Company: Advance Auto Parts
Posted on: June 23, 2022
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 a Sr. 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
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
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
Design and developing stored procedures
GIT skills to maintain scripts
Good to have technologies: ETL tool experience with Datastage,
Symmetric DS, and KAFKA
Terraform database automation
Liquibase table automation
Education and/or Experience
10+ years of experience in SQL development and database design
7+ years of experience in auto parts retail domain
Experience developing underlying data models and databases (Oracle,
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
Experience designing, developing, and implementing complete
development life cycle
Experience responding to user requests for data and reports.
Bachelor's degree in Computer Science or related technical
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
Demonstrated ability to meet commitments and multi-task in a
fast-paced work environment with a high-level of accuracy and
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
Keywords: Advance Auto Parts, Newark , Sr. SQL Developer, IT / Software / Systems , Newark, New Jersey
Didn't find what you're looking for? Search again!