Previous Job
Previous
SQL with Teradata
Ref No.: 18-52473
Location: Milpitas, California
Position Type:Full Time/Contract
Start Date: 07/24/2018
 
  • At least 6 - 8+ year experience in relational database development or administration in a commercial enterprise setting
  • Must have extensive hands-on experience with one of the enterprise database e.g. Oracle, Teradata, SQL Server etc. OR NoSQL DB technology experience ( Cassandra, Couchbase, Mongo, Solr )
  • Must have understanding of Logical and Database design, for transactional/data warehouse and data normalization concepts
  • Perform database design by analyzing business requirements
  • Experience in developing and optimizing complex stored procedures
  • Experience in working with all key database objects – Tables, Views, Triggers, Indices, Stored Procedures, User Defined Functions, Dynamic SQL
  • Database modeling and design
  • Knowledge of SQL best practices             
  • Query performance tuning (Query Plan Analysis, Profiler etc. Responsible for Analyzing and Fine-tuning of database objects and server to ensure efficient data retrieval. Provide necessary recommendations to improve the performance of the slow running SQL queries / ETL processes and should be able to implement and test the changes.
  • Excellent problem solving skills (for debugging problem/issues)
  • Experience in working with big databases ( over 100 GB)
  • Knowledge about Distributed systems architecture
  • Should have expereince in one or more Scripting languages Python, Shell Script OR PL/SQL
  • Experience with SDLC and Agile development practices
  • Excellent problem solving skills (for debugging problem reports)