Database Engineer

Job Details: Job Title: Database Engineer Location: Foster City, CA 94404 Duration: 6+ Months Pay rate range: $80.00 - $87.00/hour on W2. Job Description: • As a Database Engineer at Client, you will design, build, and operate scalable, secure data stores that power our applications and analytics. • You’ll partner closely with application and data teams to shape schemas, tune performance, and automate operations using AWS and infrastructure-as-code. • Your work will improve reliability, reduce cost, and accelerate delivery from development through production. Responsibilities: • Design and develop efficient, scalable database solutions aligned to business requirements. • Install, configure, and upgrade database software and related tooling. • Monitor performance and optimize queries, indexes, and schemas for reliability and speed. • Implement and maintain database security controls to protect sensitive data. • Collaborate with application developers to optimize schema designs and SQL. • Troubleshoot incidents and provide timely resolution across environments. • Develop and maintain documentation for architecture, configuration, and runbooks. • Perform capacity planning and recommend infrastructure improvements. • Manage and support AWS database infrastructure (e.g., RDS/Aurora/Redshift). • Stay current on emerging database technologies, patterns, and best practices. Must Have: DB operation person who can manage mainly the PostgreSQL, MySQL databases. Strong in database fundamental with the Postgres and My SQL. Strong database fundamentals, who can do operational work, as well as work with developers and optimize it Qualifications: • Strong understanding of AWS and IaC for database resources. • Proven experience as a Database Engineer/DBA. • Deep knowledge of DBMSs (e.g., PostgreSQL, MySQL, SQL Server, Redshift). • Proficiency in SQL and query optimization. • Solid grasp of data modeling, normalization, and schema design principles. • Hands-on experience with performance tuning and monitoring. • Understanding of backup/restore and disaster recovery procedures. • Knowledge of database security best practices. • Excellent problem-solving, analytical, communication, and collaboration skills. • Ability to thrive in a fast-paced, dynamic environment.. Employee Benefits: At LanceSoft, full time regular employees who work a minimum of 30 hours a week or more are entitled to the following benefits: Four options of medical Insurance Dental and Vision Insurance 401k Contributions Critical Illness Insurance Voluntary Permanent Life Insurance Accident Insurance Other Employee Perks EEO Employer: LanceSoft is a certified Minority Business Enterprise (MBE) and an equal opportunity employer. We prohibit discrimination and harassment of any kind based on race, color, sex, religion, sexual orientation, national origin, disability, genetic information, pregnancy, or any other protected characteristic as outlined by federal, state, or local laws. This policy applies to all employment practices within our organization, including hiring, recruiting, promotion, termination, layoff, recall, leave of absence, compensation, benefits, training, and apprenticeship. LanceSoft makes hiring decisions based solely on qualifications, merit, and business needs at the time.