Database developer

Role Overview: You will be responsible for maintaining the production servers of multiple environments, creating new users on SQL server, managing SQL Server security, and ensuring database backup and disaster recovery procedures are in place. Your role will also involve testing backups, working with replication, and monitoring, troubleshooting, and optimizing SQL Server performance. Key Responsibilities: - Create and maintain databases - Monitor server performance, database, and transaction log growth, and error logs - Assist database query developers with technical issues and writing efficient queries - Review and optimize SQL queries, store procedures, views, and triggers - Audit DML commands on SQL servers and individual databases - Troubleshoot SQL Server service outages as they occur, including after-hours and weekends - Configure SQL Server monitoring utilities to minimize false alarms - Perform SQL data analysis using queries and Microsoft Excel - Implement high availability concepts like log shipping, replication, mirroring, clustering, etc. - Carry out performance tuning, data migration, server upgrades, and applying patches - Have knowledge of AWS RDS and .NET application projects Qualifications Required: - 6-10 years of experience in Database Administration in SQL Server (2008 r2, 2012, 2014, 2016) - Knowledge of Oracle database would be an advantage - Strong experience in performance tuning, query optimization, and using monitoring tools - Ability to troubleshoot SQL Server-related resource contention - Familiarity with backups, restores, recovery models, database operations, and high availability concepts - Proficient in SQL development, writing and troubleshooting SQL code - Self-starter with the ability to adapt to new challenges and work in a deadline-oriented environment - Good interpersonal and communication skills, both written and verbal - Proficiency in MS Office tools like Excel, Word, and Outlook If you are interested in this role, please share your updated CV directly to hr@bsquare.in for a quick response.,