Lead Architect- Data & Database Systems

Job responsibilities

• Author and optimize queries for performance and correctness.
• Monitor and tune database performance including query tuning indexing partitioning and caching.
• Build and maintain monitoring alerting and observability for database systems.
• Support production incidents and perform root cause analysis; participate in on-call rotations.
• Assist application teams with data access patterns migrations and release planning.
• Engage technical teams and business stakeholders to discuss and propose data architecture approaches to meet current and future needs.
• Evaluate recommendations for new technologies and provide actionable feedback.
• Execute creative data architecture solutions including design development and technical troubleshooting with the ability to think beyond routine or conventional approaches to build solutions or break down technical problems.
• Develop secure high-quality production code; review and debug code written by others.

• Identify opportunities to eliminate or automate remediation of recurring issues to improve overall operational stability of software applications and systems.

Required qualifications capabilities and skills

• Strong SQL skills including complex joins window functions aggregates subqueries and explain/analyze plans.
• Experience with at least one major RDBMS: PostgreSQL MySQL/MariaDB Microsoft SQL Server or Oracle.
• Performance tuning experience including indexing strategies query profiling and execution plan interpretation.
• Experience with monitoring and observability tooling such as Prometheus Grafana Datadog Dynatrace or New Relic.
• Familiarity with versioned schema migrations using tools such as Flyway Liquibase Alembic or sqitch.
• Good understanding of storage IOPS and how database workload relates to underlying infrastructure.
• Familiarity with cloud-managed databases and their operational tradeoffs including AWS RDS/Aurora Google Cloud SQL and Azure SQL/DMS.
• Strong troubleshooting skills and experience handling production incidents.
• Proficiency in automation and continuous delivery methods.
• Proficient in all aspects of the Software Development Life Cycle.
• Advanced knowledge of one or more software application and architecture disciplines with the ability to evaluate current and emerging technologies to recommend the best data architecture solutions for future state architecture.