MS-SQL Administration -L3 || Princeton NJ (Day 1 Onsite Hybrid ) || Long Term Contract

Day 1 Onsite ( Hybrid 2-3 Days In a week )

Hi,

Please share your interest and resume at mansi@centraprise.com

Position: MS-SQL Administration -L3

Location: Princeton NJ

Duration: Long Term Contract

Position Description:

Years of exp Required: 10+ Years

Summary:

As an MS SQL (Level 3), responsibility includes overseeing the Design, Provide consulting, administration, configuration, and maintenance of MS SQL Server databases.. The role encompasses ensuring optimal performance, security, and reliability in both environments, collaborating closely with the IT team to meet business requirements.

Qualifications:

- Bachelor's or master's degree in computer science, Information Technology, or related field.

- 10+ years of experience in database administration or engineering, with a strong focus on MongoDB and Oracle.

- Proven experience leading and managing technical teams.

- Expertise in database design, performance tuning, and optimization.

- Proficient in SQL and database scripting.

- Experience with database security practices and disaster recovery planning.

- Strong problem-solving skills and the ability to work under pressure.

- Excellent communication and interpersonal skills.

Technical expertise (MS SQL):

Experience with SQL Server features such as AlwaysOn Availability Groups, Database Mirroring, and Log Shipping.

Proficiency in SQL Server Performance Tuning and Query Optimization techniques.

Familiarity with SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS).

Knowledge of database migration tools and techniques for seamless data movement between environments.

Experience with database security auditing and compliance requirements, including GDPR, HIPAA.

Understanding of database backup and recovery strategies, including full, differential, and transaction log backups.

Key Responsibilities:

Administer and maintain MS SQL Server databases, including installation, configuration, backup, recovery, and troubleshooting.
Perform regular database maintenance tasks such as index maintenance, database optimization, and query tuning to ensure optimal performance.
Monitor MS SQL Server performance and resource utilization, identifying and resolving performance bottlenecks.
Implement and maintain database security measures, including user access controls, encryption, and data masking.
Plan and execute MS SQL Server upgrades, patches, and migrations, minimizing downtime and disruptions to business operations.
Collaborate with application developers to design and implement database solutions that meet business requirements.
Provide technical support and troubleshooting assistance to users and developers, resolving database-related issues in a timely manner.

Administer and maintain Hadoop clusters and associated technologies, including installation, configuration, and troubleshooting.
Monitor Hadoop cluster performance and resource utilization, proactively identifying and resolving bottlenecks.
Implement and enforce security policies and access controls for Hadoop clusters, ensuring compliance with regulatory standards.
Plan and execute upgrades, patches, and migrations for Hadoop components, minimizing downtime and disruptions to business operations.
Collaborate with data engineers and scientists to deploy and manage big data applications on Hadoop clusters.
Automate routine administrative tasks using scripting languages and configuration management tools.
Monitor system logs and alerts for both MS SQL Server and Hadoop environments, proactively identifying and addressing potential issues.
Document configuration changes, procedures, and troubleshooting steps, maintaining up-to-date documentation for both environments.
Stay updated on the latest developments in MS SQL Server and Hadoop ecosystem technologies and best practices, evaluating and recommending new tools and approaches as necessary.