Sr. Oracle Database Administrator

Job Description

Purpose:

Senior Oracle Database Administrator is responsible for the design, implementation, management, and maintenance of Oracle databases within the organization. This position requires expertise in database architecture, performance tuning, backups, security, and troubleshooting, as well as a deep understanding of Oracle database technologies. Provide operationally efficient systems that meet business objectives and control costs. Candidates must be well qualified, able to work for any US company and be located in the Twin Cities to be considered for this position.

Key Responsibilities:

Database Administration:

• Install, configure, and maintain Oracle databases and related database software
• Perform regular database health checks, including capacity planning and tuning
• Manage Oracle database backups and disaster recovery procedures
• Configure, optimize, and troubleshoot Oracle databases for performance, stability, and reliability

Performance Tuning:

• Monitor database performance and make necessary adjustments to improve performance
• Utilize Oracle tools (e.g., OEM) to diagnose and resolve performance issues
• Implement indexing strategies and SQL query optimizations

Security Management:

• Implement and enforce database security policies, including user access control and data encryption
• Monitor and audit database activities to ensure compliance with security standards

Backup & Recovery:

• Design and implement efficient backup and recovery strategies
• Test backup and recovery processes regularly to ensure data integrity

Database Upgrades & Patch Management:

• Plan and execute Oracle database upgrades and patching
• Review and apply database patches for bug fixes and performance improvements

Capacity Planning & High Availability:

• Ensure the scalability of Oracle databases by analyzing future requirements and performing capacity planning
• Implement and maintain high-availability solutions

Disaster Recovery:

• Develop and maintain a disaster recovery plan for Oracle databases
• Ensure minimal downtime during system failure or disasters

Collaboration:

• Collaborate with development teams to support database-related queries, issues, and database design
• Provide mentoring and guidance to junior DBAs and other technical teams

Automation & Scripting:

• Develop scripts for automation of regular database maintenance tasks (e.g., backups, health checks, monitoring, cloning or replicating databases)

Troubleshooting & Support:

• Provide 24/7 on-call support for production database issues
• Diagnose and resolve critical database problems, including SQL and performance issues

Required Skills and Qualifications:

Education & Certifications:

• Bachelor's degree in Computer Science, Information Technology, or related field

Experience:

• Minimum of 5-7 years of hands-on experience in Oracle database administration
• Strong experience with Oracle Standard versions 11g, 12c, and 19c
• Proficient in SQL, PL/SQL, and Oracle performance tuning tools
• Expertise in backup and recovery methods using RMAN.  Data Guard is a plus
• Experience with Oracle Automated Storage Management (ASM).  OEM RAC Grid Control is a plus

Technical Skills:

• Strong understanding of Oracle architecture and internals including Oracle Database Multitenant architecture
• Proficiency in scripting languages such as Linux Bash and Windows Powershell
• Familiarity with cloud platforms (e.g., AWS) is a plus

Soft Skills:

• Strong problem-solving and analytical abilities
• Excellent communication and documentation skills
• Ability to work effectively in a team and under pressure
• Strong organizational and time-management skills

Complementary Technical Skills:

• Experience with SQL Server Administration including database upgrades, maintenance, replication, performance tuning, SSMS, SSIS, and SSRS is a plus

Job Type: Full Time

Pay: $120,000 - $130,000 annually

Expected Hours: 40 hours per week

Schedule: Monday through Friday

Hours of Operation: Days

Ability to Commute: Minneapolis, MN 55435

Work Location: In Person

Benefits:

• 401(k)
• 401(k) matching
• Health insurance
• Dental insurance
• Vision insurance
• Short-term disability
• Long-term disability
• Employee assistance program
• Flexible spending account
• Health savings account
• Life insurance
• Paid time off
• Referral program