Senior Oracle DBA Job Description

Senior Oracle DBA Job Description

4.9
179 votes for Senior Oracle DBA
Senior oracle DBA provides maintenance of physical database:- Creates physical database objectives following established standards and processes employed by database team.- Enforces database standards and follows up on inconsistencies.- Performs routine reviews of databases and systems to ensure acceptable levels of performance.o Reports problem performance areas and recommendations for improvement.o Follows up on recommendations and actively pushes for implementation as appropriate.- Understands and applies database concepts such as database definitions, parameters, database component placement, reorganization, access methods and security definitions.- Works with capacity planning, operations, application developers and other TSG teams on database performance and access issues.

Senior Oracle DBA Duties & Responsibilities

To write an effective senior oracle DBA job description, begin by listing detailed duties, responsibilities and expectations. We have included senior oracle DBA job description templates that you can modify and use.

Sample responsibilities for this position include:

Migrate the existing Platform to the current engineered Standard of Oracle 12c, Active Dataguard, RAC and Pure Storage, using Pure Storage Snaps for fast Test and Dev refreshes
Actively participate in solutions architecture, product engineering and continual service improvement
Test backup and recovery scenarios, formulate disaster recovery procedures
You will be responsible for install, maintain, support/troubleshooting predominantly Oracle products and help our customers making best use of the technology
Troubleshoot and resolve, in conjunction with Operational/Customer DBAs, database application issues across production, test and development environments
Provide input into architecture and design
Your experience in MYSQL and any other NoSQL DBMS would be a distinct advantage
You may also work on Microsoft SQL servers (2008, 2012, and 2014)
Mentor fellow DBAs
Configure and install from scratch Oracle database server in nominal to complex configurations

Senior Oracle DBA Qualifications

Qualifications for a job description may include education, certification, and experience.

Licensing or Certifications for Senior Oracle DBA

List any licenses or certifications required by the position: OCP, DBA, OCA, OCI, AWS, SQL, SSO, OPP, EBS, SSL

Education for Senior Oracle DBA

Typically a job would require a certain level of education.

Employers hiring for the senior oracle DBA job most commonly would prefer for their future employee to have a relevant degree such as Bachelor's and University Degree in Computer Science, Engineering, Technical, Education, Information Technology, Information Systems, Science, Communication, Design, Business

Skills for Senior Oracle DBA

Desired skills for senior oracle DBA include:

ITIL framework
Vocabulary and best practices
At least one database management system
Dataguard
OEM
Operating systems and systems administration concepts
RMAN
USPTO mission and technical infrastructure
Database creation
Disk initialization

Desired experience for senior oracle DBA includes:

Administration tasks for several Oracle databases
Provide advice and support to development resources
Supporting the standing standards, policies and procedures of the customer team
Provide mentorship to group members and will be expected to help develop and support mid and junior level staff
May be scheduled for after hours on-call support and will be required to apply production packages during non-peak hours
Run diagnostic tools to identify database performance bottlenecks, and take appropriate corrective actions to improve database performance

Senior Oracle DBA Examples

1

Senior Oracle DBA Job Description

Job Description Example
Our company is growing rapidly and is hiring for a senior oracle DBA. Thank you in advance for taking a look at the list of responsibilities and qualifications. We look forward to reviewing your resume.
Responsibilities for senior oracle DBA
  • Provide infrastructure support in accordance with all applicable and defined SLA's covering the defined supported estate for Change, Incident and Problem activities
  • Focusing and prioritising on the key deliverables for all those applications deemed critical to BT’s Operations
  • Monitor database performance, propose and implement agreed performance enhancing changes
  • 24x7 On-call support for Production Incident resolution
  • Responsible for installation support focusing on the design, installation, configuration, development, integration, implementation, and testing of Oracle database services in a complex environment with multiple classification enclaves and integrated with Department of Defense (DoD) Command and Control (C2) systems utilizing associated information assurance (IA) processes/procedures
  • Responsible for transforming high-level/low-level enterprise design artifacts into a working, representative test system within a lab environment, developing pass/fail criteria, performing controlled testing, capturing and analyzing results, optimizing system performance, and troubleshooting anomalies
  • Work closely with Government engineers during all stages of testing and be responsible for working with other enterprise disciplines as previously-tested component systems are later integrated into larger, enterprise-level systems of systems
  • Oracle Database Senior Administrator will be required to record, document, and deliver all related testing, installation, configuration, optimization, operations, and IA-compliance settings/configurations/processes/procedures upon completion of testing or incrementally as determined by the customer
  • Capture and document system details within architectural drawings using AutoCAD to be used during final system installation, configuration, integration, and implementation
  • Customer-facing position and may require interaction with senior customer leadership on matters concerning design, engineering, or functional areas
