Skills
Required
software
engineering
development
maintenance
design
code
test
efficiency
engagement
coding
schedule
compliance
documentation
configuration
management
testing
addition
certifications
support
estimate
estimation
data
interface
retention
technology
logical
debugging
communication
drive
planning
programming
agile
scrum
kanban
ide
sql
developer
server
stability
writing
integration
troubleshooting
report
etl
database
monitoring
security
analyze
automate
query
tuning
training
backup
migration
integrity
optimization
scheduling
reporting
python
aws
Job
Description
Role Description Role Proficiency: Act creatively to develop applications by selecting appropriate technical options optimizing application development maintenance and performance by employing design patterns and reusing proven solutions. Account for others' developmental activities; assisting Project Manager in day to day project execution. Outcomes Interpret the application feature and component designs to develop the same in accordance with specifications. Code debug test document and communicate product component and feature development stages. Validate results with user representatives integrating and commissions the overall solution. Select and create appropriate technical options for development such as reusing improving or reconfiguration of existing components while creating own solutions for new contexts Optimises efficiency cost and quality. Influence and improve customer satisfaction Influence and improve employee engagement within the project teams Set FAST goals for self/team; provide feedback to FAST goals of team members Measures Of Outcomes Adherence to engineering process and standards (coding standards) Adherence to project schedule / timelines Number of technical issues uncovered during the execution of the project Number of defects in the code Number of defects post delivery Number of non compliance issues Percent of voluntary attrition On time completion of mandatory compliance trainings Code Outputs Expected: Code as per the design Define coding standards templates and checklists Review code – for team and peers Documentation Create/review templates checklists guidelines standards for design/process/development Create/review deliverable documents. Design documentation Requirements test cases and results Configure Define and govern configuration management plan Ensure compliance from the team Test Review/Create unit test cases scenarios and execution Review test plan created by testing team Provide clarifications to the testing team Domain Relevance Advise software developers on design and development of features and components with deeper understanding of the business problem being addressed for the client Learn more about the customer domain and identify opportunities to provide value addition to customers Complete relevant domain certifications Manage Project Support Project Manager with inputs for the projects Manage delivery of modules Manage complex user stories Manage Defects Perform defect RCA and mitigation Identify defect trends and take proactive measures to improve quality Estimate Create and provide input for effort and size estimation and plan resources for projects Manage Knowledge Consume and contribute to project related documents share point libraries and client universities Review the reusable documents created by the team Release Execute and monitor release process Design Contribute to creation of design (HLD LLD SAD)/architecture for applications features business components and data models Interface With Customer Clarify requirements and provide guidance to Development Team Present design options to customers Conduct product demos Work closely with customer architects for finalizing design Manage Team Set FAST goals and provide feedback Understand aspirations of the team members and provide guidance opportunities etc Ensure team members are upskilled Ensure team is engaged in project Proactively identify attrition risks and work with BSE on retention measures Certifications Obtain relevant domain and technology certifications Skill Examples Explain and communicate the design / development to the customer Perform and evaluate test results against product specifications Break down complex problems into logical components Develop user interfaces business software components Use data models Estimate time and effort resources required for developing / debugging features / components Perform and evaluate test in the customer or target environments Make quick decisions on technical/project related challenges Manage a team mentor and handle people related issues in team Have the ability to maintain high motivation levels and positive dynamics within the team. Interface with other teams designers and other parallel practices Set goals for self and team. Provide feedback for team members Create and articulate impactful technical presentations Follow high level of business etiquette in emails and other business communication Drive conference calls with customers and answer customer questions Proactively ask for and offer help Ability to work under pressure determine dependencies risks facilitate planning handling multiple tasks. Build confidence with customers by meeting the deliverables timely with a quality product. Estimate time and effort of resources required for developing / debugging features / components Knowledge Examples Appropriate software programs / modules Functional & technical designing Programming languages – proficient in multiple skill clusters DBMS Operating Systems and software platforms Software Development Life Cycle Agile – Scrum or Kanban Methods Integrated development environment (IDE) Rapid application development (RAD) Modelling technology and languages Interface definition languages (IDL) Broad knowledge of customer domain and deep knowledge of sub domain where problem is solved Additional Comments Exp: 10+ years Job Description: The SQL/Snowflake Developer will be responsible for the implementation, configuration, maintenance, and performance of critical SQL Server RDBMS and Snowflake systems, to ensure the availability and consistent performance of our corporate applications as well as ensuring data is readily available to end-users. This is a “hands-on” position requiring solid technical skills, as well as excellent interpersonal and communication skills. The successful candidate will be responsible for the sustainment of multiple SQL Server instances across the enterprise that provide the backend to critical business systems. Must be capable of working independently and collaboratively. Additionally, they will be responsible for building databases and validating their stability and efficiency. Improving performance of program views, functions, and stored procedures. Writing optimized SQL queries for integration with other applications. Troubleshooting SSRS report queries, stored procedures in both SQL and Snowflake . Responsibilities - Manage SQL Server databases on multiple instances as needed. - Manage Snowflake system. - Manage ETL process and ensure data is available in the DB. Suggest improvements to the ETL process. - Troubleshoot SQL and Snowflake stored procedures. - Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security. - Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end. - Refine and automate regular processes, track issues, and document changes. - Assist developers with complex query tuning and schema refinement. - Provide support for critical production systems as needed. - Perform scheduled maintenance activities after hours as needed. - Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members. - Handle common database procedures such as upgrade, backup, recovery, migration, etc. - Ensure the data quality and integrity in databases. Skills and Qualifications - Expert in SQL Server versions 2012, 2017, and newer. - Expert in Snowflake cloud platform - Experience with Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools - Experience with backups, restores and recovery models - Experience with SQL Agent Job scheduling - Excellent understanding of T-SQL programming - Excellent experience with SQL Server Reporting Services and SQL Server Integration Services - Experience working with Windows server, including Active Directory - Excellent written and verbal communication - Flexible, team player, “get-it-done” personality - Ability to organize and plan work independently - Ability to multi-task and context-switch effectively between different activities and teams - MCTS, MCITP, and/or MVP certifications are a plus - Python, AWS Glue is a plus Skills Sql Server,Snowflake,Performance Tuning Show more Show less
