• Us Citizen

• Corp-Corp

• Consulting/Contract

• UG :- - Not Required

• PG :- - Not Required

• No of position :- ( 1 )

• Post :- 13th Nov 2020

JOB DESCRIPTION:
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""""