Key responsibilities:
- Design develop implement and maintain database solutions using MS SQL Server ensuring scalability reliability performance and security.
- Develop SQL DB objects as per the design and defined standards.
- Maintain / Writing SQL database schemas and scripts including views stored procedures / Dynamic queries and triggers.
- Extract transform and load (ETL) data from multiple databases to support reference data enhancements and new functionalities.
- Optimize database performance through indexing query optimization and other performance tuning techniques especially for complex data sets.
- Independently analyse solve and correct issues in real time providing problem resolution endtoend.
- Perform scheduled maintenance and support release deployment activities after hours.
- Provide support guidance and collaborate with Application Developers to implement database design & solution.
- Stay up to date with emerging technologies and trends in database management and data engineering.
- Provide support for critical production systems.
- Monitor database performance and troubleshoot issues as they arise working with IT operations teams to resolve problems.
- Collaborate with system DBAs to help implement database changes upgrades and migrations.
Qualifications
- Bachelor s degree in computer science Information Technology or a related field.
- Proven 4 years experience as a Data base Developer or similar role with a focus on MS SQL Server.
- Strong SQL programming skills with the ability to write complex queries stored procedures Functions Views.
- Experience optimizing the performance of webbased applications including identifying and resolving performance bottlenecks particularly with complex data sets.
- Familiarity with database design principles including normalization indexing and data modelling.
- Excellent problemsolving skills and attention to detail.
- Strong communication and collaboration skills with the ability to work effectively in a team environment.
- Experience working in an Agile development environment is a plus.
- Relevant certifications such as Microsoft Certified: Azure Data Engineer Associate or similar are advantageous.
- Experienced in alternate opensource technology is a plus
- Basic programming knowledge on any NoSQL database is a plus.
microsoft sql server,database design,sql server,etl