Oracle Database Administrator

Company Background

Join us at Mi-Case, where we’re at the forefront of developing innovative public safety products and solutions. We take pride in delivering fully-integrated software and exceptional client support, making a real impact in communities. As part of our team, you’ll collaborate with passionate, talented colleagues and industry experts who are deeply committed to solving the unique challenges faced by our clients in the public safety sector. Together, we’re replacing outdated systems with cutting-edge, mobile-ready solutions that empower our clients to enhance public safety and achieve their goals.

Position Summary

As a DBA Lead, you will play a key role in managing and optimizing multi-tenant Oracle databases within the AWS cloud environment while providing leadership and guidance to a team of DBAs and Developers who support other databases (non Oracle) as well. In this role, you will oversee database operations, and mentor team members. Your responsibilities will encompass deploying, configuring, and maintaining Oracle RDS instances, ensuring high performance, security, and reliability. This role involves a combination of technical expertise, proficiency in AWS services, and leadership abilities.

Responsibilities

• As a DBA Lead, you will be responsible for managing and optimizing databases within the AWS cloud environment, specifically leveraging AWS RDS for efficient deployment and maintenance. Additionally, you will be tasked with automating database health check reporting, ensuring proactive monitoring of the database environment for optimal performance, security, and reliability.
• AWS RDS Implementation and Management: Deploy and configure databases on AWS RDS, ensuring proper sizing, performance tuning, and high availability through multi-AZ deployments.
• Performance Optimization: Continuously monitor and optimize database performance, diagnosing issues and implementing performance tuning strategies. Use tools such as AWS CloudWatch for real-time performance insights.
• Security: Implement and maintain robust security practices for RDS, including encryption, access control, and audit logging.
• Patching and Upgrades: Plan and execute patching and version upgrades with minimal downtime, ensuring databases are up-to-date.
• Database Automation: Automate routine database administration tasks using scripting and AWS CLI to enhance efficiency in daily operations.
• Hybrid Storage Solution: Design, implement, and manage hybrid data storage solutions, ensuring seamless integration and performance across different storage tiers.
• 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, infrastructure 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, and RDS deployment strategies, to ensure consistency and adherence to best practices.

Educational /Training and Certification Requirements

• Bachelor’s degree in computer science, Information Technology, or a related field
• AWS Certified Database – Specialty, Oracle Certified Professional (OCP)

Knowledge, Skills and Experience

• Proven experience as an Oracle Database Administrator, with a focus on AWS environments
• Strong knowledge of Oracle database architecture, performance tuning, and administration
• High proficiency in Oracle database tools and utilities
• In-depth knowledge of AWS RDS and related services with more than 5 years’ experience with Oracle in a lead role
• Scripting skills for automation tasks
• Understanding of cloud security principles and best practices
• Familiarity with Oracle database design, coding, and documentation
• Demonstrated ability to lead a team, mentor junior staff, and collaborate across departments
• Excellent communication and problem-solving skills

Competencies

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 the effectiveness of the company.

Project Management - Effectively manages project(s) by appropriately focusing attention on the critical few priorities; effectively creates and executes against project timelines based on priorities, resource availability, and other project requirements (i.e., budget); effectively evaluates planned approaches, determines feasibility and makes adjustments when needed.

Teamwork - Cooperates with others to accomplish common goals; works within and across his/her department to achieve shared goals; treats others with dignity and respect and maintains a friendly demeanor; values the contributions of others; ability to work effectively with people of diverse backgrounds and characteristics.

Interpersonal and Organizational Professionalism – adept in displaying positive interpersonal skills and has self-awareness in being accountable and responsible. Recognizes areas for self-improvement and pursues professional development for continuous learning. Aligns actions to the mission and goals of the organization.  Follows through on initiatives and meets deadlines, puts thought into appropriate professional-development and keeps skills updated.

Environmental and/or Physical Factors

• Long periods in front of a computer terminal.
• Regularly required to sit, use hands, talk, and hear. Occasionally required to walk and reach.
• Work hours are typically 8am to 5:00pm. However, working extended hours and weekends would be required occasionally to meet project release schedule.

Job Types: Full-time, Exempt

Salary: $115,000-$125,000 per year

Benefits:

• 401(k) 3% Match
• 401(k) matching
• Dental insurance
• Flexible spending account
• Health insurance
• Health savings account
• Life insurance
• Paid holidays
• Paid time off
• Professional development assistance
• Vision insurance
• Work from home

Location: United States-Remote