Mi-Case · 6 hours ago
Senior Oracle Database Administrator
United States
Full-time
Remote
Senior Level
$140K/yr - $160K/yr
5+ years expMi-Case is the industry leader in fully integrated offender management software solutions, providing expertise in Criminal Justice and Public Safety systems. The Senior DBA will administer and optimize relational databases in AWS, focusing on Amazon RDS for Oracle, and lead a team of DBAs to ensure high performance and reliability of database operations.
Business DevelopmentBusiness Information SystemsSoftware
Hiring Manager
Pete Hickok
Responsibilities
As a Senior 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 CloudWatch, Performance Insights, and Enhanced Monitoring to diagnose performance issues, analyze wait events and query behavior, and implement tuning actions across Oracle, PostgreSQL, 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 CloudWatch 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 DevOps to manage RDS and Aurora changes using infrastructure as code (for example, Terraform or CloudFormation) 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, pg_dump and pg_restore, 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 PostgreSQL vacuum and extension management, and SQL Server index and statistics maintenance and SQL Agent job scheduling, within the capabilities of RDS and Aurora
Team Oversight: Provide technical leadership to the DBA team, planning and delegating tasks effectively
Mentorship: Guide and mentor mid-level DBAs, fostering their professional development and enhancing team capabilities
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
Qualification
Required
Bachelor's degree in computer science, Information Technology, or a related field
AWS Certified Database - Specialty, Oracle Certified Professional (OCP), and Microsoft SQL Server certification or equivalent experience
5+ years of hands-on database administration experience in AWS, including Amazon RDS and Amazon Aurora
Strong experience administering Oracle on Amazon RDS, including backup and recovery workflows, parameter and option group management, and performance troubleshooting
Strong experience administering Aurora PostgreSQL, including cluster design, failover behavior, reader scaling, parameter tuning, vacuum strategy, and extension management
Strong experience administering SQL Server on Amazon RDS, including index and statistics maintenance, SQL Agent scheduling, and native backup and restore workflows
Deep understanding of AWS networking and security for databases, including VPC design, security groups, IAM, KMS encryption, and TLS connectivity
Proficiency with monitoring and diagnostics tools such as CloudWatch, Performance Insights, and engine logs for root cause analysis
Scripting and automation skills using AWS CLI or SDKs plus languages such as Python, PowerShell, or Bash
Experience with database migrations and modernization using AWS DMS and AWS Schema Conversion Tool, plus native engine utilities
Demonstrated ability to lead a team, mentor junior staff, and collaborate across departments
Excellent communication, documentation, and problem-solving skills
Preferred
Results - Consistently delivers required business results; sets and achieves achievable, yet aggressive, goals; consistently complies with quality, service and productivity standards and meets deadlines; maintains focus on company goals
Technical/Functional Expertise - Demonstrates and effectively applies depth and breadth of knowledge and skill in a technical or functional area
Professional Development - Demonstrates a commitment to professional development by proactively seeking opportunities to develop new capabilities, skills, and knowledge; acquires the skills needed to continually enhance his/her contribution to the company and to his/her respective profession
Communication - Respectfully listens to others to gain a full understanding of issues; comprehends written material; presents information in a clear and concise manner orally and in writing to ensure others understand his/her ideas; appropriately adapts his/her message, style, and tone to accommodate a variety of audiences
Problem Solving - Analyzes problems by evaluating available information and resources; develops effective, viable solutions to problems which can help drive
Company
Mi-Case
With over 20 years of experience in bespoke digital transformation at both the public and private level, Mi-Case is known as much for our white-glove approach to client support as we are for our exceptional, fully-integrated software solutions.
51-200 employees
H1B Sponsorship
Mi-Case has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (1)
2024 (4)
2022 (5)
Funding
Current Stage
Growth StageCompany data provided by crunchbase