Azure SQL Database Administrator

ecialty in lieu of every year of education
• At least 4 years of Information Technology experience
• At least 3 years of hands-on experience in MS SQL server on Azure/PostgreSQL administration and maintenance
• Able to install and configure the MS SQL Server, configure the SQL clustering, SQL Always On Availability Groups
• Able to do the capacity planning based on the growth pattern of the databases
• Have expert troubleshooting skills on the SQL Clustering environment and Postgres environment
• Monitor, maintain database systems and troubleshoot problems that may arise
• Strong Analytic skills, Data Modelling & Performance tuning in MS SQL server/PostgreSQL
• Perform Upgrade of databases to different versions of SQL and migration of databases from SQL server to PostgreSQL
• Maintain data integrity and security (manage roles and permissions of database users)
• Use tools like SQL Profiler, Database tuning advisor, Execution plans for database tuning and Index recommendations
• Generate traces, execution plans, identify performance issues, deadlocks/contention and resolve them
• Develop strategies and implement solutions for managing back-ups, restoration and replication
• Strong knowledge of SQL Server Integration Services (SSIS), Reporting Services (SSRS), and Analysis Services (SSAS)
• Should be well versed with the SQL replication functions and Change Data capture process
• Ensure timely completion of the Databases regular refreshes keeping all the reporting environment in sync
• Create detailed documentation including diagrams of database infrastructure
• Learn relevant business processes and understand the data flow, criticality and dependencies
• Candidates authorized to work for any employer in the United States without employer-based visa sponsorship are welcome to apply. Infosys is unable to provide immigration sponsorship for this role at this time

Preferred Qualifications:
• Worked on tools like Qlik Attunity, SolarWinds DPA and Delphix.
• PowerShell programming
• Backup and restore tools like EMC Networker, CommVault
• Planning and Co-ordination skills
• Experience of Mergers and Acquisitions will be an added advantage
• Good Communication and Analytical skills

The job entails sitting as well as working at a computer for extended periods of time. Should be able to communicate by telephone, email or face to face. Travel may be required as per the job requirements.