2600 Cerrillos Road
Santa Fe, New Mexico87505-0127
Classification Description
IT DATABASE MANAGER/ADMINISTRATOR
Class Title Class Code Pay Band Alt Pay Band*
IT Database Administrator Level I D10271 60 70
IT Database Administrator Level II D10272 65 80
*In accordance with SPB Rule 1.7.4.10 NMAC, the assignment to alternative pay bands shall be reviewed annually to determine their appropriateness.
Occupation Description
This job family exists to develop and apply technical expertise in database management and administration. Jobs in this family are responsible for monitoring, designing/developing, security, testing, maintaining, installing, and/or optimizing database technologies. (The two levels indicated refer to simple databases [lowest levels] to moderately complex – many external interfaces, multiple applications, many users [middle levels], and mid-levels to enterprise databases [highest levels].
Nature of Work
Works with database management systems software and determine ways to organize and store data. Identifies user requirements, sets up computer databases, and tests and coordinates modifications to the system. Ensures the performance of the system, understands the platform on which the database runs, and adds new users to the system. Often may design and implement system security measures. Responsible for data integrity, backup systems, and database security.
Distinguishing Characteristics of Levels
Note: Examples of Work are intended to be cumulative for each progressively higher level of work. The omission of specific statements does not preclude management from assigning other duties which are reasonably within the scope of the duties.
Level I
This is the first line of support for end-user application, database connectivity issues. Responsible for primary support to application development personnel in data base utilization and design. Independence decision making authority limited to standard operating procedures. • Assist in the research of emerging database technologies that are scalable or for proposed
database solutions.
• Configure, install, and test and maintain databases and their associated software such as version upgrades, patches, and tools.
• Participate in the design of the application server infrastructure. • Monitor and manage database performance.
• Troubleshoot database errors, indexing, or other problems. • Performance tune databases and related servers.
• Perform database backup on a regularly scheduled basis, and database recovery when required.
• Define data elements for new or changed applications and map data elements across the enterprise to ensure consistency and integration.
• Implement change management/change control processes. • Manage user rights and levels of access to databases.
• Produce and maintain database documentation (e.g., data dictionary, Entity Relationship Diagrams).
• Monitor, track and report on unauthorized systems access.
• Research and assess emerging technologies for use within agency business.
• Provide daily support functions in the database administration and management environments and have responsibility for primary support to application development personnel in database utilization and design.
• The daily support functions include:
• Manage all files (physical and logical) related to database activity. • Schema management (work with App Developers).
• Administer database user accounts. • Administer security of the database.
• Install, upgrade, patch, configure, resource monitoring, and reporting. • Troubleshoot simple database problems.
• Install the associated database software, tools and programming languages. • Ensure all backups completed.
• Create jobs and events to automate database environment.
Recommended Education and Experience for Full Performance
Bachelor’s degree in Computer Science or MIS; or professional certification from current enterprise database and/or operating system technical courses and two (2) years of experience as an Application/Web GUI database developer including one (1) year systems administration (Windows, UNIX, Linux, etc.).
Minimum Qualifications
Associate’s degree in Computer Science and/or MIS; or professional certification from current enterprise database and/or operating system technical courses and two (2) years of experience as an Application/Web GUI database developer, including experience in systems administration (Windows, UNIX, Linux, etc.).Any combination of education from an accredited college or university in a related field and/or direct experience in this occupation totaling four (4) years may substitute for the required education and experience.
Level II
This is the master level responsible for controlling, monitoring and maintaining a multi-user data base management system, including the resolution of problems occurring in the system, overseeing the management of the data dictionary, installation of the system software, coordination of data base management functions with other information system areas, and participation in planning for the data base environment. Decision making authority bound by industry standard best practices for database management.
• Lead research for emerging database technologies that are scalable for proposed database solutions.
• Configure, install, and test and maintain databases and their associated software such as version upgrades, patches, and tools.
• Design logical and physical database infrastructure such as application schemas and file structures.
• Participate in the design of application server infrastructure. • Monitor and manage database performance.
• Troubleshoot database errors, indexing, or other problems. • Performance tune databases and related servers.
• Define data elements for new or changed applications and map data elements across the enterprise to ensure consistency and integration.
• Implement change management/change control processes.
• Participate in disaster mitigation and recovery plans for databases supported.
• Design and implement database security layers to include user rights and access, and encryption.
• Assist with the implementation of application database designs and assist in maintaining and monitoring a multi-user database management system.
• Track and report on unauthorized systems access. • Mentor, train, and develop junior staff.
• Collect, define and assess the business requirements for database design. • Establish coding standards and practices for data elements.
• Participate/lead in the RFP/RFI process for new database application solutions for the enterprise.
• Lead, manage and complete data conversion efforts.
• Provide vendor and license management for the organization’s databases. • Establish coding standards and practices for data elements.
• Evaluate and assess emerging technologies that will facilitate business value for the enterprise.
• Participate in capacity planning proposals. • Monitor database performance.
• Performance tune databases and related servers.
• Define data elements for new/changed applications and map data elements across the enterprise to ensure consistency and integration.
• Produce and maintain documentation (e.g., data dictionary, Entity Relationship Diagrams).
Recommended Education and Experience for Full Performance
Bachelor’s degree in Computer Science or MIS and four (4) years of IT experience in the following capacities:
• Experience with application servers.
• Experience with capacity planning, fault tolerance, high availability and disaster recovery. • Experience with fat and thin client application server environments.
• Experience with web servers.
• Experience with scripting languages.
• Experience with third party utility database administration tools.
Minimum Qualifications
Bachelor’s degree in Computer Science and/or MIS and two (2) years of IT experience in the following capacities:
• Experience with application servers.
• Experience with capacity planning, fault tolerance, high availability and disaster recovery. • Experience with fat and thin client application server environments.
• Experience with web servers.
• Experience with scripting languages.
• Experience with third party utility database administration tools.
• Any combination of education from an accredited college or university in a related field and/or direct experience in this occupation totaling six (6) years may substitute for the required education and experience.
Knowledge and Skills
Note: This information has been produced by compiling information and documentation provided by O*NET. O*NETTM is a trademark of the U.S. Department of Labor, Employment and Training Administration.
Knowledge
Computers and Electronics — Knowledge of circuit boards, processors, chips, electronic
equipment, and computer hardware and software, including applications and programming.
Customer and Personal Service — Knowledge of principles and processes for providing
customer and personal services. This includes customer needs assessment, meeting quality standards for services, and evaluation of customer satisfaction.
English Language — Knowledge of the structure and content of the English language including
the meaning and spelling of words, rules of composition, and grammar.
Mathematics — Knowledge of arithmetic, algebra, geometry, calculus, statistics, and their
applications.
Clerical — Knowledge of administrative and clerical procedures and systems such as word
processing, managing files and records, stenography and transcription, designing forms, and other office procedures and terminology.
Skills
Complex Problem Solving — Identifying complex problems and reviewing related information
to develop and evaluate options and implement solutions.
Critical Thinking — Using logic and reasoning to identify the strengths and weaknesses of
alternative solutions, conclusions or approaches to problems.
Monitoring — Monitoring/Assessing performance of yourself, other individuals, or organizations
to make improvements or take corrective action.
Active Learning — Understanding the implications of new information for both current and
future problem-solving and decision-making.
Active Listening — Giving full attention to what other people are saying, taking time to
understand the points being made, asking questions as appropriate, and not interrupting at inappropriate times.
Reading Comprehension — Understanding written sentences and paragraphs in work related
documents.
actions to choose the most appropriate one.
Operations Analysis — Analyzing needs and product requirements to create a design. Speaking — Talking to others to convey information effectively.
Systems Analysis — Determining how a system should work and how changes in conditions,
operations, and the environment will affect outcomes.
Statutory Requirements: N/A
Conditions of Employment: Working Conditions for individual positions in this classification
will vary based on each agency’s utilization, essential functions, and the recruitment needs at the time a vacancy is posted. All requirements are subject to possible modification to reasonably accommodate individuals with disabilities.
Default FLSA Status: Exempt. FLSA status may be determined to be different at the agency
level based on the agency’s utilization of the position.
Bargaining Unit: This position may be covered by a collective bargaining agreement and all
terms/conditions of that agreement apply and must be adhered to.
Established: 12/14/2005 Revised: 9/20/2011
Note: Classification description subject to change. Please refer to the SPO website www.spo.state.nm.us to ensure this represents the most current copy of the description.
