Automatically apply for jobs with Zippi
Upload your resume to get started.
Ms sql developer skills for your resume and career
15 ms sql developer skills for your resume and career
1. Database Objects
- Created/reallocated database objects on appropriate file group to ease maintenance and improve data access performance.
- Utilized database objects such as tables, views, functions, triggers and stored procedures, and indexed using T-SQL queries.
2. SSRS
- Developed Financial Reports using SSRS Report Designer.
- Designed and created Dashboard with KPI's, Scorecard and reports using SQL Server Reporting Services (SSRS) and Excel.
3. Ssis Packages
- Implemented partitioned tables for performance enhancement and developed SSIS packages to categorically select partition during data upload to database.
- Implemented Connection Manager files for SSIS packages to dynamically execute on Quality Analysis server and Production server.
4. SQL Server Analysis
- Experience in using XMLA protocol for SQL Server Analysis Services for interaction between client application and instance of Analysis Services.
- Experience in SSAS (SQL Server Analysis Services), Design and Developed cubes testing and Deployment/ Implementation.
5. T-SQL
- Developed dynamic T-SQL scripts for operational reports.
- Supported business applications using T-SQL.
6. ETL
- Worked with business analysts and Sr. ETL developer in analyzing business requirements.
- Translated requirements into ETL design specifications.
Choose from 10+ customizable ms sql developer resume templates
Build a professional ms sql developer resume in minutes. Our AI resume writing assistant will guide you through every step of the process, and you can choose from 10+ resume templates to create your ms sql developer resume.7. Windows Server
- Experience with Microsoft Windows Server 2012 Enterprise Edition clustering specifically active/active and active/ passive.
- Provide Windows server and network administrative support.
8. Data Warehouse
Data warehouse, often abbreviated as either DW or DWH is a system used in computing for data analysis as well reporting. The DW is also considered to be an integral component of business intelligence as they also provide storage facilities for both real-time and historical data. ETL and ELT are the two driving forces behind a data warehouse system.
- Participated in testing and verification of the entire database/data warehouse system after migration.
- Developed Data warehouse logical and physical data model using Erwin tool.
9. SSAS
- Designed SSAS cubes for providing business intelligence applications.
- Reviewed and changed the cubes in the data marts for product valuation based on the revenue opportunities using MS SSAS 2008..
10. XML
XML is a medium for storing and transporting data that is independent of software and hardware. XML stands for eXtensible Markup Language. XML, like HTML, is a markup language that was created to store and transport data. It was created with the intention of being self-descriptive. There are no predefined tags in the XML language. Another feature is that XML is extensible.
- Created Package Configurations in XML Files to efficiently Promote Unit Tested Packages to Production Environment from Development Environment.
- Extracted the data from SQL Server and used XML and present it to the end user in XML format.
11. Drill-Down
- 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.
12. HTML
- Created email notification for process started and completed, file load completion, new file creation, error notification using HTML.
- Developed user friendly GUI using HTML and CSS.
13. Management Studio
Management Studio is an integrated environment, and a software tool developed by Microsoft to help database developers to access, develop, configure, manage, and administer all the components and infrastructure within Microsoft SQL Server.
- Design and normalize databases first, second and third NF, tables, indexes and views in SQL Server management studio.
- Imported and Exported data from one server to other servers using Import/ Export wizard in SQL Server Management studio.
15. Java
Java is a widely-known programming language that was invented in 1995 and is owned by Oracle. It is a server-side language that was created to let app developers "write once, run anywhere". It is easy and simple to learn and use and is powerful, fast, and secure. This object-oriented programming language lets the code be reused that automatically lowers the development cost. Java is specially used for android apps, web and application servers, games, database connections, etc. This programming language is closely related to C++ making it easier for the users to switch between the two.
- Worked closely with the Java Developers in making JDBC connections and supplying them with the necessary Procedure Signature Technical Specifications Document.
- Migrated legacy Java code for computing satellite pointing angles into PL/SQL to improve satellite installer efficiency.
5 MS SQL Developer resume examples
Build a professional ms sql developer resume in minutes. Browse through our resume examples to identify the best way to word your resume. Then choose from 5+ resume templates to create your ms sql developer resume.
What skills help MS SQL Developers find jobs?
Tell us what job you are looking for, we’ll show you what skills employers want.
List of ms sql developer skills to add to your resume
The most important skills for an ms sql developer resume and required skills for an ms sql developer to have include:
- Database Objects
- SSRS
- Ssis Packages
- SQL Server Analysis
- T-SQL
- ETL
- Windows Server
- Data Warehouse
- SSAS
- XML
- Drill-Down
- HTML
- Management Studio
- SharePoint
- Java
- Power Bi
- Column
- DTS
- SQL Server Profiler
- Drill-Through
- Azure
- Data Flow
- TFS
- SSMS
- OLAP
- Query Analyzer
- OLTP
- Sub-Reports
- Microsoft SQL Server
- CSV
- Extraction
- Load Data
- Error Handling
- Wizard
- MDX
- Business Rules
- Business Logic
- Microsoft Visual
- Debugging
- Data Integrity
- Business Intelligence Development
- Business Analysts
- R2
- DB2
- Execute SQL
- Extract Data
Updated January 8, 2025
