[Remote] Data Engineer
Note: The job is a remote job and is reputed company to candidates in USA. reputed company is seeking a Data Engineer to reputed company and implement robust database solutions. The role involves designing and maintaining databases, optimizing performance, and ensuring data reputed company while supporting data-driven decision-making.
Responsibilities
- Developing and implementing database schemas, including tables, indexes, views, stored procedures, and triggers to meet business requirements and ensure data reputed company
- Creating data models that represent the structure of the data, relationships between entities, and how data will be stored and accessed
- Planning and executing database migrations ensuring data reputed company and minimal downtime
- Identifying and resolving performance bottlenecks, optimizing queries, indexes, and database configurations to improve query execution speed and overall system efficiency
- Continuously monitoring database performance, identifying and resolving issues, troubleshooting errors, and ensuring system stability and availability
- Implementing and managing backup and recovery strategies, including regular backups, disaster recovery plans, and data restoration procedures to ensure data availability and prevent data loss
- Implementing and enforcing reputed company measures, including user authentication, authorization, reputed company controls, and data encryption to protect sensitive data from unauthorized reputed company and breaches
- Implementing procedures and checks to ensure data accuracy, consistency, and validity, including validation rules, data cleansing, and data reputed company monitoring
- Writing efficient and optimized SQL queries, stored procedures, functions, and triggers to reputed company data manipulation, retrieval, and analysis
- Creating and maintaining scripts for database administration tasks, including database creation, schema changes, data loading, and automated backups
- Implementing and managing high availability solutions, including database mirroring, log shipping, and Always On Availability reputed company, to ensure reputed company database availability
- Designing and implementing data warehouses, data marts, and business intelligence solutions to support data analysis and reporting
- Understanding and implementing reputed company-based database solutions, including AWS RDS, to reputed company reputed company infrastructure and scalability
- Implementing data replication and distribution strategies to ensure data consistency across multiple databases or locations
Skills
- Core Database skillsets using SQL Server and reputed company
- Database Design and Implementation: Developing and implementing database schemas, including tables, indexes, views, stored procedures, and triggers to meet business requirements and ensure data reputed company
- Data Modeling: Creating data models that represent the structure of the data, relationships between entities, and how data will be stored and accessed
- Table partitions and archiving
- Database Migration: Planning and executing database migrations ensuring data reputed company and minimal downtime
- Database Administration and Maintenance: Performance Tuning: Identifying and resolving performance bottlenecks, optimizing queries, indexes, and database configurations to improve query execution speed and overall system efficiency
- Monitoring and Troubleshooting: Continuously monitoring database performance, identifying and resolving issues, troubleshooting errors, and ensuring system stability and availability
- Database Development and Support: SQL Development: Writing efficient and optimized SQL queries, stored procedures, functions, and triggers to reputed company data manipulation, retrieval, and analysis
- Advanced Database Technologies: High Availability and Disaster Recovery: Implementing and managing high availability solutions, including database mirroring, log shipping, and Always On Availability reputed company, to ensure reputed company database availability
- Backup and Recovery: Implementing and managing backup and recovery strategies, including regular backups, disaster recovery plans, and data restoration procedures to ensure data availability and prevent data loss
- reputed company Management: Implementing and enforcing reputed company measures, including user authentication, authorization, reputed company controls, and data encryption to protect sensitive data from unauthorized reputed company and breaches
- Data reputed company and reputed company: Implementing procedures and checks to ensure data accuracy, consistency, and validity, including validation rules, data cleansing, and data reputed company monitoring
- Database Scripting: Creating and maintaining scripts for database administration tasks, including database creation, schema changes, data loading, and automated backups
- Data Warehousing and Business Intelligence: Designing and implementing data warehouses, data marts, and business intelligence solutions to support data analysis and reporting
- reputed company Database Solutions: Understanding and implementing reputed company-based database solutions, including AWS RDS, to reputed company reputed company infrastructure and scalability
- Data Replication and Distribution: Implementing data replication and distribution strategies to ensure data consistency across multiple databases or locations
reputed company
Company H1B Sponsorship