Sr. MS SQL Server TSQL Developer
Apply NowCompany: OpTech
Location: Jacksonville, FL 32210
Description:
Why work at OpTech? OpTech is a woman-owned company that values your ideas, encourages your growth, and always has your back. When you work at OpTech, not only do you get health and dental benefits on the first day of employment, but you also have training opportunities, flexible/remote work options, growth opportunities, 401K and competitive pay. Apply today! OpTech is an EOE, all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran. https://www.optechus.com/eeo_self_identification/
IT Developers are responsible for the development, programming, and coding of Information Technology solutions. They will engage in all phases of the software development lifecycle which include: gathering and analyzing user/business system requirements, responding to outages and creating application system models. IT Developers are responsible for documenting detailed system specifications and will participate in evaluating, conducting performance testing, and all planned and unplanned maintenance for both internally developed applications and purchased products. Participate in design meetings and consult with clients to refine, test and debug programs to meet business needs and interact and sometimes direct third party partners in the achievement of business and technology initiatives. IT Developers are responsible for including IT Controls to protect the confidentiality, integrity, as well as availability of the application and data processed or output by the application.
Essential Functions:
Will work as a part of the SQL Development team by designing schema, tables, views, indexed views, developing stored procedures
Create complex queries, SSIS jobs and SSRS / Power BI Reports.
Will be well versed with the latest T-SQL language features and have experience dealing with large volumes of data.
Qualifications
Solid knowledge and experience with developing complex, hi-performance data cleansing SSIS Packages.
Must possess expert programming and troubleshooting skills
Must possess expert performance tuning skills and dynamic SQL skills
Must be willing to jump into anyone's code at any time to solve the problem
Must be able to reverse engineer anyone else's code and be able to modify it to solve the problem in a better or more efficient way
Application programming experience in .NET .NET, C#, ASP.NET, MVC 5, JavaScript, JSON, JQuery
Demonstrated knowledge in XML and web services
Experience and understanding with unit testing, release procedures, coding design and documentation protocol as well as change management procedures
Proficiency using versioning tools like Git.
Ability to communicate technical information clearly and articulately
Ability to adapt to a rapidly changing environment
In-depth understanding of the systems development life cycle
Proficiency programming in more than one object-oriented programming language
Proficiency using standard desktop applications such as MS Suite and flow-charting tools such as Visio
Proficiency using debugging tools
High critical thinking skills to evaluate alternatives and present solutions that are consistent with business objectives and strategy
Experience mentoring / or leading other development staff
Proven leadership abilities including effective knowledge sharing, conflict resolution, facilitation of open discussions, fairness and displaying appropriate levels of assertiveness
24x7 Production support experience supporting a large scale
Experience with complex indexing strategies including column store indexing
Experience with handling PHI data
Experience with SSAS (MDX or DAX)
Experience in developing Web services
Required Work Experience:
5+ years related work experience, Professional experience with technical design and coding in the IT industry
Required Education:
Related Bachelor's degree or related work experience
29166
IT Developers are responsible for the development, programming, and coding of Information Technology solutions. They will engage in all phases of the software development lifecycle which include: gathering and analyzing user/business system requirements, responding to outages and creating application system models. IT Developers are responsible for documenting detailed system specifications and will participate in evaluating, conducting performance testing, and all planned and unplanned maintenance for both internally developed applications and purchased products. Participate in design meetings and consult with clients to refine, test and debug programs to meet business needs and interact and sometimes direct third party partners in the achievement of business and technology initiatives. IT Developers are responsible for including IT Controls to protect the confidentiality, integrity, as well as availability of the application and data processed or output by the application.
Essential Functions:
Will work as a part of the SQL Development team by designing schema, tables, views, indexed views, developing stored procedures
Create complex queries, SSIS jobs and SSRS / Power BI Reports.
Will be well versed with the latest T-SQL language features and have experience dealing with large volumes of data.
Qualifications
Solid knowledge and experience with developing complex, hi-performance data cleansing SSIS Packages.
Must possess expert programming and troubleshooting skills
Must possess expert performance tuning skills and dynamic SQL skills
Must be willing to jump into anyone's code at any time to solve the problem
Must be able to reverse engineer anyone else's code and be able to modify it to solve the problem in a better or more efficient way
Application programming experience in .NET .NET, C#, ASP.NET, MVC 5, JavaScript, JSON, JQuery
Demonstrated knowledge in XML and web services
Experience and understanding with unit testing, release procedures, coding design and documentation protocol as well as change management procedures
Proficiency using versioning tools like Git.
Ability to communicate technical information clearly and articulately
Ability to adapt to a rapidly changing environment
In-depth understanding of the systems development life cycle
Proficiency programming in more than one object-oriented programming language
Proficiency using standard desktop applications such as MS Suite and flow-charting tools such as Visio
Proficiency using debugging tools
High critical thinking skills to evaluate alternatives and present solutions that are consistent with business objectives and strategy
Experience mentoring / or leading other development staff
Proven leadership abilities including effective knowledge sharing, conflict resolution, facilitation of open discussions, fairness and displaying appropriate levels of assertiveness
24x7 Production support experience supporting a large scale
Experience with complex indexing strategies including column store indexing
Experience with handling PHI data
Experience with SSAS (MDX or DAX)
Experience in developing Web services
Required Work Experience:
5+ years related work experience, Professional experience with technical design and coding in the IT industry
Required Education:
Related Bachelor's degree or related work experience
29166