NFF is seeking one (1) 3MS Database Administrator to support the operations and maintenance of the Maximo software platform in a cloud environment, the related integrations, and other components. The Maximo Database Administrator (DBA) is currently responsible for the operation, maintenance, and optimization of Maximo databases and integration with systems such as PeopleSoft/ERP, Fleetwatch, Optram, PPG, and Microsoft Power Platform. The role includes ensuring database performance, reliability, and security through proactive monitoring, tuning, backups, disaster recovery planning, and managing user and external process access. The DBA supports upgrades, patch management, data archiving, and migrations while complying with cybersecurity and regulatory standards and ensuring the applications and Databases are free of vulnerabilities. Additionally, the DBA collaborates with cross-functional teams to manage Maximo Integration Framework (MIF) workflows, provide actionable insights, and deliver database-related support for audits, reporting, and continuous improvement efforts to align Maximo operations with the business needs.
- Database administration and support on Oracle 12c, Oracle18, and SQLdatabases.
- Monitor, maintain, and optimize Maximo and asset management system databases to ensure high performance, high availability, real-time failover, and reliability forthe database and application servers.
- Perform regular backups, restorations, and disaster recovery planning to safeguardMaximo's and asset management data.
- Maintain and/or enhance data archiving.
- Manage database configuration and security settings, ensuring compliance with IT and cybersecurity standards.
- Execute database health checks, identify issues, and implement corrective actionsto prevent system downtime.
- Perform patch management and upgrades of Maximo and asset managementsystems database servers, ensuring compatibility with application upgrades.
- Analyze database performance metrics and resolve performance bottlenecks.
- Optimize database queries, indexes, and schema structures to improve systemefficiency and response time.
- Perform tuning of Maximo's reporting tools and integrations to ensure seamlessdata access and usage.
- Maintain data integrity by implementing and enforcing data quality, validation, andconsistency policies.
- Develop and implement procedures for archiving Maximo data to maintainmanageable database sizes.
- Support data migration and conversion efforts during Maximo upgrades orintegration projects.
- Administer and maintain databases supporting Maximo-integrated applications,including PeopleSoft/ERP, Windchill, FleetWatch, PPG, Optram, and MicrosoftPower Platform.
- Perform data mapping and data conversion for Maximo enhancement andintegration.
- Troubleshoot and resolve database-related issues in integrated systems to ensuresmooth operations across workflows.
- Support the Maximo Integration Framework (MIF), including managing databaseconnections and ensuring data exchange integrity.
- Implement robust database security policies, including user and eternal systemaccess controls, encryption, and activity monitoring.
- Conduct regular security audits and address vulnerabilities in collaboration with cybersecurity teams.
- Ensure compliance with internal and external database and data managementregulations.
- Collaborate with application administrators and developers to support database-related aspects of Maximo customizations and workflows.
- Provide database expertise during Maximo upgrades, patching, andtroubleshooting to minimize downtime and disruptions.
- Participate in testing and validating new Maximo configurations, modules orenhancements to ensure database compatibility.
- Provide both functional and technical Maximo support and process improvementfor Maximo 7.6 and or higher related to data.
- Develop, implement, and maintain Maximo integrations with systems such asmileage processing, RPM, and PeopleSoft/ERP, ensuring seamless data flow,integrity, and performance optimization to ensure accurate and efficient data flow.
- Develop and optimize advanced Maximo data migration scripts during systemupgrades to ensure smooth transitions, minimize downtime, and maintain dataintegrity while coordinating with stakeholders to ensure minimal disruption tobusiness operations.
- Set up and maintain database monitoring tools to identify and resolve issuesproactively.
- Generate performance and usage reports to support decision-making and long-term capacity planning.
- Maintain detailed documentation of database architecture, configurations,processes, and procedures.
- Develop and update knowledge base articles to assist with troubleshooting andsupport tasks.
- Train and mentor team members on Maximo database management bestpractices.
- Work closely with Maximo and other asset management application teams and ITsupport and operations teams to align database support with business objectives.
- Act as a subject matter expert for Maximo and asset management applicationdatabases, providing stakeholder guidance and recommendations.
- Participate in cross-functional meetings to support the continuous improvement ofMaximo and its integrated systems.
- Stay updated on the latest database technologies, trends, and best practices toenhance Maximo database operations.
- Identify opportunities to automate repetitive database tasks and improveoperational efficiency.
- Contribute to developing innovative solutions to enhance the performance andscalability of Maximo systems.
- Administer and maintain Maximo databases in both cloud and on-premenvironments, ensuring high availability, performance, and seamless integrationacross hybrid systems.
- Monitor and optimize Maximo database performance across cloud and on-premdatabases, ensuring consistent data flow and minimizing latency between cloudand on-prem systems.
- Ensure secure and efficient integration of Maximo databases with external cloud-based and on-prem systems, maintaining robust connections and data integrity forsystems like PeopleSoft/ERP, Windchill, and Microsoft Power Platform.
- Manage and troubleshoot database connectivity for Maximo and external systemsin both cloud and on-prem environments, ensuring seamless data exchange andreal-time synchronization.
- Collaborate with cloud service providers and internal IT teams to configure andoptimize Maximo's cloud-based database infrastructure, balancing cost,performance, and security.
- Develop and implement disaster recovery and backup strategies for Maximodatabases across cloud and on-prem environments, ensuring data protection andbusiness continuity.
- Ensure compliance with security and regulatory requirements for Maximodatabases, both in the cloud and on-prem, by maintaining secure access controlsand conducting regular security audits.
- Support Maximo database migrations to the cloud, assisting with the planning,executing, and troubleshooting cloud transitions to enhance scalability and cost-effectiveness.
- Coordinate with external system administrators to ensure smooth integrationbetween Maximo databases and other cloud and on-prem systems, minimizingoperational disruptions.