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 new 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
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, Kraków, Noida, Gurgaon, Mumbai, Pune, and Bengaluru.