What are the responsibilities and job description for the Oracle Database Administrator position at Oraapps Inc?
Job Details
Job Title - Database Administrator
Hybrid Locations - Pittsburgh, PA | Strongsville, OH | Farmers Branch, TX | Phoenix, AZ | Birmingham, AL
Job Summary
Designs and implements physical database systems and supports ongoing data management initiatives. Ensures data integrity, performance, and availability across production and non-production environments. Leads efforts to optimize database structures, enhance system reliability, and provide technical expertise to development and operations teams.
Roles and Responsibilities
- Maintain and support database systems to ensure reliability and availability
- Improve database performance and optimize SQL queries for efficiency
- Design and define database tables and structures based on evolving project requirements
Must-Have Technical Skills
Level 3 | 5 8 years of experience
- Strong hands-on experience with Oracle Single Instance databases
- Proficiency in creating tables, views, and materialized views
- Expertise in query performance tuning and optimization
- Solid understanding of SQL
Job Description
- Design, implement, and maintain physical database backups, recovery programs, archiving processes, and conversion strategies across supported database technologies.
- Manage and maintain data across all production and non-production databases and replication servers to ensure optimal performance and data consistency.
- Design and develop logical and physical database layers, ensuring scalability and alignment with project requirements.
- Lead data testing, reporting, and backup/restoration efforts, ensuring adherence to data governance and security standards.
- Provide technical guidance and mentorship to team members on conceptual, logical, and physical database design best practices.
- Utilize logical models to ensure efficient and reliable database performance and support evolving application needs.
- Collaborate with cross-functional teams to support ongoing projects, troubleshoot performance issues, and implement continuous improvements.
- Apply data analytics, data mining, and machine learning principles where applicable to enhance database intelligence and decision-making processes.
Skills:
Analytical Thinking | Data Mining | Data Analytics | Competitive Analysis | Data Science | Machine Learning
Experience:
6 8 years of hands-on experience in database design, development, and administration.