- 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.
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.
- Set up database clusters, backup, or recovery processes.
- 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.
- 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.
- Set up database clusters, backup, or recovery processes.
- 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.
- 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.
- Maintain or modify existing Geographic Information Systems (GIS) databases.
- Design or coordinate the development of integrated Geographic Information Systems (GIS) spatial or non-spatial databases.
- Develop specialized computer software routines, internet-based Geographic Information Systems (GIS) databases, or business applications to customize geographic information.
- Produce data layers, maps, tables, or reports, using spatial analysis procedures or Geographic Information Systems (GIS) technology, equipment, or systems.
- Design or prepare graphic representations of Geographic Information Systems (GIS) data, using GIS hardware or software applications.
- Provide technical expertise in Geographic Information Systems (GIS) technology to clients or users.
- Perform computer programming, data analysis, or software development for Geographic Information Systems (GIS) applications, including the maintenance of existing systems or research and development for future enhancements.
- Enter data into Geographic Information Systems (GIS) databases, using techniques such as coordinate geometry, keyboard entry of tabular data, manual digitizing of maps, scanning or automatic conversion to vectors, or conversion of other sources of digital data.
- Review existing or incoming data for currency, accuracy, usefulness, quality, or completeness of documentation.
- Perform geospatial data building, modeling, or analysis, using advanced spatial analysis, data manipulation, or cartography software.
- Perform integrated or computerized Geographic Information Systems (GIS) analyses to address scientific problems.
- Select cartographic elements needed for effective presentation of information.
- Provide technical support to users or clients regarding the maintenance, development, or operation of Geographic Information Systems (GIS) databases, equipment, or applications.
- Collect, compile, or integrate Geographic Information Systems (GIS) data, such as remote sensing or cartographic data for inclusion in map manuscripts.
- Interpret aerial or ortho photographs.
- Meet with clients to discuss topics such as technical specifications, customized solutions, or operational problems.
- Document, design, code, or test Geographic Information Systems (GIS) models, internet mapping solutions, or other applications.
- Create, analyze, report, convert, or transfer data, using specialized applications program software.
- Confer with users to analyze, configure, or troubleshoot applications.
- Design, program, or model Geographic Information Systems (GIS) applications or procedures.
- Make recommendations regarding upgrades, considering implications of new or revised Geographic Information Systems (GIS) software, equipment, or applications.
- Assist users in formulating Geographic Information Systems (GIS) requirements or understanding the implications of alternatives.
- Create visual representations of geospatial data, using complex procedures such as analytical modeling, three-dimensional renderings, or plot creation.
- Transfer or rescale information from original photographs onto maps or other photographs.
- Prepare training materials for, or make presentations to, Geographic Information Systems (GIS) users.
- Apply three-dimensional (3D) or four-dimensional (4D) technologies to geospatial data to allow for new or different analyses or applications.
- Conduct research, data analysis, systems design, or support for software such as Geographic Information Systems (GIS) or Global Positioning Systems (GPS) mapping software.
- Read current literature, talk with colleagues, continue education, or participate in professional organizations or conferences to keep abreast of developments in Geographic Information Systems (GIS) technology, equipment, or systems.
- Recommend procedures, equipment, or software upgrades to increase data accessibility or ease of use.
- Maintain or modify existing Geographic Information Systems (GIS) databases.
- Design or coordinate the development of integrated Geographic Information Systems (GIS) spatial or non-spatial databases.
- Develop specialized computer software routines, internet-based Geographic Information Systems (GIS) databases, or business applications to customize geographic information.
- 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.
