Senior Database Developer - Remote / Telecommute at Cynet Systems #vacancy #remote

Job Description:

Requirements:

  • Expertise in Database Architecture in an environment that handles large volumes 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.

Skills:

  • 8 years + relational database and SQL experience.
  • Creativity, curiosity, initiative, and self-management are key attributes a 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 is a big plus.

Responsibilities:

  • Design, develop and optimize large, complex DB schemas, SQL scripts and objects to meet application functionality and performance requirements.
  • Working with stakeholders including data, design, product, and executive teams and assisting them with data-related technical issues.
  • Working closely with application developers and business teams at all levels to assist with data-related technical issues and help ensure the successful designing and delivering data driven solutions.
  • 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.
  • Participate in code reviews to validate effectiveness and quality of code.
  • Liaise with developers to improve applications and establish best practices
  • Publish documentation and collaborative information using internal tools.

Education:

  • BS or equivalent in engineering or related technical areas.
  • Masters degree preferred.

Nice to Have:

  • Monitor and perform tuning on complex ETL jobs using meta-data/variables/ parameters.
  • Performance tuning experience using 3rd party tools.
  • udit/compliance experience in a highly regulated environment.
  • Experience using Jira & Confluence as part of the development life cycle.
  • Experience with Business Intelligence tools like Tableau, SSRS, Power BI etc.
  • Familiar with Continual Improvement processes.
  • Familiar with Git.

Code review Agile Tableau Troubleshooting data-integrity Analytical skills optimization SQL Server Integration Services (SSIS) Communication data-modeling SQL Server Reporting Services (SSRS) Performance optimization Self-management version-control Engineering Software Developer Organizational skills Power BI stakeholder-management Business Intelligence (BI) Git Data Analyst CI/CD query-optimization Creativity Confluence Microsoft SQL Server sql-scripts TDD database-design Jira SQL ETL RDBMS Scrum Healthcare industry release-management stored-procedures Initiative

Залишити відповідь