Project Role :
Application Support Engineer
Project Role Description :
Act as software detectives, provide a dynamic service identifying and solving issues within multiple components of critical business systems.
Must have skills :
Microsoft SQL Server Database Administration
Good to have skills :
5 year(s) of experience is required
Educational Qualification :
Key Reponsibilities :
1 Implemented and maintained database data security create and maintain users and roles, update security checklists and regular Patching, Transparent Data Encryption TDE, SSL encryption 2 Handled Blocking monitoring, Space Monitoring and Index Maintenance 3 Independently perform database administration activities including monitoring, performance tuning, space management, and auditing using SQL profiler, Activity Monitor, DTA, performance monitor 4 Proactive Database Monitoring through DBA jobs which send alarm notifications 5 Provide timely response to system alerts and participate in the on-call schedule Meet the SLA Service Level Agreement
Technical Experience :
1 Experience in working with Azure SQL Database Import and Export Service and data-tier application DAC for migration 2 Expertise in Always-On Availability Groups AAG and HA/DR Troubleshooting in on premise server and Azure Iaas Having hands on experience in DR processes including Log Shipping and Database Mirroring, SQL Server Replication, Backup and Restore 3 Experience in using DMVs, SP PROCS and System Views for instant analysis.
Professional Attributes :