About Daksoft:
Daksoft is an Air force veteran led global professional services company with leading capabilities in digital, cloud and security. Combining unmatched experience and specialized skills across industries, we offer strategy and consulting. We embrace the power of change to create value and shared success for our clients, employees, partners and communities.
Job Title: MS SQL Server Developer
Work Location: Noida
Experience:4 to 8 Years
Package: As per Top Tier Market Standards
Notice Period: Immediate
Full-Time Opportunity
Skills: MS SQL Server Developer, T-SQL, Performance tuning, SSIS, DTS Migration & ETL Data Flows
Key Responsibilities: Develop views in the Snowflake environment that facilitate data migration. Collaborate with onshore, offshore and other team members to determine the requirements, perform analysis and deliver the work product. Manage project aspects such as work plan guidance to project team and monitor quality assurance of project implementation. Develop, run and maintain new ETL and control processes with SSIS, SQL and stored procedures. Technical Experience: Hands-on experience on SSIS and SQL Server. Exposure to snowflake environment. Should have exposure to data warehousing, ETL Tools, Data Transformation Services DTS, Professional Attributes: Working with the client independently on developments assigned – Should have good communication skills – Flexible working in different time zones if necessary – Good team player – Mentoring juniors
Company benefits:
• All work hours meals provided.
• Phone & travel allowance.
• Gym membership.
Daksoft Solutions LLP
Technical experience preferred:
• Database Development, Data Analysis, System Analysis, Design, Development and Support of MS SQL Server in Testing and Development
• Experience in creating Snowflake views
• Hands on experience in monitoring SQL Server Performance tuning in SQL Server 2000/2005 /2008 using SQL –Profiler, Query Analyzer, Enterprise Manager, Index Tuning Wizard, and Windows Performance Monitor
• Knowledge of Relational Database Management systems.
• Experienced in creating and using Stored Procedures, Triggers, Views, User Defined Functions, Sub – Queries and Joins for complex queries involving multiple tables and exception handlers.
• Proficient in SQL Server and T- SQL (DDL and DML) in constructing Tables, Normalization/ De normalization Techniques on database Tables.
• Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.
• Experience in creating and managing fragmentation of Indexes to achieve better query performance. Experience in Performance Tuning and Query Optimization.
• Install and Configure SQL Server on Virtual Machines.
• Expert in designing ETL data flows using creating mappings/workflows to extract data from SQL Server and Data –Migration and Transformation from Oracle/Access/Excel Sheets using SQL Server SSIS.
• Expert in developing SSIS packages. Experience in DTS Migration and Metadata Management: Migrating DTS packages to Package Migration Wizard, and Storage Management.