ServiceNow CMDB Experience (Desired, but not mandatory)
Manages data with Tables, the CMDB, Import Sets, and Update Sets
Moving data in and out of an instance using import sets and transform maps and also auto import of data into ServiceNow
Produces appropriate database specifications and support documentation.
Develops source file processing logic, retention, and archive recommendations.
Develop and maintain the data model and data dictionary for the system.
Designs and develops SQL queries and reports to retrieve required data.
Optimizes/balances processing and performance for peak and load.
Validates, loads, tests, and verifies data.
Verifies information provided in all environments including development, test and production.
Performs complete functional testing of database structures.
Prepares appropriate dimensional data structures and provides logical interfaces for the extract/transform/load process.
Must have ten (10) years of experience that may be a combination of work history and education. A master’s degree is equivalent to 6 years of experience, a bachelor’s degree is equivalent to 4 years of experience and an associate’s degree is equivalent to 2 years of experience. The degree must be in Computer Science, Information Assurance, Information Security System Engineering, or related discipline from an accredited college or university. Experience with data base administration, configuration, and daily maintenance. SQL, MySQL, Oracle a plus.