Database Administrator
概述 我们正在寻找经验丰富的数据管理员,与我们的团队和客户合作设计和开发数据模型,数据仓库,湖泊和湖泊楼,数据治理,服务和管道。我们不仅寻求"数据库管理员",但是一个具有卓越的通信和客户服务技能以及对数据和解决问题的热情的技术人员。贡献 ·领导和建筑师迁移数据环境以性能和可靠性。· 在云计算中构建数据库 /数据仓库解决方案 (最好是 AWS.替代的是 Azure,GCP). ·帮助建立数据库结构和设计。· 实施数据安全措施 ·控制数据库的访问 · 建立开发,测试和生产不同的环境 · 在必要时将数据合并和迁移 · 更新和修补系统以保持合规性 · 设计和实现数据备份 · 恢复丢失数据 · 持续监控数据库系统 · 关键必须具备技能集团 管理数据库 · 支持敏捷软件开发生命周期 · 你将有助于我们数据利用实践的增长!资格 · 在美国政府中拥有公众信任地位。· 经验5年以上数据库管理,信息技术,数据库架构或相关领域 · 在工作场所进行大规模数据迁移的经验;• 对结构化和非结构化的数据设计存储和检索解决方案的经验,支持数据科学管道;· 强大的 SQL 工具掌握;· 数据库安全,备份和恢复以及性能监测标准的先进知识;· 了解关系性和维度数据建模;· PowerShell 和 Unix ?? 页脚本编写技能;· 经验证明与 SQL 和关系数据库,查询开发和优化 (SQL) 以及对各种数据库的熟悉性工作。如 Oracle,SQL Server,PostgreSQL 等。· 有关 SQL 和 NoSQL 数据库的经验 · 使用 AWS 或 Azure 的云技术的熟悉度。管理服务提供知识 (例如 AWS EC2,EMR,RDS,Redshift)和在云环境中交付的经验;· 在工作场所支持相关数据文物的发展 · 数据 Dict
查看英文原文
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.
Contributions
- 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
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
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.
Originally posted on Himalayas