SQL Database Administrator

Overview

In today’s rapidly evolving technology landscape, an organization’s data has never been a more important aspect in achieving mission and business goals. Our data exploitation experts work with our clients to support their mission and business goals by creating and executing a comprehensive data strategy using the best technology and techniques, given the challenge.

At Steampunk, our goal is to build and execute a data strategy for our clients to coordinate data collection and generation, to align the organization and its data assets in support of the mission, and ultimately to realize mission goals with the strongest effectiveness possible.

For our clients, data is a strategic asset. They are looking to become a facts-based, data-driven, customer-focused organization. To help realize this goal, they are leveraging visual analytics platforms to analyze, visualize, and share information. At Steampunk you will design and develop solutions to high-impact, complex data problems, working with the best and data practitioners around. Our data exploitation approach is tightly integrated with Human-Centered Design and DevSecOps.

Contributions

We are looking for a 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", we are looking for a technologist with excellent communication and customer service skills and a passion for data and problem solving. Responsibilities include:

• 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

Required:

• Ability to hold a position of public trust with the US government.
• Bachelor's degree in Computer Science, Information Systems, Engineering, Business, or a scientific or technical discipline.
• 8+ years of total experience.
• 5+ years of experience in database administration, information technology, database architecture, or a related field.
• Demonstrated hands-on experience as a SQL Server DBA in a production environment.
• Strong knowledge of SQL Server internals, indexing, query optimization, and performance testing.
• Experience implementing and supporting SQL Server Always On Availability Groups, clustering, replication, and log shipping.
• Hands-on experience with SQL Server monitoring tools
• 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.

Preferred:

• Microsoft Certified: Azure Database Administrator Associate

About steampunk

Steampunk relies on several factors to determine salary, including but not limited to geographic location, contractual requirements, education, knowledge, skills, competencies, and experience. The projected compensation range for this position is $115,000 to $135,000. The estimate displayed represents a typical annual salary range for this position. Annual salary is just one aspect of Steampunk’s total compensation package for employees. Learn more about additional Steampunk benefits here.

Identity Statement

As part of the application process, you are expected to be on camera during interviews and assessments. We reserve the right to take your picture to verify your identity and prevent fraud.

Steampunk is a Change Agent in the Federal contracting industry, bringing new thinking to clients in the Homeland, Federal Civilian, Health and DoD sectors. Through our Human-Centered delivery methodology, we are fundamentally changing the expectations our Federal clients have for true shared accountability in solving their toughest mission challenges. As an employee owned company, we focus on investing in our employees to enable them to do the greatest work of their careers – and rewarding them for outstanding contributions to our growth. If you want to learn more about our story, visit http://www.steampunk.com.

We are an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veteran status, or any other characteristic protected by law. Steampunk participates in the E-Verify program.