Database Administrator

Database Administrator

Role: Database Administrator Start Date: 08/03/2020 End Date: 01/15/2021 Location: Richmond, VA 23219 Interview type: Webcam Interview Only Pay Rate: $47/hr on w2 all inclusive Client: State of VA

Complete description: Local candidates strongly preferred. Interviews to be conducted by Skype or Google Hangout. Some after-hours and weekend hours required based on workload. Candidates must participate in on-call rotation. Candidate hired will work ONSITE 50% of the time now, no exceptions, and work ONSITE 100% of the time after restrictions are lifted.

Oracle DBA/Proficient in oracle database migration from Solaris to Linux/Weblogic configuration/ administration fusion middleware/ including Apex administration and support.

• 10+ years of IT experience as an Oracle DBA in a UNIX/Linux environment.

• Good understanding of Unix Administration with respect to supporting oracle database and application servers.

• Proficient in shell scripting and job scheduling.

• Expertise in Production Oracle 12c environments including PL/SQL, OEM, RMAN, Data Guard.

• Proficient in managing databases with multi-tenant architecture.

• Proven experience in migrating large databases from Solaris to Linux with minimum downtime with latest database release versions.

• Proficient in database upgrade and quarterly PSU patching of oracle database using OEM provisioning tool.

• Expertise with loading data using sql* Loader / Data Pump utilities.

• Expertise with Oracle performance tuning.

• Experience with database character set migration.

• Experience with managing and upgrading Oracle Enterprise Manager 12c and higher.

• Expertise in Oracle database performance tuning and troubleshooting.

• Strong experience in backup and recovery of large databases from Tape or RMAN online backups.

• Working knowledge of Tablespace Encryption and Oracle Advanced security tools.

• Proficient with using sql developer/ TOAD and Grid control tools for Designer experience (desired).

• Expertise in configuring and managing Oracle Fusion Middleware, Web Tier, Apache and Tomcat Servers.

• Experience in setting up weblogic on Linux/Solaris platform.

• Expertise in configuring mod pl/sql, ORDS and Apex Administration 5.0 or higher.

• Experience with Restful Web Services.

• Experience with configuring/installing SSL Certificates and Oracle Wallets for the database and Web Servers.

• Develop, review and enforce database standards.

• Experienced with SDLC methodologies.

• Ability to document database performance issues and help team members understand the resolution process.

• Able to work independently.

• Assist in the database and Web Application releases.

• Ability to implement complex changes to existing database schemas.

• Preferred working knowledge in Windows sql-server/IIS web server.

• Experience in Oracle cloud/AWS/Azure is preferable.

Skills:

• Oracle database 12c Required 6 Years
• Oracle database 11g Required 10 Year
• Oracle grid control to include version 13c Required 7 Years
• Oracle weblogic 12c/fusion middleware Highly desired 7 Years
• Oracle apex administration and support Required 5 Years
• Oracle db migration from solaris to linux (database 12c/11g) Required 10 Years
• Oracle database backup/restore/rman/dataguard Required 10 Years
• Oracle performance tuning/database maintenance/management Required 10 Years
• On-call production support Required 10 Years
• Oracle cloud setup/AWS/Azure Administration Desired 3 Years
• Windows/sql server/IIS administration Highly desired 5 Years