Member Avatar for virgilio

Hi I would like to know what does constitute a Sql Developer,
I want to do the transicion from Data Analyst to Sql Developer; however the descriptions I see online dial with performance and tunning or DW housing.
Can some one explain?
I have 5 year on the field Sql Data manaegment but I want to create now rather than maintain.

  • 2 Contributors
  • 2 Replies
  • 77 Views
  • 4 Days Discussion Span
  • Latest Post Latest Post by virgilio

Dani AI

Generated

A SQL developer builds and ships the data layer that applications and reports depend on. Key responsibilities are designing durable schemas, authoring and testing set-based SQL (stored procedures, views, functions), producing predictable indexing strategies, reading execution plans, controlling transactions and concurrency, hardening access and backup/recovery, and automating deployments and migrations. Development work is more about designing and implementing durable solutions than ad-hoc analysis.

For a practical transition: take a small end-to-end project and own the database side from schema through deployment. Practice writing idempotent DDL, versioning schema objects in source control, creating unit tests for T-SQL logic, and measuring before/after using execution plans and server monitoring. Learn how to reduce contention (locking/isolation), design indexes for typical workloads, and set up simple automated release pipelines for schema changes. Seek code reviews from application developers and aim to replace fragile report-only fixes with reusable objects and parameterized data-access layers.

As noted, the DBMS vendor shapes syntax and tooling; start with portable SQL concepts and add vendor-specific features as needed. For focused learning, review vendor documentation on schema design and on query tuning to understand execution plans and index strategies, and compare those responsibilities to current job listings to see what employers expect (, ).

Recommended Answers

All 2 Replies

Member Avatar for muta

What sql system are you familiar - Ms sql, Oracle or Sybase?

Member Avatar for virgilio

MS Sql. Mostly my background is ETL related SSIS SSRS Data management.
Data Cubes, DW. Currently I'm working for a BI team creating cube views, reports and stuff

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.