Senior SQL Developer
Clackamas Community College
Opening Date/Time: Fri. 02/03/17 12:00 AM Pacific Time
Closing Date/Time: Continuous
$33.80 - $36.83 Hourly
$5,859.07 - $6,383.74 Monthly
$70,308.84 - $76,604.88 Annually
Job Type: Full-Time, Union
Location: Oregon City Campus, 19600 Molalla Avenue, Oregon City, Oregon
Department: Information Technology
This position will remain open until filled. For full consideration, application materials should be received by March 1, 2017.
Develop and support the Microsoft SQL database environment and associated technologies. Perform database design, data modeling, SQL code creation and analysis, query optimization, custom data extracts, and reporting. Resolve system concerns such as performance issues, database capacity, replication and/or other data distribution issues. Serve as institution-wide technical expert responsible for design, programming, implementation, deployment and ongoing support of complex applications, databases and computer systems for the college's Enterprise Information System (EIS).
ESSENTIAL JOB FUNCTIONS:
Coordinate technical database projects. Manage all technical aspects of databases and database processes.
Analyze, develop, implement, integrate, test, debug and deploy system enhancements. Recommend administrative setup modification, and tune and monitor performance related to the college's Microsoft SQL EIS.
Implement and maintain database security policies and best practices. Create and maintain user accounts and roles; assign privileges. Set up and maintain documentation and standards.
Write and optimize complex data mining queries and reports. Ensure data can be provided to support OLAP reports and various reporting requirements.
Transform data via standardization, cleaning, data repair, matching, and de-duping.
Design and develop schema, aggregations, indexes, views, triggers, and stored procedures. Support database activities such as data loading and unloading.
Design, program, implement, integrate and provide ongoing support for database structures using a variety of development tools and languages, including (but not limited to) UniBasic, TSQL, and UniQuery within database environments.
Design, develop, implement, test, deploy and maintain the institutional data warehouse, data-marts, and reporting systems that afford institutional level data analysis using development tools and database specific tools, such as (but not limited to) Microsoft Reporting Services, Integration Services and Analysis Services.
Manage database resources, including planning for capacity building. Evaluate new database related software products to ensure functionality for the college's needs, prior to to introduction and implementation.
Develop, coordinate, and conduct training program for key database users. Facilitate training sessions regarding new system capabilities and functionality.
Reviewing and analyze existing college business policies, database practices and procedures, and reporting structures and usage. Advise management of recommended improvements, including interrelationship between existing, new, and/or proposed systems.
Manage data from multiple sources including internal, external, and third parties.
Serve as liaison between college users and ITS staff. Communicate the status of problem resolution, log and track requests for assistance, troubleshoot problems, and compile data/reports.
Maintain cooperative working relationship with College staff, other organizations, and the public.
Follow all safety rules and procedures for work areas.
Performs other related duties as assigned.
AUXILIARY JOB FUNCTIONS:
May provide assistance to other college personnel as workload and staffing levels dictate.
Maintain proficiency by attending training and meetings, reading materials, and meeting with others in areas of responsibility.
Maintain work areas in a clean and orderly manner.
The education and/or work experience sections of your online application form must demonstrate that you meet all of the following Minimum Qualifications.The information on the cover letter/resume will not substitute for the completed application.
MINIMUM/MANDATORY EDUCATION AND EXPERIENCE REQUIREMENTS:
Any equivalent combination of education and experience which provides the applicant with the knowledge, skills, and abilities required to perform the duties as described. A typical way to obtain the knowledge and skills would be: Bachelor's Degree in Computer Science, Business Administration or related field AND a minimum of seven years' experience in troubleshooting software applications, and developing and delivering small group training.
KNOWLEDGE: Thorough knowledge of Microsoft SQL Enterprise 2012, including best practices for schema management, index optimization, and use of hints. Working knowledge of Datatel Colleague software suite and related products. Knowledge of college business operations, processes, and procedures.
SKILL: Strong query and database tuning skills. Strong analytic, technical, communication and organizational skills to evaluate and recommend efficient systems and processes. Skill in the use of personal computers, computer networks, and database systems.
ABILITIES: Ability to work cooperatively with others. Ability to communicate effectively both orally and in writing. Ability to interpret spoken messages and employ reason to resolve complex technical problems with employees at all levels of the organization. Ability to maintain a high degree of discretion when dealing with confidential information.
Other Job Elements:
The physical demands listed below represent those that must be met by an incumbent to successfully perform the essential functions of the job.Reasonable accommodations may be made to enable individuals with qualified disabilities to perform the essential functions.
PHYSICAL DEMANDS OF POSITION:
While performing the duties of this position, the employee is frequently required to sit, stand, bend, kneel, stoop, communicate, reach, and manipulate objects.Duties require mobility including the ability to move materials weighing up to 25 pounds on a regular basis such as files, books, office equipment, etc., and may occasionally require moving materials weighing up to 60 pounds.Manual dexterity and coordination are required more than 50% of the work period while operating equipment such as computer keyboard, telephone, calculator, and standard office equipment.
The work environment characteristics described below are representative of those an employee encounters while performing the essential functions of this job.Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
Usual office working conditions.The noise level in the work area is typical of most office environments with telephones, personal interruptions, and background noises.Limited travel required for meetings and training on an as needed basis.
Supervision of others is not a typical function assigned to this position.May provide training and orientation to newly assigned personnel, and may assign work to student workers.
Works under the general direction of the Dean of Information Technology.
Clackamas Community College is a diverse community that provides equal opportunity in employment, activities, and its programs.It is the policy of the Clackamas Community College and its Board that there will be no discrimination or harassment in any educations programs, activities or employment on the grounds of race, color, religion, ethnicity, use of native language, national origin, sex, sexual orientation, marital status, disability, veteran status, age, genetic information or any other status protected under applicable federal, state or local laws.
The College also prohibits retaliation against an individual for engaging in activity protected under this policy, and interfering with rights or privileges granted under anti-discrimination laws.
Persons having questions about equal opportunity and nondiscrimination should contact the dean of Human Resources for Clackamas Community College in Barlow Hall at the Oregon City campus, 503-594-3300. Please note the following areas of responsibility, should you need relevant resources or information: Section 504 Coordinator, Disability Coordinator, Oregon City campus, 503-594-3181; Title II Coordinator, Associate Dean, Oregon City campus, 503-594-3392; Title IX Coordinator, Dean, Human Resources, Oregon City campus, 503-594-3300.
ADDITIONAL POSTING INSTRUCTIONS:
To apply for this position, you must submit:
Completed online application
Cover Letter explaining your interest in the position and describing how you meet the minimum and special qualifications and requirements of the position
Current Resume or Curriculum Vitae
1 Letter of Recommendation
Completed responses to the Supplemental Questions
Upon hire, candidate will be required to provide official transcripts for degrees earned, if applicable.
CCC only accepts applications through this online application system. We want you to be successful in applying with us. We highly encourage you to complete and submit your application in advance of the deadline.
For assistance with this, please email email@example.com. For technical assistance with your application, please call (855) 524-5627.
Please note: This is initially a self-screening system. We recognize that our application process can be lengthy, so before you begin, please read all of the stated requirements to determine if you meet them. Applicants must meet all of the stated minimum/special qualifications and additional requirements to be considered for this position. Based on your responses to the qualifying questions, the system may automatically screen you out from further consideration.
Required documents must be provided at the time of application. Please remove any personal information such as photographs, date of birth, gender, social security number, and other protected information from your documents. Documents containing protected information will be considered incomplete. Incomplete applications will not be considered.
Positions are subject to budget consideration and approval. For the candidate who is hired into this position, salary placement will be based on guidelines in the handbook or association agreement (as applicable) to assess education and experience. For this reason, please be sure to include everything in your application that you want the college to consider towards placement.
Clackamas Community College participates in E-Verify and will provide the Social Security Administration (SSA) and, if necessary, the Department of Homeland Security (DHS) with information from each new employee's Form I-9 to confirm work authorization. This information is kept completely confidential, is obtained only after a candidate is hired, and will not be used to pre-screen any job applicant.
The college does not sponsor employees in the visa application process if they intend to use this as their means to work in the United States. This means that all required work visas must be in place and supported by appropriate evidence to be employed by Clackamas.
REASONABLE ACCOMMODATION STATEMENT:
Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions of this job.
This job description is a general description of essential job functions. It is not intended as an employment contract nor is it intended to describe all responsibilities, skills, effort, or work conditions associated with the job someone in this position would perform. All employees of Clackamas Community College are expected to perform tasks as assigned by Clackamas Community College supervisory/management personnel regardless of job title or routine job duties.
VETERAN'S PREFERENCE STATEMENT:
Applicants are eligible to use Veteran's Preference when applying with Clackamas Community College in accordance with ORS 408.225, 408.230 and 408.235; and OAR 105-040-0010 and 105-040-0015. Preference will only be given if the applicant meets the minimum qualifications and any special qualifications for the position and electronically attach the required documentation at the time of application.
MEMBER COPY 4 of the Certificate of Release or Discharge from Active Duty (DD Form 214 or 215) – OR – Letter from the US Dept. of Veterans Affairs indicating a non-service connected pension.
Disabled Veterans must also submit a copy of their Veterans disability preference letter from the Department of Veterans Affairs.
◦ You can request copies of your military service record through the National Archives website at: http://www.archives.gov/veterans/military-service-records/
For information regarding Veteran's Preference qualifications, visit the following website: http://www.oregonjobs.org/DAS/STJOBS/vetpoints.shtmlq
Copyright 2015 Jobelephant.com Inc. All rights reserved.
Posted by the FREE value-added recruitment advertising agency