Database Lead

Role Overview: As a Database Lead at Adtech Corp, you will play a crucial role in managing, designing, and optimizing databases, ensuring their availability, performance, and scalability. Your responsibilities will include database administration, designing database structures, creating data models, and analyzing system performance to enhance operations. Collaboration with cross-functional teams to align database systems with organizational objectives will be a key aspect of your role. Key Responsibilities: - Design scalable database architectures, schemas, and data models for transactional & analytical workloads. - Develop & optimize complex stored procedures, UDFs, triggers, and queries. - Perform performance tuning, indexing, partitioning, sharding, and query plan optimization. - Implement replication, migration, and backup/restore strategies across environments. - Manage deployment scripts, versioning (Flyway/Liquibase), and CI/CD pipelines. - Utilize advanced PostgreSQL features like logical/streaming replication, JSONB, full-text search, materialized views, CTEs, and PL/pgSQL tuning. - Collaborate with backend teams (.NET / Node.js) to optimize database access and ORM performance. - Review database code, set best practices, and mentor developers. Qualifications Required: - 5-10 years of experience in database development, with 5+ years specifically in PostgreSQL (advanced concepts). - Proven experience in data modeling, architecture, debugging, and performance optimization. - Strong knowledge of partitioning, replication, sharding, and parallel queries. - Hands-on experience with CI/CD tools (Git/Jenkins/Azure DevOps) and cloud databases (AWS RDS / Aurora). - Excellent problem-solving and documentation skills. Company Description: Adtech Corp is a CMMI Level 3 appraised technology consulting firm specializing in Microsoft Dynamics 365, custom software development, cloud engineering, quality assurance, and digital business services. The company's mission is to help organizations modernize operations, optimize processes, and enhance customer experiences through innovative solutions. Committed to innovation, customer focus, and quality, Adtech Corp fosters strong partnerships to ensure long-term success for clients.,