Job description Infosys is seeking SQL Server DBA. This role requires close partnership and collaboration with other Engineers and Subject Matter Experts.Required Qualifications :
- Candidate must be located within commuting distance of Detroit, MI, or be willing to relocate to the area. This position may require travel in the US.
- 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 4 years of Information Technology experience
- At least 4 years of MS SQL Server Administration experience required.
- Manage SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems.
- Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.
- Apply data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations.
- Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end.
- Refine and automate regular processes, track issues, and document changes.
- Assist developers with complex query tuning and schema refinement.
- Provide 24x7 support for critical production systems.
- Perform scheduled maintenance and support release deployment activities after hours.
- Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members.
- Working Knowledge :
- Installation, configuration, and maintenance of SQL Servers R2, , ,, , .
- Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools.
- Upgrades / Migrations from SQL R2 to SQL / / / .
- Installing service packs, and client installations as required.
- Troubleshooting blocking issues, deadlock issues, disk space issues and providing solutions for all SQL server issues.
- Backups, restores and recovery models.
- High Availability (HA) and Disaster Recovery (DR) options for SQL Server.
- Always On AG configuration, Failovers, adding or removing DB’s from the existing AG set up, adding new DR replicas to the existing AG Configuration.
- Configuring, Maintaining, and troubleshooting linked server issues.
- Security administration, configuring permissions and assigning roles to users.
- Performing database health checks using SQL profiler, performance monitor, DMV’S and DBCC commands.
- Scheduling and Maintaining Jobs, Alerts and Maintenance plans.
- Monitoring, Maintaining and Troubleshooting High Availability options being used in Log Shipping, Mirroring and Replication.
- Implementation of Database change requests (ITIL Processes).
- Windows Server, including Active Directory.
- U.S. Citizens are encouraged to apply. We are unable to sponsor at this timePreferred Qualifications :
- Excellent Communications and client interaction skills along with exceptional written and verbal skills as well as technical documentation
- Extraordinary Planning, Project Management, Coordination, and Analytical skills
- Hands-on experience in working in Global Delivery Model with onsite / offshore resources
- Exceptional Organizational Skills
- Ability to manage and prioritize tasks efficiently
- Readiness to demonstrate a proactive attitude
- Solid attention to detail and excellent written and verbal communication skills are required
- Ability to work in team in diverse / multiple stakeholder environmentThe 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.Visit to see how Infosys (NYSE : INFY) can help your enterprise navigate your next.
Infosys is an equal opportunity employer and all qualified applicants will receive consideration without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, protected veteran status, spouse of protected veteran, or disability.
30+ days ago