Database Specialist
Coforge Limited
Total years of experience :9 years, 8 Months
Working as a Database Specialist
1) Create SQL stored procedures, Triggers, Complex queries, views and other database objects.
2) Writing and optimizing T-SQL statements, Tuning SQL queries and optimize the performance using Indexes, Partitions and Statistics to meet the SLA.
3) Create Control flow/Data flow to generate extract, reports and data loading using SSIS.
4) Contributing at a senior level to the extract/report creation and data preparation by implementing a solid, robust, extensible logic that supports key business flows.
5) Create scripts, stored procedures for data ingestion and support application development.
6) Data warehouse, Data dimensions, facts and measures.
7) Work with dimensional data, types of SCD and dimensional modelling.
8) Data modelling in SQL server.
9) Create/Modify database and troubleshoot the issue and provide the solution according.
10) Work with Stored Procedures, Function, Views, Triggers, Joins, Sub-queries, Dynamic SQL etc.
11) Troubleshooting common database issues.
12) Reporting with SQL, SSIS & Power BI.
Worked as a Database Specialist
1) Design, Build, Unit Test SQL stored procedures, Triggers, Complex queries, views and other database objects.
2) Contributing at a senior level to the database design and data preparation by implementing a solid, robust, extensible design that supports key business flows.
3) Writing and optimizing T-SQL statements, Tuning SQL queries and optimize the performance using Indexes, Partitions and Statistics to meet the SLA.
4) Create complex functions, scripts, stored procedures and triggers to support application development.
5) Create Control flow/Data flow to generate extract, reports and data loading using SSIS.
6) Design database for new modules.
7) Responsible for implementation and release of database changes according to agreed timescales and costs.
8) Create/Modify database and troubleshoot the issue and provide the solution according.
9) Work with Stored Procedures, Function, Views, Triggers, Joins, Sub-queries, Dynamic SQL etc.
10) Database development using tables, constraints.
11) Maintain Data Integrity using triggers and constraints.
12) Handle common database procedures such as upgrade, backup, migration etc.
13) Troubleshooting common database issues.
14) Ensure performance, security, and availability of databases.
15) Reporting with SQL, SSIS.
Worked as a Senior SQL Developer
1) Design, Build, Unit Test SQL stored procedures, Triggers, Complex queries, views and other database objects.
2) Write and optimize T-SQL statements, Tuning SQL queries and optimize the performance of existing objects
3) Create complex functions, scripts, stored procedures and triggers to support application development.
4) Create Control flow/Data flow to generate extract, reports and data loading using SSIS.
5) Data warehouse, Data dimensions, facts and measures.
6) Work with dimensional data, type of SCD and dimensional modelling.
7) Design database for new modules.
8) Responsible for implementation and release of database changes according to agreed timescales and costs.
9) Create/Modify database and troubleshoot the issue and provide the solution according.
10) Work with Stored Procedures, Function, Views, Triggers, Joins, Sub-queries, Dynamic SQL etc.
11) Database development using tables, constraints.
12) Maintain Data Integrity using triggers and constraints.
13) Handle common database procedures such as upgrade, backup, migration etc.
14) Troubleshooting common database issues.
15) Ensure performance, security, and availability of databases.
17) Reporting using SQL, SSRS, SSIS & Power IB.
Worked as a MS SQL Developer.
1) Create complex functions, scripts, stored procedures and triggers to support application development.
2) Design database for new modules.
3) Responsible for implementation and release of database changes according to agreed timescales and costs.
4) Create/Modify database and troubleshoot the issue and provide the solution according.
5) Work with Stored Procedures, Function, Views, Triggers, Joins, Sub-queries etc.
6) Database development using tables, constraints.
7) Maintain Data Integrity using triggers and constraints.
8) Write and optimize T-SQL statements.
9) Handle common database procedures such as upgrade, backup, migration etc.
10) Troubleshooting common database issues.
11) Ensure performance, security, and availability of databases.
Worked as a MS SQL Developer.
1) Create complex functions, scripts, stored procedures and triggers to support application development.
2) Design database for new modules.
3) Responsible for implementation and release of database changes according to agreed timescales and costs.
4) Create/Modify database and troubleshoot the issue and provide the solution according.
5) Work with Stored Procedures, Function, Views, Triggers, Joins, Sub-queries etc.
6) Database development using tables, constraints.
7) Maintain Data Integrity using triggers and constraints.
8) Write and optimize T-SQL statements.
9) Handle common database procedures such as upgrade, backup, migration etc.
10) Troubleshooting common database issues.
11) Ensure performance, security, and availability of databases.
Bachelor of Computer Science
URL removed due to policy violation. Please contact support for further information.