Associate Database Administrator

**Job Title: Associate Database Administrator**
**Education: B.E / B.Tech / BSc / Graduation**
**Experience: 5+Years**
**Location: Mumbai**

**Key Skills: SQL, AWS, Azure, AOAG, DR Technologies**

**Required Skills**:

- 5+ years of SQL DBA or equivalent experience on administrating and managing SQL Server 2008\2008R2\2012\2014\2017\2019
- Managing and Administrating SQL Server 2008\2008R2\2012\2014\2017\2019 production and Non-production Servers.
- Installing & upgrading SQL Server 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 the problems and provide technical solutions.
- Knowledge on creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, Rules, Defaults, user defined data types and functions.
- Proficient at Excel, PowerPoint and Word.
- Microsoft, Azure, AWS certifications would be a plus

**Process management**:

- Ensure adherence to rules, regulations, security and compliance.
- 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.
- Working in 24*7 support model
- 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.
- Creation/handling/monitoring of SQL Jobs.
- Setup and monitoring of DB/Server Maintenance jobs and alerts.
- 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.