Senior Database Engineer or Architect at Remote, Remote, USA |
Email: [email protected] |
From: Chetan Kumar Jha, Absolute IT [email protected] Reply to: [email protected] Job Title: Senior Database Engineer/Architect Location: Hybrid in Oakland, CA (Local Only) Duration: 12 Months Job Description: Digital Intelligence Solutions (DISYS) is seeking a Senior Database Engineer/Architect to provide Clinical data solutions for Healthcare informatics efforts as part of that team that designs, develops, and delivers a large-scale Data Mart solution. We are looking for a highly motivated professional with advanced database architectural, organizational, analytical, and problem-solving skills who is interested in a multi-year position in a senior-level capacity. Requirements: Expertise in Database Architecture in an environment that handles large volume of data, excess of 500 million of new data records every day. Strong analytical and organizational skills. This job involves analyzing existing databases and the clients needs to develop effective data driven solutions. Demonstrate expertise in performance tuning including both query and server optimization utilizing SQL tools and/or 3rd party solutions. Strong knowledge and experience in data modeling, database design, optimization for performance, SQL, stored procedures. Expertise in understanding complex business needs, analyzing, designing, and developing solutions. Hands-on development experience in SQL Server 2016 or above using SSIS and SSRS. Experience in troubleshooting and resolving data related issues. Excellent oral and written communication skills. Expertise in performance tuning especially tuning complex queries, procedure, and indexing strategies. Monitor and perform tuning on complex ETL jobs using meta-data/variables/parameters. Performance tuning experience using 3rd party tools. Audit/compliance experience in highly regulated environment. Experience using JIRA and Confluence as part of development life cycle. Experience with Business Intelligence tools such as Tableau, SSRS, Power BI. Familiar with Continual Improvement processes. Familiar with Git. Experience: 8 years + relational database and SQL experience Creativity, curiosity, initiative, and self-management are key attributes candidate embodies. Solid experience (4 years +) in coding complex SQL queries and stored procedures. The ability to explain the details of performance tuning internals of the database. Strong understanding of database development methodologies (Source Control, Continual improvement, Release Management, Agile and Scrum) Experience with Continuous Integration Tools (Jenkins, TeamCity, Bamboo) and Test-Driven Development (TDD) a big plus Experience with Red Gate Tools a plus (SQL Source Control, SQL Compare, SQL Data Compare, DLM). Healthcare domain knowledge a big plus. Education: BS or equivalent in engineering or related technical area Masters degree preferred Keywords: business intelligence information technology California |
[email protected] View all |
Fri Oct 06 20:32:00 UTC 2023 |