The scope of this position extends to Targray applications and application infrastructure worldwide. The incumbent will be accountable for:
Creating, troubleshooting, and maintaining SQL Objects (stored procedures, views, triggers, and functions).
Writing and maintaining complex SQL queries.
Building relationships and cleaning data between different systems to align the data to get accurate reports
Developing, debugging, and modifying the SSRS Reports/SSIS Packages.
Authoring, managing, and deploying reporting solutions using MS SQL Server Reporting Services (SSRS), Crystal Reports and SQL Integrated Services (SSIS).
The incumbent will work closely with the local and international IS and Finance team.
Requirements
University degree (B. Tech./MCA) in computer science or computer application.
Minimum of 5 years proven experience managing multiple MS SQL Server 2008 /2014 /2016 / 2017 databases and SQL development.
Excellent analytical, troubleshooting, organizational, written, and oral skills along with a positive attitude.
Knowledge of handling large datasets.
Advance level knowledge on SQL Query optimization, writing complex SQL queries, functions, procedures, triggers, and RDBMS data modelling.
Advance level knowledge on T-SQL, SSIS, SSRS, and stored procedures.
Ability to work with and understand existing .NET and legacy applications that interact with SQL.
Data warehouse concepts (Implementation of ETL pipelines, data integration components (SSIS)
Knowledge of Crystal Reports or Crystal Enterprise Server would be an added advantage.
Must be able to accommodate a flexible schedule to support/maintenance of the SQL Environment whenever required (i.e., system implementations and maintenance may be performed in off hours).
Adhere to timelines and quality of the assigned task.
Ability to work under pressure on multiple assignments
Must have excellent English oral and written communications skills.
Must have the ability and desire to thrive in a fast-paced, service-oriented environment.
Assets
Good understanding of the Finances business domain
Experience with Microsoft ERPs database schema, tables, and views (Dynamics GP preferred).
Benefits
A competitive remuneration plan and an excellent working environment in a growing multinational organization.
Beautiful, spacious and modern workplace environment.
Flexible work arrangement policy.
Generous company-wide profit-sharing plan.
Off-site Team Building and experiential development.