FIND PERSONALIZED JOBS
Sign up to Zippia and discover your career options with your personalized career search.
Sorry, we can't find that. Please try a different city or state.

SQL Server Developer

This job has expired and is no longer available.
APPLY NOW
Apply Now
×
FIND
PERSONALIZED JOBS

Sorry, we can't find that. Please try a different city or state.

CONTENT HAS
BEEN UNLOCKED
Close this window to view unlocked content
or
find interesting jobs in

Log In

Log In to Save

Sign Up to Save

Sign Up to Dismiss

Sign Up

SIGN UP TO UNLOCK CONTENT

or

The email and password you specified are invalid. Please, try again.

Email and password are mandatory

Forgot Password?

Don't have an account? Sign Up

reset password

Enter your email address and we will send you a link to reset your password.

Back to Log In

Log In

Log In to Save

Sign Up to Save

Sign Up to Dismiss

Sign up to save the job and get personalized job recommendations.

Sign up to dismiss the job and get personalized job recommendations.

or

The email and password you specified are invalid. Please, try again.

Email and password are mandatory

Already have an account? Log in

reset password

Enter your email address and we will send you a link to reset your password.

Back to Log In

Company Saved

Answer a few questions and view jobs at that match your preferences.

Where do you want to work?

Job Saved

See your Saved Jobs now

or

find more interesting jobs in

Job Dismissed

Find better matching jobs in

Your search has been saved!

Top 50 SQL Server Developer Skills

Below we've compiled a list of the most important skills for a SQL Server Developer. We ranked the top skills based on the percentage of SQL Server Developer resumes they appeared on. For example, 11.0% of SQL Server Developer resumes contained SQL as a skill. Let's find out what skills a SQL Server Developer actually needs in order to be successful in the workplace.

These are the most important skills for a SQL Server Developer:

1. SQL

demand arrow
high Demand
Here's how SQL is used in SQL Server Developer jobs:
  • Designed and Maintained SSIS Packages for Importing and Exporting Data Migration and Conversion from Legacy Systems to SQL Server 2005.
  • Worked on migrating data, tables, stored procedures and other objects from SQL Server 7.0 to 2000.
  • Experience in Creating Report Templates, Tabular and Matrix reports using SQL Server Reporting Services (SSRS).
  • Installed SQL Server Management tools using SQL Server Setup Program in Development and Production server.
  • Advanced extensible reporting skills using SQL Server 2012 Reporting Services (SSRS).
  • Worked on Migrating the Reports from SQL Server 2012 environment to 2016 environment.
  • Suggested query optimization technique for SQL/PLSQL, to have better response time.
  • Developed SSIS package to load staging tables from Oracle to SQL Server.
  • Created several tables, views and stored procedures using SQL Server.
  • Tested the installation of SQL Server and implemented different security modes.
  • Installed SQL Server Management tools using SQL server setup program.
  • Involved in performance tuning of TSQL queries and Stored Procedures.
  • Created and scheduled jobs using SQL Server Agent and Control-M.
  • Perform quality assurance and testing of SQL server environment.
  • Monitor failed and long running MS SQL Server jobs.
  • Tested successfully all stored procedures on SQL 2000 server.
  • Developed dynamic SQL and dynamic store procedures, views, indexes, CTEs, cursors for performance.
  • Use the SQL Analyzer and Profiler for studying the SQL statements and procedures.
  • Worked on SQL Profiler, Tuning Advisor in SQL 2016 to increase the performance of the reports.
  • Access SQL Server using front end applications like .Net.

Show More

37 SQL Jobs

No jobs at selected location

2. Database

demand arrow
high Demand
Here's how Database is used in SQL Server Developer jobs:
  • Developed physical model database scripts based on logical model.
  • Provide database coding support to application development team.
  • Created constraints and validated database integrity.
  • Configured and monitored database application.
  • Created documentation about the databases.
  • Design database and implement application database objects such as tables, stored procedures, user defined functions, views.
  • Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
  • Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers.
  • Developed SSIS packages to load data from application database and general ledger into Sales data mart.
  • Extracted data from different sources and stored in to SQL Staging tables in BI Staging database.
  • Worked on resolving any dead lock issues with the databases/servers on a real- time basis.
  • Applied security to web server and database server that effects report server installation.
  • Optimized queries by using Execution Plan for better tuning of the database.
  • Developed and optimized database structures, stored procedures, views etc.
  • Monitored several database's using SQL Server Spot light tool.
  • Created SQL indexes for better performance of the databases.
  • Maintain SQL Scripts for changes in database objects.
  • Resolved blocking and locking issues in production databases.
  • Scheduled and monitored all maintenance activities, including database consistency check and index defragmentation.
  • Performed database health checks and tuned the databases using Teradata Manager.

Show More

16 Database Jobs

No jobs at selected location

3. Data Warehouse

demand arrow
high Demand
Here's how Data Warehouse is used in SQL Server Developer jobs:
  • Defined Dimension Models based on existing fact and dimension tables in Relational Data Warehouse.
  • Created SSIS packages to mitigate into the data warehouse database from heterogeneous databases/data sources.
  • Developed SSIS packages for developing a fully-fledged data warehouse solution.
  • Project was to develop a data Warehouse to store the patent information, drug Details, research and sales information.
  • Designed and developed SSIS packages to load data from Flat files, Excel to Data warehouse using C#.NET.
  • Designed a new schema design for the data warehouse using dimensional modeling and developed it using the Erwin tool.
  • Worked with OLTP, OLAP, Data warehouse application, star schema and snowflakes schema dimensions.
  • Applied ETL to implement the Slowly Changing Transformation and maintain historical data in Data Warehouse.
  • Supported OLAP, data warehouse and data marts by using various tools and methodologies.
  • Used Change Data Capture (CDC) to simplify ETL in data warehouse applications.
  • Implemented data warehouse design principles and best practices for maintaining dimension and fact tables.
  • Experience in Data Warehouse Modeling with SQL Server Analysis Service (SSAS).
  • Worked on OLAP Data warehouse, Model, Design, and Implementation.
  • Processed data has been stored in data warehouse for analysis purpose.
  • Involved in building an extensive OLAP data warehouse using SSAS.
  • Used DTS to migrate the tables to the Data Warehouse.
  • Solved the issues associated with ETL Data Warehouse Failure.
  • Designed and implemented ETL processes using the Integration Service tool to populate the data warehouse through the use of staging tables.
  • Worked on development, implementation, administration and support of ETL processes for large-scaleData Warehouses using SSIS and DTS.
  • Designed Data Mart and Data Warehouse using Erwin in Snowflake Schemas.

Show More

4 Data Warehouse Jobs

No jobs at selected location

4. Ssis

demand arrow
high Demand
Here's how Ssis is used in SQL Server Developer jobs:
  • Developed SSIS solutions to enable easy maintenance and easy migration between environments.
  • Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in different environments.
  • Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server and Flat files.
  • Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user groups.
  • Developed complex SSIS packages using proper control flow tasks and data flow transformations as per business requirements.
  • Created packages in SSIS with error handling and worked with different methods of logging in SSIS.
  • Export or Import data from other data sources like flat files using Import/Export through SSIS.
  • Employed condition based notifications to let the user know the status of the SSIS jobs.
  • Worked with SSIS Package migrations from SQL Server 2012 environment to SQL Server 2016 Environment.
  • Developed test scripts and environment of the developed SSIS solutions and the loaded data.
  • Design and develop SSIS packages for data transformations and importing into new database.
  • Developed custom C# scripting for use in building custom functionality in SSIS.
  • Developed several SSIS packages and data flow tasks by using SSIS.
  • Upgraded SSIS packages from previous version to current version and standards.
  • Created different data points and pulling those using SSIS package.
  • Created SSIS packages for data conversion using Data Conversion Transformation.
  • Created SSIS packages for data transformation from flat files.
  • Implemented Event Handlers and Error Handling in SSIS packages.
  • Develop SSIS package for implement Slowly Changing Dimension, Fact Load and Dimension Load with Incremental Lookup.
  • Used various Transformations in SSIS Dataflow, Control Flow using For Loop Containers and Fuzzy Lookups, etc.

Show More

13 Ssis Jobs

No jobs at selected location

5. Ssrs

demand arrow
high Demand
Here's how Ssrs is used in SQL Server Developer jobs:
  • Developed Drill-Down reports according to requirement using SSRS.
  • Created reports in SSRS with different type of properties like chart controls, filters, Interactive Sorting, SQL parameters etc.
  • Generated reports using SSRS that could be used to send information to different Primary Vendors, Clients, and managers.
  • Deployed those reports to the report manager and configured subscription in report manager for scheduling of the reports on SSRS.
  • Developed custom selection of reports ordering using SQL Server Reporting Services (SSRS).
  • Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2012.
  • Used Report Viewer to link and display SSRS reports within an application.
  • Created the reports based on the requirements using SSRS 2012/Crystal Reports XI.
  • Developed several reports in SSRS that summarized package results.
  • Developed stored procedures to generate reports using SSRS.
  • Provided Documentation support on SSRS 2005 as assigned.
  • Provided Full Reporting Life Cycle support using SSRS.
  • Designed and developed Complex Reports using SSRS.
  • Created Tabular and Matrix reports using SSRS.
  • Gathered specifications and developed executive management level productivity and financials level reports in SQL and SSRS.
  • Developed, monitored and deployed SSIS packages Created Tabular Matrix reports, Charts and graphs as per customer requirements Using SSRS.
  • Worked on creating new reports from the scratch for new requirements and modified some of the existing reports using SSRS.
  • Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
  • Worked with report subscriptions in SSRS 2016 to send the weekly run automated reports to end users.
  • Identified and worked with Parameters for parameterized reports in SSRS 2005.

Show More

9 Ssrs Jobs

No jobs at selected location

Job type you want
Full Time
Part Time
Internship
Temporary

6. T-Sql

demand arrow
high Demand
Here's how T-Sql is used in SQL Server Developer jobs:
  • Developed T-SQL Procedures, Functions and Packages and used home-cooked Perl scripts to load data into the SQL Server 2005/2008 database.
  • Created complex Stored Procedures, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
  • Worked with T-SQL developing Stored Procedures, Triggers, Cursors, Tables, User Defined Functions, Views and Indexes.
  • Write T-SQL statements for retrieval of data and Involved in performance tuning of TSQL queries and Stored Procedures.
  • Involved in designing and writing Stored Procedures, functions and packages using T-SQL for SQL Server 2005.
  • Involved in the development of custom stored procedures, functions, triggers, SQL, T-SQL.
  • Used of T-SQL for developing complex Stored Procedures to retrieve clean data according to client requirements.
  • Developed complex programs using T-SQL queries, including Procedures, Triggers, and Functions.
  • Created and optimize complex T-SQL queries and stored procedures to encapsulate reporting logic.
  • Involved in performance tuning and monitoring of both T-SQL and PL/SQL blocks.
  • Created functions, stored procedures, triggers and constraints using T-SQL.
  • Created complex stored procedures to use SSIS packages and T-SQL together.
  • Worked on performance tuning of T-SQL queries and Stored Procedures.
  • Performed T-SQL tuning and optimizing queries for and SSIS packages.
  • Involved in writing T-SQL statements for retrieval of data.
  • Developed complex T-SQL code for the application.
  • Worked on performance tuning of T-SQL scripts.
  • Back end experience in MS SQL Server development, writing T-SQL stored procedures, views, triggers, cursors and UDFs.
  • Worked on writing the T-sql code for the historical data to pull according to the specification requirement.
  • Created reports with Transact-SQL, Aspose Cells and C# in a multi-server environment.

