Kforce has a client that is looking for a Remote DB2 IBMi Database Engineer. This company is a well established leader in their industry for over 50 years and is continuing to grow. As a DB2 IBMi Database Engineer, the role holds significant importance within the organization, entailing a range of responsibilities related to Information Technology functions. They will operate with a degree of autonomy, overseeing database performance through meticulous testing and evaluations. The primary objective is to uphold the utmost standards of data security, privacy, and integrity.
Responsibilities:
* Perform tests and evaluations regularly, as well as communicate regularly with leadership, technical, applications and operational staff to ensure data security, privacy and integrity
* Monitor database performance and implement necessary changes to assure optimal database speed and integrity
* Collaborate with IT security personnel to ensure proper restrictions and access is established on database objects, files and source
* Provide expertise and recommendations on improvements and needed maintenance to the IBMi database
* Provide expertise to create, define and enforce change management rules for database code and objects
* Apply knowledge to track database objects in the system and provide improved strategies and resolution(s)
* Understand needs of users and monitor user access and security to the database
* Communicates regularly with Technology leaders
* Inspect index advisor data, SQL plan cache, etc. in order to ensure good database performance
* Provide proactive and reactive data management support and training to front-end and back-end users
* Determine, enforce and document database policies, procedures and standards
* Map out conceptual design for planned database changes for both back-end organization of data and front-end accessibility for end-users and provide recommendations for improvements to leadership* High School diploma/GED or equivalent, along with 5+ years working as a Database Engineer or related role and experience working on multiple projects of high complexity, preferable in the financial services or mortgage servicing industries
* Expert IBM I DB2 database management skills
* Expert management and monitoring of data security and integrity
* Expert with performance monitoring, optimization, tuning and management
* Experience creating and managing elements of a -data centric- strategy such as logical files, views and stored procedures
* Ability to architect, design and diagram database systems for high traffic systems
* Application development experience on IBMi
* Experience managing, analyzing, and indexing
* Ability to conduct SQL code review with developers and provide expert advice
* Proficient at communicating technical designs and documentation to development teams
* Ability to forecast, plan and implement changes to prepare for future needs
* Team-oriented individual with the ability to work across diverse teams and skill levels
* Database tuning experience running diagnostics and doing query optimization and other performance tuning
* Knowledge and know how to troubleshoot potential database issues and experience with best practices around database operations