Job Description: Oracle Database Administrator (Contractor)
Position Overview: We are seeking an experienced Oracle Database Administrator (DBA) contractor to join our Administrative Applications Production Data Services team. This role will focus on the development, enhancement, and optimization of databases within the Financial Data Warehouse application. The successful candidate will have expertise in designing, developing, and maintaining both logical and physical data models, with a primary focus on Oracle databases. The DBA will be responsible for ensuring optimal database performance, monitoring database health, and addressing any performance bottlenecks during and after migration. This is a hands-on role requiring advanced knowledge of Oracle PL/SQL, shell scripting, performance tuning, and data modeling.
Key Responsibilities:
- Database Development and Design:
- Develop new logical and physical data models for the Financial Data Warehouse application.
- Design, create, and maintain tables, views, and indexes in Oracle databases to support complex workflows and reporting requirements.
- Create and optimize Oracle PL/SQL stored procedures, functions, and packages.
- Design and implement loaders to support project-specific data processing needs.
- Database Performance Optimization:
- Monitor and tune database performance, both during and after migrations, to ensure optimal operation.
- Identify performance bottlenecks and recommend solutions to improve database efficiency.
- Implement performance monitoring solutions and analyze database health metrics regularly.
- Database Administration and Maintenance:
- Execute database backup, recovery, and disaster recovery procedures, ensuring that all processes are executed within established procedures and timelines.
- Monitor database security, ensuring compliance with established security standards and implementing any necessary enhancements.
- Manage data integrity and control redundancy by coordinating data usage across multiple applications.
- Automation and Scripting:
- Develop and test Linux shell scripts to automate database processes, including database calls and job scheduling.
- Develop and schedule automated database jobs to streamline operations and minimize manual intervention.
- Collaborative Development:
- Work closely with cross-functional teams to develop database solutions that meet business and project requirements.
- Participate in the design, testing, and deployment of database enhancements, ensuring smooth transitions between development and production environments.
- User Support and Compliance:
- Provide technical support to end-users, especially in resolving database-related EIR Accessibility issues and ensuring compliance with accessibility standards.
- Support data extraction, transformation, and report generation tasks as requested by business stakeholders.
Required Skills and Qualifications:
- Database Development:
- Extensive experience in Oracle database development, including the creation of tables, views, indexes, and data models.
- Strong proficiency in Oracle PL/SQL programming, including stored procedures, functions, and packages.
- Experience designing and optimizing logical and physical data models.
- Database Administration and Performance Tuning:
- Proven experience with Oracle database administration, including performance tuning, monitoring, and troubleshooting.
- Familiarity with database health metrics and the ability to implement solutions to improve database efficiency.
- Knowledge of Oracle database backup, recovery, and disaster recovery procedures.
- Scripting and Automation:
- Experience developing and testing Linux shell scripts to automate database processes and tasks.
- Strong skills in job scheduling and the automation of database workflows using shell scripts or similar tools.
- Collaborative Teamwork:
- Strong interpersonal skills and the ability to work collaboratively with other database administrators, developers, and business users.
- Experience working in cross-functional teams to meet project deadlines and deliver efficient solutions.
- Compliance and User Support:
- Familiarity with EIR Accessibility standards and experience in ensuring that database-related user interfaces are compliant with these standards.
- Ability to provide technical support to users and resolve issues related to data access and integrity.
- Tools and Technologies:
- Oracle Database (versions 12c and above).
- Oracle PL/SQL development.
- Linux shell scripting.
- Experience with database performance tuning and optimization.
- Familiarity with database security standards and disaster recovery procedures.
- Understanding of database modeling tools and methodologies.
Preferred Qualifications:
- Experience with Financial Data Warehouses:
- Prior experience working in data-intensive environments, particularly within financial applications and reporting systems.
- Certification:
- Oracle Certified Professional (OCP) or equivalent certification in database management.
- ETL and Data Integration Knowledge:
- Familiarity with ETL processes and tools used to extract, transform, and load data between systems.
- Security and Disaster Recovery:
- Knowledge of database security best practices and experience implementing and monitoring security policies.
