Oracle Database Administrator - Design & Installation (4-9 yrs)

Role : Oracle DBA

Location : Guindy, Chennai.

- Install, configure, and apply patches to Oracle and MySQL databases to ensure smooth operations.

- Manage the complete database lifecycle, including upgrades, migrations, and capacity planning.

- Possess expertise in database migration strategies and tools for seamless transitions.

- In-depth knowledge of Oracle RAC, Data Guard, MySQL Cluster, and various replication methods.

- Monitor database performance, identify bottlenecks, and implement tuning solutions for optimization.

- Enforce robust security protocols, including user access management and data encryption practices.

- Perform regular database backups and establish reliable data recovery procedures.

- Write complex SQL queries to extract, manipulate, and analyze data.

- Develop stored procedures and functions using PL/SQL to streamline database processing.

- Collaborate with development teams to design efficient and scalable database schemas.

- Analyze data requirements and recommend optimal database structures to meet business needs.

- Diagnose and resolve database-related issues, including connectivity problems, data corruption, and performance degradation.

- Assist application teams with database access management and query optimization strategies.

- Implement database monitoring tools to track performance metrics and identify potential issues proactively.

- Generate regular reports on database health, usage, and performance trends for continuous improvement.

- Solid experience in designing, optimizing, and debugging complex SQL queries, triggers, stored procedures, and functions.

- Strong understanding of database performance tuning, query optimization techniques, and managing database resources.

- Expertise in database replication, backup strategies, and high availability solutions for both Oracle and MySQL databases.

- Knowledge of database security management, user access controls, and encryption methods.

- Experience managing database migrations, upgrades, and integrations across Oracle and MySQL platforms.

- Strong problem-solving and troubleshooting skills to diagnose and resolve complex database issues.