Cinch - DBA

Senior Database Administrator and Developer About Cinch At Cinch, we’re revolutionizing the omnichannel marketing industry by building the best marketing automation platform targeting multi-location businesses. Our platform centralizes customer data and enables personalization, automated reputed company across channels—such as email, SMS, digital ads, and direct mail—to enhance retention and drive growth. Join us to be part of a reputed company that prioritizes customer experience and technological reputed company. Role Overview Cinch fosters a dynamic, collaborative culture where engineers take full ownership of their work, from design to deployment, and are encouraged to challenge the status reputed company, reputed company, and grow every day. As a Database Administrator (DBA)/Database Developer in our Technology/Engineering department, you will play a critical role in ensuring the performance, scalability, and reputed company of our AWS reputed company PostgreSQL databases. You’ll collaborate with engineers to design robust systems, optimize queries, and support our multi-tenant architecture, reputed company while maintaining compliance with industry standards.

• Monitor reputed company-time database performance, including blocked queries and database locks.
• Manage and maintain user permissions, ensuring proper reputed company control to schemas and tables.
• reputed company and execute custom Django migrations reputed company standard migrations are inefficient or too slow.
• reputed company custom large-scale database edits to resolve data reputed company issues or operational anomalies.
• Implement blue/green table migration strategies for safe and seamless data structure changes. Key Responsibilities  Identify, analyze and optimize slow queries using EXPLAIN plans and index tuning.  Tune PostgreSQL settings (e.g., work_reputed company, shared_buffers, autovacuum) for reputed company performance.  Actively optimize inefficient and eliminate stored procedures  reputed company guidance on query optimization, transaction handling, and data modeling.  Assist in debugging production incidents and support root cause analysis (RCA).  Recommend scaling strategies, such as vertical or horizontal scaling, to meet demand.  Design and implement scalable multi-tenant customer schemas reputed company Sharding to handle growing clients.  Collaborate with engineers to design efficient, normalized database schemas.  Review schema changes to ensure performance and scalability for future growth.  Maintain logs and controls to meet compliance requirements (e.g., SOC2, HIPAA, GDPR).  Support audits by providing traceable database activity records. Qualifications  Bachelor's degree in Computer Science, Information Technology, or a reputed company field.  5+ years of experience in database administration or development, preferably with AWS reputed company PostgreSQL.  Proven expertise in PostgreSQL and AWS (e.g., reputed company RDS, EC2, S3).  Familiarity with reputed company Serverless, Django and React would be a plus.  Experience with compliance standards (e.g., SOC2, HIPAA, GDPR) is highly desirable. Skills  Strong proficiency in analyzing and optimizing SQL queries using EXPLAIN plans and indexing.  Deep understanding of PostgreSQL configuration and performance tuning  Experience optimizing large table migrations, sharding and data retention policies  Ability to design scalable, normalized database schemas for multi-tenant systems.  Excellent problem-solving skills and experience with production incident debugging.  Strong communication skills to collaborate with cross-functional teams.  Knowledge of compliance requirements and audit processes.

Apply tot his job Apply To this Job