Oracle Database Administrator

MDA Edge; Round Rock (TX); On-site; USD 50,006 - 71,221; Full time

Job summary

Join a dynamic team as a Database Administrator, where you will play a crucial role in the development and enhancement of a Financial Data Warehouse. This full-time position offers an opportunity to work with advanced Oracle database technologies, ensuring optimal performance and reliability. You will be responsible for creating logical and physical data models, implementing performance tuning strategies, and collaborating with a skilled team to drive data integrity and efficiency. If you are passionate about database management and thrive in a fast-paced environment, this role is perfect for you!

Qualifications

• 10+ years of experience in Oracle database design and performance tuning.
• Knowledge of programming principles and database theories.

Responsibilities

• Develop and optimize Oracle databases and PL/SQL code.
• Monitor and improve database performance and security.

Skills

Oracle Database Design

Performance Tuning

Data Analysis

PL/SQL Development

Linux Shell Scripting

Education

Bachelor's Degree in Computer Science

Oracle Certification

Tools

Jira

Job description

This range is provided by MDA Edge. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.

Base pay range

$44.00/hr - $44.00/hr

Job Summary:

This Database Administrator (must be located in the state of Texas) contractor position is part of the Administrative Applications Production Data Services team and will be working on the development and implementation of modifications and enhancements to the Financial Data Warehouse. This position will perform advanced database development tasks for databases used by an application with complex data models, workflows, and reports.

• Enter codes to create production databases.
• Select and implement utility programs to monitor database performance, such as distribution of records and available memory.
• Direct programmers and analysts to make changes to the database management system. Review and correct programs. Answer user questions.
• Consult with coworkers to assess the impact of database changes on other systems and staff costs.
• Modify database programs to improve processing performance (performance tuning).
• Specialize in one or more types of database management systems.
• Assist in planning, development, maintenance, and monitoring of integrated database systems, ensuring alignment with application design phases.
• Evaluate user requests for new data elements and systems; incorporate into the shared data environment; provide technical assistance.
• Coordinate data usage to maintain integrity, control redundancy, load databases, and reorganize as needed. Perform data modeling and prototyping.
• Perform logical and physical data modeling, design relational database models, and create physical data models. Execute security recovery procedures.
• Determine and implement database search strategies and storage requirements.
• Maintain data dictionary for consistency of definitions and standards.
• Monitor database performance and recommend improvements.
• Create test database environments, including necessary libraries and procedures.
• Execute procedures to backup, recover, and restore databases following hardware and software failures.
• Support database security standards and disaster recovery procedures.
• Assist with database software installation, analysis, design, and implementation.
• Participate in benchmarking and threshold testing of databases and establish security controls.
• Assist in selecting database management software.

Qualifications include experience in computer systems analysis or programming, knowledge of programming principles, systems design, database theories, and current technologies, with a working knowledge of EIR Accessibility standards and assistive technologies to ensure compliance and support users.

Responsibilities:

• Work with Oracle databases, including creating logical and physical data models.
• Optimize database performance during and after migration, identify bottlenecks, and implement monitoring solutions.
• Develop new views, tables, and PL/SQL code for the Financial Data Warehouse.
• Design, develop, and test tables, views, PL/SQL stored procedures, functions, and loaders.
• Develop and test Linux shell scripts for database calls and scheduled jobs.
• Perform performance tuning of tables, views, and PL/SQL code.
• Collaborate with the team to maintain data models, focusing on Oracle, with knowledge of stored procedures and functions.

Experience Required/Preferred:

• 10+ years in Oracle database design, analysis, and performance tuning.
• Experience with Oracle database structures, data analysis, enterprise application/service design, and lifecycle using Agile methodologies.
• Preferred: Jira experience, Oracle certification, experience with data warehouse applications and reporting features.

Additional Details:

• Seniority level: Mid-Senior level
• Employment type: Full-time
• Job function: Other
• Industries: IT Services and IT Consulting

Referrals increase your chances of interviewing at MDA Edge by 2x.

Get notified about new Oracle Database Administrator jobs in Round Rock, TX.