Show More

7. ETL

demand arrow
high Demand
Here's how ETL is used in SQL Server Developer jobs:
  • Coordinated with ETL team for performing land batch process to populate data from external source system to landing tables in hub.
  • Implemented Extraction Transformation and Loading (ETL) process by pulling large volume of data from various data sources using SSIS.
  • Designed the highest level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS 2008.
  • Involved in Design, analysis, Implementation, Testing and support of ETL processes for Stage, ODS and Mart.
  • Design, develop, and maintain Microsoft Integration Services ETL infrastructure for processing of Microsoft Analysis Services OLAP cubes.
  • Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
  • Prepared ETL standards, Naming conventions and wrote ETL flow documentation for Stage, ODS and Mart.
  • Upgraded and modified ETL process from SQL Server 2008 to 2012 including performance upgrade and requirements changes.
  • Looked at the reports and fixed bugs in stored procedures, tables and ETL process.
  • Created a High Level Data Flow Diagram for ETL Design using SSIS as ETL Tool.
  • Utilized sample data to create dashboard while ETL team were cleaning data from source systems.
  • Used ETL to extract files for the external vendors and coordinated that effort.
  • Helped designing the ETL Specifications document and naming conventions for the project.
  • Created Master Package to run different other ETL in one Master package.
  • Used C# and VB Scripts in ETL Packages where ever necessary.
  • Automated sliding window partitioning, partitioning of tables along with ETL.
  • Implemented error handling and roll back process in ETL load.
  • Performed ETL mappings using MS SQL Server Integration Services.
  • Designed the ETL specifications for the data load.
  • Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data..

Show More

1 ETL Jobs

No jobs at selected location

8. Query Analyzer

demand arrow
high Demand
Here's how Query Analyzer is used in SQL Server Developer jobs:
  • Monitored query using query analyzer and tuned queries and procedures to boost database performance.
  • Created and managed schema objects such as Tables, Views, Clusters, Indexes, Procedures and Triggers through query analyzer.
  • Developed and optimized Stored Procedures using input, output, table valued parameters and Query Analyzer.
  • Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
  • Create the necessary indexes to improve the query performance using SQL Server Query Analyzer.
  • Used SQL Server Enterprise Manager and Query Analyzer to administer SQL Server.
  • Well experienced with tools like Query Analyzer, SQL utility.
  • Implemented Performance tuning to optimize SQL queries using query analyzer.
  • Handled database objects with Enterprise Manager and Query Analyzer.
  • Solved T-SQL performance issues using Query Analyzer.
  • Optimized SQL Queries using SQL Query Analyzer.
  • Used query analyzer to optimize queries.
  • Developed highly scalable report automation system utilizing SSIS, T-SQL, stored procedure, cursor, Enterprise Manager, Query Analyzer.
  • Experience in using SQL Server Tools like Import/Export Wizard, SQL Server Enterprise Manager, SQL Profiler and SQL Query Analyzer.
  • NET, VB.NET, Windows Sever 2000/2003/2008, SQL Server Management Studio, SQL Profiler, Query Analyzer, Erwin 7.0
  • Experienced in involving SQL Server performance using index tuning wizards, SQL Profiler and SQL Query Analyzer.
  • Used Query Analyzer, Index Wizard, DB Engine Tuning and SQL Profiler for performance tuning.
  • Used SQL Profiler and Query Analyzer to optimize SSIS package queries and stored procedures.
  • Optimized existing Store Procedure by monitoring through SQL Profiler, and Query Analyzer.
  • time using MS SQL Profiler, index tuning wizard and SQL Query Analyzer in MS SQL Server.

Show More

9. Business Requirements

demand arrow
high Demand
Here's how Business Requirements is used in SQL Server Developer jobs:
  • Involved in analyzing and designing disaster recovery / replication strategies with business managers to meet the business requirements.
  • Gathered functional requirements and Business requirements and written the technical specifications for building the Enterprise Integrated Data warehouse.
  • Gathered business requirements, provided architecture and design for financial module for Medicare Advantage program.
  • Involved in Planning, Defining and Designing database based on business requirements and provided documentation.
  • Worked extensively on Power Pivot and tabular modeling to meet the business requirements.
  • Developed Aggregations, partitions and calculated members for cube as per business requirements.
  • Work closely with management and end-users to create and evaluate business requirements.
  • Convert business requirements into actionable technical requirements for the project.
  • Created Business Requirements, Design, Functional Specifications and Flowcharts.
  • Involved in gathering and analyzing business requirements for reporting purpose.
  • Translated business requirements into BI application designs and solutions.
  • Analyzed existing business requirements in Tableau.
  • Design database models and ER diagrams integrating existing and new tables, based on business requirements and corporate database development standards.
  • Analyzed business and technical processes, and related data to produce the data flows that meet the business requirements.
  • Collected business requirements from users and translated them as technical specs and design docs for development.
  • Created new database table to support new business components according to SGT business requirements.
  • Worked on Power BI Dashboard to make some changes on behalf of Business requirements.
  • Worked with Business Analyst's in gathering the Business requirements.
  • Created Multi-Dimensional cubes using SSAS 2012 based on business requirements.
  • Gathered requirements from business users such as trade approver, and created business requirements document (BRD).

Show More

8 Business Requirements Jobs

No jobs at selected location

10. Ssas

demand arrow
high Demand
Here's how Ssas is used in SQL Server Developer jobs:
  • Created Sales, inventory and finance cubes in SSAS and designed dashboards on cubes to give users valuable information about business.
  • Involved in analyzing, designing, building and testing of OLAP cubes with SSAS and in adding calculations using MDX.
  • Involved in development and implementation of SSIS, SSAS and SSRS application solutions for various business units across the organization.
  • Created and Designed Data Source and Data Source Views Using SQL Server Analysis Services 2008 (SSAS).
  • Developed SSAS cubes with multiple fact measures and multiple dimension hierarchies based on the OLAP reporting needs.
  • Sound Experience and understanding of SSAS, OLAP and OLTP cube, Data mining and Architecture.
  • Configured cell level security in SSAS by creating roles and writing MDX expressions in SSAS.
  • Created calculated members, named sets and scopes to implement business logic in SSAS cube.
  • Designed Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).
  • Worked with installation, configuration and deployment of SSIS, SSAS, and SSRS.
  • Created SSAS storage and partitions, and Aggregations, calculation of queries with MDX.
  • Designed and deployed cubes in SSAS environment, incorporating Dimensional Star Schema Designs.
  • Created cubes and dimensions using MS SQL Server Analysis Services (SSAS).
  • Created partitions, aggregations on measure groups in SSAS for better performance.
  • Identified Key Performance Indicators for Business needs in SSAS 2008.
  • Created Time Dimensions on OLAP Cubes using SSAS.
  • Create Dimensions and cubes through SSAS
  • Experienced with SSRS, SSAS and DBA activities.
  • Designed complex multi-dimensional cubes based on requirements to display detailed information about an advertisement for analyzing its revenue using SSAS.
  • Worked with SSAS to develop Data Marts I worked with clustered SQL Servers in order to maintain a 99.99 uptime system.

Show More

1 Ssas Jobs

No jobs at selected location

11. Drill Down

demand arrow
high Demand
Here's how Drill Down is used in SQL Server Developer jobs:
  • Designed and developed matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.
  • Developed drill down/Tree view report, Drill through reports and sub reports for organizing and efficient display of data.
  • Developed Sub Reports, Matrix Reports, Charts, and Drill down reports, using SQL Server Reporting Services.
  • Generated Tabular reports, Cross Tabs, drill down, Charts, Functions and Maps using SSRS.
  • Created Tabular, Matrix, and Drill down reports for different levels of risk officers and sectors.
  • Defined report layouts including report parameters and wrote queries for drill down reports using SSRS 2008.
  • Worked on motion chart, Bubble chart, Drill down analysis using tableau desktop.
  • Developed Query for generating drill down reports and SQL server reports in SSRS 2005.
  • Experience in creating Drill Through, Drill Down, Tabular & Pivot reports.
  • Developed Queries for generating drill down, drill through reports in SSRS 2008.
  • Assisted in defining Query for generating Drill Down reports in SSRS.
  • Create Ad hoc, Tabular, Chart, Parametric, drill down and matrix reports according to the business requirement.
  • Created and developed queries for Drill Down and AD Hoc Reports using SQL Server 2008 Reporting Services (SSRS).
  • Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports.
  • Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS.
  • Generated Sub-Reports, Drill Down-Reports, Summary Reports, and Parameterized Reports in SSRS.
  • Developed Tabular, drill down, parameterized, cascaded and sub-reports using SSRS.
  • Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.
  • Developed Drill down, Drill through, Matrix Reports, parameterized reports, cascading parameterized Reports using SSRS.
  • Generated Drill down, Drill through, Adhoc, Matrix Reports, parameterized reports using SSRS.

Show More

12. DTS

demand arrow
high Demand
Here's how DTS is used in SQL Server Developer jobs:
  • Converted Data Transformation Services (DTS) application to SQL Server Integrated Services (SSIS) has assigned.
  • Migrated DTS packages to SSIS packages and modified the packages with new features of SQL 2005 SSIS.
  • Converted DTS Package to SSIS package for synchronizes existing process (DTS migrations).
  • Worked with DTS packages to load the massaged data into Data warehousing system.
  • Involved in modifying DTS/SSIS packages, and migrating DTS packages to SSIS packages.
  • Develop DTS script to migrate data from SQL*Server database to Oracle database.
  • Performed Documentation for all kinds of reports, DTS and SSIS packages.
  • Migrated DTS objects to SQL Server Integrated Services (SSIS) environment.
  • Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
  • Developed complex SQL queries, stored procedures, and DTS packages.
  • Migrated DTS packages to SSIS packages and modified those packages.
  • Migrated bulk data using BCP and DTS from flat files.
  • Converted DTS packages to SSIS packages.
  • Transfer data from flat files, Excel spreadsheets to and from SQL Server using DTS, BCP and Bulk Insert.
  • Involved in migration of DTS Packages (2000) to SSIS (2005) and troubleshoot migration issues.
  • Worked on MS SQL Server tasks such as data loading, batch jobs, BCP, DTS.
  • Created DTS packages to copy tables, schemas and views and to extract data from Excel and Oracle using SSIS.
  • Modified store procedure for performance tuning Used DTS packages to do file operation, to apply business rules.
  • Used SQL Profiler and Query Execution Plans to optimize DTS package queries and Stored Procedures.
  • Involved in migration of DTS packages to SSIS Developed SQL overrides in Source Qualifier/Lookup according to business requirements.

