Hi,
Please share your interest and resume at himanshu@centraprise.com
MS SQL Database Administration / DBA
Princeton NJ (Onsite- 2 days week)
15+ months contract
Rate- $55 to $60/hr on C2C
Position Description:
Years of exp Required: 10+ Years
Job Description:
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.
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.
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.
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.
Himanshu Kashyap
Centraprise corp
Team Lead
Direct: 469-421-6378 , Ext- 125
www.centraprise.com(E-verify)
We respect your online privacy. If you would like to be removed from our mailing list please reply with "Remove" in the subject and we will comply immediately. We apologize for any inconvenience caused. Please let us know if you have more than one domain. The material in this e-mail is intended only for the use of the individual to whom it is addressed and may contain information that is confidential, privileged, and exempt from disclosure under applicable law. If you are not the intended recipient, be advised that the unauthorized use, disclosure, copying, distribution, or the taking of any action in reliance on this information is strictly prohibited.We are an equal opportunity employer with a diverse workforce.
