Job Description :
SM Logics Inc is a leading next-generation IT products, platforms, and services company delivering guaranteed business outcomes, seamless customer experience, actionable insights and IP-led digital transformation. We bring unparalleled knowledge of domains, markets, and technology platforms, to enable our clients realize their business goals.
Title: Sr. Database engineer
Location: Oakland, CA
Duration: Contract
Job Description:
Design and maintain objects in large clinical 2-3 TB SQL Server Databases (tables, views,
procedures, functions etc
Design and code a large number of SQL Queries and stored procedures
Tune complex SQL Server queries, drive to best performance possible.
Implement processes and procedures for the development and release of products/projects
that facilitate high quality and rapid deployment
Provide solutions to promote data integrity in enterprise systems.
Requirements:
Expertise in Database Architecture in an environment that handles large volume of data,
excess of 500 million every day
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
Hands-on development experience in SQL Server 2008 or above using SSIS and SSRS
Experience in trouble shooting and resolving data issues
Nice to have:
Monitor and perform tuning on complex ETL jobs using meta-data/variables/parameters.
Performance tuning experience using 3rd party tools
Audit/development experience in highly regulated environment.
Experience using Jira & Confluence as part of development life cycle
Experience:
8 years + relational database and SQL experience
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
Health care domain knowledge a big plus.
Education
BS or equivalent in engineering or related technical area
Masters degree preferred
BENEFITS
Health, Dental, Vision
SM Logics Inc Inc. is an Equal Opportunity Employer. M/F/Disability/Veterans.
If interested, please send your resumes to or cal
Ashpa,
Technical recruiter.