Qualifications for senior oracle DBA
  • Research and recommend innovative tools and where possible automated approaches for system administration tasks
  • Provide System Production support per request from various lines of business
  • Experience with Oracle on Cloud especially on Rackspace
  • Proficiency developing developing stored procedures and triggers
  • Be ultimately responsible for development and pastoral care and welfare of the staff under your line-management including objective setting, appraisal, performance review and training
  • Oracle and Structured Query Language (SQL) Server Relational Database Management System (RDBMS) on a Window platform
2

Senior Oracle DBA Job Description

Job Description Example
Our innovative and growing company is searching for experienced candidates for the position of senior oracle DBA. Please review the list of responsibilities and qualifications. While this is our ideal list, we will consider candidates that do not necessarily have all of the qualifications, but have sufficient experience and talent.
Responsibilities for senior oracle DBA
  • STIG Compliance
  • Participates in a 24X7 pager rotation, providing Subject Matter Expert support to the on call DBA as needed
  • Provide primary support for Oracle database environments including daily operations, backup and recovery, performance monitoring and tuning, and production support
  • Provide advice and recommendations on database architecture, design and implementation
  • Develop, support and communicate database policies, standards, guidelines and procedures
  • Design and implement database solutions upholding high standards while meeting customer requirements for reliability, available, scalability, security and performance
  • Install, upgrade and test database software in addition to troubleshooting database issues
  • Responsible for development of database backup routines and recovery procedures, ensuring data integrity and identifying potential data errors
  • Plan and perform disaster recovery testing with database restoration in alternate locations
  • Assist development teams with planning and implementations, including review and approval of database schema changes, routines and query optimizations
Qualifications for senior oracle DBA
  • Experience Oracle RAC 11g/12c administration and development
  • Bachelor’s degree in Computer Science or related discipline is generally required
  • 7+ years of experience focused on Oracle DBA administration in medium to large corporate environments
  • System knowledge may include experience with Unix/Linux server from various vendors (Oracle, HP, IBM, etc)
  • Working knowledge of Postgres, Cassandra, MS SQL Server is a plus
  • Working knowledge of AWS is a plus
3

Senior Oracle DBA Job Description

Job Description Example
Our company is looking for a senior oracle DBA. Please review the list of responsibilities and qualifications. While this is our ideal list, we will consider candidates that do not necessarily have all of the qualifications, but have sufficient experience and talent.
Responsibilities for senior oracle DBA
  • Evaluate technologies for IT strategy
  • Support enterprise automation strategies and goals
  • This role will maintain Oracle databases, including all production, backup and development files
  • Install, configure, upgrade, migrate and patch Oracle 10gR2/11g/12c databases on Solaris 10 and Linux 6,7
  • Responsible for monitoring, troubleshooting, performance tuning, high-availability strategies in a 24x7 production environment
  • Develop and implement replication, archiving and backup and recovery strategies (DR Failover testing capabilities)
  • Anticipate hardware requirements and storage capacity planning for Development, Testing, QA, Staging, and Production for scalable database growth and performance
  • Proactively monitor and optimize for better performance
  • Resolve locking conflicts/blocking and resource utilization
  • Identify and resolve database performance issues, database capacity issues and other distributed data issues
Qualifications for senior oracle DBA
  • Current DBA Certification in related area such as Oracle, DB2, SQL Server preferred
  • Ability to adapt to a fast-changing and fast-integrating business environment
  • Ability to work effectively in dynamic environment with a broad range of end-user configurations
  • Ability to communicate effectively with support peers, end users, and all levels of corporate management
  • At least 4 years experience with large scale distributed, horizontally scalable architectures
  • At least 4 years experience using Github
