Lead Database Administrator

News Corp

Bangalore, Karnataka
Permanent
Full-time

1 month ago

Job Description :Job Title: Lead Informix DBAJob Location: Bengaluru, KarnatakaWork Arrangement: Hybrid (3 days per week in office)Shifts: Rotational ShiftsOverview of Role

The successful candidate will be a production database-administration competency in our News Corp India 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 Informix Database Administrator will be primarily experienced in Informix 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.Preferable candidates will need to possess basic working knowledge of Cloud technologies - AWS EC2 and RDS.Knowledge of second database technology like MySQL or PostgreSQL preferred.Candidates are expected to work in a rotating 24 x 5 model and also provide on-call support as required by business.Service DesignTo 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

The core responsibilities include management of the Informix database as well as themaintenance, optimization and database recovery if required.

Informix 12.6 and 12.10 experience.

Experience in troubleshooting, performing upgrades, debugging and tracingUse sessions.

Installation of the Informix server version 12.

Informix TimeSeries Object/Relational data management.Informix Replication using HDR, Disaster Recovery knowledge.Informix Backup and recovery experience.Experience upgrading and patching Informix.Shell scripting (ksh,bash,etc).Informix data compression.Responsible for database backup and restoration of databases.Database related patch loading.Logical log file and dbspace maintenance.Database health check up.Executing the process of Re-indexing, re-organizing, update stats as per schedule.Monitoring database activities and performance.Space Management.Data movement from production to test server.Responsibilities

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.Support patching and upgrades of Servers, databases and appliances.Support disaster recovery events.Support Incident and Problem management.Experienced with Informix failover and switchover concepts..Partitioning and advanced compression skills.Expertise in performance tuning of SQL statements.Provides Informix database administration support for all lines of business applications and infrastructure applications.Provide technical support and coordination for core infrastructure components including server, network, storage, software and middleware.Communicate effectively with DBA team members, developers and management.Operations

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 plansEnsuring 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 incidentsTo ensure timely weekly preparation of brief management reportsOversee changes to ensure minimal disruption and compliance with change processesProvide timely participation in follow in problem focus groupsInvolved in updates for operational procedures and associated support documentation.To at all times follow and encourage ITIL best practice.Key CompetenciesManaging ContinuityProducing Results

Upholds and ensures compliance to departmental policies and procedure

Escalates issues in a timely fashionUtilises expert resources in an effective wayResponse to incident / join bridgesOwns problem resolution, including managing SIP projects through 3rd partiesEnsures very high ownership end to endDemonstrates resourcefulness and tenacitySets high standards for self,and 3rd partiesCurrent tier 0 recovery plans maintainedRelating to PeopleLeading Change

Effectively manages and works with a variety of teams, structures and reporting lines

Manages conflict constructivelyDevelops good relationships with departmental peers and business stakeholdersEncourages and facilitates open communicationChallenges current procedure looking for efficienciesIdentifies areas for improvement providing business case justificationIdentifies stakeholders and the issues that impact themEnsuring change is implemented in a seamless manner with minimal disruptionSkillsKey Performance Measures

Educated to degree level, or equivalent work experience with vendor management experience

Very high ownershipDetail orientedDemonstrates commitment to qualityAgile in a fast moving environmentStrong communication skillsIncident managementProblem managementITIL qualifiedService levels and Customer satisfaction levelsEffective utilization of timeObjectives and Goals achievedSteady progress in resolving outstanding issuesMust be willing to work 24 x 5 rotational shifts.Must be prepared to work flexible hours to cover the change windowCareer Path: Typical Previous Role or BackgroundAnecdotal Descriptors

8+ years experience of production Database Administration showing a core competency in a specific RDBMS namely Informix.

Energy and EnthusiasmPassionate about service delivery excellenceLeadershipPositivity and DriveDesire to “make things work”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.

News Corp

Apply Now