Deloitte Data Migration Engineer - Solution Architect in Mechanicsburg, Pennsylvania
Are you an experienced, passionate pioneer in technology? A system's professional who wants to work in a collaborative environment. As an experienced Database Migration Engineer, you will have the ability to share new ideas and collaborate on projects as a consultant without the extensive demands of travel. Consider an opportunity with our US Delivery Center - we are breaking the mold of a typical Delivery Center.
Our US Delivery Centers have been growing since 2014 with significant, continued growth on the horizon. Interested? Read more about our opportunity below ...
Work you'll do/Responsibilities
Collaborate with stakeholders to understand business requirements, database architecture, and performance expectations.
Develop a comprehensive migration strategy, including data migration, schema conversion, application testing, and performance tuning.
Design the AWS architecture for the target database environment, considering factors such as security, scalability, and high availability.
Plan and execute data migration using tools like AWS Database Migration Service (DMS) or other appropriate methods.
Able to perform RAC to RAC and RAC to Non-RAC migrations and familiar with backup, refresh/clone and recovery strategies
Capable enough to perform the DR setup and troubleshooting the standby/DR issues
Good knowledge on networking capabilities of oracle components
Coordinate with application teams to validate that migrated data and applications function as expected in the AWS environment.
Perform thorough testing to identify and address any post-migration issues or performance bottlenecks.
Analyze database performance in the AWS environment and optimize database configurations, indexes, and queries for optimal performance.
Create detailed documentation of the migration process, including configurations, procedures, and troubleshooting steps.
Provide training and knowledge transfer to internal teams on AWS best practices and database management.
Implement monitoring solutions to proactively identify and address potential issues in the AWS-hosted Oracle databases.
Provide ongoing support to ensure the stability, security, and performance of migrated databases.
Deloitte's Government & Public Services practice-our people, ideas, technology and outcomes-is designed for impact. Our team of over 15,000+ professionals bring fresh perspective to help you anticipate disruption, reimagine the possible, and fulfill your mission promise.
The US Oracle Offering has industry-leading experiences across Oracle products and solutions. We bring value to our clients through understanding the intersection of the business and technology, while bringing our clients industry specific preconfigured solutions to accelerate delivery and return on their investments. We're recognized as thought leaders in industry and as a Global Cloud Elite partner. Our clients affirm our position by sharing their stories of success in partnering with Deloitte and the Oracle practice.
10+ years of proven experience in Oracle database administration and migration.
Familiar with disaster recovery strategies and backup/recovery methods.
Good understanding of AWS services and cloud architecture.
Proficient in SQL, PL/SQL, and database performance tuning.
Familiarity with database migration tools and methodologies.
Excellent problem-solving and communication skills.
Ability to work collaboratively in a team environment.
Strong project management and organizational skills.
Must be legally authorized to work in the United States without the need for employer sponsorship, now or at any time in the future.
Bachelor's degree, preferably in Computer Sciences, Information Technology, Computer Engineering, or related IT discipline; or equivalent experience
Must be in your designated office location 10%-30% of each work week.
Must live within a commutable distance, or relocate, to one of the following center locations: Mechanicsburg, PA; Lake Mary, FL; Gilbert, AZ
Ability to travel 10%, on average, based on business need.
All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability or protected veteran status, or any other legally protected basis, in accordance with applicable law.
- Deloitte Jobs