Posted:1 day ago|
Platform:
On-site
Full Time
Duties & Responsibilities
Install, configure, and upgrade Oracle databases (11g/12c/19c).
Establish, Implement and manage backup and recovery strategies using RMAN and Data Pump.
Provide Oracle DBA support including patching databases and partitioning tables.
Perform database performance monitoring, tuning, and optimization.
Ensure high availability and disaster recovery using Oracle RAC, Data Guard, and GoldenGate.
Automate routine tasks using PL/SQL, Shell scripting, or Ansible.
Monitor database performance and tune SQL queries for optimal application response times.
Conduct capacity planning and proactively manage database growth.
Manage user access, roles, and security compliance.
Automates common database management tasks.
Participate in troubleshooting, escalation, Oracle Support interaction, and resolution on time for Production Issues.
Creating documentation, maintenance plans, assigning and monitoring threshold values
Eventually transition to a Data Engineer role, supporting Data Warehouse and BI processes (combination of Linux shell scripts, Snowflake SQL, ADF)
Develop and/or enhance Linux and Snowflake SQL scripts supporting Data Warehouse and BI processes based on requirements.
Participate in development and support of ETL pipelines
Meets with onsite team to gather requirements and convert them into well-designed and documented software components based on Data Warehouse technologies.
Maintain documentation related to database configurations, procedures, and policies.
Participate in on-call rotation and provide 24x7 support for critical systems.
Basic Qualifications
Bachelor’s degree in Computer Science, Information Technology, or related field.
5+ years of hands-on experience as an Oracle DBA.
Hands-On Experience managing Oracle 19c databases
Strong expertise in Oracle RAC, ASM, Data Guard, and RMAN.
Proficiency in SQL, PL/SQL, and performance tuning techniques.
Experience with Oracle Enterprise Manager (OEM).
Experience with ASM configuration and administration
Experience with table partitioning and reorg in Oracle
Knowledge of indexes, analyzing query plans for performance tuning
Knowledge of Oracle Enterprise Manager preferred
Familiarity with Linux/Unix environments and shell scripting.
Knowledge of cloud platforms (OCI, AWS, or Azure) is a plus.
2+ years development experience with Unix/Linux Shell scripting
Experience with ETL tools like SSIS and/or ADF will be a plus
Some experience with Power BI will be a plus
Excellent problem-solving skills and self-learning ability.
Effective problem-solving, communication and collaboration abilities.
Preferred Qualifications
Oracle Certified Professional (OCP) certification.
Staples India
Upload Resume
Drag or click to upload
Your data is secure with us, protected by advanced encryption.
Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.
We have sent an OTP to your contact. Please enter it below to verify.
chennai, tamil nadu, india
Salary: Not disclosed
chennai, tamil nadu, india
Salary: Not disclosed