SQL Server Database Developer

Summary:  Assesses business requirements, develops functional specifications, and develops data related solutions. Writes and maintains stored procedures, functions, or queries meant to assist the organization in accessing and analyzing business data. Develops standard and custom reports using SQL Server Reporting Services. Develops and implements ETL functions and processes for incoming and outgoing data transfer. Documents workflow, enhancements, and QA processes. The position will be part of the Database Team of the IT department.

Responsibilities:

• Full cycle development of database systems. Work with client to understand the business requirements, design and implement the applications, modify, and enhance existing applications, create and maintain technical documentation, ensuring the stability, reliability, and performance of the systems.
• Develop T-SQL database objects and SSIS packages to facilitate the flow of data between the systems. Create and maintain data flow diagrams and mapping documents. Modify existing solutions to support changes to business requirements. Examine data and workflows to increase optimization and improve efficiency.
• Participate in the design and develop the EDW solutions, develop the ETL process
• Upgrade/migrate the database systems to newer versions, SQL database, SSIS package, SSRS report.
• Creating indexes/store procedures/tables, database normalization, performance tuning/troubleshooting/traces, etc.
• SQL server installation and configuration, clustering
• Must be able to work independently with minimum supervision

Requirements:

• Excellent skills on ETL with SSIS development
• Excellent skills of T-SQL programming and understanding Microsoft SQL Server.
• Strong skills of data modeling and designing databases
• Solid understanding of systems development life cycle (SDLC), software best practices and development methodologies.
• Strong skills of building data warehouses
• Strong analytical and diagnostic skills.
• Skill troubleshooting issues in a multi-tier environment.
• Skill working with both business team members and technologists.
• Critical thinker and a team player.
• Good time-management skills and problem-solving skills.

Competencies To perform the job successfully, an individual should demonstrate the following competencies:                                              

• Problem Solving - Identifies and resolves problems in a timely manner; Gathers and analyzes information skillfully; Develops alternative solutions; Works well in group problem solving situations; Uses reason even when dealing with emotional topics.
• Customer Service - Responds promptly to customer needs; Responds to requests for service and assistance; Meets commitments.
• Interpersonal Skills - Maintains confidentiality;
• Oral Communication - Speaks clearly and persuasively in positive or negative situations; Listens and gets clarification; Responds well to questions; Participates in meetings.
• Written Communication - Writes clearly and informatively; Able to read and interpret written information.
• Teamwork - Balances team and individual responsibilities
• Ethics - Treats people with respect; Keeps commitments; Inspires the trust of others; Works with integrity and ethically; Upholds organizational values.
• Organizational Support - Follows policies and procedures; Completes administrative tasks correctly and on time; Supports organization's goals and values.
• Judgment - Displays willingness to make difficult /unpopular decisions; Supports and explains reasoning for decisions; Includes appropriate people in decision-making process; Makes timely decisions.
• Planning/Organizing - Prioritizes and plans work activities; Uses time efficiently; Plans for additional resources; Sets goals and objectives; Organizes or schedules other people and their tasks;
• Professionalism - Approaches others in a tactful manner; Reacts well under pressure; Treats others with respect and consideration regardless of their status or position; Accepts responsibility for own actions; Follows through on commitments.
• Quality - Demonstrates accuracy and thoroughness; Looks for ways to improve and promote quality; Applies feedback to improve performance;
• Adaptability - Adapts to changes in the work environment; Changes approach or method to best fit the situation.
• Attendance/Punctuality - Arrives at meetings and appointments on time.
• Dependability - Follows instructions, responds to management direction; Keeps commitments; Commits to long hours of work when necessary to reach goals; Completes tasks on time or notifies appropriate person with an alternate plan.
• Initiative – Takes independent actions and calculated risks; Looks for and takes advantage of opportunities; Asks for and offers help when needed.

Qualifications To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Education and/or Experience:   The knowledge, skills and abilities typically acquired through the completion of a Five years related experience.  Bachelor’s degree BS/MS Degree in Computer Science, Engineering, or relevant degree. BV.NET/C# skills preferred cloud (Azure/AWS) experience preferred

Language Skills:  Ability to read and interpret documents, operating and maintenance instructions, and procedure manuals.  Ability to write routine reports and correspondence.  Ability to speak effectively before managers or employees of organization.

Mathematical Skills:  Ability to work with basic mathematical concepts.

Reasoning Ability:  Ability to apply common sense understanding to carry out detailed but uninvolved written or oral instructions. 

Computer Skills:  To perform this job successfully, an individual should have intermediate level in Microsoft Products (Word, Excel, Power Point and Outlook)/

Other Skills and Abilities:  Excellent time management, decision making, prioritization and organization skills.   Working knowledge of antivirus and firewall solutions.  Proven technical aptitude and proven customer service aptitude.                

