Need expertise in repairing a damaged sql database on a windows pro 10 workstation running sql 2014. small database called amicus. Need someone to remote in a work together with me to fix this tonight. specifically looks like running a Complete a full database consistency check (DBCC CHECKDB) to fix the mdf file.

The Senior Microsoft SQL Server DBE owns the health, performance, and scalability of Greenshades's database estate as the company accelerates on its growth path. This is a senior, hands-on technical leadership role and the deepest SQL Server expert in the organization, responsible for setting the standards that developers and infrastructure engineers follow. The role spans high-volume transactional (OLTP) and analytical workloads, with a primary focus on performance tuning, developer partnership, and architecting the redundancy and capacity patterns that keep systems fast and available at scale. Responsibilities Lead all aspects of SQL Server performance optimization, including query, index, and execution-plan analysis using Query Store, Extended Events, DMVs, Activity Monitor, and execution-plan tooling. Design and maintain effective indexing strategies, statistics, and partitioning schemes for large tables. Identify and eliminate blocking, deadlocks, parameter sniffing issues, and tempdb contention. Tune server-level configuration (memory, MAXDOP, cost threshold for parallelism, instant file initialization) for workload requirements. Establish performance baselines, monitoring, and alerting to catch regressions before they impact customers. Review schema designs, stored procedures, and queries prior to release; coach developers on set-based logic, indexing, and efficient T-SQL. Define and document database development standards, code-review guidelines, and anti-patterns to avoid. Help developers interpret execution plans and understand the performance implications of design decisions. Support safe schema-change and migration practices within CI/CD pipelines.

We’re a managed service provider (MSP) looking to build a relationship with a reliable Microsoft SQL Server expert for occasional, scheduled assistance. This is not a full-time role—most work is planned in advance and brought in as needed. What we need help with: SQL Server upgrades (version upgrades, in-place vs. side-by-side guidance) Backup/restore strategy and validation (including test restores) General consulting & best practices (configuration, maintenance plans, DB health) Performance troubleshooting when needed (indexing, query tuning, waits, tempdb, etc.) Basic security/hardening guidance (permissions, least privilege, patching approach) Documentation of recommendations and changes made Environment (typical): Microsoft SQL Server (on-prem and/or hosted Windows Server environments) Supporting SMB clients with line-of-business applications Remote work with scheduled maintenance windows What we’re looking for: Strong hands-on experience with SQL Server administration Comfortable advising an MSP team and client stakeholders Ability to provide clear, written recommendations and a simple runbook when applicable Responsive communication and reliability for scheduled work Bonus: Experience with HA/DR (Always On, clustering, log shipping), SQL licensing considerations, and monitoring tools Engagement details: As-needed hours (typically light volume) Work is almost always scheduled (rare emergency help) Remote; we’ll coordinate access and maintenance windows

I am migrating data that is currently in a data management platform with a SQL backend. The export needs to be in a flat file format containing specific data from some of the tables, as well as link paths to physical files. The necessary data is spread across multiple tables in the database. We will need to be able to run it against roughly 50 database, one for each project in the document management system. This project will start ASAP and need to kick off in short order.

