Junior Oracle Database Administrator

Basic Information

Country

India

State

Maharashtra

City

Pune

Date Published

20-Aug-2021

Job ID

31132

Travel Amount

None

Description and Requirements

BU Description:
Information Services and Technology (IS&T) provides all the required technology and operational support services to run the business in BMC. IS&T has around 300 plus servers on premises & in cloud to support production, Disaster recovery databases, applications and around 1000 plus servers in Lab environment. IST&T is transformational not only for BMC but also for the customer experience, it gives 360-degree view to the customer about the products they should know, opportunities in the pipeline, and any service issues outstanding with the customer.

Position Description: 
As an Oracle Database Administrator, you’ll primarily responsible for managing and administration of Oracle Databases (DB) on the Unix (Aix), Linux, Windows platform on Premises and in AWS cloud.
Experience in an enterprise OLTP and Data Warehouse environments
Understanding of database structures, theories, principles, and practices. 
Working technical experience with designing, building, installing, configuring, and supporting database 
Should have worked on aleast 1 System (RAC, data guard, GoldenGate, Streams and Replication) 
Hands-on database tuning and troubleshooting experience (partitioning, compression, indexing, statistics, and query optimizer) 
Knowledge of workload automation, Scripting, self-service, DevOps technique.
Good understanding of monitoring, archiving and backup & restore.

Primary Roles and Responsibilities:
Create models for new database development and/or changes to existing ones 
Install and configure database components and ensure access, consistency, and integrity 
Monitor all enterprise database environments and respond to resolve issues (such as data, access, performance, etc.) 
Monitor, optimize and allocate physical data storage for all database systems 
Develop, implement, and maintain change control and testing processes for database modifications 
Interface with Development and support application release deployments 
Provide end-user support for database related requests (reports, data, code changes etc.)
Establish appropriate end-user database access controls, best practices, and perform transaction and security audits 
Work closely with LAB team for software installation, configuration, troubleshooting.
Perform DB upgrade, DB refreshes, DB migration.
Provide DB support to Different projects based on requirement.
Continuous improvement of DB services by providing automation, self-service using shell/Python scripting.
Maintain internal documentation systems, runbooks & architectural diagrams.

Experience/ Qualifications:
Educational Qualification-BE/MCA (Any Stream).
Around 2 to 3 years of experience in Database Administration
Should have hands-on experience into Shell scripting.
Ready to work in rotational shifts (no night shift), weekend on-call support
Knowledge on BMC tools like Control-M, Remedy would be an advantage
From core to cloud to edge, BMC delivers the software and services that enable over 10,000 global customers, including 84% of the Forbes Global 100, to thrive in their ongoing evolution to an Autonomous Digital Enterprise.
It is the policy of BMC Software to afford equal opportunity for employment to all individuals regardless of race, color, creed, sex, age, sexual orientation, national origin, disability, ancestry, citizenship status, political affiliation, religion, gender, transgender, gender identity, gender expression, marital status, status as a parent, disabled veteran or status as a protected veteran, genetic information or other factors prohibited by law, and to prohibit harassment or retaliation based on any of these factors.

If you need a reasonable accommodation for any part of the application and hiring process, visit the accommodation request page.