Onboarding Specialist, Migration
BoulevardSalary not specified
Full Time
Mid-level (3 to 4 years)
Not SpecifiedCompensation
Senior (5 to 8 years)Experience Level
Full TimeJob Type
UnknownVisa
Technology, DataIndustries
Requirements
- Bachelor's degree in Computer Science or a related field
- 5+ years of experience as an Oracle/PostgreSQL DBA and database developer
- Proven delivery of 2 or more end-to-end database migration projects
- Strong hands-on skills in PL/SQL, PL/pgSQL, schema conversion, and performance tuning
- Experience with AWS DMS, SCT, RDS, Aurora, and related AWS services
- Experience with AWS database migration tools and services such as AWS DMS and SCT/Ora2Pg
- Strong SQL, scripting (Shell/Python), troubleshooting, and documentation skills
- Excellent problem-solving skills with the ability to identify and resolve complex issues
- Strong communication and collaboration skills
- Ability to work independently with minimal supervision
- Preferred
- Familiarity with automation and configuration management tools, such as Ansible, Chef, or Puppet
- Familiarity with IAAC tools such as Terraform, CloudFormation
- Familiarity with CI/CD implementation tools like Liquibase/Flyway
- AWS Certified Database – Specialty
- AWS Certified Solutions Architect
Responsibilities
- Design and implement database migration plans from licensed databases like Oracle and MSSQL to open-source databases like Aurora PostgreSQL on AWS
- Analyze existing database architectures and define optimal migration strategies
- Convert schemas, stored procedures, functions, packages and database logic (PL/SQL to PL/pgSQL)
- Optimize database performance through indexing, query tuning, and execution plan analysis
- Troubleshoot complex database issues and implement robust backup/recovery and HA/DR solutions
- Develop automation scripts for database operations and monitoring
- Implement CI/CD best practices for database deployments, including automated schema versioning, testing, and rollout processes
- Collaborate with cross-functional teams and document migration processes
- Assess application-level dependencies and ensure compatibility during database migration
- Implement database security best practices, including access control, auditing, and encryption in AWS
Skills
Key technologies and capabilities for this role
Questions & Answers
Common questions about this position
Is this position remote?
Yes, this is a full-time remote position.
What experience level is required for this role?
A minimum of 5+ years of DBA and Developer experience is required, along with a proven track record of successfully delivering 2 or more end-to-end database migration projects.
What are the key technical skills needed for this Senior Database Migration Engineer role?
Key skills include strong expertise in Oracle and PostgreSQL DBA/development, PL/SQL and PL/pgSQL, AWS DMS/SCT/Ora2Pg, schema conversion, performance tuning, SQL, scripting (Shell/Python), and AWS services like RDS and Aurora.
What soft skills are important for this position?
Excellent problem-solving skills, strong communication and collaboration skills, and the ability to work independently with minimal supervision are required.
What makes a candidate stand out for this role?
Candidates with a Bachelor's degree in Computer Science or related field, proven delivery of 2+ database migration projects, and preferred skills like automation tools (Ansible/Chef/Puppet), IaC (Terraform/CloudFormation), CI/CD tools (Liquibase/Flyway), and AWS Certified Database – Specialty will stand out.
Mactores
Technology consulting in AI and IoT
About Mactores
Mactores provides technology consulting and engineering services to help businesses tackle complex challenges. The company specializes in areas such as artificial intelligence, fast data processing, industrial Internet of Things (IoT), and cloud solutions. Mactores works closely with organizations to integrate these technologies into their operations, aiming to enhance their success through effective use of technology. What sets Mactores apart from its competitors is its strong focus on understanding customer needs and industries, ensuring that their solutions deliver real business value. The goal of Mactores is to achieve exceptional results that positively impact businesses, communities, and individuals around the world.
Seattle, WashingtonHeadquarters
2008Year Founded
VENTURE_UNKNOWNCompany Stage
Consulting, Industrial & Manufacturing, AI & Machine LearningIndustries
51-200Employees
Risks
Increased competition from major tech firms like Google and Microsoft.
Potential talent shortages in AI and data science fields.
Economic downturns may reduce client budgets for technology consulting.
Differentiation
Mactores specializes in AI, Fast Data, Industrial IoT, and Cloud technologies.
The company has achieved AWS Generative AI Competency, showcasing its expertise.
Mactores focuses on technology as a strategic driver for business success.
Upsides
Growing demand for AI-driven data analytics boosts Mactores' market potential.
Rising interest in Industrial IoT enhances Mactores' service offerings.
Cloud-native technology adoption supports Mactores' scalability solutions.
Related Jobs
RemoteRemoteSenior PostgreSQL Database Engineer
PerconaSalary not specified
- Full Time
- Senior (5 to 8 years)
RemoteSolutions Architect, Migrations
Snowflake$128,000 - $178,500/year
- Full Time
- Junior (1 to 2 years)
RemoteSenior Systems Engineer (AWS)
Dev Technology GroupSalary not specified
- Full Time
- Senior (5 to 8 years)
RemoteBanner Consultant - Technical
Strata Information GroupSalary not specified
- Full Time
- Senior (5 to 8 years), Expert & Leadership (9+ years)
RemoteSenior Database Administrator & Data Architect
SpreetailSalary not specified
- Full Time
- Senior (5 to 8 years)
RemoteSenior Network Optimization Professional
HumanaSalary not specified
- Full Time
- Senior (5 to 8 years)