Loading...
Share this Job

3528 - IT Data Architect / Database Administrator

Date: Jun 9, 2021

Location: IN IN IN IN IN IN

Company: Cytel Inc

Cytel provides unrivaled biostatistics and operations research knowledge to our customers in the life sciences industries in the form of both software and services.  At Cytel, we work hard to create successful careers with significant professional growth for our employees, as a result of which they work hard to make Cytel successful. Cytel is a place where talent, experience and integrity come together to advance the state of clinical development.

 

Job Description:

The IT Data Architect /DBA will work with project teams and stakeholders to design, optimize, and maintain data infrastructure to extract and organize data for use across the enterprise. This role would identify Single source of truth for data elements and develop the framework to ensure data is sourced from the single source system and consumed by other applications

 

Summary of Job Responsibilities:

 

  • Deploy the operating system for the database server, installs software and configures it for use. Updates, patches, and on-going maintenance software as required. Handles the transfer of data from the existing system(s) to the new platform.
  • Manage Data Extraction, Transformation, and Loading (ETL) definition and processes
  • Manage any specialized data handling including unstructured data types (documents, images, etc.)
  • Create backup and recovery plans and procedures based on industry best practices.
  • Maintain secure environment and be able to examine audit logs.
  • Control access and permissions to restricted information.
  • Determine growth rates of data in storage and plan for storage needs.
  • Monitoring databases for performance issues.
  • Monitoring and adjusting for peak database performance.
  • Identify installation solutions for new databases
  • Determine the requirements for a new database
  • Publish and/or present design reports
  • Identify areas for improvement in current systems
  • Coordinate with other team members to reach project milestones and deadlines
  • Audit database regularly to maintain quality
  • Create systems to keep data secure
  • Designs/codes applications following specifications using the appropriate tools. 
  • Creates test cases and runs tests to confirm program meets specifications.  
  • Troubleshoots programs to identify and apply solutions to reported issues. 
  • Writes and maintains documentation for code, programs, and specifications. 
  • Reviews user and technical documentation written by others to confirm consistency with program operations, and compiles documentation of program development and subsequent revisions
  • Participates in all phases of the development life cycle including analysis, design, coding, testing, and release. 

 

Qualifications and Experience:

Minimum Education:  Bachelor's Degree in Computer Science or Information Systems.

 

Minimum Work Requirements:

7-10 years of experience in IT data architecture / Database Administration

 

Skills:

  • Strong understanding of Azure cloud infrastructure and platform
  • Experience in Microsoft SQL Server, Azure files, Azure Data Lake, Azure SQL database or Azure database for MySQL
  • Knowledge of database structure languages, such as SQL
  • Experience with ETL tools.  CData experience is a plus
  • Experience programming with languages (Java, Python, etc.)
  • Experience with web services, adapters / connectors, REST APIs etc. to connect with different applications
  • Knowledge of IT security best practices
  • Knowledge of database design and theories
  • Ability to work with other IT specialist to set up, maintain and monitor data networks
  • Experience with a variety of computer information systems
  • Excellent attention to detail
  • Problem-solving and critical thinking
  • Ability to explain complex ideas in simple terms
  • Ability to cultivate positive working relationships with coworkers
  • Experience in Healthcare / Pharma is a plus


Job Segment: System Administrator, Architecture, Database, Data Architect, DBA, Technology, Engineering, Data