Required Skills

Oracle databases.

Work Authorization

  • US Citizen

  • Green Card

  • EAD (OPT/CPT/GC/H4)

  • H1B Work Permit

Preferred Employment

  • Corp-Corp

  • W2-Permanent

  • W2-Contract

  • Contract to Hire

Employment Type

  • Consulting/Contract

education qualification

  • UG :- - Not Required

  • PG :- - Not Required

Other Information

  • No of position :- ( 1 )

  • Post :- 22nd Dec 2023

JOB DETAIL

Database Administrator:

Database Administrator with Oracle Database Knowledge is a senior-level position responsible for the design, implementation, and management of DB2 and Oracle databases. This role involves overseeing the database infrastructure, ensuring high availability, performance, and security. The Level 3 DBA provides technical expertise, leads database projects, and collaborates with other IT teams to deliver robust and scalable database services.

 

Key Responsibilities:

Oracle & DB2 Database Management:

 

·         Plan, install, configure, and upgrade Oracle Server instances and databases.

·         Monitor database performance, resource usage, and implement optimizations for better efficiency.

Oracle Database Management:

·         Possess in-depth knowledge of Oracle database architecture, installation, and administration.

·         Manage Oracle databases, including installation, configuration, and performance tuning.

Database High Availability and Disaster Recovery:

·         Implement and support database high availability solutions, Oracle Data Guard, or similar technologies.

·         Develop and test disaster recovery strategies to ensure data availability and business continuity.

 

Database Security:

·         Enforce security measures, access controls, and encryption to protect sensitive data.

·         Perform periodic security audits and vulnerability assessments.

Database Performance Tuning:

·         Identify and resolve complex performance bottlenecks, slow queries, and resource contention issues and Oracle databases.

·         Optimize database configurations for optimal performance.

 

Database Backup and Recovery:

·         Develop and maintain comprehensive backup and recovery strategies for Oracle databases.

·         Perform regular backups and test recovery procedures to ensure data recoverability.

Database Monitoring and Alerts:

·         Set up proactive monitoring and alerting for database health and performance issues.

·         Respond to alerts and incidents promptly to minimize service disruptions.

Database Patching and Upgrades:

·         Plan and execute Oracle Server and Oracle database patching and version upgrades following best practices.

Database Automation and Scripting:

·         Develop and maintain automation scripts and workflows to streamline routine database management tasks.

Database Documentation:

·         Create and maintain detailed documentation of database configurations, procedures, and troubleshooting steps.

Troubleshooting and Issue Resolution:

·         Lead efforts to diagnose and resolve complex database-related issues.

·         Collaborate with Level 1 and Level 2 support and other teams to address escalated incidents.

Database Project Management:

·         Lead database-related projects, such as database migrations, consolidations, and performance enhancements.

 

Requirements:

·         Bachelor’s degree in computer science, Information Technology, or related field (or equivalent experience).

·         Several years of proven experience as a Level 3 Oracle Database Administrator with advanced knowledge of Oracle databases.

·         In-depth understanding of Server architecture, configuration, and performance tuning.

·         Strong proficiency in Oracle database architecture, installation, configuration, and administration.

·         Expertise in database high availability solutions for Oracle databases.

·         Familiarity with database security, backup, and recovery best practices.

Company Information