Alchemy Techsol - Oracle DBA Expert

Database Administrator

Alchemy Techsol - Oracle DBA Expert

Database Administrator
Posted 2 weeks ago


We are hiring for Oracle DBA for Bangalore location. Key Responsibilities • Database Installation and Configuration : Install, configure, and upgrade Oracle database software and related products to ensure smooth and efficient operations. • Database Maintenance : Monitor and maintain the health, security, and performance of Oracle databases. Perform regular backups, restores, and recovery operations to ensure data integrity and minimize downtime. • Performance Tuning : Identify and analyse performance bottlenecks, tune SQL queries, and optimize database configurations to improve system performance and response times. Use tools and techniques to monitor and diagnose performance issues. • Scripting and Automation : Develop and maintain scripts to automate routine database administration tasks such as monitoring, backup and recovery, database performance tuning, and data validation. Write efficient SQL and PL/SQL scripts to perform data manipulation and analysis. • Database Security Implement and maintain database security measures to protect sensitive data. Ensure compliance with industry best practices and company policies. Monitor and resolve security vulnerabilities and access control issues. • Database Troubleshooting and Problem Resolution: Identify and resolve database-related problems, including errors, data inconsistencies, and performance issues. Collaborate with developers and system administrators to troubleshoot and resolve complex issues. • Database Design and Capacity Planning: Collaborate with application developers and system architects to design and implement effective database solutions. Perform capacity planning to ensure databases can handle current and future data growth. • Documentation and Reporting: Maintain accurate and up-to-date documentation of database configurations, procedures, and troubleshooting guides. Generate regular reports on database performance, capacity, and availability. • Collaboration and Communication: Work closely with cross-functional teams, including developers, system administrators, and network engineers, to ensure seamless integration and optimal performance of database systems. Provide technical guidance and support to team members as needed. • Hands on experience in administering database systems running on Oracle 10g,11g,12C,19c database • Expertise in managing high availability solutions RAC, DataGuard, ASM, Golden Gate, Exadata, Oracle Multitenancy • Expertise in Database maintenance activities and optimise including RMAN backups, Restores etc. • Expertise in Installation, administration and troubleshooting of Oracle 19c/12c/11g/10g/9i for OLTP (multiple instances)/ OLAP environment on Very Large or Highly Transactional Databases • Experience in Performance Tuning using EXPLAIN PLAN, SQLTRACE, TKPROF, STATSPACK, AWR and ADDM. • Expertise in setup, installation, configuration, maintenance and troubleshooting of several Oracle tools and utilities like Oracle Enterprise Manager (OEM -13.3/13.4), Oracle SQL Developer • Expertise in setup/implementation/maintenance of Real-Application-Cluster (RAC) of 2/3 Node RAC on 11g/12c/19c. • Experience of Oracle Golden Gate installation, configuration and troubleshooting Golden Gate Extract and Replicate issues • Expertise in Configuration and Management, troubleshooting of Data Guard 19c/12c/11g • Expertise in Upgradation of databases from lower version (9i/10g/11g) to higher version (12c/19c). • Experience in managing cloud database in AWS RDS / Google RDS / Oracle exacs • Expertise in SQL Tuning, SQL Optimization, Cost based optimization and Hints • Sound understanding of system configuration parameters, using OEM • Hands on experience on public cloud (AWS, GCP) • Understanding of ITIL processes Required Skills And Qualifications • Bachelor's degree in computer science, information technology, or a related field (or equivalent experience). • Strong knowledge of Oracle database architecture, administration, and performance tuning. • Proficient in writing SQL and PL/SQL scripts for data manipulation and analysis. • Experience with database monitoring and diagnostic tools. • Knowledge of backup and recovery procedures and tools. • Understanding of database security principles and best practices. • Familiarity with scripting languages such as Shell, Perl, or Python. • Excellent problem-solving and troubleshooting skills. • Strong attention to detail and ability to work in a fast-paced environment. • Effective communication and collaboration skills.


Company Name: Alchemy Techsol

Job details

827login's profile

827login Registered for 1+ year Last online 11 months ago

Contact 827login (seller)

    You must log in or register a new account in order to contact the advertiser.
    To protect against prohibited activities, we may check your message before it is forwarded to the recipient and, if necessary, block it.

    Other items from this seller

    Seller details Details

    505 active listings
    Professional seller
    Registered for 1+ year
    Last online 11 months ago
    Contact All items

    Listing location

    Bengaluru, Karnataka, India
    12.98815675, 77.622600038

    Stay safe!

    Never pay down a deposit in a bank account until you have met the seller, seen signed a purchase agreement. No serious private advertisers ask for a down payment before you meet. Receiving an email with an in-scanned ID does not mean that you have identified the sender. You do this on the spot, when you sign a purchase agreement.
    Alchemy Techsol - Oracle DBA Expert by 827login