SQL Database Administrator
Infosys is seekinga SQLDatabase 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 to Richardson, TX. Alternative locations could be - 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:00-14:00 CST
Shift 2 13:00-22:00 CST
Shift 3 21:00-06:00 CST
• Bachelor's 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 1 year of Information Technology experience
• At least 6 months of experience in MS SQL server administration and maintenance (PostgreSQL will be an added advantage)
• Understanding of Cloud environment (Azure will be preferable)
• 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
Want more jobs like this?
Get jobs in Hartford, CT delivered to your inbox every week.
• Generate traces, execution plans, identify performance issues, deadlocks/contention and resolve them
• Develop strategies and implement solutions for managing back-ups, restoration and replication
• 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.
Perks and Benefits
Health and Wellness
- Health Insurance
- Life Insurance
- HSA
- Short-Term Disability
Parental Benefits
- Birth Parent or Maternity Leave
- Non-Birth Parent or Paternity Leave
- On-site/Nearby Childcare
Work Flexibility
Office Life and Perks
- Commuter Benefits Program
Vacation and Time Off
- Paid Vacation
- Paid Holidays
- Personal/Sick Days
- Sabbatical
Financial and Retirement
- 401(K)
- Relocation Assistance
Professional Development
- Learning and Development Stipend
Diversity and Inclusion
- Employee Resource Groups (ERG)