DenverRecruiter Since 2001
the smart solution for Denver jobs

Database Manager

Company: iSYS LLC
Location: Denver
Posted on: February 22, 2021

Job Description:

ISYS Technologies delivers emerging technology solutions through our diverse and talented employees who are dedicated to our customers' success. We empower our teams, contribute to our country and operate responsibly. We are a reputable award-winning WOSB providing Engineering and Enterprise Information Technology (EIT) services to the Federal government. Headquartered in Colorado, ISYS serves key national customers throughout the United States with a presence in more than 16 states. A. Database Management
a. Work with Safety Management Information System (SMIS) users to de-duplicate data via SQL.
Identify duplicates across the SMIS database
Validate data with SMIS users and de-duplicate records
Write queries to monitor for data duplication b. Develop SQL queries to review, evaluate, and maintain the accuracy of the database.
Write queries to asses database health
Identify issues with data accuracy
Work with users to stage changes to the records
Develop code to resolve inaccuracies
Perform ad-hoc queries to ensure the referential integrity of the data.
c. Website debugging, reporting, and correction.
Contact users experiencing issues with SMIS
Validate, assess, and report website errors to SMIS Development team
If possible, resolve the issue and document steps to resolution
Assist the SMIS development team as the subject matter expert with possible causes and remedies
d. Work with SMIS users and developers to create procedures to prevent data discrepancies from re-occurring as the subject matter expert.
Review previous errors within SMIS and offer resolution based on experience with the SMIS system and bureau safety process
e. SMIS user account creation and access modification
Verify the identity and access level of SMIS users and safety managers
Create SMIS accounts with proper structure and access
Verify and update access levels within SMIS
Assist SMIS users in modifying access lists based on user needs and organization restrictions
Identify and remove inactive users from the system
Identify, validate, and re-activate user accounts that were incorrectly inactivated
f. SMIS Users profile updates
Work with SMIS users to update user specific information upon request
Identify issues with user profiles, validate findings, and resolve
Create custom user reporting lists (batches) based on access level
g. Document user requests for system enhancement and proposed
modifications.
Work with SMIS users to assess enhancement or changes requests
Assist the SMIS development team in implementing modifications as the subject matter expert
h. Ad-Hoc report creation
Document ad-hoc report request
Asses validity and PII impact
Develop queries and deliver necessary data in the format requested (Excel, flat file, Tableau, PowerPoint)
i. Schedule Report Creation
Customized compensation reports in support of OWCP compensation evaluation via SQL Create and deliver scheduled reporting to bureau contacts on a weekly, monthly and quarterly basis
Work with report users on extracting their data in SMIS and document and implement changes if needed
Assist in the compilation of the Annual Safety and Compensation reports--
j. Bi-Weekly FPPS Data transfer
Re-create and maintain profiles and accounts
Download payroll files via FTPS transfers
Start and monitor the application while the file is applied to SMIS
Review the results of the update
Document and correct any issues that were created as a result of the file transfer
Write queries to identify issues as a result of the data transfer
k. SMIS Development Assistance
Work with the SMIS team as the subject matter expert on the development of new modules and changes to the system
Test changes, document issues, and report issues to the SMIS development team
l. OWCP Chargeback Data Integration
Conduct quarterly data verification and correct issues before the file is applied to SMIS
Download weekly, monthly and quarterly Department of Labor data and monitor the process as the file is applied to SMIS
Review the changes made to the database, document, and correct if required
Develop and send reports based on the quarterly data applied to SMIS
m. Ad Hoc Development Requests
Assist in development planning as a subject matter expert
Assist in the development of SMIS to the project specifications (over term of the contract there will be dozens of projects that the SMIS team develops and implements)
B. SMIS Customer Support
a. Responsible for answering the SMIS support line during office hours
Respond to emails and missed calls within 24 hours of receiving
Document issues and resolution via email or within the database
b. Update SMIS help documentation when needed
c. Incident documentation process guidance
As the subject matter expert, provide guidance on the how navigate SMIS and the next steps in the incident/compensation process.
Provide safety manager and compensation coordinator contact information to SMIS users
Add and maintain the non-DOI profiles and accounts in SMIS d. Conduct SMIS training for all the categories of user Qualifications The proposed candidate should be a senior level person that possesses a degree in computer science, information systems, or other directly related discipline with at least ten years' experience in the areas of expertise identified below. Alternative qualifications include:
a. A master's degree may be substituted for two years' experience.
b. One year of additional IT experience may be substituted for each year of
degree-level education.
C. Technical Skills
The technical skills/requirements are as follow:
a. Must be able to read, write, speak, and understand English.
b. MS/SQL database management and development
i. Development and troubleshooting of MS/SQL stored procedures
ii. Development and troubleshooting of MS/SQL table structure and
joins
iii. Understanding of data encryption and best practices in dealing
with PII (Personally identifiable information)
c. Provide support to SMIS users
i. Experience in providing technical support via phone and email
ii. Ad-hoc issue mitigation using MS/SQL
iii. Ad-hoc customer reporting needs using MS/SQL
iv. Experience in SMIS data entry processes
d. Create statistical reports and charts for DOI/bureaus management
i. Development of stored procedures for reporting automation using
MS/SQL
ii. Excel data manipulation, chart, and graph creation US Citizenship is required. ISYS Technologies is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected Veteran status, or disability status. Physical Demands: The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job with or without reasonable accommodation. While performing the duties of this job, the employee will regularly sit, walk, stand and climb stairs and steps. May require walking long distance from parking to work station. Occasionally, movement that requires twisting at the neck and/or trunk more than the average person, squatting/ stooping/kneeling, reaching above the head, and forward motion will be required. The employee will continuously be required to repeat the same hand, arm, or finger motion many times. Manual and finger dexterity are essential to this position. Specific vision abilities required by this job include close, distance, depth perception and telling differences among colors. The employee must be able to communicate through speech with clients and public. Hearing requirements include conversation in both quiet and noisy environments. Lifting may require floor to waist, waist to shoulder, or shoulder to overhead movement of up to 20 pounds. This position demands tolerance for various levels of mental stress. ISYS Technologies is an Engineering and Information Technology Company focused on providing Services to the Federal and State Government. ISYS offers a competitive compensation program and comprehensive benefits package to our employees. Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.

