04 feb
XpertGo Talent Solutions
Xico
**Job Overview**Senior Azure/On Prem MS SQL Database Administrator will be responsible for the management of production and non- production databases; database maintenance activities; troubleshooting database-related issues; monitoring of database capacity and performance; installation, administration, and configuration of database server/instances/databases; installation and configuration of SSRS; Support release/code deployment activities (SSIS Packages, SSRS reports, SQL objects etc.
)**Essential Functions**Conduct the following for Azure SQL/Azure SQL MI/SQL on Azure VM, On Prem SQL Server, SSRS, SSIS,
Azure Synapse and other related products as applicable and necessary- Install/Configure/Setup/Administer and Maintain production and non-production environments- Setup High-Availability and Disaster Recovery- Plan and test high availability and disaster recovery- Create Users and assign/manage permissions based on the level of access the user would need; Ensure robust and full proof security of assets- Resolve database integrity, performance, blocking, connectivity, and replication issues.- Detect and resolve database-related CPU, memory, I/O, disk space and other contention issues.- Perform and manage Database backup/recovery/restore and capacity monitoring- Synapse workload management and optimization- Setup SQL agent jobs, elastic jobs and runbook automation- Identify and setup alerts and logging in Azure- Maintain databases - Statistics, Indexes, fragmentation- Conduct Performance tuning and optimization (Stored procedures, Views, Functions,
Queries,database)- Implement operational automation using scripts.Necessary)- Coordinate removal and/or archiving of data that is no longer required to be available in theproduction databases.- Design and create databases to support development initiatives- Support release/code deployment activities- Provide 24x7 support as necessary- Mentor junior/new DBA team members- Manage a team of DBAs if necessary**Qualifications**- Bachelor's Degree- Experience in HA/Failover technologies- Experience in log shipping and DR Environments- Strong Experience in Performance Tuning and Optimization (PTO)- Experience with SQL Server versions 2005 to 2019- Experience running and troubleshooting SSIS packages- Experience troubleshooting performance issues in the SQL ServerTipo de puesto: Tiempo completoSalario: $35,000.00 - $50,000.00 al mesHorario:- Turno de 8 horas
Muestra tus habilidades a la empresa, rellenar el formulario y deja un toque personal en la carta, ayudará el reclutador en la elección del candidato.