Database Engineer / Solutions Architect - (Cape Town)
Cape Town
R&D: Engineering – Tech Enablement & R&D Engineering /
Full time /
On-site
Hi there! We’re WebFX, a full-funnel revenue marketing agency based in the US. We’ve been 9x named a Best Place to Work, and we’d love to meet you! We are a fast-growing company of more than 700 FXers, that has doubled in size over the past 5 years, with talented team members in 6 US offices, 20+ US States, and now based around the globe (and representing 18+ different countries, including offices in Guatemala and South Africa!).
While WebFX and our subsidiary companies, such as Nutshell CRM, SEO.com, and TeamAI, are growing rapidly, we are committed to growing strategically and sustainably, and that starts with growing our team of the #BestCoworkers - that’s where you come in!
We’re looking for people to join our mission to provide world-class full-funnel revenue marketing solutions to mid-size businesses worldwide, We are passionate about what we do, we’re committed to driving business growth for our clients, and we’re on the hunt for people just like you, who take pride in their work and want to be part of a company that does too.
Why Choose WebFX
We’re proud to offer the same great culture and a comprehensive set of benefits to our team members no matter where in the world they’re based. In addition to very competitive base pay, we also offer company profit-sharing, performance bonuses, and health insurance (including dental, vision, remote doctor, etc.). To aid in your success, we also provide world-class industry training (Organic SEO, Local SEO, PPC, Google Analytics, etc.), long-term career track opportunities, and ongoing learning bonuses (yes, you can get paid to learn!), along with numerous other benefits!
Some of the additional benefits our FXers enjoy include:
- No matter where you are located or your position, WebFX offers long-term stability to all of our FXFamily members. Many of our global team members have been with WebFX for 10+ years, and we’re hoping you can be too! 🌏
- We put our people first; it’s as simple as that. You’re never on your own - when you run into inevitable challenges, we’re there to support you along the way!
- Long-lasting relationships with both clients and team members due to consistently low turnover rates, which are simply unheard of in our industry because, again, we put our people first.
- Fully equipped in-office setup including computer, dual large monitors, headset, seriously fast internet, generator, and more! 🖥️
- Unrestricted access to our proprietary software/platforms that our internal R&D team has developed for our team’s exclusive use, in addition to access to the many 3rd party tools and software we utilize internally in order to WOW our clients. You can learn more about just some of our proprietary tools here.
- Be part of a rapidly growing company that, at the same time, only partners with clients who share our values. 🌱📈
- Merit-based promotional structure.
- Annual merit-based compensation increases! 💰
- Access to virtual professional development opportunities with company experts and virtual team-building events like monthly meetups and hangouts.
- Invitation to our annual FXFest – a week-long, all-expenses-paid trip for our international team members (with a 1-year tenure) to our company headquarters. This event is filled with activities, learning, and motivation to help unite our U.S. and global staff! 🛫
- We have a very strong commitment to giving back globally - in fact, it’s one of our values here at WebFX. As a member of our FXFamily, you get to be a large part of that simply by achieving your goals - since 2014, we’ve committed to donating globally through our FXBuilds program. You can learn more about that here!
- When you join WebFX, you don’t just join a company; you join a community! We value all of our team members the same, regardless of their position or where they call home. We truly look forward to learning about you and your background, and we will be there to celebrate the milestones in your life together, no matter how big or small! 👏
What You'll Get
World-Class Training and Ongoing Career Development
- No matter your level of experience, our “Bootcamp” training program is provided for all new WebFX “family members” to learn, grow and develop in and out of the office with the hard skills necessary to be successful in their position.
- From training with our Award-Winning Sr. Developers, Designers, Marketers, and more to access to countless industry-leading online training resources/courses/tutorials to getting experience with our client base that spans just about every industry you can think of (and then some), our training program is simply unrivaled!
- Training doesn’t stop after your initial training period, we offer career development training and monthly Lunch-and-Learns with our state-of-the-art training amenities to facilitate departmental training, industry-related updates, and more!
- FXLearns program – where you get incentives for taking advantage of our countless industry training resources!
- With a track record of serving over 1,500+ clients, we’ve been able to truly master our processes and procedures, and we’ll train you on them - no need to develop how to do things (unless you want to help us continually improve that process!), because we refuse to ever stagnate, we are always pushing to make those processes 1% better too!
Opportunities for Growth
WebFX has doubled in size over the past 5 years, and merit-based promotional opportunities are abundant if you're meeting or exceeding position performance metrics. We believe in growing and promoting our internal team first and foremost. In fact, 95% of our promotions are internal! All team members have a very clearly defined progression path, so you know exactly what is expected of you so you can put your career in your own hands.
What’s more, you’re not expected to know it all - we believe in continually striving to be an expert in your subject matter of expertise, so while we will purposely challenge you to grow in your niche, we are a full-service agency that has experts in other departments that handle everything else - from link building, to social media, to web design, and web development. This is done so you can truly master your trade.
We currently have over 40 team members based at our office in Cape Town, and our goal is to continue growing this number!
What You'll Do
Our database engineer is 70% database expert & 30% software engineer.
You will spend the majority of your time making application changes to improve database performance, scalability and reliability and delivering foundational database solutions and best practices for our backend development teams.
During our call, we can show you a demo of our amazing proprietary platform!
Responsibilities
- Pro-actively identify database performance impediments and resolve them by proposing and delivering changes to the codebase. Own this process end-to-end, from triaging issues to verifying your solution in production
- Deliver application changes that allow us to scale the application and its database further and make sure we're prepared for data growth
- Act as a Database Maintainer for the codebase and review database-related application changes before they are released
- Review, optimize and refactor the existing database schema
- Create and incrementally improve documentation to reduce tribal knowledge, including
- Database best practices
- Workflows and database team processes
- Target architecture and long term scalability considerations
- Improve tooling to detect performance bottlenecks early in the development cycle
- Work with the Google Cloud Platform (Our platform is on GCP)
- Identify problematic database patterns by analyzing workload and implementing/suggesting solutions
- Implement a partitioning strategy framework for large tables
- Implement building blocks to efficiently load, analyze and migrate data
- Analyze tables and optimizing them by adding indexes, breaking them up into separate tables, or by removing unnecessary columns
- Implement an efficient queueing strategy for pull mirrors
- Implement efficient patterns for counting
- Rewrite the database queries and related application logic used for retrieving subgroups
- Prevent primary key integer overflows with no-downtime migrations
- Improve index usage (remove unused, identify missing)
- Improve our application-side database load balancing implementation
- Review database related changes submitted by other developers
- Document database best practices or patterns to avoid
Who We're Looking For
- Expert-level understanding of relational databases, SQL and query optimization techniques and demonstrated ability to both diagnose and prevent performance problems
- Expert-level understanding of the internals of PostgreSQL
- Proficiency in the English language, both written and verbal, sufficient for success in a remote and largely asynchronous work environment
- Demonstrated capacity to clearly and concisely communicate about complex technical, architectural, and/or organizational problems and propose thorough iterative solutions
- Experience in, and understanding of, data and information management, as it relates to Big Data trends and issues within businesses
- Experience owning a project from concept to production, including proposal, discussion, and execution.
- Self-motivated and self-managing, with strong organizational skills.
- Ability to thrive in a fully remote organization, however with some overlapping hours with the rest of the team
A Plus if you Have
- Big Data Management experience (this is a huge plus)
- Knowledge of BigQuery, BigTable, TensorFlow (this is a huge plus) (Our platform is on GCP)
- Knowledge of BigQuery, BigTable, TensorFlow
- Experience with PostgreSQL sharding techniques
- Experience with owning the operations of large PostgreSQL production database infrastructure
- Experience in a peak performance organization, preferably a tech startup, or high growth platform
- Experience working the the marketing automation / CRM / B2B software industry
- Experience working with a remote team
- Mid to Enterprise software company experience
- Developer platform/tool industry experience
- Experience working with a global or otherwise multicultural team
- Passion for/experience with open source and developer tools
- Experience with AWS RedShift, Kinesis, BigQuery, GCP Cloud SQL, whatever Azure's big datasets products are, and Data Pipeline
Working Hours
The core position hours will have 4 hours of overlap with our standard Monday through Friday - 8AM EST until 4PM EST/New York Time Zone in order to accommodate our clients' schedules, with additional options to fulfill the full work week within your time zone (Depending on the hours you select, you will receive additional pay for overlapping our hours)
Compensation
Negotiable, based on experience
Annual merit-based increases
Working Hours and Location
We're currently looking for full-time team members who are able to work in our Cape Town office and the hours outlined below.
Office Locations:
Cape Town Office: Waterview CI, Century City, Cape Town, 7441, South Africa
Work Hours:
Monday through Thursday: 10:00 AM -7:30 PM SAST
Friday: 10:00 AM - 5:00 PM SAST
Check out our culture on social media:
Please submit a resume or CV (in English) to be considered for this opportunity.
*You don't need to apply more than once, even if you're interested in multiple positions - you can simply let us know! We consider all open roles when reviewing resumes and applications!
WebFX is an Equal Opportunity Employer committed to providing and fostering an inclusive environment where all people, including women, minorities, LGBTQ+, and other underrepresented groups, are supported, respected, and encouraged to excel within STEM careers. Our goal as an organization is to empower our team to achieve their personal best, bring people together, and provide equal opportunity to do so regardless of race, age, gender, sexual orientation, religion, physical ability or disability, or political affiliation. You can learn more on our website here!
