Database Analyst - DRT Strategies, Inc.
Atlanta, GA
About the Job
Overview
DRT Strategies delivers expert management consulting and information technology (IT) solutions to large federal agencies, the U.S. Navy, state and local government and commercial clients in health care, technology, and financial services industries.
The three letters of our name, DRT, stand for Driving Resolution Together, which is the core philosophy on which the company was founded. That is, we collaborate with our clients to solve their most pressing challenges - together.
We are problem solvers dedicated to your success, combining Fortune 500 experience with small business responsiveness. We have established a reputation with our clients as a forward-thinking consulting firm with demonstrated success in implementing solutions that lead to meaningful results. Our world-class consultants unite people to work collaboratively to achieve project goals and make vision a reality.
What you will be supporting:
DRT supports the NCIPC Partners Portal modernization that will play a critical role accommodating a growing amount of data and scale to provide services that support an increasing number of recipients. We will address data challenges pertaining to collection, management, analysis, visualization and communication of public health surveillance and Notice of Funding Opportunity (NOFO) data. DRT will deliver a solution that will allow for the scalability to add additional partners and data, use CDC tested tools and processes to secure data early in the development process, and implement a design process focused on the user to increase customer satisfaction and useability.
What are we looking for:
The Database Administrator works directly with public health GIS analysts, coordinators, epidemiologists, and other technologists. The DBA analyses, monitors, and manipulates data for optimal database performance. Accesses public health databases, data structures, and data flows to recommend and perform the import, structuring, and encoding of public health data.
Fun stuff you will do on the job:
• Designs, builds, and maintains multiple databases for use with public health data
• Works with analysts, subject matter experts, and technologists to determine and implement database systems
• Monitors database performance and recommends and implements enhancements
• Conduct a thorough analysis of the current Partners Portal database architecture
• Evaluate scalability, flexibility, security measures, performance optimization potential, and adherence to industry best practices
• Develop an implementation plan for integrating advanced data analytics capabilities into the Partners Portal system
• Outline requirements for data collection, analysis tools or algorithms needed to derive meaningful insights from partner-related data
• Identify strengths and weaknesses within the existing architecture
• Respond to error handling during data ingestion
• Address timely to scalability challenges with increased dataset sizes
• Ensure data quality processes to ensure accuracy, completeness, and consistency of data ingested into the system from Excel sheet
• Establish data government and compliance with relevant regulations, privacy policies and security standards
• Develop automated validation scripts or tools to identify and flag data validation errors in Excel sheets with hundreds, thousands, or hundreds of thousands of rows
• Implement error handling mechanisms to capture and report specific validation errors for manual review and correction
• Develops and manages a schedule to meet deliverables and establish estimated completion dates
• Follows the government’s software development lifecycle framework and provides agreed upon project documentation
• Completes tasks on time with minimal supervision but supports collaboration across teams
This is you:
• Experience with database systems like MySQL or PostgreSQL for efficient data storage and retrieval
• In-depth understanding of relational databases including advanced SQL querying techniques for complex data retrieval, aggregation, filtering, and joins
• Experience in designing normalized database schemas with appropriate indexing strategies to ensure data integrity and optimize query performance
• Proficiency in utilizing database migration tools (e.g., Alembic) for seamless schema updates across different environments
• Must have or be able to obtain a Public Trust with the US federal government
• At least seven years’ experience in database administration roles
• Advanced understanding of relational database design, development, and management
• Familiarity with common API languages
• Knowledge of public health data and related privacy requirements (HIPPA, PII, etc.)
You will wow us even more if you have these skills:
• Recent experience with CDC environment and standards: SDLC, technical architecture, release processes
• Experience with Agile and DevOps methodologies
• Knowledge of EDAV techniques using tools like Data Bricks notebooks for data analysis, visualization, and reporting
Education & Training:
• Bachelor’s Degree in Computer Science, GIS or related field; Master’s Degree preferred
DRT’s culture is reflective of our core values:
Currently due to the remote working status of the federal government, most DRT employees are teleworking from home and leveraging video conferencing along with other virtual productivity tools. Under normal circumstances, most of our positions are required to report onsite. However, DRT has not yet determined when employees will be required to return to their onsite workspaces. Please be aware that at the time a date is determined to return to the worksite, the requirement of this position may be to report in person to the work location.
DRT Strategies, Inc. (DRT) celebrates diversity and is proud to provide Equal Employment Opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, genetics, disability, or protected veteran status. In addition to federal law requirements, DRT complies with applicable state and local laws governing non-discrimination in employment in every location in which the company has facilities.
DRT Strategies delivers expert management consulting and information technology (IT) solutions to large federal agencies, the U.S. Navy, state and local government and commercial clients in health care, technology, and financial services industries.
The three letters of our name, DRT, stand for Driving Resolution Together, which is the core philosophy on which the company was founded. That is, we collaborate with our clients to solve their most pressing challenges - together.
We are problem solvers dedicated to your success, combining Fortune 500 experience with small business responsiveness. We have established a reputation with our clients as a forward-thinking consulting firm with demonstrated success in implementing solutions that lead to meaningful results. Our world-class consultants unite people to work collaboratively to achieve project goals and make vision a reality.
What you will be supporting:
DRT supports the NCIPC Partners Portal modernization that will play a critical role accommodating a growing amount of data and scale to provide services that support an increasing number of recipients. We will address data challenges pertaining to collection, management, analysis, visualization and communication of public health surveillance and Notice of Funding Opportunity (NOFO) data. DRT will deliver a solution that will allow for the scalability to add additional partners and data, use CDC tested tools and processes to secure data early in the development process, and implement a design process focused on the user to increase customer satisfaction and useability.
What are we looking for:
The Database Administrator works directly with public health GIS analysts, coordinators, epidemiologists, and other technologists. The DBA analyses, monitors, and manipulates data for optimal database performance. Accesses public health databases, data structures, and data flows to recommend and perform the import, structuring, and encoding of public health data.
Fun stuff you will do on the job:
• Designs, builds, and maintains multiple databases for use with public health data
• Works with analysts, subject matter experts, and technologists to determine and implement database systems
• Monitors database performance and recommends and implements enhancements
• Conduct a thorough analysis of the current Partners Portal database architecture
• Evaluate scalability, flexibility, security measures, performance optimization potential, and adherence to industry best practices
• Develop an implementation plan for integrating advanced data analytics capabilities into the Partners Portal system
• Outline requirements for data collection, analysis tools or algorithms needed to derive meaningful insights from partner-related data
• Identify strengths and weaknesses within the existing architecture
• Respond to error handling during data ingestion
• Address timely to scalability challenges with increased dataset sizes
• Ensure data quality processes to ensure accuracy, completeness, and consistency of data ingested into the system from Excel sheet
• Establish data government and compliance with relevant regulations, privacy policies and security standards
• Develop automated validation scripts or tools to identify and flag data validation errors in Excel sheets with hundreds, thousands, or hundreds of thousands of rows
• Implement error handling mechanisms to capture and report specific validation errors for manual review and correction
• Develops and manages a schedule to meet deliverables and establish estimated completion dates
• Follows the government’s software development lifecycle framework and provides agreed upon project documentation
• Completes tasks on time with minimal supervision but supports collaboration across teams
This is you:
• Experience with database systems like MySQL or PostgreSQL for efficient data storage and retrieval
• In-depth understanding of relational databases including advanced SQL querying techniques for complex data retrieval, aggregation, filtering, and joins
• Experience in designing normalized database schemas with appropriate indexing strategies to ensure data integrity and optimize query performance
• Proficiency in utilizing database migration tools (e.g., Alembic) for seamless schema updates across different environments
• Must have or be able to obtain a Public Trust with the US federal government
• At least seven years’ experience in database administration roles
• Advanced understanding of relational database design, development, and management
• Familiarity with common API languages
• Knowledge of public health data and related privacy requirements (HIPPA, PII, etc.)
You will wow us even more if you have these skills:
• Recent experience with CDC environment and standards: SDLC, technical architecture, release processes
• Experience with Agile and DevOps methodologies
• Knowledge of EDAV techniques using tools like Data Bricks notebooks for data analysis, visualization, and reporting
Education & Training:
• Bachelor’s Degree in Computer Science, GIS or related field; Master’s Degree preferred
DRT’s culture is reflective of our core values:
- Professionalism: Be a leader and someone your customers and colleagues can count on by taking ownership and accountability for your work. Demonstrate a solution-oriented mindset and bias for action. Show empathy, dignity, and respect for each other. Be "high minded", maintain a calm demeanor when dealing with ambiguity or adversity and stay out of the fray (i.e., avoid drama).
- Quality: Do things right and do the right thing. Pursue excellence in your work by delivering quality services and products that provide high value and return on investment (ROI).
- Teamwork: Work with each other, the customer, and DRT. Demonstrate flexibility, a positive attitude and willingness to work collaboratively to help others and share information.
- Customer Mission Focused: Commit to customer success and strive to exceed expectations by understanding the mission, executing the customer's vision, and solving challenges to drive results and achieve mission goals. Build meaningful customer relationships by asking thoughtful questions, listening, and operating transparently.
- Growth Mindedness: Commit to company, team, and personal growth. Embrace an entrepreneurial spirit by actively seeking opportunities to support new customer projects and/or solve problems. Actively work to improve your skills, learn to be comfortable with ambiguity, and be resourceful and willing to figure things out and add value.
Currently due to the remote working status of the federal government, most DRT employees are teleworking from home and leveraging video conferencing along with other virtual productivity tools. Under normal circumstances, most of our positions are required to report onsite. However, DRT has not yet determined when employees will be required to return to their onsite workspaces. Please be aware that at the time a date is determined to return to the worksite, the requirement of this position may be to report in person to the work location.
DRT Strategies, Inc. (DRT) celebrates diversity and is proud to provide Equal Employment Opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, genetics, disability, or protected veteran status. In addition to federal law requirements, DRT complies with applicable state and local laws governing non-discrimination in employment in every location in which the company has facilities.
Powered by JazzHR
Source : DRT Strategies, Inc.