Show More

13. Column

demand arrow
high Demand
Here's how Column is used in SQL Server Developer jobs:
  • Performed Data Cleansing and Data Profiling using several transformations like Data Conversion and Derived Column.
  • Maintained referential integrity, domain integrity and column integrity by using the constraints.
  • Used Derived Column transformation to perform various calculations.
  • Created SSIS Package with different transformations such as Derived Column, Slowly Changing Dimension, Data Conversion, Conditional Split etc.
  • Improved performance by adding indexes, removing unnecessary columns in the inner views and adding conditions to get only required data.
  • Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
  • Worked with business users to gather requirements like match columns, system trust scores, data model and table structures.
  • Worked on SSIS Packages, changed Structure of tables and created new Columns during transformation using SSIS packages.
  • Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.
  • Generated Views for specific columns on a table to maintain privacy of a customer data.
  • Used various SSIS tool such as derived columns, aggregate functions, etc.
  • Used various SSIS tasks such as Conditional Split, Derived Column etc.
  • Created Packages to group logically related column types and to transfer data.
  • Created derived columns from the present columns for the given requirements.
  • Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split, Derived column etc.
  • Developed SSIS packages using Lookup Transformations, Merge Joins, Fuzzy Look Ups and Derived Columns with Multiple Data Flow tasks.
  • Applied various transformations like Data Conversion, Multicast, Conditional Split, Derived column in SSIS.
  • Created Grouping, Sorting columns and wrote expressions according to the business requirements.
  • Worked on Incremental Loads using concepts like Checksum and Column to Column compare.
  • Used different transformations lookup, condition split, Derived Column, Data Conversion.

Show More

14. Olap

demand arrow
high Demand
Here's how Olap is used in SQL Server Developer jobs:
  • Supported for the maintenance of OLAP structures using Analysis Services 2005 and reporting structures in MS EXCEL and Reporting Services 2005.
  • Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MSOLAP/ Analysis server (SSAS).
  • Developed OLAP Cubes by using SQL server Analysis (SSAS), worked on Performance tuning of SSAS Cubes.
  • Worked on PROCLARITY to create OLAP data sets and queries are created directly from the Unified Dimensional Model.
  • Developed OLAP cubes using SSAS and calculate the metrics that were revealed in the functional analysis.
  • Designed and developed OLAP Cubes and Dimensions using SQL Server Analysis Services (SSAS).
  • Configured the security roles to the OLAP environment and Optimized the Data warehousing environment.
  • Created Cubes on OLAP environment by using the Unified Dimensional Model (UDM).
  • Created OLAP Cubes using Star and Snowflake Schema using SQL Server Analysis Services 2000.
  • Experience in Developing and Extending OLAP Cubes, Dimensions and data source view.
  • Created SSIS Packages import SAP data from EXCEL files to OLAP Database.
  • Involved in analyzing, designing, building and testing of OLAP cubes.
  • Created OLAP cubes and dimensions for the analysis using SSAS.
  • Analyzed and Designed and developed MOLAP cubes with SSAS.
  • Design OLAP Cubes and Data Mart using SSAS.
  • Developed reports from these OLAP cubes using SSRS.
  • Worked with DTS packages and MSOLAP Services.
  • Created OLAP cubes using Analysis Services.
  • Design and develop OLAP cubes from Multi-dimensional data reporting using SSAS.
  • Calculated slowly changing dimensions and KPIs for different OLAP cubes.

Show More

2 Olap Jobs

No jobs at selected location

15. XML

demand arrow
average Demand
Here's how XML is used in SQL Server Developer jobs:
  • Worked on making on the enterprise-wide use of XML applications, content management systems, taxonomies, and search engine optimization.
  • Created a script task to modify the node values in source XML file and saved them back into source folder.
  • Created mappings to load data extracted from flat files, XML files to staging area using SQL Server SSIS.
  • Created SSIS Packages to import the data from different databases, XML, text files, Excel files.
  • Created SSIS package to check XML file validation and data validation to match the requirements.
  • Used various Package configurations available for SSIS Packages like XML files and SQL Server Tables.
  • Worked on XML Web Services Control Flow task to read from XML Source.
  • Created SSIS packages to transfer XML file data into SQL server database.
  • Created stored procedure to load XML file data into SQL server tables.
  • Created packages to convert flat file to XML file.
  • Worked on EXCEL to XML Conversion using Macros.
  • Programmed database using XML language.
  • Read the XML file, stage the data and load the data into QNXT database.
  • Worked on DTS/SSIS for transferring data from Heterogeneous Database (Access database and xml format data) to SQL Server.
  • Mentored other developers Used XML Web Services using SOAP and Restful services to transfer the data to vendor.
  • Generated reports using SQL Server Reporting Services, and created user friendly templates, indexes, using xml.
  • Analyzed the xml data (XMLA) and transformed to access and SQL server database.
  • Created XML configuration files (.dtsconfig files) to dynamically alter package properties.
  • Created report model for Ad-hoc reporting, generate report in XML format.
  • Configured SSIS Packages with xml configuration for gathering data as a source.

Show More

16. Windows XP

demand arrow
average Demand
Here's how Windows XP is used in SQL Server Developer jobs:
  • Installed MS SQL Server 2000 and Configured MS SQL Server 2000 requirements on Windows XP Professional Edition server.
  • Installed SQL server 2008 on windows XP server, applied service packs and security fixes.
  • Delivered training on Operating System Concepts for Windows XP and Windows 7.
  • NET, MS Excel, DB2, Windows XP.
  • Mentored team members to optimizing SQL queries Environment: VC++, MFC, Sybase 11.1, PL/SQL, Windows XP

Show More

17. Schema

demand arrow
average Demand
Here's how Schema is used in SQL Server Developer jobs:
  • Worked with the technical teams from various business units to set up a schema on how to incorporate newly incoming data.
  • Created and managed schema objects such as tables, views, stored procedures, and triggers and maintained Referential Integrity.
  • Created OLAP models based on dimension and facts for efficient loads of data based on star and snowflake schema structures.
  • Performed changes in the schema of the proposed database as required and informed those changes to the application development team.
  • Created PowerBI Reports using the Tabular SSAS models in PowerBI desktop and published them to PowerBI Service using star schema.
  • Developed physical data models and created DDL scripts to create database schema and database objects.
  • Designed ER diagram, performed the normalization of tables and created the structure of schema.
  • Created partition function, schema and file groups for fact tables.
  • Designed a new schema for the Data Mart databases.
  • Designed Data Warehouse and data mart with snowflake schema.
  • Involved in database Schema design and development.
  • Developed Cube with Star Schema.
  • Design and implement database logical and Physical Schemas.
  • Designed and implemented Data Marts, Facts, Dimensions and OLAP cubes having Star/Snowflake schemas using Dimensional Modeling principles in SSAS.
  • Involved in Dimensional modeling by identifying the fact and dimension tables and design start/snow flake schemas for the SS Analysis services.
  • Involved in building Data Marts and multi-dimensional models like Star Schema and Snowflake Schema.
  • Experience in creating Multidimensional cubes using SSAS and designing DW schemas.
  • Developed logical and physical data models for schemas using Erwin.
  • Developed several STAR schemas for business needs.
  • Created Databases, Schemas, Tables, Views, Indexes.

Show More

6 Schema Jobs

No jobs at selected location

18. Sub Reports

demand arrow
average Demand
Here's how Sub Reports is used in SQL Server Developer jobs:
  • Used sub reports functionality for complex report calculations.
  • Generated, Developed, and Scheduled variety of Reports like List, Matrix, and Chart and Sub Reports etc.
  • Experience in generating reports using linked reports, sub reports and filters in SQL server reporting services.
  • Worked on all types of report types like tables, matrix, charts, sub reports etc.
  • Worked on Sub Reports, Graphing, Data Drill-Down, and Data sorting/grouping, Crystal Report Design.
  • Developed different kind of reports such a Sub Reports, Charts, Matrix reports, Linked reports.
  • Created sub reports in some reports like to get the summary from the detail report data.
  • Developed Complex SSRS Reports involving Sub Reports (Matrix/Tabular Reports, Charts and Graphs).
  • Created Tabular reports, matrix reports, List reports and sub reports in SSRS.
  • Created Summary Reports, sub reports and detailed reports.
  • Created reports that call Sub reports in SSRS.
  • Included sub reports into parent report.
  • Developed Ad-Hoc reports, sub reports, drill down reports, parameterized reports and dirty reports.
  • Worked on designing reports using SSRS 2012 mainly Parameterized reports and Sub reports.
  • Generated parameterized reports, sub reports, tabular reports using SSRS 2008R2.
  • Created linked, unlinked and on-demand sub Reports.
  • Created sub reports and crosstab reports.
  • Created different type of reports including Cross-tab, Conditional, Drilldown, Sub reports also parameterized reports.
  • Created datasets using stored procedures and reports using multi value parameters Created sub reports, bar charts and matrix reports.
  • Experience in creating Tablix Reports, Matrix Reports, Parameterized Reports, Sub reports using Sql Server Reporting Services 2014.

Show More

19. Constraints

demand arrow
average Demand
Here's how Constraints is used in SQL Server Developer jobs:
  • Modified existing database by adding tables and establishing the relationships using constraints.
  • Defined relationship between tables and enforced the referential integrity constraints.
  • Created Stored Procedures, Triggers, User defined Functions, Constraints etc on various database objects to obtain the required results.
  • Created several SQL scripts in order to have required check constraints, Indexes, and Views as per existing Business Rules.
  • Experience in Error and Event Handling using Precedence Constraints, Break Points, Check Points, and Logging using SSIS 2008.
  • Used SQL Server System Catalog to find Stored Procedures, UDF, Triggers, indexes and constraints on existing databases.
  • Involved in creating the constraints, rules, defaults and triggers to maintain the data and referential integrity.
  • Involved in creating Databases, Tables, Views, Cluster/Non-Cluster Index, Unique/Check Constraints, Rules and Defaults.
  • Implemented Functions, views, triggers and stored procedures and enforced business rules via checks and constraints.
  • Involved in developing database objects such as procedures, triggers, constraints, indexes and views.
  • Organized Error and Event Handling by giving Precedence Constraints, Break Points, Logging.
  • Created tables, indexes, constraints, triggers and stored procedures.
  • Defined Check Constraints, Business Rules, Indexes, and Views.
  • Implemented different types of constraints on tables for resource Management.
  • Used indexes, constraints & business rules wherever applicable.
  • Created indexes, constraints and rules on database objects.
  • Implemented constraints on tables using some basic requirement.
  • Implemented different types of constraints on tables.
  • Created Tables, indexes and constraints.
  • Designed Tables, Constraints, Views, and Indexes etc.

Show More

1 Constraints Jobs

No jobs at selected location

20. Oltp

