Zachary Piper Solutions
Cloud Database Administrator
Zachary Piper Solutions - Aurora, Colorado, United States, 80012
Work at Zachary Piper Solutions
Overview
- View job
Overview
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