What are the responsibilities and job description for the Database Migration Specialist position at Cyber Sphere LLC?
Job Details
Job Description: Sybase and MySQL to PostgreSQL or Redshift Database Migration Specialist
Technical Skills
Deep expertise in Sybase ASE/IQ, MySQL, PostgreSQL, and Amazon Redshift.
Proficiency with database migration tools such as AWS SCT, pgLoader, Ora2Pg, and AWS DMS.
Strong SQL and scripting skills (e.g., Python, Bash, Perl) for custom data migration and automation tasks.
Knowledge of PostgreSQL-specific features like PL/pgSQL, partitioning, and JSON.
Experience with Redshift performance tuning, including distribution styles, sort keys, and query optimization.
Familiarity with ETL tools and data pipeline orchestration (e.g., AWS Glue, Apache Airflow, Talend).
Experience
5 years of experience in database administration, development, or migration.
Proven experience in migrating databases from Sybase and MySQL to PostgreSQL and/or Redshift.
Hands-on experience with large-scale data migration projects, including both OLTP and OLAP systems.
Soft Skills
Strong problem-solving and analytical skills to troubleshoot migration and performance issues.
Excellent communication and collaboration skills to work with cross-functional teams.
Ability to manage complex projects and meet tight deadlines.
Preferred Qualifications
Certifications such as AWS Certified Solutions Architect or AWS Certified Data Analytics Specialty.
Experience with real-time data replication and CDC (Change Data Capture) tools like Debezium or Kafka.
Knowledge of cloud infrastructure and services, particularly in AWS (e.g., EC2, S3, IAM).
Familiarity with containerized environments (Docker, Kubernetes) for database deployment and testing.
