Need Local::Sr. Database Developer::San Ramon, CA 94583

Title: Sr. Database Developer Duration: 8+ Months Interview: Face-To-Face Location: San Ramon, CA 94583 Required Skills: SSIS, T-SQL, Dell Boomi, ETL, SQL, SQL Server Job Description: The Data Engineer Database Developer manages the CARS data foundation and related processes for optimized performance in alignment with CARS vision, principles, architecture and standards. CARS is the Cybersecurity Analytics and Reporting Solution providing visibility...

Title: Sr. Database Developer

Duration: 8+ Months

Interview: Face-To-Face

Location: San Ramon, CA 94583

Required Skills: SSIS, T-SQL, Dell Boomi, ETL, SQL, SQL Server

Job Description: The Data Engineer Database Developer manages the CARS data foundation and related processes for optimized performance in alignment with CARS vision, principles, architecture and standards. CARS is the Cybersecurity Analytics and Reporting Solution providing visibility into the Cybersecurity landscape to improve decision quality and enhance risk intelligence for a diverse audience from executives and Cyberstream leadership to IRM professionals.

Responsibilities include:

·         Provides ongoing improvement of support processes.  Ensures solutions align with vision, principles, architecture, and standards.  Ensures information protection and security. Evaluates and recommends system upgrades and capacity adjustments

·         Designs data model and processes for new content and/or optimized performance of an analytical solution from ingestion to consumption by end user

·         Delivers viable relational and dimensional models that conform and integrate in the approved target architecture

·         Assess business requirements and data sources to determine the best design to ingest, transform, structure, and provide data for analytics tools

·         Works with the CARS data foundation owner to validate design and integration of new content

·         Provides data design artifacts and documentation

·         Contributes to the application lifecycle management of the CARS asset including planning and implementing migration to the cloud

Mandatory skills:

·         Experience in data architecture

·         Experience in data modeling

·         Creating and implementing relational and dimensional data models

·         Experience with analytics solution architecture and analytics solutions development

·         Experience with creating and implementing data designs

·         Experience with data integration between systems – ETL strategies, SSIS, Dell Boomi

·         Experience with traditional BI and/or big data ecosystems

·         Experience working within Software Development Lifecycle is required - working with Agile methods is a plus

·         Proficiency with Microsoft SQL Server, SQL and SQL Scripting, T-SQL, SQL Server Management Studio, SSIS, TFS (Team Foundation Server)

·         Knowledge of data warehousing philosophies (Kimball/Inmon) to execute data management strategy

·         Strong understanding of relational and dimensional modeling

·         Understanding of SQL Server performance and ability to design to minimize performance issues and investigate and resolve

·         Understanding of Data Governance and Data Quality and the application of these concepts to Data Architecture




Regards,

Deepak Kumar

Direct: 310-448-1044

Email ID: deepakk@rjtcompuquest.com

222 N Sepulveda Blvd., Suite 2250