Senior MS-SQL DB Architect - ETL & Data Sync

Ask IT consulting; Town of Florida (NY); On-site; USD 90,000 - 130,000; Full time

Job summary

SQL Database Administrator with legacy experience is sought to refresh WORCS system using ASP.NET, MVC 5, C#, and SQL with MS-SQL. The role emphasizes owning the database, ensuring integrity across environments, and driving data conversion and performance improvements.

You will design high-availability database infrastructure, review plans, and develop ETL packages for legacy data migration, while collaborating with architects and analysts to meet client standards.

Qualifications

• Experience with SQL Server development and management.
• Experience writing stored procedures, functions and triggers.
• Experience creating models and designing DB objects.
• Advanced SQL knowledge and data modeling.
• Experience with SQL Server Integration Services (SSIS).
• Experience with version control, preferably TFS.
• Experience with performance tuning and indexing.
• Experience ensuring database integrity across environments.

Responsibilities

• Assist with design/review tasks for WORCS database, conversion and data synchronization.
• Develop and maintain SSIS packages for data conversion from legacy to SQL Server.
• Define and maintain database roles and permissions for application objects.
• Review backup policy and optimize schedules to avoid conflicts with processes.
• Review SQL execution plans on critical queries and optimize performance.
• Support infrastructure optimization, reduce bottlenecks and single points of failure.
• Collaborate with architect and business analyst, owning database integrity.

Skills

SQL Server Management Studio

Stored Procedures

Data Modeling

ETL / SSIS

Indexing

Version Control (TFS)

Database Architecture

SQL Performance Tuning

Data Replication

Database Security

Tools

SSIS

TFS

SQL Server Management Studio

Job description

SQL Database Administrator with legacy experience

• Full-time

This project is to refresh the current client’s Workers Compensations System and supporting applications to updated technology and supported client standards. This includes updating the user interface, application and database. The project will be completed using ASP.NET , MVC 5, C# and SQL with an MS-SQL backend database. This resource, under client’s direction, will be responsible for database work related to the solution. They will help to perform design and review tasks related to the WORCS web portal with focus on database, conversion and data synchronization. They will do initial data conversion between the current WORCS database (Mainframe) and the WORCS refresh database (SQ) using SQL server integration services. They will execute tasks as defined in the client’s Project Management Methodology (PMM) as well as the Systems Engineering Methodology (SEM). The senior resource MUST take ownership of the database and associated processes. They will work with the architect and business analyst but will maintain responsibility for database integrity, synchronization across environments, performance and adherence to standards. This resource must also be proactive in improving the database, technical processes and customer relationships. Specific tasks may include, but are not limited to: Assist with the design of a highly available fault tolerant database infrastructure, assist with technical design activities, including optimizing data access for a web portal application, leveraging features in SQL to reduce latency and providing insights that could improve application performance, create and maintain application projects (ex. type of tables and indexes, partition types, keys, foreign keys/constraints, segment type and size etc.), create processes to replicate production databases (de-normalized to normalized), help with layout application schemas and database files, define and maintain database roles and permissions for application objects, develop and execute statistics collection plan for application objects depending on volume and type of queries (ex. timing of statistics collections, lock statistics, enable/disable HISTOGRAM, etc.), review back up policy with management and senior staff members and help suggest schedule/timings to avoid conflict with application processes, review SQL execution plans on critical application queries, help with application code testing during application releases or database upgrade/migration to avoid SQL performance issues, bulk data uploads, assist with infrastructure optimization and design, including identifying bottlenecks, improving responsiveness and reducing single points of failure, develop SQL server integration services packages to facilitate conversion of data from legacy system into SQL server relational database.

Experience with database development with SQL server management studio including creating models, designing database objects (tables, indexes, etc.)
Required
5
Years

Experience writing database procedures, functions and triggers
Required
5
Years

Experience developing solution architecture from business requirements, information architecture and technical architecture
Required
5
Years

Advanced SQL knowledge, software configuration and setup of the SQL translations needed between the legacy and refresh database,
Required
5
Years

Advanced SQL knowledge with data modeling and version control
Required
5
Years

Must understand SQL server database projects and how they are applied across environments and how it is used in the version control process
Required
5
Years

MS-SQL database administrator experience including creating models, designing DB objects and how it is used in version control process
Required
10
Years

Experience with SQL server integration services for ETL including creating complex multi step packages and optimizing drivers for high performance
Required
5
Years

Experience as a database architect developing solution architecture from business requirements, information and technical architecture
Required
5
Years

Experienced in SQL knowledge, writing and maintaining large complex stored procedures, tuning SQL for optimum performance
Required
5
Years

Experience creating and maintaining proper indexes
Required
5
Years

Experience with version control - using s source control system to maintain a history - TFS (Team Foundation Server) preferred
Required
5
Years

Experience monitoring application related jobs and data replication activities
Required
5
Years


All your information will be kept confidential according to EEO guidelines.

By clicking the link above or any third-party link within this posting, you are leaving this site and going to a third-party website where the third-party website's terms and privacy policy apply