Database Administrator- Leading Healthcare Company!
Company Name:
The Bowdoin Group
Company Description:
This company is a non-profit organization that owns several hospitals including community and specialty hospitals, a managed care organization, a physician network, community health centers, home care and other health-related entities. In addition to being one of Boston's best companies to work for, they are also a national leader in biomedical research.
Perks:
Shuttle system available for employees
Job Description:
The Business Intelligence Database Administrator is responsible for working within the BI database team to deliver database solutions that meet the needs of the organization. The BI DBA must work well in a team setting and have excellent organizational, prioritization, communication, and time management skills. The successful candidate will demonstrate accountability, flexibility and adaptability to handle multiple and changing priorities and be able to successfully collaborate with development teams, technology groups, and key stakeholders.
Responsibilities:
Analyze business and technical requirements, as well as data warehouse data models, to understand the detailed data management requirements.
Collaborate on data architecture design and planning as the subject-matter expert for the physical structure and implementation of data warehouses and data marts. This would include providing specifics for hardware layout and system settings (e.g., disk configuration, memory settings, and data page or tablespace definitions) and planning and creating databases.
Design, document and build physical database environments from table, column, index and view definitions to storage requirements and drive spacing and growth accommodations.
Work with ETL developers and data analysts to identify, design and implement solutions for extraction and integration of data to and from data warehouses and data marts for the purposes of reporting, decision support and analysis.
Ensure the accuracy, reliability and scalability of the data as well as the processes implemented for data collection.
Manage, Monitor and Administer database and system performance. Including optimization and tuning of data loads, extractions and recommending appropriate procedure, query or package changes and optimizations to ensure and improve system performance and reliability
Manage job and activity schedules to promote optimal performance, maximum availability and minimize data latency and data load durations
Work with the Data Architects to help implement the physical data model for the development and / or production environments.
Set up new environments; install & configure software, build databases, create start/stop scripts, schedule jobs, etc.
Work with business and data analysts to identify, design and implement custom user interface programs for data management and extraction purposes
Qualifications:
3
years of data warehousing and business intelligence experience. Extensive experience in SQL Server (or Oracle) database administration in a Windows server environment required; with Microsoft DBA certification preferred
Expertise working with high volume, partitioned data databases; with performance tuning and development skills; and a strong knowledge of Data Warehousing methodologies and concepts is required
Excellent oral and written communication skills and willingness to act as team player; sharing information willingly and accurately.
Skills:
An expertise in MS SQL Server data warehousing and data mining concepts including but not limited to: star schemas, snowflakes, ETL processes, dimensional modeling and reporting tools is needed
Expertise in sizing, capacity planning, SSIS with data warehouse solutions in SQL Server or Oracle environment is required. Knowledge of IBM Datastage is a plus.
Understanding of business intelligence concepts as well as accounting/finance knowledge in the healthcare industry is preferred; experience with PeopleSoft and Cognos BI a plus
To apply please contact Colleen at (781) 263-5233 orEstimated Salary: $20 to $28 per hour based on qualifications.
The Bowdoin Group
Company Description:
This company is a non-profit organization that owns several hospitals including community and specialty hospitals, a managed care organization, a physician network, community health centers, home care and other health-related entities. In addition to being one of Boston's best companies to work for, they are also a national leader in biomedical research.
Perks:
Shuttle system available for employees
Job Description:
The Business Intelligence Database Administrator is responsible for working within the BI database team to deliver database solutions that meet the needs of the organization. The BI DBA must work well in a team setting and have excellent organizational, prioritization, communication, and time management skills. The successful candidate will demonstrate accountability, flexibility and adaptability to handle multiple and changing priorities and be able to successfully collaborate with development teams, technology groups, and key stakeholders.
Responsibilities:
Analyze business and technical requirements, as well as data warehouse data models, to understand the detailed data management requirements.
Collaborate on data architecture design and planning as the subject-matter expert for the physical structure and implementation of data warehouses and data marts. This would include providing specifics for hardware layout and system settings (e.g., disk configuration, memory settings, and data page or tablespace definitions) and planning and creating databases.
Design, document and build physical database environments from table, column, index and view definitions to storage requirements and drive spacing and growth accommodations.
Work with ETL developers and data analysts to identify, design and implement solutions for extraction and integration of data to and from data warehouses and data marts for the purposes of reporting, decision support and analysis.
Ensure the accuracy, reliability and scalability of the data as well as the processes implemented for data collection.
Manage, Monitor and Administer database and system performance. Including optimization and tuning of data loads, extractions and recommending appropriate procedure, query or package changes and optimizations to ensure and improve system performance and reliability
Manage job and activity schedules to promote optimal performance, maximum availability and minimize data latency and data load durations
Work with the Data Architects to help implement the physical data model for the development and / or production environments.
Set up new environments; install & configure software, build databases, create start/stop scripts, schedule jobs, etc.
Work with business and data analysts to identify, design and implement custom user interface programs for data management and extraction purposes
Qualifications:
3
years of data warehousing and business intelligence experience. Extensive experience in SQL Server (or Oracle) database administration in a Windows server environment required; with Microsoft DBA certification preferred
Expertise working with high volume, partitioned data databases; with performance tuning and development skills; and a strong knowledge of Data Warehousing methodologies and concepts is required
Excellent oral and written communication skills and willingness to act as team player; sharing information willingly and accurately.
Skills:
An expertise in MS SQL Server data warehousing and data mining concepts including but not limited to: star schemas, snowflakes, ETL processes, dimensional modeling and reporting tools is needed
Expertise in sizing, capacity planning, SSIS with data warehouse solutions in SQL Server or Oracle environment is required. Knowledge of IBM Datastage is a plus.
Understanding of business intelligence concepts as well as accounting/finance knowledge in the healthcare industry is preferred; experience with PeopleSoft and Cognos BI a plus
To apply please contact Colleen at (781) 263-5233 orEstimated Salary: $20 to $28 per hour based on qualifications.
|
|
 | |