We are looking for a senior consultant to help stabilize and improve our Jet Analytics / Jet Reports / SQL Server / SSAS cube environment connected to a heavily customized Microsoft Dynamics NAV 2016 system. Our current cube environment is unreliable and periodically goes down or fails to refresh properly. We need someone who can diagnose the root cause, stabilize the environment, improve cube refresh reliability, and advise whether parts of the current cube should be repaired, refactored, or rebuilt. This is not a basic Jet Reports report-writing project. This is also not a general Power BI dashboard project. We need someone with hands-on technical experience across Jet Analytics, Jet Data Manager, SQL Server, SSAS / OLAP cubes, data warehouse design, and Dynamics NAV data structures. Current Environment: - Microsoft Dynamics NAV 2016 - Heavily customized NAV environment - LS Retail embedded - Jet Reports / Jet Analytics - SQL Server - SSAS / OLAP cube environment - Reporting environment used for business visibility and operational reporting Primary Goals: - Determine why the cube environment is unstable. - Stabilize Jet Analytics / Jet Data Manager processing. - Improve SQL Server / SSAS cube refresh reliability. - Review and improve job scheduling, processing sequence, and monitoring. - Identify whether the current cube should be repaired, refactored, or partially rebuilt. - Establish a longer-term support relationship if the fit is strong. Responsibilities: - Review the current Jet Analytics / Jet Reports configuration. - Review Jet Data Manager projects, execution packages, and dependencies. - Review SQL Server databases, SQL Server Agent jobs, job schedules, and job history. - Review SSAS cube structure, processing history, refresh failures, and performance indicators. - Analyze relevant SQL Server logs, SSAS logs, Windows event logs, and application errors. - Identify failure points causing the cube to go down or fail refreshes. - Diagnose whether issues are related to Jet, SQL Server, SSAS, infrastructure, data quality, permissions, resource constraints, or cube design. - Recommend stabilization steps. - Implement approved fixes where appropriate. - Improve monitoring and alerting for cube refresh failures. - Tune SQL Server / SSAS performance where appropriate. - Review data warehouse and dimensional model design. - Validate cube outputs against Dynamics NAV source data where needed. - Document findings, support procedures, and recovery steps. - Provide knowledge transfer to our internal IT team. Required Experience: - Hands-on experience with Jet Analytics and/or Jet Data Manager. - Experience with Jet Reports using cube-based reporting. - Strong Microsoft SQL Server experience. - Strong SSAS / OLAP cube experience. - Experience troubleshooting cube processing failures. - Experience with SQL Server Agent jobs, ETL scheduling, and refresh automation. - Experience with data warehouse design and dimensional modeling. - Experience working with Microsoft Dynamics NAV / Navision data structures. - Ability to troubleshoot across application, database, cube, and infrastructure layers. - Ability to work independently and explain findings clearly. Preferred Experience: - Dynamics NAV 2016 experience. - LS Retail experience. - Experience with heavily customized NAV environments. - Retail, hospitality, museum, zoo, aquarium, resort, or destination retail reporting experience. - Power BI experience against SSAS or cube-based sources. - Experience stabilizing legacy BI environments. - Experience creating monitoring, alerting, and operational runbooks. - Experience providing ongoing fractional support after an initial assessment. Initial Engagement: We would like to begin with a paid diagnostic / health-check engagement. Expected initial deliverables: - Current-state architecture review. - Root-cause analysis of cube instability. - Review of Jet Analytics / Jet Data Manager configuration. - Review of SQL Server / SSAS jobs, logs, schedules, and processing history. - Identification of major failure points and risks. - Recommended stabilization plan. - Estimate for remediation and ongoing support. Potential Ongoing Work: If the initial engagement is successful, we may continue with: - Stabilization project work. - Cube refactoring or rebuild support. - Monitoring and alerting improvements. - Ongoing fractional support. - Monthly health checks. - Report/cube enhancement support. - Knowledge transfer and documentation. How We Like to Work: - We prefer clear communication and practical recommendations. - We value root-cause analysis over temporary fixes. - We are comfortable starting with a focused diagnostic before committing to a larger engagement. - We prefer a consultant who can explain findings clearly to both technical and business stakeholders. - We want documentation and knowledge transfer, not a black-box support relationship. - We are looking to build a longer-term working relationship with the right person. Preferred Time Zones: Pacific or Mountain Time preferred due to IT team coverage in California and Utah. U.S.-based candidates in other time zones may still be considered if they can regularly support Pacific/Mountain business hours. Rate: Open to consultant's proposed rate based on experience. Please state your hourly rate in your response. We are more concerned with finding the right senior specialist than the lowest rate. The right fit will have hands-on experience with Jet Analytics / Jet Data Manager, SQL Server, SSAS / OLAP cubes, and Dynamics NAV. Screening Questions: Please answer these in your response. 1. Have you personally worked with Jet Analytics or Jet Data Manager, not just Jet Reports? 2. Have you supported SSAS / OLAP cube environments in production? 3. Have you diagnosed cube processing failures or unreliable cube refresh jobs? 4. Have you worked with Microsoft Dynamics NAV / Navision data structures? 5. Have you worked with NAV 2016 or older NAV environments? 6. Have you worked with LS Retail or retail ERP environments? 7. What logs or tools would you review first when a Jet / SSAS cube keeps failing or going down? 8. How would you determine whether the issue is Jet-related, SQL Server-related, SSAS-related, data-related, or infrastructure-related? 9. What is your hourly rate for this type of work, and would you recommend starting with an hourly diagnostic or a fixed-price health check? 10. Are you open to a longer-term fractional support relationship after the initial diagnostic? 11. Please describe one similar BI/cube/reporting reliability issue you have resolved. Important: Please do not apply if your experience is limited to basic Jet Reports report writing or Power BI dashboard development. This role requires backend Jet Analytics, SQL Server, SSAS, cube processing, and Dynamics NAV troubleshooting experience.

