SQL Architect HYBRID
SQL Architect HYBRID
Posted on :
07-09-2024
Employer Active
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Share
Send me jobs like this
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Job Description
Work Location: HYBRID Princeton NJ
Responsibilities:
- Install configure upgrade and patch MS SQL Server databases. Wellversed in resolving security violations on MSSQL servers/DB.
- Perform regular database maintenance tasks including backups indexing and integrity checks.
- Design implement and regularly test disaster recovery plans to ensure minimal downtime on onpremises installations.
- Manage and automate backup processes ensuring data availability and integrity using native and 3rd party backup tools like Rubrik AWS Backup service and S3.
- Monitor database performance and proactively tune databases optimizing SQL queries indexes and configurations.
- Identify and resolve performance bottlenecks ensuring high availability and fast response times.
- Design implement and manage highavailability solutions including SQL Server clustering AlwaysOn Availability Groups and database mirroring.
- Configure and monitor replication strategies such as transactional replication merge replication and log shipping to ensure data availability across environments.
- Troubleshoot and resolve high availability and replication issues minimizing downtime and data loss.
- Good understanding of Amazon Web Services (AWS) such as EC2 RDS VPC S3 backup services and other offerings.
Required:
- Candidate should have 12 years of experience with the MSSQL database preferably certified in MSSQL and AWS.
- The candidate should have excellent work experience in MSSQL database Architecture migration to AWS EC2 and knowledge of CLR and SSIS.
- It is good to have experience with other AWS Aurora and RDS (Like Oracle PostgreSQL and MySql).
- MS SQL SSIS Consultant MSSQL database Architecture migration to AWS EC2 and knowledge of CLR and SSIS Rubrik AWS Backup servic S3
Required Skills : SQL
Additional Skills : Database Architect
Employment Type
Full Time
Key Skills
Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.
