Essential Duties and Responsibilities:
These are typical responsibilities for this position and should not be construed as exclusive or all inclusive.
• Ensures accuracy and completeness of data in master files and various support tools, such as base dictionaries, and establishes and maintains security and integrity controls.
• Formulates and monitors policies, procedures, and standards relating to database management.
• Proposes and implements enhancements that will improve the performance and reliability of the system.
• Selects from multiple procedures and methods to accomplish tasks.
• Applies organizational policies; may interpret organizational policies and recommend exceptions.
• Establishes work methods, timetables, performance standards, etc.
• Routinely provides work group leadership, guidance, and/or training to less experienced staff.
• Allocates and optimizes system storage for the database system.
• Conducts capacity planning.
• Plans future storage requirements and advises management on long-term capacity plans and growth of the database system.
• Designs, implements, and maintain database security protocol. Plans and coordinates security measures alongside network administrators. Identifies and rolls out best practices for security, user and password management.
• Establishes and maintains sound backup and recovery policies and procedures. Defines Data Archive/Purge Standards. Monitors and maintains backups and recovery operations for database systems.
• Monitors and optimizes the performance of the database. Performs accurate application tuning and performance monitoring. Ensures availability of the database. Uses non-disruptive administration tactics.
• Manages and enforces database policies, procedures, and standards. Performs tests and evaluations regularly to ensure data security, privacy, and integrity.
• Collaborates with the Applications team to develop database solutions by designing the proposed system; defining database physical structure, security, back-up, and recovery specifications.
• Documents database policies, procedures, and standards.
• Identifies and builds various database reports needed to give visibility into critical database and server parameters.
• Deploys and installs Oracle and SQL Server databases.
• Designs and optimizes database architecture for performance and scalability.
• Documents database systems and operational procedures.
• Monitors and tunes database performance, identifying and resolving issues.
• Assists the Innovations team by providing knowledge and skills for data analytics, visualizations, power BI reporting, implementing data lakes and data warehouses.
• Troubleshoots and resolves database-related problems.
• Trains and mentors junior and support staff.
• May act as team lead.
• May perform other duties as assigned.
The above statements reflect the general duties, responsibilities and competencies considered necessary to perform the essential duties and responsibilities of the job and should not be considered as a detailed description of all the work requirements of the position. COA may change the specific job duties with or without prior notice based on the needs of the organization.
Knowledge Skills and Abilities:
This is a partial listing of necessary knowledge, skills, and abilities required to perform the job successfully, it is not an exhaustive list.
• Extensive knowledge of concepts, processes, and tools of the profession.
• Knowledge of the relationship of professional discipline among related organizations and functions.
• Well-developed technical skills within the profession.
• Skills in organizing and presenting proposals or information.
• Ability to plan and carry out virtually any typical assignment within the professional area.
• Ability to train others.
• Ability to build effective relationships within the organization.