Data Base Administrator

1. Reviews, develops, and designs data models using standard diagramming techniques, in conjunction with application development teams; creates logical data models and translates into physical database structures that integrate with existing or proposed database structures.
2. Monitors relational databases to optimize database performance, resource use, and physical implementations of databases; addresses a variety of database integration issues including migration between disparate databases, integration, maintenance/conversion, capacity planning issues, and new applications.
3. Maintains development, test, and production RDBMS environments.
4. Design and Implement database solutions for Disaster Recovery, Business Continuity and Cyber Security.
5. Monitors and maintains database security and database software, in cooperation with data security administrators.
6. Provides advice to applications programmers in the effective use of database languages; advises on troubleshooting, exception processing needs, and other data management issues.
7. Maintains availability and integrity of databases through multiple access schemes; facilitates sharing of common data by overseeing proper key and index management and data dictionary maintenance.
8. May evaluate and recommend testing and evaluation of new procedures, software, and hardware.
9. Monitors and manages database backups, logs, and journals; installs, maintains, and upgrades database software; restores and/or recovers data as required.
10. Creates, procures and maintains various database related documents such as manuals and programmers handbooks.
11. Provide 24 hour on-call support. Job shall be shift based.
12. Maintains a broad knowledge of state-of-the-art technology, equipment, and/or systems.
13. Performs other related duties as assigned.

• Ability to interpret data models and to develop database structures.
• Knowledge of current technological developments/trends in area of expertise.
• Ability to use standard diagramming techniques to design and develop computer data models.
• Ability to implement and troubleshoot programming changes and modifications.
• Ability to program, configure, manage, and maintain the operation of complex relational databases.
• Ability to develop and manipulate large, complex data sets.
• Knowledge of computer and/or network security systems, applications, procedures, and techniques.
• Knowledge of data integrity methods and techniques.
• Ability to perform acceptance testing on computer systems, applications, and hardware.
• Ability to install, maintain, modify, and upgrade database software.
• Technical writing skills.
• Ability to provide technical guidance and leadership to professional personnel in area of expertise.
• Ability to operate on a scheduled 24-hour on-call basis.
• Develops and implements the overall database Information Security Strategy

OCP-DBA Certification is a must