Database Applications Architect

Database Applications Architect Work Timings: From 6 PM IST - 3 AM IST [Semi-Night Shifts] Summary We're seeking a Database Applications Architect to join our development team and drive performance, scalability, and reliability across our messaging platform that serves utility companies. Our platform delivers millions of critical messages in minutes, requiring sophisticated database architecture and optimization. You'll work across our diverse technology stack with engineering leads to identify bottlenecks, improve DB application components and implement solutions that make our systems faster and more efficient. This is a database-focused application architecture role with real influence over system design and engineering practices. Key Responsibilities What you’ll do: Architectural Leadership • Analyze and optimize database interactions across our multi-database environment (Oracle, MySQL, MongoDB, DynamoDB, MSSQL Server) • Design and implement database schemas, data models, and access patterns that support high-throughput messaging operations • Re-architect portions of applications to eliminate performance bottlenecks and improve scalability • Evaluate and recommend database technologies and tools to meet evolving business requirements • Act as a technical advisor to engineering leads on data architecture decisions Performance Optimization • Identify and resolve database performance issues in production applications • Optimize queries, indexes, and database configurations to support millions of messages per minute • Design caching strategies, connection pooling, and data access patterns for high-concurrency scenarios • Conduct performance testing and capacity planning to ensure system reliability during peak loads Development Collaboration • Work closely with software engineers to design efficient data access layers • Review application code and provide guidance on database best practices • Implement monitoring, alerting, and diagnostic tools to proactively identify issues • Establish standards and processes for database development across teams Cross-Stack Problem Solving • Understand the full application stack (database, queuing architecture, frontend) to optimize end-to-end performance • Analyze how database design impacts message queuing, delivery, and overall system throughput • Bridge the gap between application development and operational requirements Qualifications Required Experience • 15+ years of hands-on experience with database application development • Deep expertise in at least 2-3 database platforms from our stack (Oracle, MySQL, MongoDB, DynamoDB, MSSQL Server) • Proven track record optimizing high-volume, high-throughput database applications • Strong SQL skills and experience with query optimization and performance tuning • Experience with both relational and NoSQL database architectures • Familiarity with cloud database services (AWS RDS, DynamoDB, etc.) and on-premises deployments Technical Skills • Expert-level understanding of database indexing, partitioning, and sharding strategies • Experience designing data models for scalability and performance • Knowledge of connection pooling, caching layers, and data access optimization • Proficiency with database monitoring and profiling tools • Understanding of distributed systems concepts and data consistency patterns • Familiarity with message queuing systems (RabbitMQ, Kafka, SQS, or similar) Preferred Qualifications • Experience with messaging or notification platforms • Knowledge of utilities industry requirements and regulatory compliance (optional) • Background in performance testing and capacity planning • Exposure to database administration tasks (configuration, deployment, backup/recovery) • Experience with CI/CD pipelines and database migration tools • Understanding of infrastructure-as-code and configuration management Soft Skills • Strong analytical and problem-solving abilities • Excellent communication skills with ability to explain complex technical concepts to diverse audiences • Collaborative mindset with experience working across development teams • Pragmatic approach to balancing architectural ideals with business realities • Self-motivated with ability to work independently and drive initiatives Our Environment Technology Stack • Databases: Oracle, MySQL, MongoDB, DynamoDB, MSSQL Server (cloud and on-premise) • Message queuing architecture supporting multi-channel delivery (SMS, email, push, etc.) • Mix of cloud-hosted and on-premise infrastructure • Modern development tools and monitoring solutions What Makes This Role Unique • High-impact work: Your optimizations directly affect millions of utility customers receiving critical communications • Technical diversity: Work with multiple database platforms and architectural patterns • Real challenges: Solve complex problems at scale where performance matters • Strategic influence: Shape the technical direction of our platform About Company We work for company Convey based in Denver, Colorado, USA. Hired Engineer will be working on payroll of AllDomainSoftware pvt. ltd. This will be full time working for Convey from home. (https://www.goconvey.com/ ). Website: http://alldomainsoft.com Address: UNIT NO 1032 10TH FLOOR TOWER, B 3 SPAZE I TECH PARK SEC 49, SOHNA ROAD, GURGAON, GURGAON, Haryana, India.