Stanfield Systems, Inc.

Database Developer

  • Job Type: Full Time
  • Industry Type: IT Sector
  • Industry Location: Sacramento
  • Experience: NA
  • No. of Positions: 1
  • Primary Skills: Database Developer Transact-SQL ETL SQL Server SQL DBA Agile OLTP Microsoft SQL Server Data Modeling report development writing queries relational database design reporting tools query tools PowerShell Data warehousing PowerBI Tableau Data warehouse SSIS SSAS
  • Secondary Skills: C# .NET Database design data issues data integrity Ad hoc reporting .NET C# Communication skills Attention to detail Microsoft Power BI Microsoft SSAS Microsoft SSIS IT management Windows PowerShell Troubleshooting Self motivated Scripting Database Reporting Business requirements
  • Job Location: Sacramento, California
  • Posted Date: Posted today
Job Description

Job Description

Reporting to the Database Technical Manager, the self-motivated database developer will support cutting edge healthcare software related software and report development. As part of a small, agile team, many opportunities exist on for exploring new technologies and gaining robust development skills:

  • Translate business requirements into a performance optimized data base design
  • Create practical logical & physical models
  • Evaluate data issues & ensure data integrity
  • Develop Transact-SQL scripts for operational, analytical reports, and ETL processes
  • Develop Transact-SQL scripts for manipulating data
  • Develop tabular models to support ad hoc reporting (Ad hoc report models are no longer supported in the newer version of SQL Server)
  • Investigate, troubleshoot and correct data and user related system errors
  • Participate in design sessions and code reviews
  • Work under an Agile development process
  • Demonstrate the ability to communicate effectively with both Subject Matter Experts and Developers
  • Estimate development efforts accurately
  • Support data warehouse database in addition to OLTP systems

Required Experience and Qualification

  • BE or BS Degree in Computer Science, Information Technology or related field preferred
  • Minimum 3 years database development experience with a strong understanding of database structures, theories, principles, and practices.
  • 2+ years Microsoft SQL Server experience
  • Experience with Data Modeling
  • Experience with report development and writing queries
  • Good understanding of Relational database design, OLTP concepts
  • Knowledge of reporting and query tools, and practices
  • Good interpersonal, written, and oral communication skills
  • Self-motivated and directed, with keen attention to detail
  • Able to prioritize and execute tasks in a high-pressure environment
  • Experience in working in a team-oriented, collaborative environment

Nice to have

  • PowerShell
  • Experience with ETL/Data Warehousing
  • PowerBI, Tableau, Data Warehouse, SSIS and SSAS knowledge and experience

Other scripting languages

  • Comfortable reading C# .NET code for analysis purposes.
Relevant Job Openings
Oracle Developer
Tableau developer
Java Developer
Azure Data Architect with Talend
Node JS Developer
Java Full stack Developer