Operations Database Administrator (MUST HAVE AUDTOCAD and OSP ex

Company: GPAC
Location: Portland
Posted on: March 20, 2023

Job Description:

POSITION SUMMARY The Operations Database Administrator is accountable for overseeing the day-to-day activities of the data management staff including direct supervision of records support personnel, cable locators and internet support personnel, scheduling of their work assignments and projects and review of such assignments. Principal accountabilities also includes management of database application architecture, programming, troubleshooting and security of the outside and inside plant facility records, GIS database, mapping systems and engineering design systems integration. The Operations Database Administrator must exercise independent and discretionary judgement when investigating, gathering and summarizing information to optimize efficiency for the benefit of the department and the Company.PRINCIPAL ACCOUNTABILITIESDAILY

• Oversees daily scheduling of work assignments issued to the staff
• Reviews, monitors and analyzes needs of applicable personnel based on immediate and future demands
• Processes all daily departmental paperwork and reports
• Oversees daily posting of verified data or in-service and closed graphic and non-graphic work order information to the GIS database.
• Oversees daily posting of in-service, verified or closed COE work order data to the appropriate COE records database.
• Oversees daily posting of in-service, verified or closed Plant Condition Reports and Plant Work Orders to the appropriate records base.
• Oversees the daily integration of data between various data systems as well as data integration from and to other systems, including but not limited to GPS data and data from external sources.
• Oversees daily USA procedures, coordination and scheduling of cable locates
• Oversees internet support staff ensuring high quality local technical support for internet subscribers
• Understands and accepts the necessity for reporting to work, on time, and is ready and able to perform the duties and responsibilities of the position on a daily basis
  • Proactive involvement in the Company's Safety Program, including compliance with all rules and regulations, and for continuously practicing safety while performing their duties
  • Proactive involvement of all staff in the Company's ongoing customer satisfaction programs
  • Duty Supervisor responsibilitiesPERIODIC
  • Maintains database results by setting and enforcing standards and controls.
  • Prepares for database expansion by studying plans and requirements; advising senior management; coordinating design and programming.
  • Prepares status and Ad Hoc reports as required
  • Upgrades hardware and software by assessing transaction processing and database production options.
  • Maintains database performance by troubleshooting problems.
  • Keeps senior technical management informed by preparing reports on system performance and problems.
  • Accomplishes platform upgrades and improvements by supervising system programming.
  • Oversees the integration of data from and to various computer systems, including but not limited to GPS data and data from external sources.
  • Secures database by developing policies, procedures, and controls.
  • Updates job knowledge by participating in educational opportunities; reading professional publications; maintaining personal networks; participating in professional organizations.
  • Accomplishes information systems and organization mission by completing related results as needed.
  • List of principal accountabilities is not exhaustive and may be supplemented as necessaryEDUCATIONAL REQUIREMENTS
    • Bachelor degree, emphasis in GIS, database management, electronic engineering, land surveying or related field desirableTECHNICAL REQUIREMENTS
    • Computer literate with emphasis on Microsoft Office
    • Detail functional knowledge of CAD/GIS systems software, preferably AutoCAD Map 3D
    • Detail functional knowledge of ArcGIS Online applications
    • Detail functional knowledge of GPS systems, equipment and techniques
    • Detail functional knowledge of data structures associated with GIS systems.
    • Detail functional knowledge in SQL and SSRS
    • Knowledge of cable splicing and assignment
    • Knowledge of RUS symbols and procedures
    • Knowledge of data and special circuit design parameters
    • Proficiency in reading engineering and splicing schematics
    • Proficiency in reading and developing as-built prints
    • Proficiency in reading record-of-survey maps and Assessor's Parcel information
    • Conceptual understanding of basic DC and AC electronics
    • Supervisory skills
    • Possesses and maintains a valid and unrestricted class "C" driver's license, with driving records that provides insurability under the Company's vehicle insurance carrier and within the guidelines of the CompanyWORK EXPERIENCE
    • 3 years as an OSP engineer, OSP Technician, Line Assigner, CAD Operator, or similar position, where duties correspond with the essential and periodic functions of this position
    • Supervisory experience desirable. Data Maintenance, Database Management, Promoting Process Improvement, Presenting Technical Information, Database Design, Reporting Skills, Quality Focus, Technical Understanding, Attention to Detail, Thoroughness, Requirements AnalysisContact All qualified applicants will receive consideration without regard to race, age, color, sex (including pregnancy), religion, national origin, disability, sexual orientation, gender identity, marital status, military status, genetic information, or any other status protected by applicable laws or regulations. GPAC (Growing People and Companies) is an award-winning search firm specializing in placing quality professionals within multiple industries across the United States since 1990. We are extremely competitive, client-focused and realize that our value is in our ability to deliver the right solutions at the right time.

Keywords: GPAC, Portland , Operations Database Administrator (MUST HAVE AUDTOCAD and OSP ex, IT / Software / Systems , Portland, Oregon