• Identify system requirements for new or/and existing applications
• Monitor daily operations and address potential issues
• Participate and contribute to Architecture and Design Solutions.
• 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 documentation for database applications.
• Memory management for database systems.
• Develop database schemas, tables, and dictionaries.
• Ensure the data quality and integrity in databases.
• Fix any issues related to database performance and provide corrective measures.
• Create complex functions, scripts, stored procedures, and triggers to support application development.
• Take regular database backup.
• Test databases and perform bug fixes.
• Provide authentication and authorizations for Database
• Develop best practices for database design and development activities.
• Experience in MS SQL Server Performance Tuning along with SQL profiler, query optimization, Database consistency check using DBCC
• Tuning / Monitoring SQL Server / Application Performance due to slow queries via profiler, query execution plan, index, and Tuning T-SQL queries to improve performance.
• Knowledge in SQL Server Reporting Services (SSRS)
• Schedule jobs, batch, alert, and email notification settings

Additional Responsibilities:

• Learning & Knowledge sharing
• Actively participate in training activity
• Actively participate and contribute to Organizational Goals
• Actively participate and contribute to Internal Audits
• Participate in requirement gathering, analysis and feasibility study

Technical Skillset:

• Excellent understanding of Microsoft SQL Server
• Skilled at optimizing large, complicated SQL statements.
• Experience in Report Development using complex SQL.
• Analyze existing SQL queries for performance improvements.
• Develop procedures and scripts for data migration.
• Discuss Requirements with Stakeholders and Develop SQL for Reporting.
• Experience in debugging data-related issues.
• Passionate about creating good design and usability.
• A team player with excellent communication skills

Knowledge of Tools

• Knowledge of tools: MS SQL Server

Soft Skills

• Ability to communicate clearly with both business and technical teams and be able to present to senior stakeholders
• Excellent English verbal and written communication skills
• Strong logical, analytical, and problem-solving skills
• The candidate should be Highly Motivated and a Self-Starter at work
• Identify & refers prospective candidates
• Takes professional ethics such as punctuality, dress-code, meetings very seriously
• Identifies and proposes alternative ways of solving a business problem
• Demonstrates awareness of individual and group dynamics