demand arrow
average Demand
Here's how Oltp is used in SQL Server Developer jobs:
  • Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
  • Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data warehouse.
  • Extracted and reviewed data from heterogeneous sources from OLTP to OLAP using MS SQL Server Integration Services (SSIS).
  • Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system.
  • Created SSIS packages to load data from the OLTP system to a Data mart for analyzing data.
  • Designed and developed SSIS package for loading data from OLTP to OLAP using the Integration Service tool.
  • Developed SQL scripts to insert, update and delete data in MSSQL database tables in OLTP environment.
  • Designed high level ETL architecture for overall data transfer from the OLTP to OLAP using SSIS.
  • Identified data source and data views for building the OLAP and OLTP cube in SSAS.
  • Involved in transformation of OLTP data to the Data Warehouse using DTS and SQL commands.
  • Created SSIS package to transfer data between OLTP and OLAP databases using Incremental Load.
  • Scheduled the packages to keep extracting the data from OLTP at specific time intervals.
  • Created packages and scheduled them in SQL Agent jobs to get data from OLTP.
  • Generated reports using SQL Server Reporting Services 2005/2008 from OLTP and OLAP data sources.
  • Developed and deployed SSIS packages to load data from OLTP to Data Warehouse system.
  • Analyzed the database schema structure of the OLTP database and designed ETL processes.
  • Experience in creating reports using SSRS and worked on OLAP/OLTP environment.
  • Involved in extracting the data using SSIS from OLTP to OLAP.
  • Constructed OLTP and OLAP Databases.
  • Created ETL process for overall data transfer from the OLTP to OLAP with the help of SSIS.

Show More

2 Oltp Jobs

No jobs at selected location

21. Backup

demand arrow
average Demand
Here's how Backup is used in SQL Server Developer jobs:
  • Designed and implemented comprehensive Backup plan and disaster recovery strategies to ensure high availability of data.
  • Provided analysis and recommendations for setting up a comprehensive Backup and Recovery Strategy for SQL Servers.
  • Provided support for database backup/restore and database transfer activity from test environment to production environment.
  • Developed system maintenance tasks such as Database Backup and Recovery, Database mirroring and replication.
  • Automated and enhanced daily administrative tasks including database backup and recovery.
  • Experienced with updating database statistics, re-indexing and data backups.
  • Performed daily database backup & restoration of Database Server.
  • Performed daily backup of entire database and recovery.
  • Evaluated database performance and maintenance duties such as Backup, Restoration are performed by scheduling jobs using SQL Server Job Agent.
  • Involved in setting up SQL Server Agent Jobs for periodic Backups with backup devices, database maintenance plans and recovery.
  • Performed DBA tasks like Backup, Restore of tables and Stored Procedures and Refreshing Database on weekly basis.
  • Created daily database backup and recovery procedures for Development, WTC (TESTING) and Production environments.
  • Perform daily database backup & restoration and monitor the performance of Database Server.
  • Implemented a well-planned backup and restore strategy that protects databases against data loss.
  • Developed backup restore scripts for SQL Server as needed.
  • Scheduled automated daily, weekly and monthly system maintenance tasks such as database Full/Differential/Transactional log backups and updating the statistics.
  • Worked on SQL Server tools Like Enterprise Manager and SQL Query Analyzer Managing the backup and restores.
  • Involved in taking the backup and make backup plans using file group, differential and transactional backup.
  • Worked on administration tasks like backup (Full/ Differential/ Transactional) & recovery.
  • Implemented several backup and recovery plans, developed Log Shipping and SQL Server replication processes for company databases.

Show More

1 Backup Jobs

No jobs at selected location

22. C #

demand arrow
average Demand
Here's how C # is used in SQL Server Developer jobs:
  • Created SSIS packages using Conditional Split, Data Conversion, and Fuzzy Logic and C #.
  • Used C #scripts to auto generate sequential value using script transformation in Data flow task.
  • Used C # and VB in SSIS to design customized tasks.

Show More

23. Bulk Insert

demand arrow
average Demand
Here's how Bulk Insert is used in SQL Server Developer jobs:
  • Extracted data from various heterogeneous sources and created packages using SSIS, Import/ Export Data, Bulk Insert and BCP utilities.
  • Used various control flow tasks like FTP, Bulk insert task, Transfer job task etc and different data flow tasks.
  • Moved the static data from various text files to SQL Server 2014 database using BCP Import and Export, Bulk Insert.
  • Used Bulk Copy Program (BCP) and Bulk Insert for data push from different source to Staging Database.
  • Used Send Mail, Bulk Insert, Execute SQL, Data Flow, Import Export control extensively in SSIS.
  • Worked with different control flow items like Execute Package, Execute SQL, Send mail and Bulk Insert tasks.
  • Performed tasks such as execute SQL task, bulk insert task, data flow task for ETL process.
  • Worked on Data transfer from a Text file to SQL Server by using bulk insert task in SSIS.
  • Created several stored procedures to do bulk insertion, ftp of data/files from mainframe/host systems to SQL server.
  • Used Bulk Insert to load large amounts of data from Excel into one single database table.
  • Used Bulk Insert Task in SSIS to load large amounts of data to SQL Server.
  • Used SSIS packages, DTS, and bulk inserts for importing and exporting of data.
  • Created Data Transformation tasks like BULK INSERT and used Import/Export Wizard to import/export data.
  • Used BCP and Bulk Insert for faster transferring large data between various environments.
  • Used bulk insert in SSIS and SSMS for faster transfer of data.
  • Transformed data using DTS packages, BCP utility and Bulk Insert statement.
  • Import data across multiple instances using BULK INSERT and BCP Utility.
  • Used Bulk Insert to copy large amount of data into database.
  • Used Bulk insert to load huge tables.
  • Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.Used Bulk insert to load huge tables.

Show More

24. Wizard

demand arrow
average Demand
Here's how Wizard is used in SQL Server Developer jobs:
  • Configured SSIS packages using Package configuration wizard to allow package run on different environments.
  • Deployed SSIS packages to MSDB database and file system using manifest file and the wizard utility in SQL Server 2008.
  • Performed Index analysis for tables to use Clustered and Non-Clustered Indexes for significant performance boost using Index Tuning Wizard.
  • Migrated DTS packages using DTS editor wizard in SSIS, validated and tested all packages on development server.
  • Created Dimensions with the cube wizard and also individually and Generated Named calculations and name queries.
  • Reduced the Query Execution time by Monitoring and Tuning Indexes using Index Tuning wizard.
  • Worked on extracting, transforming and loading data using SSIS Import/Export Wizard.
  • Optimized stored procedures and indexed query using Index Tuning Wizard.
  • Scheduled the subscription reports with the subscription report wizard.
  • Created copies of operational Databases using the Import/Export Wizard.
  • Used Index tuning wizard for tuning of indexes.
  • Secured and Configured SSIS packages for deployment to production using Package Configurations and Deployment Wizard.
  • Diagnosed and tuning the server optimal performance using SQL server 2005, Dynamic management views, Profiler and Index Tuning Wizards.
  • Worked with Deploying the SSIS packages using SQLServer package deployment wizard to deploy the packages on the production server.
  • Scheduled full and transactional log database backups in the production environment using the database maintenance plan wizard.
  • Performed data consistency and performance tuning effectively with SQL Profiler, Index Tuning Wizard.
  • Used Profiler, Index Wizard and Performance Monitor for performance tuning on SQL Server.
  • Identified and resolved the query performance using SQL Profiler and Index tuning wizard.
  • Used Index Tuning Wizard, SQL Profiler and SQL trace for Performance Tuning.
  • Conducted performance tuning by using SQL Profiler and index tuning wizard.

Show More

25. Fuzzy Lookup

demand arrow
average Demand
Here's how Fuzzy Lookup is used in SQL Server Developer jobs:
  • Created SSIS packages by using advanced transformations like Fuzzy Lookup, Derived Columns, Conditional Split, Term Extraction and Aggregation.
  • Worked extensively on bad data with configuring the error output, Conditional split, derived column, fuzzy lookup transformation.
  • Generated different SSIS packages using transformation such as fuzzy lookup, derived column to perform different design.
  • Developed SSIS Packages using fuzzy lookup transformation, file system task, for each loop container.
  • Created SSIS packages using various data transformations like fuzzy lookup, derived column transformation etc.
  • Worked on data cleansing techniques using look ups, conditional split and fuzzy lookup.
  • Created SSIS packages using Fuzzy Lookup and Fuzzy Grouping for data cleansing purpose.
  • Fine-tuned long-running Microsoft fuzzy-lookup SSIS packages, redesigned slow-performing fuzzy lookups to speed processing of 30 million entities.
  • Created several SSIS packages using advanced transforms, lookups, fuzzy lookups, and script components(c#).
  • Developed SSIS Packages for cleaning and scrubbing of data using Lookup and Fuzzy Lookup transformations to validate the data.
  • Used various SSIS transformations such as Conditional Split, Derived Column, Fuzzy Lookup, Multicast, etc.
  • Filter bad data from legacy system using Derived column, Lookups, Fuzzy Lookups and Conditional split.
  • Implemented the Data Cleansing using various transformations such as Lookup, Fuzzy Lookup and Derived Column.
  • Used transformation like Merge Join, Pivot, lookup, Fuzzy lookup and slowly changing Dimension.
  • Utilized several Transformations like Lookup, Fuzzy Lookup for implementing Transformation logic in the Packages.
  • Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy Lookups, Lookups.
  • Used various transformations in SSIS like multicast, fuzzy lookup, copy column.
  • Created SSIS Package for Deduping Process for removing duplicate data using Fuzzy Lookup.
  • Used lookup tables and fuzzy lookup tables to store the data correctly.
  • pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate).

Show More

26. Ad-Hoc

demand arrow
average Demand
Here's how Ad-Hoc is used in SQL Server Developer jobs:
  • Created Ad-Hoc reports by building models in Report Builder using SQL 2005 Model Designer and Report Builder.
  • Involved in Creating Complex ad-hoc Reports, Sub Reports, Linked Reports, Charts, Drill through and Drill down Reports.
  • Applied conditional formatting in SSRS to highlight key areas in the report data Used Report Builder to do Ad-hoc Reporting.
  • Experience in creating Ad-hoc reports, data driven subscription reports by using Server Reporting Services (SSRS).
  • Experience in creating Ad-hoc and static reports using SSRS (SQL Server Reporting Services) from BIDS.
  • Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder.
  • Experience in creating ad-hoc reports Using Report Builder 1.0 and Report Builder 2.0.
  • Deployed reports in to Report Manager &Created Ad-Hoc reports using Report Builder.
  • Created AD-Hoc reports using Report Builder and maintained Report Manager for SSRS.
  • Created packages in SSIS to import data from production for Ad-hoc reporting.
  • Developed numerous ad-hoc reports using SSRS for day to day financial reporting.
  • Created Linked reports, Ad-hoc reports and etc based on the requirement.
  • Created ad-hoc reports, drill down and drill through reports using SSRS.
  • Created Ad-hoc reports using Report builder 2.0/3.0 in SQL SERVER 2005/2008/2008R2.
  • Cleared back-log of User requests by developing ad-hoc SQL Server procedures.
  • Created additional ad-hoc reports using MS Access for Operations Director.
  • Generated ad-hoc reports using MS Reporting services and Crystal reports.
  • Generated ad-hoc reports using MS-Excel and Crystal Reports.
  • Used Report Builder for Ad-hoc reporting.
  • Provided Ad-hoc queries and Reports for Companywide users pulling data from Multi-terabyte data warehousing systems.

