Published: October 8, 2024 - The Oracle Database Administrator ensures a deep understanding of client environments and infrastructure. Recommends optimal solutions tailored to customer requirements, supports design maintenance, and troubleshoots daily. Manages SQL Server and Oracle Server administration, including backups, high availability solutions, performance tuning, and security measures.
Tips for Oracle Database Administrator Skills and Responsibilities on a Resume
1. Oracle Database Administrator, Tech Innovations, Omaha, NE
Job Summary:
- Work with the Application Development and DXC (HP) teams on information to be gathered during incidents.
- Review the run books and OSI’s periodically in support of incident management capability.
- Work with AD and DXC to write and implement: DB maintenance scripts, DB log clean up jobs, health checks, start-up and shutdown scripts
- Exercise the app maintenance window to ensure that DB’s run optimally
- Review and ensure proper alerting is in place and tested.
- Resource will review monitoring is in line with needs and make recommendations for improvements and for automation opportunities
- Work with AD to assess capacity needs and ensure the DB is sized and configured to handle the short, mid-term capacity needs
- Profiling of databases and produce Query/profile reports where issues are observed – for example provide to the AD team long running queries
- Support assessment of planned / implemented changes, assess potential impact on database performance/capacity
- Undertake investigation in conjunction with other teams at DXC and Client on agreed known problems (for example performance).
- Maintain, monitor, and analyze Oracle database system components and make recommendations for database system improvements.
- Perform and coordinate effective installation and performance of advanced Oracle database system software on Red Hat Enterprise Linux, Oracle Exadata and Solaris servers.
- Install new Oracle database software releases, system upgrades, evaluate and install patches, and resolve Oracle database software related problems.
- Plan and perform appropriate procedures, documentation and other procedures related to IT.
- Support, monitor, test and troubleshoot Oracle database software problems.
Skills on Resume:
- Incident Management (Hard Skills)
- Script Development (Hard Skills)
- Database Optimization (Hard Skills)
- System Monitoring (Hard Skills)
- Capacity Planning (Hard Skills)
- Performance Profiling (Hard Skills)
- Change Impact Analysis (Hard Skills)
- Problem Resolution (Hard Skills)
2. Oracle Database Administrator, Data Solutions Inc., Atlanta, GA
Job Summary:
- Implement complex system configurations at an expert level in demanding customer environments.
- Assess, design, plan, and implement complex infrastructure projects
- Directly interact with cross-functional teams and solution architects to identify, develop, and obtain complete information for solutions.
- Plan and execute technical deliverables including developing, validating, and executing project technical processes and procedures.
- Serve as an escalation point for technical project issues.
- Apply best practices, strategies, methodologies and approaches to large scale projects.
- Interacting with application teams to plan and execute the migrations
- Perform all technical tasks related to the move
- Building and documenting migration paths for new technologies
- Providing support to other members of the team
- Google Cloud data platform migrations and support
- Database deprecation (adhering to any data retention policies required)
- Automating tasks with shell and python scripting, and Ansible developer skills.
- Oracle and MySQL database administration on Linux platform.
- Oracle and MySQL database performance tuning
Skills on Resume:
- System Configuration (Hard Skills)
- Project Management (Hard Skills)
- Cross-functional Collaboration (Soft Skills)
- Technical Execution (Hard Skills)
- Issue Escalation (Soft Skills)
- Best Practices Application (Hard Skills)
- Cloud Data Migration (Hard Skills)
- Automation Scripting (Hard Skills)
3. Oracle Database Administrator, Cloud Services LLC, Austin, TX
Job Summary:
- Production support: Health checks, working towards dB alerts, data archive, DR switch, etc.,
- Perform dB export, import and other dB activities in setting up dB in oracle 19c as part of ongoing application version upgrade.
- Upgrade database from oracle 11.2.0.4 to 19c as part of site migration activity for few other applications, expecting to start shortly.
- Support team in analysing, deploying new changes, if any, during bi-weekly sprint releases.
- Coordinate and implement Trading and Fuels configuration environment changes
- Coordinate and implement Trading and Fuels change management
- Provide technical mentoring to support personnel
- Ensure adherence to human performance practices
- Ensure adherence to change management process
- Monitor application system health checks
- Assist with troubleshooting and resolution of operational problems
- Ensure Trading and Fuels on-call IT application support
- Monitor, report, and optimize aspect of the systems and technology to ensure all are operating in accordance with service levels and system tolerances
- Maintain software support levels via upgrades and patching
- Maintain security of Novuna's infrastructure to ensure consistence and appropriate end user access to environments
- Assess and develop long-term strategic goals for the company Application & Database Servers in conjunction with key stakeholders
Skills on Resume:
- Database Maintenance (Hard Skills)
- Oracle Upgrades (Hard Skills)
- Sprint Release Support (Hard Skills)
- Change Coordination (Soft Skills)
- Technical Mentoring (Soft Skills)
- System Health Monitoring (Hard Skills)
- Problem Resolution (Hard Skills)
- Security Management (Hard Skills)
4. Oracle Database Administrator, Network Systems, Portland, OR
Job Summary:
- Establishes configuration standard and design guideline for database software, covering availability, performance, resilience, monitoring, backup and recovery functional areas.
- Provides technical assistance to development team and operation teams for database systems.
- Troubleshoot and drive system recovery.
- Escalate problems with actual or potential major impact to problem management and IMS management.
- Performs root cause analysis and ensure planned actions are carried out to prevent recurrence.
- Leads and controls the delivery of outsourcer technical team of middleware and database support personnel.
- Ensures the supportability of database software systems.
- Plans and leads upgrade projects.
- Reviews and approves change requests.
- Supervise the execution of major change and automates system operation
- Conducts performance analysis and tuning
- Tracks and drives patch management for all database software.
- Track, plan and drive software upgrades to ensure continuous supportability.
- Establish backup and recovery procedures
- Establishes adequate monitoring to ensure efficient and reliable service delivery
Skills on Resume:
- Database Configuration Standards (Hard Skills)
- Technical Assistance (Soft Skills)
- System Recovery (Hard Skills)
- Problem Escalation (Soft Skills)
- Root Cause Analysis (Hard Skills)
- Team Leadership (Soft Skills)
- Performance Tuning (Hard Skills)
- Change Management (Hard Skills)
5. Oracle Database Administrator, SecureTech, Raleigh, NC
Job Summary:
- Responsible for the implementation, configuration, maintenance, and performance of critical SQL Server RDBMS systems
- Responsibilities cover the performance, integrity and security of business data and SQL Server databases.
- Fulfill duties and to make business data available to its users, database administrators have to perform routine DBA checks on SQL Servers to monitor status
- Manage SQL Server databases
- Configure and maintain database servers and processes
- Monitor the system's health and performance
- Ensure high levels of performance, availability, sustainability and security
- Analyze, solve, and correct issues in real time
- Provide suggestions for solutions
- Refine and automate regular processes, track issues, and document changes
- Assist developers with query tuning and schema refinement
- Provide 24x7 support for critical production systems
- Perform scheduled maintenance and support release deployment activities after hours
- Provides technical guidance and mentoring to help develop less experienced engineers.
- Supports audit and compliance activities
Skills on Resume:
- SQL Server Management (Hard Skills)
- Database Security (Hard Skills)
- Routine DBA Checks (Hard Skills)
- Performance Monitoring (Hard Skills)
- Issue Resolution (Hard Skills)
- Process Automation (Hard Skills)
- Query Tuning (Hard Skills)
- Technical Mentoring (Soft Skills)
6. Senior Oracle Database Administrator, Quantum Computing, Hartford, CT
Job Summary:
- Communicates clearly and effectively with customers, team members and management.
- Maintains an effective relationship with customers, team members and management.
- Provides input in the development of tools and processes to increase team productivity.
- Builds confidence and trust with customers.
- Displays effective analytical skills.
- Effectively manages scope and customer expectations on individual assignments.
- Follows through on all assignments and takes ownership of customer issues.
- Seeks innovative ways to improve the process of delivering solutions to customers.
- Meet Service Level Agreements for database uptime and performance.
Skills on Resume:
- Effective Communication (Soft Skills)
- Relationship Management (Soft Skills)
- Process Development (Hard Skills)
- Customer Trust Building (Soft Skills)
- Analytical Skills (Hard Skills)
- Scope Management (Soft Skills)
- Customer Issue Ownership (Soft Skills)
- Innovative Problem-Solving (Soft Skills)
7. Oracle Database Administrator, Efficient Networks, Phoenix, AZ
Job Summary:
- Understand the Client environment and Infrastructure
- Analyze and recommend optimal solutions based on Customers' requirements
- Need to understand and document the various phases of the project Build or Migration
- Support the Customer environment including activities such as design maintenance troubleshooting
- Conduct day-to-day SQL Server and Oracle Server administration activities
- Manage backups and restores Identifying and resolving blocking issues
- Complete high availability solutions including Log shipping, mirroring
- Maintain performance tuning and query optimization
- Complete troubleshooting in Clustered environments
- Maintain MS SQL server and Oracle security and database permissions
- Conduct migration and upgrades of SQL Server instances
- Plan, implement and perform DR activities
- Exposure in Upgrades knowledge on Capacity planning based on growth
- Provide 24 by 7 on-call support
Skills on Resume:
- Infrastructure Analysis (Hard Skills)
- Solution Recommendation (Hard Skills)
- Project Documentation (Hard Skills)
- Database Administration (Hard Skills)
- High Availability Management (Hard Skills)
- Performance Tuning (Hard Skills)
- Security Management (Hard Skills)
- On-call Support (Soft Skills)
8. Oracle Database Administrator, Global IT Solutions, Columbus, OH
Job Summary:
- Install and configure Oracle Grid Infrastructure and RAC databases
- Setup/Configure Oracle Physical Standby Databases
- Install and configure Oracle 21c Golden Gate for Oracle 19c database replication
- Configure unidirectional and bidirectional replication
- Setup GoldenGate for Zero Downtime Upgrades
- Explain the difference between classic vs integrated capture
- Improve Golden Gate performance and troubleshoot common issues
- Troubleshooting incidents through OEM, Database, and Cluster logs
- Evidence based review of Application, Database, OS, and Hardware with clear communication of bottlenecks within a system.
- Apply new technology and process to improve system supportability, recoverability, availability and performance.
- Provides operational excellence and skills on databases to support various project phases (requirement gathering, design, procurement, implementation and hand-over to operations).
- Develop Documentation as necessary for knowledge sharing within Teams.
Skills on Resume:
- Oracle Grid Installation (Hard Skills)
- Standby Database Configuration (Hard Skills)
- GoldenGate Replication (Hard Skills)
- Replication Techniques (Hard Skills)
- Performance Optimization (Hard Skills)
- Troubleshooting (Hard Skills)
- Systematic Problem Solving (Soft Skills)
- Documentation Development (Soft Skills)
9. Oracle Database Administrator, NextGen Technologies, Denver, CO
Job Summary:
- Manage Prod, Non-prod & DR (Standby/cascaded standby) databases on RAC and Exadata
- Troubleshoot Oracle Real Application Cluster issues
- Configuring and troubleshoot Dataguard issues
- Manage databases on VCS and troubleshoot VCS cluster issues
- Setup and troubleshoot Oracle Replication
- Configure and manage oracle wallet
- Manage database Back Up, Restore, Recovery, Update statistics, Rebuilding and Reorganizing indexes, Defrag Tables, Replication, partitioning, Database Maintenance Plan.
- Monitoring Instances, Configuring and Enabling alerts using OEM
- Set up Privileged Access Management reports in OEM
- Query optimization and performance tuning.
- Work on Core DBA activities for customer
- Corporate and/or Client attendance using phone, Zoom and email (for Production and test issues direction)
- Interface between Production supports (tier 2) with Development support (tier 3) for Production issues
- Monitoring production UNIX environment
- Support SQL Development and monitor Oracle performance
Skills on Resume:
- RAC Management (Hard Skills)
- DataGuard Configuration (Hard Skills)
- VCS Management (Hard Skills)
- Oracle Replication Setup (Hard Skills)
- Oracle Wallet Management (Hard Skills)
- Database Maintenance (Hard Skills)
- Performance Tuning (Hard Skills)
- Cross-Team Collaboration (Soft Skills)
10. Oracle Database Administrator, Advanced Data Systems, Sacramento, CA
Job Summary:
- Manage Oracle architectures, Real Application Cluster (RAC) and single instance, Data Guard (DG) databases running on HPUX, RHEL, CentOS and SLES platforms.
- Ensure database objects (views, stored procedures, triggers, constraints, etc.) and SQL statements meet performance, standards (naming and DB design) and security objectives.
- Design / Create new Oracle databases, create new schemas/database objects (tables structures & storage Mgmt, Indexes, constraints, triggers, Stored Procedures, Etc), as well as making database changes from DEV to PROD, following request/demands from the development team (per the technical specifications) or as result of translate business requirements.
- Support Oracle Databases (10g, 11g, 12c, 19c) on HP-UX, RHEL, SLES, CentOS and Windows platforms.
- Support applications for DB accounts creation, pwd reset, security, DB integrity, schemas management (Administering / manage tables, indexes and tablespaces).
- Monitor constantly / regularly performance and troubleshoot database issues using (Alert log files & Trace files) and OEM tool (unusual conditions, i.e. database contention, load throughput, cache utilization, etc.).
- Monitor regularly whether primary and standby databases are in sync and clearing the backed up archive log files after confirming that it is applied on the standby database (Synchronize Standby DBs).
- Monitor database objects growth, managing the extents growth and de-fragmenting objects, which are running out of maximum extents (excessive fragmentation of table spaces and taking remedial steps), optimize space.
- Perform Table space Management (size and schema objects) and Rollback table space Management, allocate system storage, plan future storage requirements
- Apply Health Check and solve findings to ensure stable and compliance environments.
- Execute overall health check pertain to performance tuning, backup and recovery, etc. for heterogeneous environment.
- Performance tuning (overall performance of processes) using Enterprise Manager, ADDM and Oracle AWR tuning advisor reports, explain Plan.
- Monitor and trace poor performing queries for tuning opportunities and work closely with developers to optimized them.
- Collecting statistics using and explain Plan and Tkprof during performance slowdowns.
Skills on Resume:
- Oracle Architecture Management (Hard Skills)
- Database Security Standards (Hard Skills)
- Database Design (Hard Skills)
- Platform Support (Hard Skills)
- Performance Monitoring (Hard Skills)
- Problem Resolution (Soft Skills)
- Space Optimization (Hard Skills)
- Query Optimization (Hard Skills)
11. Oracle Database Administrator System Analyst, Enterprise Services, Baton Rouge, LA
Job Summary:
- Ensure that the new technical requirements are properly integrated with existing processes
- Participate in requirement gathering and write technical requirements during critical phases
- Interact with vendors to understand software limitations
- Assist programmers during system development, Ex: provide use cases, flowcharts or even database design
- Responsible for system testing (SIT, Performance, Security testing), designing components and providing that information to the developer
- Ensure that the systems comply with IT policy standards
- Responsible for the maintenance and operational activities of the system
- Co-ordinate with the project teams and ensure that the resources are equipped to be productive in time to meet requirements.
- Responsible for preparing project plans and maintaining it
- Evaluate alternative solutions to business problems and select preferred solution and justify the selections.
- Provide functional and user interface design specifications to the development team
- Work with business and Solution Architects to identify suitable options and review these to identify the most suitable
- Gather, document and maintain the necessary information to enable the project team (business and IT staff) to undertake the project and deliver successfully.
- Document proposed changes to the requirements and solution to enable impact analysis and revised business case, specifications, budgets, timescales and plans to be prepared and authorized
- Develop the processes necessary to efficiently operate the proposed solution including user guides, manuals, training materials and implementation and data conversion aids.
Skills on Resume:
- Technical Integration (Hard Skills)
- Requirements Gathering (Hard Skills)
- Vendor Liaison (Soft Skills)
- System Development Support (Hard Skills)
- System Testing (Hard Skills)
- IT Compliance (Hard Skills)
- Project Coordination (Soft Skills)
- Solution Evaluation (Hard Skills)
12. Oracle Database Administrator, Tech Dynamics, Richmond, VA
Job Summary:
- Work in a team of experienced DBAs and support 24/7X365 operations.
- Monitoring, administration, and troubleshooting database connectivity, backup/restore, and database performance issues.
- Monitoring, administration and troubleshooting RAC Setup availability, connectivity, backup/restore and performance issues.
- Monitoring, administration and troubleshooting Oracle Dataguard Setup availability, connectivity, reconfiguration and performance issues.
- Monitoring, administering, and troubleshooting cron jobs related to database and application administration
- Database and Oracle RAC space management
- Support mission critical databases for customers, where any unscheduled downtime will result in major business loss.
- Deliver high quality technical solutions to multiple global stakeholders in a fast paced environment
- Ensure that the team follows best practices for database design
- Performance tuning and optimization
- Resolve complex production issues, and ensure applications function smoothly through critical business cycles
- Provide in-depth analysis of business problems, and innovative solutions
- Oracle Database administration with versions 12c and 19c.
- Comfortable administrating through Oracle Enterprise Manager (OEM), but able to operate at the command line
- Demonstrate application functionality, solicit feedback and ensure that project sponsor requirements are met
Skills on Resume:
- Oracle DBA (Hard Skills)
- Performance Optimization (Hard Skills)
- Problem Solving (Hard Skills)
- RAC Management (Hard Skills)
- DataGuard Admin (Hard Skills)
- Stakeholder Engagement (Soft Skills)
- Teamwork (Soft Skills)
- Fast-Paced Adaptability (Soft Skills)