| job tittle: Developer Azure Cloud Database Modeler Experience at Charlotte, North Carolina, USA |
| Email: [email protected] |
| From: Shubham Singh, Tek Inspirations LLC [email protected] Reply to: [email protected] Hello, I'm Shubham from TEK Inspirations We have a requirement for you and the details are as follows Please review the Job specifications below and let me know if interested. Please confirm this email that you received it also send me your DL, Visa , 4 digit SSN, education details and LinkedIn profile as well. job tittle:/Developer location: Charlotte, NC (hybrid Min. 3 days onsite or regular onsite M-F) duration:12 Months The Job Description Azure Cloud Database Modeler Experience As part of this role, the resource needs to be familiar with building Transactional data models (Conceptual, Logical, Physical), writing DDL, and creating Load SQL scripts to populate new models. Resource must have a clear understanding of differences between OLTP databases(relational, document, graph (nice to have) and Datawarehouse solutions(star schema, fact tables, and dimensions). OLTP Database Modeling Skills Primary Key Concepts, Foreign Keys Concepts, Code table, Extended Table, Relational Table Concepts, Constraints, Referential Integrity, normalization concepts Data Warehouse Modeling Skills (nice to have) Fact Table Modeling, Dimension Table Modeling, Type2 Data concepts, Aggregation, Managing History Azure Application Database Administrator Experience As part of this role, the resource needs to understand how to translate Business Requirements, and Application Development Requirements into logical database solutions. Resource should be able to make simple database changes such as add constraints, add new tables, add indexes, create data load scripts, basic sql performance management. Advanced skills in writing complex SQL. Resource should be familiar with Snowflake Integration. Resource will oversee and manage database related releases. Azure System Database Administrator Experience As part of this role, this resource needs to understand the systems level concepts related to managing databases and Azure data related Services. System Database Administrator skills Database optimization, database performance, capacity management, improving system health by optimizing data resources. Review and remediate security issues identified through NIST assessments, managing database permissions, key vault secret rotation management, Backup/recovery solutions and Archive solutions. CQRS architectural patterns and how to implement them. Maintain AzDo Repository of SQL and Azure Data Factory assets for release through CI/CD pipelines Azure Data Resource Solutions Azure Active Directory, Azure Resource Configurations, Azure Key Vault, Azure Data Factory, Azure SQL Databases solutions, Azure Cosmos Database solutions, and Azure Storage. Team with DevOps Engineers to maintain AzDo Repository of Infrastructure as Code (Bicep) code for maintaining Azure Data Resources for release through CI/CD pipelines. Azure Data Engineer Experience As part of this role, this resource needs to understand basic ETL concepts and how to apply them within an Azure platform. Must be familiar with basic Data Flow concepts of Data Landing, Data Cleansing, Data Standardization, Data Quality. Hands on experience with Azure Data Factory, and how to transform data using Azure Databricks or Azure SQL stored procedures, integrating Azure Key Vault into Azure Data Factory Solutions, and leveraging Scala or Python programming for ETL/ELT. SQL Developer The Data Engineer role spends much of their time analyzing data across our platform. Since our databases are generally created as Azure SQL databases, experience using SQL is required. SQL Developer Skills Experience with SSMS and data modeling tools Ability to write complex SQL queries, DDL, and DML, and stored procedures. Regards!! Shubham Singh Technical Recruiter| IT Healthcare & Informatics || Email: [email protected] Keywords: continuous integration continuous deployment information technology North Carolina |
| [email protected] View all |
| Mon Feb 06 22:57:00 UTC 2023 |