Show More

27. MDX

demand arrow
average Demand
Here's how MDX is used in SQL Server Developer jobs:
  • Calculated measures and dimension members using MDX, mathematical formulas and user defined functions.
  • Created sophisticated calculated members using MDX queries; designed and created aggregations to speed up queries and improve performance in SSAS.
  • Created calculated fields with MDX code to meet additional measures needs that are calculated from existing measures.
  • Designed custom MDX queries as desired by the end users to make the reports simpler.
  • Defined Calculated members, named sets, and executed other script commands using MDX expressions.
  • Created MDX expressions/queries for accessing cubes; involved in query structuring and performance optimization.
  • Used MDX to extract cube data and created pivot tables for revenue analysis.
  • Worked on creating calculated measures that fits business logic, using MDX queries.
  • Involved in the design and development of the SSAS cubes and MDX queries.
  • Created Static Reports using MDX queries and created MDX Base Report Definition.
  • Designed and created MDX queries to retrieve data from cubes using SSIS.
  • Created reports by dragging data from cube and wrote MDX scripts.
  • Created reports by retrieving the data from cube using MDX reports.
  • Created MDX queries to extract data from the Data Mart.
  • Create Calculate member in MOLAP cube using MDX in SSAS.
  • Created MDX script for representing Cube Calculation using SSAS.
  • Used MDX (Multi-dimensional Expressions) for the calculated members and the KPI (Key Performance Indicators).
  • Developed MDX Queries in order to perform drilldown reports and for calculating measures and dimensions.
  • Calculated measures and dimension members using multi-dimensional expression (MDX).
  • Used MDX queries for pre calculated measures.

Show More

28. Text

demand arrow
average Demand
Here's how Text is used in SQL Server Developer jobs:
  • Created SSIS packages to load the data from Text File to staging server and then from staging server to Data warehouse.
  • Designed and modified SSIS packages to import and export data from MS Excel, Delimited text files and Flat files.
  • Migrated data from text files and Excel spreadsheets to SQL Server databases using Integration Services (SSIS).
  • Imported and Exported data from text files and excel spreadsheets into SQL Server 2008 database using SSIS package.
  • Imported data from text files and excel spread sheets into SQL Server 2012 database using SSIS package.
  • Managed to Import and export the data from text files to tables using functions and stored procedures.
  • Installed and Configured SQL Server 2000 on development server for designing and testing full text search.
  • Create SSIS packages for data integration from SQL Server data source into required text files.
  • Created DTS package to export and import data from SQL Server to text files.
  • Created SSIS Packages to integrate data coming from Text files and Excel files.
  • Created SSIS packages to Export data from text file to SQL Server Database.
  • Designed a universe using alias and contexts as per the report requirement.
  • Used Text Files/ SQL Server Logging for all SSIS packages.
  • Resolved loops using contexts, aliases and integrity check.
  • Used SSIS to transform data into SQL database via FTP from Text files, MS Excel as source.
  • Documented ETL processes for existing applications in Viso and text to provide quick method for identifying data dependencies and troubleshooting.
  • Used expressions extensively for hiding textboxes, display labels and hiding charts, matrix and tabular depending on certain conditions.
  • Imported data from text files/excel spread sheets, Informix Database into SQL Server 2005/2008 database using SSIS package.
  • Used Sed/AWK to generate reports from UNIX text files.
  • Performed DTS for data transfer from Oracle, Teradata, FTP, MS Excel and text file to SQL Server 2008.

Show More

29. Management Studio

demand arrow
average Demand
Here's how Management Studio is used in SQL Server Developer jobs:
  • Scheduled package execution using SQL Server Management Studio to execute packages on a daily/weekly basis.
  • Created SSIS Jobs and scheduled Packages using SQL Server Management Studio for the Daily/Weekly/Monthly Load as per different Time Zone.
  • Scheduled and monitored SQL Server Agent Jobs to run various SSIS packages in SQL Management Studio to automate manual tasks.
  • Created indexes on selective columns of patient records for the faster retrieval of data in SQL Server Management Studio.
  • Create Store Procedure using T-SQL to evaluate result for the reports to implement using Management studio.
  • Created automated backup of OLAP cubes as well as normal backup using SQL server management studio.
  • Run several queries using SQL Server Management Studio on a daily basis to build several reports.
  • Created SSIS Jobs and scheduled Packages using SQL Server Management Studio for the Daily Load.
  • Executed complex T-SQL queries using SQL Server Management Studio for back end data validation testing.
  • Create and manage databases across Development and Production instances using SQL Server Management Studio.
  • Integrated data and transformed into operational form with SQL Server Management Studio and SSIS.
  • Developed tables, Views, Stored Procedures and Triggers using SQL Server Management Studio.
  • Created databases using SQL Server Management Studio, Database Wizard and Transact SQL Statements.
  • Worked on Client/Server tools like SQL Server Management Studio to administer SQL Server.
  • Reviewed many T-SQL issues using management studio for better performance.
  • Reviewed many T-SQL issues using management studio for better performance and working on performance tuning for slow running queries using Profiler.
  • Automated daily Database backups, restores and integrity checks using Management Studio and creating or updating indexes using SQL Profiler.
  • Experience in monitoring tools like SQL Management Studio, Enterprise Manager and Query Analyzer, Profiler.
  • Used tools like SQL Server Management Studio, SQL Server Profiler and SQL Server Agent.
  • Developed all the required T-SQl work using MS Management Studio.

Show More

30. Sharepoint

demand arrow
low Demand
Here's how Sharepoint is used in SQL Server Developer jobs:
  • Assist in administration and development of new Microsoft SharePoint 2010 company intranet website.
  • Worked on content management and document management using MS SharePoint.
  • Deployed reports on Microsoft office SharePoint on Development server.
  • Stored technical document in SharePoint.
  • Scheduled the reports to refresh and run on daily, weekly and monthly basis in the report manager and SharePoint.
  • Designed dashboards, including scorecards and reporting with the Dashboard Designer delivered via MOSS (Microsoft Office SharePoint Server).
  • Deployed and uploaded the SSRS reports to SharePoint Server for the end users and involved in enhancements and modifications.
  • Used SharePoint to for documentation and saved all the BRD, Sign off documents and other documents in it.
  • Deployed and maintained reports on SharePoint and created SharePoint Event Handlers to update data based on business request.
  • Integrated reports from SSRS with SharePoint and deployed reports and BI Dashboards to SharePoint.
  • Deployed SSRS reports to SharePoint Server for the end users to look at them.
  • Configured SSRS 2008 with MOSS 2007 for directly deploying the report in SharePoint 2007.
  • Deployed and uploaded the SSRS reports to SharePoint Server for the end.
  • Experience in configuring and deploying SSRS reports onto Microsoft Office SharePoint Server.
  • Involved in deployment of SSRS reports on the SharePoint Portal.
  • Created reports using SSRS with MS SharePoint.
  • Embedded Tableau views into SharePoint.
  • Created several Ad-hoc reports in both SharePoint and Tableau.
  • Deployed reports on Microsoft office sharepoint (Moss).
  • Create and Support packages written .net Support Sharepoint helping out Sharepoint Administrator

Show More

31. Cursors

demand arrow
low Demand
Here's how Cursors is used in SQL Server Developer jobs:
  • Fine-tuned Stored Procedures to improve performance that was achieved by removing unnecessary Cursors and Temporary Tables.
  • Worked in creating complex Stored Procedures, Functions (UDF), Triggers, Cursors, Tables, Indexes and Views.
  • Created stored procedures, scripts, cursors and tested them on the test servers and then moved them to production servers.
  • Managed index statistics, Tables, Views, cursors and optimizing queries by using execution plan for tuning the database.
  • Created database objects like Tables, Indexes, Stored Procedures, Views, User Defined Functions, Cursors and Triggers.
  • Created Stored Procedures, Triggers, Cursors, Tables, and Views and other SQL joins and statements for applications.
  • Involved in creating triggers and cursors to maintain database an audit trail of all records in the database.
  • Created Cursors to facilitate the users to scroll through the Queues to perform manual operations on the payment.
  • Experience working with triggers, intensive stored procedures, cursors, views, indexed views and T-SQL queries.
  • Created Complex Stored Procedure, Triggers, Cursors, Tables, Views and other T-SQL JOIN techniques.
  • Experience in using T-SQL for creating stored procedures, indexes, cursors and functions.
  • Involved in writing T-SQL, stored procedures, views, triggers, cursors.
  • Converted cursors into while loop to make the stored procedure run faster.
  • Created and modified stored procedures, triggers and cursors.
  • Created complex Stored Procedures and Cursors to support applications.
  • Created and modified stored-procedures, triggers, cursors.
  • Involved in writing views, cursors and triggers.
  • Designed stored procedures and cursors.
  • Involved with Transact SQL (T-SQL) Coding, writing queries, cursors, functions, views, & triggers.
  • Created cluster/non-cluster indexes on the tables, create views, cursors, tables, stored procedures and triggers.

Show More

32. Asp.Net

demand arrow
low Demand
Here's how Asp.Net is used in SQL Server Developer jobs:
  • Generated ASP.net objects from tables and presented these DOM objects which are capable for easy communication, to the Business applications.
  • Front end Asp.net using C#, Visual studio as editor and Back end SQL server 2012.
  • Developed reports by using SSRS and deployed them on web pages using ASP.NET using C#.
  • Worked with SSRS Reporting web services in ASP.NET web and Windows forms applications using C#.
  • Developed Web Forms for this application using ASP.NET 3.5 and C# with Visual Studio.NET.
  • Used ASP.NET AJAX to implement the rich client functionality, thereby achieving performance enhanced application.
  • Implemented client side and server side validation using java script and ASP.NET validation control.
  • Integrate SSRS reports with end user ASP.NET MVC web applications using report viewer.
  • Developed data interface layer using ASP.NET and C# for data access.
  • Involved in developing web pages using ASP.NET server controls.
  • Used ASP.NET 3.5 and C# to develop the application.
  • Extended ASP.NET MVC 4 application and used nunit Test Driven Development to test code.
  • Integrated SQL server reporting services with ASP.Net to view generated reports in Crystal reports.
  • Worked with application team and connected SQL Server with ASP.NET webpage.
  • Mentored and trained several team members in ASP.Net and SQL Server
  • Provide debug and maintenance support for Asp.Net 3.5 reporting website.
  • Experience working with ASP.NET as frontend team.
  • Developed screens using ASP.NET, Html, CSS
  • Developed Web Forms using several ASP.Net server controls, validation controls and HTML controls.
  • Design and develop new ASP.Net MVC/JQuery/Telerik application pages to enhance existing in house line of business freight management web application.

