Today
Public Trust
Unspecified
Unspecified
IT - Database
Remote/Hybrid• (Off-Site/Hybrid)
Job Title: Cloud Database Administrator
Location: Remote
Company: Zachary Piper Solutions
Clearance Required: Public Trust
Full Job Description:
Zachary Piper Solutions is looking for a Cloud Database Administrator to join a growing team in support of a government agency. This position will be fully remote.
Responsibilities/Overview:
• Design scalable, secure, and highly available database solutions AWS, OCI and GCP.
• Architect scalable, secure, and highly available database solutions using AWS services like RDS, Aurora, DynamoDB, and Redshift.
• Translate business requirements into optimized cloud-native database architectures.
• Administer and tune databases like Oracle Autonomous DB, MySQL HeatWave, Cloud SQL, BigQuery, and Cloud Spanner.
• Lead migrations from on-prem or other clouds using AWS DMS, Snowball, or custom ETL pipelines.
• Use Terraform, Ansible, or Deployment Manager for infrastructure as code.
• Build, maintain, and manage multiple SQL and NoSQL databases, ensuring data integrity and security as the team works through a broad modernization and database migration effort like SQL Server, PostgreSQL, MySQL (Aurora), DynamoDB, MongoDB.
• Optimize queries, distribution styles, sort keys, and vacuum schedules on Redshift.
• Provide strong analytical and diagnostic capabilities to support identifying opportunities for building better system and data boundaries and managing data integrity across a distributed systems architecture.
• Manage user accounts, permissions, cron jobs, and system updates using linux.
• Have proficiency in Linux system administration and skilled in automation using Python, PowerShell, Bash, T-SQL, and AWS Lambda to streamline infrastructure, optimize database performance, and enforce security compliance
• Implement IAM roles, CMKs, encryption at rest/in transit, and audit logging.
• Provide technical support, including the analysis, design, development and implementation of new systems, system enhancements and bug fixes.
• Responsible for the creation, modification, and execution of test plans and scripts.
Required Qualifications:
• Bachelor's Degree and at least 5 years of experience. 9 Years of Experience in Lieu of a degree.
• Must be U.S Citizen.
• Must be able to obtain a Public Trust clearance to start.
• Proven experience as a DBA with experience in Oracle and Postgres databases.
• Experience with AWS database services, including Aurora, RDS, and Redshift.
• Familiarity with AWS infrastructure and services like EC2, VPC, S3, IAM, and Lambda.
• Experience with automation tools and scripting languages such as Python, Shell, or AWS Lambda to automate database tasks.
• Experience with AWS CloudWatch, CloudTrail, or other monitoring tools to ensure high availability and performance.
• Solid experience in database failover, recovery procedures, and disaster recovery planning.
• Comprehensive understanding of modern database design, database management, and best practices.
• Strong verbal, written, interpersonal, troubleshooting, and analytical skills.
Desired:
• AWS or relevant database certifications (e.g., Oracle Certified Professional, PostgreSQL Professional).
• Experience with Azure, OCI or GCP cloud database services
• Experience with scripting languages (e.g., Python, Bash) for automation of database tasks.
• Experience with data warehouse design, implementation, and optimization, for example, AWS Redshift.
• Agile, Scrum, JIRA, Service now
• Experience utilizing version control systems like Git and SVN
Compensation and Benefits:
· $110,000 - $120,000+ Dependent on experience
· Comprehensive Benefits: Medical, Dental, Vision, 401K, PTO, Sick Leave as required by law, and Holidays.
This job opens for applications on 7/31/25. Applications for this job will be accepted for at least 30 days from the posting date.
Location: Remote
Company: Zachary Piper Solutions
Clearance Required: Public Trust
Full Job Description:
Zachary Piper Solutions is looking for a Cloud Database Administrator to join a growing team in support of a government agency. This position will be fully remote.
Responsibilities/Overview:
• Design scalable, secure, and highly available database solutions AWS, OCI and GCP.
• Architect scalable, secure, and highly available database solutions using AWS services like RDS, Aurora, DynamoDB, and Redshift.
• Translate business requirements into optimized cloud-native database architectures.
• Administer and tune databases like Oracle Autonomous DB, MySQL HeatWave, Cloud SQL, BigQuery, and Cloud Spanner.
• Lead migrations from on-prem or other clouds using AWS DMS, Snowball, or custom ETL pipelines.
• Use Terraform, Ansible, or Deployment Manager for infrastructure as code.
• Build, maintain, and manage multiple SQL and NoSQL databases, ensuring data integrity and security as the team works through a broad modernization and database migration effort like SQL Server, PostgreSQL, MySQL (Aurora), DynamoDB, MongoDB.
• Optimize queries, distribution styles, sort keys, and vacuum schedules on Redshift.
• Provide strong analytical and diagnostic capabilities to support identifying opportunities for building better system and data boundaries and managing data integrity across a distributed systems architecture.
• Manage user accounts, permissions, cron jobs, and system updates using linux.
• Have proficiency in Linux system administration and skilled in automation using Python, PowerShell, Bash, T-SQL, and AWS Lambda to streamline infrastructure, optimize database performance, and enforce security compliance
• Implement IAM roles, CMKs, encryption at rest/in transit, and audit logging.
• Provide technical support, including the analysis, design, development and implementation of new systems, system enhancements and bug fixes.
• Responsible for the creation, modification, and execution of test plans and scripts.
Required Qualifications:
• Bachelor's Degree and at least 5 years of experience. 9 Years of Experience in Lieu of a degree.
• Must be U.S Citizen.
• Must be able to obtain a Public Trust clearance to start.
• Proven experience as a DBA with experience in Oracle and Postgres databases.
• Experience with AWS database services, including Aurora, RDS, and Redshift.
• Familiarity with AWS infrastructure and services like EC2, VPC, S3, IAM, and Lambda.
• Experience with automation tools and scripting languages such as Python, Shell, or AWS Lambda to automate database tasks.
• Experience with AWS CloudWatch, CloudTrail, or other monitoring tools to ensure high availability and performance.
• Solid experience in database failover, recovery procedures, and disaster recovery planning.
• Comprehensive understanding of modern database design, database management, and best practices.
• Strong verbal, written, interpersonal, troubleshooting, and analytical skills.
Desired:
• AWS or relevant database certifications (e.g., Oracle Certified Professional, PostgreSQL Professional).
• Experience with Azure, OCI or GCP cloud database services
• Experience with scripting languages (e.g., Python, Bash) for automation of database tasks.
• Experience with data warehouse design, implementation, and optimization, for example, AWS Redshift.
• Agile, Scrum, JIRA, Service now
• Experience utilizing version control systems like Git and SVN
Compensation and Benefits:
· $110,000 - $120,000+ Dependent on experience
· Comprehensive Benefits: Medical, Dental, Vision, 401K, PTO, Sick Leave as required by law, and Holidays.
This job opens for applications on 7/31/25. Applications for this job will be accepted for at least 30 days from the posting date.
group id: 10430981