• Assist with the development and maintenance of new data repositories, databases, or infrastructure in IC storage repositories
• Develop Data Security Plans that ensures databases comply with data protections requirements and policies and incorporate a risk and recovery plan
• Employ specific tools for unique office needs as required, which may include interoperability with or ability to share information with other IC or state and local partners
• Formulate and apply mathematical modeling and other optimizing methods to develop and interpret information that assists management with decision making, policy formulation, or other managerial functions
• Collect and analyze data and develop decision support software, service, or products
• Develop and supply optimal time, cost, or logistics networks for program evaluation, review, or implementation
• Develop analytical solutions, databases, and data pipelines.
• Develop specifications for the most efficient database solutions.
• Performs work involved in the phases of developing software.

Skills: Data Repositories, Data Security, Risk Management, Mathematical Modeling, Data Analysis, Decision Support, Analytical Solutions, Database Development.

• Provide support for reporting needs through the design, development, and maintenance of a SQL Server data mart. 
• Design of tables, views, and stored procedures, the development of ETL processes, performance tuning, and automation.
• Ensures best practices, principles, and guidelines are used in developing data models as necessary for data management and analytics encompassing conceptual, logical and physical models.
• Exhibit excellent written and oral communication skills as well has having a customer oriented focus and provide technical support and training for fellow employees.
• Facilitate the mapping and auditability of information assets as they flow from upstream to downstream applications, thus ensuring optimal transparency, quality, consistency and controlled redundancy across the enterprise.
• Ensures that incoming work is prioritized appropriately to meet stakeholder needs and assists in resourcing appropriately.
• Identify and define the linkage of data within and across subject areas, and using metadata to accurately and uniquely identify data.
• Communicate complex ideas effectively with business partners.
• Ability to learn quickly and drive a team-oriented environment.

Skills: SQL Development, ETL Processes, Data Modeling, Technical Support, Data Mapping, Stakeholder Management, Metadata Management, Communication Skills.

• Works with constituent departments to fulfill database architecture development, support, and maintenance requests.
• Designs data structure and database components for use by Business Applications.
• Works with other groups as necessary to gather input for technical design and development.
• Recommends best practices for the development of data access including design and development of data access components.
• Works with development teams and database administration personnel to ensure optimal database performance, evaluating and making recommendations regarding code design, application interaction, physical design, etc.
• Acts as project manager or works with the project management group on scope definition, estimation of work effort, task definition, etc.
• Sets and follows design standards using industry best practices.
• Performs design and/or mentors team members in design and development for project work efforts.
• Creates technical documentation as required for all project work.
• Reviews progress with management.
• Coordinates unit testing of projects for release into production environment.

Skills: Database Architecture, Data Structure Design, Technical Collaboration, Data Access Development, Performance Optimization, Project Management, Design Standards, Technical Documentation.

• Provide database architecture expertise in the design, development, and deployment of the enterprise data warehouse
• Provide expert recommendations on data warehouse decisions to align IT decisions with the data warehouse strategic goals
• Lead and support in the technical evaluation of data models, ETL processes, server specifications, and reporting tool capabilities
• Identify and assist in the development of data ETL processes
• Lead and support in the developer documentation, processes, and diagrams for the data warehouse
• Participate and provide expertise in 3rd party vendor discussions related to the data warehouse
• Work with the District stakeholders to ensure the data warehouse meets data warehouse best practices and IT security standards
• Design and develop complex database load and maintenance processes.
• Delivers data architecture in line with the requirements of software products that are aligned with market, business and technology roadmap and strategy
• Design and document innovative and implementable database designs that satisfy complex technical software requirements, customer business requirements, business processes.
• Evaluate new technologies, develop POC’s for enhanced functionality
• Establish methods and procedures for tracking data quality, completeness, redundancy, and publish coding and design guidelines for improvement
• Take complete ownership of database related to delivering business processes in product roadmap.

Skills: Database Architecture, Data Warehouse Design, ETL Development, Technical Evaluation, Developer Documentation, Stakeholder Collaboration, IT Security, Data Quality Management.

• Data operations and reporting requirements analysis, understanding the use cases and performance criteria, working with stakeholders to maximize use and minimize cost
• Design of cloud native and hybrid cloud end-to-end data models and data store access, MDM systems, data pipelines, and storage solutions for platforms and applications
• Design data solutions for consistent or eventually consistent highly distributed application or application deployed across multiple availability zones
• Design data solutions for big data and data science application.
• Hands-on implementation and testing of data model and data store solutions, including designing state of the art stress testing capable of measuring scalability and availability
• Analyze and troubleshoot development and production issues, and perform a systematic root cause analysis
• Ensure performance, security, and availability of databases taking into account the overall strategy of Bitpanda
• Provision MySQL instances, both in clustered and non-clustered configurations together with DevOps via Terraform
• Ensure documentation and specifications are up to date
• Profile server resource usage, optimize and tweak based on future growth
• Assist teams with long term data migration plans
• Collaborate with other team members and stakeholders

