IS Data Management Analyst

Posted 1 month ago
The State of Oklahoma, Oklahoma County, OK, Openings : 1,
Apply Here Job Description : Job Posting Title IS Data Management Analyst Agency 805 DEPARTMENT OF REHABILITATION SERVICES Supervisory Organization Dept Rehabilitation Services–DDS Job Posting End Date (Continuous if Blank) May 11, 2024 Note: Applications will be accepted until 11:59 PM on the day prior to the posting end date above. Estimated Appointment End Date (Continuous if Blank) Full/Part-Time Full time Job Type Regular Compensation Monthly/Annual Salary: Monthly Annual
Level II (Pay Band L) $6,554.57 $78,654.84
Level III (Pay Band M) $6,882.30 $82,587.60 Job Description Basic Purpose Positions in this job family are assigned responsibilities involving data bases and system administration. This includes database design, implementation and maintenance, security administration, capacity planning, performance tuning and performance monitoring, job scheduling, data backup and recovery, business continuity planning and testing, installing vendor software products, coordination of and responsibility for system availability, ensuring the integrity, confidentiality and security of information. Typical Functions
  • Designs and implements on-line data bases, security access systems, data sets and jobs defines parameters for file or space utilization establishes direct access files or other file configurations as required monitors space utilization and makes modifications as needed.
  • Create queries, stored procedures, functions and data exports and imports performs other data management processes utilizing database protocols.
  • Documents and demonstrates solutions by developing documentation, flowcharts, layouts, diagrams, charts, code comments and clear code.
  • Provides applications development and other unit personnel with data base and data security information required to support application development and other activities supports repository/data base dictionary requirements and activities develops, implements and monitors control blocks and data definitions to support data bases.
  • Installs and modifies vendor software products conducts appropriate tests to insure compatibility of new or modified programs with operating system requirements uses data base performance and tuning tools in order to monitor and enhance response times and system performance.
  • Confers with computer operations, technical support, user and vendor representatives concerning data base requirements, system performance, software maintenance, capacity planning, and data security requirements.
  • Reviews systems specifications for compliance with departmental, division and data base administration standards.
  • Responds to data base operational emergencies as required including data base recoveries involving the use of data base log files which provide for the recovery of data bases with no loss of data and which do not require the user to reenter data into the data base.
Level Descriptor Level II – This is the career level of this job family where employees are assigned responsibilities at the full performance level for performing a full range of duties in designing and implementing database and/or data security systems to support various applications and systems operations. Some responsibility may be assigned for providing guidance or training to other employees or serving as a team leader on some projects. Level III – This is the specialist level of this job family where employees are assigned advanced responsibilities for design and maintenance of critical and complex data bases and jobs and the completion of special technical assignments associated with developing data bases and/or data security systems to support various computer applications requirements. This includes positions which are the only Information Systems Data Management position in a data processing division with independent responsibility for all aspects of data base design, maintenance and/or data security. Some responsibilities may be included for providing guidance and training to other programmers or technical personnel in the completion of various applications projects. Education and Experience Level II – Education and Experience requirements at this level consist of completion of twelve semester hours of information technology course work at an accredited college or university plus two years of experience in database design or data security administration or a comparable vocational or technical training program of at least 156 hours resulting in certification in database administration plus two years of experience in database design or data security administration or an equivalent combination of education and experience, substituting one year of experience in information technology for the required education or a comparable vocational or technical education course resulting in certification in database administration or a bachelors degree in a comparable vocation plus two years of experience in database design or data security administration or an equivalent combination of education and experience, substituting one year of experience in information technology for the required education plus two years of experience in database design or data security administration. Level III – Education and Experience requirements at this level consist of completion of twelve semester hours of information technology course work at an accredited college or university plus four years of experience in database design or data security administration or a comparable vocational or technical training program of at least 156 hours resulting in certification in database administration plus four years of experience in database design or data security administration or an equivalent combination of education and experience, substituting one year of experience in information technology for the required education or a comparable vocational or technical education course resulting in certification in database administration or a bachelors degree in a comparable vocation plus four years of experience in database design or data security administration or an equivalent combination of education and experience, substituting one year of experience in information technology for the required education plus four years of experience in database design or data security administration. Knowledge, Skills, Abilities and Competencies Level II – Knowledge, Skills and Abilities required at this level consist of knowledge of information technology of repository/data dictionary systems of data security systems and of database maintenance utilities. Ability is required to apply data processing analysis techniques to resolve and prevent database integrity problems to communicate effectively and to establish and maintain effective working relationships with others. Level III – Knowledge, Skills and Abilities required at this level consist of knowledge of information technology of repository/data dictionary systems of data security systems and of database maintenance utilities. Ability is required to apply data processing analysis techniques to resolve and prevent database integrity problems to communicate effectively to establish and maintain effective working relationships with others and to perform highly independent work in the design, analysis and maintenance of database and/or data security systems. Special Requirements Additional Job Description Equal Opportunity Employment The State of Oklahoma is an equal opportunity employer and does not discriminate on the basis of genetic information, race, religion, color, sex, age, national origin, or disability. Current active State of Oklahoma employees must apply for open positions internally through the Workday Jobs Hub . Last Date For Apply: 2024-08-08 00:00:00 Job Type : FULL_TIME, Employment Type : FULL_TIMEApply Here