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.

MS SQL 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 MS SQL Developer Skills

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

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

1. SQL

demand arrow
high Demand
Here's how SQL is used in MS SQL Developer jobs:
  • Created various SQL server objects like stored procedures, functions and views as per the logic to be implemented.
  • Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
  • Used highly complex T-SQL Queries and SQL Scripts to perform efficient data load based on complex Business rules.
  • Experience in Creating and Updating Clustered and Non Clustered Indexes to keep up the SQL Server Performance.
  • Installed and configured MS SQL Server 2005 along with Visual Studio on a network domain system.
  • Created many SQL scripts and jobs to resolve the repeating error from the front end.
  • Designed, developed and deployed reports in MS SQL server environment using SSRS 2005/2008.
  • Created complex Stored Procedures, views, Triggers, Tables and other SQL joins.
  • Worked with T-SQL to create Tables, Views, Triggers and Stored Procedures.
  • Worked with many important SQL jobs and help to monitor and maintained.
  • Performed Unit Testing and Tuned SQL statements using Indexes and Stored Procedures.
  • Implemented Complex Stored Procedures and automated them using SQL Server Agent.
  • Used SQL Server Agent for scheduling jobs and alerts.
  • Developed complex T-SQL code for the application conversions.
  • Created SQL server Reports using SSRS 2008.
  • Used SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
  • Used Index Tuning Wizard, SQL Profiler and SQL trace for Performance Tuning.
  • Experience in building reports in Tableau 8.0 using Sql server data sources.
  • Conducted performance tuning by using SQL Profiler and index tuning wizard.
  • Optimized queries tuned and monitored server performance using SQL Profiler.

Show More

5 SQL Jobs

No jobs at selected location

2. Database

demand arrow
high Demand
Here's how Database is used in MS SQL Developer jobs:
  • Reviewed and developed data models and database designs with development teams.
  • Developed and created logical and physical database architecture using ERWIN.
  • Participated in Databases Architecture and data modeling design.
  • Maintained and enhanced Access medical database.
  • Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
  • Involved in ER diagrams (Physical and Logical using Erwin) and data mapping the data into database objects.
  • Designed complex Lotus Notes database reader to organize and automate any user's massive daily incoming email set.
  • Designed Excel Gross Income Planning and related Access database tools for client's annual planning analysis process.
  • Created database objects like tables, view, store procedures, functions, triggers using SQL server.
  • Maintain and enhance existing commercial appraisers' Access database and reporting system for client.
  • Designed databases from using conceptual, logical and physical modeling using Erwin.
  • Completed and enhanced existing auto leasing database and reporting apps for client.
  • Designed database, tables and views structure for the new data mart.
  • Utilized T-SQL queries to retrieve information from the database based on requirements.
  • Performed Database Refresh tasks from production to Development and Staging Servers.
  • Assigned roles and privileges to different users of the database.
  • Upgraded Database from SQL Server 2000 to 2005 and 2008.
  • Install and Manages Sage Grant Management applications Estimated disk storage requirements for database software, database files & database Administration needs.
  • Developed and created data dictionary, stored procedures, advanced queries, triggers, views, indices and functions for databases.
  • Involved in improving database performance using SQL Profiler, Trace Flags, Execution plan and Index Tuning Wizards.

Show More

3 Database Jobs

No jobs at selected location

3. Data Warehouse

demand arrow
high Demand
Here's how Data Warehouse is used in MS SQL Developer jobs:
  • Gathered functional requirements and Business requirements and written the technical specifications for building the Enterprise Integrated Data warehouse.
  • Participated actively in analysis and discovery phases of data warehouse implementation.
  • Implement, monitor and troubleshoot operational databases and data warehouses.
  • Developed SSIS solution for developing a full-fledged data warehouse solution.
  • Worked closely with end users in designing and creating the Global Enterprise Data warehouse for management group using SSIS and Erwin.
  • Analyzed data quality, by working in conjunction with the data warehouse architect on the development of logical data models.
  • Involved in managing developers, advising other groups in organization on SSIS development, data warehouse development and ETL development.
  • Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse databases.
  • Worked closely with developers, end users in designing and creating the Enterprise Integrated Data warehouse.
  • Developed ETL jobs to load information into Data Warehouse from different relational databases and flat files.
  • Use ETL to implement the slowly changing Transformation, to maintain Historical Data in Data warehouse.
  • Identified the dimension, fact tables and designed the data warehouse using star schema/snowflake schema.
  • Managed the Metadata associated with the ETL processes used to populate the Data Warehouse.
  • Designed a Database and a Data Warehouse for the system using the Star Schema.
  • Performed historical or full load and incremental load data into Enterprise Data Warehouse.
  • Created SSIS package to extract, validate and load data into Data warehouse.
  • Loaded the data from multiple systems to the Reporting Data warehouse database.
  • Involved in data warehouse database design using Star Schema.
  • Solved the issues associated with ETL Data Warehouse Failure.
  • Managed MSSQL data warehouse, Wrote SSIS for ETL tools, SSRS for reports.

Show More

4. Ssrs

demand arrow
high Demand
Here's how Ssrs is used in MS SQL Developer jobs:
  • Developed Financial Reports using SSRS Report Designer.
  • Created reports in SSRS with different type of properties like chart controls, filters, Interactive Sorting, SQL parameters etc.
  • Designed and developed matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.
  • Worked on querying data and creating on-demand reports using Report Builder in SSRS reports and send the reports via email.
  • Generated country wise, region wise reports using global variables, expressions and functions using SSRS.
  • Generated and formatted Reports using Global Variables, Expressions and Functions for the SSRS reports.
  • Developed Various Reports like Charts, Matrix, Tabular, and Cross Tab using SSRS.
  • Applied conditional formatting in SSRS to highlight key areas in the report data.
  • Developed stored procedures, queries and views necessary to support SSRS reports.
  • Created Drill Through and Various Cross tabbed reports using SSRS.
  • Created Report Snapshots to improve the performance of SSRS.
  • Configured and deployed SSRS reports.
  • Consolidate the data load into ODS using SSIS Developed Query for generating Drill Down and Drill Through reports in SSRS 2005.
  • Defined report parameters and wrote queries and procedures for drill down and parameterized reports using SSRS.
  • Experience in writing sub reports and parameterized Queries for generating reports in SSRS 2008.
  • Cash Settlement Reports are developed in SSRS Parameterized reports, Pivot Reports.
  • Developed drill down, drill through, and parameterized reports using SSRS.
  • Generated parameterized reports, sub reports, tabular reports using SSRS-2012.
  • Promoted RDLs to Reporting Service Server (SSRS).
  • Generated parameterized/Drilldown reports to enable/disable the parameters based on user selection in SSRS.

Show More

2 Ssrs Jobs

No jobs at selected location

5. Ssis

demand arrow
high Demand
Here's how Ssis is used in MS SQL Developer jobs:
  • Worked with control flow and data flow tasks like Containers, Precedence Constraints, and Execute SQL task in SSIS.
  • Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
  • Implemented the error threshold using precedence constraints and variables in SSIS packages using business rules as reference.
  • Developed SSIS Packages to handle feedback system on wiring process, which is consumed by PeopleSoft system.
  • Involved in Developing, Monitoring and Deploying SSIS packages and successfully created dynamic configuration packages in SSIS.
  • Created SSIS packages for application that would transfer data among servers and perform other data transformations.
  • Enhanced and deployed the SSIS packages from development server to production server and scheduled jobs.
  • Developed Notification Model, for all SSIS packages to report about SSIS Job status.
  • Worked with SSIS to import, export and transform the data between the servers.
  • Performed Data cleansing by creating tables to eliminate the dirty data using SSIS.
  • Deployed SSRS reports to the reporting server and assisted in troubleshooting deployment problems.
  • Involved in configuration and deployment of SSIS packages in Production and QA servers.
  • Scheduled the same SSIS packages by creating the corresponding job tasks.
  • Deployed the created SSIS packages in Development and Testing environments.
  • Used Event Handlers for Exception Handling in SSIS packages.
  • Develop SSIS package for implement Slowly Changing Dimension.
  • Created packages using SSIS for data extraction from Flat Files, Excel Files OLEDB to SQLServer.
  • Created packages in SSIS with error handling Worked with different methods of logging in SSIS.
  • Used Script task for Data Flow and Error Handling in SSIS.
  • Assisted with various ad hoc query requests.

