SQL Queries Triggers Stored Procedures And User Defined Functions Database Adminis   Requirement id 73212 Job title Administrator Job location in Boston, MA Skills required Relational Database Systems, Structured Query Language (SQL), Cognos Development, SQL Queries Triggers Stored Procedures A Open Date 11-Sep-2018 Close Date Job type Not specified Duration 9 Months Compensation DOE Status requirement --- Job interview type Face to Face interview    Email Recruiter: coolsoft Job Description Administrator: Relational Database Systems, Structured Query Language (SQL), Cognos Development, SQL Queries Triggers Stored Procedures A Notes : May be filled PRIOR TO CLOSE DATE: _x_Yes __No Start date : 9/24/2018 End date : 6/30/2019 Dead line : 9/14/2018 Client : EOHHS Description : Background: the Massachusetts DPH/Bureau of Substance Abuse Services (BSAS) is operating and constantly improving a DataMart containing data from various systems. This DataMart supports the college, storage and reporting of critical data. We also leverage the infrastructure and standardization of tools for enhanced data collection and reporting. Challenge: In light of Opioid Epidemic and the on-going objective of improved reporting and data analysis to provide insights to management the DataMart is and will continue to be vital to provide data for addressing public health challenges. Role Description: The DBA reports jointly to the director of the BSAS OSE as well as the IT Program Manager at the Bureau for Substance Addiction Services (BSAS) in Boston. This position will work closely with the BSAS DataMart team and IT staff as well as BSAS OSE. The primary role is proactively identify, develop, and drive DataMart strategies. The DBA is responsible for understanding the Bureaus data management goals and needs and how these relate to the existing and evolving DataMart, while ensuring compliance with IT policies and procedures. The DBA will apply industry best practices and concepts to achieve DataMart goals and aid in ensuring the completion of all project deliverables on time and budget while maintaining documentation in a centralized repository. Duties of the Database Administrator; • evaluates, designs and manages database systems in a client/server mainframe or cloud environment and work with users to analyze requirements and define specifications for database access, structure, format, documentation, security, back-up and recovery. • performs validation checks, maintains database dictionaries and coordinates the installation of new and revised database systems. • Manage application upgrades and migration activities • Report production and enhancement ensuring the timely generation and distribution of regular provider and population reports • Create and maintain written procedure manuals • Work with providers • Ad-hoc support where and when necessary • Partnering with DPH and MassHIWay IT staff Skills: • Thorough knowledge of relational database systems, structured query language (SQL), COGNOS, and a working knowledge of referential integrity, triggers and stored procedures. • Data and databased operational support including database/administration data management/configuration and internal (incorporation of new data channels) and external dataset integration • Regular Data refresh including modification to data tables. • Data quality initiatives embedded in the data and database operational support framework to address regular and intermittent data issues caused by inconsistencies in data presented to DataMart. • Identify on-going problems, their impact analysis and resultant coding necessary to compensate for those issues; incomplete/inconsistent enrollment submission by programs as well as historical changes in assessment forms that do not align over time and other data consistency and completeness issues. • Ability to work towards reallocation of resources currently committed to data resolution to more business analytic efforts supporting OSE. Experience: • Working with software vendors and in a PMO environment • Working in a team environment and promote collaborative atmosphere • Bachelors degree in computer science, Computer Information Systems, Information management or related field or experience • 5+ years experience in DBA role, • Experience n SDLC, Solution assessment and validation • Technical requirements/Specifications Development and Management   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 73212 while calling.   Other jobs in MA: Boston (103), Burlington (1), Cambridge (1), Canton (3), Chelsea (9), Franklin (1), Lexington (2), Malden (10), Marlborough (2), Maynard (2), Newton (1), Quincy (6), Sharon (1), Waltham (1), Welesley (1), Wellesley (6), Westborough (1), Westbourough (1), Relational Database Systems job openings in Boston, MA Jobs List ITS63 EHS FY19 Data Warehouse Developer 006 -DPH -SP Create date: 21-Mar-2019 Note: Maximum number of resumes per ITS63 Vendors: 3 Note: RTR form must be signed by candidate. Submission Deadline: 3/29/2019 Start Date: 4/9/2019 End Date: 6/30/2019 Client: EOHHS Description: Background: The Massachusetts Department of Public Health (DPH) Bureau of Substance Abuse Ser.... (This job is for - job Jobs in MA Boston Developer - (in Boston, MA))    Relational Database Systems job openings in other states Jobs List DIRCPOITSAC2001 Data Warehouse Architect 3 - SP Create date: 25-Feb-2020 Note: Online Submission Submission Deadline: 3/9/2020 5:00 PM (CT). Start Date: 3/9/2020 End Date: 8/31/2020 Client: Department Of Information Resources (DIR) Description: Texas Department of Information Resources requires the services of 1 Data Warehouse Architect 3, hereafter referred to as .... (This job is for - job Jobs in TX Austin Architect - (in Austin, TX)) ETL Programmer - NTTJP00018328 Create date: 29-Mar-2019 Start Date :5/3/2019 End Date :05/02/2021 Submission Deadline :4/4/2019 Client Info :PS: S&L New York Delivery Description: we know that with the right people on board, anything is possible. The quality, integrity, and commitment of our employees are key factors in our companys growth.... (This job is for - Analysis Jobs in NY NewYork Consultant - (in New York, NY))     (Administrator: Relational Database Systems, Structured Query Language (SQL), Cognos Development, SQL Queries Triggers Stored Procedures A in Boston, MA)

Featured Jobs Data Analyst (Jobs in Madison, Wisconsin) Customer Analyst (Jobs in COLUMBIA, South Carolina) Network Architect (Jobs in Richmond, Virginia) LMS Manager (Jobs in Madison, Wisconsin) Z/Os Specialist (Jobs in Raleigh, North Carolina) Problem Analyst (Jobs in Chelsea, Massachusetts) SQL PostgreSQL Analyst (Jobs in Atlanta, Georgia) PEOPLESOFT Customer Analyst (Jobs in Atlanta, Georgia) TCL Consultant (Jobs in Jackson, Mississippi) Email Supervision Administrator (Jobs in Nashville, Tennessee)