SUMMARY:
The role of the Database Administrator is to direct, evaluate, review, and manage database (Oracle and Microsoft SQL Server) resources and services across the Corporation while ensuring data integrity, high levels of data availability and data quality. The Database Administrator will design, install, monitor, maintain, secure and performance-tune (optimize) production databases. |
- Ensures the stability and reliability of data access and data quality across the organization via ongoing database support and maintenance (including the troubleshooting of database issues).
- Ensures the security and integrity of data (including data used in labor relations matters) by implementing appropriate security measures (according to policy and procedures) and by adopting best security standards and practices.
- Writes and maintains database documentation and inventory, including data standards, procedures and definitions for the data dictionary (metadata).
- Develops, manages and tests back-up and recovery plans.
- Plans capacity and ensures that storage, encryption, back-up and recovery procedures are functioning correctly.
- Liaises regularly with application/operational staff, developers, IT/project managers and other technical staff.
- Works closely with business and data owners to define and implement business requirements.
- Ensures compliance with database vendor license agreement.
- Monitors and optimizes the performance and improves efficiency of the both MS SQL and Oracle databases.
- Responds to and resolves database access, performance or any other issue including contacting database vendors for technical support.
- Develops, implements, and maintains change control and testing processes for modifications to databases.
- Performs database transaction, access and other data related security audits.
- Conducts research and makes recommendations on database products, services, protocols, and standards in support of procurement and development efforts.
- Administers and implements strategies for the control and sharing of company database resources and services.
- Uses internal tracking systems to track and document issues, problems, changes and resolutions, including maintaining a knowledge-base of common fixes to key issues.
- Is familiar with and operates within known standards, including but not limited to, Security, ITIL, SDLC, Project Management, and Enterprise Architecture.
- Performs other duties as assigned.
|
