SQL Database Administrator

Job Role- SQL DBAExperience- 4 to 6 yearsJob Location - Chennai / Hyderabad/ BangaloreStraive is a market leading Content and Data Technology company providing data services, subject matter expertise, & technology solutions to multiple domains. Data Analytics & Al Solutions, Data Al Powered Operations and Education & Learning form the core pillars of the company's long-term vision. The company is a specialized solutions provider to business information providers in finance, insurance, legal, real estate, life sciences and logistics. Straive continues to be the leading content services provider to research and education publishers. Data Analytics & Al Services: Our Data Solutions business has become critical to our client's success. We use technology and Al with human experts-in loop to create data assets that our clients use to power their data products and their end customers' workflows. As our clients expect us to become their future-fit Analytics and Al partner, they look to us for help in building data analytics and Al enterprise capabilities for them. With a client-base scoping 30 countries worldwide, Straive's multi-geographical resource pool is strategically located in eight countries - India, Philippines, USA, Nicaragua, Vietnam, United Kingdom, and the company headquarters in Singapore. Profile Summary -As a SQL Database Administrator, you will be responsible for maintaining, monitoring, and troubleshooting SQL Server performance issues; developed custom scripts for monitoring and collecting performance trending data and responsible for implementing new methods of automating various maintenance processes related to the SQL Server environment. Hands-on experience in setting up and configuring new SQL server transactional push replications. Experience in supporting SQL server replication agent failures, latency issues. Experience in reviewing SQL server Agent jobs, tasks and SSIS packages to monitor in production environment. Experience in T-SQL query analysis, execution plan, performance tuning etc  Maintaining SQL server/Database user access/permissions.All production SQL data database support (database backup/restore, SQL server installation, upgrade and configuration.Experience in troubleshoot application sluggishness and poor performance.Experience in maintain, and administer complex ETL using SQL Server (SSIS). Experience in analyze and understanding SSIS workflow/dataflow tasks to support production jobs and activities. Knowledge of Azure data factory pipelines and Azure SQL Managed Instances. PRB