Vacancy expired!
Trigyn's direct client has a long term contract assignment in Austin, TX & Seattle, WA. The particulars of the position are as follows.
NO c2c, only W-2 candidates.Technical skills / Requirements: The candidate must have 8+ years demonstrable programming experience in SQL development Strong experience in MS SQL SERVER including proficiency in SQL and stored procedures. Excellent understanding of Teradata Develop, implement, and optimize queries, procedures and functions using T-SQL (DQL, DML, DDL, DCL and TCL). Excellent knowledge in creating objects like Indexed Views, complex Stored Procedures, effective functions, and appropriate Triggers to facilitate efficient data manipulation and data consistency. Hands on experience with performance tools like SQL Profiler, Index Tuning Wizard and Database Engine Tuning Advisor. Experience with ETL technologies, hands on experience with developing, deploying, and monitoring packages for ETL tasks using Informatica/ SSIS DTS Import/Export Utility, BCP and DTS packages. Excellent understanding of T-SQL programming and Teradata SQL Understanding PERL for any legacy code debugging, ability to write shell and python scripts Hands on experience using SQL Server agent jobs and logshipping for SQL Server Develop a test framework for database migrations to compare objects and data from source systems to target systems Write test cases for comparing performance throughput across Hybrid data centers and capturing and storing the results for performance benchmarking.General Responsibilities: Design database applications, such as interfaces, data transfer mechanisms, global temporary tables, data partitions, and function-based indexes to enable efficient access of the generic database structure. Develop load-balancing processes to eliminate down time for backup processes. Develop data models for applications, metadata tables, views or related database structures. Develop data models for applications, metadata tables, views or related database structures. Identify, evaluate and recommend hardware or software technologies to achieve desired database performance. Plan and install upgrades of database management system software to enhance database performance. Development of high-quality database solutions ensuring performance, security, and availability of databases Strong understanding of distributed systems, operating systems, networking, databases, security, and analytics. Experience developing continuous integration, continuous delivery, and continuous deployment pipelines for distributed apps. Participating in the design and database and able to create ER diagrams, integrate with applications and reporting Able to write tests for SQL connectivity, data validation and for performance throughput Strong proficiency with SQL and its variation among popular databases Knowledge of best practices when dealing with relational databases Good understanding of ANSI SQL code and databases such as MS SQL server, Teradata and Postgres SQL Creating and maintain database objects such as Tables, Views, and Stored Procedures Develop various facets of the Hadoop ecosystem, data processing, and Map Reduce jobs.For Immediate Response call or send your resume to TRIGYN TECHNOLOGIES, INC. is an EQUAL OPPORTUNITY EMPLOYER and has been in business for 30 years. TRIGYN is an ISO 9001:2015, ISO 27001:2013 (ISMS) and CMMI Level 5 certified company.