*Hi Partners,* *Hope you are doing great today,*
*Please check the below JD and let me know If you have any consultants on your bench.* *Reach me at swa...@osairtech.com <haris...@osairtech.com>* *Title*: Database Modeler and SQL Developer *Location*: Providence, RI. *Duration*: 12 months. *Responsibilities:* Assess database performance based on AWR reports and suggest improvements Create new database objects Assist application team in modeling database Review SQLs being written by developers Analyze application SQLs and provide guidance on improvement *Required Skills:* Five years' experience in Database Administration including installation, configuration; strong knowledge and experience in writing complicated PL/SQL. Five years' experience in configuring and administrating database including taking back ups and daily routine maintenance tasks. Five years' experience in modeling database objects using Erwin. Five years' experience as a strong SQL developer and Data Modeler, who can assist the application team with the optimization of their queries modeling new database requirements. *Additional requested skills include:* · Should have knowledge of Java · Good communication skills. · 24 X 7 Production database administration, support and monitoring · Oracle installation, creation of database (includes physical and logical design of database) · Capacity planning, capacity monitoring and management for 11g databases. · Installation, Configuration, Upgrade, patching of Oracle RDBMS 10g, 11g versions. · Refresh/Cloning of Database for development, testing environments. · Performance Tuning of the database (Memory Allocation Tuning, I/O Tuning, Tuning Contentions) *Technology platform to support health insurance initiatives under the Affordable Care Act (ACA).* *The day to day tasks will include but are not limited to the following:* · Assess Database performance based on AWR reports and suggest improvements · Create new database objects · Assist application team in modelling database · Review SQLs being written by developers · Analyze application SQLs and provide guidance on improvement *Job Level Specific Duties* • Works on multiple applications. • Provides informal mentoring to less experienced colleagues. • Develops innovative and creative output based on interpretation and analysis. • Participates and may lead critical projects, customer engagements or business processes. • Provides design and documentation at an application or function capability level. • Participates in establishing and maintaining application standards and processes. • Effectively communicates application and technical direction to the business and within the customers IT organization. • Advises on issues of systems integration, compatibility, scalability and multiple platforms. *Minimum Education and Certifications* • Undergraduate degree or equivalent combination of education and work experience. *Skills* • Strong understanding of at least one programming language. • Strong knowledge of coding, testing, and debugging applications. • Strong knowledge of application configuration, maintenance and support. • Applies a broad knowledge of application programming and design to analyze and isolate issues. • Exceptional ability to effectively troubleshoot program errors. • General understanding of how technology decisions relate to business needs. *Physical Requirements/ Working Conditions* • Ability to physically perform general office requirements. • Must be able to perform essential responsibilities with or without reasonable accommodations. • Significant travel including overnight domestic or international trips may be required. *Regards,* *HAREESH REDDY* Technical Recruiter haris...@osairtech.com Osair TechnologiesLLC | Desk: 703-349-2764| Fax 732-289-6076 | 12642, Chapel Road, Suite # 16D , Clifton, VA-20124| [image: linkdin symbol]<http://in.linkedin.com/pub/hareesh-reddy/75/67/968/> <http://in.linkedin.com/in/saikrishna2/> [image: logo] <http://www.osairtech.com/> Experience the Excellence... *P *Please consider the environment before printing this e-mail! -- You received this message because you are subscribed to the Google Groups "oraapps" group. To unsubscribe from this group and stop receiving emails from it, send an email to oraapps+unsubscr...@googlegroups.com. To post to this group, send email to oraapps@googlegroups.com. Visit this group at http://groups.google.com/group/oraapps. For more options, visit https://groups.google.com/d/optout.