] Office of Human Resources - Montgomery County Public Schools

OFFICE OF HUMAN RESOURCES AND DEVELOPMENT → CLASSIFICATION → SENIOR ORACLE DATABASE ARCHITECT/ENGINEER

Sorted by job title: A - C | D - H | I - Q | R - Z

Senior Oracle Database Architect/Engineer

MONTGOMERY COUNTY PUBLIC SCHOOLS CLASS DESCRIPTION
OFFICIAL TITLE: Database Analyst III CODE: 5800 SQ/OQ: Optimal Qualified
WORKING TITLE: Senior Oracle Database Architect/Engineer GRADE: 27 MONTHS: 12
SUMMARY DESCRIPTION OF CLASSIFICATION: Responsible for the implementation of moderate to large scale Oracle database solutions to include installation, configuration, integrity, security, and maintenance. Responsibilities include delivery and administration of physical Oracle database solutions that support MCPS enterprise application systems with accuracy, efficiency, and appropriate user, role, and application access. Helps with the evaluation, planning, and implementation of new database hardware/software; responsible for data security, integrity, backup and recovery procedures and standards. Also contributes to the definition and enforcement of standards for security. Works with other DBAs, infrastructure and operations engineers, and development teams to create, populate and administer Oracle database resources. In addition, is responsible for monitoring, researching, recommending, and implementing optimization/tuning strategies for efficient database, schema, and query resources and underlying infrastructure. Coordinates Oracle database research and development efforts for DIO. These efforts include: evaluation and recommendation of new tools, software, techniques, migrations, upgrades, development of standards, implementation, etc.
MINIMUM QUALIFICATION STANDARDS
KNOWLEDGE, SKILLS, AND ABILITIES: Extensive Oracle database administration experience. Knowledge of current network technologies. Knowledge of data security and relational integrity issues and methods. Experience working with data development teams. Advanced working knowledge of UNIX management and overall server and Oracle database-dependent hardware configuration. A solutions engineering mindset, the ability to visualize the ''big picture'' of cross-organization architecture, with Enterprise systems data is desired; this includes roles, identity, synchronization, periodicity, inter- and intra-database relationships, as well as, authoritative source of overlapping/related/intersecting data across the Enterprise. Excellent oral and written communication and human relations skills. Knowledge of and the ability to meet the seven core competencies of the Supporting Services Professional Growth System (SSPGS).
EDUCATION, TRAINING, AND EXPERIENCE: Bachelor's or Master's Degree in Computer science or related field is strongly desired. Considerable experience in the area of database design and administration of Oracle databases. Advanced experience in database monitoring, troubleshooting, performance tuning, and high availability strategies for Oracle DBMS. Demonstrated experience in solving complex database administration challenges and issues. Knowledge of Unix Shell script is a plus. Other combinations of applicable education, training, and experience which provide the knowledge, abilities, and skills necessary to perform effectively in the position may be considered.
CERTIFICATE AND LICENSE REQUIREMENTS: Certified Oracle Database Administrator highly desired.
PHYSICAL DEMANDS: (Special requirements such as lifting heavy objects and frequent climbing.) None
SPECIAL REQUIREMENTS: (Frequent overtime or night work required, etc.) Ability to work non-compensated overtime, especially during peak periods and when urgent work requirements exist
OVERTIME ELIGIBLE: No

EXAMPLES OF DUTIES AND RESPONSIBILITIES:

1. Working under the leadership of the DIO director.2. Works with technology delivery teams and engineers to architect Oracle database environments/solutions, monitor and analyze database performance, identifies issues/potential areas for performance improvement, and researches, recommends, and implements actions as appropriate. 3. Develops and enforces standards for database security, application security, database backup and recovery,. 4. Keeps up to date on Oracle database technology.5. Directs new database infrastructure (hardware/software/storage/backups/redundancy) evaluation, planning, and implementation. 6.. 7. Oracle database Performance Monitoring, Tuning and Optimization 8. Directs and participates in research and development efforts involving new technologies, application development tools, software products and training for possible use by MCPS. 9. Defining hardware requirements and storage capacity planning for development, testing, QA and production for capacity planning and performance.. 13. Works with WAN engineering and ERP groups to collaborate and decide on issues related to deployment of large-scale Oracle database and client-server applications in a network environment. 16. Develops standards for data security and user access privileges. 17. Performs related duties as required
Class Established: 6/2023
Date(s) Revised:
Last Reviewed:

This description may be changed at any time.