Senior Software Engineering Lead

Role Description As a Senior Database Architect you will be responsible for designing developing and maintaining complex database solutions that meet business and technical requirements You will ensure optimal performance data integrity and high availability while collaborating with cross-functional teams to deliver robust and scalable database systems This role also involves mentoring junior team members and staying abreast of emerging database technologies to drive continuous improvement Responsibilities Design develop and implement database solutions aligned with business requirements and architectural standards Conduct database capacity planning and performance forecasting to ensure scalability Continuously monitor and optimize database performance using advanced tools e g SQL Server Management Studio DMVs Identify and resolve performance bottlenecks through query optimization and indexing strategies Implement and maintain high availability solutions e g Always On Availability Groups Failover Clustering log shipping Develop and regularly test disaster recovery plans for rapid and accurate data restoration Establish and enforce database security policies including user roles encryption and regulatory compliance Perform regular security audits and vulnerability assessments to safeguard sensitive data Design and automate comprehensive backup and recovery strategies to ensure data integrity Collaborate with application development teams to optimize database interactions and facilitate deployments Work with IT operations to ensure seamless integration with infrastructure and cloud services Create and maintain detailed documentation for database architecture maintenance plans and troubleshooting Develop best practices and guidelines for database management and ensure team adherence Mentor and guide junior database administrators and engineers through training and knowledge sharing Foster a collaborative culture focused on continuous learning and innovation Stay current with industry trends and emerging database technologies to enhance systems and processes Provide innovative solutions to improve database performance reliability and scalability Mandatory Skills 8 years of experience in database architecture design and administration Expertise in SQL Server and related technologies e g Always On Availability Groups Failover Clustering Strong knowledge of performance tuning query optimization and indexing strategies Experience in developing and implementing disaster recovery solutions Advanced understanding of database security best practices and regulatory compliance Proficiency in backup and recovery strategies including automation of processes Hands-on experience with database monitoring and optimization tools e g DMVs SQL Server Management Studio Strong documentation skills for database design processes and troubleshooting Good to Have Skills Experience with cloud-based database solutions e g Azure SQL Database AWS RDS Familiarity with other RDBMS systems e g Oracle MySQL PostgreSQL Knowledge of data warehousing and big data technologies Scripting skills for automation e g PowerShell T-SQL Certifications in database management e g Microsoft Certified Azure Database Administrator Soft Skills Excellent problem-solving and analytical skills Strong communication and collaboration abilities Ability to work independently and lead technical initiatives Attention to detail and a commitment to data accuracy and integrity Mentorship and leadership capabilities to guide junior team members Experience Range 8 to 12 years Hiring Location Chennai Trivandrum Kochi Skills Sql Healthcare Database Mysql About Company UST is a global digital transformation solutions provider For more than 20 years UST has worked side by side with the worlds best companies to make a real impact through transformation Powered by technology inspired by people and led by purpose UST partners with their clients from design to operation With deep domain expertise and a future-proof philosophy UST embeds innovation and agility into their clients organizations With over 30 000 employees in 30 countries UST builds for boundless impacttouching billions of lives in the process