Sql Server Database Administrator
- Ihcs Technologies
- 5 - 9 years
- Vadodara
- 1 month ago
- Email to a friend
- Report this job
Job Description
Job Description
Responsibilities for the Database Administrator SQL Server
Install, configure, and maintain SQL Server instances
Configure and administer high availability and disaster recovery solutions, such as Always on Availability Groups to ensure business continuity and data availability
Monitor database performance, identify bottlenecks and areas for improvement, and proactively tune queries and configurations to ensure optimal performance
Apply patches and updates to SQL Server instances and other related software, ensuring minimal disruption to business operations
Deploy SQL scripts to multiple databases using 3rd party or custom tools
Debug and troubleshoot database issues and collaborate with development teams to resolve them.
Automate routine database administration tasks using scripts
Regularly refresh lower environments with production database backups
Implement and maintain database security policies and procedures, ensuring compliance with industry standards and regulations
Develop and implement backup and restore strategies to protect data against loss or corruption and perform regular backups
Plan and execute database migrations to new hardware, software versions, or cloud platforms, and ensure data consistency and integrity during the migration process
Develop and maintain database documentation, including procedures, diagrams, and technical specifications, to facilitate knowledge sharing and ensure compliance with regulatory requirements
Perform daily and operational database tasks
Design and implement backup policies
Be available for on-call support as needed
Qualifications of the Database Administrator SQL Server
Bachelor's degree or equivalent
Certifications in SQL Server
5+ years of experience
Experience in in Always on High Availability solutions and best practices
Experience in SQL Server installation and configuration
Experience in SQL Server security
Experience in database backup, restore and recovery
Experience in query tuning and optimization
Experience in debugging and troubleshooting database issues
Experience in database maintenance tasks such as backups, restores, and recovery
Experience in database migration
Experience with PowerShell scripting for automating routine tasks.
Experience working with Amazon Web Services
Experience with database migration to AWS
Experience in working with a ticketing system and managing tickets
Knowledge, Skills, and Abilities of the Database Administrator SQL Server
Ability to apply patches and updates to SQL Server instances and other related software
Knowledge of performance tuning techniques, including query optimization and indexing
Ability to implement encryption for sensitive data
Strong documentation skills for documenting database architecture, configurations, and processes
Ability to provide standby support for critical database issues
Ability to troubleshoot and resolve database issues
Understanding of SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS)
Knowledge of T-SQL programming language
Strong written and verbal communication skills, with the ability to effectively communicate with technical and non-technical stakeholders
Strong analytical and problem-solving skills
Ability to work independently and in a team-oriented environment
Working knowledge of MySQL or Aurora MySQL
SQL Server database administration experience in a Healthcare or SaaS domain
Familiarity with Splunk, SQL Sentry
Kindly Note: -
Work Location: - Vadodara, Gujarat (Work from Office only)
Shift Timings: - 1:30 PM to 10:30 PM (IST)
Job Classification
Industry: IT Services & ConsultingFunctional Area / Department: Engineering - Software & QARole Category: DBA / Data warehousingRole: Database AdministratorEmployement Type: Full timeContact Details:
Company: Ihcs TechnologiesLocation(s): Vadodara
Keyskills: SQL Server Administration SQL SSRS migration SSIS AWS
Similar positions
Ihcs Technologies
Greetings from IHCS Technologies India Private Limited. (Formerly known as MD Online Asia Technologies) About Us:- Insync HCS is an EHNAC accredited health care technology company that works closely with providers, payers and others in the industry to increase electronic...
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in