Application Developer I - SQL

Overview

THE ROLE: 

This Application Developer Level I position focuses on supporting the design and development of database and application components under guidance from senior team members. The role involves participating in the analysis, design, development, testing, and implementation of business and technical IT solutions using standard software development life‑cycle (SDLC) methodologies.The developer is expected to demonstrate strong attention to detail, eagerness to learn, and the ability to work collaboratively in a team environment.

 

HOW YOU WOULD CONTRIBUTE: 

• Create new database (SQL) Objects and modify current one based on requirements.
• Keep data consistency and low redundancy level on developments.
• Keep high performance on DB Programming objects.
• Troubleshooting Database issues on production and non-production environments
• Continuous Integration /Continuous Delivery pipeline updates and working with DevOps for production deployment and post-production validation/support.
• Ability to quickly learn database structure, table layout and production processes.
• • Develop with quality through hands-on development and attention to detail.
  • Contribute as part of a team to research, develop, deploy, and maintain software for use within the company, designs, codes, tests, ensures quality assurance, debugs, and deploys application system.
  • Work closely on an agile team of product owner, other engineers, and scrum master in a collaborative environment
  • Uses appropriate tools to analyse, identify, and resolve business and/or technical problems.
  • Readily available to troubleshoot and solve unforeseen production incidents.
  • Actively participate in feature software design with senior and principal developer mentors
  • Interacts with the customer to gain an understanding of the business environment and technical context.
  • Validates scope, plans, and deliverables for assigned projects.
  • Mentoring staff and associate developers in the team, to make them understand about the techs that needed to run the project smoothly.

   

  REQUIRED QUALIFICATIONS: 

   

  Skills: 

  • Strong attention to detail, problem-solving skills, and verbal/written communication
  • Ability to work in an agile environment.
  • Experience on DB Designing, use of Entity-Relationship Diagram, Relational Model, Implementation of Normal forms.
  • Troubleshoot data loading and transformation procedures to resolve operational issues.
  • Ability to read execution plans.
  • MS SQL 
  • Write advanced SQL / TSQL (MS SQL Server) Queries
    • Solid experience with Data Definition Language (DDL) and Data Manipulation Language (DML) Statements
    • Development of Tables, Constraints (PK, FK, DF, Check, Unique), indexes
    • Understanding and development of DB Programming Objects (Stored Procedures, Functions, Views, Triggers, Types, etc) of medium to high complexity
    • Implement error handling.
    • Transactions, Isolation levels
    • Queries Performance tuning
  • Troubleshoot data loading and transformation procedures to resolve operational issues.
  • Ability to read execution plans.
  • Experience in Unit Testing frameworks, Unit test case design and executions

   

  Essential Technical Skills: 

  Languages: 

  • SQL
  • No SQL (Postgres db., Mongo dB)
  • 3+ years of experience in the IT/Technology industry with database development experience (MS SQL Server) 
  • Preferred: Agile Experience
  • Bachelor’s in computer science or equivalent.

   

  Experience: 

  • 3+ years of experience in the IT/Technology industry with database development experience (MS SQL Server) 
  • Preferred: Agile Experience
  • Bachelor’s in computer science or equivalent.

   

  Education: 

  Bachelor’s in computer science or equivalent.