SQL Database Consultant

Our goal is to solve problems and deliver results for our clients. At Cloud and Things, you can be a part of transforming the public sector’s IT environment. Our team is on the forefront of helping to solve the government's most complex IT challenges. If you are seeking a role that offers the opportunity to work on rewarding projects, consider a career with Cloud and Things.  *This is an exempt position. Salary commensurate with experience*Overview:Location: Hybrid – New York, NYSalary: $125,000 - $150,000We are seeking an SQL Database Consultant who will support our client to lead the migration, upgrade, and optimization of complex SQL Server environments. This role will help ensure a seamless transition to SQL Server 2022 by supporting database restoration, reporting and integration updates, system testing, and post-migration stabilization. The ideal candidate for this role thrives in complex environments, brings a proactive problem-solving mindset, and can collaborate effectively with cross-functional stakeholders. Duties:Configure existing databases on SQL Server 2016/2019 to read-only mode to ensure data integrity during transition.Perform full database backups on SQL Server 2016/2019.Restore databases to the new SQL Server 2022 environment.Bring SQL Server 2022 databases online and decommission legacy instances by setting prior versions offline.Establish user accounts, permissions, jobs, and SSIS packages within SQL Server 2022.Migrate reports and subscriptions from SSRS 2016 to SSRS 2022.Engage report owners to reconfigure data source connections to align with the upgraded platform.Coordinate with database owners to update existing jobs and packages to SQL Server 2022 compatibility.Create and validate linked servers to ensure cross-platform functionality.Facilitate comprehensive testing and verification by database owners to confirm operational readiness.Mandatory Qualifications:Associates degree or combination of experience and education.4+ years of experience in migrating to large complex databases and applications along with associated logins, jobs, SSIS packages, linked servers.4+ years of experience with designing and installing clustering with Always ON High availability.4+ years of experience regarding project status, meetings, reporting requirements, scope changes.4+ years of experience with providing Hyper Care support post migration of databases and applications, user support and2+ years of experience with Redgate monitoring Software to fine-tune SQL Server database performance, creating indexes, optimizing response time, calculating IOPS and tuning SAN performance.4+ years of experience with SQL Server Reporting Services (SSRS): Skills in creating, deploying, and managing reports using SSRS or other reporting tools like Power BI.4+ years of experience with Data Analysis & Warehousing: Skills in data analysis, data warehousing concepts (e.g., star and snowflake schemas), and data visualization tools like Tableau or Power BI.Cloud and Things complies with all applicable federal, state, and local laws regarding recruitment and hiring. All qualified applicants are considered for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, protected veteran status, or any other category protected by applicable federal, state, or local laws. AI-Assisted Resume Evaluation NoticeCloud and Things – Talent ManagementNotice to CandidatesCloud and Things utilizes artificial intelligence (AI) tools to assist our recruiting team in evaluating candidate applications for streamlining; consistency, efficiency, and thoroughness.  All hiring decisions are ultimately made by our human recruiting professionals.How AI Is UsedOur AI tools assist by:Analyzing resumes against job requirementsSupporting our recruiters in candidate data evaluationEnsuring consistent review standards across all applicationsImportant: AI serves as a support tool only. As noted above, all candidate selection and hiring decisions are made by experienced human recruiters. Your unedited resume will be processed by our AI tools as part of this evaluation.Your Data and PrivacyCloud and Things Data Handling:Your information is processed securely and used exclusively for recruitment purposesCloud and Things may store your resume in our Applicant Tracking System (ATS) indefinitely for future job matching opportunitiesYou may opt out of long-term ATS storage by emailing your name  and your request to opt out of storing your resume in the ATS to: security@cloudandthings.comAll personal information is handled confidentially in accordance with our privacy policyAI Tool Data Processing:AI processing data is retained for a maximum of 90 days, after which it is deletedAll data sent to AI tools is encrypted in transit and at restAI tools comply with applicable privacy laws including GDPR and CCPAPersonal data is anonymized or minimized wherever possible during AI processingYour ParticipationBy submitting your application, you acknowledge this notice and consent to AI-assisted evaluation as part of our recruitment process. You may opt out only by choosing not to submit your resume for consideration.