• L2 with minimum 5 years’ experience.
• Installation/Upgradation/Migration of SQL Servers.
• Apply any patches or service packs for SQL Server.
• Configure High Availability/Disaster recovery solutions.
• Configure automated alerts to send a mail to team if any issues.
• Work on incidents, change tickets and problem tickets.
• Setup Maintenance plans for Backups, Database integrity check, Rebuild index and Update statistics and make sure to run all the jobs without any issues.
• Troubleshoot locking issues, including deadlocks, blocking, lock timeouts and fix them.
• Join bridge calls to troubleshoot and fix P1(SEV1) and P2 (SEV2) incidents.
• Execute all changes of db. schema and maintain controlled development database environment.
• Work closely with application developers to test, configure, and optimize servers based on application demands
• Handle database object deployment to Integration, QA, UAT, and Production
• Provide day to day support of high OLTP HA of SQL Server databases- Identify root causes of production problems and work with developers to resolve such problems.
• Work on performance tuning like creating missing indexes.
Skills:
• Extensive knowledge of SQL and SQL server tools
• Experience in Database Performance, Development and Maintenance
• In-depth understanding of database security, backup and recovery, and performance monitoring requirements
• Knowledge of PowerShell or Unix shell scripting
• Outstanding writing and verbal communication abilities
• MCSE/MCSA certificates preferred
• Working knowledge of Linux and Windows Server infrastructures
• Extensive knowledge of database technologies (MySQL, PostgreSQL, Oracle, MongoDB) Any 2 DB technologies is preferred.
• Prior experience with cloud services (AWS, Microsoft Azure and GCP)
Neudesic is an Equal Opportunity Employer
Neudesic provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by local laws.
Neudesic is an IBM subsidiary which has been acquired by IBM and will be integrated into the IBM organization. Neudesic will be the hiring entity. By proceeding with this application, you understand that Neudesic will share your personal information with other IBM companies involved in your recruitment process, wherever these are located. More Information on how IBM protects your personal information, including the safeguards in case of cross-border data transfer, are available here: https://www.ibm.com/us-en/privacy?lnk=flg-priv-usen