Find Jobs
Hire Freelancers

Oracle table(range) partition with sub-partition strategy ..

₹600-1500 INR

已关闭
已发布超过 5 年前

₹600-1500 INR

货到付款
===> Should have expert knowledge in Oracle table partitioning and performance tuning NOTE: Confidential -------------------------------- For purging sub-partitions, we shall have purge profiles. We have around 2000 bank's... should be distributed among the purge profiles... purge profile 30 days... 60 days... 90 days... we shall have column retprofile as sub-partition & continue with partition key as "createdate". We need to evaluate the queries response time and query execution plan for the new table The query which includes only the partition key Query with partition + sub-partition key Query without partition + sub-partition key Query with joining other tables. ( application queries) Decide on partition strategy based on the query performance stats a. Non-partition table b. Partition table c. Partition & sub-partition &&&&&& AND ... Should have expert practical knowledge Oracle performance tuning ( AWR, ADDM, ASH reports), long-running query tuning NOTE: Good to have knowledge in - ant builds , WBI , Jetty , WAS.
项目 ID: 17829783

关于此项目

9提案
远程项目
活跃5 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
9 freelancers are bidding on average ₹1,250 INR for this job
用户头像
Oracle RDBMS and EBS Certified professional with over 11 years’ experience in a wide range of environments and have used Oracle versions 9.0 through to 12c on different operating systems. Troubleshooting, tuning, backup, recovery and upgrading of Oracle databases, Installation and cloning. Database administration tools used include Oracle Enterprise Manager and TOAD. Currently serving at Interactive Group of Companies, Pakistan • Oracle 10g, 11gR1 & R2 RAC implementation and administration • Data development support and Administration using oracle 9i, 10g ,11g and 12c • Backup/Recovery, performance tuning of mission critical 24/7 databases • Performance Testing & Tuning of Existing and ongoing DBMS systems • Administrating Software Development and change management Tasks • Implementation and management of Oracle 12c Cloud Control • Implementation configuration and administration of oracle EBZ R12 • Database and Oracle EBZ Patching • Working knowledge of Red Hat Linux, Oracle Enterprise Linux, Solaris and AIX • Well versed with: - RMAN,Data Guard, Oracle RAC, Database restoration and cloning, Cloud Control, ASM - Performance Tuning, Oracle EBZR12,Database administration,OEM,OAM • An effective communicator with excellent relationship building & interpersonal skills, analytical, problem solving & organizational abilities. • Thrives in fast-paced environment, readily adapting to evolving business and technology challenges
₹1,500 INR 在1天之内
5.0 (1条评论)
1.0
1.0
用户头像
As i have gone through your initial requirements and have understood that you need an excellent developer for design and development of your website application and i am confident to deliver you the best desired result. i have 9 years of expirience in the mentioned technologies in your job description. waiting for your kind reply
₹1,300 INR 在1天之内
0.0 (0条评论)
0.0
0.0
用户头像
Hi, I can help you - I will do it for you cheaper as the freelancer allows , but I will need a review. Thanks, Rogerio
₹600 INR 在1天之内
0.0 (0条评论)
0.0
0.0
用户头像
• Around 9.5 years of Strong development experience with Oracle PL/SQL, UNIX shell scripting and 3 Years in Informatics power center. I will be able to provide
₹600 INR 在1天之内
0.0 (0条评论)
0.0
0.0
用户头像
I have 20 plus experience in Oracle.
₹1,500 INR 在3天之内
0.0 (0条评论)
0.0
0.0
用户头像
Having 10+ years of DBA experience and through knowledge about partitioning and Performance Tuning Approach .
₹1,300 INR 在3天之内
0.0 (0条评论)
0.0
0.0

关于客户

INDIA的国旗
Hyd, India
0.0
0
会员自4月 29, 2018起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。