| Need Sr Database Lead - Remote (EST) - Long Term Contract at Remote, Remote, USA |
| Email: [email protected] |
| From: Sai Teja, Aspired Solutions [email protected] Reply to: [email protected] Role: Sr Database Lead Location: Remote (Preferred EST Only) Duration: Long Term Contract Client: Virtusa/ Dun & Bradstreet Rate: DOE Must have experience with MS SQL/SSIS Job Description: In depth knowledge of modeling/architectural patterns and governance methodologies in SQL Server. Perform SQL Server database level maintenance, optimization, integrity checks, recovery, and handling failover of databases. Implement and monitor backups of SQL databases using both native functionality, as well commercial packages. Database performance tuning including identifying bottlenecks with suitable workarounds. Optimization of existing database & business logic source code. Implement and perform database encryption algorithms Automate and perform database restores/system refreshes of non-Production environments using Production data. Recommend and implement best practices for Rest API integration framework/model. Understand and translate business requirements into technical specifications and build elegant, efficient, and scalable solutions based on specifications. Experience working with industry standards, regulations and guidelines in database warehousing and other relevant systems. Experienced in databases like SQL Server, Oracle, MongoDB. Experienced in ETL/ELT tools like SSIS, Azure Function, Azure Data Factory. Experienced in Azure Function, Azure Data Factory. Experience working with data security practices and available security software packages. Knowledge of network architecture to develop, implement and maintain highly efficient network systems. Advanced knowledge of Database and Table Partitioning. Advanced knowledge of database design including table structure, data types, index management, and permissions. Knowledge of High Availability (HA) and Disaster Recovery (DR) options for MSSQL Server including Windows Server clustering and transaction database replication. Primary Skills: SQL Server DB Data modelling Database programming (Stored Proc , Functions , triggers , etc) SSIS, Azure Function, Azure Data Factory Exposure in Graph Database. Thanks, [email protected] Saiteja. Keywords: database microsoft |
| [email protected] View all |
| Wed Dec 27 22:15:00 UTC 2023 |