*Dear Candidate,*
*We have an urgent opening for SQL DBA and I have sent you a job description ,Please go through it and let me know if you are comfortable with it and also send me your consultant's updated resume ASAP. * *Title:- SQL DBA* *Duration:- 9-12 Months* *Location:- Chicago, IL* *Phone then Face to Face only* *Below is the job description. It’s a 9-12 month contract role. Let me know if you have any consultants available! * *Tasks to be Performed* *• Build s DB structure (e.g. Design schemas. Build tables, FKs, PKs on local DBs created by system DBA) that meets the business/application needs. • Provide PDW DB consultant service to data layer developers who are responsible for merging data from multiple sources into a data warehouse. Design and implement physical warehouse, but cleans, standardizes, and scrubs data before loading. • Build queries, stored procedures, etc. that meet business/application needs. Ensure that the application is fully optimized for the database and vice versa. • Provide Application/Project security requirement to System DBA and maintain Application level database security (create and maintain users and roles, assign privileges). • Application DB tuning and performance monitoring. • Establish Application/project backup and recovery policies and procedures, and work with system DBA to implement it. Develop archive/purge procedure based on business/application requirement. • Develop Database migration and operational functional procedure. • Setup and maintain Application DB documentation and standards. • Plan DB growth and changes (capacity planning) to fulfill Business requirement. • Work as part of an Application team and provide 7×24 supports when required. • Do Application technical trouble shooting and give consultation to development teams.* *Skillset Details* *- 8+ years of SQL DBA experience - Working knowledge of M/S PDW (APS)* *Rohit Bhasin |* Module lead Recruiter | Apetan Consulting LLC Tel: 201-620-9700* |121| Fax:2015266869 | 72 Van Reipen Avenue # 255 Jersey City, NJ 07306 ro...@apetan.com| www.apetan.com *“Forget all the reasons why it won’t work and believe the one reason it will work**"* <http://www.facebook.com/Apetanconsulting> <http://www.linkedin.com/company/apetan-consulting-llc?trk=top_nav_home> <http://twitter.com/ApetanLLC> *Disclaimer:* We respect your Online Privacy. This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. If you are not interested in receiving our e-mails then please reply with a "REMOVE" in the subject line at rem...@apetan.com and mention all the e-mail addresses to be removed with any e-mail addresses, which might be diverting the e mails to you. We are sorry for the inconvenience. -- You received this message because you are subscribed to the Google Groups "OracleD2K" group. To unsubscribe from this group and stop receiving emails from it, send an email to oracled2k+unsubscr...@googlegroups.com. To post to this group, send email to oracled2k@googlegroups.com. Visit this group at https://groups.google.com/group/oracled2k. For more options, visit https://groups.google.com/d/optout.