SQL Database DeveloperRemote
Full stack person with SSO integration. Azure prospective in case of any deployments. How many server instances, server monitoring needs. All deployments of azure. -Different storage accounts from a development point of view.-SQL Tables expert-Azure-Expert in Ingesting XML files & Schemas-Data Migration-A lot of critical thinking and knowledge-discrepancies in data-excellent oral and written communication skills-initiate things to happen-Authentication skills of SSO 10+ years of SQL Experience10+ years of Stored Procedures10+ years Advance Level DB knowledge3+ years Azure We are seeking a highly skilled and motivated SQL Database Developer to join our dynamic IT team. The ideal candidate will be responsible for designing, implementing, and maintaining SQL databases in a fast-paced and challenging environment. As a SQL Database Developer, you will collaborate with cross-functional teams to develop efficient and effective database solutions that meet the organization's business needs. The successful candidate will have a strong background in database design, optimization, and troubleshooting.
Responsibilities:Database Design and Development:Design, develop, and maintain SQL databases to support various applications and business requirements.Create and optimize database schema, tables, views, stored procedures, and functions.Performance Tuning and Optimization:Identify and resolve performance bottlenecks in database systems.Optimize queries for improved efficiency and responsiveness.Data Integration:Collaborate with application developers to integrate database solutions with software applications.Develop and maintain data integration processes for seamless data flow.Database Security:Implement and maintain database security measures to protect sensitive information.Ensure compliance with data protection and privacy regulations.Backup and Recovery:Develop and implement backup and recovery strategies to safeguard data against loss or corruption.Perform regular database backups and conduct recovery procedures when necessary.Documentation:Create and maintain comprehensive documentation for database architecture, configurations, and processes.Keep documentation up-to-date with any changes or enhancements.Collaboration:Collaborate with cross-functional teams, including software developers, system administrators, and business analysts.Provide technical support and guidance to team members.Troubleshooting:Investigate and resolve database-related issues in a timely manner.Conduct root cause analysis for database incidents and implement preventive measures. Qualifications:Bachelor's degree in Computer Science, Information Technology, or a related field.Proven experience as a SQL Database Developer or a similar role.Expert in writing Stored Procedures.Advanced level database knowledge.Proficient with AzureStrong knowledge of relational database management systems (RDBMS) and SQL.Experience with database design, optimization, and performance tuning.Familiarity with data integration and ETL processes.Solid understanding of database security principles and best practices.Proficient in writing complex SQL queries and stored procedures.Excellent problem-solving and troubleshooting skills.Strong communication and collaboration skills. Preferred Qualifications:Certifications in database administration or related areas.Experience with cloud-based database solutions.Knowledge of NoSQL databases.Familiarity with data warehousing concepts.