What are the responsibilities and job description for the SQL Database Consultant position at Trigyn Technologies, Inc.?
Trigyn's direct government client has an immediate long-term need for SQL Database Consultant in Brooklyn, NY.
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:
? 8 years of general IT experience.
? 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.
For Immediate Response call , or send your resume to
TRIGYN TECHNOLOGIES, INC. is an EQUAL OPPORTUNITY EMPLOYER and has been in business for 35 years. TRIGYN is an ISO 9001:2015, ISO 27001:2013 (ISMS),ISO 20000:2018 and CMMI Level 5 certified company.