Senior Oracle Developer
Bellevue, WA
Skill must have: Oracle 8i, 9i; Oracle 10g; SSMA; GoldenGate Azure DMS
Job Title: Senior Database Developer We need strong, hands-on migration experts who can lead and execute this end-to-end migration, working closely with internal teams to ensure a seamless transition with minimal disruption. Automation, efficiency, and performance optimization are key to meeting our aggressive timelines.
Key Responsibilities:
• Design, develop, and maintain database systems using Oracle and SQL Server.
• Perform database design and development, including the creation of stored procedures, triggers, and views.
• Experience in database administration, architecture, and migrations.
• Strong hands-on experience in OLTP replication design, data warehousing architecture, and database automation.
• Proven experience migrating complex Oracle environments (Oracle 11g/12c/19c) to Azure SQL or MS SQL (on-prem).
• Expertise in Oracle GoldenGate, Azure Data Factory, and SSIS for real-time and batch data replication.
• Strong experience in PL/SQL to T-SQL conversion and performance optimization.
• Hands-on experience with Azure SQL (PaaS) and MS SQL (IaaS & on-prem), including security, backup & recovery, and performance tuning.
• Strong analytical and troubleshooting skills, with the ability to solve complex migration challenges.
• Migrate existing databases from Oracle to SQL Server, ensuring data integrity and optimal performance.
• Implement and manage distributed database techniques to ensure high availability and scalability.
• Troubleshoot and resolve complex technical issues related to databases.
Qualifications: • bachelor’s degree in computer science, Engineering, or a related field.
• 5+ years of experience in database development with Oracle and SQL Server.
• Proven experience in migrating databases from Oracle to SQL Server.
• Expertise in distributed database techniques and high availability solutions. • Proficiency in Unix shell scripting. • Proficiency in SQL, PL/SQL, and T-SQL programming. • Solid understanding of database performance tuning and optimization. • Excellent problem-solving skills and attention to detail. • Strong communication and teamwork skills.
click here