Database Administrator

Employer
4S
Location
Arlington, VA
Posted
Sep 20, 2022
Closes
Sep 24, 2022
Ref
655463404
Hours
Full Time
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 modelsDesign, 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 modelsWrite ETL code querying relational databases, tabular excel data, and CSV dataWrite ETL routines to confirm full data content is transferred successfullyWrite procedures to perform automated operations on data and provide business rule views of dataPerform data discovery to profile data for ETL requirements and find anomalous dataOptimize queries for large volumes of dataWrite 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 plusWrite performant complex SQL statements against terabyte+ size datasetsDevelop relational data models to accommodate in-process data for automated ETL processesOptimize ETL and SQL statementsAnalyze and troubleshooting database performance issuesDevelop ETL routines that manipulating and transfer large volumes of data and perform quality checks to confirm all data is transferredUsing version control systems, GIT preferredWorks well in a distributed team environmentRequires 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 (eg Amazon Web Services EC2, Elastic MapReduce) and considerations for scalable, distributed systems.Experience with industry standard medical data models, eg 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.

Similar jobs