At Hallmark Labs, you will work with developers and business stakeholders to understand the business needs for data and create, maintain, and monitor secure and highly performant databases. You are passionate about data and not only enjoy data schema design, but are comfortable with various DB tools and types of databases. You know that good data and well designed and maintained databases are critical to any business.

This job involves the following responsibilities:

Basic Qualifications:

Preferred Qualifications:

In compliance with the Immigration Reform and Control Act of 1986, Hallmark Labs will hire only individuals lawfully authorized to work in the United States.  Employment by Hallmark Labs is contingent upon the signing of the Employment Agreement, completing Form I-9 Employment Eligibility Verification and satisfactory reference and background checks.

Hallmark Labs is an equal employment opportunity employer. Qualified applicants will be considered for employment without regard to race, color, religion, sex, age, pregnancy, national origin, physical or mental disability, genetics, sexual orientation, gender identity, veteran status, or any other legally-protected status. To view your rights as an applicant please review the following EEO posters: “EEO is the Law” poster and the “EEO is the Law Supplement”  

Desired Skills and Experience

  • Install, configure and maintain MySQL and PostgreSQL databases
  • Optimize and tune database performance and SQL queries
  • Improve monitoring, perform database capacity and usage planning
  • Assist developers with query tuning and schema design
  • Write and maintain scripts to automate tasks
  • Troubleshoot database-related application performance issues
  • Perform tests and evaluations regularly to ensure data security and integrity
  • Ensure security and data integrity of databases
  • Perform routine, periodic and proactive maintenance
  • Implement tools to automate database operation and monitoring
  • Backup/recovery, replication, cluster failover and disaster recovery
  • BS/MS in Computer Science, Engineering, related field, or equivalent experience or relevant certification
  • 4+ years of experience as a Database Administrator
  • 4+ years of SQL experience
  • 2+ years of performance tuning
  • 2+ years of disaster recovery and backup experience
  • 2+ years of professional experience with MySQL or PostgreSQL
  • Highly proficient in all aspects of database administration, including backup/recovery/replication, clustering, advanced performance tuning, and proactive monitoring
  • Familiarity with microservice data schema design
  • eCommerce experience 
  • Experience with AWS
  • Experience with DB monitoring tools such as Monyog
  • Experience with configuration management tools such as Chef and Puppet
  • Able to read and understand ERDs
  • Familiarity with iterative software development
  • Experience with NoSQL DBs such as MongoDB and Redis
  • Experience with high availability configurations