Orion Innovation is a premier, award-winning, global business and technology services firm that provides business solutions rooted in Digital Strategy, Experience Design, and Engineering, delivering game-changing business transformation and digital product development for our clients.
Orion Innovation is looking for a senior database developer (SQL) resource who can assist with SQL upgrade 2016 activities , and cloud migration (managed SQL) as well as archiving / purge development for one of our applications.
Experience required for the role:
- Minimum 5+ years of experience in software development using Microsoft SQL Server, Azure SQL, T-SQL and T-SQL language (queries, views, procedures).
Must have experience in troubleshooting and resolving database integrity issues, complex query performance optimizations, blocking and deadlocking issues, table partitioning, data replication/restore process.
- Design and development of Microsoft SQL Server databases(MS SQL Server 2016/2014/2012).
- Experience in development of SSIS packages to Extract Data, Transform, Load (ETL) data into SQL Server from different environments.
- Experience in Database Maintenance plans for the performance of SQL Server, which includes Database Integrity Checks, Update Database Statistics and Re-index the fragmented indexes. Design database by adding tables, relationships, create stored procedures, views, Triggers, Functions and performance tuning of SQL queries.