What are the responsibilities and job description for the Database Engineer position at Staff Smart Inc?
Must have and nbsp; OLTP . If they have ETL or pipeline analytics they are not a fit. and nbsp;
and nbsp;
OLTP and nbsp;
Schema optimization
Query optimization
SQL Server database Microsoft
SQL Server tooling
SQL cluster setup design management
SQL Server compatibility mode change
Data modeling (Schema with about 650 tables 1000s of attributes)
Job Description
We are searching for a Database Engineer for a healthtech company located in the Sunnyvale area. This is a pivotal role on a fastgrowing team dedicated to transforming patient care. This person will lead efforts in developing and enhancing cuttingedge data management systems working alongside talented engineers and domain experts to create software solutions that empower physicians to focus on fighting cancer. Please note : this role is focusing on OLTP system (transactional) and not ETL (pipeline analytics etc). Candidates who focus on pipeline and analytics will not be considered.
and nbsp;
and nbsp;
and nbsp;
This is a hybrid role with onsite requirements on Tuesday Wednesday and Thursday with work from home on Mondays and Fridays. We are looking for someone who has experience work with large cloud based infrastructures and small start up experience is not preferred.
and nbsp;
and nbsp;
and nbsp;
Requirements of the Database Engineer :
and nbsp;
and nbsp;
- Bachelors degree in Engineering Computer Science or a related field or equivalent practical experience (Masters degree preferred)
- Proven experience in software engineering for deployable software products in both customer sites and cloud environments
- Expertise in data management and database technologies with at least one major cloud provider (e.g. Google Cloud Microsoft Azure Amazon Web Services)
- Extensive experience with SQL Servers : Microsoft database tooling cluster setup design management server compatibility mode change etc and nbsp;
- Extensive experience with schema design changes for Azure schema migration during development delta upgrades
- Proficiency in application code performance improvement by investigating SQL patterns and solution proposal
- Proficiency in managing data systems and databases for onpremises and cloud deployments
- Skilled in using version control tools such as Git
- Knowledge of agile development methodologies and practices
- Strong analytical and problemsolving abilities
- Meticulous attention to detail with excellent task prioritization skills
- Effective communication and teamwork capabilities
- Handson experience with CI / CD pipelines and tools
and nbsp;
and nbsp;
Responsibilities of the Database Engineer :
and nbsp;
and nbsp;
and nbsp;
Occupational Category : 151243 Database Architects
General
Key Skills
Databases,SQL,Database Development,Microsoft SQL Server,Database Design,Performance Tuning,NoSQL,MySQL,Postgresql,Database Administration,MongoDB,Oracle
Experience : years