- Design or coordinate the development of integrated Geographic Information Systems (GIS) spatial or non-spatial databases.
Occupations with related tasks Save Table: XLSX CSV
- Develop and document database architectures.
- Design databases to support business applications, ensuring system scalability, security, performance, and reliability.
- Design database applications, such as interfaces, data transfer mechanisms, global temporary tables, data partitions, and function-based indexes to enable efficient access of the generic database structure.
- Plan and install upgrades of database management system software to enhance database performance.
- Set up database clusters, backup, or recovery processes.
- Write and code logical and physical database descriptions, and specify identifiers of database to management system or direct others in coding descriptions.
- Establish and calculate optimum values for database parameters, using manuals and calculators.
- Collaborate with system architects, software architects, design analysts, and others to understand business or industry requirements.
- Develop database architectural strategies at the modeling, design and implementation stages to address business or industry requirements.
- Develop data models for applications, metadata tables, views or related database structures.
- Develop methods for integrating different products so they work properly together, such as customizing commercial databases to fit specific needs.
- Create and enforce database development standards.
- Document and communicate database schemas, using accepted notations.
- Develop data model describing data elements and their use, following procedures and using pen, template or computer software.
- Work as part of a project team to coordinate database development and determine project scope and limitations.
- Identify and evaluate industry trends in database systems to serve as a source of information and advice for upper management.
- Demonstrate database technical functionality, such as performance, security and reliability.
- Develop load-balancing processes to eliminate down time for backup processes.
- Identify, evaluate and recommend hardware or software technologies to achieve desired database performance.
- Test programs or databases, correct errors, and make necessary modifications.
- Identify and correct deviations from database development standards.
- Review project requests describing database user needs to estimate time and cost required to accomplish project.
- Develop or maintain archived procedures, procedural codes, or queries for applications.
- Provide technical support to junior staff or clients.
- Train users and answer questions.
- Develop and document database architectures.
- Design databases to support business applications, ensuring system scalability, security, performance, and reliability.
- Design database applications, such as interfaces, data transfer mechanisms, global temporary tables, data partitions, and function-based indexes to enable efficient access of the generic database structure.
- Plan and install upgrades of database management system software to enhance database performance.
- Set up database clusters, backup, or recovery processes.
- Write and code logical and physical database descriptions, and specify identifiers of database to management system or direct others in coding descriptions.
- Establish and calculate optimum values for database parameters, using manuals and calculators.
- Modify existing databases and database management systems or direct programmers and analysts to make changes.
- Plan and install upgrades of database management system software to enhance database performance.
- Write and code logical and physical database descriptions and specify identifiers of database to management system, or direct others in coding descriptions.
- Revise company definition of data as defined in data dictionary.
- Plan, coordinate, and implement security measures to safeguard information in computer files against accidental or unauthorized damage, modification or disclosure.
- Specify users and user access levels for each segment of database.
- Test changes to database applications or systems.
- Test programs or databases, correct errors, and make necessary modifications.
- Train users and answer questions.
- Provide technical support to junior staff or clients.
- Approve, schedule, plan, and supervise the installation and testing of new products and improvements to computer systems, such as the installation of new databases.
- Develop standards and guidelines for the use and acquisition of software and to protect vulnerable information.
- Develop data models describing data elements and how they are used, following procedures and using pen, template, or computer software.
- Select and enter codes to monitor database performance and to create production databases.
- Identify, evaluate and recommend hardware or software technologies to achieve desired database performance.
- Review procedures in database management system manuals to make changes to database.
- Identify and evaluate industry trends in database systems to serve as a source of information and advice for upper management.
- Review workflow charts developed by programmer analyst to understand tasks computer will perform, such as updating records.
- Modify existing databases and database management systems or direct programmers and analysts to make changes.
- Plan and install upgrades of database management system software to enhance database performance.
- Write and code logical and physical database descriptions and specify identifiers of database to management system, or direct others in coding descriptions.
- Revise company definition of data as defined in data dictionary.
- Create and maintain a database of completed appraisals.
- Calculate the value of property based on comparisons to recent sales, estimated cost to reproduce, and anticipated property income streams.
- Determine the appropriate type of valuation to make, such as fair market, replacement, or liquidation, based on the needs of the property owner.
- Document physical characteristics of property such as measurements, quality, and design.
- Forecast the value of property.
- Inspect personal or business property.
- Locate and record data on sales of comparable property using specialized software, internet searches, or personal records.
- Recommend loan amounts based on the value of property being used as collateral.
- Take photographs of property.
- Testify in court as to the value of a piece of tangible property.
- Update appraisals when property has been improved, damaged, or has otherwise changed.
- Verify that property matches legal descriptions or certifications.
- Write and submit appraisal reports for property, such as jewelry, art, antiques, collectibles, and equipment.
- Write descriptions of the property being appraised.
- Create and maintain a database of completed appraisals.
- Design databases to support healthcare applications, ensuring security, performance and reliability.
- Assign the patient to diagnosis-related groups (DRGs), using appropriate computer software.
- Compile medical care and census data for statistical reports on diseases treated, surgery performed, or use of hospital beds.
- Develop in-service educational materials.
- Evaluate and recommend upgrades or improvements to existing computerized healthcare systems.
- Facilitate and promote activities, such as lunches, seminars, or tours, to foster healthcare information privacy or security awareness within the organization.
- Identify, compile, abstract, and code patient data, using standard classification systems.
- Manage the department or supervise clerical workers, directing or controlling activities of personnel in the medical records department.
- Monitor changes in legislation and accreditation standards that affect information security or privacy in the computerized healthcare system.
- Plan, develop, maintain, or operate a variety of health record indexes or storage and retrieval systems to collect, classify, store, or analyze information.
- Prepare statistical reports, narrative reports, or graphic presentations of information, such as tumor registry data for use by hospital staff, researchers, or other users.
- Protect the security of medical records to ensure that confidentiality is maintained.
- Resolve or clarify codes or diagnoses with conflicting, missing, or unclear information by consulting with doctors or others or by participating in the coding team's regular meetings.
- Retrieve patient medical records for physicians, technicians, or other medical personnel.
- Train medical records staff.
- Write or maintain archived procedures, procedural codes, or queries for applications.
- Design databases to support healthcare applications, ensuring security, performance and reliability.
- Design and implement data repositories to integrate data.
- Assess blockchain threats, such as untested code and unprotected keys.
- Automate the deployment of software updates over geographically distributed network nodes.
- Design and deploy blockchain design patterns to make transactions secure, transparent, and immutable.
- Design and develop blockchain technologies for industries such as finance and music.
- Design and implement dashboard and data visualizations to meet customer reporting needs.
- Design and verify cryptographic protocols to protect private information.
- Determine specifications for, or implement, logging.
- Develop a maintainable code base using object-oriented design principles, practices, or patterns.
- Discuss and plan systems with solution architects, system engineers, or cybersecurity experts to meet customer requirements.
- Discuss data needs with engineers, product managers, or data scientists to identify blockchain requirements.
- Evaluate blockchain processes or risks based on security assessments or control matrix reviews.
- Evaluate new blockchain technologies and vendor products.
- Implement catastrophic failure handlers to identify security breaches and prevent serious damage.
- Run infrastructure tests to examine the behavior of large peer-to-peer networks.
- Test the security and performance of blockchain infrastructures.
- Update client and server applications responsible for integration and business logic.
- Design and implement data repositories to integrate data.
- Create business intelligence tools or systems, including design of related databases, spreadsheets, or outputs.
- Generate standard or custom reports summarizing business, financial, or economic data for review by executives, managers, clients, and other stakeholders.
- Synthesize current business intelligence or trend data to support recommendations for action.
- Maintain library of model documents, templates, or other reusable knowledge assets.
- Manage timely flow of business intelligence information to users.
- Collect business intelligence data from available industry reports, public information, field reports, or purchased sources.
- Analyze competitive market strategies through analysis of related product, market, or share trends.
- Maintain or update business intelligence tools, databases, dashboards, systems, or methods.
- Identify or monitor current and potential customers, using business intelligence tools.
- Disseminate information regarding tools, reports, or metadata enhancements.
- Provide technical support for existing reports, dashboards, or other tools.
- Identify and analyze industry or geographic trends with business strategy implications.
- Communicate with customers, competitors, suppliers, professional organizations, or others to stay abreast of industry or business trends.
- Create or review technical design documentation to ensure the accurate development of reporting solutions.
- Analyze technology trends to identify markets for future product development or to improve sales of existing products.
- Conduct or coordinate tests to ensure that intelligence is consistent with defined needs.
- Document specifications for business intelligence or information technology reports, dashboards, or other outputs.
- Create business intelligence tools or systems, including design of related databases, spreadsheets, or outputs.
- Design and implement warehouse database structures.
- Develop data warehouse process models, including sourcing, loading, transformation, and extraction.
- Verify the structure, accuracy, or quality of warehouse data.
- Map data between source systems, data warehouses, and data marts.
- Develop and implement data extraction procedures from other systems, such as administration, billing, or claims.
- Develop or maintain standards, such as organization, structure, or nomenclature, for the design of data warehouse elements, such as data architectures, models, tools, and databases.
- Provide or coordinate troubleshooting support for data warehouses.
- Write new programs or modify existing programs to meet customer requirements, using current programming languages and technologies.
- Design, implement, or operate comprehensive data warehouse systems to balance optimization of data access with batch loading and resource utilization factors, according to customer requirements.
- Perform system analysis, data analysis or programming, using a variety of computer languages and procedures.
- Create supporting documentation, such as metadata and diagrams of entity relationships, business processes, and process flow.
- Create or implement metadata processes and frameworks.
- Review designs, codes, test plans, or documentation to ensure quality.
- Create plans, test files, and scripts for data warehouse testing, ranging from unit to integration testing.
- Select methods, techniques, or criteria for data warehousing evaluative procedures.
- Prepare functional or technical documentation for data warehouses.
- Test software systems or applications for software enhancements or new products.
- Implement business rules via stored procedures, middleware, or other technologies.
- Design and implement warehouse database structures.
- Design and validate clinical databases, including designing or testing logic checks.
- Process clinical data, including receipt, entry, verification, or filing of information.
- Generate data queries, based on validation checks or errors and omissions identified during data entry, to resolve identified problems.
- Develop project-specific data management plans that address areas such as coding, reporting, or transfer of data, database locks, and work flow processes.
- Monitor work productivity or quality to ensure compliance with standard operating procedures.
- Prepare appropriate formatting to data sets as requested.
- Design forms for receiving, processing, or tracking data.
- Prepare data analysis listings and activity, performance, or progress reports.
- Confer with end users to define or implement clinical system requirements such as data release formats, delivery schedules, and testing protocols.
- Perform quality control audits to ensure accuracy, completeness, or proper usage of clinical systems and data.
- Analyze clinical data using appropriate statistical tools.
- Evaluate processes and technologies, and suggest revisions to increase productivity and efficiency.
- Develop technical specifications for data management programming and communicate needs to information technology staff.
- Write work instruction manuals, data capture guidelines, or standard operating procedures.
- Supervise the work of data management project staff.
- Contribute to the compilation, organization, and production of protocols, clinical study reports, regulatory submissions, or other controlled documentation.
- Read technical literature and participate in continuing education or professional associations to maintain awareness of current database technology and best practices.
- Train staff on technical procedures or software program usage.
- Develop or select specific software programs for various research scenarios.
- Provide support and information to functional areas such as marketing, clinical monitoring, and medical affairs.
- Track the flow of work forms, including in-house data flow or electronic forms transfer.
- Design and validate clinical databases, including designing or testing logic checks.
- Design or maintain databases of biological data.
- Draw conclusions or make predictions, based on data summaries or statistical analyses.
- Analyze clinical or survey data, using statistical approaches such as longitudinal analysis, mixed-effect modeling, logistic regression analyses, and model-building techniques.
- Write detailed analysis plans and descriptions of analyses and findings for research protocols or reports.
- Calculate sample size requirements for clinical studies.
- Read current literature, attend meetings or conferences, and talk with colleagues to keep abreast of methodological or conceptual developments in fields such as biostatistics, pharmacology, life sciences, and social sciences.
- Design research studies in collaboration with physicians, life scientists, or other professionals.
- Prepare tables and graphs to present clinical data or results.
- Write program code to analyze data with statistical analysis software.
- Review clinical or other medical research protocols and recommend appropriate statistical analyses.
- Develop or implement data analysis algorithms.
- Determine project plans, timelines, or technical objectives for statistical aspects of biological research studies.
- Prepare statistical data for inclusion in reports to data monitoring committees, federal regulatory agencies, managers, or clients.
- Plan or direct research studies related to life sciences.
- Prepare articles for publication or presentation at professional conferences.
- Monitor clinical trials or experiments to ensure adherence to established procedures or to verify the quality of data collected.
- Apply research or simulation results to extend biological theory or recommend new research projects.
- Develop or use mathematical models to track changes in biological phenomena, such as the spread of infectious diseases.
- Assign work to biostatistical assistants or programmers.
- Analyze archival data, such as birth, death, and disease records.
- Design surveys to assess health issues.
- Teach graduate or continuing education courses or seminars in biostatistics.
- Provide biostatistical consultation to clients or colleagues.
- Write research proposals or grant applications for submission to external bodies.
- Collect data through surveys or experimentation.
- Design or maintain databases of biological data.
- Develop databases that support Web applications and Web sites.
- Write supporting code for Web applications or Web sites.
- Design, build, or maintain Web sites, using authoring or scripting languages, content creation tools, management tools, and digital media.
- Back up files from Web sites to local directories for instant recovery in case of problems.
- Select programming languages, design tools, or applications.
- Evaluate code to ensure that it is valid, is properly structured, meets industry standards, and is compatible with browsers, devices, or operating systems.
- Perform Web site tests according to planned schedules, or after any Web site or product revision.
- Perform or direct Web site updates.
- Maintain understanding of current Web technologies or programming practices through continuing education, reading, or participation in professional conferences, workshops, or groups.
- Analyze user needs to determine technical requirements.
- Respond to user email inquiries, or set up automated systems to send responses.
- Renew domain name registrations.
- Confer with management or development teams to prioritize needs, resolve conflicts, develop content criteria, or choose solutions.
- Communicate with network personnel or Web site hosting agencies to address hardware or software issues affecting Web sites.
- Collaborate with management or users to develop e-commerce strategies and to integrate these strategies with Web sites.
- Document test plans, testing procedures, or test results.
- Establish appropriate server directory trees.
- Recommend and implement performance improvements.
- Document technical factors such as server load, bandwidth, database performance, and browser and device types.
- Develop or implement procedures for ongoing Web site revision.
- Create Web models or prototypes that include physical, interface, logical, or data models.
- Provide clear, detailed descriptions of Web site specifications, such as product features, activities, software, communication protocols, programming languages, and operating systems software and hardware.
- Evaluate or recommend server hardware or software.
- Monitor security system performance logs to identify problems and notify security specialists when problems occur.
- Install and configure hypertext transfer protocol (HTTP) servers and associated operating systems.
- Research, document, rate, or select alternatives for Web architecture or technologies.
- Develop system interaction or sequence diagrams.
- Design and implement Web site security measures, such as firewalls and message encryption.
- Incorporate technical considerations into Web site design plans, such as budgets, equipment, performance requirements, and legal issues including accessibility and privacy.
- Develop databases that support Web applications and Web sites.
- Create or maintain databases of known test defects.
- Identify, analyze, and document problems with program function, output, online screen, or content.
- Document software defects, using a bug tracking system, and report defects to software developers.
- Develop testing programs that address areas such as database impacts, software scenarios, regression testing, negative testing, error or bug retests, or usability.
- Design test plans, scenarios, scripts, or procedures.
- Document test procedures to ensure replicability and compliance with standards.
- Provide feedback and recommendations to developers on software usability and functionality.
- Install, maintain, or use software testing programs.
- Test system modifications to prepare for implementation.
- Develop or specify standards, methods, or procedures to determine product quality or release readiness.
- Monitor bug resolution efforts and track successes.
- Update automated test scripts to ensure currency.
- Participate in product design reviews to provide input on functional requirements, product designs, schedules, or potential problems.
- Plan test schedules or strategies in accordance with project scope or delivery dates.
- Monitor program performance to ensure efficient and problem-free operations.
- Conduct software compatibility tests with programs, hardware, operating systems, or network environments.
- Investigate customer problems referred by technical support.
- Review software documentation to ensure technical accuracy, compliance, or completeness, or to mitigate risks.
- Identify program deviance from standards, and suggest modifications to ensure compliance.
- Perform initial debugging procedures by reviewing configuration files, logs, or code pieces to determine breakdown source.
- Design or develop automated testing tools.
- Install and configure recreations of software production environments to allow testing of software performance.
- Collaborate with field staff or customers to evaluate or diagnose problems and recommend possible solutions.
- Coordinate user or third-party testing.
- Visit beta testing sites to evaluate software performance.
- Conduct historical analyses of test results.
- Evaluate or recommend software for testing or bug tracking.
- Modify existing software to correct errors, allow it to adapt to new hardware, or to improve its performance.
- Recommend purchase of equipment to control dust, temperature, or humidity in area of system installation.
- Store, retrieve, and manipulate data for analysis of system capabilities and requirements.
- Create or maintain databases of known test defects.
