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.

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.

• 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.