Randstad
Sql architect
Randstad, Princeton, New Jersey, us, 08543
job summary:Work Location:
HYBRID - Princeton, NJ
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, S3location: Princeton, New Jerseyjob type: Contractsalary: $45 - 52 per hourwork hours: 8am to 4pmeducation: No Degree Required
responsibilities:
Install, configure, upgrade, and patch MS SQL Server databases. Well-versed 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 on-premises 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 high-availability solutions, including SQL Server clustering, Always-On 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.qualifications:
Experience level: ExperiencedMinimum 12 years of experienceEducation: No Degree Required
skills:
SQL
Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.
At Randstad Digital, we welcome people of all abilities and want to ensure that our hiring and interview process meets the needs of all applicants. If you require a reasonable accommodation to make your application or interview experience a great one, please contact HRsupport@randstadusa.com.
Pay offered to a successful candidate will be based on several factors including the candidate's education, work experience, work location, specific job duties, certifications, etc. In addition, Randstad Digital offers a comprehensive benefits package, including health, an incentive and recognition program, and 401K contribution (all benefits are based on eligibility).
This posting is open for thirty (30) days.
HYBRID - Princeton, NJ
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, S3location: Princeton, New Jerseyjob type: Contractsalary: $45 - 52 per hourwork hours: 8am to 4pmeducation: No Degree Required
responsibilities:
Install, configure, upgrade, and patch MS SQL Server databases. Well-versed 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 on-premises 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 high-availability solutions, including SQL Server clustering, Always-On 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.qualifications:
Experience level: ExperiencedMinimum 12 years of experienceEducation: No Degree Required
skills:
SQL
Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.
At Randstad Digital, we welcome people of all abilities and want to ensure that our hiring and interview process meets the needs of all applicants. If you require a reasonable accommodation to make your application or interview experience a great one, please contact HRsupport@randstadusa.com.
Pay offered to a successful candidate will be based on several factors including the candidate's education, work experience, work location, specific job duties, certifications, etc. In addition, Randstad Digital offers a comprehensive benefits package, including health, an incentive and recognition program, and 401K contribution (all benefits are based on eligibility).
This posting is open for thirty (30) days.