Database Administrator – MSSQL

Job Description : 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 a second database technology which could be one of PostgreSQL, MySQL/Aurora, MongoDB 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, and Lambda etc.), Storage (S3, EFS, and 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. 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 support 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 database 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 4 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. 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. 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.