Senior Oracle DBA Job Description
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:
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:
Desired experience for senior oracle DBA includes:
Senior Oracle DBA Examples
Senior Oracle DBA Job Description
- 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
- 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
Senior Oracle DBA Job Description
- 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
- 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
Senior Oracle DBA Job Description
- 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
- 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
Senior Oracle DBA Job Description
- 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
- 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
Senior Oracle DBA Job Description
- 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
- 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 –