Database Administrator - SQL Server Aegerion Pharmaceuticals, Inc.
THIS JOB HAS EXPIRED POSITION DESCRIPTION
The Database Administrator will focus on the development and support of Aegerion?s database environment. The position will entail database design and modeling, SQL code creation, integration with existing systems, business intelligence and reporting. The ideal candidate will have significant life sciences industry and process experience with expense management, ERP, and CRM. Additional experience developing workflows, Intranet and virtual team and project collaboration environments with SharePoint 2010 is a plus. This is an exciting opportunity to work in a fun and creative environment for a start-up biopharma with no legacy systems in place to support.
Design and Development Schema, Aggregations, Indexes, SQL, Stored Procedures
Design database structures & use data modeling tools
Develop and support shell scripts for database activities, such as data loading and unloading
Develop ETL integration processes between operational systems and enterprise data warehouse
Monitor SQL server databases to ensure optimum performance, analyzing and resolving performance issues ensuring maximum uptime
Implement and maintain security policies and best practices
Ensure backup and recoverability of all enterprise SQL server databases.
Responsible for capacity planning
Analyze, translate and develop business requirements into a design of both the metadata and logical data model needed to support both reporting and ad-hoc analysis.
Design, build, test and implement data model and reporting solutions
Conduct data analysis, design and develop standardized management reporting
Front-end design of charts and graphs
Conduct training and implementation of the reporting system.
Experience in the Life Sciences, Pharmaceutical, or Biotech industries preferred
A minimum of five years of experience as a database analyst/administrator
Bachelor?s degree in computer science, or related field
Experience with performance monitoring statistics, database optimization, and index utilization.
Experience configuring database instances, replication, and show plan utilities.
Ability to manage project commitments to ensure that the project comes in on time and within budget.
Experience with developing ETL workflows and processes
Excellent SQL skills
Experience with SQL Server
Experience with creating stored procedures and triggers
Experience building metadata repositories
Experience with OLAP
Experience creating reports with tools such as Crystal Reports, MicroStrategy, BusinessObjects or others
Strong relational and multi-dimensional data modeling
Excellent analytical skills
Ability to effectively present information to customers and senior management
||Cambridge, MA |
THIS JOB HAS EXPIRED