As a Database Administrator with 3+ years of experience, you will be responsible for Oracle Database Administration including Oracle 11g and 12c. Your role will involve managing Oracle RAC and Data Guard database administration, creating and maintaining databases for various usage, and handling database installations, upgrades, and patching. You will need to interface with Oracle Corporation for technical support, monitor database alerts regularly, and take necessary actions. Performance analysis and tuning for the database, managing complex Oracle Environments, and backup and recovery using RMAN will be part of your daily tasks. Ensuring database integrity, re-organizing databases for performance, and providing feedback to the Development team for serviceability improvements will be crucial. Troubleshooting Oracle databases, operating system knowledge of Windows, Linux, and AIX, participating in team calls, and documenting work performed are also key responsibilities. Additionally, you will assist the Application Team in monitoring performance, tuning queries, and database objects. You will be involved in database module design, performance tuning of database code (SQL & PLSQL), report design and tuning, code deployments, schema refreshes, and post-production support. Data modeling, maintaining standards and procedures, ensuring security, backup and recovery policies, and capacity planning for databases and servers will also fall under your purview. Your desired skill set should include proficiency in English with good communication skills for coordination with internal and external teams. You should be willing to work as part of a team and provide 24x7 support when required, including non-standard working-time models. This may involve some off-hours/weekend work at times to ensure smooth operations.,
As a Database Administrator at our company in Chandigarh, you will be responsible for the following: Role Overview: You will be handling Oracle Database Administration tasks for versions 11g and 12c. This includes managing Oracle RAC and Data Guard database administration. Your role will involve creating and maintaining databases for various purposes such as development, testing, production, and training. Additionally, you will be responsible for database installations, upgrades, and regular patching. You will also interface with Oracle Corporation for technical support and monitor database alerts regularly. Key Responsibilities: - Drive performance analysis and tuning for the database - Manage complex Oracle environments across multiple instances and servers - Implement backup and recovery using RMAN - Monitor table and index growth and take proactive measures for storage allocation - Enforce and maintain database constraints for data integrity - Perform database re-organizations to optimize performance - Provide feedback to Development team for serviceability improvements - Troubleshoot and resolve complex Oracle issues - Have operating system knowledge of Windows, Linux, and AIX - Complete time sheets, participate in team calls, and document work performed - Interview new candidates for the team Additional Details: You will also assist the Application Team in various tasks such as monitoring performance, tuning queries, assisting in database module design, performance tuning of database code, report design and tuning, code deployments, schema refreshes, post-production support, and data modeling. You will be required to develop and maintain standards and procedures related to database monitoring, PLSQL/Database development, data modeling, security, backup and recovery policies, high availability, replication design, and capacity planning. Moreover, you will participate in deployment and support activities, including preparing rollback scripts, deploying DB changes in the production environment, and monitoring databases for any impacts due to release changes. Qualifications Required: - B.Tech, BE, or MCA degree - Minimum of 3 years of experience in database administration - Proficiency in Oracle, RMAN, RAC, SQL, PLSQL, and other database-related skills - Strong communication skills in English for coordination with internal and external teams - Willingness to work as part of a team and provide 24x7 support when required - Ability to work non-standard hours including weekends if needed If you possess the required qualifications and skills and are ready to take on the responsibilities of a Database Administrator in our IT-Software / Software Services company, we look forward to receiving your application.,