I’m looking for an experienced freelancer to help with ongoing Microsoft SQL Server administration/development and C# service development. Work may include SQL Server maintenance, backups/restores, SQL Agent jobs, stored procedures, query tuning, troubleshooting, database health checks, and general database support. I also need help with C# services, background processes, integrations, and data-processing tasks that interact with SQL Server. Ideal candidate should have strong hands-on experience with: Microsoft SQL Server Administration T-SQL / Stored Procedures Performance tuning and troubleshooting SQL Agent jobs and maintenance C# / .NET service development Windows services or background services API or data integration experience This may start as part-time or project-based work, with potential for ongoing support. Please include examples of similar SQL Server and C# service work you’ve done.

ABOUT US We are a CMMC 2.0 Level 2 and ISO 27001:2022 certified federal systems integration company supporting Department of Defense and federal customers in classified and CMMC-regulated environments. OVERVIEW Looking for an experienced SQL Server DBA to upgrade Windows Server and SQL Server, consolidate two production databases onto a single instance, harden the OS and SQL for CMMC compliance, and document all work for audit purposes. We are looking for a consultant who enjoys documenting their work. High-quality documentation is just as important as technical execution. SCOPE OF WORK OS Upgrade Upgrade host OS from Windows Server 2019 to Windows Server 2025. SQL Server Upgrade Upgrade SQL Server 2019 Standard Edition (4-core, per-core licensing) to SQL Server 2025 Standard Edition. Server currently hosts our ERP database (Solutions360 Q360 v24). Database Consolidation Migrate the Genetec Security Center database from its current dedicated SQL server onto the existing Q360 ERP SQL Server instance. This includes creating the Genetec database on the shared instance, reconfiguring the Genetec Security Center server connection string to point to the new location, and configuring appropriate resource allocation between workloads (memory allocation, TempDB configuration, and workload management as appropriate). This is not a high-transaction SQL environment. The ERP and physical security databases support approximately 30 internal users. Downtime is acceptable as all production work will be performed after hours or on weekends. Please describe your proposed migration approach and expected outage window in your proposal. Server and SQL Server Hardening Harden both the Windows Server 2025 operating system and the SQL Server instance consistent with CMMC 2.0 Level 2 and ISO 27001:2022 requirements. We expect the consultant to recommend appropriate hardening frameworks (such as DISA STIG and/or CIS Benchmarks), implement applicable controls, and document any justified deviations. Screenshots of all configuration changes are required as evidence artifacts for ISO 27001 and CMMC audit purposes. Backup and Rollback Prior to any production changes, verify a tested backup exists and provide a documented rollback plan for each phase of the work. DELIVERABLES Migration and upgrade plan Upgrade and configuration documentation Hardening checklist, configuration baseline, and documented exceptions Screenshot evidence artifacts for ISO and CMMC compliance Successful validation of ERP (Solutions360) and Genetec database functionality following migration Rollback documentation Knowledge transfer session with our MSP ENVIRONMENT AND ACCESS Remote or on-site at our Sterling, VA office (Loudoun County) Remote access provided via ConnectWise tunnel through our managed service provider (MSP) MSP provides just-in-time administrative access to the SQL server ERP vendor (Solutions360) available to provide technical guidance on their application's database requirements Both the MSP and ERP vendor contacts will be introduced at kickoff We expect the consultant to work directly with our MSP during implementation. The MSP will retain administrative control of the environment. This engagement assumes an in-place upgrade of the existing virtual machine unless the consultant recommends a substantially lower-risk alternative All production work must occur after hours or on weekends SQL Server 2019 Standard Edition, 4-core per-core licensing already owned Windows Server 2025 licensing already owned Backups are performed using Veeam Backup and Replication Environment details including SQL patch level and current Windows Server build will be provided during kickoff Current environment: single Windows Server 2019 VM, 4 vCPUs, approximately 3 TB total disk, supporting a 30-person organization with relatively small databases REQUIREMENTS US citizenship required (no exceptions; federal compliance environment) Extensive SQL Server upgrade and migration experience Experience hardening SQL Server for CMMC or ISO 27001 compliance environments Familiarity with running multiple application databases on a shared SQL instance Comfortable working through remote access tools with MSP-managed infrastructure Must be able to provide documentation of changes for compliance audit trail NICE TO HAVE Experience migrating or supporting Genetec Security Center SQL databases Experience with Solutions360 Q360 ERP CMMC or FedRAMP environment experience SQL Server clustering or Always On experience Relevant certifications (Microsoft Data Platform, CISSP, etc.) BUDGET AND TIMELINE Hourly engagement; submit your estimated hours and hourly rate based on the scope above Flexible on scheduling; work can be performed after hours or on weekends (Eastern time) Potential for ongoing relationship including annual compliance reviews, future upgrades, and ad hoc DBA support TO APPLY Please provide: One example of a similar SQL Server migration you have completed One example of SQL Server hardening work in a compliance environment Relevant certifications Your estimated hours and hourly rate for the defined scope Earliest available start date

