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
Have good knowledge of implementation SAAS architecture
Automate deployments using CI/CD
Have good knowledge of deployment to multiple databases with zero downtime
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
Implement SSIS (SQL Server Integration Services), SSRS (SQL Server Reporting Services)
Have strong data management skills
Have good understanding of indexing, querying, and normalization
Have good understanding of relational database management system
Have good understanding of database integrity and security
Have 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
Have at least 5+ years integrating SQL Server solutions in .NET environments, with working knowledge of C#, ASP.NET, and SOA with web services
Have excellent attention to detail, ability to detect and correct problems within SQL scripts
Have sense of ownership and pride in your performance and its impact on company's success
Be a critical thinker and problem-solving skills
Be a team player
Have good time-management skills
Have great interpersonal and communication :
Designing, testing, and debugging software applications using SQL Server
Collaborating with cross-functional teams to gather and analyze requirements
Help write and optimize in-application SQL statements
Ensure performance, security, and availability of databases
Prepare documentations and specifications
Handle common database procedures such as upgrade, backup, recovery, migration, etc.
Profile server resource usage, and optimize and tweak as necessary
Collaborate with other team members and stakeholders
