Database Engineer I

Description

This position will work with the Database Engineering team to support, maintain, and expand the DB2 database platforms utilized within the CU*Answers network. Working together with multiple cross-discipline teams, you'll focus on reviewing database changes to facilitate new projects, analyzing current performance and database structure, and proposing and executing on strategic database management plans to help us deliver the best possible experience to our clients and members.

The ability to apply independent judgment is critical in managing complex tasks and making decisions that directly impact the organization's success. This includes assessing situations, analyzing available information, and evaluating potential risks and benefits to determine the best course of action. The individual in this role is expected to make well-informed decisions without constant supervision, addressing challenges with confidence and ensuring alignment with organizational goals and values. This function involves balancing competing priorities, managing ambiguity, and handling urgent or sensitive matters with discretion.

1. Responsible for managing the day-to-day team operations for corresponding departments to ensure overall performance meets company objectives including but not limited to coaching, mentoring, developing, hiring, firing, disciplining, motivating, performance reviews, training, goal setting, payroll processing, staff budgeting, and other HR administrative tasks.

2. Oversee daily operations by leading departmental planning, project execution, budgeting, employee development, succession planning, and performance reporting to the AVP of Web Technologies.

3. Exercise extensive independent judgment to assess complex situations, analyze information, and make decisions that align with organizational goals.

4. Manage multiple priorities effectively, demonstrating discretion and sound decision-making across all responsibilities.

5. Perform additional duties as assigned to support organizational goals and evolving business needs.

Database Architecture, Design and Implementation

• * Architecture, design and implementation of database systems and components in support of information management goals.
• * Database and data life cycle.
• * Data modeling practiced via modern methods, tools and interfaces.
• * Gathering business requirements, logical modeling, physical modeling, implementing the model and maintaining the model.

Data Availability, Control, Governance and Integrity

• * The DBE, in partnership with the data owner, is responsible for the accessibility, availability and integrity of the database and data.
• * Defining and implementing the appropriate strategy and methods to maintain control and governance of the database and the data, as defined and mandated by the owner. This includes understanding and accounting for all the potential data access interfaces and methods; and ensuring proper security and auditing measures are in place. A critical success factor is identifying, understanding and reconciling the associated business and technical requirements for data and information management.
• Data Centric Application Design and Programming
• * Ensuring proper and adequate data centric techniques are used in the design, development and implementation of applications. This includes taking advantage of built in database management system features and functions such as constraints, functions and triggers.
• * The DBE is responsible for understanding and applying the science and art of coding and implementing SQL (DDL, DML and PSM) via modern methods, tools and interfaces. Leading, guiding and reviewing data centric application development is a fundamental task. As appropriate, the DBE is also involved in all aspects of maintaining and enhancing existing database applications that are based on DDS, high level language record level access and other non-SQL interfaces.
• Database Performance and Scalability
• * The DBE is responsible for identifying, understanding, reconciling and meeting the data serving performance and scalability requirements.
• * This includes applying the best practices of indexing, work management and set-at-a-time SQL requests.
• * The DBE is responsible for understanding and applying the science and art of monitoring, analyzing and tuning data access and data processing via modern methods, tools and interfaces.
• * The DBE is involved in planning, sizing and configuring database systems to meet business and technical requirements. This should include the set up and use of prototypes, proofs of concept, proofs of technology and realistic benchmarks.

1. Four-year degree in business-related, IT or project management field or equivalent work experience is preferred. Equivalent experience would be at least 5 years of working experience in programming.
2. Having 5 years of experience with DB2 is required.
3. Ability to perform complete project development including user interface, project analysis, development of specifications, delegation of duties, monitoring progress, smooth installation, and complete documentation.
4. Ability to supervise staff and manage department goals.
5. Ability to make solid, sound decisions in stressful situations.
6. Ability to set clear expectations for performance, provide meaningful feedback, hold employees accountable and recognize successes.
7. The ability to communicate information and ideas so others will understand.
8. The ability to combine pieces of information to form general rules or conclusions (includes finding a relationship among seemingly unrelated events).
9. Extensive knowledge of all aspects of SQL: DML, DDL, DCL, TCL and procedural including external stored procedures.
10. Database tuning and index building.
11. Full knowledge of database normalization to a minimum of 3rd normal form.
12. Proficient with Navigator.
13. Excellent verbal and written communication skills.
14. Ability to deal with external clients as well as internal staff.
15. Excellent attention to detail and accuracy.
16. Ability to use discretion when dealing with sensitive or confidential data.
17. Ability to work effectively with other CU*Answers teams.
18. Ability to operate telephone, photocopier, fax machines and PC workstation.
19. Regular and predictable attendance.
20. Embrace and adhere to the company mission and the seven cooperative principles of a cooperative.

CU*Answers is an Equal Employment Opportunity employer that supports the unique perspectives and experiences from all employees and supports a collaborative community spirit. All qualified applicants will receive consideration for employment without regard to age, citizenship status, color, creed, disability, ethnicity, genetic information, gender (including gender identity and gender expression), marital status, national origin, race, religion, sex, sexual orientation, veteran status or any status or condition protected by applicable federal, state or local laws.