Database/SharePoint Support Associate (15.39)

OCT Consulting LLC; Washington (District of Columbia); On-site; USD 90,000 - 110,000; Full time

Benefits offered by this job

Medical, Dental, and Vision insurance

401K plan with employer contribution

Paid Time Off

Life Insurance

Training benefits

Job summary

A consulting firm is seeking a Database and SharePoint Administrator to design, update, and maintain database structures and SharePoint solutions. The ideal candidate will have a Bachelor's degree in Information Technology, alongside 5-8 years of experience in database support or SharePoint administration. They will work fully remote, providing advisory support, conducting testing, and developing reports using SQL and Power BI. The role offers a competitive salary range between $90,000 and $110,000 per year with comprehensive benefits.

Qualifications

• 5-8 years’ experience in database support or SharePoint administration roles.
• Direct experience designing, developing, testing, documenting, and maintaining SharePoint environments and sites.
• Ability to obtain and maintain required security clearance.

Responsibilities

• Design and update database structures and dashboards using SQL Server and Power Platform.
• Prepare and maintain technical documentation for database objects and workflows.
• Develop reports and dashboards with Power BI for actionable insights.

Skills

SQL Server

SharePoint Online

Power BI

Power Automate

Microsoft 365 applications

Database support

Education

Bachelor's degree in Information Technology or related field

Job description

Responsibilities

• Design and update database structures, forms, queries, and dashboards using SQL Server, SharePoint Online lists/libraries, and Power Platform.
• Conduct functional and regression testing of database modifications to ensure accuracy, reliability, security, and compliance with agency standards.
• Prepare and maintain technical documentation for database objects, workflows, integrations, and user guidance.
• Develop reports, queries, and interactive dashboards with Power BI and other analytics tools to provide actionable insights.
• Assist in possible migration to a new integrated contract writing and financial management system, creating a legacy data repository to preserve historical records.
• Provide advisory support and troubleshooting for database-related issues, optimizing performance, usability, and scalability.
• Extract and validate contract and procurement data ensuring accuracy, completeness, and consistency.
• Produce recurring reports and conduct trend analyses on obligations, expenditures, and contract actions.
• Maintain and update SharePoint Online tools, applications, and site collections, ensuring compliance with governance, security, and data management policies.
• Develop, configure, and maintain workflows using Power Automate and Power Apps, supporting legacy SharePoint Designer workflows as needed.
• Partner with Government staff to design, implement, and evolve SharePoint solutions supporting contracting tools, workflows, and business processes.
• Integrate SharePoint with Microsoft 365 services (Teams, OneDrive, Outlook) to enhance collaboration and efficiency.
• Document processes, configurations, and procedures for effective management, reporting, and auditing of SharePoint activities.
• Recommend and implement enhancements to improve usability, efficiency, and performance of the SharePoint environment.

Qualifications

• Bachelor's degree in Information Technology or related field.
• 5-8 years’ experience in database support or SharePoint administration roles.
• Direct experience designing, developing, testing, documenting, and maintaining SharePoint environments and sites.
• Proficiency in SQL Server, including query writing and database design.
• Highly proficient in Microsoft 365 applications (Excel, Power BI).
• Experience utilizing Power BI and other analytics tools to develop reports, queries, and dashboards.
• Experience supporting development of workflows and applications using Power Automate and Power Apps.
• Ability to obtain and maintain required security clearance; background investigation may involve credit, fingerprint, and law enforcement agency checks.
• Fully remote/telework position requiring video during Microsoft Teams meetings when directed.

Benefits

• Medical, Dental, and Vision insurance.
• Retirement savings 401K plan with 3% employer contribution.
• Paid Time Off and Standard Government Holidays.
• Life Insurance, Short- and Long-Term disability benefits.
• Training benefits.

Salary Range

$90,000 - $110,000 yearly commensurate with experience, education, etc.