Database Administrator - SQL

Role : SQL Database Administrator Job description : - Design, implement, and manage SQL Server instances deployed on Microsoft Azure. - Develop and execute comprehensive backup and recovery strategies for all databases, ensuring data integrity and availability. - Proactively monitor and optimize database performance to guarantee responsiveness and high uptime. - Identify and troubleshoot database issues efficiently, minimizing downtime and impact on business operations. - Implement robust access controls and user permissions to safeguard database security. - Formulate and enforce database security policies and procedures to maintain a strong security posture. - Perform routine database maintenance tasks, including index optimization and statistical updates. - Collaborate with developers to provide guidance on query tuning and schema design best practices. - Maintain a strong understanding of the latest advancements in SQL Server and Azure cloud technologies. - Participate in capacity planning initiatives to effectively allocate resources for optimal database operations. - Document database configurations, procedures, and troubleshooting steps for comprehensive knowledge transfer. - (Preferred) Leverage database-related tools to automate and streamline ETL (Extract, Transform, Load) processes. Qualifications : - Minimum of 3 years of demonstrably successful experience in SQL Server administration. - Proven track record of designing, implementing, and maintaining robust database solutions. - In-depth knowledge of Transact-SQL (T-SQL) for database querying, scripting, and automation. - Strong understanding of fundamental database concepts, including normalization, indexing, and security best practices. - Experience working in a cloud environment (Azure certification is a significant advantage). - Excellent problem-solving and analytical skills with the ability to effectively diagnose and resolve complex database issues. - Strong communication and collaboration skills to foster productive working relationships with developers and other IT professionals. - Ability to work independently and take ownership of assigned tasks while also demonstrating a collaborative spirit. - Familiarity with database-related tools for ETL processes (e.g., SSIS, Azure Data Factory) is highly desirable. Benefits : - Competitive salary and benefits package. - Opportunity to work with cutting-edge cloud technologies. - Collaborative and supportive work environment. - Professional development opportunities. (ref:hirist.tech)

Location: in, IN

Posted Date: 11/25/2024