Hello,
Hope you are doing well,
Please go through the following requirement and let me know on 
Kevin@riderconsultinginc.comif 
you have any available resources

 

 

 

Role : Sr. Oracle Architect that has Oracle Retail experience with the PLCB

Location :Harrisburg, PA

Duration :6 month project

  

 

Job Description :

Attached is an experience matrix for this position and a Right to Represent 
form (RTR).  Please have your consultant complete the experience matrix and 
return it to me.  

 

PLCB Sr DB Arch Oracle Retail:

The Senior Database Architect is responsible for designing, developing, and 
implementing infrastructure to provide highly-complex, reliable, and scalable 
databases to meet the organization’s objectives and requirements. Database 
Architects are familiar with a variety of the database technologies, concepts, 
methodologies, practices, and procedures and rely on experience and judgment 
to plan and accomplish goals. Database Architects are able to perform a variety 
of complicated tasks with minimal or no direct supervision. They assist in 
defining system and application architecture and provide vision, problem 
anticipation, 
and problem solving ability to organization. They consult with the client to 
define needs or issues, conduct research, perform studies and surveys to obtain 
data, and analyze problems to advise on or recommend solutions, utilizing 
knowledge 
of theory, principles, or technology of specific discipline or field of 
specialization.

 

8 plus years of database experience

4 year college degree in computer science or related field with advanced study 
preferred.

•Possesses extensive knowledge of one or more database systems, and is capable 
of hands-on work in all phases of database design and management.

•Designs, develops, and implements infrastructure to provide highly-complex, 
reliable, and scalable database to meet the organization's objectives and 
requirements.

•Analyzes organization's business requirements for database design, and 
implements 
changes to database as required.                                                


•Performs systems analysis on database, and resolves performance, capacity, 
and replication issues as necessary.                                          


•Provides detailed design and specification documentation, including 
flowcharts, 
for all aspects of the database.                                             


•Works with database analysts to develop methodologies, report views, queries, 
and table replications

•Ensures that all the data is in the proper format.                             
                


•Participates in the identification, prioritization, and development of 
technical 
initiatives and strategies.                                               

•Develops and maintains database standards and naming conventions.

 

•Keeps up-to-date on emerging database architectures, technologies, and 
methodologies, 
and attends training classes as necessary.

--------------------------------------------

The Pennsylvania Liquor Control Board owns and operates 620 liquor stores 
across 
the state of Pennsylvania. Last year, the PLCB had liquor sales of 
approximately 
$1.9 billion. 

 

In addition to the above, the candidate will: 

- Support databases and application technology stacks (forms, reports, SOA, 
Java, J2EE, etc..) underlying the agency's Oracle eBusiness (financials) and 
Oracle Merchandizing Operations Management (retail) applications.  This 
currently 
consists of over 35 database and 45 application servers, plus the planned 
additional 
15 application and 15 database servers. 

- Support the databases and application technology stacks underlying the 
agency's 
Oracle point-of-service applications.

- Troubleshoot and resolve support issues related to database, Oracle 
application 
server and the Oracle technology stack 

- Recommend and implement database organization strategies to minimize downtime 
and improve performance 

- Manage and monitor the daily disaster recovery (DR) synchronization 
procedures 
and monitor the state of DR environments (Oracle DataGuard) 

- Apply/migrate changes to development, test and production environments such 
as data changes, vendor-provided patches, technical/functional configuration 
changes, and modified reports, interfaces, customization, extensions and 
workflow 
objects 

- Clone applications and databases between production and test. 

- Support weekly applications re-start and scheduled maintenance 

- Automate weekly applications re-starts and scheduled maintenance 

- Develop operational and management scripts to improve the operations of the 
Oracle applications 

- Monitor databases and Oracle application servers and respond to alerts 

- Participate in capacity planning 

- Support resolution of database and application performance issues 

- Provide recommendations for tuning underperforming applications to increase 
performance (SQL Tuning, Index Tuning and Memory Tuning) 

- Design, develop and manage backup and recovery policies and procedures 

- Manage and monitor disk space 

- Participate in change control meetings 

- Maintain the patch inventory and patch logs 

- Participate in problem resolution arising from functional testing activities. 


 

Some night and weekend work will be required.

 




Oracle Database Administration (10g and 11g)


Required


4


Years


Oracle DataGuard   

Required   

2   

Years

 



Oracle Forms Server Administration   

Required   

2   

Years


Oracle eBusiness Suite   

Required   

4   

Years

 



Oracle Retail (Merchandizing Operations Management) RMS, REIM, ReSA, SIM, RDW   

Required   

2   

Years


Oracle SOA Suite (BPEL)   

Required   

2   

Years



Oracle Retail Central Office, Back Office   

Required   

1   

Years

 

 

 

 


  Thanks.

  KevinPatel

   

  Ph No:- 980-819-0687

  E-mail:- ke...@riderconsultinginc.com    

  G-Talk : kevinpatel.ri...@gmail.com                                           
            


  Web Site :- www.riderconsultinginc.com

 

-- 
You received this message because you are subscribed to the Google Groups 
"Citrix and Sap problems" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to citrix-and-sap-problems+unsubscr...@googlegroups.com.
To post to this group, send email to citrix-and-sap-problems@googlegroups.com.
Visit this group at http://groups.google.com/group/citrix-and-sap-problems.
For more options, visit https://groups.google.com/groups/opt_out.

Reply via email to