SQL Database Consultant

Project: Data Center Co-location and Migration Project

Project Overview:

• NYC DSS is undertaking a large-scale Data Center Co-location and Migration Project to modernize its IT infrastructure.
• Approximately 90% of current data center infrastructure is reaching End-of-Life (EOL) / End-of-Support (EOS)
• Migration from 15 MetroTech Center to 11 MetroTech (Brooklyn NY)
• Consolidation of multiple data centers into a single co-location facility

Tasks & 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.

Required Skills:

• 4 years experience in migrating to large complex databases and applications along with associated logins jobs SSIS packages linked servers.
• 4 years experience with designing and installing clustering with Always ON High availability.
• 4 years experience regarding project status meetings reporting requirements scope changes.
• 4 years experience with providing Hyper Care support post migration of databases and applications user support and
• 2 years 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 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 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.

V Group Inc. is a NJ-based IT Services and Products Company with its business strategically categorized in various Business Units including Public Sector Enterprise Solutions Professional Services Ecommerce Projects and Products. Within Public Sector business unit we cater IT Professional Services to Federal State and Local. We have multiple awards/ contracts with 30 states including but not limited to NY CA FL GA MD MI NC OH OR CO CT TN PA TX VA NM VT and WA.

If you are considering applying for a position with V Group or in partnering with us on a position please feel free to contact me for any questions you may have regarding our services and the advantages we can offer you as a consultant.

Please share my contact information with others working in Information Technology.