Keywords: iSYS LLC, Denver , Database Manager, Executive , Denver, Colorado

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category
within


Other Executive Jobs


Business Development Manager - CATIA
Description: Position Overview Responsible for the development and performance of all sales activities in assigned market. Establishes plans and strategies to expand the customer base in the marketing area and contributes (more...)
Company: Computer Aided Technology
Location: Denver
Posted on: 03/2/2021

Senior Manager, Connect Partner Operations
Description: Welltok drives consumer actions that matter. Only Welltok delivers solutions built on a single, secure platform that includes a massive consumer database, predictive analytics and multi-channel engagement (more...)
Company: Welltok, Inc.
Location: Denver
Posted on: 03/2/2021

Assistant District Manager - Maintenance
Description: As an Assistant District Manager, you will have the opportunity to partner with district managers to understand our business processes and focus on operational leadership. You will be responsible for (more...)
Company: Valet Living
Location: Denver
Posted on: 03/2/2021


Delivery Manager
Description: About Qwinix br br Qwinix is a cloud-native consultancy and Google Cloud Partner. Driven by a distinguished engineering core, Qwinix works with clients to modernize their infrastructure, develop powerful (more...)
Company: Qwinix
Location: Denver
Posted on: 03/2/2021

Director, Go-to-Market Strategy
Description: At HomeAdvisor, we are revolutionizing the way that every American homeowner improves and maintains their home. We do this by creating digital products and experiences to help hundreds of millions of (more...)
Company: Greenhouse Software, Inc.
Location: Denver
Posted on: 03/2/2021

Account Manager
Description: POSaBIT is a leading financial technology company that specializes in solutions for the cannabis industry. Since 2015, POSaBIT has provided dispensaries and retailers with an innovative payment processing (more...)
Company: POSaBIT
Location: Denver
Posted on: 03/2/2021

Director of Customer and Growth Analytics - Cigna Medicare (Business Analytics Director) - Work[...]
Description: Director of Customer and Growth Analytics - Cigna Medicare Business Analytics Director - Work from home United States Work at Home Overview: Cigna's Government Business Segment GBS , and particularly (more...)
Company: Cigna Health and Life Insurance Company
Location: Denver
Posted on: 03/2/2021

Benefits Account Manager
Description: GENERAL SUMMARY:Responsible for customer service and assisting account executive and advisor with day-to-day tasks. br RESPONSIBILITIES AND DUTIES: li Processing and Submitting of New and Renewal (more...)
Company: PFS Insurance Group, LLC
Location: Johnstown
Posted on: 03/2/2021

Director Of Software Development
Description: The Director, Software Engineering position is a leadership role who will collaborate with other product and technology teams, as well as lead a platform team to holistically enhance a robust and efficient (more...)
Company: ModivCare, formerly LogistiCare
Location: Denver
Posted on: 03/2/2021

Director of Fundraising
Description: Responsible for the development and implementation of HSP's strategic plans to raise funds for the organization. Oversee and manage fundraising efforts, build strong and successful relationships, maintain (more...)
Company: Maryland Nonprofits
Location: Westminster
Posted on: 03/2/2021

Log In or Create An Account

Get the latest Colorado jobs by following @recnetCO on Twitter!

Denver RSS job feeds