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.

 

 Description:

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:

 

KEY DUTIES

• 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 environment.
• 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 standards.
• 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 guidelines.?
• Maintains effective working relationship with application development and production support team.

 

QUALIFICATIONS

• 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 SSAS.

 Other desired experience:

• Developing customized Data Warehousing, ETL, Business Intelligence and On-Line Analytical Processing (OLAP) applications for enterprise data warehouses.
• 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 transformation.
• 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

aojha@sagetl.com

--
You received this message because you are subscribed to the Google Groups "US Jobs: Requirements, Clients and Consultants" group.
To unsubscribe from this group and stop receiving emails from it, send an email to recruiters-r-us+unsubscribe@googlegroups.com.
To post to this group, send email to recruiters-r-us@googlegroups.com.
Visit this group at https://groups.google.com/group/recruiters-r-us.
For more options, visit https://groups.google.com/d/optout.