Brandon Consulting Associates
Database Architect - Albany, NY (Onsite)
Brandon Consulting Associates, Albany, New York, us, 12237
Passport copy is mandatory
Provide a short description of the Position: The client needs a dabase architect to work on data architect analysis, solution designing and providing suport for the Unified Information System (UIS). Enhancement project in the client. This project is being undertaken to address critical application issues and required enhancements. Primarily staff will be reponsible to design system architectecture and writing complex store procedure, streamlining legacy database structure and processes for better data integrity and enhancing code to meet ITS standards during implementation of a planned interface with SFS and participate in Spills Hotline and Spill Response notification -Survey 123 integration project are in need of a Database Architect. Provide a list of the day-to-day tasks to be performed by the Selected Candidate: The database architect will be responsible for designing and maintaining MS SQL databases, reviewing database performance, and optimizing existing processes. This individual will perform analytical and technical tasks to develop advanced complex SQL based solutions. This individual will also provide ad-hoc production support for the existing database needs. Maintain Database mobile field inspection module V7 already integrate into UIS. • Build complex SQL queries, stored procedures, functions, views, and reports. • Work with developers to design modern and effective database architectures. • Analyze functional requirements to perform ad-hoc Extract, Transform and Load (ETL) processes involving data analysis, data manipulation and setting up SSIS packages. • Review performance logs to track and analyze production issues, identify and eliminate obsolete DB objects, and optimize stored procedures and jobs to improve database responsiveness. • Participate in unit and regression testing by assisting business analysis team to mine and translate complex dataset. • Work with data modelling team to draft/maintain system data model and data dictionary. Establish standards for system documentation and advise other team members. • Participate in data integration activities for PBS E-Registration , mobile field inspection system and Spill Hotline-Response Notification project.
Requested Qualification
Exp you have
84 months experience in design and development of advanced SQL queries, stored procedures, triggers, scripts, cursors, and views 11.25 84 months experience in MS SQL Server Management Studio (MS SQL Server version 2012+, and upgrade to MS SQL 2019) including experience on database software (including SSRS, SSMS, SSIS), and understanding ETL concepts (Extract, Transform and Load data). 11.25 84 months of experience in designing data architecture and data modeling (data dictionary and system documentation), including the ongoing maintenance of an existing data model 11.25 84 months of experience supporting day-to-day database operations, including: monitoring and maintenance, problem investigation and resolution, backup creation and maintenance, database optimization, tuning, consolidating views and tracking and improving database performance metrics 11.25 60 months of experience with extracting and inserting data to/from business systems using scripting along with GIS API's( ESRI ArcGIS, Survey 123, Workspace, Google Maps) 15 • Résumé • Copy of Candidate Identification (i.e., Driver's License/Green Card/Visa and Passport if applicable) • Any documents referenced in the above Requested Qualifications (i.e., professional certifications, degrees, etc.) 0
Provide a short description of the Position: The client needs a dabase architect to work on data architect analysis, solution designing and providing suport for the Unified Information System (UIS). Enhancement project in the client. This project is being undertaken to address critical application issues and required enhancements. Primarily staff will be reponsible to design system architectecture and writing complex store procedure, streamlining legacy database structure and processes for better data integrity and enhancing code to meet ITS standards during implementation of a planned interface with SFS and participate in Spills Hotline and Spill Response notification -Survey 123 integration project are in need of a Database Architect. Provide a list of the day-to-day tasks to be performed by the Selected Candidate: The database architect will be responsible for designing and maintaining MS SQL databases, reviewing database performance, and optimizing existing processes. This individual will perform analytical and technical tasks to develop advanced complex SQL based solutions. This individual will also provide ad-hoc production support for the existing database needs. Maintain Database mobile field inspection module V7 already integrate into UIS. • Build complex SQL queries, stored procedures, functions, views, and reports. • Work with developers to design modern and effective database architectures. • Analyze functional requirements to perform ad-hoc Extract, Transform and Load (ETL) processes involving data analysis, data manipulation and setting up SSIS packages. • Review performance logs to track and analyze production issues, identify and eliminate obsolete DB objects, and optimize stored procedures and jobs to improve database responsiveness. • Participate in unit and regression testing by assisting business analysis team to mine and translate complex dataset. • Work with data modelling team to draft/maintain system data model and data dictionary. Establish standards for system documentation and advise other team members. • Participate in data integration activities for PBS E-Registration , mobile field inspection system and Spill Hotline-Response Notification project.
Requested Qualification
Exp you have
84 months experience in design and development of advanced SQL queries, stored procedures, triggers, scripts, cursors, and views 11.25 84 months experience in MS SQL Server Management Studio (MS SQL Server version 2012+, and upgrade to MS SQL 2019) including experience on database software (including SSRS, SSMS, SSIS), and understanding ETL concepts (Extract, Transform and Load data). 11.25 84 months of experience in designing data architecture and data modeling (data dictionary and system documentation), including the ongoing maintenance of an existing data model 11.25 84 months of experience supporting day-to-day database operations, including: monitoring and maintenance, problem investigation and resolution, backup creation and maintenance, database optimization, tuning, consolidating views and tracking and improving database performance metrics 11.25 60 months of experience with extracting and inserting data to/from business systems using scripting along with GIS API's( ESRI ArcGIS, Survey 123, Workspace, Google Maps) 15 • Résumé • Copy of Candidate Identification (i.e., Driver's License/Green Card/Visa and Passport if applicable) • Any documents referenced in the above Requested Qualifications (i.e., professional certifications, degrees, etc.) 0