Job Description : Responsible to keep the database up and running smoothly 24 / 7. The goal is to provide a seamless flow of information throughout the company, considering both backing data structure and front-end accessibility for end-users.
Key Responsibilities :
Experience with Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools
Experience with backups, restores and recovery models
Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server
Database design, Database Modelling, Normalization.
Reviewing query performance and optimizing code
Writing queries used for front-end applications (websites, desktop applications, or cloud apps)
Working with application developers to create optimized queries
Creating database triggers for automation, e.g., automatic email notifications
Creating table indexes to improve database performance
Programming views, stored procedures, and functions
Perform tests and evaluations regularly to ensure data security, privacy and integrity
Monitor database performance, implement changes and apply new patches and versions when required.
Technical & Strategic :
Excellent knowledge of data backup, recovery, security, integrity and SQL
Hands-on experience with database standards and end-user applications.
Behavioural Competencies :
Must possess - can-do- attitude and a strong drive to take initiative and complete the tasks.
Must be a good team player and should be flexible to work on any assigned tasks and adjust to changing business priorities and plans.
Should be able to work under minimal supervision.
Should be able to work in fast-paced start-up environment
Openly accept personal feedback and provide feedback to the management.