· Lead the upgrade of our platform from SQL 2012 to SQL 2019, ensuring comprehensive updates to all functions, including stored procedures, Windows services, and the database.
· Optimize database queries and rewrite existing code to enhance system performance and efficiency.
· Oversee the migration of our current hosted environment, including web servers, application servers, and database servers, to Amazon Web Services (AWS).
· Establish a secure AWS environment, including setting up web servers, application servers, and database servers, with appropriate firewall protection and port management.
· Facilitate the secure setup of VPN connections during the migration to AWS, collaborating with Network Administrators as needed.
· Implement load balancing within the AWS environment to ensure efficient distribution of inbound traffic across web servers and maintain seamless connectivity with application and database servers.
· Ensure adherence to best practices in database design, deployment, management, and performance optimization, with a strong understanding of AWS tools and certifications, such as the AWS Certified Database \u2013 Specialty.
· Provide guidance and expertise on AWS migration processes, security measures, and system optimization, contributing to a smooth transition and ongoing system improvement.
Current Applications/Tools Used: Angular, .NET, and SQL 2012
About the Position:
The platform is Microsoft. They use Angular, .NET, and SQL 2012 (and need to migrate to SQL 2022).
The first project will be to upgrade us from SQL 2012 to SQL 2022, so the individual we desire will have knowledge in SQL 2022 and experience migrating from SQL 2012 to SQL 2022. They expect this will require updating all functions (including stored procedures and Windows services), in addition to the databases. They have two full time .NET Windows Developers who will assist with the migration.
Ongoing projects will involve traditional SQL DBA work, such as setting up and managing backups, optimizing database queries and stored procedures to improve performance. Experience with Windows services and API calls is beneficial but not required.
Location: Anywhere
Posted: Sept. 16, 2024, 7:27 a.m.
Apply Now Company Website