Database Management Specialists develop and administer large-scale, multi-agency database systems. They have responsibility for maintenance, tuning, running backup and recovery, growing the system, administering permissions and security, and assuring continuous system availability.
Essential Functions: (The functions listed are characteristic of the type and level of work associated with this group and pay band. They are not all-inclusive. Individual positions may perform some or all, as well as other similar work.)
Design, develop, and maintain data management systems that meet current and future business requirements.
Design, develop and maintain databases. Recommend new or modified standards, methods, and procedures.
Define, allocate, and modify storage capacity.
Develop data dictionaries, data models, metadata repositories, and other data management tools.
Produce database design schema for integrating source data into data management systems.
Ensure data compliance with data exchange formats and database structure.
Monitor and optimize database performance and tune database operations.
Troubleshoot database problems.
Advise participating state and tribal agencies of new database features, provide technical guidance, and assist with database design and implementation.
Generate complex queries and reports. Oversee data distribution systems, including user interface and reporting capabilities.
Participate in the design of data mining and data warehousing systems.
The supervisor provides project goals, objectives, priorities, and deadlines. The employee proceeds independently, using experience and knowledge to complete objectives. The employee reports periodically on work progress and potentially controversial matters. Work is expected to be complete, accurate, and timely. It is reviewed for soundness of overall approach and effectiveness in meeting requirements or producing expected results.
Guidelines include project level documents, data exchange standards, and system maintenance procedures. The guidelines are general in nature and address policies, procedures, and standards. Equipment and software manuals and technical documentation are available.
Precedents are available outlining the preferred approach to more general problems or issues. The employee uses judgment in determining which appropriate alternatives should be used, in interpreting and adapting guidelines to specific situations or problems, in analyzing results, and in making changes.
The work consists of maintaining and supporting databases, including adding new elements to databases as directed. Multiple agencies, tribes, and individuals contribute and use data from the databases, and the work is complicated substantially by the fact that they operate under different policy directives and data collection and compilation procedures.
Scope and Effect:
The work involves managing data systems to meet the identified needs of multiple users. The employee determines the need for changes in access methods, storage media, or other elements based on usage and performance trends. He/she troubleshoots a wide range of accessibility and availability issues.
These data systems serve as primary sources of information for high profile programs. The employee's work ultimately affects decision making and management of biological and environmental resources and future expenditures on fish and wildlife projects.
Contacts within PSMFC include working with the data managers of other projects, the PSMFC computer services center, and project staff. Contacts outside PSMFC include state and tribal data managers, data users and biologists from a variety of agencies and tribes, and data managers and technical staff with other related projects.
Purpose of Contacts:
Contacts are to plan, coordinate, or advise on work efforts, or to resolve issues or problems by influencing or persuading people who are working toward mutual goals and have basically cooperative attitudes. Contacts typically involve identifying options for resolving problems
The work is sedentary with moderate walking between workstations and carrying folders, reports, and similar light loads.
The work is performed in an office setting with adequate lighting, heating and ventilation. There are the normal risks of an office environment.
Minimum Qualification Requirements:
Candidates must present one year of Specialized Experience which demonstrates:
Knowledge of the customary approaches, techniques, and requirements appropriate to database management;
Knowledge of planning sequences necessary to accomplish assignments where this entailed coordination with others outside the organizational unit and development of project controls; and
Adaptation of guidelines or precedents to the needs of the assignment.
The Specialized Experience must equip the candidate with the particular knowledge, skills, and abilities to perform successfully the duties of the position, and is typically in or related to the work of the position to be filled. To be creditable, the Specialized Experience must have been equivalent to at least the next lower level in the normal line of progression position.
Knowledge Required by the Position:
At the lower end of the range, the employee has broad knowledge of and ability to apply:
Database management concepts, principles, and methods including database logical and physical design, normalization, storage capacity management, and back up and recovery.
Data flow design and business process design.
Sources, characteristics, and uses of the organization's data assets
Database management systems, query languages, table relationships, and views.
Data mining and data warehousing principles.
The characteristics of physical and virtual data storage media.
Data administration and data standardization policies and standards in developing and managing large-scale, multi-agency databases.
At the upper end of the range, the employee uses mastery-level knowledge, skills and abilities in the above areas.