Location
Secunderabad | India
Job description
Key Responsibilities
- SQL Server
- Manage SQL Server databases
- Configure and maintain database servers and processes
- Monitor system's health and performance
- Ensure high levels of performance, availability, sustainability and security
- Analyze, solve, and correct issues in real time
- Experience in Creating and scheduling the jobs and troubleshooting the failed jobs.
- Refine and automate regular processes, track issues, and document changes
- Perform Server level tuning, performance monitoring, Index Tuning, Query Tuning.
- Perform scheduled maintenance and support release deployment activities after hours
- Experience in Performance tuning activities like verifying the slow running queries and identifying missing indexes and also usage of statistics.
- Experience in User Management activities like adding the user and managing the permissions.
- Configuring, monitoring and troubleshooting the REPLICATION issues and DR activities.
- Provide 24x7 support for critical production systems
- Alert Configuration
- Configure custom alerting for SQL
- SQL Server Integration Services
- knowledge on creation of SSIS packages and deploying in MSDB or File System.
- SQL Server Reporting Services
- Installing and configuring the SSRS and working with Security in SSRS.
- PowerShell
- Scripting and automation
- Server
- Record SQL data & log files sizes, report unusual growth
- Monitor disk usage and free space
- Monitor CPU & memory usage
Key characteristics - Hands on
- Available after hours as needed
- Attention to detail
- Problem solving
- Organization
- Able to work in a Team environment
- Good communication skills
Working Conditions - Hyderabad only
- Some travel to various field offices may be required
- Minimum internet speed of 6 mbps download and 3 mbps upload; no satellite
Compensation - Competitive Salary / Benefits / PTO
Physical Requirements* - Constantly perform desk-based computer tasks
- Frequent sitting
- Occasionally stand/walk, writing by hand, use of telephone
- Sort/file paperwork, rarely twist/bend/stoop/squat
- Consistent with its obligations under the law, the Patra Corp will provide reasonable accommodation to any employee with a disability who requires accommodation to perform the essential functions of his or her job.
Work Standards - Interpersonal Skills Demonstrates the ability to work well with Patra colleagues and clients and with external organizations
- Promotes Culture of Respect & Safety Demonstrates commitment to personal responsibility and value for safety and respect; communicates concerns; uses and promotes safe respectful behaviors based on training and lessons learned
Subject to and expected to comply with all applicable Patra Corp policies and procedures
Qualifications - Microsoft Certified IT Professional Database Developer, SQL Server Certification
Job tags
Salary
