As a Sr. Oracle Database Administrator, your primary aim is to address issues related to Data Migration, including Validation, Clean-up, and Mapping, while also understanding the importance of Data Dictionaries. Key Responsibilities: - Installation, configuration, and upgrading of Oracle server software - SE, EE & RAC and related products. - Establish and maintain sound backup and recovery policies and procedures. - Database design and implementation skills would be an added advantage. - Implement and maintain database security by creating and maintaining users and roles, assigning privileges, and monitoring databases. - Perform database tuning and performance monitoring. - Perform application SQL query tuning and performance optimization. - Setup and maintain documentation and standards. - Plan growth and changes through capacity planning. - Perform general technical troubleshooting and provide consultation to development teams. - Interface with Oracle Corporation for technical support. - Manage Patch Management and Version Control. - Implement Data Replication using Data Guard and Golden Gate. - Set up DR site and DR failover. Experience Level & Qualification: - 3-5 years of experience as a DBA. - Preferably Oracle certified DBA. - Preferably a BS in computer science or related engineering field. Essential Skills: - Good understanding of the Oracle database, related utilities, and tools. - Good understanding of Data Replication Software such as Data Guard and Golden Gate. - Good understanding of the underlying operating system. - Knowledge of physical database design. - Ability to perform Oracle and operating system performance tuning and monitoring. - Knowledge of all Oracle backup and recovery scenarios. - Understanding of Oracle security management. - Knowledge of Oracle resource management. - Understanding of Oracle data integrity. - Sound knowledge of implemented application systems. - Experience in code migration, database change management, and data management through development life cycle stages. - Sound knowledge of database and system performance tuning. - Strong communication skills with management, development teams, vendors, and systems administrators. - Provide strategic database direction for the organization. - Ability to handle multiple projects and deadlines. - Possess a sound understanding of the business. - Fair understanding of Oracle database development. - Proficiency in RHEL and Windows Operating systems for DBA specific activities. Additional Skills: - Knowledge of Postgres and Oracle to Postgres migration will be an addon.,
As a Software Engineer DB, your primary aim is to address issues related to Data Migration, including Validation, Clean-up, and Mapping. It is crucial for you to understand the importance of Data Dictionaries. Key Responsibilities: - Develop procedures and functions using PL/SQL. - Evaluate Oracle features and related products. - Establish and maintain backup and recovery policies. - Design and implement databases. - Implement and maintain database security by creating and managing users and roles, as well as assigning privileges. - Perform database and application tuning for optimal performance. - Set up and maintain documentation and standards. - Plan for growth and changes through capacity planning. - Provide 24x7 support as needed. - Troubleshoot technical issues and provide consultation to development teams. Experience Level & Qualification: - 4-8 years of experience as a PL/SQL developer. - Educational Background: B.Sc / BE / B. Tech. Essential Skills: - Solid knowledge of Java, SQL, and PL/SQL with a good understanding of Oracle & PostgreSQL. - Experience in creating PL SQL packages, procedures, triggers, functions, views, and migrating complex data sets. - Proficiency in writing PL/SQL Triggers, Functions, Views, Cursors, Stored Procedures, and Exceptions in Oracle & PostgreSQL. - Familiarity with integrating data into other software systems. - Analytical and programming capabilities, with the ability to learn and adapt to new technologies. - Working knowledge of Linux (Ubuntu) Environment. - Oracle and operating system performance tuning skills. - Understanding of Oracle data integrity. - Experience in code migration, database change management, and data management throughout the development life cycle. - Ability to provide strategic database direction for the organization.,