Engineer

Job Description

Skill: Powershell Developer

Must Have Technical/Functional Skills

Key Responsibilities

• Design and develop PowerShell scripts to automate execution of SQL Server stored procedures.
• Create and configure Windows Task Scheduler jobs for scheduled and event-driven execution.
• Implement parameter-driven script execution for multiple environments (DEV, QA, PROD).
• Connect securely to SQL Server databases using PowerShell.
• Execute stored procedures and validate successful completion.
• Handle database connectivity, authentication, and execution exceptions.
• Capture execution metrics including runtime, success/failure status, and return codes.
• Design and implement comprehensive logging capabilities beyond native Task Scheduler logging.
• Log execution details, errors, performance metrics, and operational events.
• Generate structured logs suitable for SIEM ingestion
• Create alerting mechanisms for failed executions, timeouts, and abnormal conditions.
• Support audit and compliance reporting requirements.
• Implement retry logic, failure recovery, and exception handling.
• Design notification workflows via email, Teams, ServiceNow, or SIEM integration.
• Ensure automated jobs are resilient and operationally supportable.
• Document script architecture, scheduling configurations, logging standards, and operational procedures.
• Provide implementation recommendations and best practices.
• Work with infrastructure, database, and security teams to ensure successful deployment.

Required Qualifications

• 5+ years of PowerShell scripting and automation experience.
• Strong experience with Windows Server administration and Task Scheduler.
• Experience executing SQL Server stored procedures from PowerShell.

Strong Knowledge Of

• PowerShell 5.x/7.x
• SQL Server
• T-SOL
• Windows Event Logging
• Error handling and structured logging
• Excellent troubleshooting and debugging skills.

Roles & Responsibilities

Key Responsibilities

• Design and develop PowerShell scripts to automate execution of SQL Server stored procedures.
• Create and configure Windows Task Scheduler jobs for scheduled and event-driven execution.
• Implement parameter-driven script execution for multiple environments (DEV, QA, PROD).
• Connect securely to SQL Server databases using PowerShell.
• Execute stored procedures and validate successful completion.
• Handle database connectivity, authentication, and execution exceptions.
• Capture execution metrics including runtime, success/failure status, and return codes.
• Design and implement comprehensive logging capabilities beyond native Task Scheduler logging.
• Log execution details, errors, performance metrics, and operational events.
• Generate structured logs suitable for SIEM ingestion
• Create alerting mechanisms for failed executions, timeouts, and abnormal conditions.
• Support audit and compliance reporting requirements.
• Implement retry logic, failure recovery, and exception handling.
• Design notification workflows via email, Teams, ServiceNow, or SIEM integration.
• Ensure automated jobs are resilient and operationally supportable.
• Document script architecture, scheduling configurations, logging standards, and operationa l procedures
• Provide implementation recommendations and best practices.
• Work with infrastructure, database, and security teams to ensure successful deployment.

Salary Range - $100,000-$120,000 a year

TCS Employee Benefits Summary

• Discretionary Annual Incentive.
• Comprehensive Medical Coverage: Medical & Health, Dental & Vision, Disability Planning & Insurance, Pet Insurance Plans.
• Family Support: Maternal & Parental Leaves.
• Insurance Options: Auto & Home Insurance, Identity Theft Protection.
• Convenience & Professional Growth: Commuter Benefits & Certification & Training Reimbursement.
• Time Off: Vacation, Time Off, Sick Leave & Holidays.
• Legal & Financial Assistance: Legal Assistance, 401K Plan, Performance Bonus, College Fund, Student Loan Refinancing.

Qualifications: BACHELOR OF COMPUTER SCIENCE