• US Citizen

• Green Card

• EAD (OPT/CPT/GC/H4)

• H1B Work Permit

• Corp-Corp

• Consulting/Contract

• UG :- - Not Required

• PG :- - Not Required

• No of position :- ( 1 )

• Post :- 31st Aug 2022

Your future duties and responsibilities
• The SQL Database Administrator is responsible for installing, configuring, upgrading and otherwise administering / maintaining the client’s healthcare database environments, including providing high security of protected health information, monitoring and investigating issues with production applications, evaluating and identifying operational issues within the databases.
• The SQL DBA will be responsible for working on tickets and monitoring of the database environment and completing user requests for access, change requests, scripts and responding to performance issues.
• The SQL DBA will review database level code and ensure adherence to DBA standards and best practices.
• The SQL DBA will be occasionally be responsible for participating in the support schedule.
• The SQL DBA will be responsible for mentoring junior DBAs and taking a lead role in major projects and working on major issues and working with management to set standards for the team.
• Other duties will be determined as necessary.


Required qualifications to be successful in this role
Technical
• 5+ years of experience with Microsoft SQL Server 2008 – 2017
• 2+ years of experience with Azure Database Platforms: SQL Managed Instance, SQL VM, SQL DB, SQL Data Warehouse/Synapse, Data Factory, Databricks
• Elastic pools for scale and performance on Azure
• Capacity Planning/Storage
• Extensive understanding of DBA concepts and Best Practices
• TSQL (scripting, stored procedures, triggers, query development)
• Clustering/Always On technology, Log Shipping, Replication, HA
• Database and SQL Performance Analysis (Index Management and Query Plan Assessment)
• SQL installation and configuration
• Troubleshooting and RCA experience, Incident Management
• Able to recommend, set and apply Standards and Best Practices
• ITIL: Change Management Process and Procedures
• SQL monitoring tools (Idera, Spotlight, SCOM, Zabbix, SQL Sentry, Foglight, Azure SQL Analytics)
• Experience with ETL, SSIS, SSRS, SSAS, OLAP, OLTP
• Security and User Management, including Azure AD Integration and Identities
• Backup/Recovery and Disaster Recovery Procedures
• Standardized Database Maintenance
• Requests including (Installs, Performance Analysis, Security Management, SQL Job Management, Index Maintenance, Troubleshooting) – SNOW/Cherwell
• Data Replication/Streaming (Qlik, SQL Server Replication, Kafka)