Show More

3 Ssis 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 MS SQL Developer jobs:
  • Worked with TSQL DDL and DML and generated various T-SQL scripts using Stored Procedures, Views, and Table Variable etc.
  • Used advanced features of T-SQL to design and tune T-SQL to interface the database and other applications in most efficient manner.
  • Worked on performance issues of the T-SQL queries and stored procedures which were early executing for more than 1 hour.
  • Developed complex T-SQL code such as Stored Procedures, functions, triggers, Indexes and views for the application.
  • Build the T-SQL scripts based on SQL Server Coding Standard, rules and templates based on business requirement.
  • Created complex Stored Procedures and Cursors to support applications and Created Distributed Partition views Using T-SQL.
  • Created new database objects like Procedures, Functions, Packages, Indexes, Views using T-SQL.
  • Developed T-SQL queries and stored procedures with multiple parameters to created data sets for reports.
  • Created T-SQL stored procedures, views, functions and triggers in SQL Server.
  • Designed and optimized indexes, views, stored procedures and functions using T-SQL.
  • Designed and developed MS SQL Server Stored Procedures using T-SQL statements from scratch.
  • Involved in performance tuning of the database and T-SQL queries using Explain Plan.
  • Performed T-SQL tuning and optimizing queries for reports that take longer execution time.
  • Enriched in design and optimize T-SQL query to solve specific selection requirements.
  • Created and modified various Stored Procedures used in the application using T-SQL.
  • Involved in developing T-SQL and store procedures to declare report parameters.
  • Generated server side T-SQL scripts for data validation.
  • Worked with T-SQL, DDL, DML and DCL.
  • Improved Performance by creating Clustered and Non clustered Indexes and by Optimizing the T-SQL statements using SQL profiler.
  • Solved T-SQL performance issues using SQL Server profiler.

Show More

7. ETL

demand arrow
high Demand
Here's how ETL is used in MS SQL Developer jobs:
  • Developed ETL process using SSIS with Various Control Flow, Data Flow task and Store Procedures for Work Order Validation process.
  • Performed ETL using SSIS by extracting data from OLTP data sources such as Excel, Access, and Text files.
  • Involved in ETL Architecture, Developing Source to target data mapping (STDM) document defining transformation logic.
  • Created Jobs in SSIS and was responsible for ETL job scheduled to run daily, weekly and monthly.
  • Design of ETL processes to transfer customer related data from MS Access, excel to SQL Server.
  • Followed data standards, resolved data issues, completed unit testing and system documentation for ETL processes.
  • Experience in Scheduling the SSIS packages for automatic process of extract transform and load (ETL).
  • Create SSIS packages for ETL process and also participated in migration from Crystal Reports enterprise to SSRS.
  • Worked with SSIS for creating ETL jobs in migration of data from one database to other.
  • Look at the reports and fixing bugs in stored procedures, tables and ETL process.
  • Developed complex ETL Stored Procedures for data extraction, transformation and loading for applications.
  • Translated business logic to transformation logic to generate pseudo code for the ETL process.
  • Checked the raw data files and compared with requirements to design the ETL.
  • Involved in Performance tuning of ETL transformations, data validations and stored procedures.
  • Involved in ETL Process and developed medium to complex SSIS packages.
  • Reduced the overall ETL time by SQL Query performance Tuning.
  • Performed ETL mappings using MS SQL Server Integration Services.
  • Created high level design of the ETL process.
  • Played role in design of scalable, reusable, and low maintenance ETL templates.
  • Created Hadoop ETL's using Pig Scripting Created Adhoc Reports using Hive from Hadoop Distributed File System.

Show More

8. Business Requirements

demand arrow
high Demand
Here's how Business Requirements is used in MS SQL Developer jobs:
  • Analyzed and designed disaster recovery / replication strategies along with business managers to meet the business requirements.
  • Analyzed the business requirements from the given specifications.
  • Created and reviewed business requirements and functional specifications.
  • Developed database triggers to implement business requirements.
  • Verified business requirements and functional specifications.
  • Created and managed stored procedures, indexes, views, UDF's, Database Constraints to meet business requirements and policies.
  • Created and modified complex stored procedures, complex views and indexes based upon Detail design and Business requirements diagram.
  • Planed and implement strategies of project that would ensure all the business requirements reflect in the project development.
  • Analyzed business requirements and build logical data models that describe all the data and relationships between the data.
  • Schedule and manage daily / weekly / monthly sales and operational reports based on the business requirements.
  • Involved in Planning, Defining and Designing database using Erwin 8.0 on business requirements and provided documentations.
  • Designed, created dimensions/tables and the requisite relationships to meet business requirements based on ER diagram.
  • Work closes with business users to formulate and classified business requirements and rules.
  • Gathered business requirements, definition and design of data source and data flows.
  • Interacted with vendors, developers and customers to manage the business requirements.
  • Experience working with end users to create business requirements.
  • Generated reports using SSRS 2008 as per business requirements.
  • Created reports using SSRS based on business requirements.
  • Set up dynamically configured networks and sub-networks of business requirements Developing data mapping and data requirements documents.
  • Modified existing data model using ERwin Data Modeler as per business requirements.

Show More

9. Windows XP

demand arrow
high Demand

10. Ssas

demand arrow
high Demand
Here's how Ssas is used in MS SQL Developer jobs:
  • Created several cubes in SSAS and build lot of MDX queries to query cubes and to access cube's data.
  • Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
  • Create OLAP cubes with SQL Server Analysis Services (SSAS) based on multidimensional database with star schema.
  • Created named query in SSAS Data Source View to get appropriate hierarchical summarize data for two dimensions.
  • Created 4 OLAP cubes using SSAS to analyze the business condition of the sales.
  • Identified and defined Fact relationships, calculated members while designing OLAP cubes in SSAS.
  • Identified data source and data views for building the OLAP cube in SSAS.
  • Identified and Defined Key Performance Indicators (KPI) in SSAS 2005.
  • Defined measures, dimensions and attributes for building the cube in SSAS.
  • Created perspectives, partitions, and Designed aggregations in cubes using SSAS.
  • Created reports on cubes developed by SSAS developer.
  • Created Cell Level Security in cubes using SSAS.
  • Created DSV, Cubes, and Dimensions, DMX/MDX for SSAS Reports.
  • Involved in Designing Aggregations and pre-calculating the same in SSAS identified the data source and the data source views.
  • Developed Multi-dimensional Objects (Cubes, Dimensions) Using SQL Server Analysis Services (SSAS).
  • Involved in designing OLAP Cubes in SSAS environment using snowflake and Star Schemas.
  • Worked in Data modeling, creating star and snowflake schemas in SSAS.
  • Experience in creating Multidimensional cubes using SSAS and designing DW schemas.
  • Designed various multi-dimensional OLAP cubes using SSAS.
  • Defined dynamic KPIs using SSAS, analytical reports and Scorecard using MDX functions.

Show More

11. Query Analyzer

demand arrow
high Demand
Here's how Query Analyzer is used in MS SQL Developer jobs:
  • Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to administer SQL Server.
  • Solved various T-SQL issues using Query Analyzer.
  • Used Query Analyzer to optimize SQL Queries.
  • Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures.
  • Performed optimization of SSIS packages and SQL queries using SQL profiler and query analyzer.
  • Performed tuning to optimize SQL queries using SQL profiler and query analyzer.

Show More

12. Column

demand arrow
high Demand
Here's how Column is used in MS SQL Developer jobs:
  • Applied various SSIS transformations like look-up, conditional-split, derived column data conversion extensively.
  • Created Database documentation for table and column dictionaries and other reference material.
  • Converted data types using Derived Column, Data Conversion Transformation.
  • Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
  • Designed, Developed and Deployed ETL packages using several transformations such as Derived column, Sort, Merge and Conditional Split.
  • Performed data staging using SSIS data flow tasks, including conditional split, derived column, and slowly changing dimension.
  • Add a feature in the outcome report for forecasting future growth with custom measures and calculated columns utilizing PowerPivot Add-In.
  • Maintained referential integrity, domain integrity and column integrity by using the available options such as constraints etc.
  • Identified columns for primary keys in all the tables at the design time and created them.
  • Created indexes on selective columns to speed up queries and analysis in SQL Server Management Studio.
  • Loaded data to company's Data Warehouse, debugged data type conversion and derived column expression.
  • Added row sum and column sum to tables by grouping and then sorted the data.
  • Created functions for fast inclusion of derived columns on created tables as needed.
  • Created Packages to group logically related column types and to transfer data.
  • Created derived columns from the present columns for the given requirements.
  • Worked on modifying the data type of columns if required.
  • Applied various data transformations like Slowly Changing Dimensions, Aggregate, Sort, Derived column, Multicasting, Conditional Split.
  • Used Merge transform, Derived column transform, Lookup transform with the use of various string functions.
  • Created Jobs that called Stored Procedure that automatically populated tables with Proc Date column.
  • Used SSIS transformations such as lookup, merge, derived column, data conversionand aggregate etc.

