Monday, March 27, 2017

[Matrix Placement Services] [NetaKsharee] SQL BI Developer in Dallas, TX !
*SQL BI Developer*
*Dallas, TX*
*6+ months *
*Onsite interview*
*Local Candidates*
The qualified candidate will possess 5+ years of experience in three major
areas, including: SQL Server Application Design & Development Experience,
SSIS, and Database Administration.
Design, development and deployment of Data Warehousing and ETL process
design and automation initiatives on SQL Server platform. Provide ETL
development expertise in relational database management concepts and data
warehousing best practices. Develop SSIS packages in support of ad-hoc and
ongoing processes. The candidates must also have knowledge of data
architecture and data integration methodologies.
*Responsibilities for this Position Include:*
– Ensuring that databases are properly designed from a logical,
physical, performance, and data governance perspective.
– Establishing proper monitoring, operational support guidelines, and
procedures in order to establish highest reliability in the production
– Providing intermediate-level development support to application
development teams, including design for performance, utilization of DBMS
features, and debugging technical issues.
– Contribute to the design and architecture to enable secure, scalable,
and maintainable software
– Responsible for implementing solutions ensuring the quality of data
and data integrity
– Develop implementation plans & Monitor jobs and verify completion
– Work closely with Developers and Quality Assurance Analysts to ensure
requirements and design are completely understood
– Develop SSIS ETL processes to ingest data from source systems and
operational transactional applications
– Maintains quality service by establishing and enforcing organization
– Follows SDLC as key portions of the software development lifecycle
– Monitor the databases to optimize database performance, resource use
and physical implementations of databases. Checking for database
consistency, fixing DBCC errors, monitoring of error logs regularly,
monitoring of database space allocations, transaction log space allocations.
– Prioritizes, scopes, estimates, and implements changes within the MS
SQL Server database environment.?
– Ensures security event logs are maintained.? Ensures all productions
changes are made in accordance with lifecycle methodology and risk
– Maintains effective working relationship with application development
and production support team.
– High School diploma or equivalent required.
– Bachelor Degree in IT or equivalent work experience strongly preferred.
– 4+ years of SQL Server 2008 (or above) application design and
development experience
– 3+ year of SSIS, SSAS, SSRS, SQL Stored procedures development
experience dealing with large volume data processing and analytics
– Relevant technology certification is encouraged.
– Required 5 years of IT experience in working on projects,
data/application architecting, Database Administration, System Analysis,
Design, Development and Support of MS SQL Servers 2014, 2012, 2008, 2005,
2000, 7.0 and 6.5 in Production, QA and Development environments.
– Performance Tuning, Query Optimization, Client/Server Connectivity,
Database consistency checks using DBCC Utilities.
– Extensive experience in developing data warehouses, data marts,
operational data stores using SSIS
– Developing ETL and Data Warehousing solutions writing complex ETL Code
Using Microsoft SQL Server technologies, including DTS Packages, SSIS and
* Other desired experience:*
– Developing customized Data Warehousing, ETL, Business Intelligence and
On-Line Analytical Processing (OLAP) applications for enterprise data
– Microsoft Data warehousing Framework including SQL Server Analysis
Services 2008, 2000, SSIS 2008,2005, SSRS 2008, Excel 2007/2010,
Performance Point 2007, TSQL, ETL Tools.
– Well versed using DTS,SSIS Transformations and Customizing new
– Experience in writing Stored Procedures, Functions and Triggers.
– Excellent interpersonal, analytical and communication skills.
– Experience in SQL Server Architecture and metadata
*Thanks & Regards,*
*Abhishek Ojha*
*732- 837- 2138*
* *

You may view the latest post at

You received this e-mail because you asked to be notified when new updates are
Best regards,

No comments:

Post a Comment