Technical Lead (Database)

ID

2024-4897

# of Openings

1

Posted Date

4 days ago(8/13/2024 2:46 AM)

Category

Research & Development

We are seeking a Technical Lead- Database to join our growing team!

About Us

Community Brands provides a connected network of solutions that enable mission-driven organizations to thrive. Our software powers non-profits, associations, and K-12 schools to engage the people they serve through programs and events, raise funds to enable their mission, and manage their financials and operations. Our family of brands are bound by a common purpose to serve the organizations that make our communities a better place to live. With over 1,600 employees in the US, Canada, UK, Australia, India, and the Philippines, we know that our success is driven entirely by the people of Community Brands. Through professional opportunity, we strive to give each person a clear path to success and personal growth. We embrace diversity and believe that our differences in experience and perspective are the key to our sustained success.

A Day in the Life

As a Senior Database Developer, you will collaborate with software engineers, data engineers, and product managers to drive forward data modeling, database design, database scalability, database performance and other data initiatives. You will perform database administration for Amazon RDS databases including both MySQL and Postgres database engines, query development and tuning, developer query optimization and code review and coach teams on how to best apply the principles of data management including master data management princples across the GiveSmart fundraising platform.

In this role candidate will:

• Effectively manage day-to-day tasks in coordination with a team of developers and stakeholders to meet deliverables. Strong programming capabilities in SQL and other DB technologies– Stored Procedures, Functions, Triggers, Views, Transactions, etc.
• Have responsibility for production database environments
• Preserve data integrity and security
• Participate in the physical database design process. Ensures databases provide required functionality, scalability and performance to meet identified business needs.
• Create scripts to build and maintain database objects
• Implements databases for testing and production.
• Assist in monitoring capacity and performance for test and production databases to ensure they are reliable, efficient, cost effective, and provide the required functionality.
• Create and maintain appropriate documentation (Database, Architecture, etc.)
• Assist in analyzing and diagnosing problems reported to the support, development and operations teams.
• Work with the Architects in the data modelling and database design for fast application performance, including advanced architectural techniques. Assists in defining data models for optimal use in varied use cases and data engines.
• Assist in DevOps, working with Architects and Engineers to automate code promotion and deployment up the stack of environments, ensuring successful, repeatable deployments through Production, with consistent quality.
• Performance Optimization – Performance monitoring, measurement, and capacity planning of Production Software solutions, recommending changes to products and “standardized” System configurations.
• Participate in regular code review for all new code deployment efforts as code is advanced through the secure software development life cycle.
• Accurately estimate efforts and fully participate in Scrum ceremonies.
• Stay current with the database technologies, Amazon RDS, MySQL, Postgres, MongoDB, Redis, etc.

We would love to chat if you have...

• Must-Have Skills:
  • 6+ years of experience in maintaining database environments successfully within Amazon RDS utilizing either MySQL or Postgres database engines.
  • Strong SQL skills, including writing, optimizing and maintaining stored procedures, Triggers, indexes, and other DB functions.
  • Expertise in performing DB administration and optimiziation tasks.
  • Experience with optimization, troubleshooting, debugging, and performance tuning of SQL code, stored procedures, functions, indexes, etc.
  • AWS cloud experience. (Knowledge of Aurora / RDS)
• Nice to have Skills:
  • Added advantage of experience with generating customer-readable reports from databases
  • Experience working in agile/scrum environment within the SAFE agile framework.
  • Extract/Transform/Load (ETL) process experience is a plus.

Preferred Education and Experience:

• B.S. or higher in computer science/technology field preferred or equivalent industry experience
• Excellent customer-service orientation
• Effective delegation of tasks and follow-up
• Lead database technology assessments and author recommendations
• Knowledgeable of database system and quality assurance best practices and methodologies
• Capable of meeting deadlines and focuses on results and value creation
• Works well with customers and vendors, knows when and how hard to push to maintain a stable and reliable environment
• Capable of leading research into database development issues to successful completion
• Self-motivated and directed
• Capable of prioritizing and execution of tasks in a high-pressure environment
• Knowledge of applicable data privacy practices and regulations preferred (PCI, PII, PHI, HIPAA, GDPR, ADA, etc.)

Why work here?

Good People, Doing Good Things: Employees at Community Brands are techies and volunteers who strive to make the Company a great place to work. We dream big and are motivated to help our customers use the technology we create to improve the world around us.

• Planned Paid Time Off
• Purpose-Driven Culture
• Work-Life Balance

• Passionate About Community Involvement
• Company Paid Parental Leave

All persons hired will be required to:

• Verify their identity,
• Verify they are eligible to work (without sponsorship) in the country they are to be employed in, and

• Complete any required employment eligibility verification form upon hire.

#LI-PK1