4

Senior Oracle DBA Job Description

Job Description Example
Our innovative and growing company is looking to fill the role of senior oracle DBA. If you are looking for an exciting place to work, please take a look at the list of qualifications below.
Responsibilities for senior oracle DBA
  • Provide 24/7/365 primary application dba support of specific global database applications, performing application releases, app/data patching
  • Supporting the business on-call after business hours and weekends on a rotation basis for Oracle
  • Lead database development, tuning and optimization expertise to application development and support teams on an ah-hoc or continual basis
  • Contribute towards Architecture, Engineering of Db solutions
  • Maintain complete inventory, configuration and documentation of deployed systems
  • Work within the project management framework defined for IT Production North America
  • Cross train members of the Database team in all responsibilities and maintain a daily and weekly rotation schedule for these
  • Identify operational and infrastructure risks within the environment and work with the application development team and CM business to make corrections and mitigate risks
  • Ensure that all systems are backed up and monitored according to the business requirements and notify the data owners when there are failures
  • Ensure optimal resilience of deployed systems and meet all disaster recovery and compliance requirements dictated by the business
Qualifications for senior oracle DBA
  • Perform database performance monitoring and tuning
  • At least 4 years experience in continuous integration and development methodologies tools
  • 7+ years database administration experience with minimum 5+ years ORACLE 11g, 12c.· 5+ years experience in administering Oracle ASM, RAC, Clusterware, DGuard, exp/datapump, online reorg/re-indexing.· 5+ years experience performance tuning both instance and SQL statement level tuning
  • 3+ years’ experience in administering MSSQL Active-Active, Active-Passive Cluster, Peer to peer replication and transactional replication
  • 2+ years’ experience in administering Oracle SAP, Oracle E-Business Databases, and packaged programs on Oracle
  • 1+ years knowledge of advanced compression experience
5

Senior Oracle DBA Job Description

Job Description Example
Our company is growing rapidly and is hiring for a senior oracle DBA. We appreciate you taking the time to review the list of qualifications and to apply for the position. If you don’t fill all of the qualifications, you may still be considered depending on your level of experience.
Responsibilities for senior oracle DBA
  • Define, implement and support database backup and recovery policies using RMAN and/or storage replication technologies
  • Develop and code SQL/PL-SQL project enhancements
  • Review and assist in the creation of Data Models
  • Participate in Trading and Fuels on-call IT application support
  • Installation, configuration, and architecture design for OEM12g/13c, Oracle 12c Cloud Management Pack, and Oracle 12c Lifecycle Management Pack
  • Provide database technical evaluation and recommendation on database design and architecture, integration and development, database high availability solution, database replication architecture, database backup, disaster and recovery strategies, grid computing and cloud management, database monitoring and management, performance tuning, database audit and security compliance and daily database operation and maintenance
  • Write shell scripts in RedHat Unix platforms
  • Ability to understand use case requirements and plan for product life cycle testing
  • At least be a senior level Oracle DBA, familiar with Oracle database software installation and configuration, and Oracle database software patching on RedHat Unix platforms
  • Responsible for Production database systems meeting the SLA availability targets
Qualifications for senior oracle DBA
  • Ability to configure ORACLE MySQL DB architecture, installation, configuration setup on Linux OS
  • Experience with installing Multiple Instances on single machine
  • Take responsibility, plan and structure all tasks (technical or non-technical) assigned as part of my role to ensure a business efficient service is delivered to our customers
  • Contribute to and participate in all knowledge sharing activities and provide web based media content for CTS, my team and customers
  • Take an active part in DOMAIN (Expertise) activity to develop LWOW and improve ‘Best database Practice’ within the unit
  • Take part in system performance and service improvement consultancy work Assume management of major incidents and take ownership of escalations in accordance with the agreed SLA and all applicable operational documents across all supported platforms –

Related Job Descriptions

Resume Builder

Create a Resume in Minutes with Professional Resume Templates