Oracle Database Administrators

Two95 International Inc. Sacramento , CA 95841

Posted 1 week ago

Title Oracle Database Administrators

Job Type Contract(3 +years) with extensions

Location Sacramento, California

Rate Best Rate possible

Job description

Required Skills:

  • 4+ years of Oracle database administration experience (including hands-on experience on Oracle database upgrades, and database patching)
  • 2+ years of Hands-on experience with ORACLE (12c) database administration.
  • 3+ years of Hands-on experience in identifying poor performing SQL queries and performance tuning queries.
  • 2+ years of hands-on experience with scripting bash, python,
  • Hands-on experience on RMAN backup and restore. Copy/clone/refresh databases to other environments
  • Hands-on Experience with tools like ERWIN, TOAD, SQL Developer & OEM.
  • Effective communication skills
  • Preferred Skills:

  • Awareness on Chef and Jenkins
  • 1+ years of Terraform experience;
  • 1+ years of AWS cloud experience
  • Experience with SolarWinds
  • Responsibilities:

  • Regular database maintenance activities
  • Troubleshooting production and non-production database issues and working with AWS or Oracle to create and resolve trouble tickets.
  • Having played a Production support role will be an added advantage.
  • Hands-on experience on Fine Grained Audit and Flashback Archive (Total Recall)
  • Responsible for data security including implementation of TDE, data encryption at rest and in transit, and database hardening
  • Responsible for data management (security and audit)
  • Taking lead on calls with clients, vendors etc.
  • Taking lead on critical activities like DR
  • Doing code reviews of PL/SQL and complex queries created by the dev team and providing sign offs.
  • Technical Environment (specify versions):

    Oracle ExaLogic, Oracle Exadata, and AWS

    Note: If interested please send your updated resume tonaveen.remkumar@two95intl.com and include your rate requirement along with your contact details with a suitable time when we can reach you. If you know of anyone in your sphere of contacts, who would be a perfect match for this job then, we would appreciate if you can forward this posting to them with a copy to us.

    We look forward to hearing from you at the earliest!

    icon no score

    See how you match
    to the job

    Find your dream job anywhere
    with the LiveCareer app.
    Mobile App Icon
    Download the
    LiveCareer app and find
    your dream job anywhere
    App Store Icon Google Play Icon
    lc_ad

    Boost your job search productivity with our
    free Chrome Extension!

    lc_apply_tool GET EXTENSION

    Similar Jobs

    Want to see jobs matched to your resume? Upload One Now! Remove
    US EConsulting Database Administrator And Database Migration Specialist Specialist Master CBO AMI

    Deloitte

    Posted 1 week ago

    VIEW JOBS 1/27/2023 12:00:00 AM 2023-04-27T00:00 <p>Position Summary</p><p>Database Administrator and Database Migration Specialist</p><ul><li>Specialist Master</li></ul><p>Help create new life for legacy information technology systems.</p><p>The Deloitte Application Modernization Team - specialists in converting legacy information technology systems to modern languages - is currently seeking a practitioner with hands-on database administration, database migration and modernization experience. This is an exciting opportunity to immerse yourself in one of the hottest areas in the market, moving databases from legacy to modern technologies and into public clouds such as AWS, Azure and GCP.</p><p>Work you'll do</p><p>Responsibilities will include but are not limited to:</p><ul><li>Build</li></ul><ul><li>Design databases, programs, and scripts independently with minimal or no handholding.</li></ul><ul><li>Leadership</li></ul><ul><li>Guide and mentor the junior members of the team.</li></ul><ul><li>Delivery</li></ul><ul><li>Manage and deliver database migration projects for client engagements that identify, design, and implement migration solutions for creative and large businesses. Responsibilities include, among others,</li></ul><ul><li><p>Identification of migration approaches</p></li><li><p>Developing database migration plans for database schema, objects, data, etc.</p></li><li><p>Identifying and creating migration tools and timeline for execution</p></li><li><p>Performing database migration activities e.g., DB2 to PostgreSQL</p></li><li><p>Creating capacity estimates and plans</p></li><li><p>Performance tuning of database and SQL statements to meet business objectives</p></li><li><p>Deployment Activities</p></li></ul><ul><li>Planning and execution for production deployment of the migrated database including deployment activities such as:</li></ul><ul><li><p>Setting up production data server databases as per the architecture diagram i.e., High Availability, Redundancy, Disaster Recovery, etc.</p></li><li><p>Dry runs for data migration of high volume of data within a defined amount of time</p></li><li><p>Data migration from source to target during multiple project phases including System Integration Test, User Acceptance Test, Performance Test, and Production go-live</p></li><li><p>Support post-production database issues during the 60-90 days post go-live and provide client specific training</p></li><li><p>Deliverables</p></li></ul><ul><li>Create and maintain database deliverables such as project schedule, data migration plan, test plan, and database administration guide among others</li></ul><p>The team</p><p>At Deloitte Consulting LLP, Deloitte Application Modernization &amp; Innovation consultants leverage the best of innovative technology, people, and delivery approaches to help our clients dream, explore, build, and optimize their future. The AMI practice delivers end-to-end technology solutions to enable and improve our clients' core business operations. AM&amp;I is composed of three different areas- Service Delivery &amp; Business Design, Application Modernization &amp; Migration and Quality Engineering</p><p>Qualifications</p><p>Required:</p><ul><li><p>Bachelor's degree in Computer Science or similar field or equivalent work experience</p></li><li><p>Minimum of 7 years of relevant work experience</p></li><li><p>Must have demonstrated hands-on experience in at least one of the following technologies:</p></li><li><p>IBM DB2, Oracle, AWS Aurora, PostgreSQL, MySQL or SQL Server</p></li><li><p>Experience in database migration from source database/OS platform to destination database/OS platform.</p></li><li><p>Experience in automation of Database task using DevOps tools such as GitHub.</p></li><li><p>Experience working in a large development environment, both in person and remote, gathering business requirements, assessing, and estimating activities, and assisting developers with SQL performance tuning and other database related activities</p></li></ul><p>Preferred:</p><ul><li><p>Experience working for large consulting firms in client service role</p></li><li><p>Experience working on projects using Agile methodology</p></li><li><p>Cloud platform experience in AWS, Azure or GCP is strongly preferred</p></li></ul><p>Additional Requirements:</p><ul><li><p>Limited Sponsorship: Limited immigration sponsorship may be available</p></li><li><p>Must be willing to travel up to 50%</p></li></ul><p>AppMod2020</p><p>Recruiting tips</p><p>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.</p><p>Benefits</p><p>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.</p><p>Our people and culture</p><p>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.</p><p>Professional development</p><p>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.</p><p>As used in this posting, &quot;Deloitte&quot; 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.</p><p>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.</p><p>Deloitte will consider for employment all qualified applicants, including those with criminal histories, in a manner consistent with the requirements of applicable state and local laws. See notices of various ban-the-box laws where available.</p><p>Requisition code: 135415</p><br> Deloitte Sacramento CA

    Oracle Database Administrators

    Two95 International Inc.