State of Washington Dept. of Ecology invites applications for the position of: Database Manager (Information Technology Specialist 1) [http://agency.governmentjobs.com/washington/careersLogo-blue.jpg] SALARY: $3,117.00 - $4,088.00 Monthly OPENING DATE: 12/06/12 CLOSING DATE: 12/21/12 11:59 PM DESCRIPTION: [http://agency.governmentjobs.com/images/AgencyImages/jobposting/1924/JobPostings/image/ECY/Saving%20Puget%20Sound(2).jpg] [http://agency.governmentjobs.com/images/AgencyImages/jobposting/1924/JobPostings/image/ECY/Facing%20Climate%20Change.jpg] [http://agency.governmentjobs.com/images/AgencyImages/jobposting/1924/JobPostings/image/ECY/Reducing%20Toxic%20Threats.jpg] [http://agency.governmentjobs.com/images/AgencyImages/jobposting/1924/JobPostings/image/ECY/Managing%20Our%20Water.jpg] [http://agency.governmentjobs.com/images/AgencyImages/jobposting/1924/JobPostings/image/ECY/ourlivingshorelines.jpg] [http://agency.governmentjobs.com/images/AgencyImages/jobposting/1924/JobPostings/image/ECY/ECYlogo_wide.jpg] Keeping Washington Clean and Evergreen The Department of Ecology's mission is to protect, preserve and enhance Washington's environment, and promote the wise management of our air, land and water for current and future generations. This means protecting both humans and the environment from pollution, restoring and preserving important ecosystems that sustain life, and finding ways to meet human needs without destroying environmental resources and functions. Our everyday interaction with citizens, stakeholders, and the public we regulate is fundamental to achieving these results. We treat our customers as partners and collaborators, provide respectful and prompt service, explore creative solutions for the best results, and act with integrity. We maintain effective infrastructures and foster a workforce that is committed, productive and successful. We invest in our employees to create and sustain a working environment that encourages creative leadership, teamwork, professionalism and accountability. The citizens of Washington trust that the Department of Ecology supports and assists them in promoting the sustainable environmental and economic well-being of the state. That trust, coupled with our effectiveness, helps Ecology to continue to receive the support it needs to advance our environmental mission. To learn more about our agency, please visit our website at www.ecy.wa.gov<http://www.ecy.wa.gov/>. Local efforts... Diverse people... Statewide impacts DUTIES: [http://agency.governmentjobs.com/images/AgencyImages/jobposting/1924/JobPostings/image/ECY/TCP%20New.gif] Accidental spills of dangerous materials and past business practices have contaminated land and water throughout the state. The Toxics Cleanup Program<http://www.ecy.wa.gov/programs/tcp/cleanup.html> (TCP) works to remedy these situations, which range from cleaning up contamination from leaking underground storage tanks, to large, complex projects requiring engineering solutions. Our mission is to get and keep contaminants out of the environment. The Tacoma Smelter Plume (TSP) Unit in the Southwest Region in Lacey, WA<http://www.ci.lacey.wa.us/> is looking for a TSP Areawide Remediation Environmental Information System (AREIS) Database Manager (Information Technology Specialist 1). This is a project position currently funded until June 30, 2021. The TSP Program is focused on sampling and remediation of childcare facilities, schools, parks, camps, and residential properties. The TSP yard cleanup and soil safety programs are high priority projects covering two regions - Northwest and Southwest Regional Offices. It is estimated that nearly 16,000 properties will need to be addressed by these programs. As the Areawide Database Manager for the TSP project, this position serves as the technical expert responsible for maintaining information on several database systems and for the development of business intelligence products. The successful candidate will be responsible for all TSP data as well as the design, development, and implementation of business intelligence products in support of these systems. The Database Manager will also provide input to the TCP IT Team during the development of new information systems or complex business intelligence products. QUALIFICATIONS: Required Qualifications Two years of information technology experience to include analyzing, designing, and programming computer software application, or developing canned or ad-hoc reports using Structured Query Language (SQL) OR A Bachelor's Degree in Computer Science or a related field. Desirable Qualifications A Bachelor's with focus in Computer Science Experience with software development, SQL report development, and GIS Knowledge of current software development methodologies and test techniques Experience in Design Teams and development of end-user requirements specifications to include use case or user story documentation for routine tasks Understanding of mathematical functions and formulas Experience creating elementary data flow diagrams, process models, prototypes, and user instructions SUPPLEMENTAL INFORMATION: Application Instructions Please complete the applicant profile when applying for this position. Or, you may paste the text of your resume within the profile's resume text field. Please read the supplemental questions carefully and answer completely. Incomplete responses, including "please see resume" may disqualify you from further consideration. Department of Ecology employees, please make sure to answer the agency-wide questions regarding permanent status as classified employee within the Washington General Service or Washington Management Service. Do not forget to select Department of Ecology as a response to question 2, and type your personnel ID number for question 3. If you are not sure of your status or do not know your personnel ID number, please contact Human Resources at (360) 407-6186. If you are reading this announcement in print format, please visit www.careers.wa.gov<http://www.careers.wa.gov/> to access the online recruitment system. Click on "Look for Jobs" and select Dept. of Ecology under the "Department" search list. Click "Apply Search." Other Information >From July 1, 2011 through June 29, 2013, a 3% temporary salary reduction is in effect for most state positions. The salary listed above includes this reduction. For specific information on the Temporary Salary Reduction, please click here<http://www.dop.wa.gov/CompClass/TempSalaryReduction/Pages/default.aspx>. If you need assistance applying for this job, please call Human Resources at (360) 407-6020 or e-mail careers@ecy.wa.gov<mailto:careers@ecy.wa.gov>. Please do not call this number or send an email to this address to follow-up the status of your application. You can view the latest status of your application on your profile's main page. The act of submitting application materials electronically is considered affirmation that the information is complete and truthful. The state may verify this information and any untruthful or misleading answers are cause for rejection of your application or dismissal if employed. This position is included in the Washington Federation of State Employees (WFSE) union bargaining unit for the Department of Ecology. All employees covered by the collective bargaining agreement (CBA) with the WFSE will, as a condition of employment, either become members of the WFSE and pay membership dues or, as non-members, pay a representation fee as described in the CBA, no later than the 30th day following the effective date of this CBA or the beginning of their employment. The Washington State Department of Ecology is an equal opportunity employer. We strive to create a working environment that includes and respects cultural, racial, ethnic, sexual orientation and gender identity diversity. Women, racial and ethnic minorities, persons of disability, persons over 40 years of age, veterans or people with military status, and people of all sexual orientations and gender identities are encouraged to apply. Persons needing accommodation in the application/testing process or this job announcement in an alternative format may call (360) 407-6186. Applicants who are deaf or hard of hearing may call the Washington Relay Service by dialing 7-1-1 or 1-800-833-6388. Database Manager (Information Technology Specialist 1) Supplemental Questionnaire * 1. Please select the statement that best describes your level of experience with information technology analysis, design, and programming of computer software applications, development of canned and ad-hoc reports using Structured Query Language (SQL)? [Checkbox] I have at least two years of experience. [Checkbox] I have at least three years of experience. [Checkbox] None of the above statements apply. * 2. Please list your position title(s) and describe your duties, with periods of employment, to support your response to the previous question. An incomplete answer, including "please see resume" may remove you from further consideration. If none, please type N/A on the space below. * 3. Do you have at least a bachelor's degree in computer science or a related field? [Checkbox] Yes [Checkbox] No * 4. Please indicate your degree and major study. * 5. Please describe your experience with Structured Query Language (SQL) and report development. What tools did you use for report development? * 6. Please describe your experience with database technologies such as Microsoft SQL Server or Microsoft Access. * 7. Please describe your experience with Geographic Information Systems (GIS) technologies. What tools did you use in your GIS work? * 8. Please describe your experience in helping to design a line of business software application. Did you assist in gathering and managing the software requirements? If so, what tools and methodologies did you employ to manage the software requirements? * 9. Please describe your experience managing information in a line of business database application. * Required Question For complete job posting please visit http://agency.governmentjobs.com/washington/default.cfm?action=viewJob&jobID=564333