The Database Administrator is responsible for planning, creating, implementing, maintaining, troubleshooting and enhancing complex relational databases and the Enterprise Data Warehouse (EDW). This position consistently uses discretion and independent judgment to perform essential duties; including performance tuning, job scheduling, program processing and systems monitoring on an as-needed or as- instructed basis. This position advises management on database concepts, capabilities, performance improvements, and data utilization.
1) Develop, maintain and administer system databases and EDW- 45%
a. Create logical links between databases to create EDW as required by the Credit Union’s needs. This may be accomplished by utilizing various SQL tools.
b. Performance tune in-house and third party databases as required. This will include creating and re-organizing indexes, optimizing job schedules, and creating stored procedures and functions.
c. Plan, define, and create new databases using database normalization techniques to meet the Credit Union’s needs.
d. Set up and maintain user security for databases and connected applications.
e. Interact with IT staff, appropriate UWCU division representatives and vendor support personnel to define and resolve systems-related problems.
f. Track and document actions and results in accordance with IT “change control” methodology.
g. Work closely with Project Managers, Programmers, and Web Developers to ensure a high level of database integrity.
h. Actively participate with IT Network, Operations, and Systems Programming staff in preparing and implementing backup and disaster recovery procedures and processes of mission critical databases.
i. Analyze and implement techniques to optimize system utilization, database performance and maintain established service levels.
j. Work with business units/data owners to classify database data for appropriate security, backup, and performance characteristics.
k. Generate automated, repeatable and stable processes to support data load, data validation, and data synchronizations for the Miser BI data warehouse.
l. Create database code requirements for all data warehouse data migrations and business unit and SQL-server projects via programming and the various SQL languages.
m. Identify and resolve data integrity issues between the data warehouses and the original data sources.
n. Create and maintain data dictionaries and database diagrams for complex in-house databases.
o. Provide on-call support for problem resolution of database-related issues .
2) Applications Development- 25%
a.Provide applications development support primarily for data warehouse applications surrounding product development, marketing research, financial analysis and process improvements using programming tools or languages to support mainframe, platform, loan origination, interfaces and electronic forms systems, reports, and other PC-based applications.
b. Conduct needs assessment, program analysis and specifications, coding, testing, implementation, communication and documentation for all program development.
c. Explore and develop creative solutions and efficiencies through programming enhancements.
d. Maintain appropriate documentation of all changes and user-requested parameters and reports in accordance with IT programming standards.
e. Maintain updated documentation for application and system software and various utilities on a regular basis including the data dictionary for the data warehouse.
f. Coordinate all activities related to the operational plan, including maintenance of the status of requests for service, internal department assignments and documentation.
g. Modify and enhance third party databases and procedures to create an Enterprise Data Warehouse.
h. Lead projects of all sizes independently and, as assigned, work with Senior Programmer or Systems Programmer on large-scale projects.
i. Create, maintain, and document database views for client use in data warehouse reporting.
j. Maintain partnership with client liaisons (mainly the Finance Department) to impart knowledge and participate in client procedures and documentation.
3) Software Maintenance Support- 20%
a. Implement new SQL server installations and update existing installations to ensure maximum security and efficiency.
b. Develop and implement proactive maintenance plan to review and install available third-party data transformation software fixes.
c. Actively lead and participate in new release upgrades of software and hardware.
d. Maintain data warehouse system parameters and security specifications.
e. Provide clients and staff with technical assistance for supported applications.
f. Manage Vendor Relationships
4) Other Job Duties- 10%
- Participate in new vendor evaluations, including contract negotiations as appropriate.
- Ensure active usage of vendor provided resources, including technical support, education, compliance, reporting, and user groups.
- Maintain professional rapport with vendor contacts to facilitate progress with problem resolution and new product enhancements.
a. Participate in Technology Division cross-training, including application development, data processing operations, network support and systems consulting.
b. Stay abreast of industry trends and continue to enhance technical skills through education, on the job training, reading, professional contacts and participation in user group meetings.
c. Assist and mentor Credit Union staff and programmers on database concepts, procedures, and data use.
d. Perform all other duties as assigned.
e. Back up fellow Operations Staff as needed by:
- Processing all regularly scheduled programs, including daily/nightly, monthly, quarterly, annual and periodic runs. Monitor messages and output for successful completion. Perform recovery/restart if necessary.
- Monitoring data communications; perform all tape/cartridge, printer and optical disk management.
- Coordinating statement processing, and special reporting such as IRS and year-end activities.
- Performing System Administrator duties for Optical Disk documen t storage system.
To perform this job successfully, an individual must demonstrate regular, predictable attendance and be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Be available for problem solving during non-regular work hours, including on-call support.
- Bachelor’s Degree in Computer Science or related field.
- Expert knowledge of currently supported versions of MS SQL Server.
- Six to seven years database programming and software maintenance experience in a SQL environment, including working with end users.
- Detailed understanding and experience with relational database modeling concepts, including the use of Primary Keys, Unique Keys, Foreign Keys, Triggers, Views, Stored Procedures, Table Joins, Normalization and Entity Relationship Diagrams.
- Detailed understanding of SQL performance tuning techniques and tools.
- Experience with SQL data transformation tools.Demonstrate analytical, problem-solving and leadership skills.
- Expert in all MS Office products. (Excel, Access, Word).
- Excellent interpersonal skills.