Junior Database Administrator

TITLE:

Junior Database Administrator

DEPARTMENT:

IT

WORK TYPE:

Full-Time Exempt

LOCATION:

12999 E. Adam Aircraft Circle, Englewood, CO 80112

PAY RANGE:

$55,000 - $70,000 DOE

BONUS:

8% bonus potential based upon achievement of defined goals

401(K):

3% automatic safe-harbor match plus 80% elective deferral match of the first 5% contributed by the employee

BENEFITS:

Medical, Dental, Vision, FSA or HSA*, Short-Term Disability Insurance, Employer Paid Life Insurance, Employer Paid Long-Term Disability, Travel Assistance, and EAP. Sick, Vacation, and Holidays including Winter Break office closure from 12/24-1/1. 9/80 Work Schedule option.
 

SUMMARY

This is a hands-on position within the information systems team with a primary focus on technical support for the Society for Mining, Metallurgy & Exploration’s (SME) association management system (AMS). This includes the following 5 areas; 1. Staff Support, 2. System and software maintenance, 3. Reports, 4. Database/SQL support and 5. Development.

 

KEY RESPONSIBILITIES:

Reasonable accommodations may be made to enable individuals with disabilities to perform the assigned and essential functions.

Staff Support:

  • Respond to, troubleshoot, route and ensure timely closure of AMS support tickets.
  • Work with the SME’s business analyst, Personify’s support staff, and other IT team members to assist in resolving AMS related problems.
  • Create and maintain system and project documentation as required. Including updating SME’s knowledge base and provide training to staff.

System and Software maintenance:

  • Assist with the configuration and maintenance of SME’s AMS.
  • Assist in create new products in the AMS, collaborating with the business analyst, the finance team and product owners, this includes, meetings, inventoried products, webinars, subscriptions, new and renewing memberships.
  • Coordinate with the business analyst and the IS manager to thoroughly test any upgrades, migrations, new features, etc., with documented results and organized communication to staff and technical partners.

Reports:

  • Gather report requirements, create, maintain and schedule necessary reports (as required) using Crystal Reports and/or Business Objects Data Analyzer to address requests submitted by customers.
  • Gather report requirements, create, maintain and schedule necessary reports (as required) using Crystal Reports and/or Business Objects Data Analyzer to address data quality and data auditing requirements.
  • Create and Maintain universes, views and other possible data subsets.
  • Create widgets, dashboards, etc. per request.

Database/SQL Support

  • Data handling and diagnostic skills and abilities to work with real-world datasets to produce meaningful business information that meets the requestor’s need.
  • Knowledge of and familiarity with computerized information systems particularly, SQL database applications and Microsoft office applications
  • Technical competence in relational database concepts and SQL language with the ability to assist in designing and developing queries, stored procedures, views, datasets for analysis as well as developing, writing, testing and executing scripts.

Development:

  • Work with SME’s business analyst and the web development team to help develop small scale applications using Personify’s API’s, web services, and data services for web access and database integration.
  • Other duties as assigned.
 

REQUIRED EDUCATION AND EXPERIENCE

  • Bachelor's Degree in information technology, computer science, or a related field. 
  • 3 years of experience in systems analysis and/or support working with Association Management Systems.  
  • Experience in developing, using:  MS SQL, including understanding of tables, views, stored procedures, functions, primary and foreign keys, relationships, triggers and ability to write scripts for same.
  • Possess a strong technical and working knowledge of current database software, protocols, and standards, including SQL Reporting Services, Crystal Report development, SAP Business Objects.
  • Development skills web-service calls and API interfaces.
 

PREFERRED EDUCATION AND EXPERIENCE

  • Personify experience a plus.
 

The above qualifications and requirements are representative, but not all-inclusive, of the knowledge, skills, and abilities required for the position.

 

EOE/Minorities/Females/Veterans/Disabled

 

 

If you are having issues submitting your application online, please submit a cover letter expressing why you are interested in this particular position, including how your experience is related to the duties of the position, and a resume to jobs@smenet.org.

 

SME, www.smenet.org, is a scientific and technical society (501(c) (3) corporation) whose more than 13,000 members globally in more than 100 countries.  SME members include engineers, geologists, metallurgists, educators, students and researchers focused on innovations in mining engineering. SME nurtures a professional community, develops technical content, and provides networking and educational opportunities for the mining industry.