Company Name: VARITE India Private Limited
About The Client:
Client is an Indian multinational technology company specializing in information technology services and consulting. Headquartered in Mumbai, it is a part of the Tata Group and operates in 150 locations across 46 countries.
About The Job:
- The SQL DBA will provide 24x7 support, including flexible shifts, to ensure the smooth operation of our database systems.
- The role involves handling basic connectivity issues, user account management, monitoring and alerts, backup monitoring, query optimization, service restarts, database space management, status checks, audit support, incident ticket handling, performance troubleshooting, running routine scripts, failover notifications, special requests, vulnerability remediation, database migrations, continuous improvement, and facilitating new deployments.
Essential Job Functions:
- Basic Connectivity Issues:
- Investigate and resolve user connection problems, ensure database services are running.
- User Account Management:
- Create, delete, or modify user accounts and roles, reset passwords, grant/revoke access permissions.
- Monitoring and Alerts Handling:
- Respond to automated monitoring alerts for performance issues, check for high CPU/memory/disk usage, notify L2/L3 if needed.
- Backup Monitoring:
- Ensure scheduled backups complete successfully, notify the L2 team of any failures or inconsistencies.
- Basic Query Optimization:
- Identify slow-running queries, provide basic troubleshooting (e.g., missing indexes).
- Service Restarts:
- Restart database services when non-responsive or encountering failures.
- Database Space Management:
- Monitor database storage and disk space, notify L2/L3 if space thresholds are crossed.
- Database Status Checks:
- Check the health and availability of databases and server resources, monitor error logs for critical issues.
- Supporting SOX & HIPAA Audit Requests:
- Assist with data gathering for SOX and HIPAA audit requests.
- Incident Ticket Handling:
- Triage and escalate complex issues to L2/L3 teams, log issues in the ticketing system.
- Basic Performance Troubleshooting:
- Investigate basic performance complaints (e.g., slow response times) and escalate if needed.
- Running Routine Scripts:
- Execute pre-approved SQL scripts or queries for basic maintenance tasks (e.g., clearing logs).
- Handling Failover Notifications:
- Notify higher-level teams in case of database failovers in HA environments.
- Special Requests:
- Handle special requests like generating reports, running diagnostics, or performing data extracts under L2/L3 guidance.
- Vulnerability Remediation Support:
- Assist with applying security patches and addressing basic vulnerabilities under L2/L3 guidance.
- Supporting Database Migrations:
- Support pre-migration tasks and monitor migration processes, escalating issues to L2/L3 as needed.
- Continuous Improvement & Knowledge Management:
- Continuously enhance processes and tools while updating knowledge base articles to improve efficiency and streamline issue resolution, under L2/L3 guidance.
- Facilitating New Deployments for DBs & Managing Deployment Features:
- Help with new deployments for IaaS/On-Prem DBs and handle deployment features.
Technology Landscape:
- PaaS: Azure SQLDB, Managed Instance, Hyperscale
- IaaS: SQL + On-prem
Qualifications:
Experience range:
- 5 to 8 Yrs Exp and 8 to 12 Yrs
How to Apply: Interested candidates are encouraged to respond/submit their updated resumes, and for additional job opportunities, please visit Jobs In India - VARITE.
Unlock Rewards: Refer Candidates and Earn.
If you're not available or interested in this opportunity, please pass this along to anyone in your network who might be a good fit and interested in our open positions. VARITE offers a Candidate Referral program, where you'll receive a one-time referral bonus based on the following scale if the referred candidate completes a three-month assignment with VARITE.
Experience Level Bonus Referral:0-2 yearsINR 5,0002-6 yearsINR 7,5006+ yearsINR 10,000
About VARITE: VARITE is a global staffing and IT consulting company providing technical consulting and team augmentation services to Fortune 500 Companies in USA, UK, CANADA and INDIA. VARITE is currently a primary and direct vendor to the leading corporations in the verticals of Networking, Cloud Infrastructure, Hardware and Software, Digital Marketing and Media Solutions, Clinical Diagnostics, Utilities, Gaming and Entertainment, and Financial Services.
Equal Opportunity Employer:
VARITE is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. We do not discriminate on the basis of race, color, religion, sex, sexual orientation, gender identity or expression, national origin, age, marital status, veteran status, or disability status.
