Description

POSITION SUMMARY:

Responsibilities

• Database Design and Implementation:

• Design, implement, and maintain MSSQL databases that meet organizational needs.
• Collaborate with application developers to define database structures, tables, and relationships.

• High Availability Management:

• Implement and manage high availability solutions such as database clustering, mirroring, and AlwaysOn Availability Groups to ensure continuous database access.

• Monitoring and Alerting

• Set up monitoring systems to track database performance metrics.
• Respond to alerts promptly and proactively address potential issues.

• Capacity Planning

• Monitor database usage trends and plan for capacity needs.
• Scale resources as necessary to accommodate growing data and user requirements.

• Backup and Recovery Operations:

• Execute regular database backups and validate their integrity.
• Conduct periodic recovery drills to ensure a quick and effective response in case of data loss.

• Performance Tuning and Optimization:

• Monitor database performance and optimize queries for maximum efficiency.
• Implement best practices for performance and scalability.
• Identify and resolve performance bottlenecks through query optimization, index tuning, and other performance-enhancing techniques.

• Security Management:

• Conduct security audits and implement measures to address vulnerabilities.
• Regularly review and update security protocols to protect against unauthorized access.

• Upgrades and Patch Management:

• Stay informed about the latest MSSQL patches and updates.
• Plan and execute patch deployments in a timely and organized manner.
• Stay current with MSSQL releases and features.

• Incident Response:

• Respond to and resolve database-related incidents promptly.
• Document incident details and implement preventive measures to avoid future occurrences.

• Automation and Scripting:

• Develop and implement scripts for routine tasks, automation, and monitoring.
• Explore opportunities for process automation to improve efficiency.

• Create and maintain documentation for database configurations, processes, and procedures.
• Ensure that documentation is up-to-date and accessible to the team.

• Work collaboratively with cross-functional teams, including developers, system administrators, and network engineers.
• Provide technical support and guidance to team members.

Qualifications

• Education:

• Bachelor’s degree in computer science, Information Technology, or a related field

• Experience:

• Proven 8-10 years’ experience as a Database Administrator with a focus on MSSQL.
• Experience in database design, implementation, performance tuning, and troubleshooting.

• Skills:

• Proficiency in MSSQL administration, including installations, configurations, and upgrades.
• Strong knowledge of database security best practices.
• Excellent problem-solving and analytical skills.
• Familiarity with backup and recovery processes.

• Certifications:

• Microsoft Certified: Azure Database Administrator Associate (optional but preferred).

• Communication:

• Strong verbal and written communication skills.
• Ability to communicate technical information to non-technical stakeholders.

Knowledge, Skills, and Attributes

• SSIS, SSRS, SnowFlake, t-SQL, PowerBI, PowerShell