Position: – Oracle DB2 DBA
Client:- Hexaware/Freddie Mac
Location :- Plano, TX (On-Site)
Duration :- 1 + Years
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 Oracle DB2 DBA 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 Oracle DB2 DBA 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 Oracle DB2 DBA performance.
Database Backup and Recovery:
· Develop and maintain comprehensive backup and recovery Oracle & DB2 DBA strategies for Oracle databases.
· Perform regular backups and test recovery procedures to Oracle & DB2 DBA 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 DB2 DBA database patching and version upgrades following best practices.
Database Automation and Scripting:
· Develop and maintain automation Oracle DB2 DBA and workflows to streamline routine database management tasks.
Database Documentation:
· Create and maintain detailed documentation of database Oracle DB2 DBA 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 DB2 DBA databases.
· Familiarity with database security, backup, and recovery best practices.
· Proficiency in SQL and PL/SQL scripting and Oracle DB2 DBA automation for routine tasks.
· Experience with database clustering and load balancing Oracle DB2 DBA technologies is advantageous.
· Strong problem-solving and analytical skills to diagnose and resolve complex database issues.
· Excellent communication and leadership abilities to guide junior team members and collaborate with cross-functional teams.
· Oracle (e.g., Oracle Database Administrator Oracle & DB2 DBA Certified Professional) are preferred.
Thanks & Regards,
Abhinay Singh
Sr. IT Recruiter
469-654-1695
Read more:
top 10 staffing companies in usa
More Corp to corp hotlist
Join linkedin 42000+ US Active recruiters Network
Join No.1 Telegram channel for daily US JOBS and Updated HOTLIST