Oracle Database Administrator
Location
Alabama + 18 moreAll locations: Alabama | California | Connecticut | Florida | Kansas | Kentucky | Louisiana | Maine | New Jersey | North Carolina | Oregon | Maryland | Massachusetts | Rhode Island | South Carolina | Texas | Virginia | Washington | West Virginia
Posted
2 days ago
Salary
0
Seniority
Senior
Job Description
Oracle Database Administrator
Atlas Technologies
• Install, configure, patch, and upgrade Oracle database software across AWS RDS environments • Perform proactive performance monitoring, SQL tuning, and resource optimization, including PeopleSoft-aware diagnostics (PeopleTools metadata, PSFT schemas, App Server/PIA/Process Scheduler impacts) • Ensure database availability, integrity, and reliability through automated monitoring and alerting using CloudWatch, RDS metrics, and custom PeopleSoft health checks • Develop and implement robust backup strategies, including RMAN, PITR, cross-region backups, and restore validation • Enforce database security policies, including user access, encryption, auditing, ATO compliance, CAT I/II remediation, and SQL inactivity/audit reporting • Troubleshoot database issues, including slow queries, locks, PeopleSoft metadata inconsistencies, and cross-tier performance bottlenecks • Create and maintain documentation for processes, architecture, configurations, and operational runbooks • Automate routine tasks using shell scripting, Python, SQL automation, Lambda workflows, and Step Functions • Support database migrations and upgrades across environments (on-premises/cloud), including PeopleTools upgrades, PUM lifecycle activities, and environment refreshes (masking, scrambling, schema sync) • Participate in disaster recovery planning and testing exercises, including High Availability architecture implementation for PeopleSoft (Multi-AZ, failover testing, DB redundancy, autoscaling alignment)
Job Requirements
- U.S. Citizenship
- Possession of a Department of Defense (DoD) Secret Level Security Clearance
- Bachelor's degree in computer science, Information Technology, or relevant experience
- Security+ CE Certification, or equivalent
- Minimum 5 years of experience as an Oracle DBA with in-depth knowledge of Oracle database architecture
- Strong expertise in performance tuning, capacity planning, and system optimization
- Proficiency in SQL, PL/SQL, and scripting languages such as Bash or Python
- Familiarity with database automation and monitoring tools, including AWS RDS, CloudWatch, and PeopleSoft monitoring integrations
- Experience working with cloud-based databases (AWS RDS, OCI, etc.) is a plus
Benefits
- Training resources and skills enhancement opportunities
- Education reimbursement for outside resources or higher education
Related Guides
Related Categories
Related Job Pages
More Database Administrator Jobs
• Will be responsible for providing all activities related to the administration of computerized databases. • Project long-range requirements for database administration and design in conjunction with other managers in the information systems function. • Design, create, and maintain databases in a client/server environment. • Conduct quality control and auditing of databases in a client/server environment to ensure accurate and appropriate use of data. • Advise users on access to various client/server databases. • Design, implement, and maintain complex databases with respect to JCL, access methods, access time, device allocation, validation checks, organization, protection and security, documentation, and statistical methods. • Apply knowledge and experience with database technologies, development methodologies, and front-end/back-end programming languages (e.g., SQL). • Perform database programming and supports systems design. • Provide maintenance of database dictionaries, overall monitoring of standards and procedures, file design and storage, and integration of systems through database design.
Role Description We are looking for a highly experienced Oracle Property Graph Database Specialist with 7–10+ years of experience in Oracle technologies and advanced data modeling. The ideal candidate will be responsible for designing and implementing graph-based data models aligned with complex network architectures. This role requires deep expertise in Oracle Database along with hands-on experience in graph technologies to enable relationship-driven analysis, network insights, and high-performance data processing. Key Responsibilities - Design and develop scalable graph data models (nodes, edges, properties) based on network architecture and system relationships - Implement and manage Oracle Property Graph solutions within the Oracle Database ecosystem - Convert relational and network data into graph structures for advanced analytics - Develop and optimize graph queries using PGQL (Property Graph Query Language) - Analyze and interpret network topology, connectivity, and dependencies using graph techniques - Collaborate with data architects, DBAs, and application teams to integrate graph solutions - Ensure performance tuning, scalability, and efficient data processing for large graph datasets - Support data migration, transformation, and validation processes - Provide technical guidance and best practices for graph-based implementations Qualifications - 7–10+ years of strong experience in Oracle Database development and administration - Hands-on experience with Oracle Property Graph and related tools (Graph Server, Graph Studio) - Strong expertise in SQL, PL/SQL, and Oracle data architecture - Proven experience in data modeling, including translating relational models into graph models - Experience working with network-based data structures (telecom, infrastructure, or similar domains) - Strong understanding of graph concepts such as traversal, pathfinding, and relationship analysis - Ability to design efficient and scalable graph schemas Salary Best market rate
Senior Database Administrator – Software
Truelogic SoftwarePremium boutique software development company that helps brands with big ideas to make a difference in people’s lives.
• Data Pipeline Execution (ETL): Build, manage, and monitor efficient ETL/ELT pipelines to consolidate data from multiple production AWS PostgreSQL instances into Snowflake for analytics and reporting. • Advanced Query Auditing & Performance Tuning: Continuously audit SQL queries across our production systems. Diagnose complex bottlenecks, rewrite sub-optimal queries, optimize indexes, and tune database configurations to ensure peak platform speeds. • Database Operations & Maintenance: Oversee the day-to-day health, backup strategies, security compliance, and scaling of our PostgreSQL (AWS RDS/Aurora) and Snowflake environments. • Query Best Practices & Collaboration: Partner with Software Engineers to review database schemas and queries before they hit production, acting as a trusted advisor on SQL best practices. • Troubleshooting & Optimization: Serve as the senior escalation point for database performance issues, ensuring minimal downtime and high availability for our core SMS services.
Senior Database Administrator – Software
Truelogic SoftwarePremium boutique software development company that helps brands with big ideas to make a difference in people’s lives.
• Data Pipeline Execution (ETL): Build, manage, and monitor efficient ETL/ELT pipelines to consolidate data from multiple production AWS PostgreSQL instances into Snowflake for analytics and reporting. • Advanced Query Auditing & Performance Tuning: Continuously audit SQL queries across our production systems. Diagnose complex bottlenecks, rewrite sub-optimal queries, optimize indexes, and tune database configurations to ensure peak platform speeds. • Database Operations & Maintenance: Oversee the day-to-day health, backup strategies, security compliance, and scaling of our PostgreSQL (AWS RDS/Aurora) and Snowflake environments. • Query Best Practices & Collaboration: Partner with Software Engineers to review database schemas and queries before they hit production, acting as a trusted advisor on SQL best practices. • Troubleshooting & Optimization: Serve as the senior escalation point for database performance issues, ensuring minimal downtime and high availability for our core SMS services.


