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

Execute stored procedures and validate successful completion. Handle database connectivity, authentication, and execution exceptions. Support audit and compliance reporting requirements. Document script architecture, scheduling configurations, logging standards, and operationa l procedures Provide implementation recommendations and best practices. 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. </div

Qualifications

BACHELOR OF COMPUTER SCIENCE