Oracle DBA (Part Time)
Albany, NY
24 Months
Job Description:
The Fraud Activity Comprehensive Tracking System (FACTS) is an electronic drawer, composed of numerous and varying databases and interfaces that permit efficient access to current and historical information on all audit and investigative activities involving Medicaid providers and/or recipients. The application is web based and is accessible in real-time by over 1,200 users across the State in five state agencies (OMIG, DOH, AG (MFCU), OSC & CQC). The FACTS system is comprised of over 30 related modules.
The main modules of FACTS are developed in the .NET platform; the backend database is Oracle 11g. Some of the auxiliary modules such as PADS, Teammate use SQLServer database.
This position is mission critical to support the maintenance and on-going development for the FACTS system for OMIG to carry on its mission.
Daily Tasks will include but not limited to the following:
Oracle (version 11g or higher) and SQLServer (version 2008 or higher) database administration. This includes:
- Performance tuning
- Database optimization
- Monitoring to ensure maximum database availability
- Backup & recovery using RMAN and Data Pump
- Instance maintenance and troubleshooting
- Apply patches and updates
- Install database software and create databases
- Perform database upgrades
Support development activities
- Develop, troubleshoot and performance tune complex queries.
- Work with business analysts and developers to create logical and physical database design.
- Create and maintain database objects.
Develop, maintain, troubleshoot, and execute ETL scripts that populate FACTS databases from external sources.
Attend project meetings and provide management with statuses and updates on projects and assignments.
Make recommendations on new technologies and how the technologies will benefit ITS/OMIG
Required Experience:
Experience using Oracle database administration.
Experience developing and performance tuning complex queries.
Experience using logical and physical database design, optimization and performance tuning
Experience working with data warehouse/data mart, Oracle Warehouse Builder (OWB), development and execution of ETL
Regards,
Satya
Technical Recruiter
Key Business Solutions, Inc|| Office: 916 646 2080 Ext 221 || Fax: 916 646 2081 || Email: satya@keybusinessglobal.com || Website: www.key-soft.com || Yahoo IM/G Talk: satyakeysoft
Notice: This email is not intended to be a solicitation. Please accept our apologies and reply in the subject heading with REMOVE to be removed from our Mailing list. Thank You.
--
Request: Please do not send any messages to this group which are nor related to IT staffing.
You received this message because you are subscribed to the Google
Groups "Technical Recruiters" group.
To post to this group, send email to
technical-recruiters@googlegroups.com
To unsubscribe from this group, send email to
technical-recruiters+unsubscribe@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/technical-recruiters?hl=en?hl=en
---
You received this message because you are subscribed to the Google Groups "Technical Recruiters" group.
To unsubscribe from this group and stop receiving emails from it, send an email to technical-recruiters+unsubscribe@googlegroups.com.
To post to this group, send email to technical-recruiters@googlegroups.com.
Visit this group at https://groups.google.com/group/technical-recruiters.
To view this discussion on the web visit https://groups.google.com/d/msgid/technical-recruiters/CAAd%3DnqdaZP6ptu1%3DG7o3nJ2eEoqcN86VWDY%3D305g1B0h6FHFjw%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.
0 comments:
Post a Comment