• MSSQL administration and engineering in the architecture, design, development.• Adhere to industry and corporate standards and best practices.• Database Tuning and Optimization.• Handle app team and developer questions, incidents, requests.• Upgrade, build of database and maintenance tasks, and automation of managerial and repetitive DBA tasks and daily operations using shell script and SSIS.• Pre-installation Tasks, Physical Database Design, Server and Patch Management, DB environment maintenance.• Create, manage and monitor WSFC and AlwaysOn solution.

• Design, build and integrate data from various resources and big data management using ETL, SSIS and PowerBI. • Provide 24×7 database administrative support and manage challenging technical issues by setting customer expectations, devising and implementing action plans. • Identify and correct bottlenecks with a focus on proactive prevention and knowledge transfer. • Write complex procedural scripts by combination of SQL, Powershell and Cmd for data pipeline automation. • Collaborate with developers to optimize problematic and complex queries. • Collaborate with developers to optimize problematic and complex queries. • Capacity planing, High Availability and Disaster Recovery solutions. • Plan and enhance analytical dashboards

• Providing comprehensive database incident support for customers both in-person and remotely. • Rapid database problem resolution followed by root cause analysis and solution presentation to development team. • Installing, upgrading, and maintaining customers’ server databases and related applications to latest service packs and patches.• Performance tuning and optimization, capacity planning. • cleansing and Importing newly-joined customers’ data from various data sources with ETL processes to ease the prepration process. • Implementing and maintaining High Availability (HA) and Disaster Recovery (DR) solutions such as: Mirroring, log shipping and replication.

• Windows server management, network management and server application management. • Provide technical support for both software and hardware issues. • Daily system monitor and instant respond to security and usability issues. • Take daily data backups and verify data consistency. • system and process upgrades as required to enhance functionality and security of systems. • Collaborate with the personnel to support client-based operating systems. • Providing general guidelines for personnel.