• Design, configure, and maintain Hibernate/JPA persistence layers across multiple environments, including cloud-hosted databases. • Develop and optimize entity models, relationships, fetch strategies, and schema mappings aligned with application and business requirements. • Integrate Java persistence with Infor SyteLine V10.x, Salesforce Sales Cloud, and related enterprise systems. • Establish best practices for ORM usage, including naming standards, caching strategies, and transaction handling. • Monitor and optimize persistence performance, reducing database load and improving application responsiveness. • Analyze SQL generated by Hibernate and enhance performance through strategic indexing, batching, lazy/eager loading optimization, and query tuning. • Identify and resolve N+1 issues, excessive joins, inefficient fetch plans, and transaction bottlenecks. • Use Hibernate statistics, profiling tools, and database monitoring utilities to drive continuous improvement. • Design robust transaction management strategies, supporting distributed transactions where required. • Ensure data consistency and reliability across high-availability architectures. • Collaborate on application-level backup and recovery strategies related to data access layers. • Enforce secure coding and ORM best practices to protect sensitive data. • Ensure adherence to data governance, auditing, and regulatory requirements. • Work with the security team to identify vulnerabilities within application-layer data access implementations. • Evaluate and optimize ORM configurations and database interactions to support business growth. • Participate in planning for infrastructure scaling, including cloud migrations and performance load testing. • Diagnose and resolve application-level data access issues, including slow queries, deadlocks, locking, concurrency challenges, and transactional anomalies. • Provide on-call support for critical incidents involving persistence-layer failures or performance degradation. • Work closely with Java development teams to support deployments, new features, major refactoring efforts, and platform upgrades. • Create and maintain comprehensive documentation for ORM architecture, configuration standards, optimization techniques, and troubleshooting procedures.