Show More

13. Constraints

demand arrow
high Demand
Here's how Constraints is used in MS SQL Developer jobs:
  • Imposed Referential Integrity of data by creating different constraints.
  • Used SQL Server System Catalog to find Stored Procedures, UDF, Triggers, indexes and constraints on existing databases.
  • Increased Data Quality and Consistency of System using various types of constraints, triggers, and default objects.
  • Performed backup/restore, database objects such as tables, procedures, triggers, constraints, indexes and views.
  • Experience in Error and Event Handling, Precedence Constraints, Break Points, Check Points, Logging.
  • Defined check constraints, Indexes and views and also created triggers to enforce data and referential integrity.
  • Created Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers.
  • Created Tables, Indexes, Table Spaces, Views synonyms, and integrity constraints.
  • Created Stored Procedures, Triggers, Indexes, User defined Functions, Constraints etc.
  • Implemented triggers and stored procedures and enforced business rules via checks and constraints.
  • Defined Indexes, Views, Constraints and Triggers to implement business rules.
  • Defined Check constraints, Business Rules, Indexes, and Views.
  • Created functions, stored procedures and constraints using T-SQL.
  • Created Indexes, Constraints and Rules on database objects.
  • Implemented different types of constraints on tables.
  • Created Tables, Indexes and Constraints.
  • Developed, tested and implemented Referential Integrity rules and regulations through constraints and normalization of the transactional database system.
  • Created and maintained databases, tables, users, logins, indexes, check constraints, and business rules using T-SQL.
  • Created variables and expressions to generate dynamic SQL's and to perform desired tasks in control flow usingprecedence constraints.
  • based on logical design models, user requirements and physical constraints.

Show More

14. DTS

demand arrow
high Demand
Here's how DTS is used in MS SQL Developer jobs:
  • Designed new job process, new database maintenance plans, DTS programs and did performance tuning of the existing processes.
  • Migrated data into the Data Warehouse from legacy systems (Flat files, Excel spreadsheets and Access) using DTS.
  • Created DTS package to export and import data from SQL Server to Access database, EXCEL, and text files.
  • Configured Server for sending automatic mails to the respective people when a DTS process failure or success.
  • Used DTS migration wizard to convert DTS to SSIS packages and also developed new SSIS packages.
  • Worked on DTS Package, DTS Import for Transferring data from Oracle and Lotus notes.
  • Transformed data from various data sources using OLE DB connection by creating various DTSX packages.
  • Used DTS to develop jobs to populate the data from source systems to target system.
  • Migrated data from text files and Excel spreadsheets to SQL Server databases using DTS.
  • Designed and developed DTS packages for transferring data from flat files and Access files.
  • Involved in the migration of DTS packages to SSIS packages.
  • Migrated DTS packages to SSIS packages using package migration wizard.
  • Created scheduled jobs to execute DTS and SSIS packages.
  • Created DTS Packages to import data from Excel spreadsheets.
  • Implemented batch processing using Jobs and DTS.
  • Used SSIS to manually transfer DTS packages 2000 to SSIS packages 2008 using MS SSIS 2008.
  • Migrated DTS packages from SQL Server 2000 to SQL Server 2008 as SSIS Packages.
  • Worked on SSIS (DTS, DTSX)packages for Data Integration Services.
  • Modified store procedure for performance tuning Used DTS packages to do file operation, to apply business rules.
  • Created SSIS/DTS packages to copy tables, schemas, views to extract data from Excel, Oracle.

Show More

15. XML

demand arrow
average Demand
Here's how XML is used in MS SQL Developer jobs:
  • Developed meta-data structure and configuration for storing/preserving database connection and security parameters using SQL Server configurations, XML configurations.
  • Experience in using XMLA protocol for SQL Server Analysis Services for interaction between client application and instance of Analysis Services.
  • Used XML task to apply operations on source XML file, merge multiple XML files and save and validate them.
  • Extracted the data from SQL Server and used XML and present it to the end user in XML format.
  • Involved in Debugging and Deploying reports on the production and UAT servers by modifying the RDL files using XML.
  • Used XML skill to store and fetch data using stored procedure from SQL Server 2008 Database.
  • Involved in developing and modifying VB and XML reports for exporting the reports to web application.
  • Created stored procedure using nodes method to load XML file data into SQL server tables.
  • Deployed reports in various sources like Web browser in XML and PDF formats.
  • Loaded XML data into SQL Server database for performing data operations.
  • Extracted data from XML files and inserted the data into database.
  • Created SSRS report on top of SSIS data profiling XML output.
  • Deployed the packages to production using XML package configuration.
  • Copied Facet State to XML file using T-SQL.
  • Deployed cubes using XMLA files in to production.
  • Created SSIS packages to extract data from text files, Oracle, XML to SQL server.
  • Created multiple SSIS Package to extract data from multi Formatted Flat Files, Excel, XML files into SQL Server Database.
  • Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc.)
  • Manage connections dynamically through SQL XML config files in SSIS.
  • Develop SOAPEmail function in MS Access to automate uploading email requests to Web Services via XML Encoding and http protocol.

Show More

1 XML Jobs

No jobs at selected location

16. Management Studio

demand arrow
average Demand
Here's how Management Studio is used in MS SQL Developer jobs:
  • Performed administration and management of Integration Services within SQL Server Management Studio.
  • Implemented the calculations to aggregate physical measures using management studio.
  • Design and normalize databases first, second and third NF, tables, indexes and views in SQL Server management studio.
  • Developed DML scripts to Insert, Update and Delete data in MSSQL database tables with SQL Server Management Studio.
  • Created automated backup of OLAP cubes as well as normal backup using SQL server management studio.
  • Worked extensively with T-SQL, Performance-Tuning, Troubleshooting in SQL Server Management Studio and SQLCMD.
  • Create Jobs and scheduled Packages using SQL Server Management Studio for the Daily Load.
  • Create and manage databases across Development and Production instances using SQL Server Management Studio.
  • Reviewed many T-SQL issues using management studio for better performance.
  • Worked on creating and executing complex T-Sql queries using SQL Server Management studio for back end data validation testing.
  • Created configuration Tables, Stored Procedure, User Defined Function in SQL Server Management Studioto support the whole SSIS process workflow.

Show More

17. Oltp

demand arrow
average Demand
Here's how Oltp is used in MS SQL Developer jobs:
  • Developed SSIS packages to extract data from OLTP to OLAP systems and schedule the same as jobs using SQL Server Agent.
  • Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data warehouse.
  • Created SSIS packages to extract data from OLTP to OLAP systems and scheduled Jobs to call the packages and Stored Procedures.
  • Extracted and reviewed data from heterogeneous sources from OLTP to OLAP using SQL Server Integration Services (SSIS) 2008..
  • Designed ER diagrams and mapped the data into database objects; Involved in normalization of the database in OLTP.
  • Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
  • Created complex SSIS packages using proper control and data flow elements to transfer Data from OLTP to OLAP.
  • Project involved maintenance of existing OLTP databases as well as designing SSIS packages for custom warehousing needs.
  • Developed SQL Scripts to Insert, Update and Delete data in MSSQL Database tables in OLTP Environment.
  • Created reports using SSRS from OLTP and OLAP data sources and deployed on report server.
  • Schedule the packages to keep extracting the data from OLTP at specific time intervals.
  • Created, maintained and updated ETL packages loading both OLTP and OLAP database tables.
  • Provide on call 24 by 7 production support for OLTP and DSS databases.
  • Used SSIS to integrate and map new data into the existing OLTP system.
  • Designed ETL architecture for overall data transfer from OLTP to OLAP using SSIS.
  • Involved in Data Modeling and Database Design of OLTP/OLAP and Dimensional Models.
  • Involved in extracting the data using SSIS from OLTP to OLAP.
  • Created packages for extracting data from OLTP to OLAP.
  • Involved in normalization of the Database in OLTP.
  • Generated reports using SQL Server Reporting Services [ ] from OLTP and OLAP data sources.

