Oracle Database Administrator

As a Senior 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 PostgreSQL, 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 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.

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

• 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

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.