Sr. DB Developer

Description

POSITION SUMMARY (Key tasks and outcomes):

A Senior Software Engineer possesses advanced technical knowledge and experience in software development. They are involved in making critical technical decisions, optimizing performance, and ensuring code quality. Senior Software Engineers often collaborate with stakeholders to understand business requirements and provide technical guidance to the team.

Job Title – Senior Software Engineer

Job Description:

• Strong expertise in Postgres SQL required – SQL and database development.

• Design, develop, and maintain complex SQL queries, stored procedures, functions, and views

• Optimize database performance through query tuning, indexing, and execution plan analysis

• Work with large datasets and high-transaction databases

• Design and manage database schemas and data models

• Ensure data integrity, consistency, and security

• Support and troubleshoot production database issues

• Collaborate with application developers, BI, and data teams

• Participate in database architecture and design reviews

• Implement and manage backup, recovery, and disaster recovery strategies

• Perform database migrations and upgrades

• Mentor junior developers and review SQL code

• Should be Proficient on Git, SQL, SSRS, Power BI (Report development or DAX, Paginated report, Dataset or IDM or MQuery), Visual Studio, Azure Devops.

• Good if the candidates have exposure to either Power BI and / or Data bricks and / or AWS Redshift

• Researching, designing, implementing, and managing reports and dashboards.

• Unit testing and evaluating new programs.

• Identifying areas for modification in existing programs and subsequently developing these modifications.

• Ownership of individual and team tasks delivery.

• Writing and implementing efficient code.

• Determining operational practicality.

• Developing quality assurance procedures.

• Deploying software tools, processes, and metrics.

• Maintaining and upgrading existing systems.

• Working closely with other developers, UX designers, business and systems analysts.

Experience (Years and types):

Must have 3 - 6 years of work experience with relevant skills.

Skills and Abilities and Other Characteristics:

• Enthusiastic team player who enjoys both strategic and hands on work.
• Cross functional collaboration and time management skills.
• Should be proficient in computer literacy, MS Office and Typing skills.
• Ability to analyze problems and develop creative solutions to complex product issues.
• Strong interpersonal, communication, and the ability to work effectively with all levels of employees.