Show More

18. Olap

demand arrow
average Demand
Here's how Olap is used in MS SQL Developer jobs:
  • Analyzed OLAP processing for changing and maintaining the Warehouse, Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
  • Created and Configured OLAP Cubes using SQL Server 2012 Analysis Services and Performance tuning and scaling to large numbers of users.
  • Created a MOLAP Cube on SQL Server 2005 Analysis Services as an alternative prototype to an existing relational data mart.
  • Created and Deployed OLAP cubes using fact and dimension tables with star schema using SSAS 2012.
  • Created and Configured OLAP Cubes (Star Schema and Snow flex Schema) using SSAS.
  • Developed fact tables, dimensional tables, cubes for OLAP warehouse using Analysis Services.
  • Defined cubes, dimensions, user hierarchies, aggregations in an OLAP environment.
  • Designed an OLAP with the help of Erwin 7.1.0 to visualize data structure.
  • Created OLAP models based on Dimensions and Facts for efficient loads of data.
  • Deploy SSAS OLAP cubes on development and production server for performance analysis.
  • Trained the End-users to access OLAP Cube using Excel Power Pivot.
  • Set up security and perspective for OLAP cube by using SSAS.
  • Designed OLAP cubes with star schema and multiple partitions using SSAS.
  • Designed and Created report from OLAP Cubes.
  • Worked to build OLAP cubes (Star Schema) using SSAS 2012.
  • Created star schema for OLAP cube generation and extensively worked dimension modeling for analysis service using SSAS..
  • Developed a multi-dimensional database (MDDB) and OLAP cube using SQL Server 2000 that stored and maintained the data.
  • Designed and implemented a logical Online Analytical Processing (OLAP) solution architecture and MS SQL Server 2005 Reporting Services.
  • Studied the existing OLAP system(s) and created facts, dimensions and star schema representation for the Datamart.
  • Loaded transformed data into OLAP system which contains analytical data for creating reports.

Show More

19. Backup

demand arrow
average Demand
Here's how Backup is used in MS SQL Developer jobs:
  • Developed scripts for database maintenance including backup, restore, database consistency checking and index recreation.
  • Developed administrative tasks of SQL Server of performing daily Backups and Recovery procedures.
  • Generated backup and restore operations for migrating database from one server to another.
  • Automated and enhanced daily administrative tasks including database backup and recovery.
  • Maintained daily server backups of databases and ensure successful completion.
  • Developed Backup and Recovery Strategies, and Disaster Recovery Plan.
  • Created a full backup maintenance plan in order to keep integrity of database and control the size of the logs.
  • Performed DBA tasks like Backup, Restore of tables and Stored Procedures and Refreshing Database on weekly basis.
  • Upgraded MS SQL Server 2000 databases to 2005, using detach/attach, backup and recovery and by replication.
  • Trouble shoot Application and Backup jobs failed issues and SQL cluster installation and cluster resources failed issues.
  • Evaluated database performance and performed maintenance duties such as tuning, backup, restoration.
  • Implemented automated jobs for database backup on a daily and weekly basis.
  • Performed DBA roles like backups and created jobs in SQL Server.
  • Scheduled Backups and performed Restore operations for system test data.
  • Monitored backup operations, and schedules manual backups as needed.
  • Developed Backup and Restore scripts for SQL Server 2005.
  • Managed Backup and Disaster Recovery of the systems.
  • Established backup and recovery of SQL server 2005.
  • Set up database backup and recovery strategies.
  • Designed and implemented comprehensive Backup plan and disaster recovery strategies Involved in trouble shooting and fine-tuning of databases for its performance.

Show More

20. Fuzzy Lookup

demand arrow
average Demand
Here's how Fuzzy Lookup is used in MS SQL Developer jobs:
  • Experienced in slowly changing dimension, Data Mining, Pivot, Fuzzy lookup incremental data load packages in SSIS.
  • Worked on data cleansing techniques using look ups, conditional split, and fuzzy lookup.
  • Filtered bad data from legacy system using Derived column, Lookups, Fuzzy Lookups, Conditional split.
  • Implemented the Data Cleansing using various transformations such as Lookup, Fuzzy Lookup and Derived Column.
  • Used various Transformations in SSIS Dataflow, Control flow using for loop Containers and Fuzzy Lookups.

Show More

21. Sub-Reports

demand arrow
average Demand
Here's how Sub-Reports is used in MS SQL Developer jobs:
  • Key role in implementing a standardized process for deployment of reports with multiple sub-reports/ linked reports.
  • Created Drill down, Drill through, Snapshot, Sub-reports using SSRS.
  • Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using MS SSRS for the end user requirements.
  • Generated Sub-Reports, Cross-tab, Conditional, Drill down reports, Drill through reports and Parameterized reports using SSRS2005.
  • Developed Tabular, Cross Tab reports, Charts reports, Parameterized, cascaded and sub-reports using SSRS.
  • Created Cross-Tab, Drill-down, Parameterized and Sub-Reports using SQL Server Reporting Services (SSRS).
  • Generated Sub-reports, Drill down, Drill through and Parameterized reports using SSRS 20005/2008.
  • Developed Tabular, Drill Down, Parameterized, Cascaded and sub-reports using SSRS.
  • Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS.

Show More

22. C # .NET

demand arrow
average Demand

23. Wizard

demand arrow
average Demand
Here's how Wizard is used in MS SQL 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.
  • Used Database Maintenance Wizard to make necessary changes and to keep the performance of the server at acceptable levels.
  • Imported and Exported data from one server to other servers using Import/ Export wizard in SQL Server Management studio.
  • Incorporated the DTS packages into SSIS 2005 by using package migration wizard and executed DTS 2000 Package task.
  • Used various tools to improve SQL Server performance like windows performance monitor and index tuning wizard.
  • Created and modified Clustered and Non Clustered Indexes to optimize the queries using Index Tuning Wizard.
  • Created wizards to import raw State data from Excel, and export forms into Word.
  • Configured the loading of data into slowly changing dimensions using Slowly Changing Dimension wizard.
  • Participated in response for scheduling the subscription reports with the subscription report wizard.
  • Used the MS SQL Server DTS Wizard to schedule migrations and transformations.
  • Optimize indexes using the index tuning wizard and rebuild indexes.
  • Created many SSIS packages using Import/Export Wizard.
  • Identified and worked with parameters for parameterized reports in SSRS 2005/2008 and used SSIS import/export wizard for performing the ETL operation.
  • Used SQL Profiler for gathering the trace activity for the Various Stored procedures and used Index Tuning wizard for performance improvement.
  • Conducted performance tuning of complex SQL queries and stored procedures by using SQL Profiler and index tuning wizard.
  • Worked with Team Lead on T-SQL tuning using MS SQL Profiler and Index tuning wizard.
  • Optimized SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
  • Worked with SQL profiler for tuning wizard.
  • Experienced in SQL Optimizing by using SQL Profiler, Index Tuning Wizard, and Database Tuning Advisor.

Show More

24. Text

demand arrow
average Demand
Here's how Text is used in MS SQL Developer jobs:
  • Generated Tableau Dashboards with filters, quick filters, context filters, global filters, parameters and calculated fields on reports.
  • Worked on Data transfer from a Text file to SQL Server by using bulk insert task in SSIS.
  • Worked DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server.
  • Designed ETL process to load data from different sources like text file, excel or various database.
  • Imported data from text files and excel spread sheets into SQL Server 2005 database using SSIS package.
  • Developed various dashboards, used context filters, sets while dealing with huge volume of data.
  • Transferred data from different files format (Text File, Spread Sheet) to SQL Server.
  • Created SSIS Packages to integrate data coming from Text files and Excel files.
  • Created context filters and used performance actions while handling huge volume of data.
  • Transformed data from various data sources such as Excel and text files.
  • Worked with SSIS packages to load text files to SQL Server.
  • Used Text Files/ SQL Server Logging for all SSIS packages.
  • Created Tables, Joins and Contexts in Universe.
  • Created SSISpackages to Export data from text file to SQL Server Database.

