Hi,
Please share your interest and resume at himanshu@centraprise.com
MySQL 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:
The Level 3 SQL and MySQL Administrator oversees advanced administration tasks for MySQL database systems. Responsibilities include optimizing performance, ensuring reliability, and providing expert support for both production and development environments. Collaboration with application developers, technical leadership, and adherence to industry standards are key aspects of this role. Strong problem-solving skills and expertise in both Windows Server and MySQL administration are essential.
SQL / MySQL Database Administration:
- Deploy, configure, and manage MySQL database servers in high availability environments, ensuring optimal performance and reliability.
- Design and implement database schema, indexing strategies, and partitioning to optimize query performance and enhance scalability.
- Develop and maintain database backup and recovery procedures, including regular backups, point-in-time recovery, and disaster recovery planning.
- Perform database performance tuning and optimization, including query optimization, resource utilization analysis, and database cache management.
- Monitor database health and performance metrics, identify bottlenecks, and implement corrective actions to ensure optimal database performance.
- Implement and manage database security measures, including user access controls, authentication mechanisms, and data encryption.
- Collaborate with application developers to troubleshoot database-related issues and optimize database queries for improved application performance.
- Provide expert support for production Application databases with respect to availability, reliability, and integrity.
- Provide expert support for Applications databases in the development and test environments.
- Work with Application developers and their logical data models, create physical Application database designs which conform to industry standards (e.g., data normalization), optimize performance, and efficiently utilize disk space, size tables, and indexes for production implementation based on projected row counts provided by Applications.
- Create complex new databases and Application database objects (e.g., tables, indexes, procedures), and as requirements change, update data structures/objects in existing databases.
- Coordinate production database deployment including tasks to promote database objects between environments (e.g., test to production) in support of Application requirements.
- Provide technical leadership to Application developers in database capabilities and features, build efficient queries, database design, Application database Problem Resolution, and the use of database utilities.
- Determine and implement appropriate Application database backup and recovery strategies, including decisions regarding frequency of backup and procedures for recovering Application database changes.
- Perform production database recovery when necessary.
Qualifications:
- Bachelor's degree in computer science, Information Technology, or a related field.
- Minimum of 10 years of hands-on experience in SQL/MySQL database administration.
- Relevant certifications such as MCSE (Microsoft Certified Solutions Expert), MCSA: SQL Server, and MySQL Database Administrator Certification are highly preferred.
- Strong analytical and problem-solving skills, with the ability to think critically and strategically.
- Excellent communication and interpersonal skills, with the ability to collaborate effectively with cross-functional teams and stakeholders.
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.
