Day Shift Postgresql Jobs (NOW HIRING)

Senior Database Engineer needed for a contract opportunity with SOC's client to work onsite in Washington D.C Contract Length: 6 months, possible conversion to FTE Must have an Active Public Trust Clearance or be willing to obtain Responsibilities: Full time, on-site position at DOT Headquarters, Washington, DC. 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: AWS Certified Database Specialty, AWS Certified Solutions Architect, or equivalent cloud/database certifications preferred. * 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 VMware, 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. Desired Qualifications: * 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.

Employment Prerequisites The following requirements must be met to be eligible for this position: successful completion of a background investigation and drug urinalysis. SOC, a Day & Zimmermann company, is an Equal Opportunity Employer, EOE AA M/F/Vet/Disability. Note: Any pay ranges displayed are estimations, which may have been provided by job boards.

Actual pay is determined by an applicant's experience, technical expertise, and other qualifications as listed in the job description. All qualified applicants are welcome to apply. #DZFED #CJ #INDSC Estimated Min Rate: $43.16 Estimated Max Rate: $61.65