Database Administrator

Company: 4S
Location: Arlington
Posted on: September 22, 2022

Job Description:

JOB DETAILS Job Title: Database Administrator Company: 4S - Silversword Software and Services, LLC 4S-Silversword Software & Services is looking for an experienced Database Administrator that provides expertise and direction in the development and/or modification of computer-based scientific, technical, and business software systems. Applies knowledge of database concepts and techniques to develop data models and write ETL components that manipulate and transformation data for business data acquisition, aggregation, and dissemination. Uses scientific and engineering logic to independently identify conceptual or theoretical solutions to problems of data design and operation. Key Responsibilities

• Will research and bring current industry trends to the table, evaluating them for both risk and fit to business requirements.
• Design relational data models
• Design, deliver, and document multi-platform architecture with a focus on architectural standards, growth, performance, flexibility, reliability, scalability, and security.
• Identify architectural risks and plans to mitigate.
• Be the technical architect and point person for data platforms.
• Will architect reliable and scalable data platforms, provide standard interfaces to query and support analytics for our big security related data sets that is transparent, efficient and easy to access as possible by our varied applications.
• Design relational data models
• Write ETL code querying relational databases, tabular excel data, and CSV data
• Write ETL routines to confirm full data content is transferred successfully
• Write procedures to perform automated operations on data and provide business rule views of data
• Perform data discovery to profile data for ETL requirements and find anomalous data
• Optimize queries for large volumes of data
• Write ETL code to migrate data to specific shards in a database farm Requirements 4+ years of experience working with relational databases: writing complex SQL, designing data models, and/or developing ETL. Experience with SQL Server Version 2016 or later. Experience with SQL Server Integration Services (SSIS). Must be able to perform the following with minimal guidance:
  • Experience with SQL Server, SSIS, Oracle and Talend a plus
  • Write performant complex SQL statements against terabyte+ size datasets
  • Develop relational data models to accommodate in-process data for automated ETL processes
  • Optimize ETL and SQL statements
  • Analyze and troubleshooting database performance issues
  • Develop ETL routines that manipulating and transfer large volumes of data and perform quality checks to confirm all data is transferred
  • Using version control systems, GIT preferred
  • Works well in a distributed team environment
  • Requires experience in Big Data Technologies that can provide the technical direction towards re-architecting Data Models and Access Platforms.
  • Have extensive experience with data implementations, data storage and distribution.
  • Experience with administration, configuration management, monitoring, debugging, benchmarking and performance tuning of Database Engines.
  • Experience with high-scale or distributed RDBMS a plus.
  • Knowledge of cloud computing infrastructure (e.g. Amazon Web Services EC2, Elastic MapReduce) and considerations for scalable, distributed systems.
  • Experience with industry standard medical data models, e.g. HL7, OMOP, ICD 9/10, a plus.
  • Bachelor's (or equivalent) with 10 - 12 years of experience or a Master's with 8 - 10 years of experience.
  • Security+(Which can be obtained after hire)
  • Must be a US Citizen who is eligible for a security clearance. Already having a Public Trust is preferred.Physical Requirements Work may involve sitting or standing for extended periods of time. Position may require typing and reading from a computer screen. Must have sufficient mobility, including but not limited to bending, reaching, and kneeling to complete daily duties in a timely and efficient manner. There is a possibility that due to parking availability and location of work, walking moderate to long distance may be required. Possible lifting up to 25 lbs. Please note: 4S-Silversword Software and Services LLC reserves the right to change or modify job duties and assignments at any time. The above job description is not all encompassing. Positions functions and qualifications may vary depending on business needs. 4S-Silversword Software and Services LLC is an equal opportunity employer and does not discriminate against applicants based on race, color, creed, religion, medical condition, legally protected genetic information, national origin, sex (including pregnancy, childbirth or related medical condition), sexual orientation, gender identity and expression, age, disability, or Vietnam era, or other eligible veteran status or legally protected characteristics.

Keywords: 4S, Arlington , Database Administrator, IT / Software / Systems , Arlington, Virginia