Revalsys Technologies - Lead SQL Database Developer

Key Responsibilities :

• Create database design
• 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

(ref : hirist.tech)