Administer the Snowflake environment, including warehouse configuration, workload management performance and query optimization, environment management, and platform upgrades.
Own platform cost management, including tagging and attribution of compute, storage, and pipeline costs by domain and initiative; consumption monitoring and reporting; and workload optimization.
Build and operate orchestration, CI/CD, and infrastructure-as-code for data workloads, providing safe, repeatable deployment for engineering teams.
Operate platform observability including pipeline monitoring, data freshness monitoring, incident response process, root-cause analysis, and post-incident reviews.
Implement and operate role-based access control for the data platform in partnership with Information Security, following organization-owned identity and access processes.
Senior Database Developer responsible for designing, developing, and maintaining enterprise database solutions, including migration, ETL, and performance optimization.
Locations (2)
Falls Church, Virginia, United States
Fairfax, Virginia, United States
Responsibilities
Analyze agency operations and application requirements to determine database structural needs
Design database applications and data transfer mechanisms in an Agile environment
Develop database design and architecture documentation for management
Plan and install upgrades of database management system software
Identify and correct deviations from database development standards
Requirements
Bachelor's Degree in Computer Science
Nice to have: Experience with State governments
Nice to have: DevOps
Nice to have: CiCD
Nice to have: Child Welfare domain
DATABASE ANALYST
Creative Information Technology, Inc. · Posted Feb 10, 2022
Senior Database Developer responsible for designing, developing, and maintaining database solutions, including migration, ETL, and performance optimization.
Locations (2)
Falls Church, Virginia, United States
Fairfax, Virginia, United States
Responsibilities
Analyze agency operations and applications to determine database structural requirements
Design database applications such as interfaces, data transfer mechanisms, and function-based indexes
Develop database design and architecture documentation for management and executive teams
Plan and install upgrades of database management system software
Identify and correct deviations from database development standards
Lead technical architecture and database administration for Oracle, MySQL, MariaDB environments in AWS and on-premises, ensuring performance, security, and disaster recovery.
Responsibilities
Architect overall system design and implementation
Design and maintain database schemas
Implement daily and weekly jobs interacting with external interfaces
Coordinate with stakeholders to understand requirements
Direct team members in executing project milestones
Requirements
Bachelor's degree in an IT-related or Engineering field
Master's degree in IT-related or Engineering field
Senior Data Engineer responsible for building and operating metadata-driven ingestion pipelines, governing Snowflake data layers, and supporting AI initiatives within Cox Automotive’s Enterprise Platforms Data & Analytics organization.
Compensation
Compensation includes a base salary in the range of $101,500.00 - $169,100.00. The base salary may vary within the anticipated base pay range based on factors such as the ultimate location of the position and the selected candidate’s knowledge, skills, and abilities. Position may be eligible for additional compensation that may include an incentive program.
Responsibilities
Design, build, and operate metadata-driven ingestion and egress pipelines that land data from enterprise applications, databases, and third-party APIs into Snowflake
Own end-to-end delivery of features from refined requirement to production
Build governed consumption layers in Snowflake
Extend and harden shared libraries and frameworks
Define and enforce data-quality, reconciliation, and peer-validation standards
Requirements
Bachelor’s degree in Computer Science, Information Systems, or a related field, or equivalent practical experience
Manage SQL Server servers and instances, oversee migration and consolidation plans, monitor infrastructure, and tune performance.
Compensation
No-term full-time contract; Health Insurance; 22 days of paid vacation; 4 extra days annually (Carnival, Christmas Eve, New Year's Eve, Birthday); Meal Allowance on card (Coverflex); Referral Bonus; Special discounts and flex options; Training annual budget; A great team-oriented culture; Chance to become a part of a dynamically growing international company; Challenging projects giving the unique opportunity to grow and learn.
Responsibilities
Manage SQL Server servers and instances
Create and manage database and server migration/consolidation plans
Analyze and monitor database infrastructure using monitoring tools
Analyze and tune performance of instance or queries
Serves as the senior technical subject matter expert for infrastructure, application, and database modernization on the MOCAS Critical Stabilization (CS) Proof of Concept (PoC) effort supporting the DCMA/DFAS Joint Program Management Office (JPMO).
Locations (2)
United States
Columbus, Ohio, United States
Responsibilities
Lead the design, architecture, and implementation of the MOCAS database transition from the legacy hierarchical (Cincom SUPRA) database and flat file structure to a modern relational database.
Architect and deploy cloud-native database and infrastructure solutions within the vendor-established environment (e.g., AWS).
Develop database Entity-Relationship Diagrams (ERDs), design artifacts, and related technical documentation in support of the MOCAS 2.0 system design.
Provide technical direction and expert guidance on infrastructure and database upgrade alternatives.
Support systems engineering activities by contributing infrastructure and database expertise to the MOCAS LIM Systems Engineering Plan (SEP).