Guild Mortgage Company , closing loans and opening doors since 1960. As a mortgage banking firm we are dedicated to serving the home owner/buyer. Our goal is to provide affordable home financing for our customers, utilizing the best terms available while providing a level of professionalism and service unsurpassed in the lending industry. Position Summary The Database Engineer plays an important role in the organization by performing a number of activities related to the companies Information Technology functions. The role is primarily responsible for, under limited to intermittent supervision, for overseeing database performance through testing and evaluations. The purpose is to ensure the highest level of data security, privacy and integrity.
Essential Functions 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. Refine the logical design of the database to ensure translation into a specific data model. Refine the physical design in order to meet system storage requirements. Maintain data standards, including adherence to the SOX compliance and the Data Protection Act. Write database documentation, including data standards, procedures and definitions for the data dictionary. Work with Governance to develop, manage and test back-up and recovery plans. Synchronize testing and production data environments to meet the needs of users on those environments. Perform data migrations between environments assuring appropriate masking of data and necessary security settings appropriate for each environment. Commission and install new applications and customize existing database applications/tools in order to make them fit for purpose. Qualifications High School degree or equivalent, along with a minimum of five 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. Supervision Low supervision of work Strong independent judgment and discretion used in decision-making; uses sound judgment in executing core job responsibilities Resolves issues of high complexity Travel: Up to 20% Requirements Physical: Mobility in an office setting.
Manual Dexterity: Frequent use of computer keyboard and mouse.
Audio/Visual: Ability to accurately interpret sounds and associated meanings at a volume consistent with interpersonal conversation. Regularly required to accurately perceive, distinguish and interpret information received visually and through audio; e.g., words, numbers and other data broadcasted aloud/viewed on a screen, as well in print and other media.
Environmental: Fully remote with experience in an office environment, no substantial exposure to adverse environmental conditions.
Guild offers a pleasant work environment, competitive compensation and excellent benefits package; including medical, dental, vision, life insurance, AD&D, LTD and 401(k) with employer match.
Guild Mortgage Company is an Equal Opportunity Employer.
Targeted Salary Range: $94,542.00 to $128,600.00 annually
Compensation at Guild is influenced by a wide array of factors including but not limited to local and federal minimum wage requirements, education, level of experience, and applicant's geographical location.
PDN-9c17cfb4-84d3-46c7-85ec-a80fc49b1665
