Amick Brown is looking for an experienced SeniorDatabase Developer for our direct client in the public sector. Location: Sacramento, CA Duration: 6+ Months Roles and Responsibilities
Maintain data collection and ETL processes
Develop databases, building stored procedures, views, triggers to support database interactions
Work closely with teammates on the Databases and Business Analysis team as well as the Applications Development teams
Develop complex data extracts, applications, and ad-hoc queries as requested by using SQL or SSIS
Research, troubleshoot, and resolve data issues impacting extract delivery
Work within the project team to complete system analysis and application design
Work closely with Business Analysts to refine requirements, and ensure data quality
Collaborate on the definition, development, and maintenance of standards and processes
Drive continuous improvement and automation in BI solutions and processes
Work effectively with System Administrators, Project Manager(s), Developers and Management
Participate in a team development environment using the TFS source control system
This role does not include classic DBA responsibilities like backup and restore
Required Technical Skills
Must be proficient with T-SQL, and development of stored procedures
Report writing and dashboard development experience, preferably with SSRS and Power BI
Degree in Computer Science, business or related discipline.
4 years of experience with T-SQL, including stored procedure development
Knowledge of data integration, e.g., extract, transform, and load (ETL) process development/support.
Able to develop and troubleshoot reports delivered with SSRS; requires good analytical skills.
Experience with data access performance tuning, and database performance optimization.
Application Development Lifecycle knowledge and experience.
Data transport protocols, e.g., SFTP, XML, and JDXDML.
Experience with Case Management data and/or Call Center data.
Documentation of system support information.
Basic understanding of networking principles.
Ability to analyze system resource usage and constraints.
Strong communication skills and ability to interact at all levels including management.
Works independently and follows through on assignments
Amick Brown is an Information Technology consulting company specializing in ERP, Data Analytics, Information Security, Application Development, Networking, and Cloud Computing. The company was founded in 2010 and is headquartered in San Ramon, California.
Regular full-time employees are eligible for the following Amick Brown provided benefits: