We are looking to add a Mid-Level back-end Java or .Net developer with very strong Microsoft SQL Server skills to build a new application for a large federal agency. Candidate should have at least five years of hands-on experience as a back-end developer with direct experience designing and implementing database schemas, stored procedures, triggers, as well as index tuning and performance tuning. Candidate should also have hands-on experience with data migration from legacy to new application databases. The successful candidate for this role will have experience directly working with SQL Server Management studio using designers and scripting to manage database scheme objects.
Candidate should also have a strong background in Object Oriented Programming in either .NET or Java Spring Boot including REST API development, layered architecture, separation of concerns and other SOLID principles.
Experience with ETL for reporting using standard SQL Server tools is a plus.
Duties and Responsibilities:
- Design database schema to house data migrated from existing databases.
- Develop database indexes to support efficient data retrieval and searching
- Develop REST API endpoints to efficiently search and retrieve data
- Follow Change Management procedures to implement database configuration changes
- Experience working with SQL Server 2016 and above on virtual servers
- Experience with database migration and in-place upgrade
- Experience with SQL and T-SQL. Creating tables, indexes, stored procedures, views, triggers, and functions.
- Experience with traditional database operations including transaction processing and issues of database integrity, scalability, database backup, recovery, and standardization in a large-scale environment
- Experience in debugging performance, load, and concurrent use issues in a distributed, multitiered architecture including the development or integration of application services and/or shared components to address needs like user authentication, security, version control, authorization, etc.
- Experience in design, integration and test of application interfaces to system databases
- Self-motivated and directed, with keen attention to detail
- Experience working in a team-oriented, collaborative environment
- Good written and oral communication skills
- Experience working with DISA STIGs
- Experience working with PowerShell or developing custom scripts a plus
- CICD experience with Jenkins a plus.
- AWS certification and/or experience a plus.
- Experience developing Lambda functions a plus.
- Bachelor's Degree in Information Systems or Computer Sciences
- 5+ years of experience in database engineering
- SQL Server Certification a plus
- US Citizenship is required.
- Candidate must be able to obtain Public Trust Clearance
- This position is currently remote but may require occasional onsite presence.
Flexible work from home options available.