Show More

25. Ad-Hoc

demand arrow
average Demand
Here's how Ad-Hoc is used in MS SQL Developer jobs:
  • Created Ad-Hoc Reporting with Report Builder and Programming Reporting Services.
  • Designed ad-hoc reports using Report Model and configured using Report Manager.
  • Constructed cubes, starting from scratch, using SSAS based on data volumes used in ad-hoc analytic research and Automated Reporting.
  • Maintained and modified reports by using XML for updated web data service and using Report Builder for Ad-hoc reports.
  • Generated reports on wealth information, account information, research reports in ad-hoc reports and sent them to managers.
  • Deployed and Scheduled the Reports in Report Manager using data driven subscription, Ad-hoc report using Report Builder.
  • Developed complex stored procedures using T-SQL to generate Ad-hoc reports within SQL Server Reporting Service (SSRS).
  • Developed database objects providing ad-hoc SQL scripts, stored procedures, Functions, and Triggers using T-SQL.
  • Executed Ad-hoc Analysis for customer reports, executive management reports with MS SQL SSRS using Cube.
  • Developed Various reports involved in Tabular, Matrix, Ad-hoc, Drill down reports using SSRS.
  • Build ad-hoc reports using SQL Server Reporting Services (SSRS), Excel.
  • Created Drill down Reports, Ad-hoc Reports and Drill through reports using SSRS.
  • Created AD-Hoc reports using Report Builder and maintained Report Manager for SSRS.
  • Created stored procedures and SQL statements for generating Ad-hoc Reports in SSRS.
  • Analyze, design, implement and test ad-hoc and standard reports.
  • Designed numerous ad-hoc and custom reports using SQL Reporting Services.
  • Designed ad-hoc and custom reports for high level management.
  • Created Ad-hoc reports, monthly, weekly reports.
  • Generated Drill down, Drill through, Ad-hoc, Matrix Reports, parameterized reports using SSRS.
  • Generated Drilldown, Drill trough Cascaded, Ad-hoc reports using SSRS 2008.

Show More

26. Sharepoint

demand arrow
average Demand
Here's how Sharepoint is used in MS SQL Developer jobs:
  • Deployed reports on Microsoft office SharePoint on Development server.
  • Manage SharePoint Site Collections and Service applications.
  • Created Analytic Grid Report using data source (SSAS) in Performance Point Server (PPS) and integrated with SharePoint.
  • Redesigned/enhanced (1) Price Promotions Calendar tool that imports SharePoint data and (2) a complex forecasting model.
  • Deployed reports both to the SharePoint server, IIS Server, Integrated SharePoint server with Report Server.
  • Administer and use the SharePoint/Dashboard server to deploy MS SSRS reports and create and resolve issues generated.
  • Migrated and resolved conversion errors for Performance Point Server reports to SharePoint 2010 Business Intelligence platform.
  • Created Scorecards and added them to dashboard using Dashboard Designer and deployed the dashboard to SharePoint.
  • Worked on SQL BI solution integration with Microsoft SharePoint Server (MOSS).
  • Provided DBA assistance in SharePoint 2007 to SharePoint 2010 conversion.
  • Deployed SSRS report to SharePoint and Report Server Web Service.
  • Integrated reports and dashboards within SharePoint from various reporting tools.
  • Published dashboards on an intranet site using SharePoint Server.
  • Worked with SharePoint Server 2007 while deploying SSRS reports.
  • Implement Dash reports to MS SharePoint for different departments.
  • Experience in collecting the to do list from SharePoint.
  • Collaborate work by using SharePoint Tested the reports and fixed bugs in the stored procedures.
  • Experienced using Sharepoint to enhance collaboration among the team members.
  • Deployed reports on Microsoft Office Sharepoint (Moss).
  • Created and remediated SSRS reports and publish in SharePoint.

Show More

27. Complex Queries

demand arrow
average Demand
Here's how Complex Queries is used in MS SQL Developer jobs:
  • Designed, developed, and tested stored procedures, views and complex queries for creation of Reports.
  • Created numerous simple to complex queries including self joins and correlated sub queries for diverse business requirements.
  • Created complex queries which involve usage of Joins, Sub-queries, Functions, Temporary tables etc.
  • Created indexed views and appropriate indexes to reduce the running time for complex queries.
  • Created and Executed the Stored Procedures and Complex Queries for Reports.
  • Created Complex Queries for generating drill down reports in SSRS 2010..
  • Utilized SQL scripts and complex queries to analyze and extract data.
  • Have worked on complex queries and stored procedures using T-SQL 2014/2012.
  • Experience in creating joins for complex queries involving multiple tables.
  • Developed Complex Queries using different SQL joins and T-SQL Queries.
  • Created complex queries involving CTE's, Sub-queries and Joins.
  • Create joins and sub-queries for complex queries involving multiple tables.
  • Created complex queries to automate data profiling process needed to define the structure of the pre staging and staging area.
  • Developed complex stored procedures and T-SQL programming which includes Triggers, Views and other complex Queries with best performance.

Show More

28. Ssms

demand arrow
average Demand
Here's how Ssms is used in MS SQL Developer jobs:
  • Created SSISDB catalog with SQL Server 2014/2012 to support SSIS package deployments in SSMS with Environment variables respective to each environment.
  • Filtered data using T-SQL statements, and implemented various types of constraints and triggers for data consistency in SSMS.
  • Created SQL Server Agent jobs to schedule SSIS packages using SQL Server Management Studio (SSMS).
  • Scheduled and maintain packages by daily, weekly and monthly using SQL Server Agent in SSMS.
  • Created SSISDB catalog with SQL Server 2012 to support SSIS package deployments in SSMS.
  • Use SSMS to manage database and reports security.
  • Created database diagrams in SQL SERVER MANAGEMENT STUDIO (SSMS).

Show More

29. Development Studio

demand arrow
average Demand
Here's how Development Studio is used in MS SQL Developer jobs:
  • Developed reports in MS SQL Server environment using MS SSRS-2005 in Business Intelligence Development Studio (BIDS).
  • Migrated old data from MS Access into SQL Server 2008 using SSIS Packages in Business Intelligence Development Studio.

Show More

30. Business Logic

demand arrow
low Demand
Here's how Business Logic is used in MS SQL Developer jobs:
  • Developed Stored Procedures, functions and database triggers and maintained referential integrity and implemented complex business logic.
  • Gathered user requirements to develop the business logic and analyzed and designed database solutions.
  • Developed Stored Procedures and Functions to implement necessary business logic for interface and reports.
  • Created User Defined Functions to encapsulate frequently and commonly used business logic.
  • Developed User-Defined Functions to implement the Custom Business Logic.
  • Created User Defined Functions to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible.
  • Enhanced the business logic using User Defined Functions to retrieve information on the services like Retailers Debit, Credit etc.
  • Implemented complex business logic through T-SQL stored procedures, Functions, Views and advance query concepts.
  • Created new Stored Procedures, functions and database triggers according to the complex business logic.
  • Stored Procedures, User Defined Functions, Views, TSQL Scripting for complex business logic.
  • Participated in design of the application that covers process flow of the business logic.
  • Worked extensively as PL/SQL programmer, Developed PL/SQL Procedures that handle key business logic.
  • Involved in testing and debugging business logic in Store Procedures with Application Development Team.
  • Designed, coded, tested and debugged business logic for software applications.
  • Replicated logic of old crystal report to the new business logic.
  • Developed stored procedures for the implementing complex business logic using T-SQL.
  • Created stored procedures for the business logic using T-SQL.
  • Transformed the complex business logic and calculations into coding.
  • Developed programs using C#.Net, Business Objects and Entity spaces according to the business logic provided by the clients.
  • Created various calculations and Named Datasets to implement business Logics.

Show More

31. MDX

