This job board retrieves part of its jobs from: Toronto Jobs | Emplois Montréal | IT Jobs Canada

Find jobs in Texas today!

To post a job, login or create an account |  Post a Job

  Jobs in Texas  

Bringing the best, highest paying job offers near you

previous arrow
next arrow
Slider

Database Developer / Programmer

Ameri100

This is a Full-time position in Austin, TX posted May 10, 2021.

Locals Drivable preferred Position Summary The Database Developer is responsible for designing, building, enhancing, and supporting database systems for complex high-level reporting requirements for a wide variety of applications. The Database Developer should have a solid understanding of database design, development and management in a cloud environment, and should be able to perform quality control, database administration, transform data via ETL processes, debug and analyse code, and work with team members to ensure a high-quality end product. HeShe should work both independently and as a part of a team. Responsibilities bull Provide development and administration support for analytics data services solutions in different environments, including TimeXtender, Azure Analysis Services, Azure Data Lake Gen 2, and MS SQL Server bull Develop and maintain Extract-Transform-Load (ETL) scripts, SQL scripts, and ETL schedules, using TimeXtender, MS SQL Server, MS Integration Services, or Azure Data Factory bull Develop and implement all database indexing, maintenance, backup, transformations, and stored procedures, utilizing SQL Management Studio or equivalent tools bull Monitor scheduled ETL processes and troubleshoot issues in collaboration with owners and administrators of related systems or data sources bull Lead the development of engineering artifacts documenting the systemrsquos design and architecture, including Technical Design Document preparation and delivery bull Work with business stakeholders and business analysts to fully understand business requirements and convert into appropriate technical solutions bull Contributing member of a cross-functional team in charge of delivering new features and capabilities on an iterative basis bull Ability to digest existing SQL data models, data sources, and ETL processes and be able to provide recommendations for additional functionality or improvements to the existing design bull Provide accurate estimates of effort required to complete assignments bull Conduct reviews to ensure all code passes organizationally mandated code reviews and audits bull Perform other duties as requested. Qualifications bull Bachelor’s degree in Computer Science or equivalent work experience bull Minimum of 4 years of experience in database design, development, and management, preferably with a data warehousing, business intelligence, or analytics focus bull Demonstrated knowledge of transactional database and data warehouse architecture, design, and development (star schema, high dimensional model, fact tables, etc.) bull Deep knowledge of relational database objects and their functions bull Demonstrated experience with MS SQL Server Integration Services and SQL Scripts bull Strong knowledge of MS Power BI tool along with profound knowledge on query writing using DAX bull Demonstrated skills and experience using and managing data resources in Azure, especially Azure Data Lake Gen 2, Azure SQL Server, Azure Analysis Services, and Azure Data Factory. bull Familiarity with backup recovery, performance tuning and optimization. bull Extensive data migration skills and working experience with ETL concepts and tools bull Preferred knowledge of TimeXtender bull Excellent communication, both written and verbal, with all levels of the business. bull Strong sense for detail, accuracy and problem solving

Please add your adsense or publicity code here (inc/structure/adsfooter.php)