*Greetings!* This is *Rohan* from *Magnus Technology Solutions INC*. *Magnus* is a preferred nationwide staffing vendor to Fortune 500 companies in the US. We have an immediate opportunity with one of our clients. Please find the job description below and if you are interested, please forward your resume to *ro...@magnustechnol.com <roh...@magnustechnol.com>*. You can also *Reach Me :* *775-473-5989 EXT: 949.*
*NOTE: It is mandate to provide VISA copy and Proof of ID during the submission.* *Position : Oracle DBA* *Location : Northern VA (Main), Can also work from Delaware (or) Plano, TX.* *Duration : 6 Months* *Job Type : C2C/W2 - No OPT’s Please for this reQ* *Requirements:* - Design data structures and indexing strategies, most specifically working within Oracle databases. - Write and/or consult on high performance SQL queries and stored procedures. - Manage and administer database environments relative to Capacity, performance, and availability. - Provide advice and coaching to developers/support on database tuning and optimization strategies *SKILLS / EXPERIENCE:* - REQUIRED: 8 years of relevant experience as an Oracle DBA for Oracle 10g/11g and higher. - HIGHLY PREFERRED: Experience in/around Identity Access Management applications. - Ability to actively participate in technical discussions providing valuable input regarding RDBMS environment - Ability to provide accurate and realistic effort estimates, commit and deliver accordingly - Abilitye to work in a fast paced environment with occasional non-business hours (evenings and weekends) flexibility and able to prioritize and juggle multiple projects. - Ability to work productively in a team environment and participate as a positive and cooperative team member. - Ability to perform data movements using export/import tools: DATA PUMP, EXP - Ability to build databases, database cloning, and database refreshes - Ability to backup and restoration using Data Pump and RMAN - Ability to work in AIX UNIX environments and writing Shell scripts - Add automation for database tasks where necessary - Implement and maintain physical database designs for pre-production environments - Configure and manage Oracle databases (RAC/Data Guard) for high availability and data synchronization - Manage the process to define physical database design changes for production environments, get required approvals, and engage production DBA resources to perform the changes - Create and maintain logical and physical data model designs - Create database objects (tables, indexes, etc.) in pre-production - Manage the process to promote database objects to production - Develop database procedures, functions and triggers - Assist developers with database activities - Tune database queries - Monitor application related jobs and data replication activities - Remediate database security compliance violations - Manage application-level security: create database roles, assign privileges on database objects in pre-production. Manage the process to promote database roles and privileges to production. - Monitor and maintain database capacity *TECHNICAL SKILLS:* - Oracle RDBMS 8i thru 11g or higher - Oracle Data Guard, Standby Database, RAC - Unix OS, Shell Scripts, CRON TAB - PL/SQL, SQL Plus, SQL Loader, Oracle Enterprise Manager - SQL Developer, putty, shell script development - Control M - Change Management procedures and best practices - Familiarity with Identity and Access Management is a plus - Microsoft SQL Server DBA experience is a plus - Familiarity with MySQL is a plus *ADDITIONAL INFORMATION:* - If candidate does not have significant Oracle experience, he/she will not be considered. - Prefer candidate to sit in Northern VA, but also open to Plano and Wilmington - Potential to be contract to hire, but no guarantee *Thanks & Regards,* *Have a wonderful day!!* *Rohan Damarla* *Business Development Manager * *Email:** ro...@magnustechnol.com <roh...@magnustechnol.com> |* *Gmail : d.rohan...@gmail.com <d.rohan...@gmail.com> * *Magnus Technology Solutions INC.**| 2600 El Camino Real | Suite 601 | Palo Alto, CA-94306 * *Phone:** 775-473-5989 EXT: 949* *Website: **http://www.magnustechnol.com <http://www.magnustechnol.com/>* -- You received this message because you are subscribed to the Google Groups "Open Source Erp & Crm" group. To unsubscribe from this group and stop receiving emails from it, send an email to open-source-erp-crm+unsubscr...@googlegroups.com. To post to this group, send email to open-source-erp-crm@googlegroups.com. Visit this group at https://groups.google.com/group/open-source-erp-crm. For more options, visit https://groups.google.com/d/optout.