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.