Physical Demands The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

While performing the duties of this Job, the employee is regularly required to sit; use hands to finger, handle, or feel and talk or hear. The employee is frequently required to stand; walk and reach with hands and arms. The employee is occasionally required to climb or balance; stoop, kneel, crouch, or crawl. The employee must occasionally lift and/or move up to 50 pounds. Specific vision abilities required by this job include close vision.

Work Environment The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.  The noise level in the work environment is usually quiet.

Competencies To perform the job successfully, an individual should demonstrate the following competencies:                                              

• Problem Solving - Identifies and resolves problems in a timely manner; Gathers and analyzes information skillfully; Develops alternative solutions; Works well in group problem solving situations; Uses reason even when dealing with emotional topics.
• Customer Service - Responds promptly to customer needs; Responds to requests for service and assistance; Meets commitments.
• Interpersonal Skills - Maintains confidentiality;
• Oral Communication - Speaks clearly and persuasively in positive or negative situations; Listens and gets clarification; Responds well to questions; Participates in meetings.
• Written Communication - Writes clearly and informatively; Able to read and interpret written information.
• Teamwork - Balances team and individual responsibilities
• Ethics - Treats people with respect; Keeps commitments; Inspires the trust of others; Works with integrity and ethically; Upholds organizational values.
• Organizational Support - Follows policies and procedures; Completes administrative tasks correctly and on time; Supports organization's goals and values.
• Judgment - Displays willingness to make difficult /unpopular decisions; Supports and explains reasoning for decisions; Includes appropriate people in decision-making process; Makes timely decisions.
• Planning/Organizing - Prioritizes and plans work activities; Uses time efficiently; Plans for additional resources; Sets goals and objectives; Organizes or schedules other people and their tasks;
• Professionalism - Approaches others in a tactful manner; Reacts well under pressure; Treats others with respect and consideration regardless of their status or position; Accepts responsibility for own actions; Follows through on commitments.
• Quality - Demonstrates accuracy and thoroughness; Looks for ways to improve and promote quality; Applies feedback to improve performance;
• Adaptability - Adapts to changes in the work environment; Changes approach or method to best fit the situation;
• Attendance/Punctuality - Arrives at meetings and appointments on time.
• Dependability - Follows instructions, responds to management direction;  Keeps commitments; Commits to long hours of work when necessary to reach goals; Completes tasks on time or notifies appropriate person with an alternate plan.
• Initiative – Takes independent actions and calculated risks; Looks for and takes advantage of opportunities; Asks for and offers help when needed.

Qualifications To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Education and/or Experience:   The knowledge, skills and abilities typically acquired through the completion of BS/MS Degree in Computer Science, Engineering, or relevant degree. Five years related experience. Bachelor’s degree in Computer Science. BV.Net/ C# skills preferred, Cloud ( Azure/ AWS) experience preferred.

Language Skills:  Ability to read and interpret documents, operating and maintenance instructions, and procedure manuals.  Ability to write routine reports and correspondence.  Ability to speak effectively before managers or employees of organization.

Mathematical Skills:  Ability to work with basic mathematical concepts.

Reasoning Ability:  Ability to apply common sense understanding to carry out detailed but uninvolved written or oral instructions. 

Computer Skills:  To perform this job successfully, an individual should have intermediate level in Microsoft Products (Word, Excel, Power Point and Outlook)/

Other Skills and Abilities:  Excellent time management, decision making, prioritization and organization skills.   Working knowledge of antivirus and firewall solutions.  Proven technical aptitude and proven customer service aptitude.                

Physical Demands The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

While performing the duties of this Job, the employee is regularly required to sit; use hands to finger, handle, or feel and talk or hear. The employee is frequently required to stand; walk and reach with hands and arms. The employee is occasionally required to climb or balance; stoop, kneel, crouch, or crawl. The employee must occasionally lift and/or move up to 50 pounds. Specific vision abilities required by this job include close vision.

Work Environment The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.  The noise level in the work environment is usually quiet.

SFS is an equal opportunity employer. SFS is committed to providing its employees an environment that is free of harassment, discrimination, and intimidation. It is the policy of SFS to comply with all applicable employment laws and regulations and to provide equal opportunity for all qualified persons and to not discriminate against any employee or applicant for employment because of race, color, religion, sex, age, national origin, disability, pregnancy, sexual orientation, veteran status, familial status, gender identity, change of sex, and/or transgender status or any protected status. Candidates must possess authorization to work in the United States. This policy applies to recruitment and placement, promotion, training, transfer, retention, rate of pay and all other terms and conditions of employment. Employment and promotion decisions will be based solely on merit, ability, achievement, experience, conduct and other legitimate business reasons. Interested candidates should NOT submit a photograph or video with a résumé. Résumés containing a photograph or video will not receive consideration.