MS SQL Admin

Overview:The MS SQL Administrator plays a critical role in managing, optimizing, and maintaining the organization's database systems. This position is essential for ensuring data integrity, availability, and security across all platforms. By utilizing advanced technical skills, the SQL Admin works to support the organization's data needs, assists application development teams in database design, and implements industry best practices for performance and reliability. The MS SQL Admin is responsible for installing and configuring SQL Server instances, managing backups, and implementing disaster recovery plans. As the custodian of the data architecture, the SQL Admin must continuously monitor system performance and tune queries to enhance efficiency. With the proliferation of data-driven decisions, this role is vital to safeguarding assets and leveraging data to drive business growth.
• Key Responsibilities:Install and configure MS SQL Server instances.
• Manage database security, including user access and roles.
• Design and implement backup and recovery strategies.
• Monitor and tune database performance and ensure high availability.
• Develop and maintain efficient T-SQL scripts.
• Facilitate database migrations and upgrades.
• Implement replication strategies for data redundancy.
• Create and maintain documentation for the database environment.
• Assist in troubleshooting database-related issues.
• Establish monitoring solutions for database health.
• Coordinate with application developers to optimize database schema.
• Enforce compliance with data governance and regulatory standards.
• Conduct regular database audits and performance assessments.
• Evaluate new database technologies and tools.
• Provide training and support to other IT staff on SQL Server best practices.
• Required Qualifications:Bachelor's degree in Computer Science or related field.
• 4+ years of experience in MS SQL Server administration.
• Strong knowledge of T-SQL programming.
• Experience with performance optimization and tuning.
• Familiarity with SSMS, SSIS, and SSRS tools.
• Understanding of backup and recovery practices.
• Certifications such as MCSA or MCSE in SQL Server are a plus.
• Proven experience in security implementations for SQL databases.
• Ability to collaborate with cross-functional teams.
• Excellent problem-solving and analytical skills.
• Strong communication and interpersonal skills.
• Experience in cloud database management (Azure, AWS) preferred.
• Knowledge of data modeling and normalization principles.
• Ability to work under pressure and meet deadlines.
• Experience with automated monitoring and alerting tools.
• Passion for learning new technologies and best practices.

Skills: alerting tools,backup and recovery,database management,ssms,cloud database management,t-sql programming,ssrs,sql server,disaster recovery,performance tuning,automated monitoring,performance optimization,database security,normalization principles,ms sql server administration,security implementation,database,data modeling,ssis