In charge of database backup and recovery methods, database access security and integrity, physical data storage design, and Cloud data storage administration.
Assists in the selection of a database management system and the maintenance of database performance.
Install, configure, and deploy MS SQL Server.
Perform capacity planning, performance turning, monitoring, troubleshooting and optimization of the databases.
Download and install SQL Server service packs and updates.
Configure and maintain SQL Security controls.
Make recommendations for system architecture per Microsoft SQL Server best practices.
Manage database backup and recovery, as well as disaster recovery planning, in coordination with the IT manager and System Engineer.
Create, change, and improve SQL Server Agent tasks and maintenance plans.
Proactively monitor SQL Server maintenance tasks, troubleshoot failed processes, and address issues as soon as possible.
Optimize query plan caching and reuse to minimize compilation overhead and improve response times.
In charge of T-SQL query tuning and develop and maintain SSIS packages.
In charge of database migrations and server updates, Migrate Databases from On-Premises to Azure using tools like DMA, DMS, BACPAC and Export/Import.
Make decisions on who gets access to certain parts of the data ensuring the employees can only access the information they need without compromising the security.
Work with other departments, like the IT team and software developers to make sure databases meet company needs and changes are implemented smoothly.
Perform activities to include VMware deployments, maintain resolution to critical break/fix escalations.
Create and manage database reports, visualizations, and dashboards as well as authoring and modifying SQL Server Reporting Services reports.
Collaborate with developers, analysts, and other stakeholders to ensure that databases meet business needs and requirements.
Collaborate with cloud architects and engineers to design and implement cloud infrastructure for database systems.
Make provision, configure, and maintain virtual machines and containers in cloud environments (e.g., AWS EC2, Azure VMs). Manage and optimize cloud storage solutions (e.g., AWS S3, Azure Blob Storage) for performance, cost, and data durability.
Implement and manage monitoring, alerting, and logging solutions for cloud-based systems (e.g., AWS CloudWatch, Azure Monitor). Requirements: Masters degree in Computer Science, Computer Applications or related or foreign equivalent plus 12 months of experience in the job offered and 12 months of experience in using tools like DMA, DM, BACPAC and in configure virtual machines in cloud environments using AWS EC2 and Azure.