SQL Database Administrator

*** no c2c * *** W2 only; Web Cam Interview***Remote***

Scope of the project:

The Child and Adult Protection Services Applications Team is part  is responsible for developing and maintaining applications in support of the Client

Daily duties / responsibilities:

• The Client seeks a highly motivated individual who has the skills and experience of designing, developing and supporting enterprise scale web applications on the Microsoft .NET platform for Child Welfare applications under the Client.
• Candidate should be an experienced developer in visual interfaces, application logic, database design and web services construction on the Microsoft Windows platform.
•  In addition, they should be familiar with the most effective and efficient product development using Microsoft Visual Studio 2022, C#, VB.Net, ASP.NET, ASP.NET Core, ASP.NET MVC 4, Entity Framework or higher, jQuery, Angular, Web Forms, MS SQL Server 2016/2019 Enterprise Server (including SQL Server Reporting Services) and TFS (Team Foundation Server). T
• his includes code development, database/script development, unit testing, source code management, build management, integration testing, and deployment.
• Take initiative in performance, working independently and with groups to effectively accomplish project objectives and engage in the following:
• Interact with other software engineers and technical leaders to understand subsystem and component specifications and recommend changes to facilitate efficient and effective development.
• Review design and code of existing systems to determine potential issues and provide suitable recommendations to improve code quality.
• Design and document subsystems and system components consisting of (in OO terms) several objects working together to execute an encapsulated function of the larger system.
• Implement and debug subsystems and components.
• Write and execute tests for subsystems and components.
• Participate in integrated test sessions of components and subsystems on test and production servers
• Determine and communicate the implications of system-level decisions on subsystems and components and help determine how best to mitigate or take advantage of these implications.
• Determine and communicate the requirements and capabilities of components within the context of the larger system, project, and team.
• Support management of the team''s technical infrastructure (e.g., repository, build system, testing system) under guidance from the engineers or other project leads.
• Support technical oversight activities using automated monitoring scripts
• Perform tasks efficiently and work together with team to ensure project success.

Required skills (rank in order of importance):

• 7+ years of experience independently designing and implementing medium to large-scale software systems and components using MICROSOFT .net architecture.
• 5+ years experience developing data-driven applications utilizing significant relational database engines as part of the overall application architecture.
• 5+ years experience building and deploying web-based software systems, utilizing N-tier architectures, dynamic content, highly scalable approaches, and complex security models/implementations
• 3+ years of experience with Angular Framework (version 15+)

Preferred skills (rank in order of importance):

• Experience with Agile software development is a plus.
• Experience with performance, security, and regression testing tools

Required education:

• BS Degree or equivalent work experience

Environments and tools:

• MS SQL 2016/2019 Database Server (Must, Minimum 8 years)
• MS SQL 2014/2016 Reporting Services (Recommended, Minimum 2 years)
• Azure DevOps (Must, Minimum 3 years)
• Microsoft Visual Studio 2019/2022 (Must, Minimum 6 years)
• C#, VB, ASP.NET, .NET (Must, Minimum 8 years)
• ASP.NET MVC 4 or higher (Must, Minimum 3 years)
• WCF (Must, Minimum 5 years)
• Angular (Must, Minimum 3 years)
• Entity Framework 6 (Must, Minimum 3 years)

Additional skills:

• Knowledge of Microsoft operating systems and at least two application, database, messaging or web server systems.
• Successful design and implementation of multiple software components and subsystems.
• Ability to communicate the design and implementation of software systems including relevant strengths/weaknesses and reasons for implementation decisions.
• Ability to communicate (orally and written) effectively with technical, non-technical staff, and customers/stakeholders as needed or directed.
• POWERSHELL SCRIPTING (RECOMMENDED, MINIMUM 2 YEARS)
• Windows server 2016/2019 management (Active directory, IIS) (RECOMMENDED, MINIMUM 2 years)
• JQuery – Must 3 years, Java script ES6+
• Knowledge of reactive programing using RxJs (Observables, subjects, Operators)
• Angular CLI must 3 years Project scaffolding and management
• ANGULAR FRAMEWORK: Through understanding for latest version angualr 15+
• Responsive Design
• Ability to communicate effectively with the DSS and other State information technology staff