Database Administrator

Virtus TS; McLean (VA); On-site; USD 120,000 - 170,000; Full time

Job summary

Virtus TS is seeking a data-focused professional to manage structured data tiers across Oracle and AWS. You will cleanse, transform, and process data while crafting efficient SQL routines and PL/SQL, with emphasis on performance tuning.

The role requires experience with Oracle security policies, AWS services (RDS/S3/EMR/SQS/SNS), and graphical ETL tools to build robust data flows. Collaboration across teams is essential in a fast-paced environment.

Qualifications

• Relational data experience: cleansing, transforming, processing structured data.
• Oracle RDBMS proficiency and PL/SQL development.
• Data transformation flows using graphical ETL tools.
• SQL routines with performance emphasis.
• Experience with Oracle security policies.
• AWS environments: RDS, S3, EMR, SQS, SNS.

Responsibilities

• Design and maintain structured data tiers across Oracle and AWS.
• Cleansing, transforming, and processing structured data.
• Develop complex SQL routines focusing on performance.
• Work with Oracle Views and Triggers; implement security policies.
• Engage with AWS services and data hosting solutions.
• Support data provisioning, governance, and integration tasks.

Skills

SQL

Oracle

ETL Tools

Performance Tuning

PL/SQL

Views & Triggers

Oracle Security

AWS Services

Tools

GitHub

AWS Pipeline

Job description

Own structured-data tiers across Oracle and AWS — performance, security, and the integrity of every transaction.

• Demonstrated experience working with relational data tiers including cleansing, transforming, and processing of structured data.
• Demonstrated experience in Oracle Relational Database Management System.
• Demonstrated experience developing complex data transformation flows using graphical ETL tools.
• Demonstrated experience creating and modifying complex SQL routines, with a focus on performance tuning.
• Demonstrated experience working with Views, triggers, and Oracle PL/SQL.
• Demonstrated experience implementing complex security policies in Oracle.
• Demonstrated experience and knowledge of Amazon Web Services environments, including RDS, S3, EMR, SQS, and SNS.
• Demonstrated experience with data hosting solutions for structured and unstructured data sets.

Highly desired

The following experience is highly desired, though not required.

• Demonstrated experience with the Sponsor's approval and data provisioning processes pertaining to enterprise data.
• Demonstrated experience with data management, data versioning, backups, and GitHub.
• Demonstrated experience with data streaming solutions to transform and store data.
• Demonstrated experience with coordination and facilitation of meetings and technical discussions of requirements.
• Demonstrated experience tracking project status, plans, and action items.
• Demonstrated experience drafting meeting minutes.
• Demonstrated experience working in an agile environment and providing inputs to agile operations such as scrum and retrospectives.
• Demonstrated experience with data repository storage types such as relational, NoSQL, or distributed processing framework.
• Demonstrated experience with data transformation services and pipelines such as AWS pipeline.
• Demonstrated experience with formulating strategies and designs for decoupling direct connections to the data tier.
• Demonstrated experience proposing strategies for utilizing web services and an Application Program Interfaces (API) gateway.
• Demonstrated experience creating REST APIs.
• Demonstrated experience interfacing with REST APIs.