Payactiv is seeking an experienced Database Developer to join our dynamic Engineering team. You will play a crucial role in developing, testing, improving, and maintaining both new and existing databases to ensure efficient and effective data retrieval. Your expertise will contribute to system consistency and support our financial domain projects. This position is based in our Milpitas CA office.
Who we are...
We are Payactiv, a FinTech company in the heart of Silicon Valley, devoted to giving workers access to their earned wages when they need them. Payactiv is the pioneer and industry leader in Earned Wage Access. We are the only Certified B Corporation and Public Benefit Corporation in our industry. Our app provides millions with financial services that help them avoid debt, manage their finances, and regain flexibility to pay for things on their own schedule.
What you will do...
- Develop, test, and maintain new and existing databases to ensure efficient data retrieval and management.
- Collaborate closely with developers, administrators, and clients to provide technical support and identify new requirements.
- Ensure system consistency and reliability by adhering to best practices and coding standards.
- Design and implement database solutions, including stored procedures, functions, triggers, and views using T-SQL.
- Produce high-quality code and resolve complex design and architecture issues.
- Perform database performance tuning, diagnose and troubleshoot errors, and recommend emerging database technologies.
- Create and manage comprehensive database reports, visualizations, and dashboards.
- Automate recurring database tasks to improve efficiency.
- Maintain and enforce database standards, ensuring data integrity and security.
- Utilize PowerShell and Unix shell scripting skills for database automation and management.
- Implement SSIS and SSRS for data integration and reporting.
- Demonstrate strong problem-solving skills and critical thinking in resolving technical challenges.
What you need...
- Extensive experience with database technologies, including MS SQL and MySQL.
- 7-10 years of experience in database development, information technology, database architecture, or a related field.
- Demonstrated ability to produce high-quality code and follow best practices.
- Strong command of SQL and SQL server tools.
- Familiarity with cloud services (AWS, Azure) is highly desirable.
- Proficiency in working with data lakes such as Snowflake is a plus.
- Excellent written and verbal communication skills, with a keen attention to detail.
- Strong mathematical and statistical knowledge.
- MCSE/MCSA certifications preferred.
- Advanced knowledge of relational database concepts and database design principles.
- Proficient in writing and optimizing complex T-SQL queries and database scripts.
- Expertise in database performance tuning and troubleshooting.
- Experience with database automation tools and techniques.
- Strong organizational skills and a problem-solving attitude.
- Ability to handle multiple projects simultaneously and meet deadlines.
- Bachelor’s degree in Computer Science, Information Technology, or a related field, or equivalent experience
What we offer...
- Company-sponsored Health Benefits
- Fully Paid Dental, Vision and Life Insurance
- Fully Paid Health, Dental and Vision Reimbursement Account
- 401K, traditional, and Roth
- Tuition Assistance or Tuition Reimbursement
- Monthly Gym Reimbursement
- Paid time off to volunteer
- Paid Family Leave
- Paid Vacations
- Complimentary office lunches
- The opportunity to make a difference
Join Payactiv and be part of a team dedicated to driving innovation and excellence in database management. Apply your expertise to make a significant impact on our data-driven initiatives and contribute to our success.