Position Summary:
Our client is currently seeking exceptional individuals to join the Data Warehouse team. This is an exciting opportunity to join a highly skilled team and contribute to a critical and highly visible project.
Job Responsibilities
Oracle Database Administration for the Data Warehouse multi-terabyte database Using Oracle RAC
· Tune and Optimize an Oracle Real Application Cluster (RAC) setup on multiple Linux nodes.
· Tune the environment to provide best performance and a stable environment.
· Review the space usage and prepare and implement storage management plan which includes
o Organize or re-organize the table structures in separate tablespaces, for better management of backups, facilitate creating lower (QA, Development) environments, and allow for reduction of backup load by separating relatively static data, staging and temporary data, etc. This will require learning about the business aspects of the data.
o Monitor data growth and changes to the storage requirements and develop a multi-year growth pattern by subject area.
o Prepare/ Plan storage expansion as necessary in advance to allow time for procurement.
· Configure and maintain secure SQLNet Listener ensure high availability of services.
· Develop detailed understanding of the major facts and dimensions of the data warehouse and frequent queries. Review methods of optimizing these queries by
o Developing appropriate support structure – indexes, partitions, materialized views
o Review Batch Queries and suggest methods to optimize them
o Monitor user queries and suggest changes for users
o Work closely with the development team to develop/ maintain code, including for query optimization
o Develop code when necessary in Linux bash, SQL, PL/SQL, perl as necessary.
· Review the resource profiles and ensure that there are appropriate governors in place to prevent any one process causing undue load on the DB, ensuring that end users are appropriately restricted and that batch users can perform the necessary tasks in a reasonable time
· Monitor periodic ETL batch processes and ensure that any issues are resolved
· Manage EMC SAN based Database replication process and scripts
· Manage our Informatica servers and infrastructure
· Manage ancillary servers such as SFTP, wiki, CVS, LDAP etc.
· Manage user creation/ privilege management for development and business users
· Informatica Administrator skills
o Install, configure and implement good deployment practices for our Informatica Setup
o Manage Informatica server routine tasks
o Advise us on where we can leverage Informatica in within the DW
Required Skills:
- Minimum 5 years of Oracle DBA experience with minimum 1 year with Oracle RAC
- Experience with Storage Management
- Experience with Oracle SQL tuning
- Experience working in data warehouse installations and knowledge of managing dimensional data
Preferred skills:
- Experience in Informatica Administration
- Experience in Cognos or other BI tools based reporting
- Experience with Medicaid or Health Insurance
Thanks,
Krishna Reddy,
Business Development Manager,
Email: krishna@inspirixtek.com,
Contact: 636-209-5062,
Inspirix Technologies LLC,
--
You received this message because you are subscribed to the Google
Groups "Tech_Recruiters" group.
To post to this group, send email to tech_recruiters@googlegroups.com
To unsubscribe from this group, send email to
tech_recruiters+unsubscribe@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/tech_recruiters?hl=en
Get Paid To Read Emails. Free To Join Now!
http://www.emailcashpro.com/?r=antonynj
---
You received this message because you are subscribed to the Google Groups "Tech_Recruiters" group.
To unsubscribe from this group and stop receiving emails from it, send an email to tech_recruiters+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
No comments:
Post a Comment