Responsibilities and Duties:
- Analyzing highly complex business requirements, writing technical specifications for the design or redesign of complex computer platforms and applications.
- Performance and application tuning solutions for the design/build of new applications and work on existing applications.
- Create and configure automation of testing, builds and deployments.
- Create and configure monitoring of processes, operations, systems and applications.
- Collaborate with development team on the design and development of internal custom applications and solutions.
- Develop, improve and maintain Microsoft SQL based applications (tables, indexes, constraints, stored procedures, functions, triggers)
- Completes applications and systems development and configuration by coordinating requirements, schedules, and activities; contributing to team meetings; troubleshooting development and production problems across multiple environments and operating platforms.
- Supports users by developing new documentation and departmental technical procedures.
- Updates job knowledge by researching new technologies and software products; participating in educational opportunities; reading professional publications; maintaining personal networks; participating in professional organizations.
- Develop programming code and software modifications using appropriate languages and tools to provide responsive and innovative solutions and new functionality in enterprise-wide and/or complex specialized systems.
- Research, design, and develop prototypes using best practice and technologies to demonstrate utility, productivity enhancements, and cost savings.
- Participate in peer-reviews of solution designs and related code.
- Package and support deployment of code releases.
- Adhere to high-quality development principles while delivering solutions on-time and on-budget.
- Design integrated solutions which may include applications, databases, networks, and related systems.
- Design database systems and programs to meet business requirements.
Knowledge, Skills, and Abilities
- This individual will possess a combination of business knowledge, technical skills, and people skills to define and guide business strategies.
- Advanced and comprehensive knowledge of applications systems development and the systems they support, along with knowledge of other information technology functions to apply a broad and interactive perspective to systems development and configuration.
- Knowledge of integration and deployment tools, automation, hosting and systems.
- Ability to define business objectives by analyzing user requirements; envisioning system features and functionality.
- Web development experience using ASP.NET, VB.NET/C#, JavaScript and MS SQL or similar
- Experience with one or more CI/CD tools
- Experience with monitoring software for web based solutions
- Experience with automation of testing
- Experience creating and editing T-SQL code including complex stored procedures
- History working in an Agile/Scrum environment
- Ability to troubleshoot software and processes to determine the root cause and develop the corresponding solutions
- Experience with application deployment with Team Foundation Server / GIT or other source code repositories
- Excellent teamwork skills
- Attention to detail
- Writing and Documentation skills, someone who can listen to the user issues, come up with a solution, and communicate that back.
- High-energy, enthusiastic, and dependable individual who excels in challenging and competitive environments
- Ability to work independently and as a member of a diverse team
- Thorough knowledge and utilization of the Software Development Life Cycle (SDLC) process - including analysis, design, coding, system and user testing, problem resolution and planning
- Strong technical skills including a broad understanding of relational databases, file processing, application development, SQL and web-enabling technologies
- Ability to work on multiple projects, ranging from simple to high complexity
- Ability to communicate effectively, both verbally and written, with subordinates, peers, and leaders at all levels of management - Able to build strong working relationships with customers and department leads
- Strong analytical and problem-solving skills
- Orientation toward customer service and responsiveness to customer needs
- Excellent problem solving and decision making skills to analyze data and reports, conduct research, develop plans, estimate effort, document and communicate information to others
- The following areas and skills are desired to best perform the job:
- Web Based Development
- C# / .NET or similar (Java)
- HTML5/CSS
- Monitoring (NewRelic, Zabbix, etc.)
- JavaScript Frameworks (Angular)
- JQuery / JQuery UI
- Restful APIs / WebAPI
- Web Services / WCF
- Entity Framework / ORM
- CI/CD (TFS, Jenkins, Octopus, Team City, etc.)
- T-SQL /Complex Stored Procedures/ SQL Reporting