No experience
Employment Type:
Full time
Job Category:
Information Services
Associate Programmer Analyst (specialist)
(This job is no longer available)
State of California | Sacramento, CA
Grad Date

Not sure what types of jobs you are interested in?

Explore Jobs
Based on Your Education

Follow This Company

Job Description

Please list position number, RPA number and eligibility on your application under Job Title(s) for which you are applying. To be considered for this vacancy you must have transfer eligibility based on present or past state civil service eligibility, or passed an exam for this classification. **If you have SROA/Surplus status, please indicate by either attaching your surplus letter or notating it on line 12 of your application.** Please mail applications attention to Stefani Fong at 1416 9th Street, 12th Floor, 1217B, Sacramento, CA 95814.

Who We Are:
The California Department of Fish and Wildlife (CDFW) manage California's diverse fish, wildlife and plant resources and the habitats upon which they depend. Throughout the organization, CDFW staff is committed to sustaining California's abundant natural resources. CDFW combines several diverse lines of businesses dedicated to science, conservation and research including: Marine, Ecosystem Conservation, Wildlife, Fisheries, Spill Prevention and Response, Law Enforcement, Fiscal and Information Technology, Located in downtown Sacramento, we are a premier state employer offering competitive salary, excellent benefit packages with opportunity for advancement. We are looking for people who share our interests and dedication to the state's natural resources and desire to work in a stimulating environment with truly dedicated staff.

What You Will Do:
CDFW has an exciting opportunity for an Associate Programmer Analyst (Specialist) to manage the CDFW data systems. You will serve as a Database Developer designing, developing and maintaining CDFW databases for the enterprise and in support of software development projects. This is an excellent opportunity to work with a great team and to join an organization that offers professional growth and training opportunities working with modern Microsoft technology. You will work with a senior database architect to learn best practices with database design and development.

The incumbent will demonstrate proficiency in information system development concepts, methods and best practices. The incumbent will also have demonstrated experience and knowledge of data systems, and business intelligence. Knowledge and abilities using Transact-SQL query language or similar SQL query language. Experience with reporting and business intelligence tools desired.
The ideal candidate will possess the skills to: Design physical and logical data models, create SQL statements, create stored procedures, views and triggers, develop the physical database, define and implement database user roles using Microsoft SQL Server Management Studio, create entity relationship diagramming, create business intelligence in the form of reports, charts and graphs.
Entry level computer science graduates encouraged to apply.

CDFW employees are eligible for benefits including Leave (vacation, sick, holidays) Health (health care, dental, vision), Retirement (CalPERS, savings plus program) to name a few. Please visit the California Department of Human Resources website for a complete listing of benefits. If you are interested in an exciting career choice where people, talent and experience are valued, the California Department of Fish and Wildlife encourages you to apply.

CDFW uses modern technology and is committed to developing the skills of our technical staff. We provide several training opportunities such as classroom training, online training as well as MSDN and Pluralsight subscriptions.

Alternate work hours are available after the initial probationary period

A valid California driver's license is required for this position.

Duty Statement is available upon request.

The State of California is an equal opportunity employer to all, regardless of age, ancestry, color, disability (mental and physical), exercising the right to family care and medical leave, gender, gender expression, gender identity, genetic information, marital status, medical condition, military or veteran status, national origin, political affiliation, race, religious creed, sex (includes pregnancy, childbirth, breastfeeding and related medical conditions), and sexual orientation.
RPA# ITSB 15-007

About State of California

CSAC has a long history of helping our members accomplish their missions. We now proudly offer our latest program to make human resource (HR) advice and services easily accessible to each county. Our intent in forming CSAC HR Advisory Services was to initiate a way for counties to acquire essential services efficiently without significant cost. We are particularly pleased with the quality of the public/private partnership of Shannon Associates and CPS, selected through a competitive RFP process. Shannon Associates is well-known to many of you for its exceptional search services and long history of working with counties to make their management structures more efficient. CPS is already a presence in all our counties through its administration of the Merit Systems Services programs, and its ongoing consulting role with our county human resources departments. We at CSAC believe that partnerships with other entities benefit our members, and we are excited about the creation of this HR alliance through the RFP process. We know you will experience the excellent service you have come to expect from your association, and we welcome further opportunities to help you satisfy your business demands.