Oracle Database Engineer
Apply now »Date: Nov 28, 2024
Location: Remote, KA, IN
Company: NTT DATA Services
Req ID: 304886
NTT DATA strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now.
We are currently seeking a Oracle Database Engineer to join our team in Remote, Karnātaka (IN-KA), India (IN).
Preferred Experience:
- Ideal candidate has been supporting traditional server based relational databases (Oracle primarily and MySQL secondary) for over 7+ years out of which last 4+ years in public cloud environments (Azure/AWS).
- Solid understanding of cloud computing, networking, and storage principles with focus on either Azure or AWS
- Install, configure, and upgrade Oracle Database software 12c/19c across various environments.
- Optimize database performance through tuning, indexing, and monitoring.
- Design and implement robust backup and recovery strategies for Oracle databases.
- Implement and manage security measures, including user access controls and auditing.
- Apply patches and updates to ensure Oracle databases are up to date and secure.
- Working Experience on high availability solutions, such as Oracle Real Application Clusters (RAC) and Datagaurd.
- Proficient in writing and optimizing SQL and PL/SQL queries for efficient database operations.
- Plan and execute upgrades to newer Oracle Database versions and migrate databases between servers.
- Perform efficient database cloning and refreshing for testing and development purposes.
- Monitor and plan for database capacity to accommodate future growth.
- Diagnose and resolve complex database-related issues and incidents.
- Utilize Oracle Enterprise Manager for comprehensive database management.
- Collaborate effectively with cross-functional teams and communicate database-related updates.
- Maintain accurate and up-to-date documentation for databases and processes.
- Strong planning, deployment, maintenance and troubleshooting experience in high availability
- Expert in setting up health-checks and troubleshooting of Oracle backups, restores and recovery models
- Able to work on On-Call rotations and provide 24*7 shift hours support at L2/L3 level
- Able to work independently in a project scenario and do POCs
- Passion for delivering timely and outstanding customer service
- Ability to work independently, with little or no direct supervision.
- Great written and oral communication skills with internal and external customers
- Strong ITIL foundation, Continual Service Improvement and Total Quality Management experiences
Basic Qualifications:
- 7+ years of overall operational experience on Oracle database
- 4+ years of Azure/AWS experience as a cloud DBA in a 24*7 production support model
- Shell scripts for Monitoring like ‘slow queries’, replication lag, nodes fail, disk usage. etc
- Backup and restores (Backups should be automated with shell scripts/Ops Manager)
- Database Health check (Complete review of Database slow queries, fragmentation, index usage. etc)
- Maintenance (Data Centre outages etc)
- Architecture design as per the Application requirement
- Segregation of duties (User Management – designing User roles and responsibilities)
- Participating in DR (Disaster Recovery)/COB (Continuity of Business) plans as applicable
- Database Profiling, Locks, Memory Usage, No of connections, page fault etc.,
- Export and Import of Data to and From Oracle datapump,
- Monitoring of Various issues related with Database,
- Monitoring at Server, Database and Various Monitoring Tools related to Oracle,
- Database software Installation and Configuration in accordance with Client defined standards.
- Database Migrations and Updates
- Hands on experience in Server Performance tuning and Recommendations
- High availability solutions and recommendations
- Hands on experience in Root cause analysis for business impacting issues.
- Experience with SQL,SQL Developer,TOAD,Pgadmin,mongo db atlas
- Experience with python / powershell scripting - preferred
- Secondary skill in MySQL/postgresql/DB2 – preferred
- Good understanding of PAAS and RDS databases
Preferred Certifications:
- Azure fundamentals certification (AZ-900) – REQUIRED
- Azure Database Certification (DP-300) - desirable
- AWS Certified Database Specialty - preferable
- Oracle OCP
B.Tech/BE/MCA in Information Technology degree or equivalent experience
About NTT DATA
NTT DATA is a $30 billion trusted global innovator of business and technology services. We serve 75% of the Fortune Global 100 and are committed to helping clients innovate, optimize and transform for long term success. As a Global Top Employer, we have diverse experts in more than 50 countries and a robust partner ecosystem of established and start-up companies. Our services include business and technology consulting, data and artificial intelligence, industry solutions, as well as the development, implementation and management of applications, infrastructure and connectivity. We are one of the leading providers of digital and AI infrastructure in the world. NTT DATA is a part of NTT Group, which invests over $3.6 billion each year in R&D to help organizations and society move confidently and sustainably into the digital future. Visit us at us.nttdata.com
NTT DATA endeavors to make https://us.nttdata.com accessible to any and all users. If you would like to contact us regarding the accessibility of our website or need assistance completing the application process, please contact us at https://us.nttdata.com/en/contact-us. This contact information is for accommodation requests only and cannot be used to inquire about the status of applications. NTT DATA is an equal opportunity employer. Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or protected veteran status. For our EEO Policy Statement, please click here. If you'd like more information on your EEO rights under the law, please click here. For Pay Transparency information, please click here.
Job Segment:
Cloud, Database, Oracle, Testing, SQL, Technology