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
Oracle
PostgreSQL
Amazon Aurora
RDS
PL/SQL
PL/pgSQL
AWS
Database Migration
Schema Conversion
Query Tuning
Indexing
CI/CD
Backup/Recovery
HA/DR
Database Security
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)