We're a small US-based B2B SaaS company building a multi-tenant platform for in-building wireless / RF analytics (drive-test and DAS measurement data). Our measurement store is Azure SQL Database using a clustered columnstore index (CCI) with partitioning, on a vCore Business Critical tier, with read-committed snapshot isolation on. Backend is Python 3.12 / FastAPI talking to the DB via SQLAlchemy + pyodbc (ODBC Driver 18), authenticating through an Azure managed identity. We've just completed an internal CCI benchmark (compression, query latency, and bulk-load throughput on a ~7.5M-row corpus) and have a handful of interpretation-level decisions where we want an experienced second opinion specifically on Azure SQL Database (PaaS) behavior — not generic SQL Server. This is advisory: reviewing our benchmark findings and answering pointed questions, not writing production code. Initial scope (est. 3 hours, async + one or two calls): Sanity-check our warm-vs-cold columnstore query results and help us reason about cold-start behavior on Azure SQL DB, given that DBCC DROPCLEANBUFFERS isn't available on PaaS. How should we honestly characterize and mitigate a ~3s cold first-touch on a columnstore heatmap scan? Advise on service-tier choice: is Business Critical the right steady-state for a small-customer-base workload, or is General Purpose (or a smaller BC) defensible? How would each affect cold columnstore reads and cost? Review our bulk-load approach: pyodbc fast_executemany (we measured ~53× speedup), batch/commit strategy, and the DECIMAL-binding correctness concern under Driver 18. Are there Azure-native load paths we should prefer given managed-identity auth constraints (which ruled out bcp for us)? Comment on CCI ordering / partitioning choices for compression and segment elimination on our query patterns. If the fit is good, we'd like to keep you on a light ongoing retainer as our escalation path for Azure-SQL-specific questions (a few hours a month, on-call). You're a strong fit if you've operated clustered columnstore indexes at scale on Azure SQL Database specifically (not just SQL Server on-prem or on a VM), understand the PaaS differences in tiering / IO / diagnostics, and can explain tradeoffs clearly to a technical-but-not-DBA audience. We value people who say "it depends, and here's on what" over confident one-liners.