demand arrow
low Demand
Here's how MDX is used in MS SQL Developer jobs:
  • Defined calculating measures and dimension members using multidimensional expression (MDX), mathematical formulas, and user-defined functions.
  • Implemented complex query techniques of passing Multi-Valued parameters and cascading parameters in MDX.
  • Involved to planning and designing SSAS Cubes and building attribute relationships for optimal MDX query performance of Hierarchies and Fact Dimensions.
  • Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS and in adding calculations using MDX.
  • Developed measures and dimension members using multidimensional expression (MDX) to meet additional needs that were calculated from existing measures.
  • Manage and maintain stored procedures and standard reports; build reports from Analysis Services cube using MDX query designer.
  • Created Cubes with Dimensions and Facts and calculating measures and dimension members using Multidimensional expression (MDX).
  • Created Reports from Web Services and used MDX on Cubes in SSAS to create reports in SSRS.
  • Involved in writing MDX queries for cubes and Performance optimization of MDX queries.
  • Created MDX queries to extract data from the data mart.
  • Created reports from complex SQL queries and MDX queries.
  • Created several MDX queries according to Business requirements.
  • Developed cube with SSAS and MDX Queries.
  • Create Calculate member in MOLAP cube using MDX in SSAS 2008.
  • Developed MDX Queries in order to perform drilldown reports and for calculating measures and dimensions.
  • Used Multi-dimensional Expressions (MDX) to create calculated members in the cube.
  • Used MDX (Multi-dimensional Expressions) for the calculated members and the KPI.
  • Developed MDX for cube calculations and KPIs.
  • Created Unix scripting, MDX Scripting , DATA modeling Features Established a sound backup and recovery policies and procedures.
  • Worked on pre-defined facets included by SQL SERVER Created calculated measures and dimension members using multi-dimensional expression (MDX).

Show More

32. Drill-Down

demand arrow
low Demand
Here's how Drill-Down is used in MS SQL Developer jobs:
  • Developed various operational Drill-through and Drill-down reports using SSRS.
  • Developed various reports including matrix report, parameter report, and dashboard with charts, Drill-Trough/Drill-Down function, and KPI/Indicators.
  • Developed various kinds of Tabular, Matrix, Drill-down, Charts and web receiving reports using SSRS.
  • Designed and Developed Drill-through, Drill-down, Cross Tab (Matrix) Reports and Sub-Report using SSRS.
  • Created cross-tab, drill-down, drill-through, linked reports and sub-reports with both SSRS and Tableau.
  • Created different types of reports such as Cross-Tab, Drill-down, Summary reports using SSRS 2008R2/2012.
  • Developed, designed and deployed matrix and tabular reports with drill-down and drill-through features using SSRS.
  • Created Ad-Hoc Reports, Summary Reports, Sub Reports, and Drill-down Reports using SSRS.
  • Created cross-tab, drill-down, drill-through and sub-report RDL (Reporting Definition Language).
  • Created Sub-reports, Drill-down reports, Matrix reports and Summary reports in SSRS 2008.
  • Project includes generating Cross-Tab, Drill-down, Drill-through and Sub-Report using RDL.
  • Created Complex Reports like Cascaded Reports, Drill Through, Tabular Reports, Matrix Reports, Drill-down and Crosstab Reports.
  • Transformed data from various data sources using OLEDB Developed Various Operational, drill-through and drill-down reports using SSRS.
  • Created Sub-reports, Parameterized, Drill-through, Drill-down reports, Matrix reports and Summary reports in SSRS 2005.
  • Created different type of reports including Cross-tab, Conditional, Drill-down, Sub reports also parameterized reports.
  • Involved in Creating Parameterized, Cascaded, Drill-down, Cross-tab and Drill-through Reports using SSRS.
  • Experienced in creating various Parameterized, Cascading, Linked, Drill-Through and Drill-Down reports.
  • Created Drill-down, Parameterized and Sub-Reports using RDL.
  • Generated Parameterized, Drill-through, and Drill-down Reports to get monthly customers account details and profits using SSRS.
  • Created Cross-Tab, Drill-down, Drill-through, Parameterized, cascading parameterized and Sub-Report using RDL.

Show More

33. Windows Execution Plan

demand arrow
low Demand

34. Asp.Net

demand arrow
low Demand
Here's how Asp.Net is used in MS SQL Developer jobs:
  • Used server controls, ASP.NET Web Forms extensively, setting up an inheritance chain of Forms following Object Oriented Programming Principles.
  • Created ASP.NET web forms and Class libraries containing code for business and data access logic using C#.NET.
  • Involved in Development of data access, business and Application layer using LINQ, C# AND ASP.NET.
  • Implemented auditing of changes made by users of ASP.NET application that aided in 40% of support calls.
  • Design and development of front end GUI modules for technical support personnel using C# and ASP.NET.
  • Developed reports by using SSRS and deployed them on web pages using ASP.NET using C#.
  • Supported ASP.NET team to build a credit card payment system prototype for the applications.
  • Implemented Server and Client side validations using ASP.NET validation controls and JavaScript.
  • Involved in the enhancement of Travel agent commission ASP.net application.
  • Designed Web-based ASP.NET Internet applications linked to firm-wide SQL databases.
  • Developed GUI front end using web forms in ASP.NET.
  • Migrated Asp.net Applications to SQL server 2005 environment.
  • Integrated ASP.NET pages with SQL server Database.
  • Integrated SSRS reports with asp.net Maintained Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules.
  • Worked as Application Developer where my job entailed building web applications using ASP.Net and maintaining SQL Server 2005.
  • Involved in the enhancement of Data access layer of component which uses ASP.Net Objects.
  • Deployed and maintained ASP.NET, node Js applications running at IIS 7.0.
  • Developed Web application using the Microsoft .NET framework, ASP.net and MVC.
  • Involved in designing and creating Web UI screens using ASP.Net.
  • Develop SSIS Script tasks using C# ( ASP.NET ) Generated Excel PIVOT Reports.

Show More

35. Drill-Through

demand arrow
low Demand
Here's how Drill-Through is used in MS SQL Developer jobs:
  • Develop numerous drill-through and matrix reports for membership data analysis.
  • Developed different kind of reports such a Drill-through and Drill-down, Sub Reports, Charts, Matrix reports, Linked reports.
  • Created tabular, matrix, list, cascaded, drill-down, drill-through, linked Reports using SSRS.
  • Designed and Developed Complex Chart Reports, Drill-Through Reports, Form Reports and Tabular Reports.
  • Designed the structures and layouts of reports, applied drill-down, drill-through and sub-reports.
  • Created Drill-through, Drill-down, Cross Tab Reports and Sub-Report using RDL.
  • Developed Cross-Tab, Drill-down, Drill-through and Sub-Reports.
  • Enabled drill-through for a cube.
  • Created Stored Procedures to generate Drill-through reports, Parameterized reports, Tabular reports, Matrix reports and Linked reports using SSRS.
  • Created parameterized reports, Drill-through reports and sub-reports using variables, expressions and functions based on the requirements using SSRS.
  • Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
  • Designed, Developed and Deployed Tabular Reports, Matrix Reports, Drill-through Reports and Parameterized Reports using SSRS-2008.
  • Worked on different kinds of reports like Parameterized Reports, Linked Reports and Drill-through reports.
  • Generated sub-reports, drill down reports, drill-through reports and parameterized reports using SSRS 2005..
  • Created parameterized, drill-down and drill-through for sales module for business users in SSRS 2012.
  • Used SSIS packages to roll our data to Live Tables and to Processing Database Generating drill-down, drill-through and parameterized reports.
  • Used SSRS to create various ad-hoc, parameterized, drill-down and drill-through reports weekly and monthly showing detailed information.

Show More

36. Event Handlers

demand arrow
low Demand
Here's how Event Handlers is used in MS SQL Developer jobs:
  • Used SSIS features like event handlers, property expressions, package configurations, transaction option and protection levels in the packages.
  • Worked with creating and Managing Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages.
  • Implemented exception handling using event handlers in SSIS 2012 and identified critical exceptions to be notified and logged in database.
  • Utilized Package Configurations and Event handlers in SSIS to make a package more portable and to handle errors in package.
  • Implemented event handlers to send an e-mail message when an error or a warning occurs or when a task fails.
  • Implemented Error Logging using Event Handlers and also implemented logging in SSIS Packages in visual studio (MSVS).
  • Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user environments.
  • Implemented Distributed Transaction Control for the SSIS packages and event handlers to keep track of error logs.
  • Involved in maintaining batch log tables and error logging tables to handle errors using event handlers.
  • Worked on Error Handling and Event Handlers, Break point, SSIS Logging and Check points.
  • Used Event Handlers to notify the User communities about the results of SSIS package execution.
  • Created and Tuned Event Handlers, Checkpoints and Logging to maintain active SSIS packages.
  • Created configurations to make package portable and event handlers for handling package error.
  • Created Event Handlers for the SSIS package on Error, on Post execute.
  • Implemented custom logging in SSIS using event handlers and execute SQL task.
  • Used Breakpoints & Event Handlers to debug packages & capture errors.
  • Used checkpoints, break points and event Handlers while running packages.
  • Implemented Event Handlers and Error Handling in SSIS packages.
  • Used Event Handlers to handle errors in the packages.
  • Involved in debugging of packages with help of Breakpoints, Checkpoints, Event Handlers and Loggings.

