Send me more jobs like this

Sr. SQL Developer ( SSIS, SSRS, SSAS)

Keywords / Skills : SQL Developer, SQL server developer, Database developer, Ms SQL developer, SSIS, SSAS, SSRS

5 - 10 years
Posted: 2019-09-12

Nationality
Philippines
Industry
IT/Computers - Software
Function
IT
Role
Software Engineer/Programmer
Education
Bachelors
Degree
Posted On
12th Sep 2019
Job Description
Qualification

• 5+ years of experience in SQL Server development and administration with DBA duties.

• Experience in SSIS, SSAS and SSRS of MS SQL Server tools.

• Expertise in designing SSIS packages to import and transform data between databases and external data sources using various transformations.

• Experience in configuration and maintain Report Manager and Report Server for SSRS, Deployed and Scheduled the Reports in Report Manager

• Developed OLTP system (s) and involved in creating facts, dimensions and Star Schema representation for the data mart.

• Expertise in OLAP and OLAP Cubes in SSAS.

• Proficient in Data Migration from sources like MS Access, SQL server, Text Files, Excel to SQL server 2000/2005/2008 using SQL Server Integration Services (SSIS).

• Well-versed with database Installation, configuration, maintenance, monitoring, backups and recoveries, develop and debug Stored Procedures and Triggers.

• Experience in creating SQL Logins, Roles and Authentication modes as a part of security policies for various categories of users.

• Experience in using BCP and Bulk Insert commands while working with Flat files

• Knowledge in Linux command shell, Git, Python, Spark, Hadoop (HBase, Hive, Impala) is desired

• Extensive knowledge of Relational Database Management Systems including MS SQL Server 7.0/ 2000/ 2005/2008 R2, Oracle 8i/ 9i/ 10g, DB2and Teradata.

• Extensive experience with monitoring, tuning, analyzing DB performance and allocating server resources to achieve optimum DB performance by performing various query-optimization techniques.

• Good experience in writing MDX queries while creating and customizing Cubes using SQL Server Analysis Services (SSAS) 2005/2008.

• Experience in working with SSAS in creating cubes, data source views, named queries, dimensions and deploying of analysis services projects.

• Expertise in identification of Business & Data requirements and converting them into conceptual & logical data models.

• Experience in Dimensional Data Modeling Star and Snow Flake Schemas.

• Experience in maintaining database, including updating statistics, re-indexing, structure modifications, and index analysis and also Log Shipping, Mirroring & Replication to restore Database backup.

• Flexible, enthusiastic and project oriented team player with excellent written, verbal communication to develop creative solutions for challenging client needs.



About Company

Asian Technology Solutions (ATS) was founded by IT Professionals and leaders from wide spectrum of industries to build IT business solutions.

ATS has been formed with a strong focus in areas such as IT Consulting, Staff Augmentation, HR and Training to its customers with assured service excellence on high-quality, reliable and cost-effective services to various industrial verticals such as IT, ITES, Telecom, Retail, Manufacturing, Infrastructure, BFSI and Life Sciences.

Asian Technology Solutions (ATS) ranked among the top recruitment and staffing Companies in APAC. We are one of the leading companies in developing and delivering unique personnel solutions that are customised according to the specific operational and HR requirements of organisations.

Since then we have been dominating the recruitment and staffing industry in APAC. We have a corporate
office in Singapore and branch offices in Thailand, Malaysia, Indonesia Philippines, Australia and India.

ATS has a Track Record with 100 plus clients across 12 Countries .
Similar Jobs
View All Similar Jobs


Walkin for you