Implement and review security guidelines, develop and test database migration procedures, troubleshoot application key selection, and perform database maintenance functions.
Requirements
- Implement and review appropriate security guidelines / mechanisms
- Develop and test database migration procedures
- Troubleshoot application key selection, creation of appropriate indexes, and query needs
- Perform database maintenance functions, move, rebuild, or change database objects as required in production
- Proactively solve complex problems
- Translates user's needs into sound database design with tables,fields, and relationships documented
- Assist in developing purge / archive criteria and procedures for historical application data on a relation model database environment
- Reviews, evaluates, designs, implements and maintains company database(s)
- Develops database administration tools / utilities / operation procedures
- Educates user and maintains database documentation
- Establishes database procedures and standards; assists in database design
- Documents data requirements in a logical entity relationship diagram