Senior Data Migration Engineer Job Description Duties and Responsibilities Demonstrate extensive knowledge of all aspects AWS Database Engines (RDS, DynamoDB) andor Azure Database Engines (Managed Instances, Data Warehouse) including administration Include DB technology evaluation, guidance and consultation, design support, task automation and scripting, best practice and standards development, capacity planning, optimization and tuning, system upgrades and migrations, performance management, monitoring, security, backup and recovery, issue troubleshooting, and documentation.
Deploy, configure, monitor and maintain databases in the production, development, and quality assurance environments.
Understand AWS based architecture and closely work with DevOps, SecOps develop scripts to deploy and maintain environment.
Work with Operations Development team planning serverserver-less resource requirement to decide proper size for specific application requirements and performance metrics.
Process database change requests, including the creation and modification of databases, tables, views, stored procedures, triggers, jobs, etc.
in accordance with change control policies.
Analyze problems, anticipate future problem areas and implement solutions.
Work outside of normal business hours as required for completing projects, working on deployments and resolving system outages.
Responsible for level 2 systems management and exercises project-level control over initiatives.
Recommend and implement solutions for performance monitoring and tuning.
Help administrating and integrating with Microsoft SQL Server so minimum MSFT SQL DBA skill is required Carries out assignments with minimal coaching and guidance from others.
Develops, enhances and adheres to engineering and administration standards.
Upholds and maintains strong documentation.
To be placed on on-call rotation for a week every 3 months and respond to system alerts Requirements The ideal candidate will have experience with at least one of the Pubic Cloud providers like AWS, Google Cloud Services and Azure experience.
Cloud migration experience also a plus.
Relational Database Management experience in the past is a plus.
Excellent technical expertise in relevant state of the art data technologies, database warehouse data security, data systems, and its design.
Able to formulate and present various solutions for business initiatives and discuss proscons for each option.
Strong AWS experience Strong Cloud Database management experience (RedshiftSnowflakeGreenplum) Data warehouse or Data analytics Deep Knowledge of monitoring tools Kibana, CloudWatch, DataDog, etc Deep Knowledge of automation tools Scripts , ELK, PRTG, Jenkins, Chef, Lamda, Terraform, Cloudfomation, Azure Automation, etc Qualifications Degree in computer scienceinformation systems, engineering or related field preferred or a corresponding number of years' experience in technical operations or software engineering 3 years experience with Linux Server platform 1-3 years of supporting a large data platform and data pipe-lining.
2-3 years of experience solving data engineering problems using technologies such as Spark, Solr.
2-3 or more years of experience with NoSQL data platforms like Spark, Solr, MongoDB, DocumentDB, DynamoDB, Cosmos DB, Experience with Data Warehouse technologies such as AWS Redshift, Snowflake, Azure Data Warehouse, etc are big plus.