Oracle Database Administrator

Defining processes and ensuring that the processes are adhered to Oversees and is responsible for successful completion of Installation, configuration and migration Ensure maximum uptime according to the SLA Understanding of Multi-geo support environment Responsible for building / maintaining a test environment Responsible for strategizing a backup plan and test plan for failure scenario Improves and maintains customer and employee satisfaction Suggests new technologies and design changes Monitoring and maintaining SLA requirements by the team members Planning Backup/Restoration Strategy for 24x7 operation support Suggesting patches/upgrades to maintain security level Testing / Auditing/processes as required from time to time Identify Skill gaps and plan for training / knowledge updating Assist in effort estimating, forecasting, and work planning for resources To participate or contribute on EN business in creation of proposals to drive Service improvement plans To provide support for on call escalations and doing incident & problem management Work on value adding activities such Knowledge base update & management, Training fresher, coaching analysts & conducting interviews/participation in hiring drives Familiarity and capability of learning new database technology across tower is an add-on. DBA point of contact for database requirements DBA should possess a sound understanding of the business. Technical Requirements Evaluate the Database Server Hardware Define/Recommend/Maintain Database Standards and Architecture Recommend Server H/W, Oracle Server Editions for a new Build Research and Recommend Patch management for database/instance and Impact Analysis. Initiate need and Impact Analysis for Database Migration/Upgrade Technical Consultation Vendor Support and Interaction Proficient in Oracle EE RAC database installation, upgrade, patching, maintenance, security, sysadmin functions and administration Monitor and optimize Oracle database performance and capacity planning Troubleshoot database issues, maintain database systems availability and scalability Create and maintain Oracle databases required for development, testing, Integration, QA and production usage Performs the capacity planning required to create and maintain the databases The DBA should work closely with Server, Backup and storage administrator to meet Backup, Hardware, Storage and Operating system requirements Perform ongoing analysis and tuning of the Oracle database Install new versions of the Oracle database and its features and any other tools that access the Oracle database Application code promotion and migrations of programs, database changes, reference data changes and menu changes through the development life cycle if applicable Hands on experience with Oracle Grid Control, PL/SQL, Exadata, Oracle RAC, Oracle Active Data Guard, Golden Gate Replication,OEM and other Oracle Products. Experience in Oracle Enterprise (OEM) 11g/12c/13c Experience and knowledge in migrating code, database changes, data and menus through the various stages of the development life cycle Performs database re-organizations as required to assist performance and ensure maximum uptime of the database Troubleshoots with problems regarding the databases, replication and database related Tools Good knowledge of physical database design and responsible for the physical database design Ability to perform database and operating system performance monitoring and the necessary adjustments Excellent skill in High availability, replication technologies and fail over Implement and enforce security requirements for Oracle databases Recommend and Review Backup and Recovery Strategies. Provides technical support to application development teams Having experience of DR Solution/Implementation/Execution through various sync methods. Designing strategy towards Capacity Management for DB tracks Designing Oracle Server Security (Server hardening,Auditing,compliance) Good knowledge of the windows and unix operating system(s) DB2/Oracle EBS,MYSQL knowledge is added advantange Soft Skills Excellent communication and conversation skills (Verbal and Written) Good working knowledge of MS OFFICE (Including MS Project and Visio) Should have a great customer handling skills Able to handle unforeseen situations High level of acceptance Can drive HCL’s value and its methodology Other Skills / Experience Worked on Production systems Experience with Database Migration, Installation, Upgrades and Patching Knowledge of Data warehousing and Other RDBMS Knowledge of Gateways for Other DBs Experience on Third Party backup tools Knowledge of NoSQL DB knowledge of Public and Private cloud Provider and their services Certification requirements OCA and OCP A candidate’s pay within the range will depend on their skills, experience, education, and other factors permitted by law. This role may also be eligible for performance-based bonuses subject to HCL policies. In addition, this role is eligible for the following benefits subject to HCL policies: medical, dental, vision, pharmacy, life, accidental death & dismemberment, and disability insurance; employee assistance program; 401(k) retirement plan; 10 days of paid time off (PTO) per year (some positions are eligible for unlimited PTO); and 10 paid holidays per year. Disclaimer HCL is an equal opportunity employer, committed to providing equal employment opportunities to all applicants and employees regardless of race, religion, sex, color, age, national origin, pregnancy, sexual orientation, physical disability or genetic information, military or veteran status, or any other protected classification, in accordance with federal, state, and/or local law. Should any applicant have concerns about discrimination in the hiring process, they should provide a detailed report of those concerns to View email address on click.appcast.io for investigation. #J-18808-Ljbffr