Overview: We are seeking an organized, detail-oriented, and experienced Data Migration & Cleansing Specialist based in the United States to help prepare, clean, and organize legacy data for critical system migrations. Our primary goal is to ensure that only accurate, deduplicated, and perfectly formatted data enters our new target platform. This is a hands-on technical role requiring someone who can quickly spot database anomalies, map disparate data structures, and systematically execute automated or semi-automated data cleansing rules. Key Responsibilities: Data Profiling: Review and assess our current source datasets to identify data quality issues, missing fields, structural discrepancies, and duplicates. Data Cleansing: Execute deduplication, standardize inconsistent text/phone/email formatting, correct structural errors, and safely filter out outdated or corrupted historical entries. Data Mapping: Document and implement logic to map data fields from our legacy schemas to align seamlessly with the new system's requirements. Validation & Verification: Run post-cleansing validation checks to ensure zero data loss and verify absolute data integrity prior to the final migration push. Required Qualifications & Technical Skills: Location: Must be physically located in the United States (strict requirement for data sensitivity and compliance). Tools: Advanced proficiency with Excel (Power Query, advanced formulas, text manipulation) and/or robust SQL querying skills. Experience: Proven track record working on at least 1–2 data migration, consolidation, or database cleanup projects. Communication: Strong analytical reasoning and the ability to clearly document your transformation logic so our team can follow your steps. Preferred but not required: Experience writing Python script (Pandas) or using dedicated ETL tools.

About the Company We're a B2B distributor of medical, industrial, and veterinary supplies based in Minnesota. Our team operates on a Microsoft-first stack — Microsoft Dynamics GP (Great Plains) as our ERP, SalesPad for order management, SQL Server as our data backbone, and Microsoft 365 across the organization. We're building out a reporting and analytics function to give our sales team and leadership better visibility into the business. What We're Building We need an experienced Power BI developer to work alongside our internal data specialist and sales team to design, build, and deliver a suite of operational dashboards. This is a hands-on development role — you'll be writing DAX, building data models, and working directly with SQL Server as your data source. Initial dashboards will include: Sales by item, item category, and product line Sales by customer and customer segment Sales by rep and sales territory Order volume and revenue trends over time Year-over-year and period-over-period comparisons Item cross reference self-service tools Your Responsibilities Connect Power BI Desktop to SQL Server (via ODBC/DirectQuery or import mode) and build clean, performant data models Write T-SQL queries and views against Dynamics GP tables (SOP, RM, IV modules) and SalesPad tables as the reporting layer Collaborate with our internal data specialist on schema, table relationships, and data definitions Work with our sales team to understand reporting requirements and translate them into dashboard designs Build and publish reports to Power BI Service for sharing across the organization Document your data models, measures, and report logic so work is maintainable internally Required Skills & Experience 3+ years of Power BI development experience (Desktop + Service) Strong T-SQL — you'll be writing queries against GP's table structure (SOP30200, RM00101, IV00101, etc.), not just connecting to a clean data warehouse Experience building star-schema or similar data models in Power BI Proficient in DAX for calculated measures, time intelligence, and KPIs Comfortable working directly with source ERP databases — no pre-built connectors here Strong communication skills — you'll need to translate business questions into data requirements Nice to Have Prior experience with Microsoft Dynamics GP or similar ERP (SAP B1, Sage, Acumatica) Familiarity with SalesPad or distribution/supply chain business processes Experience with Power BI incremental refresh and row-level security (RLS) Experience publishing to Power BI Service and scheduling dataset refreshes