Please continue the application only if you have expertise in MySQL with Postgres and not

Oracle Mandatory Skills:

Strong experience in MySQL, PostgreSQL, and decent experience in Redis and MongoDB In-person work 3x/day from the northern NJ office. Final round with the client will be in-person at NJ office Job roles and responsibilities This role requires strong knowledge of MySQL, Redis, PostgreSQL, and MongoDB. Most work is done in MySQL, PostgreSQL, and Redis. Candidates should have hands-on experience deploying, migrating, and experiencing blue-green deployments for upgrades and planning on

EC2, AWS

Aurora, RDS MySQL, and PostgreSQL. Experience in MongoDB is recommended but not mandatory, as the infrastructure is standardized and we rarely see requests. Experience in HAProxy, Keepalived configuration and management helps understand the infrastructure and excel. Strong replication knowledge and the ability to perform on-demand database refreshes from production to non-production are essential. Scripting knowledge, including strong shell scripting, knowledge of Ansible, and AWS CloudFormation, is recommended. Candidates may be expected to understand, tune and write stored procedures during interviews with the application management team and some leadership teams. So, this knowledge is recommended to crack the next level interview rounds Job Summary We are seeking a dynamic and detail-oriented Database Administrator to join our innovative team. In this role, you will be responsible for managing, maintaining, and optimizing our diverse database systems to ensure seamless data flow and high performance. Your expertise will support critical business operations by designing robust database architectures, implementing efficient data solutions, and ensuring the highest levels of data integrity and security. If you thrive in a fast-paced environment and are passionate about leveraging your technical skills to drive organizational success, this is the perfect opportunity for you!

DBA JD:

Install, configure, upgrade, and maintain MySQL, Redis, PostgreSQL and MongoDB databases in both on-premise and AWS environments. Manage Replication solutions for each Database based on application requirement for proper HighAvailability. Administer and Optimize AWS Managed database services (RDS, AURORA, ElastiCache, Dynamo

DB, S3, EC2

). Automate routine tasks and infrastructure setup using tools like Ansible and AWS CloudFormation. Design and implement comprehensive monitoring and alerting systems (CloudWatch , PMM, Datadog, MonYog) to proactively identify performance bottlenecks and apply necessary optimizations or fixes. Perform daily maintenance, health checks, and capacity planning to ensure database reliability across all environments. Collaborate with application developers to design efficient schemas, optimize complex queries, and enhance database performance. Work closely with DevSecOps to ensure timely application of security patches and upgrades. Develop and manage robust backup and disaster recovery strategies ensuring minimal data loss and downtime. Generate ad-hoc reports and provide insights as requested by internal teams or stakeholders. Good with Shell Scripting or Python. Good with linux administration

Pay:

$95,556.49 - $115,078.78 per year

Benefits:

401(k) Dental insurance Health insurance Paid time off Vision insurance

Work Location:

In person