Overview
POSITION SUMMARY STATEMENT:
This Applications Developer II profile focuses on designing and developing the database. The position is for the analysis, design, construction, configuration, testing, and implementation of business and technical information technology solutions through application of appropriate software development life cycle methodology. The developer needs to have a sharp eye for spotting defects and should be a team player and excellent communicator.
Detailed Responsibilities
- 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.
- 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
Languages
Essential Technical Skills:
- 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.
Terms of Use Privacy Policy Compliance Documents CSR Policy
