The SQL Developer is responsible for wide range of tasks, which include: migration of data from legacy systems, data cleansing and normalization, development of stored procedures or use of other architectural approaches to provide reliable and secure mechanisms of data access from web applications and microservices, optimization of data access mechanisms to achieve optimal response times including indexing, capacity planning, development of reports
* Working knowledge of database platforms including MS SQL Server, MySQL or Postgres * Extensive experience creating stored procedures or triggers * Experience executing high volume data migrations including data cleansing, deduplication and change data capture * Ability to identify query performance bottlenecks and resolve them through index creation or other optimization approaches * Experience creating and reading Entity Relationship Diagrams (ERD) * Experience maintaining database objects in source control repository (TFS, SVN, Git) * Proven ability to resolve issues in timely manner * Flexible to respond adequately to changing requirements invalidating the original plans * Capacity to handle multiple tasks and manage competing priorities * Self-motivated with a demonstrated ability to work independently or in a team situation * Creative and takes innovative approaches to problem solving * Strong customer-service mentality and goal oriented * Excellent analytical skills with a high capacity for continuous learning
* Bachelor's degree or related experience * 5-8 years of experience as a database developer using MS SQL Server * 3-5 years of experience designing and building databases to support high volumes of transactions
Essential Functions & Responsibilities:
* Extensive experience creating stored procedures and data migration SQL scripts * Working knowledge of data integration or migration (ETL) tools * Working knowledge of database reporting tools such as MS SQL Reporting Services, Power BI or Cognos * Experience creating and tuning high transaction volume (e-Commerce) solutions * Collaborate directly with business to define and document task requirements
* Familiarity with Continuous Integration and Continuous Delivery concepts : preferred * Prior experience working in an agile development environment: desirable * Familiarity with Big Data concepts and no-SQL databases: desirable * Prior experience with Jira: desirable
Let your dream job find you.
Sign up to start matching with top companies. It’s fast and free.