Infosys is seeking a AzureSQL Database Administrator. This role requires close partnership and collaboration with other Data Engineers and Subject Matter Experts. This candidate needs to maintain best practices and collaborate with the architecture and application teams to set the technical vision and target architecture
Required Qualifications:
Candidate must be located within commuting distance or willing to relocate toRichardson TX. Alternate locations that may be considered- Tempe AZ Raleigh NC; Hartford CT; Indianapolis IN.
Candidate must be available to work on a rotating shift schedule to provide 24/7 support.Shift 1 05:0014:00 CST
Shift 2 13:0022:00 CST
Shift 3 21:0006:00 CST
Bachelors degree or foreign equivalent required from an accredited institution. Will also consider three years of progressive experience in the specialty 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.About UsInfosys is a global leader in next-generation digital services and consulting. We enable clients in more than 50 countries to navigate their digital transformation. With over four decades of experience in managing the systems and workings of global enterprises we expertly steer our clients through their digital journey. We do it by enabling the enterprise with an AI-powered core that helps prioritize the execution of change. We also empower the business with agile digital at scale to deliver unprecedented levels of performance and customer delight. Our always-on learning agenda drives their continuous improvement through building and transferring digital skills expertise and ideas from our innovation ecosystem.
Infosys provides equal employment opportunities to applicants and employees without regard to race; color; sex; gender identity; sexual orientation; religious practices and observances; national origin; pregnancy childbirth or related medical conditions; status as a protected veteran or spouse/family member of a protected veteran; or disability. Required Experience:
Unclear Seniority