Database Administrator

Steampunk•McLean, VA

6d•$115,000 - $135,000

About The Position

Steampunk is seeking an experienced data administrator to work with its team and clients to architect and develop data models, data warehouses, data lakes and lakehouses, data governance, services, and pipelines. The role calls for a technologist with strong communication and customer service skills and an interest in data and problem solving. The administrator will lead the migration of data environments and help ensure performance and reliability, with cloud experience preferred—particularly AWS, or alternatively Azure or GCP. The position supports database design and structure, security and access control, development, testing, and production environments, data merging and migration, system updates and patching, backups and recovery, and ongoing monitoring. It also supports an Agile software development lifecycle and contributes to the growth of Steampunk’s Data Exploitation Practice. The role requires collaboration with staff, IT customers, and technical and non-technical colleagues and contractors.

Requirements

Ability to hold a position of public trust with the US government.
At least 5 years of experience in database administration, information technology, database architecture, or a related field.
On-the-job experience with large-scale data migration.
On-the-job experience designing storage and retrieval solutions for 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.
Experience with SQL and relational databases, query development and optimization, and working familiarity with databases such as Oracle, SQL Server, and PostgreSQL.
Experience with relational SQL and NoSQL databases.
Familiarity with AWS or Azure cloud technology, including managed services such as AWS EC2, EMR, RDS, and Redshift, and experience delivering in a cloud environment.
Experience working in a DevSecOps environment and using CI/CD best practices.
Experience collaborating with technical and non-technical colleagues and contractors.
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.

Nice To Haves

Cloud experience, preferably AWS; alternatively Azure or GCP.
Familiarity with AWS managed service offerings such as EC2, EMR, RDS, and Redshift.

Responsibilities

Lead and architect data-environment migrations with a focus on performance and reliability.
Craft database and data warehouse solutions in cloud environments.
Help build database structure and design.
Implement data security measures and control database access.
Build development, testing, and production environments.
Merge and migrate data as necessary.
Update and patch systems to maintain compliance.
Design and implement data backups and restore lost data.
Continuously monitor database systems.
Support an Agile software development lifecycle.
Support development of data artifacts, including data dictionaries, entity relationship diagrams, data flow diagrams, data quality plans, data management plans, and data asset catalogs.
Develop specifications for modern large-scale data repositories, including cloud-based database solutions.
Collaborate with staff, IT customers, and technical and non-technical staff and contractors at all levels.
Lead Agile projects and contribute to the growth of the Data Exploitation Practice.