Role Proficiency:

Acts under very minimal guidance to develop error free code; testing and documenting applications

Outcomes:

     Understand the applications features and component design and develop the same in accordance with user stories/requirements.      Code debug test and document; and communicate product/component/feature development stages.      Develop optimized code with appropriate approach and algorithms following standards and security guidelines independently      Effectively interact with customers and articulate their input      Optimise efficiency cost and quality by identifying opportunities for automation/process improvements and agile delivery models      Mentor Developer I – Software Engineering to become more effective in their role      Learn technology business domain and system domain as recommended by the project/account Set FAST goals and provide feedback to FAST goals of mentees

Measures of Outcomes:

     Adherence to engineering processes and standards (coding standards)      Adherence to schedule / timelines      Adhere to SLAs where applicable      # of defects post delivery      # of non-compliance issues      Reduction of reoccurrence of known defects      Quickly turnaround production bugs      Meet the Defined productivity standards for project      Completion of applicable technical/domain certifications Completion of all mandatory training requirements

Outputs Expected:

Configure:

Follow configuration process

Test:

Create and conduct unit testing

Domain relevance:

Develop features and components with good understanding of the business problem being addressed for the client

Manage Defects:

Raise
fix
retest defects

Estimate:

Estimate time
effort and resource dependence for one's own work

Mentoring:

Mentor junior developers in the team Set FAST goals and provide feedback to FAST goals of mentees

Document:

Create documentation for one's own work

Manage knowledge:

Consume and contribute to project related documents
share point
libraries and client universities

Status Reporting:

Report status of tasks assigned Comply with project related reporting standards/process

Release:

Adhere to release management process

Design:

Understand the design/LLD and link it to requirements/user stories

Code:

Develop code with guidance for the above

Skill Examples:

     Explain and communicate the design / development to the customer      Perform and evaluate test results against product specifications      Develop user interfaces business software components and embedded software components      Manage and guarantee high levels of cohesion and quality      Use data models      Estimate effort time required for own work      Perform and evaluate tests in the customers or target environments      Team player      Good written and verbal communication abilities Proactively ask for and offer help

Knowledge Examples:

     Appropriate software programs / modules      Technical designing      Programming languages      DBMS      Operating Systems and software platforms      Integrated development environment (IDE)      Agile methods Knowledge of customer domain and sub domain where problem is solved

Additional Comments:

Job Description - Database Developer UST is looking for a Database Developer with minimum 3 year experience, who under the general supervision of the Engineering Platform Delivery Manager and Delivery Lead, will work to deliver the implementation of a Health care ecosystem for our Health Plan clients. The Senior Database Developer will work with the small to mid-size Health Plan Clients, third party vendors, and onshore and offshore UST associates to develop database for our Advalent healthcare payer system. Candidate should have excellent technical and communication skills and ability to engage as part of a team working both physically together and virtually. You should be an excellent problem solver who is able to grasp customer/team/development needs and brainstorm ways to fulfill them. As a Database Developer at UST, this is your opportunity to: • Be part of a world class health care payer backend system. • Work with the UST-Advalent development team to ensure solution quality and architecture compliance. • Collaborate with numerous external vendors many who are top in the healthcare industry. • Independently develop test and debug Database systems and SQL code. • Utilize your skills in Agile development methodologies including JIRA, SCRUM, Git, BitBucket. • Exercise strong communication skills including the ability to convey technical information effectively. • Ensure repeatability and reusability of integration design, processes, and code. • Consistently use analytical skills - able to synthesize complex information. • Deploy expertise in estimation techniques. • Perform other duties and special projects as assigned. • Support or conduct staff mentoring as needed. • Provide constructive feedback to staff. May have responsibility for staff oversight on a project including goal setting and performance monitoring. • Comply with the organization’s Code of Conduct, all regulatory and contractual requirements, organizational policies, procedures, and internal controls. • Responsible to write and maintain clean, well-written code, as per the best practices. You bring: • Experience and expert level skills with MySQL - Mandatory; Good to have - Microsoft SQL Server, Oracle, other RDBMS systems. • Build Database Objects Following Standards and Specifications (e.g. Tables, Views, Stored Procedure, UDF, Triggers and Indexes). • Develop and Optimize T-SQL Statements (e.g. Queries, Stored Procedures, UDF) to Support Internal and Customer Applications. • Coding, Debugging and Testing the Programs. • Experience with Database versioning. • Maintained the Database Using Procedures, Functions, Cursors and Triggers. • Performance troubleshooting and coding and designing for performance. • Performed Quality Assurance and Testing of SQL Server Environment. • Developed Complex T-SQL Code such as Stored Procedures, Functions, Triggers, Indexes and Views for the Application. • Responsible for Optimizing SQL Queries, Stored Procedures to Improve the Performance Time. • Knowledge on NoSQL databases like MongoDB, Graph Database like Neo4J, Janus etc. • Experience with Agile tools and methodologies including JIRA, SCRUM, Git, BitBucket • Experience in architecting software solutions and understanding of architecture governance. • Bachelor’s degree or higher in business or technical field, 5-8 years of relevant work experience. Work experience in client partner or account interaction is needed. • Strong Customer Focus • Deep understanding of software development in a team, and a track record of implementing quality software solutions on time and on budget. • Experience in any Health care IT application and a managed care environment is preferred. • Experience with Medicare and Medicaid is preferred For this role, we value: • Technical Competence o Healthcare background, especially the payer industry. o Strong problem-solving and excellent communication skills o Project Requirements, Analysis and Objectives o Experience in architecting, designing, and implementing software solutions. o Quality Focus o Ability to understand the architectures, ask the right questions and think bigger (performance, go live, future maintenance) o Ability to influence business and technical leaders in a dynamic environment. o Project organization & Teamwork o Problem resolution o Ability to manage scope and deliverables. o Share design/development ideas with visual tools like Lucidchart/similar. o Very comfortable with daily stand-up meetings with clients, update daily work progress via Project Management systems, voice/video calls, online collaboration using screen-sharing tools. o Exposure/experience in fast-paced, agile development practices. • Behavioral Competence o Engagement and Motivation o Assertiveness o Openness and Creativity o Results Orientation o Efficiency o Reliability o Devotion to high-quality customer service o Excellent interpersonal communication skills o Keen analytical and research abilities