Padmi

Engineer

United StatesPosted 1 month ago
Software engineeringUnspecified
Apply at Tata Consultancy Services

Opens the source posting on ibegin.tcsapps.com

Source description

About the role

View original

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.

</div

Role: Engineer

Desired skills: SQL Server | Powershell

Qualifications: BACHELOR OF COMPUTER SCIENCE

  • Experience: 6 - 8 Years

  • Job function: TECHNOLOGY

  • Location: Cleveland, OH

Salary range: $100,000–$120,000

Apply by: 2026-09-06 00:00:00

One address, no account. We’ll tell you when matching roles go live.

More at Tata Consultancy Services

Related open roles

View all roles