Database Administrator, Oracle - Senior-...
Seattle Public Schools - Seattle, WA

This job posting is no longer available on Seattle Public Schools. Find similar jobs: Database Administrator jobs - Seattle Public Schools jobs

Essential Functions:

Performs Database-related software support and administration. Reviews and assists in the creation of indexes, triggers, stored procedures and other database scripts based on performance and access requirements. Supports database user account access requests and database user account policies. Designs, implements and monitors backup and recovery processes, including ensuring appropriate disaster recovery procedures are in place. Develops and utilizes scripts to schedule and run repeatable administration tasks. 25% of the time

Conducts performance management tasks. Includes database refreshes and performance monitoring of the RDBMS systems. Maintains manageability of large databases with partitioning, archival, compression or other techniques to assure performance and recoverability. Manages database disk storage capacity to prevent storage-related issues. Tunes the data bases, as needed; diagnoses and corrects problems in data base performance and integrity. Uses database and network utilities to monitor health and performance of production databases and related applications. 20% of the time

Acts as team member on projects, provides estimates of task deliverables in collaboration with project management; assures that schedules are met; provides status reports to management. Maintains focus on project objectives and mitigates issues concerning functional scope; prioritizes work efforts to maintain project critical path. 15% of the time

Works collaboratively with other technical staff and vendors to negotiate and troubleshoot complex technical issues and provide solutions. 10% of the time

For custom-developed applications, assists with the design and reviews of the logical data models, data structures and content of the physical data bases. For 3rd party/vendor systems, learns the data structure to be able to support the system and assist Developers and Analysts in working with the system. Collaborates with other database administrators, developers, business analysts and testers in the application of sound database methodology and design. 10% of the time

Performs database upgrades and assists in system and application upgrades. Performs production support, including support during off shift hours. 10 % of the time

Develops and refines technical standards for database design and implementation. 5 % of the time

Performs capacity planning for team resources, and hardware/software. Evaluates and recommends hardware, software, and tools. 5 % of the time

Reporting Relationships:
Reports to the assigned IT Manager.

Minimum Qualifications:

Minimum Qualifications:

Bachelor’s degree in mathematics or computer science or related field or completion of equivalent training.

Ten years of related work experience which includes at least one (5) year experience as a Database Administrator.

Allowable Substitutions:
Equivalent work experience may substitute for the education requirement on a year-for-year basis. A master's degree may substitute for two (2) years of experience. (Does not apply to required database administrator experience)

Desirable or Preferred:
Certification in database technology appropriate to position.

Required knowledge, Skills, and Abilities:
Data modeling with tools such as PowerDesigner, Erwin and Oracle Designer 2000;
Basic Windows or Unix server administration relevant to database platforms;
Data base administration concepts and tools;
SQL at a working level;
Physical data base design for performance and integrity;
Distributed database technology;
Backup/recovery strategies, data migration, security and error handling.
Enterprise-level DB management toolsets, such as Oracle Enterprise Manager or SQL Server Management Studio

Designing medium to large databases;
Diagnosing and correcting problems in data base performance and integrity;
Strong troubleshooting skill, able to help troubleshoot complex system issues involving database, application, server, network, automated jobs;
Data base design techniques;
Excellent written and veral skills;
Office productivity tools such as MS Word and Excel.


Define and follow best practices;
Perform well under pressure while maintaining professional composure and behavior;
Create complete, concise and cogent data base documents;
Function independently and as part of a team;
Communicate effectively with diverse audiences within a multicultural environment.

District-Wide Core Competencies Required For All Jobs:

Is seen as a team player who encourages efficient and effective collaborations

Works skillfully in difficult situations with both internal and external groups

Represents his/her own interests while being open-minded to other groups

Builds respectful and productive relationships internally and externally

Getting Results (Action Oriented)

Demonstrates a strong sense of urgency about solving problems and getting work done

Focuses on achieving the goal even in the face of obstacles

Assumes responsibility for starting and finishing work with minimal supervision

Strives for new levels of performance

Decision Quality & Problem Solving

Weighs the consequences of options before making a decision

Applies appropriate criteria to situations for the purpose of making decisions

Displays self-confidence in own judgment

Focuses in the facts and solutions instead of opinions and problems


Deals with people and situations in an honest and forthright manner

Represents information and data accurately and completely

Represents the confidentiality of information and concerns shared by others

Takes ownership if a mistake is their own and does not blame others


Takes responsibility and action as if the risks (financial or otherwise) are his or her own

Holds individuals and team accountable for their actions and results

Initiates action even if outcome is uncertain and is willing to accept the consequences of failure

Aligns own activities and priorities to meet broader organizational needs

Demonstrates courage and confidence in his or her own ability

Customer Focus
Makes customers and their needs a primary focus of his/her actions.
Thinks ahead and considers the impact of actions both internally and externally.
Develops trust, credibility and maintains strong relationships with customers.
Goes the extra mile to satisfy customer needs and expectations.

Managing Through Processes & Systems
Sets clear, well-defined outcomes for desired results and tracks progress.
Breaks down objectives into actionable steps with targeted deadlines.
Leverages and uses resources efficiently and creatively to achieve desired outcomes.

Technical Learning
Picks up and integrates technical skills quickly.
Recognizes trends and effectively prepares for changes.
Seeks out opportunities to advance one’s learning in relevant technical disciplines.

Functional / Technical Skills
Understands the technical aspects of the job and keeps up-to-date on key technical or functional aspects of the job.
Applies appropriate technical/functional knowledge to address situations in a timely manner.
Thinks of ways to apply new developments to improve organizational performance.
Shares expertise and skills with others when appropriate.

Intellectual Acumen
Demonstrates and is described as someone who is intellectually sharp, agile and capable.
Handles concepts and complexity comfortably.
Demonstrates the ability to comfortably shift thinking on a dime.

Required Clearances:

Criminal Justice Fingerprint

Background Clearance

Supplemental Information:

This Senior Oracle Database Administrator position is responsible for ensuring stability and performance of Oracle databases in support of critical applications for Seattle Public Schools. The successful candidate will have a solid background in core database administration, performance management, and DB-related software support and administration. This is a senior level role and will need to work collaboratively with the technology senior management team on projects and infrastructure/architectural planning, troubleshooting and maintenance to ensure high quality services to our students, staff and families.
Additional responsibilities unique to this position include:
  • Strong demonstrated knowledge of Oracle
  • Experience in management of Oracle RDBMS Software
  • Demonstrated knowledge of database management techniques
  • Demonstrated knowledge of SQL, PL/SQL
  • Demonstrated understanding of relational database design and modeling.
  • Oracle Grid Control (10g-11g) software administration and application experience.
  • Oracle Grid Control 12c installation and administration experience preferred
  • Demonstrated knowledge of shell scripting

About this company
20 reviews