Day Shift Postgresql Jobs (NOW HIRING)

Job Summary:
Scalence L.L.C. is seeking a Senior Database Administrator Expert to lead enterprise database environments to AWS Cloud. The role involves managing PostgreSQL and MySQL databases, ensuring their security, reliability, and performance while collaborating with various teams to streamline operations and improve database reliability.
Responsibilities:
• Provide in-person support several days per week, with availability for either the early shift (starting 7:00 AM) or late shift (ending 7:00 PM) as needed.
• Install, configure, and maintain enterprise-level PostgreSQL and MySQL database platforms and supporting infrastructure across on-premises and AWS cloud environments.
• Configure, manage, and optimize AWS database services including Amazon RDS for PostgreSQL, Amazon RDS for MySQL, Amazon Aurora, and MySQL Cluster environments.
• Plan and execute migrations of PostgreSQL and MySQL databases from on-premises environments to AWS cloud platforms (IaaS and PaaS).
• Design, implement, and maintain MySQL clustering, replication, failover, and high-availability solutions.
• Contribute to database architecture and capacity planning to ensure scalability, reliability, performance, and security.
• Design, implement, and maintain disaster recovery strategies for PostgreSQL and MySQL environments hosted on AWS.
• Monitor the performance, integrity, and security of all database platforms and investigate anomalies and production incidents.
• Perform routine database maintenance tasks including index optimization, query tuning, statistics updates, backups, and consistency checks.
• Plan and perform database upgrades, patching, and migrations for standalone, clustered, and cloud-hosted database servers.
• Oversee and lead migration projects, including lift-and-shift, modernization, and re-platforming efforts to AWS cloud environments.
• Manage database accounts, roles, and permissions according to least privilege and compliance requirements.
• Audit database activity and maintain comprehensive logs of configuration and schema changes for compliance and forensic analysis.
• Implement encryption, secure connectivity (TLS/SSL), and other security controls for data at rest and data in transit.
• Maintain detailed, version-controlled documentation for database environments, architecture diagrams, configurations, operational procedures, and runbooks.
• Generate regular reports on database performance, capacity growth, availability, and usage trends for stakeholders.
• Collaborate closely with development, infrastructure, cloud, and security teams to streamline deployments and accelerate incident resolution.
• Mentor junior DBAs and establish operational best practices for AWS database administration, automation, and cloud migration initiatives.
• Demonstrated success managing enterprise PostgreSQL and MySQL environments in hybrid (on-premises and AWS cloud) infrastructures.
• Proven expertise in planning and executing cloud migration projects with strong hands-on experience in AWS cloud platforms.
• Must be able to multitask effectively and perform well under pressure in a fast-paced, high-urgency environment while managing multiple priorities and production incidents concurrently.
Qualifications:
Required:
• Candidate must be a U.S. citizen or green card holder who has resided in the U.S. for at least 3 years and the ability to obtain a public trust.
• Strong expertise in PostgreSQL and MySQL administration across on-premises and AWS cloud environments.
• In-depth knowledge and hands-on experience in PostgreSQL and MySQL installation, configuration, optimization, clustering, replication, backup/recovery, and ongoing maintenance.
• Proven ability to manage PostgreSQL and MySQL environments across multiple platforms including Client, AWS EC2, Amazon RDS, Amazon Aurora, and on-premises infrastructure.
• Strong experience with MySQL Cluster, replication technologies, failover configurations, and high-availability database architectures.
• Capability to troubleshoot database performance issues, analyze execution plans, optimize SQL queries, and implement database performance tuning strategies.
• Experience implementing database security solutions including encryption, IAM integration, SSL/TLS, and secure access controls.
• Hands-on experience migrating PostgreSQL and MySQL clusters to AWS cloud environments, including assessments, planning, and providing technical recommendations.
• Experience with backup and recovery tools, monitoring solutions, automation scripting, and disaster recovery planning.
• Ability to participate in on-call rotations and perform mandatory maintenance activities during scheduled maintenance windows.
Preferred:
• Experience with Amazon Aurora PostgreSQL and Aurora MySQL highly preferred.
• Strong knowledge of AWS networking, storage, security, and infrastructure services supporting database environments.
• Experience automating database administration tasks using shell scripting, Python, Terraform, Ansible, or similar automation tools.
• Familiarity with DevOps, Infrastructure as Code (IaC), CI/CD pipelines, and monitoring tools such as CloudWatch and Prometheus.
• Experience supporting large-scale, mission-critical enterprise database environments with strict uptime and performance requirements.
• Strong verbal and written communication skills with the ability to interact effectively with technical and non-technical stakeholders.
• Excellent analytical, troubleshooting, and problem-solving skills in high-pressure production environments.
Company:
In today’s dynamic and competitive market, success hinges on mastering three key areas: Data Intelligence, Business Resilience, and Digital Experience. Founded in , the company is headquartered in Morristown, USA, with a team of 501-1000 employees. The company is currently Late Stage.