Show More

33. Business Logic

demand arrow
low Demand
Here's how Business Logic is used in SQL Server Developer jobs:
  • Created Tableau worksheets of quarterly financial and operational reports, and implemented the business logic by customization.
  • Developed Stored Procedures, functions and database triggers and maintained referential integrity and implemented complex business logic.
  • Developed stored procedures and functions to implement necessary business logic for interface and reports.
  • Gathered user requirements to develop the business logic and analyzed and designed database solutions.
  • Created User Defined Functions to encapsulate frequently and commonly used business logic.
  • Maintained referential integrity and implemented complex business logic.
  • Created User Defined Functions to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible.
  • Converted complex business logic into SQL Stored Procedures and User Defined Functions to achieve functionality required by the UI team.
  • Implemented error handling in TSQL procedures using Try catch and implemented complex business logic in the procedure for better performance.
  • Implemented the complex business logic for MSP 30/60 letters in stored procedures and created SSIS package for calling the procedures.
  • Write stored Procedures, User Defined Functions, Triggers, Views, T-SQL Scripting for complex business logic.
  • Use of Triggers to implement business logic and for auditing changes to critical tables in the database.
  • Used various transformation components in the data flow task (SSIS) to implement business logic.
  • Created triggers, stored procedures and functions using T-SQL to implement the business logic.
  • Write stored procedures and user defined functions to implement complex business logic.
  • Developed triggers and stored procedures to incorporate the business logic and process.
  • Reviewed, implemented and improved of business logic and rules.
  • Created and managed a number of databases on multiple servers Involved in writing SQL stored procedures to enforce business logic.
  • Load text file to staging area, edit columns based on the business logics, created unique identifiers.
  • Created T-SQL scripts using common table expression to apply business logics.

Show More

34. R2

demand arrow
low Demand
Here's how R2 is used in SQL Server Developer jobs:
  • Queried against Heterogeneous Data Sources like SQL Server, Oracle, to retrieve records for data loads using SSIS 2008R2.
  • Experience in designing/generating/using/deploying Visual Studio 2008 R2/2012/2014 Business Intelligence Reports, SQL Server 2008 R2/2012/2014 Reporting Services (SSRS).
  • Installed, configured and deployed various instances of SQL Server 2008 R2 via cloning of a base template VM.
  • Developed and delivered dynamic reporting solutions using MS SQL Server 2008R2 Reporting Services (SSRS).
  • Fixed configuration issues with SSRS 2008 R2 and developed multiple complex SSRS 2008 R2 reports.
  • Created complex reports using SSRS 2005/2008 R2 from the OLAP cubes for end user analysis.
  • Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2008 and 2008R2.
  • Involved in installing and configuration of SQL Server 2008 R2 and Visual Studio 2008.
  • Developed incremental loading using MERGE statement in SQL server 2008 R2.
  • Installed couple of SQL Server 2005/2008 R2 on cluster environment.
  • Involved in installing and maintaining MS SQL Server 2008 R2/2012.
  • Installed SQL Server 2008 R2 in Cluster Environment.
  • Extract Transform Load (ETL) development using SQL Server 2005, SQL 2008R2 Integration Services (SSIS).
  • Administered all SQL Server Instances (SQL 2000, 2005, 2008 & 2008R2).
  • Migrated SSIS packages from SQL Server 2008 R2 to SQL Server 2012 as SSIS packages.
  • Migrated DTS packages from SQL Server 2005 to SQL Server 2008R2 as SSIS Packages.
  • Involved in migrating SQL Server 2005 to 2008 R2.
  • Developed various types of reports like Drill down, Drill through and parameterized reports using SQL Server Reporting Services 2008 R2.
  • Created parameterized, drill down and aggregation reports in MS SQL environment using SSRS 2008R2.
  • Migrate MS Access Database 2000 to SQL Server 2008 R2 Convert MS Access query to TSQL query.

Show More

35. Development Studio

demand arrow
low Demand
Here's how Development Studio is used in SQL Server Developer jobs:
  • Created SSIS packages for new projects utilizing Business Intelligence Development Studio.
  • Developed tabular, matrix and chart reports, using Report Designer as well as Report Builder in Business Intelligent Development Studio.
  • Used SQL server business Intelligence Development Studio to designs SSIS packages to transfer data between servers and deploy the data.
  • Used Business Intelligence Development Studio to build reports using the wizards and designers, and deploy them to Report Server.
  • Migrated data to transfer database objects among servers using different SSIS packages in Business Intelligence Development Studio (BIDS).
  • Developed reports out of the consolidated data warehouse for the business users using MS SQL Server Business Intelligence Development Studio.
  • Worked with data source views, Dimensions, Cubes within Business Intelligence Development Studio (BIDS) using SSAS.
  • Designed, developed and maintained large data sets passed through the MS BI Stack using Business Intelligence Development Studio.
  • Migrated old data from MS Access into SQL Server 2008 using SSIS packages in business intelligence development studio.
  • Reviewed & Tested packages, fixing bugs (if any) using SQL 2008 Business Intelligence Development Studio.
  • Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.
  • Outlined SSIS Packages to trade data from level records to SQL Server using Business Intelligence Development Studio.
  • Used Business Intelligence Development Studio, Management Studio for developing SSIS, SSAS, and SSRS.
  • Maintained versions of Reporting Project Code, (Business Intelligence Development Studio Projects).
  • Involved in Deployment and Administration on SSIS packages with Business Intelligence development studio.
  • Involved in execution and creation of SSIS packages using Business Intelligence Development Studio.
  • Tested Packages and fixed bugs using SQL Server Business Intelligence Development Studio.
  • Involved in developing Cubes in Business Intelligence Development Studio using SSAS.
  • Designed and architected cubes for building reports using SQL Server Business Intelligence Development Studio to support business reporting and forecasting processes.
  • Performed unit testing of reports on QA databases Tested ETL Packages and fixed bugs using SQL 2008 Business Intelligence Development Studio.

Show More

36. TFS

demand arrow
low Demand
Here's how TFS is used in SQL Server Developer jobs:
  • Involved in using Team Foundation Server (TFS) to check in and check out SSRS reports and SSIS packages.
  • Worked on Team Foundation Server (TFS) to work, maintain track of report and also all documentation.
  • Used TFS to get the latest versions of stored procedures and SSIS packages on server and local database.
  • Maintained different branches in TFS as development for release 2 and testing for release 1 were together.
  • Installed and administered Microsoft SQL Server Integration Services, SQL Server Reporting Services, and TFS.
  • Deployed Web Applications and Databases onto Web servers and Database servers using IIS and TFS.
  • Ensured all code and versions are properly maintained in TFS while migration is in progress.
  • Used Team Foundation Server (TFS) for version control, source control and reporting.
  • Developed the WCF Services, Web Service for interaction with TFS-2010 Custom Controls.
  • Build SSIS packages and label them for release in VSS and TFS environments.
  • Experienced working on Tableau Software for designing Dashboards and deploying them onto TFS.
  • Worked in Creating Team projects for Reporting and Integration using TFS.
  • Used Team Foundation Server(TFS) for version control.
  • Used Team Foundation Server (TFS) for Deploying Packages.
  • Experience with using Team Foundation Server (TFS).
  • Used TFS for the version control of BI Solutions.
  • Developed code was managed by TFS Source Control.
  • Checked-in/checked out all the report projects from TFS.
  • Used TFS as the source control repository.
  • Net, XML, SQL* Profiler, TFS, DTS, OLAP, Windows 2008/XP, MS Visio 2010, Crystal Reports

Show More

37. Vb.Net

demand arrow
low Demand
Here's how Vb.Net is used in SQL Server Developer jobs:
  • Coded extensively in VB.NET targeting the Business requirements.
  • Developed and managed dynamic VB.NET web applications.
  • Worked on Visual studio vb.NET to code web methods required to enable smooth process flow according to the client's requirements.
  • Developed scripts to create application for retrieve or insert data while designing the SSIS package using C#, VB.NET.
  • Created Test Harness for the SSRS application to replicate the web service call using VB.NET.
  • Involved in design weatherization application using VB.NET, ASP.NET, Frame work.
  • Worked on conversion of VB.NET code into C# for windows services.
  • Use VB.NET for SSRS for back end to provide accurate report.
  • Designed the User interface in VB.NET.
  • Involved in coding using C#, ASP.NET, VB.NET, ADO.NET, XML, XSL, JavaScript and HTML.
  • Use SSIS script task using vb.net and C# Script to create XML File and Flat File.
  • Used VB.NET in script task in SSIS.
  • Worked with VB.Net components in Visual Studio 2010 for loading data from Text files into SQL server database.
  • Applied Custom auditing ON Error and ON Post execution event using VB.Net script in SSIS.
  • Created custom data flow items for different SSIS packages using the VB.Net script.
  • Used VB.Net, VB Scripts for loading data using SSIS Packages.
  • Used VB.Net Code to create embedded functions in SSRS.
  • Used Script task to write custom code using Vb.net.
  • Implemented VB.Net script and performed testing.
  • Designed and implemented user-interface screens using .Net technologies: ASP.Net, C# and VB.Net.

Show More

38. BCP

demand arrow
low Demand
Here's how BCP is used in SQL Server Developer jobs:
  • Worked with Bulk copy program (BCP) using BCP Utility and loaded large data into staging tables for ETL processing.
  • Export and import of data from text files and Excel to SQL Server database using bulk insert and BCP utility.
  • Involved in heavy PowerShell scripting to perform database true-ups, BCP and moving XML based data across servers.
  • Used BCP utility and Bulk Insert to load data from different data sources to SQL Server.
  • Have used BCP, BULK INSERT to transfer data from and to SQL server database.
  • Migrate the data from different legacy system to SQL Server 2008 using SSIS, BCP.
  • Developed Data Transfers between various servers using BCP and Managing Disk space on NT systems.
  • Created Data Transformation tasks like BCP, BULK INSERT to import/export data from clients.
  • Used Stored Procedures, DTS packages, BCP for updating Servers.
  • Performed various data transfers between various servers using BCP and DTS.
  • Used BCP utility to publish table output to text files.
  • Used BCP/Bulk Insert to publish table output to text files.
  • Performed data transfer (import & export) using BCP.
  • Performed data transfers using BCP and BULK INSERT utilities.
  • Experience with Data migration utilities (Import & Export - BCP, Bulk Insert) from text to SQL Server.
  • Worked on BCP to Import and Export flat files.
  • Involved to work with BCP, Bulk Insert & export utilities within Netezza in order to export & import the data.
  • Used BCP command and TSQL command to bulk copy the data from Text files to SQL Server and vice versa.
  • Used BCP and DTS utility for Meta data transfer across servers.
  • Import and Export), BCP, Transact-SQL, and SQL Server Agent and SQL Server profiler.

Show More

39. Complex Queries

