Bengaluru
Posted 7 months ago
Experience: 6+ years
Job Location: Bangalore
Job Description
- Familiar with different editions of SQL Server and can advise on when to use each to optimize.
- Strong backup/recovery, including replication/failover tuning and troubleshooting knowledge of SQL Server.
- Experience using Azure SQL and related tools (Hybrid connections, etc.) is a bonus.
- Install, configure, upgrade, patch, and manage Microsoft SQL Server databases.
- Establish and maintain backup and recovery policies and procedures.
- Provide proactive monitoring and performance tuning including physical server level, database level, and query tuning.
- Create users and assign permissions based on the authorized level of access.
- Provide L2-level representation for the DBA team to account leadership, clients, application owners, and infrastructure teams.
- Ensure 24/7 availability of the SQL Server database environment. This will include 24/7 on-call responsibilities on a rotating schedule. Represent SQL Server Database Administration team in Disaster Recovery and project activities.
- Share technical expertise providing technical mentorship and cross-training to other team members.
- Maintain documentation of the database environment and infrastructure.
- Work with system administrators, architects, development teams, and business application owners to ensure database changes are in line with operational standards and the strategies needed to scale.
- Work collaboratively with cross-functional teams to administer as well as troubleshoot live issues both internal as well as customer-reported.
- Investigate and troubleshoot issues.
- Create and execute scripts to perform needed system functions.
- To provide 24×7 Support.
- Database server administration ( MS-SQL) and team management.
- Good communication skills, Need to participate in client meetings.
- Handle regular day-to-day IT Infra operations.
- Installation of MS-SQL, Applications and break fixing of H/W and S/W issues. Working on Service Desk tickets
- Working on Service Desk tickets.
- Coordinating with IT stakeholders to fix the issues.
- Participate in internal/external audits to showcase the IT compliance status.
- Perform the IT-related task and update the status of higher management regularly.
Required Professional and Technical Expertise:
- A minimum of 6+ years of overall experience in IT Database Domain with proven experience in Database Operations.
- Client Meetings, External Audit, Database Installation, Database Environment, Database MS-SQL Server Administration
Preferred Professional and Technical Expertise:
- BE/ BTech/MCA/Diploma.
- Participating in Day/Weekly status review meetings
- Excellent oral and written communication skills
- Experience in Operating Systems tuning and configurations
- Ability to obtain and maintain a Minimum Background Investigation (MBI)
About Outworks Solutions
Outworks Solutions helps tier-one IT organisations improve their workforce. Our expert recruiters aim to bridge the gap between employers and talents. Furthermore, we create result-driven solutions aimed at enriching customer experience. Our headquarters and state-of-the-art development centre are established in Noida, and we have multiple teams operating from Bengaluru, Pune, Dehradun and Nagpur. Outworks Solutions has been a trusted partner to India’s largest service-based IT companies and Global Captive Centres (GCCs). We will meet your expectations.
