Job Description :
Following is a summary of the essential functions for this job. Other duties may be performed, both major and minor, which are not mentioned below. Specific activities may change from time to time.
1. Create physical database schemas and sub-schemas to support the logical database model.
2. Develop, monitor, and maintain backup and recovery for assigned databases to include the appropriate transaction logging.
3. Work with application programmers, business users, and project managers to assist in the development of logical and physical database design, develop data and user capacity requirements, develop user access and disaster recovery requirements.
4. Work with disk storage management group to determine the appropriate disk platform and disk allocation configuration for physical implementation of logical design.
5. Work with operating systems engineers to install kernel and set database parameters to conform to previously determined data and user capacity requirements.
6. Work with application designer to assist in the development of referential integrity to support logical design and application requirements.
7. Work with application programmers and security administrators to establish appropriate data security and user access roles. Work with network administration and operating system engineers to configure appropriate user connectivity path.
8. Perform database performance monitoring and analysis and recommend tuning adjustments and make database adjustments to compensate. Provide support to application programmers through analysis and recommendations as requested for database access and performance problems.
9. Identify, recommend and reorganize database structures and data needed based on performance factors and user requirements. Provide application data refresh as requested to various development and test environments.
10. Maintain documentation of backup and recovery procedures, physical data storage, and logical data design for assigned databases.
Required Skills and Competencies:
The requirements listed below are representative of the knowledge, skill and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
1. Associate’s degree in Information Systems or related curriculum or equivalent education and related training.
2. Three to four years of experience, including approximately two years of experience as a database administrator and at least one year of application database programming experience.
3. Experience with design, modeling, development, and maintenance of small and medium sized databases.
4. Experience with data extract, migration, and loading processes and utilities.
5. Experience writing host system scripting languages such as Job Control Language (JCL), UNIX shell scripting, or NT batch.
6. Experience with cross-platform database network communication techniques.
7. An understanding of one or more database management systems including performance management, security, various file system concepts.
8. Good written and verbal communication skills.
9. Ability to work as a member of a team.
10. Ability to travel as needed.