Key skills
CloudMariaDBMS SQL ServerMySQLServiceNowSQLData WarehousingSnowflakeSQL ServerSalesforceRisk Management
About this role
Role Overview
- Serve as the Subject Matter Expert (SME) for data architecture, including design, analysis, evaluation, infrastructure, efficiency, migration, and overarching strategy.
- Strategically plan new designs for database structure integrations, using knowledge of system interfaces to ensure effective integration and optimal performance.
- Analyze methods for transforming existing data into new environment formats and loading it into other database structures.
- Provide recommendations for environment disaster recovery plans and migration tools.
- Manage source-to-target data mapping between different data models.
- Assist in planning, designing, and managing data migration processes between cloud environments.
- Work closely with the project manager and development lead to identify resources and integrate the data migration plan into the project schedule.
- Develop best practices and standards for risk management, scheduling, and data-related requirements gathering.
- Perform migration and testing of transactional data from legacy systems to modernized systems.
- Perform migration of users from source to destination systems and coordinate with customers on post-migration issues.
- Define test cases and quality control mechanisms to ensure data is migrated correctly, at the right time, and in suitable volumes for each project phase.
- Perform post-migration quality assurance, audits, reconciliation, and exception reporting.
- Review existing migration tools and recommend performance improvements for the migration process.
- Identify migration risks and proactively communicate them to the project manager and technical lead.
- Work with management to continually improve team workflows and processes.
Requirements
- Bachelor’s degree required along with 6 years of experience in data migration.
- Hands-on data migration experience using various methods and tools.
- SQL experience creating and maintaining queries, views, and stored procedures in a multi-database environment.
- Experience with relational databases, data analysis, and data conversions.
- Ability to evaluate data integrity, recommend solutions, and develop methods to systematically eliminate data incompatibilities across systems.
- Ability to effectively diagnose, isolate, and expediently resolve complex data infrastructure problems and monitor project development.
- Experience in consulting and active involvement with data-related projects.
- Preferred Qualifications:
- Experience with Microsoft SQL Server, MySQL, and MariaDB.
- Experience with database replication technologies.
- Familiarity with Snowflake or other data warehousing tools.
- Experience with low-code platform data migrations (such as Appian, ServiceNow, and Salesforce) and/or specific Appian-related projects.
Tech Stack
- Cloud
- MariaDB
- MS SQL Server
- MySQL
- ServiceNow
- SQL
Benefits
- Medical Insurance
- Dental Insurance
- Vision Insurance
- Disability and Life Insurance
- Parental Leave
- 401K
- Paid Time Off