Description
Roles & Responsibilities
• Create, maintain, and administer SQL Server databases.
• Ensure the databases are highly secure, available, and recoverable.
• Proactively monitor and tune the databases for maximum performance.
• Install, configure, and patch database software and complete database migrations and upgrades.
• Support web application development, with a focus on helping the team interact with the database in the most efficient and productive way possible.
• Troubleshoot and solve database and application coding problems
• Deploy the database components for new versions of our web applications to test and production environments.
• Implement or advise on implementation of high availability (HA) and disaster recovery (DR) solutions.
• Perform SQL Server version upgrades.
• Perform SQL Server migrations from on- premises to cloud.
Key Requirement
• 2+ years of development and / or DBA experience in Relational Database Management Systems [RDBMS] (MySql, SQLServer, etc.)
• Strong performance tuning skills in a very large database environment
• Ability to run trace reports and analyze results, then to recommend options for problem resolution
• Proficient with SQL
• Deep understanding of database installation and configuration
• Experience with database encryption and backup/recovery methodologies
• Excellent data modelling skills (relational, multi-dimensional) and proficiency in one of the programming languages preferably Python.
• Knowledge in a Cloud Platform (AWS)
(ref:hirist.com