|
Reference Number:
23641
Job Description:
COOK SYSTEMS INTERNATIONAL has an IMMEDIATE need for a SQL Server DBA.
Job Description/Responsibilities:
The Database Administrator will primarily be responsible for maintaining the integrity, reliability, security of our SQL database environment.
The Administrator will help the organization manage storage requirements and growth; provide SQL Monitoring (logs) and tuning; reporting, auditing; implement and enforce best practices, standard operating procedures , etc.; provide recommendations for our database hardware and software architecture; assist with documentation of our SQL environment; institute disaster recovery plans, procedures and testing related to SQL database backups; manage upgrades and patches; create queries, stored procedures and triggers; manage roles, users and permissions; interface with internal and external technical teams; perform project related tasks; automate DBA tasks; and provide on-call support as necessary.
The DBA will also be responsible for communicating with and understanding the data needs of our customers, medical researchers and statisticians, in a large, research-oriented community oncology practice, and to help them utilize the data available in our research database as well as possible. This will require developing a thorough understanding of the current database schema as well as the processes for accumulating new data (from patients and other data sources) and translating this data into forms usable by the research staff.
Required Skills/Experience:
The candidate must be detail-oriented and a good listener and communicator.
He or she must be flexible and eager to find ways to contribute to a small, dynamic and rapidly growing team of medical and technical staff.
In addition, the candidate should possess or be positioned to master the following:
Training and experience in SQL data manipulation language to perform queries, tuning, stored procedures, triggers and more.
A solid understanding of relational database design, including actual design experience.
Administrative experience with SQL Server/MSDE, including performing backups, maintaining database security, and other routine tasks with exposure to hardware, OS, OS logs and SQL logs.
Experience with SQL Clustering and/or Storage Area Network architecture.
DBA certification desirable.
Some training in statistics and the design of experiments.
Familiarity with standards for medical data exchange, including HL7 and CDISC.
A medical background and familiarity with medical research, particularly clinical trials and oncology.
Some training in statistics and the design of experiments.
BS degree in Computer Science, Information Systems or related field preferred.
Working knowledge of regulations related to HIPAA, FDA, PHI, and data handling, security, and processes.
Strong familiarity with SQL database security roles and other security related access/authentication methods such as DB roles, SQL user roles, application authentication, OS authentication, domain authentication, etc.
Understanding of data protection schemes utilizing encryption.
Ability to optimize DB performance by diversification, hardware recommendation and implementation, SQL optimization, load balancing, clustering, etc.
e/o/e
Contact jwhitney@cooksys.com for further details.
Experience Level:
5+ Years
Requirements:
|
