Cloud DBA

Founded in 1992, Mi-Case is the industry leader in fully integrated offender management software solutions and provides industry expertise and consulting within Criminal Justice and Public Safety systems. Mi-Case leverages a unique combination of technical, functional and industry specialization as well as partnerships with key software vendors to deliver maximum value add projects.

As a DBA, you will play a key role in administering and optimizing relational databases in AWS, with primary focus on Amazon RDS for Oracle, Amazon Aurora Postgre

SQL, and Amazon RDS for SQL Server. You will own provisioning, configuration, upgrades, performance, backup and recovery, security, and day‑to‑day operations. You will also provide leadership and guidance to a team of DBAs and developers, establish cloud database standards and runbooks, and automate health checks and reporting to ensure high performance, availability, and reliability.

• As a DBA, you will be responsible for administering Amazon RDS databases in AWS. You will drive automation, operational excellence, and proactive monitoring through repeatable runbooks and health check reporting.
• AWS RDS and Aurora Provisioning:
  Design, deploy, and configure RDS DB instances and Aurora clusters, including instance and storage sizing, subnet and parameter groups, option groups, maintenance windows, Multi-AZ, and read replicas.
• High Availability and Disaster Recovery:
  Implement and validate HA and DR strategies, including Multi-AZ, failover configuration, cross‑region replication where applicable, and disaster recovery runbooks with defined RTO and RPO.
• Backup, Restore, and Environment Refresh:
  Manage automated backups, manual snapshots, retention policies, and cross‑region snapshot copies. Perform and document regular restore tests and support Dev, QA, and UAT refreshes using approved methods.
• Performance Monitoring and Tuning:
  Use Cloud Watch, Performance Insights, and Enhanced Monitoring to diagnose performance issues, analyze wait events and query behavior, and implement tuning actions across Oracle, Postgre
  
  SQL, and SQL Server.
• Security and Compliance:
  Enforce least‑privilege access using IAM and database roles, network isolation using VPC and security groups, encryption at rest using KMS and encryption in transit using TLS. Configure and retain audit and engine logs in Cloud Watch Logs as needed.
• Patching and Upgrades:
  Plan and execute minor and major engine upgrades with minimal downtime. Coordinate testing, apply patching within defined maintenance windows, and use blue/green or staged deployment patterns where supported.
• Automation and Infrastructure as Code:
  Automate routine tasks using scripting and AWS CLI or SDKs. Partner with Dev Ops to manage RDS and Aurora changes using infrastructure as code (for example, Terraform or Cloud Formation) and integrate database checks into CI/CD pipelines.
• Migration and Data Movement:
  Support database migrations and upgrades using AWS DMS and AWS Schema Conversion Tool when applicable, plus native utilities such as Oracle Data Pump,  and , and SQL Server native backup and restore to S3.
• Engine‑Specific Administration:
  Implement maintenance routines appropriate for each engine, such as Oracle statistics and maintenance windows, Aurora Postgre
  
  SQL vacuum and extension management, and SQL Server index and statistics maintenance and SQL Agent job scheduling, within the capabilities of RDS and Aurora.
• Collaboration:
  
  Be the liaison between the database team and other technical and business units, ensuring alignment of database services with organizational goals.
• Collaboration and Support:
  Work closely with developers, platform teams, and system administrators to optimize database design, resolve issues, and ensure database systems meet business needs.
• Documentation and Best Practices:
  Document all database procedures in internal Wiki, including health check reporting, automation scripts, RDS and Aurora deployment standards, and operational runbooks, to ensure consistency and adherence to best practices.

• Bachelor's degree in computer science, Information Technology, or a related field
• AWS…