Powershell Developer

Info-Ways; Stamford (CT); On-site; USD 83,000 - 124,000; Full time

Job summary

A technology solutions provider is looking for a Powershell Developer in Stamford, CT for a 6+ month contract. The role involves developing scripts to manage email data in Office 365, implementing logging for troubleshooting, and ensuring timely execution via Windows Task Scheduler. Ideal candidates will have robust PowerShell scripting knowledge and familiarity with Oracle databases. Strong problem-solving skills and communication are essential as script alerts and updates are crucial to this function.

Qualifications

• Strong knowledge in PowerShell scripting and experience in Exchange Managed Web Services.
• Ability to create and manage PowerShell scripts for Office 365 environments.
• Familiarity with Oracle stored procedures is a plus.

Responsibilities

• Develop scripts to connect to Office 365 mailboxes and process email messages.
• Implement logging and email alert systems for script operations.
• Schedule scripts to run via Windows Task Scheduler.
• Implement verbose logging and email alerts for failures or delays.
• Configure the script to run every 5 minutes via Windows Task Scheduler and alert if idle for 15 minutes.

Skills

PowerShell shell scripting

Exchange Managed Web Services

Windows 2012 Server Task Scheduler

Office 365

SQL Plus connection to Oracle database

SQL Plus / Oracle interaction

Tools

SQL Plus

Oracle database tools

Job description

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 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

1. Login to Mailbox ( EWS – Exchange web Services )
2. Go to public Folder
3. Extract the public folder data and all emails
4. Move the collected public folder information into Oracle DB
5. 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 :

Additional Information

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