**Job Title: Associate Database Administrator** **Education: B.E / B.Tech / BSc / Graduation** **Experience: 4+Years** **Key Skills: SQL, AWS, Azure, AOAG, DR Technologies** **Required Skills**: - 4+ 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.