Source description
About the role
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.
</divRole: 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
More at Tata Consultancy Services