Senior Database Developer
Having 810 years of experience in MySQL SQL & ORACLE
Responsibilities:
* Design & Implement the database and data modelling.
* Creating Indexes Views complex Triggers Stored Procedure effective Functions and appropriate store procedures to facilitate efficient data manipulation and data consistency.
* Designing Database writing sequences jobs complex and dynamic queries in SQL MySQL ORACLE.
* Should have good grip on Keys Constraints Indexes Joins CTEs Partitioning Row Number() and Windows function Temporary Tables UDTs Types of Union Metalized views etc.
* Strong analytical and problem solving skills.
* Database Normalization & Denormalization.
* Good command in writing the complex logic.
* Troubleshoot optimize and tune SQL processes and complex SQL queries.
* Should Know how to write unit test cases.
* Understanding of Database Transactions and states.
* Design implement and monitor queries and stored procedure and their performance.
* Able to debug programs and integrate the applications with thirdparty web services.
* Identify opportunities for improved performance in SQL operations and implementations.
* Understanding of database Backup Restore & Maintenance.
* Should have the knowledge about development testing UAT and production environments and their databases.
* Knowledge of Working on SSRS and SSIS. Experience in SSAS will be plus.
* Good communication skills.
performance tuning,database transactions,ssrs,sql query optimization,oracle,de-normalization,triggers,backup and restore,ssas,views,database,indexes,functions,stored procedures,database design,data modeling,unit testing,mysql,database normalization,ssis,sql