ESG Consulting/Norcross, GA
Seeking a Junior Oracle production DBA that has worked with high availability Oracle Rac. You will also support Dev, QA environments and Data Warehouse. In this role you will pick up some development skills as well. (if you are a Jr Oracle Database Developer and would like to transition to Support, then please apply). No on call needed for this role; as it is a follow the Sun environment across the globe. No travel.
Functions:
Provide day to day support of high OLTP & Data Warehouse High Availability of Oracle 11g databases
Provide Database Administration and support of databases to the application development teams.
Implement and support Administration tasks such as Backup and recovery procedures, database utilities, and data replication technologies while supporting the development, test, and production environments.
Provide technical support and troubleshooting assistance to developers. This support will involve effective communication, escalations on Oracle bugs, issues, and or identifying anomalies to developers for their corrective actions for all production and non production releases (This task is a continuous effort throughout the SDLC)
Assume primary ownership for the development requests submitted and work with the application team and DBA manager on prioritization.
Identify root causes of production problems and work with developers to circumvent and resolve such problems.
Provide technical services to monitor and maintain environments, (the Oracle production, development, and test databases) running on firm's strategic platforms including periodic software upgrades and migration of the Oracle products.
Document operational or newly engineered solutions properly to educate and inform the clients and DBAs from the various levels of the organization.
Create and maintain Unix and SQL scripts to automate tasks such as setting up and refreshing DEV, QA, and Production database environments.
Log, schedule and track all changes using change management system tools.
Responsible for all corrections to the database infrastructure and for repairs to the system or database.
Skills
2 years of Full Development Life Cycle experience in OLTP using any SDLC methodologies.
2 years database administration with Oracle 10g/11G
Oracle RAC, ASM, Oracle Dataguard, Grid Control, RMAN.
Experience in reviewing, and debugging, tuning PL/SQL & SQL code
Experience with Linux/Unix platforms
Experiencing with Linux, Shell and windows Scripting.
A plus is working experience using Tools such as SQL Profiler, TOAD
Display ability in troubleshooting issues, problem solving and analytical, time management, written and communication skills, decision making, interpersonal relationship skills.
Display strong inter-personal, verbal and written communication skills and experience
Highly motivated with a commitment to quality service.
Plus:
Experience with Full Development Life Cycle in DW projects using any SDLC methodologies.
Working knowledge of Oracle Golden Gate is desirable.
Working in large environments.
Experience with versioning control, ClearCase.
Knowledge in Healthcare industry/HL7.
SQL Server experience.
Knowledge of the EMC DMX VMAX CX, HP storage systems.
Experience in reviewing, and debugging, tuning PL/SQL & SQL code, a plus is able to do some writing as well
A plus only, not required is experience in physical characteristics such as table design, relationships, data partition, efficient indexes, storage allocation, capacity planning etc.
Employment Type: Permanent
Work Hours: Full Time
Other Pay Info: market
Apply To Job