Database Administrator

UNAVAILABLE; McLean (VA); On-site; USD 90,000 - 140,000; Full time

Job summary

UNAVAILABLE in McLean, VA seeks a seasoned Data Administrator to architect data models, data warehouses, lakes and lakehouses, data governance, services and pipelines for our team and clients.

You will lead migrations, design cloud storage solutions (AWS/Azure), implement security, manage access, build development/testing/production environments, and support an Agile SDLC. Bachelor’s degree and 5+ years in related fields required.

Qualifications

• 5+ years of experience in database administration, information technology, database architecture, or a related field.
• Ability to hold a position of public trust with the US government.
• Demonstrated on-the-job experience with large-scale data migration.
• Strong command of SQL tools.
• Experience with relational SQL and NoSQL databases.
• Cloud technology experience (AWS or Azure).

Responsibilities

• Lead and architect migration of data environments with performance and reliability.
• Craft database/data warehouse solutions in cloud (AWS preferred).
• Design storage and retrieval solutions for structured and unstructured data.
• Implement security measures for data and control access.
• Create and manage development, testing, and production environments.
• Monitor and patch systems to maintain compliance.
• Design and implement data backups and restore processes.
• Support an Agile software development lifecycle.

Skills

SQL proficiency

Cloud AWS/Azure

Data modeling

Data governance

ETL pipelines

PowerShell scripting

Unix shell

NoSQL/SQL databases

DevSecOps

Agile

Education

Bachelor's degree

Tools

AWS EC2

EMR

RDS

Redshift

Oracle

SQL Server

PostgreSQL

Job description

Overview

We are looking for seasoned Data Administrator to work with our team and our clients to architect and develop data models, data warehouses, lakes, and lakehouses, data governance, services, and pipelines. We are looking for a more than just a "Database Administrator", but a technologist with excellent communication and customer service skills and a passion for data and problem solving.

Responsibilities

• Lead and architect migration of data environments with performance and reliability.
• Experience in crafting database / data warehouse solutions in cloud (Preferably AWS. Alternatively Azure, GCP).
• Helping build the structure and design of the database
• Implementing security measures for the data
• Controlling access to the database
• Building different environments for development, testing and production
• Merging and migrating data when necessary
• Updating and patching systems to maintain compliance
• Designing and implementing data backups
• Restoring lost data
• Continually monitoring database systems
• Key must have skill sets – database management
• Support an Agile software development lifecycle
• You will contribute to the growth of our Data Exploitation Practice!

Qualifications

• Ability to hold a position of public trust with the US government.
• 5+ years of experience in database administration, information technology, database architecture, or a related field
• Demonstrated on-the-job experience with large-scale data migration
• Demonstrated on-the-job experience designing storage and retrieval solutions for both structured and unstructured data, in support of data science pipelines
• Strong command of SQL tools
• Advanced knowledge of database security, backup and recovery, and performance monitoring standards
• Understanding of relational and dimensional data modeling
• PowerShell and Unix shell scripting skills
• Impeccable attention to detail
• Demonstrated experience working with SQL and relational databases, query development and optimization (SQL) as well as working familiarity with a variety of databases, such as Oracle, SQL Server, PostgreSQL, and others.
• Experience with relational SQL and NoSQL databases
• Familiarity with cloud technology, using AWS or Azure. Knowledge of managed service offerings (e.g. AWS EC2, EMR, RDS, Redshift) and demonstrated experience delivering in a cloud environment.
• Demonstrated on-the-job experience supporting the development of related data artifacts
  • Data Dictionary
  • Entity Relationship Diagrams
  • Data Flow Diagram
  • Data Quality Plan
  • Data Management Plan
  • Data Asset Catalog
• Experience working in a DevSecOps environment, utilizing CI/CD best practices
• Demonstrated on-the-job experience developing specifications for modern large-scale data repositories including development of specifications for cloud-based database solutions
• Demonstrated experience collaborating with staff, IT customers, and other technical and non-technical staff and contractors at all levels
• Demonstrated experience working in an agile environment and leading agile projects
• Bachelor's degree in computer science, information systems, engineering, business, or a scientific or technical discipline