Maximo Database Administrator

About the position

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.

Responsibilities

• Database administration and support on Oracle 12c, Oracle18, and SQL databases.
• Monitor, maintain, and optimize Maximo and asset management system databases to ensure high performance, high availability, real-time failover, and reliability for the database and application servers.
• Perform regular backups, restorations, and disaster recovery planning to safeguard Maximo'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 actions to prevent system downtime.
• Perform patch management and upgrades of Maximo and asset management systems database servers, ensuring compatibility with application upgrades.
• Analyze database performance metrics and resolve performance bottlenecks.
• Optimize database queries, indexes, and schema structures to improve system efficiency and response time.
• Perform tuning of Maximo's reporting tools and integrations to ensure seamless data access and usage.
• Maintain data integrity by implementing and enforcing data quality, validation, and consistency policies.
• Develop and implement procedures for archiving Maximo data to maintain manageable database sizes.
• Support data migration and conversion efforts during Maximo upgrades or integration projects.
• Administer and maintain databases supporting Maximo-integrated applications, including PeopleSoft/ERP, Windchill, FleetWatch, PPG, Optram, and Microsoft Power Platform.
• Perform data mapping and data conversion for Maximo enhancement and integration.
• Troubleshoot and resolve database-related issues in integrated systems to ensure smooth operations across workflows.
• Support the Maximo Integration Framework (MIF), including managing database connections and ensuring data exchange integrity.
• Implement robust database security policies, including user and external system access 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 management regulations.
• Collaborate with application administrators and developers to support database-related aspects of Maximo customizations and workflows.
• Provide database expertise during Maximo upgrades, patching, and troubleshooting to minimize downtime and disruptions.
• Participate in testing and validating new Maximo configurations, modules or enhancements to ensure database compatibility.
• Provide both functional and technical Maximo support and process improvement for Maximo 7.6 and or higher related to data.
• Develop, implement, and maintain Maximo integrations with systems such as mileage 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 system upgrades to ensure smooth transitions, minimize downtime, and maintain data integrity while coordinating with stakeholders to ensure minimal disruption to business operations.
• Set up and maintain database monitoring tools to identify and resolve issues proactively.
• 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 and support tasks.
• Train and mentor team members on Maximo database management best practices.
• Work closely with Maximo and other asset management application teams and IT support and operations teams to align database support with business objectives.
• Act as a subject matter expert for Maximo and asset management application databases, providing stakeholder guidance and recommendations.
• Participate in cross-functional meetings to support the continuous improvement of Maximo and its integrated systems.
• Stay updated on the latest database technologies, trends, and best practices to enhance Maximo database operations.
• Identify opportunities to automate repetitive database tasks and improve operational efficiency.
• Contribute to developing innovative solutions to enhance the performance and scalability of Maximo systems.
• Administer and maintain Maximo databases in both cloud and on-prem environments, ensuring high availability, performance, and seamless integration across hybrid systems.
• Monitor and optimize Maximo database performance across cloud and on-prem databases, ensuring consistent data flow and minimizing latency between cloud and 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 for systems like PeopleSoft/ERP, Windchill, and Microsoft Power Platform.
• Manage and troubleshoot database connectivity for Maximo and external systems in both cloud and on-prem environments, ensuring seamless data exchange and real-time synchronization.
• Collaborate with cloud service providers and internal IT teams to configure and optimize Maximo's cloud-based database infrastructure, balancing cost, performance, and security.
• Develop and implement disaster recovery and backup strategies for Maximo databases across cloud and on-prem environments, ensuring data protection and business continuity.
• Ensure compliance with security and regulatory requirements for Maximo databases, both in the cloud and on-prem, by maintaining secure access controls and 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 integration between Maximo databases and other cloud and on-prem systems, minimizing operational disruptions.

Requirements

• Bachelor's degree in computer science, information systems, or a related field, or equivalent work experience.
• Minimum of Four (4) to seven (7) years of relevant experience in addition to education or equivalent.
• Relevant certifications such as IBM Certified Deployment Professional - Maximo Asset Management or Oracle Certified Professional (OCP) 18 or higher, Azure Database Administrator Associate (preferred).
• At least 5-7 years of hands-on experience with IBM Maximo Asset Management database hosted in a cloud environment or a complex information systems and data processing management in a large organization, transit preferred.
• Comprehensive knowledge and experience with Maximo 7.6 or higher, including Transportation add-on preferred, Asset Configuration Manager, and Mobile experience.
• Demonstrated expertise in Maximo table structure, metadata, and developing migration scripts for Maximo upgrades.
• Experience automating Maximo's administrative tasks, such as error handling.
• Hands-on experience with major cloud providers such as Microsoft Azure or Oracle Cloud Infrastructure (OCI).
• Knowledge of cloud-native database services like Azure SQL Database, Cosmos DB, or Oracle Autonomous Database.
• Experience deploying, configuring, and managing databases in cloud environments.
• Proficiency with cloud-native database features such as autoscaling, high availability, and backup/recovery.
• Knowledge of multi-region and multi-zone deployments for disaster recovery and fault tolerance.
• Skills in performance tuning and monitoring cloud databases using tools like Azure Monitor, SQL Analytics, Oracle Cloud Infrastructure Monitoring, or Oracle Autonomous Database Performance Hub.
• Knowledge of cost-optimization strategies, including selecting the right database tier, managing storage, and leveraging reserved instances or serverless models.
• Proficiency with automation tools such as Terraform, Ansible, or cloud-native Infrastructure as Code (IaC) tools for database provisioning and management.
• Knowledge of cloud database APIs and scripting languages (e.g., Python, PowerShell) for task automation.
• Proficiency with writing, enhancing and maintaining Oracle scripts for data integration.
• Expert knowledge of Maximo, WebSphere, and Oracle architectures.
• Extensive experience with Oracle Development and administration, including Oracle 18c and advanced features such as Data Guard, Active Data Guard, RAC, Golden Gate, and application continuity.
• Experience with Database High Availability (HA) concepts leveraging Oracle Exadata.
• Experience implementing cloud-based High Availability (HA) and Disaster Recovery (DR) solutions, including replication, failover mechanisms, and backups.
• Familiarity with tools like Azure Auto-Failover Groups and Oracle Data Guard for cloud environments.
• Advanced level of Linux usage and administration.
• Proficiency in PL/SQL for database scripting and automation.
• Experience with enterprise systems related to transit operations, such as GOTRS, RPM, PeopleSoft/ERP, Optram, InspectTech, Remstar/PPG and FleetWatch.
• Expertise in using and integrating TRM Rules Manager within Maximo.
• Experience with Microsoft Power Platform and integration with databases.
• Proven experience developing data migration scripts and archiving strategies for Maximo upgrades.
• Ability to ensure data integrity, consistency, and performance across Maximo databases and integrated systems.
• Experience migrating on-premises databases to the cloud using tools like Azure Database Migration Service, or Oracle GoldenGate.
• Expertise in integrating cloud databases with enterprise applications and analytics tools.
• Experience with cloud-native monitoring and troubleshooting tools to ensure database reliability and performance.
• Familiarity with database-specific cloud monitoring systems, such as Azure SQL Insights, or Oracle Enterprise Manager.

Benefits

• Medical, Dental and Vision, Health Savings Account, Flexible Spending Account
• STD, LTD, Supplemental life insurance and ADD&D
• Comprehensive 401k plan
• Paid Time Off