Lead Developer-PostgreSQL en Hyderabad a Advance Auto Parts

Fecha de publicación: 1/13/2022

Resumen de la oferta

  • Tipo de contrato:
  • Ubicación:
  • Tipo de empleo:
  • Fecha de publicación:

Descripción del empleo

Job Description

As a Lead 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.


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 mainly Oracle, Postgres.  This includes knowledge of tools used for running queries, performing DB schema changes and analyzing database activity/performance.

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

    • PL/SQL coding, creating stored procedures, triggers, functions, packages, Logical and Physical database design.

    • ETL tool experience with Datastage and Symmetric DS  

  • Proficient in the following technologies:

    • Oracle 11g/12c and Postgres databases, and other NoSQL DB.

    • Design and developing stored procedures

    • Unix/Linux

    • Shell scripting

    • SOLR

    • GIT

  • Good to have technologies:

    • Exposure to any cloud platform

    • Terraform

    • Kafka Connect

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