Data Migration Engineer - Solution Architect

Management Consulting | Enterprise Performance
Same job available in 2 locations

Atlanta, Georgia, United States

Dallas, Texas, United States

Position Summary

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.

The Team

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.  

Job Description

  • 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.
  • Ability to travel 10%, on average, based on business need.
Recruiting tips

From developing a stand out resume to putting your best foot forward in the interview, we want you to feel prepared and confident as you explore opportunities at Deloitte. Check out recruiting tips from Deloitte recruiters.
Benefits

At Deloitte, we know that great people make a great organization. We value our people and offer employees a broad range of benefits. Learn more about what working at Deloitte can mean for you.
Our people and culture

Our diverse, equitable, and inclusive culture empowers our people to be who they are, contribute their unique perspectives, and make a difference individually and collectively. It enables us to leverage different ideas and perspectives, and bring more creativity and innovation to help solve our client most complex challenges. This makes Deloitte one of the most rewarding places to work. Learn more about our inclusive culture.
Our purpose

Deloitte’s purpose is to make an impact that matters for our clients, our people, and in our communities. We are creating trust and confidence in a more equitable society. At Deloitte, purpose is synonymous with how we work every day. It defines who we are. We are focusing our collective efforts to advance sustainability, equity, and trust that come to life through our core commitments. Learn more about Deloitte's purpose, commitments, and impact.
Professional development

From entry-level employees to senior leaders, we believe there’s always room to learn. We offer opportunities to build new skills, take on leadership opportunities and connect and grow through mentorship. From on-the-job learning experiences to formal development programs, our professionals have a variety of opportunities to continue to grow throughout their career.

As used in this posting, "Deloitte" means Deloitte Consulting LLP, a subsidiary of Deloitte LLP. Please see www.deloitte.com/us/about for a detailed description of the legal structure of Deloitte LLP and its subsidiaries.

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.

Requisition code: 155917

SCAM ALERT

Caution against fraudulent job offers!

We have been informed of instances where jobseekers are led to believe of fictitious job opportunities with Deloitte US (“Deloitte”). In one or more such cases, false promises of actual or potential selection, or initiation or completion of the recruitment formalities appear to have been or are being made. Some jobseekers appear to have been asked to pay money to specified bank accounts of individuals or entities as a condition of their selection for a ‘job’ with Deloitte. These individuals or entities are in no way connected with Deloitte and do not represent or otherwise act on behalf of Deloitte.

We would like to clarify that:

  • At Deloitte, ethics and integrity are fundamental and not negotiable.
  • We are against corruption and neither offer bribes nor accept them, nor induce or permit any other party to make or receive bribes on our behalf.
  • We have not authorized any party or person to collect any money from jobseekers in any form whatsoever for promises of getting jobs in Deloitte.
  • We consider candidates on merit and that we provide an equal opportunity to eligible applicants.
  • No one other than designated Deloitte personnel (e.g., a Deloitte recruiter or Deloitte hiring partner) is permitted to extend any job offer from Deloitte.

Anyone who at any time has made or makes any payment to any party in exchange for promises of job or selection for a job with Deloitte or any matter related to this (including those for ‘registration’, ‘verification’ or ‘security deposit’) or otherwise engages with any such person who has made or makes fraudulent promises or offers, does so (or has done so) entirely at their own risk. Deloitte takes no responsibility or liability for any such unauthorized or fraudulent actions or engagements. We encourage jobseekers to exercise caution.