AzimuthGRC - Data Base Administrator - SSIS/SSRS

Job Description : - Conduct the 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 - Upgrade and maintain SQL Server and related software (apply patches and updates when necessary) Coordinate removal and/or archiving of data that is no longer required to be available in the production databases. - Deploy and configure SSIS packages and SSRS Reports. - Troubleshoot issues with SSRS and SSIS. - Support release/code deployment activities - Implement operational automation using scripts. - Conduct Performance tuning and optimization (Stored procedures, Views, Functions, Queries, database) - In-depth SQL database advanced performance tuning experience - Stored Procedures, Views, Functions; skilled in analyzing and assessing query execution plans and DMVs; expertise in assessing and implementing indexes and partitioning; Tuning ETL Jobs - SSIS & Azure Data Factory - Design and create databases to support development initiatives - Synapse workload management and : - Bachelor's Degree or related working experience - Overall Experience of 9 to 12 years. - Experience in HA/Failover technologies - Experience in log shipping and DR Environments - Experience with DataSync in Azure and other technologies used in replicating data - 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 Server environment - Good verbal and written communication is a must have (ref:hirist.tech)

Location: in, IN

Posted Date: 11/23/2024