Oracle 11g RAC Shell Script DBA LinuxUnix OEM Consultant (Jobs in Atlanta, GA)   Requirement id 91993 Job title Consultant Job location in Atlanta, GA Skills required OCP Certification, Hands-On Development, PL/SQL, Oracle 11g RAC Shell Script DBA LinuxUni Open Date 03-May-2019 Close Date Job type Contract Duration 12 Months Compensation DOE Status requirement --- Job interview type ---    Email Recruiter: coolsoft Job Description Consultant: OCP Certification, Hands-On Development, PL/SQL, Oracle 11g RAC Shell Script DBA LinuxUni Start Date :05/26/2017 End Date :12/31/2017 Submission Deadline :05/22/2017 Client Info: Note to vendors - This position is being posted as contract position, however agency would like to convert this to contract to hire depending on the performance of the candidate. The agency will sponsor the H1 visa, if required, when the state decides to hire the candidate. Description: Job Role – Oracle Database Administrator Hands on Oracle Database Administrator experience running on Oracle 12c on RedHat Linux is a must - please do not apply otherwise. The candidate will also serve as Oracle Developer – Complex SQL, PL/SQL, and Shell Scripting experience is desired. The individual needs to work with end users directly for working on adhoc reports on need basis. The incumbent is expected to understand the data model and the actual data contained in the database, so he/she can generate reports. This is a single DBA situation, must be independent and organized. We are looking for individuals who can work on the assignment right away, with minimum learning curve. The interview process will consist of resume review (step 1), telephone screening (step 2), and in-person interview (step 3). We plan to complete this process within 2 weeks after receiving resumes. Face to face is a must and video interviews (skype, etc.) will not be acceptable. Job duties include but not limited to: Under broad supervision, the Oracle Database Administrator will be responsible for provisioning, maintenance, monitoring, performance tuning, backup and disaster recovery of databases. Database monitoring of Oracle 12c running on RedHat Linux using Enterprise Cloud Control, including Development, Test and Production environments. Administration of Oracle Active Data Guard for high availability, monitor archive logs, bandwidth usage between primary and standby databases Monitoring Export/Import to ensure that RMAN and Full Database backups are running correctly and address any issues that may occur. The databases are hosted on physical servers, and these are backed up using Backup exec/Data Domain. Database patching, monitoring alerts, monitoring space availability and address issues that may surface. Monitor access to the database, log manual actions for audit purposes. Respond to issues raised by developers, end users about database performance Work with Process Improvement and Oversight (PIO) division to produce Adhoc reports that help the SBWC leadership to analyze operational data. Improve the response time of reports by tuning SQL queries, procedures, functions, triggers, creating indexes and so on. Support ICMS2 software developers with complex SQL queries, support with query tuning effort. Provide support by writing batch jobs, scheduling, using SQL, PL/SQL, and Shell Scripting. This role involves database software development apart from database administration. Create technical documentation to ensure long term support for the database by the agency staff. Provide knowledge transition as necessary to SBWC staff. SBWC envisions replenishing database server hardware in the near term, Oracle DBA is expected to plan and execute this transition in collaboration with SBWC System Administrator. Patch the Oracle software and potentially upgrade to 18c as needed. Related components, like APEX, Oracle Data Guard, and Oracle Business Intelligence (BI) publisher need to be upgraded. Produce reports using database views, materialized views and SQL queries. These objects are published to web applications for user functionality. Work with SBWC subject matter experts (SME) and Process Improvement and Oversight division staff to analyze data and produce meaningful analytics that can support the leadership team in deci   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 91993 while calling.   Other jobs in GA: Alpharetta (12), Atlanta (37), Conyers (2), Downtown Atlanta (1), Dublin (1), Duluth (5), Dunwoody (4), Lawrenceville (2), Norcross (4),         (Consultant: OCP Certification, Hands-On Development, PL/SQL, Oracle 11g RAC Shell Script DBA LinuxUni in Atlanta, GA)

Featured Jobs Developer (Jobs in Atlanta, Georgia) Data Architect ETL Specialist (Jobs in Raleigh, North Carolina) SQL Architect (Jobs in Richmond, Virginia) Business Analyst Financial Analyst (Jobs in Fredericksburg, Virginia) Cyber Architect (Jobs in Columbia, South Carolina) VxRails Consultant (Jobs in Boise, Idaho) Project Manager Microsoft Manager (Jobs in Raleigh, North Carolina) Agile Jira UAT Manager (Jobs in Atlanta, Georgia) - - Analyst (Jobs in Portland, Oregon) HTMLCSSJavaScript Developer (Jobs in Lincoln, Nebraska)