Key Responsibilities
- Designing databases and ensuring their stability, reliability, and performance.
- Design, create, and implement database systems based on the end user's requirements.
- Improve application's performances.
- Prepare documentations for database applications.
- Memory management for database systems.
- Develop database schemas, tables and dictionaries.
- Create complex functions, scripts, stored procedures and triggers to support application development.
Minimum Qualification and Experience
-
2+ years of experience in SQL database development, Performance tuning, application monitoring and support of production applications with distributed teams
Mandatory Skills
- SQL Server - Azure or on premise
- Able to write complex stored procedures
- Database Performance fine tuning and optimization.
- Reporting tools like SSRS or Power BI or Jaspersoft or any other reporting tool
- Experience in impact-analysis and root cause analysis
- Performance tuning, Indexing strategies
- Ability to design and build flexible and extensible systems with focus on code reuse and generation
Desired Skills
- PostgreSQL database
- Knowledge of ETL/ELT processes
- Experience in SSIS, SSAS, Azure Data Factory, Synapse Analytics, Azure Data Bricks, Azure Data Lake
- Unit testing, change management and release procedures for the database code
- Experience in Large scale Data Migration
Competency Requirement
-
Strong communication skills (verbal and written) and an ability to communicate with internal and external customers and all levels of management.
-
Attention to detail and drive for results.
-
Good planning, organizing & time management skills.
-
Should be a very good team player with good interpersonal skills.
