ROLES RESPONSIBILITIES Job Role MSSQL DBA 10 years Position Summary looking for a qualified MSSQL DBA L3 with 10 years experience of working for companies in related fields The candidate is responsible for effective installation configuration operation migration and maintenance of MSSQL databases Responsibilities Create recent Microsoft SQL Server instances and configure them including AlwaysOn availability groups and failover clustering Facilitate brainstorming meetings with clients to review analyse and assess business systems and needs In charge of database backup and recovery methods database access security and integrity physical data storage design and data storage administration Assists in the selection of a database management system and the maintenance of database performance Participate in continuous process improvement Download and install SQL Server service packs and updates Configure and maintain SQL Security controls Make recommendations for system architecture per Microsoft SQL Server best practises Manage database backup and recovery as well as disaster recovery planning in coordination with the IT manager and System Engineer Create change and improve SQL Server Agent tasks and maintenance plans Proactively monitor SQL Server maintenance tasks troubleshoot failed processes and address issues as soon as possible Troubleshoot application sluggishness and poor performance In charge of T-SQL query tuning In charge of database migrations and server updates Create documentation and training for routine database administration activities as well as train server operations employees on them In charge of big data ETL into SQL Server as well as authoring and modifying SQL Server Reporting Services reports Integrate SQL Server with corporate applications T-SQL Transact-SQL Programming Perform any extra responsibilities that are allocated to you Requirements Skills REQUIREMENTS SKILLS Extensive knowledge of SQL and SQL server tools Experience in Database Performance Development and Maintenance In-depth understanding of database security backup and recovery and performance monitoring requirements Familiarity with relational and dimensional data modelling Extensive knowledge in database design implementation and conversion Knowledge of PowerShell and Unix shell scripting Experience with SSAS SSIS and SSRS Outstanding writing and verbal communication abilities Meticulous attention to detail Working knowledge of Linux and Windows Server infrastructures Extensive knowledge of database technologies MySQL MS SQL PostgreSQL Oracle MongoDB Prior experience with cloud services AWS Microsoft Azure GCP EXPERIENCE 8-11 Years SKILLS Primary Skill Database Administrator Sub Skill s Database Administrator Additional Skill s Microsoft SSIS SQL Server DBA ABOUT THE COMPANY Infogain is a human-centered digital platform and software engineering company based out of Silicon Valley We engineer business outcomes for Fortune 500 companies and digital natives in the technology healthcare insurance travel telecom and retail CPG industries using technologies such as cloud microservices automation IoT and artificial intelligence We accelerate experience-led transformation in the delivery of digital platforms Infogain is also a Microsoft NASDAQ MSFT Gold Partner and Azure Expert Managed Services Provider MSP Infogain an Apax Funds portfolio company has offices in California Washington Texas the UK the UAE and Singapore with delivery centers in Seattle Houston Austin Krakow Noida Gurgaon Mumbai Pune and Bengaluru