Job Summary

SQL - SME : • Minimum 9 to 12 Yrs. relevant experience on SQL Server Database Administration. • Test and Install SQL Server along with the latest hotfix and patches in dedicated and shared environment • Installation and up gradation of SQL Server 2008 R2/20017/2019/2022 on Clustered and Non-clustered environment for production, development, staging servers. • Installation of latest SQL Server Service packs and hot fixes. • Installation of MSRS. • Providing support on database-related issues during testing and troubleshooting of existing applications in live environment to resolve performance, security and other back-end issue. • Migrate database between SQL servers. Migrate database from test / development to production environment • Monitor SQL Server down, SQL Server Agent down, Error log, Application and System logs, Job failures, Backup Failures, Database and Log growth, CPU Utilization, Memory Utilization and Disk Utilization using the in-house built SQL Server monitoring tool. • Change management and incident management through Picasso, BMC Remedy Force and other ticketing tools. Working on Incidents / Work Order / change requests to provide resolution within the set time frame / SLA. • Making sure that the daily activities (backups, jobs etc.) are running and being handled properly. • Take part in SOX testing for financial applications to make sure that the SQL Server hosting the financial data is in compliance with Sarbanes Oxley (SOX) regulation. Remediation of the servers as per the SOX guidelines. • Setting up security on server and database level. • Backing up and restoring databases with SQL Server 2008 R2/20017/2019/2022 and Lite Speed 2005. • Capacity Management it includes memory, processors I/O devices along with Disk space. • Implementing Disaster recovery plans using replication, log shipping, Database Mirroring (in SQL Server 2008 R2/20017/2019/2022) and point in time recovery of databases. • Documentation for installation of MS SQL Server 20017/2019/2022 CUs and hot fixes. • Testing latest released service packs in test environment. • Re-indexing and Index tuning. • Amazon RDS and multi-region EC2. Operational support, change and release management, • Migration from Amazon RDS to Amazon EC2 • Creating and Managing logins/Access levels in Azure IAAS and PAAS environments. • Database restoration activity on azure sql database server and managed instance. • Migration of databases from On premise to Azure Cloud environment.

Key Responsibilities

1. Optimize Business Processes By Implementing And Enhancing Operational Systems Using Mssql And Azure Mysql, Ensuring Improved Management Reporting And Streamlined Information Flow.
2. Analyze Client Requirements And Ensure That The Support Team Consistently Meets And Exceeds Client Expectations Through Effective Management And Resource Allocation.
3. Lead And Mentor The Project Team, Facilitating Transparent Communication Of Project Goals And Fostering A Collaborative Environment For Continuous Improvement.
4. Drive Innovation By Identifying And Proposing New Ideas For Process Development, Leveraging Azure Iaas Solutions To Support Organizational Progress.
5. Provide Tailored Solutions That Align With Customer Needs By Utilizing Expertise In Mssql And Azure Mysql, Resulting In Measurable Business Outcomes.

Skill Requirements

1. Proficient In Mssql Database Architecture And Azure Mysql Dba.
2. Strong Understanding Of Azure Iaas And Its Application In Support Operations.
3. Excellent Problem-Solving Skills And Ability To Implement Process Improvements.
4. Effective Leadership And Team Management Capabilities.
5. Solid Communication Skills For Stakeholder Engagement And Client Relationship Management.

Other Requirements

1. Optional But Valuable Certifications: Microsoft Certified: Azure Database Administrator Associate, Microsoft Certified: Azure Solutions Architect Expert