##### Job Description :
-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.
-Level II Intermediate level resource with significant experience
##### _**Skills**_
-Candidate must have 8-10 years demonstrable programming experience in SQL development
-A minimum of 6-year 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 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
