AMSG is seeking a Database Developer/Administrator to support, maintain, and enhance our Microsoft SQL Server environment in support of the Department of Veterans Acquisition Academy located in Fredrick, Maryland.
AMSG supports a variety of programs for the Department of Defense (DoD), Department of Veterans Affairs (VA), Defense Health Agency (DHA), Department of Homeland Security (DHS), Washington Headquarters Service (WHS), and the Federal Trade Commission (FTC). We take pride in our great work environment and highly motivated company.
We offer a competitive benefits package (medical, dental, vision, flexible paid time off, referral bonuses) and numerous training opportunities for professional development and growth.
Apply today and join our team of talented professionals!
Location: 100% Remote with potential monthly team meetings with the customer at the VA Academy in Frederick, MD
Education: A Bachelor’s degree from an accredited college or university is required.
Years of Experience: Minimum of four (4) years of relevant experience
Clearance: Ability to obtain and maintain a Public Trust
Description/Scope:
- The ideal candidate will manage database performance, security, and reliability, while also developing SQL Server Reporting Services (SSRS) reports to support business needs.
- This role requires experience creating and managing SQL Server jobs for data loading and integration. Familiarity with Power BI dashboard development, as well as Power Apps and Power Automate, is a plus but not required. This role requires experience creating and managing SQL Server jobs for data loading and integration. Experience with the Power Automate SQL Server connector to build automated workflows that interact with SQL Server is strongly preferred. Familiarity with Power BI dashboard development, as well as Power Apps, is a plus but not required.
Responsibilities:
- Administer, monitor, and optimize Microsoft SQL Server databases.
- Develop, deploy, and maintain SSRS reports.
- Create and manage SQL Server jobs to automate database loading and updates.
- Ensure database performance, reliability, backups, and security compliance.
- Collaborate with stakeholders to translate business requirements into data solutions.
- Support business intelligence and automation initiatives with Power BI, PowerApps, and Power Automate, including designing flows that leverage the SQL Server connector for data integration, updates and notifications.
Qualifications:
- Proven experience with Microsoft SQL Server administration and development.
- Strong skills in SQL, stored procedures, and SSRS reporting.
- Experience designing and scheduling SQL Server jobs (SQL Agent).
- Knowledge of database performance tuning and troubleshooting.
- Hands-on experience with power automate, specifically using the SQL Server connector to build automated workflows involving triggers, actions, and secure connections.
- Familiarity with Power BI, PowerApps, or Power Automate preferred.