• Perform database monitoring, performance tuning, and optimization of Oracle databases • Execute version upgrades, patching, and schema changes • Manage data migrations across environments and ensure data consistency • Work with large datasets (terabytes of data) and optimize for high availability and scalability • Ensure database security, backup, and recovery processes are in place and reliable • Collaborate with application and infrastructure teams to support business requirements • Automate routine database administration tasks where possible

• Administer, monitor, and support SQL Server databases on Azure (SQL DB, Managed Instance, SQL on VMs) • Manage backup/recovery, patching, and high availability (AlwaysOn, Geo-replication, Log Shipping) • Tune SQL queries, improve indexing and analyze wait stats, leveraging Redgate, new relic and related tools • Implementing data encryption, managing user access/passwords and ensuring compliance with security standards • Executing, migrating on-premise databases to cloud systems or between cloud providers • Integrate and optimize observability tools such as New Relic APM, RedGate Monitor, and SQL Monitor for real-time diagnostics and alerting • Automate operational tasks using PowerShell, T-SQL, and other scripting tools; contribute to DevOps pipelines • Collaborate with Product Support, DevOps, and SRE teams around release management, deployment automation, and IaC • Ensure cost-effective cloud resource utilization through tagging, right-sizing, and scheduled scaling • Maintain secure access controls and auditing as per FedRAMP High and IL5; support audits and compliance • Participate in a 24x7 on-call rotation for incident response and resolution

Database/SharePoint Support Associate (15.39)   OCT Consulting is a business management and technology consulting firm that supports Federal Government clients. We provide consulting services in the areas of Strategy, Process Improvement, Change Management, Program and Project Management, Acquisition/Procurement, and Information Technology. Responsibilities and Duties OCT currently has an opening for a Database/SharePoint Support Associate to support a client requirement. This position is contingent upon contract award. The Associate serves as the dedicated resource that ensures accuracy, usability, and security in the client's contract data environment. This person will be a SME in modern database and reporting tools, including Microsoft 365 applications, SharePoint Online, and SQL-based systems. Additionally, the Associate will provide support for SharePoint Online architecture, workflows, document libraries, collaboration sites, and integration with Microsoft 365 applications. Day to day responsibilities include:  - Database Development and Maintenance: Design and update database structures, forms, queries, and dashboards to meet evolving acquisition and contracting requirements, leveraging modern tools such as SQL Server, SharePoint Online lists/libraries, and Power Platform. - Testing and Quality Assurance: Conduct functional and regression testing of database modifications to ensure accuracy, reliability, security, and compliance with agency standards - Documentation: Prepare and maintain technical documentation for database objects, workflows, integrations, and user guidance to support continuity of operations and knowledge transfer - Reporting and Analytics: Develop and refine reports, queries, and interactive dashboards using Power BI and other analytics tools to provide actionable insights into acquisition activities, contract status, and resource utilization -- responding to queries and questions as needed. - Transition Support: Assist in possible migration to a new integrated contract writing and financial management system, including creation of a legacy data repository to preserve historical records, ensure data integrity, and enable seamless access to archived information. - Technical Expertise: Provide advisory support and troubleshooting for database-related issues, leveraging SME-level proficiency in Microsoft 365, Power Platform, SharePoint Online, and SQL-based solutions to optimize performance, usability, and scalability. - Data Extraction & Validation: Extract and validate contract and procurement data, ensuring accuracy, completeness, and consistency of all outputs to support reliable acquisition decision-making.  - Contract Data Analytics: Produce recurring reports and conduct trend analyses on obligations, expenditures, and contract actions, identifying anomalies, compliance risks, and inefficiencies to strengthen oversight and improve contract execution. - Administration and Maintenance: Maintain and update SharePoint Online tools, applications, and site collections. Ensure compliance with governance, security, and data management policies. - Workflow and Automation: Develop, configure, and maintain workflows using modern tools such as Power Automate and Power Apps, while supporting legacy workflows created in SharePoint Designer as needed. Troubleshoot and de-bug broken workflows, codes, and previously developed tools as needed.  - Collaboration and Integration: Partner with Government staff to design, implement, and evolve SharePoint solutions that support contracting tools, workflows, and business processes. Integrate SharePoint with other Microsoft 365 services (Teams, OneDrive, Outlook) to enhance collaboration and efficiency. - Documentation and Reporting: Document processes, configurations, and procedures required for effective management, reporting, and auditing of SharePoint activities. Provide user guidance and training materials to support adoption. - Continuous Improvement: Recommend and implement enhancements to improve usability, efficiency, and performance of the SharePoint environment, ensuring alignment with operational and strategic objectives.

• Accountable for the operational excellence and business continuity of enterprise database infrastructure • Advanced performance tuning of database systems and SQL workloads • Design and maintain enterprise-grade High Availability and Disaster Recovery architectures • Provide and maintain detailed technical documentation on Database Lifecycle Management • Mentor other Database Administrators • Implement effective security protocols and data protection measures