Zachary Piper Solutions
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. #J-18808-Ljbffr
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. #J-18808-Ljbffr