Job Title: Technical Specialist
Education: BSC Computer Science, BCA\MCA,BE IT\Computer Graduate
Experience: 10+ Years 
Location: Mumbai / Hyderabad / Bangalore

Key Skills: SQL Server DBA, cloud Azure\AWS, T-SQL, SSIS\SSRS, AOAG, DR, Replication, Log shipping, Migrations, upgrade, SQL patching. Good Communication skills,Fluency in English, Understanding of international customer services.

Are you a seasoned SQL Database Administrator? Does working in a multi customer, multi domain environment on global scale motivates you? If yes, this role could be a good fit for you. 
Datavail is seeking a highly skilled, self-motivated, and passionate SQL DBA to join our SQL Global Practice. As a SQL DBA, you will be working on the latest SQL technologies in the industry. This position is based out of our global delivery centers in Mumbai, Hyderabad, and Bangalore in India.
Datavail is one of the largest data-focused services company in North America and provides both professional and managed services and expertise in Database Management, Application Development and Management, Cloud & Infrastructure Management, Packaged Applications and BI/Analytics.

Why should you work at Datavail?

Learn from a vast pool of global SQL DBAs with over 500 combined years of industry experience. You would be working with multiple customers in a multi domain environments. Work would range from On-Prem DB’s, AWS, Azure.  Your Certifications would be on us. 100 days of working from home (since inception of Datavail). Future Opportunity for permanent deputation on H1B to work in US. Leverage the DV Training program to upscale the technical skills.

Required Skills: 

10+ years of SQL DBA or equivalent experience on administrating and managing SQL Server 2005\2008\2008R2\2012\2014\2017\2019 Managing and Administrating SQL Server 2005\2008\2008R2\2012\2014\2017\2019 production and Non-production Servers.  Installing & upgrading SQL Server 2005\2008\2008R2\2012\2014\2017\2019 and its service packs on Windows Environment. Experience in Database backup and disaster recovery procedures. Experience in Windows Clustering, Replication, Log Shipping, Mirroring and Always On. Knowledge in Reporting Services & Analysis Services.  Performed daily tasks including using tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor, Trace. Well versed in SQL Server technical skills and should be able to drive problems and provide technical solutions to team members. Knowledge on creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, Rules, Defaults, user defined data types and functions.  T-SQL Programming skills: Experience in query optimization & performance tuning. Used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands Experience in working in warehousing and OLTP environments. Should be able to manage the customer escalations and Hands on and extensive experience in IT industry practices and standards. Proficient at Excel, PowerPoint, and Word. Knowledge of third-party tools such as – LiteSpeed, IBM Tivoli, RedGate, SolarWinds etc. would be an added advantage. Any Microsoft, Azure, AWS certification is a must! 

Process management:

Improvising policies and procedures to ensure they are successful and ensure that the team is compliant. Identify any process gaps and provide solutions. Ensure adherence to rules, regulations, security and compliance.

The successful candidate will possess the following attributes:

Interpersonal skills - ability to build strong relationships with internal team members and to work across the organization to achieve results. Professional communication skills - Ability to work effectively with mid and senior level contacts face to face, electronically and over the phone. Integrity – Words and actions are always consistent, and behavior is always in accordance with highest ethical standards. Customer focus – Responsive, service oriented and attuned to customer needs. Technical acumen – Ability to grasp technical concepts and establish credibility with technical contacts. Process orientation – Ability to recognize process deficiencies and implement improvements.

Role and Responsibilities: 

Database Administration of Microsoft SQL servers within co-lo, IaaS and PaaS Microsoft Azure environment including Azure Managed Instances. Providing support in non-production and production environments. Owning, tracking and resolving database related incidents and requests, fulfilling requests and resolving incidents within SLAs. Reviewing service-related reports related to disk space, backups and alerting on a daily basis to ensure service-related issues are identified and resolved within established SLAs. Responding to database related alerts and escalations and working with Technical Operations team to come up with strategic solutions to recurring problems. Database Server Setup, Patching & Migration. Participate in Disaster Recovery planning, processes, procedures, testing and execution. Managing access control of SQL Server and databases. Exposure to one or more high availability technologies - Always On Availability Groups, Cluster, Database Mirroring, Replication and Log Shipping. Performance Monitoring of OLTP/OLAP database server and databases in MS SQL Server. Creation/handling/monitoring of SQL Jobs. Deployment of scripts, DB changes, and SSIS/SSAS objects. Setup and monitoring of DB/Server Maintenance jobs and alerts.  Demonstrate the ability to work on multiple BAU operational activities and projects simultaneously, prioritize as required and work to a very high standard. Liaise with other IT Operations team members and suppliers to ensure support and operational activities can be carried out and handed over across geographically dispersed staff. Ensure IT operational documentation, build documents, processes and procedures are completed and maintained to a high standard. Ensure IT standards, audit and compliance requirements and controls are understood and adhered to. In addition to the above key responsibilities, you may be required to undertake other duties from time to time as the Company may reasonably require. Performing RCA on Improvement Plans. Due to the geographically dispersed nature of the company and IT teams it may require a degree of out of hours working including attending team meetings and interactive with other IT Operations team members.