Title: Database DeveloperLocation: Seattle, WA / Austin, TXDuration: 12 Months Development of high-quality database solutions ensuring performance, security, and availability of databases Participate in the design and database and able to create ER diagrams, integrate with applications and reporting Create and maintain database objects such as Tables, Views, and Stored Procedures Develop various facets of the Hadoop ecosystem, data processing, and Map Reduce jobs 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
Who You Are: A minimum 8+ years of demonstrable programming experience in SQL development A minimum of 6+ years of experience in MS SQL SERVER including proficiency in SQL and stored procedures Excellent understanding of Microsoft SQL Server , Teradata and Oracle 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 SQLServer 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 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