Show More

37. CSV

demand arrow
low Demand
Here's how CSV is used in MS SQL Developer jobs:
  • Migrated data from Flat files and CSV files to SQL Server databases using Integration Services (SSIS).
  • Created SSIS Packages to export and import data from CSV files, Text files and Excel Spreadsheets.
  • Developed SSIS packages for creation delimited files (CSV) which are used input for another application.
  • Used SSIS Package Model to load master data from CSV, XLS/XLSX and pipe delimiter files.
  • Worked on exporting reports in multiple formats including MS Word, Excel and CSV.
  • Developed reports using SSRS and published as PDF, Excel, and CSV formats.
  • Involved in extracting data from heterogeneous sources, such as CSV and Excel files.
  • Imported products from a CSV file using Data Maps and Imports.
  • Used excel sheet, flat files, CSV files to generated Tableau adhoc reports.
  • Used transformations like SCD, Derived column and webservices task to load .CSV files.

Show More

38. TFS

demand arrow
low Demand
Here's how TFS is used in MS SQL Developer jobs:
  • Worked on Team Foundation Server (TFS) to work, maintain track of report and also all documentation.
  • Involved in backing up stored procedures, views and packages on version manager tools like TFS.
  • Deployed packages, scripts, tables, stored procedures from lower to higher environments in TFS.
  • Involved in check in and check out of report layouts using TFS.
  • Organized project process by using MS Team Foundation Server (TFS).
  • Used TFS (Team Foundation Server) for Source Control.
  • Worked on project level deployment in TFS 2012.
  • Worked on TFS in Developing and Staging environments.
  • Experience of working with TFS and Serena business viewer for Versioning and source code management.

Show More

39. BCP

demand arrow
low Demand
Here's how BCP is used in MS SQL Developer jobs:
  • Utilized SQL Server command line utilities like BCP and SQLCMD for automating report generation and recurring data loads.
  • Created data transformation tasks like BCP, BULK INSERT to import/export data from clients.
  • Transferred flat files from different sources to the ETL tier by using BCP.
  • Worked extensively on BCP utilities for bulk data & image file uploading.
  • Import data across multiple instances using BULK INSERT and BCP Utility.
  • Used BCP utility to publish table output to text files.
  • Used BCP command for copying large amount of data.
  • Performed data transfers using BCP and BULK INSERT utilities.
  • Worked on MS SQL Server tasks such as data loading, batch jobs, BCP, Linked Servers.
  • Import Export data, Bulk Insert and BCP.
  • Used Bulkinsert, BCP and database consistency checks using DBCC command.
  • Managed database failover and failback during BCP testing.

Show More

40. Data Integrity

demand arrow
low Demand
Here's how Data Integrity is used in MS SQL Developer jobs:
  • Maintained data integrity by performing validation checks and Optimized queries tuned and monitored server performance.
  • Implemented SSIS data transformations scripts, created maintenance procedures and provided data integrity strategies.
  • Created triggers for cascading update and delete operations to maintain data integrity.
  • Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
  • Maintained data integrity all over the database and performed normalization.
  • Modified existing applications to ensure data integrity and security.
  • Maintained data integrity by performing validation checks.
  • Used DDL and DML Triggers, Stored procedures to check the Data Integrity and verification at early stages before calling them.
  • Maintained standards, security, controls and procedures to ensure data integrity and security.
  • Defined constraints, rules and defaults to ensure data integrity and relational integrity.
  • Implemented Constraints and Triggers for Data Consistency and to preserve Data Integrity.
  • Created complex joins and implemented Constraints on tables for maintaining Data Integrity.
  • Helped team members occasionally with scripts and data integrity issues.
  • Created check constraints to maintain data integrity.
  • Identified slow running query and optimization of stored procedure and tested application for performance, data integrity using SQL profiler.
  • Used Tableau to visually analyze data and create concise and actionable dashboards Created checks and constraints to maintain data integrity.
  • Involved in maintaining Data consistency and Data Integrity with variousconstraints like Unique, Check, Primary Key and Default.

Show More

41. R2

demand arrow
low Demand
Here's how R2 is used in MS SQL Developer jobs:
  • Created views, triggers and complex stored procedures in SQL Server 2008-R2 to implement business rules.
  • Defined report layouts including report parameters and wrote queries for drill down reports using SSRS 2008R2.
  • Developed and delivered dynamic reporting solutions using MS SQL Server 2008R2 Reporting Services (SSRS).
  • Migrated database from MS SQL Server 2005 to MS SQL Server 2008R2 using SSIS packages.
  • Generated reports using Global Variables, Expressions, and Functions using SSRS 2008R2.
  • Worked on performance tuning, and migration of report from 2005 to 2008R2.
  • Normalized and modeled new SQL Server 2008-R2 database environment for data migration.
  • Created and modified SSIS 2008-R2 packages to load and process data.
  • Installed and configured MS SQL Server 2008R2 along with Visual Studio.
  • Developed incremental loading using MERGE statement in SQL server 2008 R2.
  • Installed SQL Server 2008 R2 and established connectivity with Database.
  • Involved in migration of SQL Server 2005 to 2008R2/2012.
  • Migrated Databases from SQL Server 2008 R2 to 2012.
  • Involved in creating SSAS projects using SQL Server 2008R2.
  • Designed reports in both SSRS (SQL 2008 R2) and SQL 2005..
  • Involved in updating the servers from 2008R2 to DENALI (CTP3) version.
  • Transformed data from MS SQL Server 2008R2 to MS SQL Server 2012 using OLE DB connection by creating various SSIS packages.
  • Modified existing stored procedures to conform to model changes in SQL Server 2008-R2 Conducted data mapping between SQL Server databases.
  • Created parameterized, drill down, and aggregated reports in MS SQL environment using SSRS 2008R2.
  • Identified and worked with parameters for creating cascading parameterized reports in SSRS 2008 R2.

Show More

42. Referential Integrity

demand arrow
low Demand
Here's how Referential Integrity is used in MS SQL Developer jobs:
  • Modified current database by adding tables, altering referential integrity and relationships to support online system.
  • 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.
  • Created schema objects such as tables, views, clusters, indexes, procedures, triggers & maintaining Referential Integrity.
  • Created SQL commands like Functions, Stored Procedures and Triggers to access and retrieve data and maintain database referential integrity.
  • Created and managed schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements.
  • Created After and Instead of Triggers to enforce data consistency and referential integrity.
  • Created SQL tables with referential integrity and developed queries using SQL.
  • Created Triggers to maintain the Referential Integrity.

Show More

43. DB2

demand arrow
low Demand
Here's how DB2 is used in MS SQL Developer jobs:
  • Performed transfer and loading of files to DB2, Database Administrator for DB2 in z/OS environment for more than 2 years.
  • Created SSIS packages for data integration from various data sources, such as DB2 & SQL Server into SQL Server 2008R2.
  • Developed SQL scripts, ensured optimal performance of the queries to generate reports from various relational databases like Oracle, DB2.
  • Transferred data from various data sources/business systems including MS Excel, MS Access, Flat Files, Oracle, DB2 etc.
  • Used diverse connection adapters to load data from heterogeneous databases/sources (Excel, DB2, Text, CSV, etc.)
  • Experience in handling with DB2 mainframe and working with CMD Utility tool to run command files.
  • Worked on DTS Package, DTS Import/Export for Transferring data from DB2 Database.
  • Created testing script for migrated data from DB2 to MS SQL server.
  • Experience in handling with DB2 mainframe.
  • Created the Load packages for loading the CSV files from DB2 into SQL Server using SSIS 2012.
  • Handled Tableau admin activities granting access, managing extracts and Installations Built connections to/pulling data from AS400, mainframe/db2 and Oracle.
  • Developed stored procedures, user-defined functions, triggers, indexes, cursors and views in SQLServer, DB2 databases.
  • Migrated data from heterogenous data sources and legacy system (DB2, Access, Excel) to SQL server.
  • Administered DB2 subsystems in Prod, Qual, Test and Development regions.

