Senior Oracle Database Analyst

Job Description:

Job Title: Senior Oracle Database Analyst

Primary location of assignment: 600 CANAL STREET Richmond, VA 23219

How many contractors are you needing? 1

What is the preferred candidate location (local, non-local, remote?) and is there flexibility? Local Candidates ONLY (this position is not remote)

Will travel be required for this position? If so, how often? Occasional travel based on project needs to VA nuclear facilities

• Candidate will need to obtain nuclear access

Will this candidate be dealing with Private Personal Information (PPI), Company Sensitive Information, or Credit Sensitive Information? Yes

Are any certification required: Oracle Certified Professional

Top Required Skills

1. MUST have hands on experience and have previously used an Oracle DBA – Oracle versions 19c (container base features) – 23ai
2. MUST have experience with the following Oracle technologies RAC, TDE, Data Guard, Oracle Exadata database appliances
3. MUST have previously worked hands on as a Senior Database Analyst and be able to apply advanced knowledge/principles and procedures
4. MUST have experience with 10Tb database systems

Candidate Resume Should be screened for the Following Experience in Handling:

• Enterprise level Oracle database administration experience with Oracle on Red Hat Linux operating systems, including but not limited to data migration, data replication, database cloning, user administration, and database backup and recovery
• Solid understanding of Oracle internal architecture.
• Hands-on experience with Oracle Database installation, upgrades, and migrations
• Experience in managing and maintaining multiple production database environments.
• Strong performance tuning and troubleshooting skills.
• Proficient in scripting to automate routine DBA tasks.
• Experience with database auditing and working in regulated environments.

What soft skill requirements do you have (team fit and personality requirements)?

• Strong communication skills both verbal and written
• Ability to lead, collaborate, or work effectively in a variety of teams, including multi-disciplinary teams

Nice to Have Skills:

• SAP experience
• Oracle RAC experience
• Familiarity with data replication technologies such as Golden Gate.

High Level Project Overview/Duties:

• Support multiple Oracle databases on Linux operating systems
• Responsible for software installation, database creation, support and administration of Oracle databases
• Work in collaboration with multiple business units and provides resolution for complex problems across project teams.
• Evaluate and research new database features and technologies.
• Participate in a 24x7 on-call rotation supporting a large Oracle environment.
• Monitor and optimize performance issues at the application and database level.
• Plan, design, implement, enhance and maintain complex databases, access methods, database security and audit & regulatory requirements
• Must be able to work and perform Oracle Administration tasks independently as well as part of the team
• Excellent written, verbal and interpersonal communication skills
• Capable of a high level of accuracy and attention to detail

Knowledge, Skills, Abilities, and Experiences (Minimum Requirements) 

The successful candidate will have 5-7 years experience as an Oracle DBA and will possess and apply knowledge of principles, practices, and procedures to carry out all aspects of the job of Oracle database support.  The Candidate will have direct experience handling the following tasks:

• Enterprise level Oracle database administration experience with Oracle on Red Hat Linux operating systems, including but not limited to data migration, data replication, database cloning, user administration, and database backup and recovery
• Solid understanding of Oracle internal architecture.
• Hands-on experience with Oracle Database installation, upgrades, and migrations
• Oracle database administration experience with Oracle 12G and above.
• Manage and support various backup and recovery strategies for Oracle databases (e.g. RMAN, Export/import, and Standby databases).
• Monitor and tune database performance using Oracle Enterprise Manager/Grid Control.
• Upgrade and patching of the Oracle Database.
• Shell script programming to automate routine DBA tasks.
• Experience managing, maintaining a production RAC database environment with Strong Oracle RAC performance tuning and troubleshooting skills.
• Knowledge of Oracle ASM administration.
• Solid understanding of Oracle internal architecture.
• Shell script programming to automate routine DBA tasks.
• Experience in database software management (installation, patching and version management)

Required Years of Experience:

• Minimum 5+ years direct experience as a Senior Database Analyst

Education:

• Minimum High School Diploma or Equivalency is required

Are there any specific companies/industries you’d like to see in the candidate’s experience?

• MUST have prior experience working in a regulated industry and environment, preferably utilities

Preferred Interview Process Overview (High level):

• Round 1 Interview will be virtual
• Round 2 will be an onsite in person interview (required)