Maximo Database Administrator (DBA) Washington, DC (Hybrid) Contract

Role: Maximo Database Administrator (DBA)


Location: Washington, DC (Hybrid/ 3 days onsite)


6-12+ Months Contract

Preferred Skills: 7-10 yrs exp. In Database Asset Mgmt. (Maximo 7.6 or higher)

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.

Qualifications


Minimum Requirements:

• Bachelor's degree in computer science, information systems, or a related field, or equivalent work experience
• Minimum 4-7+ years of relevant experience in addition to education or equivalent.
  Bachelor's degree in Computer Science, Information Technology, or a related field
• Relevant certifications such as IBM Certified Deployment Professional - MaximoAsset Management or Oracle Certified Professional (OCP) 18 or higher, AzureDatabase 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 anddata processing management in a large organization, transit preferred. This includes Maximo application and database configuration, customization, upgrades,patches, and integrations hosted on-premise and in a cloud environment.
• Comprehensive knowledge and experience with Maximo 7.6 or higher , includingTransportation add-on preferred, Asset Configuration Manager, and Mobileexperience.
• Demonstrated expertise in Maximo table structure, metadata, and developingmigration 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 orOracle Cloud Infrastructure (OCI)
• Knowledge of cloud-native database services like Azure SQL Database, CosmosDB, or Oracle Autonomous Database
  Experience deploying, configuring, and managing databases in cloudenvironments.
• Proficiency with cloud-native database features such as autoscaling, highavailability, and backup/recovery.
• Knowledge of multi-region and multi-zone deployments for disaster recovery andfault tolerance.
• Skills in performance tuning and monitoring cloud databases using tools like AzureMonitor, SQL Analytics, Oracle Cloud Infrastructure Monitoring, or OracleAutonomous Database Performance Hub.
• Knowledge of cost-optimization strategies, including selecting the right databasetier, managing storage, and leveraging reserved instances or serverless models.
• Proficiency with automation tools such as Terraform, Ansible, or cloud-nativeInfrastructure 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, includingOracle 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 OracleExadata.
• Experience implementing cloud-based High Availability (HA) and DisasterRecovery (DR) solutions, including replication, failover mechanisms, and backups.
• Familiarity with tools like Azure Auto-Failover Groups and Oracle Data Guard forcloud 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 forMaximo upgrades.
• Ability to ensure data integrity, consistency, and performance across Maximodatabases and integrated systems.
• Experience migrating on-premises databases to the cloud using tools likeAzure 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 ensuredatabase reliability and performance.
• Familiarity with database-specific cloud monitoring systems, such as Azure SQLInsights, or Oracle Enterprise Manager.