Database/System Administration Specialist or Senior Database/System Administrator
Columbus, OH, United States
STRS Ohio, STRS
The State Teachers Retirement System of Ohio (STRS Ohio) is seeking a Senior Database/System Administrator Database/System Administration Specialist to join the Executive/Information Technology Services/Engagement and Operations team.
Established in 1920 and serving Ohio's educators, STRS Ohio is one of the nation's largest retirement systems serving over 500,000 active, inactive, and retired public-school teachers, and university faculty members, managing approximately $88 billion in assets and paying more than $7 billion in benefits annually.
STRS Ohio provides a competitive pay, and a comprehensive benefits package including on-site parking, educational assistance, subsidized medical insurance, fully paid dental and life insurance, vacation and sick leave, retirement benefits and on-site fitness center. At STRS Ohio, you can experience rewarding work in a professional, business casual work environment. We welcome, celebrate, and promote respect for everyone. We are continually seeking bright and talented individuals to join our team.
Compensation:
Grade 11: $114,200 to $125,620
Grade 12: $133,900 to $147,290
Work Schedule:
8:00 a.m. - 5:00 p.m. Monday through Friday, with up to two days per week remote work opportunities.
General Summary (Grade 11 and Grade 12):
Under the direction of the supervisor, Systems and Database Services, ensure access to State Teachers Retirement System of Ohio (STRS Ohio) data by maintaining the availability, performance and integrity of databases, Windows and UNIX operating systems, assist or design and development of or implement departmental standards and procedures.
Summary of Responsibilities Grade 11:
Perform upgrades, maintenance and access security for assigned databases per established procedures.
Complete database schema and system changes for assigned systems per established procedures.
Provide support resolving application related database performance issues, conferring with users, co-workers and vendors, applying experience and judgment to develop solutions.
Assist in the development execution, and documentation of database maintenance, backup, recovery and disaster recovery procedures.
Support in the development, execution and documentation of procedures to maintain database performance using diagnostic tools.
Provide 24x7 on-call support, including after-hour, weekends and holidays on a rotating basis.
Summary of Responsibilities Grade 12: Proactively research and establish installation, upgrade and maintenance procedures for supported database systems.
Research, design and develop security schemes for supported database systems.
Perform all aspects of developing and implementing standards and procedures for database schema modifications, backup and recovery, and disaster recovery.
Develop, test and implement database maintenance jobs.
Research and resolve application database performance issues through conferring with users, co-workers and vendors, online research, online training, applying experience and judgment to develop solutions.
Develop methods and procedures for monitoring databases and systems to pinpoint and resolve database and system problems.
Apply preventative database and system maintenance patches.
The above list of duties is intended to describe the general nature and level of work performed by persons assigned to this classification. It is not to be construed as an exhaustive list of duties performed by the persons so classified, nor is it intended to limit or modify the right of any supervisor to assign, direct and control the work of associates under supervision.
Summ ary of Qualifications Grade 11 and Grade 12: Associate degree in a related field required.
Three or more years' experience in database administration preferred.
Five or more years' experience in database systems administration preferred. (Grade 12)
General or Superior knowledge of: Oracle WebLogic 12 or later versions.
In-depth knowledge of Oracle 12c or 19c required.
SSIS, SSAS and SSRS are a plus. (Grade 12)
Database system capacity planning, auditing and performance tuning required. (Grade 12)
Excellent or Superior knowledge of database utilities, maintenance, performance and tuning and recovery required.
Thorough or Excellent knowledge of: UNIX Operating Systems concepts, AIX and Red Hat Linux required.
Windows and UNIX scripting, Python, TSQL and PL/SQL required.