IT IS_AMS_Database_MS SQL Server

Teamware Solutions is seeking a skilled professional for the IT IS_AMS_Database_MS SQL Server role. This position is crucial for ensuring the stability, performance, and availability of our Microsoft SQL Server databases within an Application Management Services (AMS) environment. You'll work with relevant technologies, ensuring smooth operations, and contributing significantly to business objectives through expert analysis, development, implementation, and troubleshooting within the MS SQL Server database domain in an AMS context .

Roles and Responsibilities :

• Database Administration : Perform routine database administration tasks for Microsoft SQL Server, including installation, configuration, patching, upgrades, and managing database instances.
• Performance Monitoring & Tuning : Continuously monitor SQL Server database performance, identify bottlenecks, and implement optimization strategies such as query tuning, index optimization, and instance-level tuning.
• Backup and Recovery : Design, implement, and manage robust backup, recovery, and disaster recovery solutions for SQL Server databases to ensure data integrity and business continuity.
• High Availability : Implement and maintain high availability and disaster recovery solutions like AlwaysOn Availability Groups, SQL Server Failover Cluster Instances, and replication.
• Database Security : Implement and enforce database security policies, manage user access, roles, and permissions, and ensure compliance with security standards.
• Incident & Problem Management : Respond to database-related incidents, troubleshoot complex issues, perform root cause analysis, and implement permanent fixes in an AMS framework.
• Change Management : Adhere to ITIL-based change management processes for all database modifications and deployments.
• SQL Development Support : Provide support to application development teams for database-related issues, including query optimization, schema changes, and data fixes.
• Automation : Develop and maintain scripts (e.g., PowerShell, T-SQL) for automating routine DBA tasks, database maintenance, and reporting.
• Documentation : Create and maintain comprehensive documentation for database configurations, procedures, and troubleshooting guides.

Preferred Candidate Profile :

Skills Required

Ms Sql, T-sql, Scripting, Clustering, Performance Tuning, Change Management