Sql dba Jobs in Durham, NC

CMMS (Computerized Maintenance Management System) Analyst

Work Arrangement: On-Site Requisition Number: 261085 Regular or Temporary: Regular Location: Durham, NC, US, 27710 Personnel Area: CENTRAL ADMIN MANAGEMENT CTR

Occupational Summary The Computerized Maintenance Management System(CMMS) Analyst will provide a wide variety of analytical, strategic and operational support to the Facilities Management Department (FMD) primarily focusing on the (CMMS). The CMMS program is instrumental in notifying and prioritizing Operations & Maintenance preventative and corrective maintenance for the Department. The CMMS Analyst will report to the Manager of Support Services and will assist with various other CMMS administrative functions. Work Performed: Responsible for the management and coordination of equipment/asset management, reporting metrics and development of training programs and materials. The individual will work closely with all shops, planners & managers and have in-depth understanding of materials management for the Department. This position will be responsible for maintaining and optimizing the current PM program including taking the lead on PM development while working with a wide range of stakeholders to ensure an efficient PM program is in place. Define and document standard workflow processes for creating and maintaining asset information, setting up and modifying PM schedules, tasks and routes. Oversee the implementation and perform regular optimization review of the work flows. Participate in establishing and maintaining reports, KPIs, and inboxes in the CMMS to provide easy-to-access status updates on key information for shops, storerooms, and managers. Update and maintain existing metric reports utilizing SQL programming and have a thorough knowledge of the layout and operation of the CMMS database. Work with management and others in increasing the user experience of the CMMS including but not limited to creating/altering customizable objects like User Defined Fields and User Defined Screens, reports, and other system enhancements. Work with EAM Administrator in understanding the back end of the system and provide backup Administration duties as required. Participate in developing and presenting a training program for new employees and refresher training for staff and managers including the mobile interface. Generate reports to analyze work orders, shop labor, materials and costs to evaluate maintenance costs and recurring maintenance issues to assist in decision making on renewal funding or potential maintenance strategy changes. Collaborate with the Project Managers to ensure equipment is updated, either added or removed, as a result of campus construction projects Perform other duties as assigned by department leadership. Anticipated Pay Range: Duke University provides an annual base salary range for this position as USD $59,829.00 to USD $104,550.00. Duke University considers factors such as (but not limited to) scope and responsibilities of the position; candidate's work experience, education/training, and key skills; internal peer equity; as well as market and organizational considerations when extending an offer. Your total compensation goes beyond the dollars on your paycheck. Duke provides comprehensive and competitive medical and dental care programs, generous retirement benefits, and a wide array of family-friendly and cultural programs to eligible team members. Learn more at: Education Work requires an Associate's degree in Engineering, Architecture, Business or related field. Alternately, equivalent knowledge and experience in facilities maintenance and operations, or construction and renovation in facilities management combined with relevant education may qualify Experience (4) Four years of facilities management experience preferred. Good knowledge of building systems and general facilities maintenance practices. Proficient with CMMS including report, grid, and SQL business rule development. Experience in HxGN CMMS preferred. Computer software skills using MS Office including Word, Excel, PowerPoint, and Outlook. Excellent oral and written communication skills; ability to communicate effectively to a wide range of audiences, including senior University management, faculty, staff from other departments, students, and others. Ability to create and maintain positive customer and stakeholder relationships. Duke is an Equal Opportunity Employer committed to providing employment opportunity without regard to an individual's age, color, disability, gender, gender expression, gender identity, genetic information, national origin, race, religion, sex (including pregnancy and pregnancy related conditions), sexual orientation or military status. Duke aspires to create a community built on collaboration, innovation, creativity, and belonging. Our collective success depends on the robust exchange of ideasan exchange that is best when the rich diversity of our perspectives, backgrounds, and experiences flourishes. To achieve this exchange, it is essential that all members of the community feel secure and welcome, that the contributions of all individuals are respected, and that all voices are heard. All members of our community have a responsibility to uphold these values. Essential Physical Job Functions: Certain jobs at Duke University and Duke University Health System may include essential job functions that require specific physical and/or mental abilities. Additional information and provision for requests for reasonable accommodation will be provided by each hiring department.