- Bachelor's degree or 4 years of relevant work experience in Computer Science, Engineering, or related discipline
- Microsoft SQL Server Certification
- 5 Years of related experience
- Proficient in SQL development and administration disciplines with current hands-on experience with the latest SQL Server releases including SQL 2019, 2017, 2016
- Strong background and experience with all BC and DR capabilities of Microsoft SQL Server including Always-On, Mirroring, Log Shipping, and Clustering with a practical understanding of other Infrastructure BC/DC capabilities
- Leverage metrics to drive capacity planning and trending to proactively identify potential problems and mitigate before they result in customer impact
- Understand the place of automation and standardization when delivering stable, maintainable, and performant database services at scale
- Perform platform, database, and query optimization
- Must be legally authorized to work in India for any employer without sponsorship
- Must be fluent in English (written and spoken)
- Successful completion of interview required to meet job qualification
- Reliable, punctual attendance is an essential function of the position
- SQL Server Production Support
- Off-hours support for all Tier1 – Tier5 SQL Databases and InstancesCreate physical database structures based on physical design for development, test, and production environments
- Coordinate with systems engineers to configure servers for DBMS product installation and database creation
- Install, configure, and maintain DBMS product software on database and application servers
- Assist in the consultation to application development teams on DBMS product technical issues and techniques
- Implement monitoring procedures to maximize availability and performance of the database, while meeting defined SLA's
- Investigate, troubleshoot, and resolve database problems
- Communicate the required downtime with the application development teams and systems engineers to implement approved changes
- Identify, define and implement database backup / recovery and security strategies
- Install and support of DBMS (Database Management Systems) software and tools
- Perform various database activities which include monitoring, tuning, and troubleshooting, with appropriate supervision, if required
- Review deployment for all SQL database changes
- Complete pre-deployment code reviews with application teams as requested
- Review and provide feedback on all SQL code updates
- Work with deployment manages on dates and time for releases including assignments
- Performance Tunning and code review
- Migrations and DB setup (Cloud-AWS, SQL)
- Patching of all SQL Server and some Couchbase