Overview
Remote
Depends on Experience
Accepts corp to corp applications
Contract - Independent
Contract - W2
Contract - 1 year(s)
No Travel Required
Skills
Maximo
database administrator
Job Details
Positions Title: 3MS Database Administrator
Period of Performance: 1080 Hours
Place of Performance: Remote but may be required to attend meetings or work on-site at various locations, specifically: 4100 Garden City Dr, Hyattsville, MD 20785 / 300 7th St SW, Washington, DC 20024 / 2401 Mill Road, Alexandria, VA 22314
Due : April 21st by 10:00AM
Responsibilities:
Database Administration and Maintenance
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 withWMATA's 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.
Performance Tuning and Optimization
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.
Data Management and Integrity
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.
Integration and Support for Connected Systems
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 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.
Database Security and Compliance
Implement robust database security policies, including user and eternal system access controls, encryption, and activity monitoring.
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 withWMATA's 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.
Performance Tuning and Optimization
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.
Data Management and Integrity
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.
Integration and Support for Connected Systems
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 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.
Database Security and Compliance
Implement robust database security policies, including user and eternal system access controls, encryption, and activity monitoring.
Conduct regular security audits and address vulnerabilities in collaboration withWMATA's cybersecurity teams.
Ensure compliance with internal and external database and data management regulations.
Support for Maximo Application Operations
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.
Monitoring and Reporting
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.
Documentation and Knowledge Sharing
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.
Collaboration and Stakeholder Engagement
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 application databases, providing stakeholder guidance and recommendations.
Participate in cross-functional meetings to support the continuous improvement ofMaximo and its integrated systems.
Continuous Improvement and Innovation
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.
Cloud Focus
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 forsystems 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.
Ensure compliance with internal and external database and data management regulations.
Support for Maximo Application Operations
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.
Monitoring and Reporting
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.
Documentation and Knowledge Sharing
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.
Collaboration and Stakeholder Engagement
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 application databases, providing stakeholder guidance and recommendations.
Participate in cross-functional meetings to support the continuous improvement ofMaximo and its integrated systems.
Continuous Improvement and Innovation
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.
Cloud Focus
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 forsystems 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 Maximum 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.
Develop and implement disaster recovery and backup strategies for Maximum 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.
Minimum Qualifications:
Education and Certification
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).
Experience
At least 5 7 years of hands-on experience with IBM Maximo Asset Managementdatabase hosted in a cloud environment or a complex information systems and data processing management in a large organization, transit preferred. Thisincludes 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 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.
Technical Skills
Cloud Platform Expertise
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
Database Management in the Cloud
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.
Performance and Cost Optimization
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 database tier, managing storage, and leveraging reserved instances or serverless models.
Automation and Scripting
Proficiency with automation tools such as Terraform, Ansible, or cloud-nativeInfrastructure as Code (IaC) tools for database provisioning and management.
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).
Experience
At least 5 7 years of hands-on experience with IBM Maximo Asset Managementdatabase hosted in a cloud environment or a complex information systems and data processing management in a large organization, transit preferred. Thisincludes 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 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.
Technical Skills
Cloud Platform Expertise
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
Database Management in the Cloud
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.
Performance and Cost Optimization
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 database tier, managing storage, and leveraging reserved instances or serverless models.
Automation and Scripting
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.
Maximo and Oracle Expertise:
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.
High Availability and Advanced Techniques:
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 for cloud environments.
Knowledge of SQL database technology
Programming and Administration:
Advanced level of Linux usage and administration.
Proficiency in PL/SQL for database scripting and automation.
Integration and Transit-Specific Systems
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
Data Management and Migration
Proven experience developing data migration scripts and archiving strategies forMaximo upgrades.
Ability to ensure data integrity, consistency, and performance across Maximum Databases and integrated systems.
Cloud Integration and Data Migration
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.
Monitoring and Troubleshooting
Experience with cloud-native monitoring and troubleshooting tools to ensure database reliability and performance.
Familiarity with database-specific cloud monitoring systems, such as Azure SQLInsights, or Oracle Enterprise Manager.
Proficiency with writing, enhancing and maintaining Oracle scripts for data integration.
Maximo and Oracle Expertise:
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.
High Availability and Advanced Techniques:
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 for cloud environments.
Knowledge of SQL database technology
Programming and Administration:
Advanced level of Linux usage and administration.
Proficiency in PL/SQL for database scripting and automation.
Integration and Transit-Specific Systems
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
Data Management and Migration
Proven experience developing data migration scripts and archiving strategies forMaximo upgrades.
Ability to ensure data integrity, consistency, and performance across Maximum Databases and integrated systems.
Cloud Integration and Data Migration
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.
Monitoring and Troubleshooting
Experience with cloud-native monitoring and troubleshooting tools to ensure database reliability and performance.
Familiarity with database-specific cloud monitoring systems, such as Azure SQLInsights, or Oracle Enterprise Manager.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.