Job Description

Equal Opportunity Employer



All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, national origin, protected veteran status, or disability status. EEO/Disabled/Vets



:



Overview


The successful candidate will be a production database-administration competency in our News


Technology Services / New Tech Infrastructure team and will take ownership of supporting the



Dow Jones/News UK / News Corp Australia/ Realtor corporate databases including



performance, reliability and security of data in a core database competency.


The Oracle Database Administrator will be primarily experienced in Oracle RDBMS with


knowledge of Cloud technologies. Additionally, they'll be involved in administration of



databases and their eco-systems; will support release, incident, problem, business continuity



management practices; will patch, upgrade and comply with audit controls; will continuously



improve database service quality to ensure stability and high availability. You are experienced in



implementing; securing, supporting and upgrading enterprise infrastructure, ensuring the



infrastructure, which runs corporate applications, are correctly monitored and highly available



as required.


Candidates should have 4-7 years of experience in a DBA role and are expected to work in a


rotating 24 x 5 model and also provide on-call support as required by business.


Knowledge of a second database technology which could be one of PostgreSQL will be an added


advantage.


Candidates will need to possess working knowledge of Cloud technologies of AWS and Azure


including Compute (EC2, Auto Scaling, Lambda etc), Storage (S3, EFS, EBS etc.), Network (VPC,



ELB's, Route 53 etc).


Additionally, knowledge of MongoDB and No-SQL will be an added advantage.

Preferable candidates will need to possess basic working knowledge of Cloud technologies -


AWS EC2 and RDS.


Candidates are expected to work in a rotating 24 x 5 model and also provide on-call support as


required by business.


Service Design


To ensure availability and security of the database infrastructure.



To manage the governance process for technical policy, standards and guidelines.



To drive best practice designs that promote stability and operational efficiency.


Service Technologies

To work on core database technologies in:

Oracle - Database Concepts and administration.

Basic knowledge of Cloud hosted DB technologies. Oracle on AWS-EC2/RDS.





Minimum of 4 to 7 years of experience working with Oracle, Postgres,Aurora PostgreSQL


and/or other databases.


Should possess knowledge and concept of infrastructure and databases.

Amazon AWS Database & RelatedTechnologies - RDS & EC2 hosted databases.

Should have a reasonable understanding of AWS.

Monitoring - Oracle OEM, SolarWinds, Script Based Tools

HA & replication - Oracle Data Guard, Log Miner &RAC.

Backup Solutions - Oracle RMAN, Datapump, Export/Import

Amazon AWS Database & RelatedTechnologies - Oracle RDS (Desired)

Core competency on Oracle 11g/12c/ 19c / Grid Control Database Administration.

Certification in core competency preferred. (desired, but not required)

Good understanding of AWS RDS and EC2 instances. (desired, but not required)

Good understanding of platform O/S (Linux / Windows)

Good Understanding of database / application interfaces ( SQLNet, jdbc, odbc)



Responsibilties



1. Database Management:


Provide 247 support for production, development, and test databases.


Be responsible for standard database administration duties: including, but not limited


to,installation, patching and change migration, monitoring, backup and recovery.Build, upgrade,



migrate and maintain databases.


Administer, install, configure, and maintain Oracle databases (12c,19c,23c etc.) in both on-


premises and AWS environments.


Installation, configuration and administration of data replication technologies: Data Guard,


Active Data Guard.


Ensure database availability, reliability, and high performance through proactive monitoring,


maintenance, and optimization.


Implement and support Oracle RAC (Real Application Clusters), Data Guard, and other high-


availability solutions.



2. Cloud Database Administrations:


Design, deploy, and manage Oracle databases hosted on AWS services, including Amazon RDS,


EC2, and S3.


Utilize AWS-native tools like CloudWatch, RDS Monitoring, and Newrelic to monitor and


maintain cloud database environments.


Assist with database migrations to the cloud (on-prem to AWS) and ensure smooth operations


in the cloud environment.


Should have experience RDS/Aurora (cloud) database upgrades and patching with minimum


downtime (rolling upgrades/patches).


Should have experience in migrating the databases using DMS,replication etc.


3. Operational Responsibilities


Responsible for maintaining services to agreed Service Levels through effective management


and communication to all parties.


Responsible for alerting the Leadership team, Service managers and Business of any issues that


impact production or result in reduced resilience during a production period.


Is involved in the maintenance and regular testing of tier 0 disaster recovery plans

Ensuring that system failures are contained and resolved with minimum business impact and


that steps are taken to manage failures in IT delivery.


To join the Incident Management team during major incidents.

To ensure timely weekly preparation of brief management reports.

Oversee changes to ensure minimal disruption and compliance with change processes.

Provide timely participation in follow-on problem focus groups.

Involved in updates for operational procedures and associated support documentation.

To at all times follow and encourage ITIL best practice.


4. Backup Recovery & Security Compliance:


Use RMAN backup/recovery and deployment.

Using RMAN, Oracle Data Pump, and proprietary AWS tools, prepare and implement solutions


for database backups and disaster recovery.


Carrying out regular recovery tests and validations is a must to guarantee data integrity.

Ensure proper database security measures are in place, including user management, encryption


etc.


Apply the latest RU/PSU, security patches and updates for both on-prem and AWS-hosted


Oracle environments.


Work with app team for upgrading the major and minor version for Oracle & Postgres.

Maintain and review database audit trails to ensure compliance with organizational and


regulatory policies.


Prepare reports on database security, user access, and system changes.


5. Performance Tuning and Optimization:


Monitor and tune Oracle database performance, including query optimization, indexing, and


SQL performance.


Use tools like Oracle Enterprise Manager (OEM), AWR/ASH reports, and CloudWatch for


database health monitoring.


Perform capacity planning and resource optimization.

Identify performance bottlenecks and implement solutions for continuous improvement.


6. Database Health Checks:


Regularly checks the system,OS,space,db logs and reports to proactively identify and resolve


potential issues



7. Audit and Reporting:


Maintain and review database audit trails to ensure compliance with organizational and


regulatory policies.



8. Script and Automation:


Write and maintain scripts for database automation (e.g., backup scripts, monitoring scripts,


health checks) using Shell, Python, or other scripting languages.


Should have working on Devops tools like Terraform, or CloudFormation,Github, Jenkins to


automate database deployments.


Work with application developers, infrastructure teams, and cloud architects to support


application performance, integrations, and deployments.


Provide timely resolution for database-related incidents, track issues through ticketing systems,


and perform root cause analysis.


Participate in on-call rotation to provide after-hours support for critical database issues.


This job is posted with NTS Technology Services Pvt. Ltd.



Job Category:



News Corp is a global, diversified media and information services company focused on creating and distributing authoritative and engaging content to consumers throughout the world. The company comprises businesses across a range of media, including: news and information services, book publishing, digital real estate services, cable network programming in Australia, and pay-tv distribution in Australia.



Headquartered in New York, the activities of News Corp are conducted primarily in the United States, Australia, and the United Kingdom.