Sr. SQL Developer

Company: Advance Auto Parts
Location: Newark
Posted on: June 23, 2022

Job Description:

Job Description

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

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
Liquibase table automation
SOLR administration

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, 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.
Bachelor's degree in Computer Science or related technical discipline
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.

#LI-KN-AAP

Keywords: Advance Auto Parts, Newark , Sr. SQL Developer, IT / Software / Systems , Newark, New Jersey