demand arrow
low Demand
Here's how Complex Queries is used in SQL Server Developer jobs:
  • Used complex queries to pull data from excel as well as other databases to the table that has been designed schema.
  • Write Complex Queries, stored procedures, Batch Scripts, Triggers, indexes and Functions using T-SQL for SQL Server 2008R2/2012.
  • Led the development of stored procedures and complex queries, sub-queries and joins as per the business requirements.
  • Created indexes for better performance and tested the data with complex queries, Joins and sub queries.
  • Analyzed and tuned complex Queries/Stored Procedures in SQL Server 2008 for faster execution and developed database structures.
  • Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
  • Created Stored Procedures for commonly used complex queries involving join and union of multiple tables.
  • Created indexed views, and appropriate indexes to reduce the running time for complex queries.
  • Assisted team members in completing their tasks on time and solving complex queries.
  • Write T-SQL scripts, cursors, functions and complex queries / view definitions.
  • Used joins and sub queries to simplify complex queries involving multiple tables.
  • Tested the data with complex queries, joins and sub queries.
  • Developed reports using complex queries and filters as per client requirements.
  • Created and Executed the Stored Procedures and Complex Queries for Reports.
  • Create joins and sub-queries for complex queries involving multiple tables.
  • Worked on complex queries involving CTE's and nested cursors.
  • Used table variables in stored procedures to simplify complex queries.
  • Created complex queries to automate data profiling process needed to define the structure of the pre staging and staging area.
  • Create joins and sub-queries for complex queries involving multiple tables Created User Defined Functions, Stored Procedures, and Triggers.
  • Performed Migration of databases from SQL 2000 to SQL2005 Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables.

Show More

2 Complex Queries Jobs

No jobs at selected location

40. Windows Execution Plan

demand arrow
low Demand

41. CSV

demand arrow
low Demand
Here's how CSV is used in SQL Server Developer jobs:
  • Designed and developed SSIS Packages for loading data from text files, CSV files to SQL Server databases using SSIS.
  • Created SSIS Packages for testing and cleaning the standardized data by using tools in Data Flow Transformations for huge CSV.
  • Designed ETL packages dealing with different data sources (SQL Server, CSV, Flat Files etc.)
  • Created SSIS Packages to export and import data from CSV files, Text files and Excel Spreadsheets.
  • Created SSIS packages to load data from Heterogeneous sources like Flat files, CSV files and Excel.
  • Scheduled and executed SSIS Packages Day to Day included manipulation of XML, CSV files.
  • Create SSIS packages to extract the *CSV files into the database tables.
  • Exported reports from crystal to PDF, Excel and CSV formats.
  • Create ETL packages to move data from feed files (XML, CSV and TXT) to database.
  • Generated reports in PDF, Excel, CSV and XML formats.
  • Designed Console application to generate Single .CSV and text file from Different relational Database table using SSIS and C#.
  • Performed Unit testing * Created SQL jobs which execute the stored procedures and load the data into CSV/Excel files.
  • Used excel sheet, flat files, CSV files to generated Tableau adhoc reports.
  • Created different stored procedure to load data from csv files to the database tables.
  • Imported and exported files to and from csv and excel.
  • Created SSIS packages to create csv files and excel sheets.
  • Worked on flat files, excel files and csv files in the SSIS packages.
  • Designed SSIS Packages to load data from differnt sources like excel, flat file, csv etc.
  • Reconfigured rsreportserver.config for reporting server to disable export formats like CSV, MHTML and PDF.
  • Worked with Qlikview 11.x, SQL Server, Excel, CSV, Qvd, Qvw, Qar files.

Show More

42. Referential Integrity

demand arrow
low Demand
Here's how Referential Integrity is used in SQL Server Developer jobs:
  • Modified existing databases by adding/removing tables there by altering referential integrity, primary key constraints and relationships according to requirements.
  • Coordinated with back-end programmers in optimized stored procedures, implemented referential integrity by using triggers, worked on performance tuning.
  • Analyzed database integrity and developed batch and SQL scripts to resolve database referential integrity errors and bad data.
  • Modified current database by adding tables, altering referential integrity and relationships to support online system.
  • Designed and implemented database triggers and stored procedures to check the referential integrity of database.
  • Created necessary triggers on tables to ensure data and referential integrity incorporating business logic.
  • Defined different keys like primary and foreign keys and implemented referential integrity.
  • Imposed Referential Integrity of data by creating different constraints.
  • Created Triggers to enforce data and referential integrity.
  • Developed, tested and implemented Referential Integrity rules and regulations through constraints, triggers and views in the centralized SQL database.
  • Analyzed and developed the schema objects such as Tables, Views, Indexes, and referential integrity depending on our requirements.
  • Developed, tested and implemented Referential Integrity rules and regulations through constraints, triggers and views, partitioned views.
  • Experience in Data Modeling (Logical and Physical Design of Databases), Normalization and building Referential Integrity Constraints.
  • Created and managed schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements.
  • Maintain referential integrity, domain integrity and column integrity by using the available options such as constraints etc.
  • Identify database entities and attributes, relation among the entities tables and enforced the referential integrity constraints.
  • Created After and Instead of Triggers to enforce data consistency and referential integrity.
  • Created Entity relationship diagrams ER-Diagrams, function relationship diagram, Dataflow Diagrams and enforced all referential integrity constraints.
  • Normalized and de-normalized tables to maintain referential integrity by using Primary and Foreign Keys.
  • Involved in Logical and Physical Data Modeling using tool such as ERWin and maintained Referential Integrity of the databases.

Show More

43. Data Source

demand arrow
low Demand
Here's how Data Source is used in SQL Server Developer jobs:
  • Involved in using SSIS to merge data from heterogeneous data sources like flat files, Excel, Oracle and SQL Server.
  • Developed SQL Server Integration Services (SSIS) packages to transform data from various data sources to MS SQL 2005.
  • Based on required reports, identified various data sources and established the connections using SSRS and constructed data source view.
  • Created the Data source connections, Data Source Views, Relationships, Named Query for customized analysis in SSAS.
  • Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.
  • Transferred data from various data sources/business systems including MS Excel, MS Access, Flat Files etc.
  • Used bulk copy program and bulk insert to load data from diverse data source to SQL Server.
  • Published Work sheets, Data sources in Tableau servers so that End users can use it.
  • Involved in identifying and creating Data Sources and Data Source Views (DSV) in SSAS.
  • Designed and implemented complex SSIS package to migrate data from multiple data sources for data analyzing.
  • Created reports using SSRS from OLTP and OLAP data sources and deployed on report server.
  • Create data mapping of the new fields to existing or new data sources.
  • Migrated Crystal Reports to SSRS manually using Shared Data sources and SQL queries.
  • Created Linked Servers for data retrieval using OLE DB data sources and providers.
  • Created reports with Analysis Services Cube as the data source using SSRS 2008/2012.
  • Worked with shared Data source and shared data sets for multiple reports.
  • Created all the SSRS report using Cube as data source.
  • Implemented complex ETL processes involving diverse data sources and transformations.
  • Created SQL Server Reports using SSRS 2005.Identified the data source and defined them to build the data source views.
  • Created adhoc reports to users in Tableau by connecting various data sources.

Show More

44. VB

demand arrow
low Demand
Here's how VB is used in SQL Server Developer jobs:
  • Involved in developing and modifying VB and XML reports for exporting the reports to web application.
  • Developed several Web controls -- composite and standard web controls -- using VB.NET and C#.
  • Imported and exported data into MS Access databases and Debugged VBA scripts linked to said databases.
  • Work with script component to write codes in VB.NET to implement data initialization settings.
  • Identified and fixed bugs in the VBA modules and macros of the reports.
  • Experienced in using VB.NET to customize specific task by using Script Task.
  • Used VB script in script components for data transformations.
  • Used VB.net to create user define functions in SSRS.
  • Used VB.NET to develop user-defined task.
  • Used VBA for report development.
  • Implement VB scripts, C# scripts in order to do custom coding within SSIS.
  • Worked on VB.NET code in Script task of SQL Server 2005.
  • Experienced with C# and VBA.
  • Reported Access data using the Excel presentation layer Move data between Excel and Access using VBA, ADO and SQL.
  • Worked on the script components in SSIS using VB script for getting latest files and ETL logging areas.
  • Created VB.Net Script for Data Flow and Error Handling using Script component in SSIS.
  • Code deals with highway designT-SQL, SQL-Server 2000, VB.NET.
  • Worked on VB.Net script in SSIS script task.
  • Used Script task to write custom code using Vb.net Experience in ETL Data Warehouse environment.
  • Net, VB.Net, ASP.Net, ADO.Net, Erwin, UNIX, TOAD, Excel, Access, Java, XML

Show More

2 VB Jobs

No jobs at selected location

45. Data Integrity

demand arrow
low Demand
Here's how Data Integrity is used in SQL Server Developer jobs:
  • Implemented various constraints for data integrity like Referential integrity using primary and foreign keys relationships.
  • Implemented SSIS data transformations scripts, created maintenance procedures and provided data integrity strategies.
  • Created Clustered and Non-Clustered indexes for performance improvement and worked on Data Integrity.
  • Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
  • Maintained security and data integrity of the database.
  • Maintained data integrity by developing bug/data fixes.
  • Maintained data integrity by performing validation checks.
  • Involved in maintaining Data consistency and Data Integrity with various constraints like Unique, Check, Primary Key and Default.
  • Applied Unit Testing on reports and dashboards to ensure data integrity as per the business requirements.
  • Tested applications for performance, data integrity, validation issues, job scheduling and alerts.
  • Created and implemented Constraints and Checks on the Database Objects to maintain Data Integrity.
  • Performed Back-End testing to verify the data integrity by passing SQL queries.
  • Tested the data and data integrity among various sources and targets.
  • Created Maintenance plans for the Data Integrity and Backups.
  • Implemented Constraints on tables for maintaining Data Integrity.
  • Used all Declarative Constraints for maintaining Data Integrity.
  • Created checks and constraints to maintain data integrity.
  • Identified slow running query and optimization of stored procedures and tested applications for performance, data integrity using SQL Profiler.
  • Support regulatory reporting and ensure data integrity in report output and timely deliverables.
  • Maintained the physical database by monitoring and optimizing performance, data integrity and SQL queries for maximum efficiency using SQL Profiler.

Show More

46. DDL

