Database Consultant

Collabera; West Valley City (UT); On-site; USD 80,000 - 120,000; Full time

Benefits offered by this job

Paid vacations

Medical insurance

401K retirement plan

Disability Insurance

Life Insurance

Job summary

A leading IT staffing firm is seeking a Database Consultant to ensure the performance and security of MySQL databases. This role involves preparing documentation, working on MySQL implementation, and guiding teams in database migration. The ideal candidate will have over 5 years of experience with MySQL and skills in SQL optimization. The position offers a comprehensive benefits package and opportunities for professional growth.

Qualifications

• Minimum 5 years proficiency in MySQL database management.
• Experience with recent versions of MySQL.
• Knowledge of MySQL’s storage engines like InnoDB and RocksDB.

Responsibilities

• Ensure performance, scalability, security, and availability of MySQL databases.
• Prepare documentation, best practices, and specifications.
• Work as an expert on MySQL implementation and design.

Skills

MySQL database management

SQL optimization

Code versioning (Git / SVN)

E/R Diagramming tools

NoSQL databases (MongoDB)

Job description

Established in 1991, Collabera has been a leader in IT staffing for over 22 years and is one of the largest diversity IT staffing firms in the industry. As a half a billion dollar IT company, with more than 9,000 professionals across 30+ offices, Collabera offers comprehensive, cost-effective IT staffing & IT Services. We provide services to Fortune 500 and mid-size companies to meet their talent needs with high quality IT resources through Staff Augmentation, Global Talent Management, Value Added Services through CLASS (Competency Leveraged Advanced Staffing & Solutions) Permanent Placement Services and Vendor Management Programs.

Collabera recognizes true potential of human capital and provides people the right opportunities for growth and professional excellence. Collabera offers a full range of benefits to its employees including paid vacations, holidays, personal days, Medical, Dental and Vision insurance, 401K retirement savings plan, Life Insurance, Disability Insurance.

Job Description

Our top direct client is looking for a Database Consultant

The client is a Fortune 50 multi-billion dollar revenue generating organization with a spectrum of products and services throughout major operating businesses

Job Responsibilities

• Ensure performance, scalability, security, and availability of MySQL databases.
• Prepare documentation, best practices, and specifications.
• Work as an expert on MySQL implementation and design
• Profile server resource usage, optimize and tweak as necessary
• Provide guidance and expertise on tuning MySQL implementation
• Help engineering teams migrate from Oracle to MySQL.

Qualifications

Tools/skills:

• Proficient understanding of code versioning tools such as Git / SVN
• E/R Diagramming tools

Must Have Skills:

• Proficiency in MySQL database management, minimum 5 years.
• Experience with recent versions of MySQL
• Understanding of MySQL’s underlying storage engines, such as InnoDB and RocksDB
• Experience with replication configuration in MySQL
• Knowledge of de-facto standards and best practices in MySQL
• Proficient in writing and optimizing SQL statements
• Knowledge of MySQL features, such as its event scheduler
• Experience on architecting and designing MySQL databases
• Familiarity with NoSQL databases such as MongoDB
• Knowledge of limitations in MySQL and their workarounds in contrast to other popular relational databases

Additional Information

To set up an interview for this position, feel free to contact: