• Us Citizen

• Green Card

• Corp-Corp

• Consulting/Contract

• UG :- - Not Required

• PG :- - Not Required

• No of position :- ( 1 )

• Post :- 16th Nov 2020

Role: Oracle Pl/SQL Developer wit Some Database Exp.

Location: St Louis, MO (Have to relocate On-site)

Duration: Long Term

 

General requirements

·         Performs installations and configurations of grid infrastructure, databases, clients etc.

·         Designs and maintains access and security administration.

·         Designs, implements and maintains backup and recovery strategies on Database Management Systems.

·         Supports multiple services and multiple databases of medium complexity with multiple concurrent users, ensuring control, integrity and accessibility of data.

·         Designs, installs, configures and maintains High Availability (RAC, RAC One Node, Data Guard etc.) Database solutions.

·         Expertise in setup using OEM as a monitoring and diagnostics tool and identifies/resolves the performance issues.

·         Troubleshoots alerts (alert log, Jobs, Disk Group, Tablespace etc.) and performance issues.

·         Performs capacity planning of Oracle server environment and provides recommendations to management to sustain business growth.

·         Designs, implements, maintains Disaster Recovery (DR) methodologies and creates documentation.

·         Gathers business requirements and designs, implements multiple projects along with the production support.

·         Creates standard operational procedures and templates.

·         Acts as mentor for Database Administrators and Associate Database Administrators.

·         Performs research and provides plans to remediate complex business problems.

·         Assists the development teams to improve database design and procedures on PL/SQL best practices etc.

 

Specific requirements

·         Seeking an experienced DBA with extensive knowledge with PL/SQL programming and database architecture. 

·         The ability to read, analyze, and enhance PL/SQL scripts delivered to our team by the development team. 

·         Able to utilize all Oracle DB tools and functionality to create/modify PL/SQL scripts for performance on large DBs and datasets. 

·         Thrives on problem solving and able to apply those skills to think outside the box to engineer new solutions as well as improve existing solutions. 

·         A good communicator to interface with APO production DB support teams. 

·         The ability to write detailed documentation along with MOPs for all projects assigned to them.

·         Strong knowledge of database architecture and its implementation

·         Strong understanding of best practices in maintaining medium to large scale Oracle database systems

·         Strong knowledge of PL/SQL programming language

·         Strong understanding of Change Management procedures

·         Strong knowledge of Instance, database and query tuning to improve the performance of the database/application

·         Strong understanding of SAN technologies related to SQL server disk layouts

·         Strong knowledge of Windows/Linux/Solaris operating systems and shell scripting

·         Ability to communicate orally and in writing in a clear and straightforward manner

·         Ability to communicate with all levels of management and company personnel

·         Ability to handle multiple projects and tasks

·         Ability to make decisions and solve problems while working under pressure

·         Ability to prioritize and organize effectively

·         Ability to show judgment and initiative and to accomplish job duties

·         Ability to use personal computer and software applications (i.e. word processing, spreadsheet, etc.)

·         Ability to work independently

·         Ability to work with others to resolve problems, handle requests or situations

·         Ability to effectively consult with department managers and leaders