Create database design and help create tables, SQL statements for data presentation and further automation.
Set up and monitor routine maintenance SQL jobs and develop/maintain an alert strategy for failed jobs and database problems or failures.
Automate deployments using CI/CD, handle team estimations, and delivery.
Modify/update T-SQL scripts for importing and organizing data, work closely with analysts and other department personnel in advising best SQL coding practices.
Manage multiple projects simultaneously within time and budget constraints.
Be responsible for data profiling, source-target mappings, ETL development, SQL tunings, and optimization, testing, and implementation.
Requirements
Strong data management skills.
Good understanding of indexing, querying, and normalization.
Good understanding of relational database management system.
Good understanding of database integrity and security.
At least 5 years using MS SQL, data modelling, including an understanding of all normalized forms, design, and development of stored procedures, views, and triggers.
Integrating SQL Server solutions in .NET environments, with working knowledge of C#, ASP.NET, and SOA with web services.
Critical thinking and problem-solving skills, sense of ownership and pride in performance, and good time-management skills.
Designing, testing, and debugging software applications using SQL Server, collaborating with cross-functional teams to gather and analyze requirements, writing and optimizing in-application SQL statements, ensuring performance, security, and availability of databases, preparing documentations and specifications, handling common database procedures, and optimizing server resource usage
