Database Administrator

About the role

We are looking for a seasoned Data Administrator to lead the migration of data environments with performance and reliability. This role requires 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
• Craft database / data warehouse solutions in cloud (AWS preferred, Azure or GCP alternatively)
• Implement security measures for the data
• Control access to the database
• Build different environments for development, testing and production
• Merge and migrate data when necessary
• Update and patch systems to maintain compliance
• Design and implement data backups
• Restore lost data
• Continually monitor database systems

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)
• Familiarity with cloud technology, using AWS or Azure
• Knowledge of managed service offerings (e.g. AWS EC2, EMR, RDS, Redshift)
• Demonstrated experience supporting the development of related data artifacts
• 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

Benefits

The projected compensation range for this position is $115,000 to $135,000. Steampunk is an equal opportunity employer and participates in the E-Verify program.