Show More

44. Multiple Tables

demand arrow
low Demand
Here's how Multiple Tables is used in MS SQL Developer jobs:
  • Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables & calculations from different databases.
  • Combine data sources by joining multiple tables and using data blending.
  • Used multiple join statements to retrieve data from multiple tables.

Show More

45. Visual Source Safe

demand arrow
low Demand
Here's how Visual Source Safe is used in MS SQL Developer jobs:
  • Used Visual Source Safe (VSS 2005) for keeping Database Objects under Source Control.
  • Used Visual Source Safe to track the versions of the entire project.
  • Use MS Visual Source Safe as a Version Control System.
  • Used Visual Source Safe tool for Version Control.
  • Installed various software like MS SQL server 2008 R2, Aqua data, visual source safe.
  • Project Environment: SQL Server 2000, DTS, ASP.NET, VB.NET, Visual Source Safe

Show More

46. VB

demand arrow
low Demand
Here's how VB is used in MS SQL Developer jobs:
  • Redesigned/enhanced multiple Excel/VBA applications for performing sophisticated commercial planning/market investment analysis for consumer goods company.
  • Designed Excel/Access VBA/SQL product distribution/assortment management tool.
  • Designed additional Excel/VBA/SQL reporting tools.
  • Worked as Excel/Access/VBA Developer with IT Team to develop and maintain an Access Database and Excel Applications.
  • Imported and exported data into MS Access databases and Debugged VBA scripts linked to said databases.
  • Worked to establish connectivity between VB applications and MS SQL server by using ODBC.
  • Worked with script component to write codes in VB.NET to implement data initialization settings.
  • Achieved similar time savings by redesigning related Excel VBA applications.
  • Created user defined functions in SSRS using VB script.
  • Used VB script in script components for data transformations.
  • Designed Excel VBA/SQL product swap decision-making tool.
  • Involved in SSIS Packages using Script Task and various C#, VB script.
  • Used C# and vb.net to create script tasks in SSIS packages.
  • Assisted in establishing connectivity between VB applications and MS SQL Server Supported technical teams involved with MS SQL issues and operations.
  • Worked with script task in SSIS with C# and VB.Net programming language.
  • Designed front-end in VB.Net 2008 for crystal report for live core banking project.
  • Involved in design weatherization application using VB.NET , ASP.NET, Frame work.
  • Migrated windows applications from VB6 to VB.Net.
  • Design and develop Windows Forms using VB.Net, SQL Server 2000 and Infragistics.
  • Net, VB.Net Implemented changes in coding and designs using knowledge of VB .NET Created Development and Production support documents.

Show More

1 VB Jobs

No jobs at selected location

47. Html

demand arrow
low Demand
Here's how Html is used in MS SQL Developer jobs:
  • Diagnose and correct errors within Java/HTML code to allow for connection and utilization of proprietary applications.
  • Created email notification for process started and completed, file load completion, new file creation, error notification using HTML.
  • Designed and generated reports with different layouts using SSRS 2008/2005 and exported them into Excel, PDF and HTML.
  • Posted HTML files to server and updated database and returned the response back to ASP.NET.
  • Used script task to produce HTML reports and mail using SSIS.
  • Involved in documentation of the project implemented using HTML.
  • Developed user friendly GUI using HTML and CSS.
  • Developed the UI part of Web application using HTML5, CSS, C# and ASP.NET.
  • Transferred XML documents to XHTML with the help of XSL.
  • Enhanced and developed UI functionality using ASP.Net and HTML.

Show More

1 Html Jobs

No jobs at selected location

48. Dimension Tables

demand arrow
low Demand
Here's how Dimension Tables is used in MS SQL Developer jobs:
  • Created complex packages and performed the ETL to load the Dimension Tables in using SSIS.
  • Created MS Power Pivot Excel report using fact table and dimension tables of SSAS cube.
  • Defined Dimension Models based on existing fact & dimension tables in Relational Data Warehouse.
  • Created efficient SSIS packages for processing fact and dimension tables with complex transformations.
  • Implemented SSAS Cubes, Facts and Dimension tables to perform analysis services.
  • Analyzed and created Multidimensional Cubes in Facts and Dimension Tables using SSAS.
  • Used the update strategy transformation to update the target dimension tables.
  • Identified fact and dimension tables in the Cube.
  • Created Fact and Dimension tables.
  • Involved in migrating data from Data warehouse to data marts Implemented SSAS Cubes, Facts and Dimension tables to perform analysis.

Show More

49. Cross-Tab

demand arrow
low Demand
Here's how Cross-Tab is used in MS SQL Developer jobs:
  • Generated reports using Cross-Tab, Global Variables, Expressions and Functions using MS SQL Server Reporting Services.
  • Developed parameterized crystal reports existing reports for presentations using cross-tab reports, running totals, and alerting.
  • Developed, and scheduled variety of reports like cross-tab, parameterized, drill through and sub reports with SSRS.
  • Created Parameterized reports, Cross-Tab reports, Drill down reports & Summary reports by using SSRS 2005.

Show More

50. User Acceptance

demand arrow
low Demand
Here's how User Acceptance is used in MS SQL Developer jobs:
  • Participated in requirements gathering sessions and the administration of User Acceptance Testing exercises.
  • Configured Snapshot replication for reporting, user acceptance test and development servers.
  • Attend functional testing and user acceptance sessions and worked on the feedback provided by them.

Show More

MS SQL Developer Jobs

NO RESULTS

Aw snap, no jobs found.

20 Most Common Skills For A MS SQL Developer

SQL

14.4%

Database

14.0%

Data Warehouse

10.3%

Ssrs

6.9%

Ssis

6.7%

T-Sql

6.7%

ETL

5.0%

Business Requirements

4.7%

Windows XP

4.5%

Ssas

3.5%

Query Analyzer

3.3%

Column

2.8%

Constraints

2.5%

DTS

2.4%

XML

2.3%

Management Studio

2.1%

Oltp

2.0%

Olap

2.0%

Backup

1.9%

Fuzzy Lookup

1.9%
Show More

Typical Skill-Sets Required For A MS SQL Developer

Rank Skill
1 SQL 11.0%
2 Database 10.7%
3 Data Warehouse 7.8%
4 Ssrs 5.3%
5 Ssis 5.1%
6 T-Sql 5.1%
7 ETL 3.8%
8 Business Requirements 3.5%
9 Windows XP 3.4%
10 Ssas 2.7%
11 Query Analyzer 2.5%
12 Column 2.2%
13 Constraints 1.9%
14 DTS 1.9%
15 XML 1.7%
16 Management Studio 1.6%
17 Oltp 1.6%
18 Olap 1.5%
19 Backup 1.5%
20 Fuzzy Lookup 1.4%
21 Sub-Reports 1.4%
22 C # .NET 1.4%
23 Wizard 1.3%
24 Text 1.2%
25 Ad-Hoc 1.2%
26 Sharepoint 1.1%
27 Complex Queries 0.9%
28 Ssms 0.9%
29 Development Studio 0.9%
30 Business Logic 0.9%
31 MDX 0.8%
32 Drill-Down 0.8%
33 Windows Execution Plan 0.8%
34 Asp.Net 0.8%
35 Drill-Through 0.7%
36 Event Handlers 0.7%
37 CSV 0.7%
38 TFS 0.7%
39 BCP 0.7%
40 Data Integrity 0.7%
41 R2 0.6%
42 Referential Integrity 0.6%
43 DB2 0.6%
44 Multiple Tables 0.6%
45 Visual Source Safe 0.5%
46 VB 0.5%
47 Html 0.5%
48 Dimension Tables 0.5%
49 Cross-Tab 0.5%
50 User Acceptance 0.5%
{[{skill.rank}]} {[{skill.name}]} {[{skill.percentageDisplay}]}%
Show More

20,623 MS SQL 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.