demand arrow
low Demand
Here's how DDL is used in SQL Server Developer jobs:
  • Worked with dynamic T-SQL queries, DDL, DML statements for creating objects, making updates and managing user permissions.
  • Create various types of triggers to keep track of DDL events at server and Database level on OLTP server.
  • Used DDL to define indexes (keys), specifies links between tables, and imposes constraints between tables.
  • Developed and optimized data structures, Stored Procedures, Dynamic Management views, DDL Triggers and User-Defined Functions.
  • Analyze stored procedure-based business logic in order to document and propose solutions for migrating to the middle tier.
  • Involved in the development of a normalized database using Data Definition Language (DDL) in T-SQL.
  • Used Microsoft Visual Source Safe to version control and maintain DDL T-SQL files and SSIS packages.
  • Streamlined database design process using creation of table structures in 3NF using DDL statements using T-SQL.
  • Created DDL triggers to prevent accidental table drop and also to restrict access for unauthorized user.
  • Optimized the Oracle PL/SQL queries by Performance Tuning and using DDL created physical data structures.
  • Used C# as one of the middle tier languages in modifying newer features.
  • Implemented many stored procedures using DDL commands (Create, Alter, Drop).
  • Created the DDL script for renaming the legacy tables without actually dropping them.
  • Researched and implemented REDGATE source control on SQL Servers for DDL source control.
  • Generated DDL scripts for database schema and created all other database objects.
  • Performed various DDL changes in order to improve performance of database.
  • Used C# to write all the middle business layer logic.
  • Based on the Data Model generate DDL Scripts for new Database Creation and Data Mapping in ERStudio Data Architect 9.5/9.6/10.0.
  • Involved in preparing and executing SQL code deployments (DDL/DML) with application rollout teams into QA/Production environments.
  • Implemented business rules via stored procedures, middleware, or other technologies.

Show More

47. Global Variables

demand arrow
low Demand
Here's how Global Variables is used in SQL Server Developer jobs:
  • Generated Reports using Global Variables, Expressions and Functions along with concatenating strings based on the requirements by using SSRS.
  • Generated Event Detail Report in SSRS 2008 R2 using Global Variables, Expressions and Functions for the reports.
  • Formatted reports using Global Variables, Expressions and Functions for the reports using T-SQL in SSMS.
  • Generated country wise, region wise reports using global variables, expressions and functions using SSRS.
  • Generated Reports using Global Variables, Expressions and Functions based on the requirements in SSRS 2008.
  • Generated reports using Global Variables, Expressions and Functions using MS SQL Server Reporting Services 2005..
  • Created Drill-down and Drill-through reports using Local and Global Variables, Expressions and Filters in SSRS.
  • Involved in generating and deploying various reports using global variables and functions using SSRS.
  • Performed complex Expressions to create calculated fields and used Global Variables in SSRS 2008.
  • Generated complex SSRS reports using multiple data providers, Global Variables, Expressions.
  • Generated Reports and designed packages using global variables, Expression and functions.
  • Created reports using Global Variables, Expressions and Functions using SSRS 2008.
  • Generated reports using Global Variables, Expressions and Functions using SSRS 2008R2.
  • Generated Reports using Global Variables, Expressions and Functions for the reports.
  • Created local variables and global variables package configurations and error handling.
  • Generated Reports using Global Variables, Expressions based on the requirements.
  • Formatted the reports using the Global variables and expressions.
  • Developed reports using global variables, expressions and functions.
  • Worked on parameters to generate cascaded parameterized reports along with that extensively used global variables, expressions and functions.
  • Worked on parameters to generate cascaded parameterized reports and used global variables, expressions and functions in developing reports.

Show More

48. DB2

demand arrow
low Demand
Here's how DB2 is used in SQL Server Developer jobs:
  • Created SSIS jobs for monitoring the jobs that depend on daily loads and loading DB2 Database Tables using SQL Server Agent.
  • Used SSIS to migrate and transform data from different sources like SQL server, Oracle, DB2 to different destinations.
  • Created SSIS packages for loading Fact Tables, Dimension Tables from Excel, Oracle, and DB2 Databases.
  • Write T-SQL queries and Stored Procedures and Oracle and DB2 queries and use them to build SSIS packages.
  • Developed complex SQL scripts based on the business requirements in DB2, Oracle, SQL Server databases.
  • Web-enabled Management reports were created using Crystal Report attached to both SQL Server 2000, And DB2.
  • Assist in capacity planning, space management and data maintenance activities for database system in DB2.
  • Analyzed the existing DB2 database for different business units and documented them.
  • Perform database enhancement and modification as per the requirements in DB2.
  • Migrated data from DB2 database to SQL Server database using SSIS.
  • Extracted data from oracle, DB2 to load to data warehouse.
  • Moved database objects from DB2 to SQL Server Database.
  • Created the Load packages for loading the CSV files from DB2 into SQL Server using SSIS 2008..
  • Extracted the data from Client Access DB2/AS 400 to SQL Server.
  • Created SSIS Packages to load data from transactional system DB2 to staging (ODS) and staging to Enterprise Data-warehouse.
  • Created monthly reports using reporting wizard with Visual Studio Experienced working on DB2 database for ETL operations.
  • Developed backend SSIS package to transfer data from SQL to DB2 database using WMQ application.
  • Extracted, Integrated data from Sybase, Oracle, and DB2 database to SQL Server.
  • Loaded to the data from flat file/sql server/ db2 to sql server/flat file/excel.
  • Developed Informatics Mappings/Workflows to load domain data from Sybase Database, Flat Files into Db2.

Show More

49. Data Analysis

demand arrow
low Demand
Here's how Data Analysis is used in SQL Server Developer jobs:
  • Designed and created Microsoft Excel spreadsheets to implement mathematical data analysis models and to provide an attractive and functional user interface.
  • Translated the business needs into data analysis, business intelligence data sources and reporting solutions for different types of information consumers.
  • Performed data analysis, logical data modeling, created database objects, applying data normalization techniques and implementing data integrity.
  • Developed user defined financial reports to provide on demand financial data analysis using SSRS.
  • Performed data analysis for automating various customer order reports utilizing SQL Server Reporting Services.
  • Performed data analysis and designed source to destination mapping.
  • Performed data analysis to generate various trend reports.
  • Created cubes with multiple dimensions for data analysis using SSAS 2008 r2 and created queries using MDX to report the findings.
  • Used Data Analysis Expressions (DAX) for data cleaning, data validation and analysis of data in SSAS tabular Model.
  • Used Power BI Power Pivot to develop data analysis prototype, and used Power View and PowerMap to visualize reports.
  • Designed & developed ETL procedures, Data dictionaries, data mappings involving data analysis, data validations and data migrations.
  • Involved in Dimensional Data Modeling (Star Schema, Snow-Flake Schema) Data Architecture, Business and Data Analysis.
  • Conducted Data Analysis and did Data Modeling and Created the ER diagrams using Logical Schema and Star Schema.
  • Performed Data Analysis and Data validation by writing complex SQL queries using SQL against the SQL server database.
  • Scheduled and performed data transfers using DTS including filtering appropriate to the data mart for data analysis.
  • Used MDX to query Analysis Service Databases, debugging and supported the purpose of data analysis.
  • Created various reports using Crystal Reports after performing Data Analysis on the various Views.
  • Performed SQL complex data analysis and created SQL automation process for SSRS reports.
  • Performed Data Analysis for automating various Customers Order Reports utilizing SSRS 2005.
  • Provided data analysis support for Salesforce on downsized SQL data from Salesforce.

Show More

2 Data Analysis Jobs

No jobs at selected location

50. DML

demand arrow
low Demand
Here's how DML is used in SQL Server Developer jobs:
  • Developed T-SQL (DDL-Data Definition Language, DML-Data Manipulation Language) statements using dynamically generated SQL.
  • Involved in designing the physical database models on SQL Server 2005 RDBMS using DML/DDL implementing constraints and triggers for data integrity.
  • Created user profiles and corresponding read, write and DDL and DML access properties were maintained on the database.
  • Developed DML scripts to Insert, Update and Delete data in MSSQL database tables with SQL Server Management Studio.
  • Used DDL and DML for writing triggers, stored procedures to check the data entry and payment verification.
  • Used Data Manipulation Language (DML) to insert and update data, satisfying the referential integrity constraints.
  • Involved in writing heavy T-SQL, complex joins, user defined functions, DDL and DML commands.
  • Used DDL and DML for writing triggers, stored procedures, and data manipulation.
  • Experience in T-SQL Programming using DDL, DML commands for various business applications.
  • Developed T-SQL (DDL, DML) statements using dynamically generated SQL.
  • Implemented Set-based DML statements such as set-based update and delete statements.
  • Worked with DDL, DML, and created implemented stored procedures.
  • Fine-tuned DML, DDL scripts with lock hints for improved performance.
  • Created DML scripts to create database schema and database objects.
  • Created stored procedures, functions, CTE's and DDL & DML triggers.
  • Designed DDL and DML for MS SQL Server 2000.
  • Created DDL/DML triggers in SQL Server 2005/2008.
  • Worked with T-SQL, DDL, DML and DCL Created and executed SQL statements in both SQL production and development environments.
  • Used Imported/Exported Wizard to export EA program data from database DMLArgentumNQR to Excel Sheet for manager to do analysis.
  • Worked with T-SQL, DCL, DDL, DML Scripts and established relationships between tables using Constraints.

Show More

SQL Server Developer Jobs

NO RESULTS

Aw snap, no jobs found.

20 Most Common Skills For A SQL Server Developer

SQL

14.8%

Database

13.6%

Data Warehouse

9.1%

Ssis

7.3%

Ssrs

6.9%

T-Sql

6.5%

ETL

4.9%

Query Analyzer

3.8%

Business Requirements

3.8%

Ssas

3.6%

Drill Down

3.3%

DTS

3.3%

Column

2.9%

Olap

2.7%

XML

2.6%

Windows XP

2.4%

Schema

2.2%

Sub Reports

2.1%

Constraints

2.1%

Oltp

2.0%
Show More

Typical Skill-Sets Required For A SQL Server Developer

Rank Skill
1 SQL 11.0%
2 Database 10.1%
3 Data Warehouse 6.8%
4 Ssis 5.4%
5 Ssrs 5.1%
6 T-Sql 4.9%
7 ETL 3.6%
8 Query Analyzer 2.9%
9 Business Requirements 2.8%
10 Ssas 2.7%
11 Drill Down 2.5%
12 DTS 2.4%
13 Column 2.1%
14 Olap 2.0%
15 XML 1.9%
16 Windows XP 1.8%
17 Schema 1.6%
18 Sub Reports 1.6%
19 Constraints 1.5%
20 Oltp 1.5%
21 Backup 1.5%
22 C # 1.4%
23 Bulk Insert 1.3%
24 Wizard 1.3%
25 Fuzzy Lookup 1.2%
26 Ad-Hoc 1.2%
27 MDX 1.2%
28 Text 1.2%
29 Management Studio 1.2%
30 Sharepoint 0.9%
31 Cursors 0.9%
32 Asp.Net 0.8%
33 Business Logic 0.8%
34 R2 0.8%
35 Development Studio 0.8%
36 TFS 0.7%
37 Vb.Net 0.7%
38 BCP 0.7%
39 Complex Queries 0.7%
40 Windows Execution Plan 0.7%
41 CSV 0.7%
42 Referential Integrity 0.6%
43 Data Source 0.6%
44 VB 0.6%
45 Data Integrity 0.6%
46 DDL 0.5%
47 Global Variables 0.5%
48 DB2 0.5%
49 Data Analysis 0.5%
50 DML 0.5%
{[{skill.rank}]} {[{skill.name}]} {[{skill.percentageDisplay}]}%
Show More

22,378 SQL Server Developer Jobs

Where do you want to work?

To get started, tell us where you'd like to work.
Sorry, we can't find that. Please try a different city or state.