RockvilleMDRecruiter Since 2001
the smart solution for Rockville jobs

Senior Database Programmer (req1923)

Company: Frederick National Laboratory
Location: Rockville
Posted on: October 4, 2021

Job Description:

PROGRAM DESCRIPTION

The Frederick National Laboratory is dedicated to improving human health through the discovery and innovation in the biomedical sciences, focusing on cancer, AIDS and emerging infectious diseases.The Biomedical Informatics and Data Science (BIDS) directorate works collaboratively and helps to fulfill the mission of Frederick National Laboratory in the areas of biomedical informatics and data science by developing and applying world leading data science and computing technologies to basic and applied biomedical research challenges, supporting critical operations, developing and delivering national data resources, and employing leading-edge software and data science.Within BIDS, the CBIIT Technical Ops Support (CTOS) group implements and manages software projects primarily sponsored by the National Cancer Institute's (NCI) Center for Biomedical Informatics and Information Technology (CBIIT). The work is primarily focused on successfully delivering software projects with development on local servers or the cloud. The projects are very diverse, typically mergingscience and IT, involve multiple stakeholders, and engineering can involve subcontractors. We work very collaboratively with the NCI to define the requirements and deliver a successful project.The Oracle Clinical Database Administrator/Developer will work on the C3D database team and perform a variety of Clinical database and middle tier administration, upgrade, and maintenance tasks, and also perform development tasks such as development and deployment of Oracle database data structures, development of PL/SQL programs and database-related scripts and programs, maintenance of custom ETL procedures, and data maintenance.

KEY ROLES/RESPONSIBILITIES

  • Administration, upgrade and patch Oracle Clinical Database and middle tiers as per requirements. Operation and maintenance support for C3D database, middle-tier, OC front-end application, and C3D tools such as Data Extract, Data Loader, Metadata Loader, JReview, and SAS data loader
  • Create automated ETL processes for importing data using files, API, SFTP, etc.
  • Create and maintain complex Oracle PL/SQL and Microsoft T-SQL queries
  • Evaluate, design, code, optimize, troubleshoot, and modify Oracle and Microsoft SQL databases
  • Create tables, stored procedures, views, triggers, and other database objects
  • Tune batch queries for optimum performance
  • Work closely with other team members to integrate databases with other applications for ETL and reports
  • Analyze business requirements and come up with the optimum design
  • Responsible for all aspects of database design, development, and deployment
  • Develop and maintain database and application documentation
  • Perform limited database administration
  • Resolve day-to-day tickets related to missing data, job failures, and additional requests from clients
  • Will have a responsibility to work with the BIDS PAO as may be required
  • Other duties as required

BASIC QUALIFICATIONS

To be considered for this position, you must minimally meet the knowledge, skills, and abilities listed below:
  • Possession of Bachelor's degree from an accredited college/university according to the Council for Higher Education Accreditation (CHEA) in Computer Science, Math or Biomedical Science or a related field or four (4) years relevant experience in lieu of degree. Foreign degrees must be evaluated for U.S. equivalency
  • In addition to the education requirement, a minimum of five (5) years of progressively responsible experience
  • Oracle database administration
  • Oracle Clinical administration
  • Writing complex SQL queries
  • Oracle PL/SQL Programming
  • Ability to obtain and maintain a security clearance

PREFERRED QUALIFICATIONS

Candidates with these desired skills will be given preferential consideration:
  • Oracle Clinical - Proficiency - Intermediate to High
  • Oracle database administration - Proficiency High
  • Oracle WebLogic Suites - Proficiency High
  • PL/SQL and T-SQL - SQL Development - designing, writing, and troubleshooting SQL Code (Stored Procedures, Packages, Functions, Tables, Indexes, file operations) Proficiency - Intermediate to High
  • Shell Scripting - Proficiency - Intermediate to High
  • Oracle Forms - Proficiency - Low to Intermediate
  • Medidata Rave - Proficiency - Low to Intermediate

EXPECTED COMPETENCIES
  • Database administration


Keywords: Frederick National Laboratory, Rockville , Senior Database Programmer (req1923), Other , Rockville, Maryland

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category
within


Log In or Create An Account

Get the latest Maryland jobs by following @recnetMD on Twitter!

Rockville RSS job feeds