• Us Citizen

• Green Card

• Corp-Corp

• Consulting/Contract

• UG :- - Not Required

• PG :- - Not Required

• No of position :- ( 1 )

• Post :- 14th Nov 2020

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