Noida, Uttar Pradesh, India
Information Technology
Full-Time
Birlasoft
Overview
Area(s) of responsibility
- Install and configure new Microsoft SQL Server instances, including AlwaysOn availability groups and failover clustering.
- Review, analyze, and evaluate business systems and user needs by facilitating brainstorming sessions with stakeholders.
- Highly skilled at SQL server installations, configuration, migration, and optimization
- Responsible for database backup and recovery procedures, access security and database integrity, physical data storage design and data storage management
- Participates in Database Management System selection and maintains database performance.
- Engage in ongoing process improvement.
- Experienced in Database Performance, Maintenance and Development to perform the following:
- Database management including backups, recovery, and maintenance.
- Database management for export, import and mass data loads.
- Analyzes and generation of all tables and index statistics.
- Monitoring and resolving data lock issues.
- Check all statistics related to memory, locks, I/O, database response time, wait events, top sessions, and background processes.
- On-Line Transaction Processing (OLTP) to capture, validate and store large amounts of transactions.
- Create indexes to achieve critical dataset response time for time sensitive reports.
- Install SQL Server service packs/ patches/ fixes and updates.
- Configure and manage SQL Security settings.
- Make system design recommendations according to Microsoft SQL Server best practices.
- Manage database backup & recovery & DR planning in collaboration with IT manager and System Engineer.
- Create, modify, and optimize SQL Server Agent jobs and maintenance plans.
- Proactively monitor SQL Server maintenance tasks, troubleshoot failed jobs, and resolve issues in a timely manner.
- Troubleshoot application slowness and performance issues.
- Responsible for T-SQL query tuning
- Responsible for database migrations and server upgrades.
- Develop documentation and training of routine database administration tasks and train server operations staff on these tasks.
- Perform SQL Server integration with enterprise applications.
- Should have thorough knowledge of Azure databases including (IaaS, PaaS and DbaaS )
- Having knowledge of PostgreSQL, MySQL, MongoDB would be value add.
- Must have thorough knowledge of cloud services including AWS, GCP
- Should be able to provide solutions per customer requirement.
Similar Jobs
View All
16 Hours ago
SAP Functional Architect
Information Technology
- 4000000,00,000 - 4500000,00,000 INR - Annual
- 12 - 15 Yrs
- Bangalore, Chennai
We are seeking an experienced SAP Pre-Sales Architect with a strong functional background and deep expertise in at least one SAP functional area. The ideal candidate will have extensive knowledge of cross-module integrations and a proven track record...
17 Hours ago
SDE
AI & Machine Learning Advancement
- 4 - 8 Yrs
- Bangalore
We are seeking a highly skilled and motivated Data Engineer to join our dynamic AI/Analytics team.
More specifically, you will responsible for:
4 + Years of track record of relevant work experience and a computer Science or related technic...
19 Hours ago
Product Technical Architect - InsurTech SaaS
Information Technology
- 50,00,000 - 60,00,000 INR - Annual
- 12 - 18 Yrs
- Hyderabad
Summary role description:
Hiring for a Product Technical Architect (Node.js) for a global InsurTech SaaS platform provider.
Company description:
Our client is a Silicon Valley HQ, venture-funded, tenured provider of the Ins...
2 Days ago
Technical Business Analyst_Director _Business Analysis
Information Technology
- Bangalore, Karnataka, India
Technical Business Analyst - Director - Software EngineeringProfile DescriptionWe’re seeking someone to join our team as (Director) Technical Business Analyst Will work on technical and functional analysis of platforms/applications and documentation...
2 Days ago
Senior Software Engineer - Ruby on Rails
Information Technology
- Bangalore, Karnataka, India
Job DescriptionOur team is responsible for the core User model for Zendesk. The team’s mission is to optimize the in-product, customer and developer experience for representing our customers’ Users at Zendesk.This role will be joining our team based...
2 Days ago
Data Engineer
Information Technology
- Bangalore, Karnataka, India
Project Role : Data EngineerProject Role Description : Design, develop and maintain data solutions for data generation, collection, and processing. Create data pipelines, ensure data quality, and implement ETL (extract, transform and load) processes...
2 Days ago
Mainframe z/OS System Administrator
Information Technology
- Bangalore, Karnataka, India
Who We AreAt Kyndryl, we design, build, manage and modernize the mission-critical technology systems that the world depends on every day. So why work at Kyndryl? We are always moving forward – always pushing ourselves to go further in our efforts to...
2 Days ago
Test Engineer - L3
Information Technology
- Bangalore, Karnataka, India
Job description:Job Description Role PurposeThe purpose of this role is to prepare test cases and perform testing of the product/ platform/ solution to be deployed at a client end and ensure its meet 100% quality assurance parameters. ͏ Do Instrume...
Talk to us
Feel free to call, email, or hit us up on our social media accounts.
Email
info@antaltechjobs.in