Powershell Developer

IT

Role: Powershell Developer
Location: Stamford, CT
Duration: 6+ Months
BGV will be done for the selected candidates.
Skillset :
· Strong knowledge in PowerShell shell scripting
· Knowledge on Exchange Managed Web Services to create Powershell scripts
· Knowledge on Knowledge on Windows 2012 Server Task Scheduler to create Powershell scripts
· Knowledge on Office 365 to create Powershell scripts
· Knowledge on Exchange Online public folders and mailboxes to create Powershell scripts
· Knowledge on SQL Plus connection to Oracle database to create Powershell scripts
· Process steps
o Login to Mailbox ( EWS – Exchange web Services )
o Go to public Folder
o Extract the public folder data and all emails
o Move the collected public folder information into Oracle DB
o Generate report from Oracle DB using customer application which was developed
Resource candidate requirements
What is expected:
Create from scratch a script to connect to a mailbox hosted in Office 365, enumerate all email messages in a public folder hosted on an on-premise Exchange 2010 server, extract certain fields from each email message stored in the public folder and store those fields in a database, update Oracle tables with the count of emails processed and then move the messages into a subfolder of the public folder.
· The script should have verbose logging so that each step or activity performed is logged for troubleshooting purposes.
· In the event of any issues with the script processing or completion, an email alert should be sent to a defined notification group.
· The script should be configured to run every 5 minutes via the Windows Task Scheduler.
· If the script has not been executed for more than 15 minutes, send an email alert indicating as such.
· The script should be executed running under a service account with a mailbox hosted in Office 365.
· Procedure to update the Oracle database is done via calls to an Oracle stored procedure and does not need to be redeveloped but knowledge of Oracle stored procedures would be nice to have.
Technologies to be used:
· PowerShell shell scripting
· Exchange Managed Web Services
· Windows 2012 Server Task Scheduler
· Office 365
· Exchange Online public folders and mailboxes
· SQL Plus connection to Oracle database
Please respond with your word resume and requested details:
Full Name :
Work Authorization:
Contact Number :
Email ID :
Skype ID:
Current location:
Willing to relocate :
Rate/hr :

All your information will be kept confidential according to EEO guidelines.