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 skills

Requirements :

- 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