Database Administrator Specialist

#w2 Role

JD:

We are seeking an experienced Technical Lead with a strong background in MongoDB to join our dynamic team. The ideal candidate will possess expertise in database architecture, design, development, and optimization, as well as hands-on experience with cloud-native database solutions. This role is responsible for leading technical initiatives, ensuring optimal database performance, and guiding migration strategies across complex environments. The position requires a deep understanding of MongoDB and PostgreSQL systems, AWS ecosystem automation tools, and best practices for high availability, security, and compliance. Key Responsibilities MongoDB and PostgreSQL Architecture & Best Practices: o Design, implement, and optimize MongoDB databases for scalability, reliability, and performance. o Apply advanced knowledge of MongoDB and PostgreSQL architecture, including query planning, indexing, partitioning, and replication. o Establish and enforce best practices for database design, normalization, and data integrity. o Deploy and manage MongoDB and PostgreSQL clusters, focusing on high availability, global databases, and disaster recovery strategies. o Utilize AWS storage management and monitoring tools to ensure optimal database health and performance. o Implement performance and cost optimization strategies within the environment. Database Administration & Optimization: o Monitor and tune database performance, including query optimization and resource allocation. o Perform regular backup and recovery operations, ensuring data integrity and compliance with security standards. o Oversee access management, security controls, and regulatory compliance for all database systems. Migration Planning and Execution: o Lead end-to-end database migration projects, including planning, execution, and post-migration validation. o Ensure data integrity verification and minimal downtime during migration processes. Technical Leadership: o Mentor and guide junior database engineers and developers. o Collaborate with cross-functional teams to align database strategies with business objectives. o Document technical solutions, operational procedures, and best practices for ongoing reference. Required Skills and Experience Bachelor's degree in Computer Science, Information Technology, or related field. 8+ years of hands-on experience with MongoDB and PostgreSQL database systems, with at least 2+ years in a technical leadership capacity. In-depth understanding of MongoDB and PostgreSQL architecture, including query optimization, indexing, and partitioning. Proven experience designing, developing, and optimizing databases for high performance and reliability. Extensive experience with AWS including management, monitoring, high availability, and global databases. Familiarity with AWS automation tools such as CloudFormation and Terraform for infrastructure management. Strong troubleshooting and problem-solving skills in database environments. Demonstrated experience with database administration: performance monitoring, backup/recovery, tuning, query optimization, data integrity, security, compliance, and access management. Successful track record of planning and executing database migrations Preferred Qualifications Professional certifications in MongoDB, PostgreSQL, or AWS. Experience migrating databases from legacy systems to cloud-native solutions. Knowledge of additional AWS services (e.g., Lambda, EC2, S3) and their integration with database platforms. Experience implementing database automation and infrastructure as code practices.