Skills: Data Operations, Cloud Architecture, Data Pipeline Design, Data Modeling, Big Data Solutions, Database Optimization, Root Cause Analysis, DevOps Collaboration.

• Demonstrated experience working in all phases of full life cycle data analytics development: Requirements, Architecture, Design, Testing, and deployment
• Experience in defining and implementing legacy modernization and migration roadmaps for large scale applications, databases (Oracle to PostgreSQL) and database optimization
• Experience building applications using service-oriented, microservice, and/or API based architectures at an enterprise scale
• Experience with event-driven applications using queues, service bus and other related patterns
• Hands-on experience in developing proof of concepts and work with limited direction
• Strong analytical, communication, presentation and learning skills
• Experience with federal acquisition systems and processes
• Experience in working closely with technical leads, engineering teams and architecture stakeholders for technical issues and architecture framework capabilities for use by other development teams

Qualifications: BS in Computer Science with 10 years of Experience

• Strong experience in databases, tools, and methodologies
• Strong experience in Microsoft SQL Server (SSIS and SSAS) and Visual Studio
• Demonstrated proficiency in Data Analysis, Data Modeling, Data Integration, Data Warehousing, Database Design
• Experience with database performance evaluation and remediation
• Develops strategies for data acquisitions, archive recovery and implementation
• Be able to design and develop Databases, Data Warehouses and Relational Databases
• SQL development experience (TSQL, Views, Stored Procedures, Indexes)
• Experience working with Microsoft Power BI 
• Experience in Microsoft Azure SQL Database 
• Experience with browser-based web applications delivered over the Internet that support high user concurrency
• Ability to develop database strategies for flexible high-performance reporting and business intelligence
• Excellent verbal and writing skills, including the ability to research, design and write new documentation, as well as to maintain and improve existing material

Qualifications: BS in Information Technology with 3 years of Experience

• Experience with Database Administration and implementation
• Strong understanding of relational database and Data warehousing concepts
• Strong understanding and experience in database indexing, optimizer, query and memory tuning and effective partitioning
• Experiences with different database solutions, Oracle, MS SQL, Postgres
• Hands on experience in performance optimizations, understanding explain plans, redo logs/checkpoint tuning
• Ability to work with global teams and help advice and code database performance enhancements
• Proven experience designing and developing database schemas, architectures and models
• Experience writing complex SQL statements
• Experience in application architecture, network management, and performance management
• Experience in data management, data-oriented programming, and development
• Experience working in healthcare

Qualifications: BS in Software Engineering with 5 years of Experience

• Solid skill with at least one of the open source/commercial relational databases, say MySQL/PostgreSQL/Oracle/SQLServer/DB2.
• Any kind of NoSQL/bigdata knowledge
• Hands-on coding experience is an advantage, especially for mission-critical and high-concurrency/low-latency system.
• Good understanding of database industry, experience in architecting, designing and deploying data engineering infrastructure for collecting, aggregating and analyzing data.
• Experience in a ssisting with the development and maintenance of new data repositories, databases, or infrastructure in IC storage repositories
• Experience with developing Data Security Plans
• Active TS/SCI with Polygraph security clearance required
• Experience in Database Administration within MySQL v8 at enterprise level including complex clustering (InnoDB Cluster/NDB) and multi-master replication schemes.
• High level of expertise as a DBA in the administration, design and implementation of backups, performance tuning (using MySQL Enterprise Monitor or directly accessing the performance schema), management, and provisioning of MySQL database instances.
• Knowledge of Database operation on AWS
• Basic Linux system administration and bash scripting experience.
• Knowledge of Oracle and/or PostgreSQL/MSSQL/MariaDB would be a distinct advantage as well as the ability to work across a range of technologies and applications in support of MySQL.

Qualifications: BS in Database Management with 3years of Experience

• Experience in design and implementation of large-scale data platforms/solutions using major Cloud platforms: Amazon Web Services (AWS)
• Experience in data engineering with an emphasis on predictive data analytics, reporting and visualization
• Experience in the design and build of data extraction, transformation, and loading processes using data pipelines
• ETL/ELT/Python programming skills including experience with pipeline orchestration tools, logging, monitoring & alerting, deep troubleshooting, and automated testing & deployments
• Experience in SQL, data transformations, migration, statistical analysis, and troubleshooting across more than one Database Platform (Oracle, PostgreSQL, Redshift, Amazon RDS for Oracle etc.)
• Demonstrated experience in designing and building solutions utilizing various Cloud services such as EC2, S3, RDS, Redshift/Spectrum, Lambda, etc.
• Experience in translating business requirements into technical specifications, including data streams, integrations, transformations, databases, and data warehouses
• Experience in defining and implementing data access patterns for analytical and operational workloads, across on-premises and cloud-based platforms
• Experience in defining and executing enterprise level strategy on building data storage infrastructure, data pipelines, data warehouses, data lakes, data APIs and self-service tooling for diverse types of data (structured and unstructured), and diverse workloads/dataflows (transactional, analytics, Machine Learning pipelines)

Qualifications: BS in Information Systems with 7 years of Experience