Guild Mortgage

Job Details

Description

Guild Mortgage Company, closing loans and opening doors since 1960. As a mortgage banking firm, we are dedicated to serving the homeowner/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

This position is responsible for establishing database management systems, database standards, guidelines and quality assurance rules for database deliverables, such as conceptual design, performance tuning, logical databases, capacity planning, external data interface specifications, data loading plans, data maintenance plans, and security policies.

The IBM i DB2 Database Administrator is actively involved in the evaluation, review, and management of database resources and services across the organization in order to ensure that a high level of database integrity is reached and maintained. The ideal candidate will have a proven track record of supporting large scale database infrastructure in close collaboration with peer teams and vendors. The role provides the database expertise needed for the team’s success. This individual will also be required to develop, follow and enforce database standards.

This position requires an individual who works with minimal supervision on a wide range of projects interfacing with peer support teams, development teams and IT management. The Database Administrator is constantly ensuring that their work is aligned with the business and technology customers.

Essential Functions

• Meets regularly with leadership and IT teams to discuss opportunities for improvement across Guild's database systems.
• Deploys and maintains Database infrastructure/objects.
• Maintains database security, integrity, and availability.
• Manages database performance and capacity.
• Implements database design enhancements.
• Collaborates with the Software Development team and the server administrators for the planning and implementation recommended index maintenance, table reorgs, data purging etc.
• Reviews and implements processes for table and index creation using the change management system.
• Establishes procedures for backup/recovery and disaster recovery.
• Establishes database security procedures.
• Maintains current knowledge of industry trends and standards.
• Provides support to the user community using incident and problem management tools.
• Installs, configures, and maintains IBM i-based database artifacts (DB2 for i, ) and ensures they are optimized for performance.
• Collaborates with internal teams for Backup/Recovery and HA/DR solutions for IBM i-based database applications.
• Continuously monitors and optimizes the performance of IBM i database systems, including query optimization, indexing, and system resources management.
• Implements security measures to protect sensitive data, including user access control, auditing, and encryption. Ensures compliance with regulatory requirements.
• Plans and evaluates impact with OS upgrades and patches on IBMi for minimal disruption to business operations.
• Diagnoses and resolves database-related issues, including system performance, connectivity, and integrity issues.
• Performs regular database maintenance tasks, including reorganization, index rebuilds, and data archiving.
• Highly collaborative: Works with developers and other IT teams to design and optimize database schemas, stored procedures, functions, and queries. Assists in database-related development and deployment tasks.
• Maintains comprehensive documentation related to database configurations, procedures and Design/Architecture of the database.
• Performs regularly scheduled capacity planning activities providing required storage recommendations.
• Coordinates interaction with appropriate IT support areas to resolve critical database problem situations.

Qualifications

• Bachelor's Degree in Computer Science, Information Technology, or directly related field to the position or
• equivalent, preferred.
• Minimum of 10 years of IT experience.
• IBM Certified Database Administrator – DB2 for i
• Experience with other database technologies is a plus, (e.g., MySQL, Oracle, Snowflake, Sequel Server).
• Familiarity with IBM Power Systems hardware
• Familiarity with PHP, Cloud Computing, Node.js, other IBM MDM tools (Informatica), and stateless CGI development architectures.
• Ability to organize and manage multiple priorities simultaneously.
• Ability to work well independently or within a team.
• Strong interpersonal and customer service skills.
• In-depth knowledge of IBM i operating system (OS/400), database management, services of the IBM i System Catalog, SYSTOOLS, QSYS2, and tools like IBM Access Client Solutions (ACS) IBM Navigator, STRSQL, etc.
• Expertise in database performance tuning, backup, recovery, and security.
• Strong understanding of DB2 for i SQL and relational database management principles.
• Familiar with multiple partitioned environments and impacts to database changes across mirrored environments.
• Experience with IBM i system hardware, memory, and storage configurations.
• Familiarity with IBM i job management, work management, and system resources.
• Experience in developing software application components using IBM i application languages: ILE RPG, ILE CL, DB2 SQL/PL, Java.
• Familiar with the IBM i modern programming concepts used with the Integrated Language Environment (ILE) for Programs and Service Programs.
• Strong problem-solving, troubleshooting, and communication skills.
• Knowledge of industry best practices and regulatory compliance standards related to database management.
• Understanding of industry best practices pertaining to DB2.
• Experience in Performance Tuning and Capacity Planning.
• Experience deploying large-scale enterprise applications.
• Scheduling flexibility to meet the needs of the business, including weekends, holidays, and 24/7 on call responsibilities on a rotational basis.
• Excellent verbal and written communication skills required.
• Highly organized and detail-oriented; ability to work in a fast-paced, metrics-driven environment required.
• Proficiency in Microsoft Office Suite, Word, Excel, Wiki, collaborative cloud-based programs, and third-party software applications required.
• Commitment to company
• Customer Service - Proactive attention to each person
• Integrity - Do and say what's right
• Respect - Treat others with dignity
• Collaboration - Listen and work together
• Learning - Seek knowledge and strive for improvement
• Excellence – Deliver the unexpected

Supervision

• Job Scope: Responsible for understanding the department/functional area objectives and goals and how own job contributes to achievement of these goals; may contribute insights and ideas on policies, processes, procedures, and efficiency; may recommend changes and enhancements based on analysis and evaluation of circumstances
• Complexity: Problem solving involves evaluating and resolving discrepancies with people, data, analyses, processes, etc. within prescribed program/project guidelines; may also involve resolving basic resource coordination and availability
• Impact: Decisions and actions have a direct impact on the strategic and operational outcomes of the area/unit and the organization as a whole.
• Interaction/Supervision: Works under broad direction with some latitude for independent actions; guided by professional standards, desired outcomes and unit/project/program specifications

Requirements

Physical: Work is primarily sedentary; mobility in an office setting.

Manual Dexterity: Ability to operate standard office equipment and keyboards

Audio/Visual: 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 as print and other media. Ability to accurately interpret sounds and associated meanings at a volume consistent with interpersonal conversation. Expressing or exchanging ideas by means of the spoken word to impart oral information to clients or the public and to convey detailed spoken instructions to other workers accurately, loudly, or quickly.

Environmental: Office environment – moderate noise, no substantial exposure to adverse environmental conditions.

Mental: Learn new tasks, remember processes, maintain focus, complete tasks independently, and make timely decisions in the context of a workflow. This role requires effective adaptation to workplace stressors, including customer service complaints, security responsibilities, and competing priorities. Must be able to adhere to process protocol. Must be able to apply established protocols in a timely manner.

Schedules: Work is primarily performed during the business week, Monday - Friday. Occasional night or weekend may be necessary.

Travel: 5% or less

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: $120,000 - $176,000 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.

REQ#: IBMID017313

Equal Opportunity Employer

This employer is required to notify all applicants of their rights pursuant to federal employment laws. For further information, please review the Know Your Rights notice from the Department of Labor.