Senior Software Engineer

Capio Group is looking for an experienced Senior Software Engineer!

Full-time employee - Remote
Salary: $125,000 - $135,000

About Us:
Capio Group is a California-based Information Technology Consulting firm serving the public sector since 2010. We assist the Government in delivering large, complex systems and solutions. Capio Group is a small, but quickly growing firm that mixes good ideas, with great people, to achieve extraordinary results for our clients. We offer the salary and benefits of the bigger companies, with the added bonus of a flexible workplace and a great work-life balance.

Scope of Work:
Capio Group is looking for an experienced Senior Software Engineer to augment its database engineering capacity to support patching and configuration management activities for databases supporting the clients Modernization Division. Under the direction of the clients team, the Senior Software Engineers will be responsible for planning, coordinating, and executing tasks across Enterprise Technology Services (ETS)-related environments. The engineers will work closely with clients application teams, infrastructure support, and vendor partners to ensure that database platforms and low-code/no-code (LCNC) solutions are maintained and developed in accordance with clients standards for performance, availability, and operational continuity. The Senior Software Engineer is responsible for planning and executing patching and configuration activities across enterprise database platforms. This includes coordinating with infrastructure and application teams, validating patch compatibility with LCNC and .NET-based applications, and ensuring compliance with the client operational standards. The Senior Software Engineer also provides technical leadership in scripting, automation, and performance tuning. The Senior Software Engineers must have expert knowledge of the following technologies:
1. Microsoft SQL Server (2016 and newer)
2. Oracle Database (12c and newer)
3. PostgreSQL and MySQL
4. .NET classic and core Framework and .NET Core integration with databases
5. Entity Framework and EF Core
6. SQL Server Agent and job scheduling
7. PowerShell scripting for automation
8. Git-based version control for database scripts
9. Backup and recovery procedures
10. Patching and upgrading of database platforms

As part of the team, the Senior Software Engineer will be responsible for tasks including but not limited to:

•  Plan and execute patching and version upgrades for enterprise database platforms (e.g., SQL
  Server, Oracle, PostgreSQL, MySQL).
• Perform configuration changes to support performance, availability, and compliance with the client standards.
• Coordinating and executing patching schedules for enterprise database platforms (e.g., Microsoft SQL Server, Oracle, PostgreSQL) used within ETS.
• Performing version upgrades, service pack installations, and cumulative updates in development, test, and production environments.
• Supporting pre- and post-patch validation activities, including backup verification, rollback planning, and compatibility testing with the applications.
• Maintaining configuration baselines and ensuring consistency across environments.
• Documenting patching procedures and maintaining records in alignment with client change management processes.
• Collaborating with application and infrastructure teams to minimize downtime and ensure successful deployment of patches and configuration changes.
• Integrating LCNC applications with enterprise systems such as SharePoint, SQL Server, and Dynamics 365, ensuring secure and scalable implementations.
• Supporting governance, lifecycle management, and documentation of Database and LCNC solutions in alignment with client IT standards.
• Providing knowledge transfer and training to client staff on Database and LCNC tools and best practices. Knowledge transfer activities include, but are not limited to, all of the following:
  • Mentorship
  • Guided experience
  • Simulation
  • Work shadowing
  • Paired work

1. Must have a minimum of seven (7) years of full-time working experience in electronic data processing systems study, design, and programming. 
2. Must have at least four (4) years of electronic data processing systems study, design, and programming experience must have been in a lead capacity.
3. Possess a bachelor’s degree in an IT-related or Engineering field. Additional qualifying experience may be substituted on a year-for-year basis. A copy of the degree must be provided upon request.
4. Must have at least four (4) years of full-time working experience in a lead capacity, including oversight of database patching, configuration, and integration with .NET-based applications.
5. Must have at least five (5) years of full-time working experience designing and implementing patching and upgrade strategies for database platforms (e.g., SQL Server, Oracle,
   PostgreSQL), including rollback, validation, and documentation.
6. Must have at least five (5) years of full-time working experience integrating databases with .NET
   Framework (Classic), .NET Core, and Entity Framework, including performance tuning and compatibility testing.
7. Must provide a client/user end reference contact information for each applicable project meeting the requirements and two client references to sign attachments upon request. The reference contact must be a representative of the company for which the project was developed and have performed a management or supervisory role?

1. Possession of certifications such as:
   • AWS Certified Developer - Associate
   • Microsoft Certified Azure Developer Associate
   • Certified Scrum Developer
   • Microsoft Certified: .NET Developer Associate
   A copy of the certification must be provided upon request. 
2. Experience with:
   • DevOps tools (e.g., Jenkins, GitHub, GitLab CI/CD, Docker, Kubernetes
   • Cloud Platforms (AWS, Azure)
   • Microservices architecture
3. Experience with:
   • Optimizing application performance and scalability
   • Profiling tools and performance tuning
4. Experience working in Agile environments using tools like Jira and Confluence.