Associate Database Administrator will require to have a entry level experience in  MS SQL Server, MongoDB, and monitoring tools like SolarWinds DPA with basic experience with T-SQL skills and a demonstrated ability to optimize database performance with infra hosted both on prem and on Cloud. In this role the candidate will be responsible to handle enterprise and client facing Database environment in a 24x7 setup who is technically very strong and understands and articulates both verbal and oral communications. As a Associate DBA candidate will take seek help and support from the team to drive project outcomes and be accountable for success of the team and professional growth .   Essential Duties & Responsibilities ·         Manage and administer MS SQL Server, in a high-availability environment ·         Monitor and perform routine database maintenance tasks, including backups, restores, and disaster recovery planning. ·         Works on user access management requests adhering to internal access management policies. ·         Understand various Enterprise services under DB support and possess strong T-SQL skills to write and optimize complex queries for enhanced database performance. ·         Participate with teams to identify and address performance bottlenecks in the application. ·         Collaborate with application architects and development teams to ensure database architecture aligns with business objectives. ·         Work on change management requirements. ·         Ability to resolve L1 level DBA issue and escalate appropriately for quick resolution ·         Implement best practices for indexing, partitioning, and query optimization. ·         Knowledge of Windows Active Directory and Microsoft Windows Server. ·         Rely on SolarWinds Database Performance Analyzer (DPA) for comprehensive database monitoring ·         Proactively respond to alerts and troubleshoot issues to ensure optimal database performance. ·         Develop and maintain automation scripts for routine database tasks to streamline operations. ·         Maintain comprehensive documentation of database configurations, processes, and procedures.