Database Administrator

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 Job Description : 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. Job Description - 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 ( SQL*Net, jdbc, odbc) Responsibilties - Database Management: - Provide 24*7 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. - 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. - 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. - 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. - 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. - Database Health Checks: - Regularly checks the system,OS,space,db logs and reports to proactively identify and resolve potential issues - Audit and Reporting: - Maintain and review database audit trails to ensure compliance with organizational and regulatory policies. - 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: