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