We are immediately seeking a senior-level Data Architect/SQL Database Developer to support the Geospatial Research, Analysis and Services Program (GRASP), which is a program within the Agency for Toxic Substances and Disease Registry (ATSDR). GRASP is responsible for geospatial analysis, research, and technology as applied to diverse public health domains including environmental health, site-specific exposure, infectious and chronic disease, injury, and emergency preparedness and response. GRASP works with ATSDR, other Centers for Disease Control and Prevention (CDC) centers/institutes/offices, state/local health organizations, other federal agencies, international governments, academia, and advocacy groups. Work will include supporting various public health projects, such as COVID-19, diabetes, cancer, health disparities, and others.
The position will be based at the CDC Chamblee, GA office location with remote support currently provided.
- Provide high-level expertise to design, develop, process, and prepare relational, third normal form (3NF) public health database(s).
- Develop and design import and validation methodologies to import datasets in a variety of formats including, but not limited to, MS Excel, Adobe PDF, MS SQL Server, and paper documents.
- Develop Structured Query Language (SQL) queries, ETL processes, and Transact-SQL (T-SQL) stored procedures to support data validation, manipulation, and/or preparation of public health databases.
- Design and develop database and ETL (Extract, Transform, and Load) processes and scripts to support web application development and data processing.
- Design processes, create procedures, and implement database indexing methods to optimize database performance.
- Provide guidance to GRASP in the development of novel procedures and protocols to import, validate, and manipulate data contained in databases.
- Perform data mining on databases to discover geospatial, temporal, and other types of patterns and trends.
- Monitor GIS database backups and other time-based routines and/or automated procedures.
- Manage, prepare, and structure GIS data.
- Prepare documentation outlining standards, methods, and tools used in all aspects of the management of databases.
- Support the deployment and administration of mobile technologies, processes, and devices to gather spatially referenced data from the field to support public health investigation and practice.
- Manage and organize both vector and raster file-based GIS data and provide user support in connecting to GIS databases.
- Provide expertise in the full stack design, development, and implementation of complex web/mobile/desktop applications.
- Understand entire web development process (design, development, and deployment).
- Design and develop application components, in particular, the application back-end; support custom web application development and support.
- Create and support SQL development to include, but not limited to advance and efficient stored procedures and SQL functions.
- Optimally design and develop databases, tables, views, stored procedures, user defined functions, SSIS packages, and other database objects using SQL Server 2016.
- Perform code review, unit and quality assurance testing, and issue resolution supporting all levels from development to production.
- Work closely with the Database Administrators, enterprise architect and lead developers to ensure that the application design conforms to standards.
- Make use of SQL, C#, and Common Runtime Language (CLR) for backend database programming support.
- Deliver JSON-object packages to developers.
- Build routines to manipulate datasets and data flows.
- Load data from CDC partner sources.
- Work independently following all standards and patterns in place to complete work assignments.
- Work with development teams using Agile methodologies.
- Document and diagram databases as needed; create database dictionaries for new and existing databases.
- Degree in Computer Science, Business Administration, or related field
- Requires 8 to 10 years with BS/BA or 6 to 8 years with MS/MA or 3 to 5 years with PhD.
- 10+ years (or 5+ years with an advanced degree) of experience in database development
- Experience with relational database design, development, management, and administration
- Experience designing, developing, testing, implementing, maintaining, documenting, and providing administrative support for GIS and general public health databases
- Strong experience writing stored procedures
- Experience developing and maintaining GIS metadata
- Ability to analyze, monitor, and manipulate GIS spatial data and make recommendations for fine tuning analysis and optimization of database performance
- Experience developing and designing import and validation methodologies to import datasets in a variety of formats
- Excellent oral and written communication skills are a must