News Technology Services Hiring for Senior Database Administrator at Bengaluru, Karnataka Full Time

Full Job Description
Job Description:
Job Title

Database Administrator – MS-SQL

Reporting to

Database Manager

Department

NewsTech – Infrastructure and Operations

Overview of Role

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 MS-SQL DBA will be primarily experienced in MS-SQL 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.

Knowledge of Azure SQL Database and SQL on Azure server is mandatory.

Knowledge of a second database technology which could be one of MySQL/Aurora, PostgreSQL, Mongo DB or Redshift 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.).

Candidates are expected to work in a rotating 24 x 5 model and also provide on-call support as required by business. Initially you will be expected to work for the Australian Business Unit which translate to 3:30 AM to 12:30 PM IST.

Service Design

To ensure scalability, 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

Provide 24*7 supports for production, development, and test databases.
Responsible for the implementation, configuration, maintenance, and performance of critical SQL Server RDBMS systems, to ensure the availability and consistent performance of our corporate applications.
Be responsible for standard databases administration duties: including, but not limited to, installation, patching and change migration, monitoring, backup and recovery.
Build, upgrade, migrate and maintain databases.
Handles P1 alerts for Application outages and follow escalation steps.
Support Incident and Problem management
Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end.
Support patching and upgrades of Servers, databases and appliances
Support disaster recovery events.
Perform scheduled maintenance and support release deployment activities after hours.
Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members.
Refine and automate regular processes, track issues, and document changes.
Assist developers with complex query tuning and schema refinement.
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.

Technical Skills & Requirements

8 + years’ experience as MS-SQL server DBA.
Core competency on SQL Server 2005, 2008, 2012, 2014 and 2016 in a production environment.
4+ years of implementing and managing multi-node clusters.
Working experience of High Availability (HA), Log shipping, mirroring, replication, clustering and Always on Availability groups. and Disaster Recovery (DR) options for MS SQL Server. Multi-node clustering is required.
Advanced knowledge of MS SQL Server Integration Services (SSIS), SQL Server Always On Availability, SQL Replication, and Microsoft Clustering.
Good knowledge on resolving performance issues.
Good understanding of cloud technologies especially AWS and Azure.
Good understanding of homogeneous and heterogeneous database migration.
Team player and should have good communication skills.
MCTS/MCSA/AWS SAA certifications a plus.
Using PowerShell and SQL to automate Installation and configuration of new SQL Servers.
Qualified to troubleshoot and resolve database integrity, performance issues, blocking and deadlocking, replication, connectivity, and security issues.
Performance tuning & Monitoring.
Backup Solutions.
Troubleshooting system and network performance problems.
Ability to implement automation and reduce manual administrative tasks.
Configure SQL Server advance monitoring tools to minimize false alarms
Making sure the information is protected and backed-up to meet business RPO and RTO and ensuring all the data complies with legal regulations
Improvise process for onboarding and upgrade/migrate existing servers

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 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.
To regularly revue working practices to identify opportunities to work smarter and more effectively
Oversee changes to ensure minimal disruption and compliance with change processes
Provide timely participation in follow in problem focus groups
Involved in updates for operational procedures and associated support documentation.
To at all times follow and encourage ITIL best practice.

Key Competencies

Managing Continuity

Producing Results

Upholds and ensures compliance to departmental policies and procedure
Escalates issues in a timely fashion
Utilises expert resources in an effective way
Response to incident / join bridges
Owns problem resolution, including managing SIP projects through 3rd parties

Ensures very high ownership end to end
Demonstrates resourcefulness and tenacity
Sets high standards for self,and 3rd parties
Current tier 0 recovery plans maintained

Relating to People

Leading Change

Effectively manages and works with a variety of teams, structures and reporting lines
Manages conflict constructively
Develops good relationships with departmental peers and business stakeholders
Encourages and facilitates open communication

Challenges current procedure looking for efficiencies
Identifies areas for improvement providing business case justification
Identifies stakeholders and the issues that impact them
Ensuring change is implemented in a seamless manner with minimal disruption

Skills

Key Performance Measures

Educated to degree level, or equivalent work experience with vendor management experience
Very high ownership
Detail orientated
Demonstrates commitment to quality
Agile in a fast moving environment
Strong communication skills
Incident management
Problem management
ITIL qualified

Service levels and Customer satisfaction levels
Effective utilisation of time
Objectives and Goals achieved
Steady progress in resolving outstanding issues
Must be willing to work 24 x 5 rotational shifts.
Must be prepared to work flexible hours to cover the change window

Career Path: Typical Previous Role or Background

Anecdotal Descriptors

10+ years experience of production Database Administration showing a core competency in a specific RDBMS namely MS-SQL.
Energy and Enthusiasm
Passionate about service delivery excellence
Leadership
Positivity and Drive
Desire to “make things work”

Job Category:
Software Product Engineering