Job Description :
Senior SQL Server Database and Oracle Developer
Main areas of responsibility:
Design, develop and support multiple data projects in traditional relational databases such as Oracle, MSSQL
Develop complex queries and stored procedures using T-SQL
Knowledge conversion PL/SQL to T-SQL
Expert level of SQL query performance tuning
Evaluate large and complex data sets
Dimensional Data Warehousing and ‘Big Data’ Experience
Migration of data between various RDBMS (i.e. Oracle & SQL Server)
Qualifications:
8+ years development experience with Microsoft SQL Server including recent experience with 2014, 2016 and or 2017
8+ Years’ experience coding T-SQL including the use of dynamic SQL
5 years’ experience with Oracle Database development.
Data warehouse development experience
Experience with development in other aspects of the Microsoft BI Stack – SSAS/SSRS/SSIS
Other Skills:
Any experience with Oracle GoldenGate (software application for database integration and migration)
Experience with data in various forms (data warehouses/relational SQL, NoSQL, JSON, unstructured data environments/PIG, HIVE, Impala, Spark, AtScale, HBase, Kafka)