Technical Lead (Database)

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

Responsibilities & Qualifications

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\u2013 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 \u2013 Performance monitoring, measurement, and capacity planning of Production Software solutions, recommending changes to products and \u201cstandardized\u201d 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.)