Database Administrator

Ohio Public Employees Retirement System

Bachelor's degree in computer science or Business Administration or equivalent.

Training in file structures and design, information retrieval techniques, file access methods and control, and development and documentation of standards. Four years’ work experience of which two years have been in data processing. One year of data processing experience must have been in systems analysis and design using relational database technology. Additional experiences using DB2, or SQL Server are a plus. Familiarity with Java, J2EE, EJBs, .Net, and application servers such as WebSphere, Internet technologies, and DB2 or SQL Server support products are pluses. Additional non-data processing experience may be substituted for education on a year-for-year basis.

Designs, implements, maintains, optimizes, and controls the organization's physical database structures, to ensure secure and timely data access balanced with data integrity and recoverability. Develops and implements database technology to be used by business application, and business intelligence systems to add value to the business. Implements database modifications requested through mandated channels. Works with Data Administration and systems analysts to translate logical data models into physical database models. Creates and documents physical models, then schedules and conducts physical design reviews, incorporating feedback into the model as required. Devises written procedures, automated scripts, JCL, software tools, reports and other means to monitor and facilitate database tuning, data integrity, data security, database recovery, resource usage, history retention and other activities that are central to a robust database environment. Establishes and enforces standards for use of the corporate database. 1.Analyzes database modifications to access impact on total environment before implementation. 2.Helps to develop and document standards for use, control, updating, and maintenance of databases. 3.Consults with Data Administration, systems analysts and business users to obtain contextual information related to new or existing data files. 4.Establishes, maintains and migrates databases used for development, testing, quality assurance, and production. 5.Helps to develop automated and procedural means to enforce security, enhance recoverability, optimize performance and reinforce other characteristics associated with a healthy database environment. 6.Fulfill administrative reporting requirements. 7.Proactively analyzes database performance via DBMS, third-party, or in-house tools to optimize database performance where indicated. 8.Helps to develop training materials on the organization's databases. 9.Participates in software selection process, including but not limited to, selection of Database Management Systems, third-party backup/recovery software, monitoring/tuning packages, data repositories and database reporting tools. 10.Participates in hardware selection process, including but not limited to, selection of CPU, DASD, and database Servers. 11.Assists with the design, construction, and optimization of systems architecture with database connectivity, and other Internet technologies. For a complete job description and technical skills go to www.opers.org and on careers.