Supports the day to day availability and performance of s SqlServer operational support systems including the ability to troubleshoot and isolate moderate to complex system/application issues for SqlServer based operating systems and hardware.
Proposes and implements complex system enhancements (software and hardware updates) that will improve the performance and reliability of the system. Manages the configuration of the sqlserver .
Supports the rollout of complex projects that impact SqlServer operational support systems. Installing configuring and testing different produce sets on SqlServer 2008R22012 and 2019
Provides 24x7 support on a rotating basis is required and responsible for performing the job in accordance Client vision and values
Roles & Responsibilities: Responsible to support 1000 Sql db servers(2000 to 2019) and provide oncal support. Responsible for all operational aspects of Sql Server database systems including performance integrity and security. Plan and execute database migration from Microsoft SQL Server to Postgre Respond to incidents troubleshoot issues and provide advice on improving database performance. Monitor performance of the database and the database servers; Determine optimal performance parameters for the database server operating system etc. and tune as needed. Carry out periodic maintenance of the database including table extents indexes etc. Carry out periodic maintenance of the database platform in terms of software updates security updates and service packs. Plan test and execute a data migration from a Microsoft SQL Server DBMS to Postgre db Ensure that redundant database systems are properly maintained and that they are available for activation as and when required. Carry out database design tasks in conjunction with the software development team and implement enhancements and modifications to the database. Monitor database logs and take corrective action on issues if required. Participate 24x7 on call support on a weekly rotating schedule including weekends Develop and maintain Standard Operating Procedures/documentation Experience in legacy db versions (Sqlserver ) as he will be part of migrations to Postgre and upgrade to Sql server 2019 Provide escalation support for database related issues Share knowledge and mentor junior team members as needed Develop administration automation and monitoring scripts as needed
Required industry experience:
5 to 7 years experience in SqlServer and knowledge on other RDBMS dbs
Required functional experience
Excellent communication interpersonal analytical skills
Planning and Co-ordination skills
Experience with project management
Experience in vendor management
Experience ITIL Incident change Problem Release management process
Experience and desire to work in a management consulting environment
Experience resolving more complex technical problems through a defined escalation process
Excellent written and verbal communications skills.
Strong time management process improvement and scheduling skills
Able to work and communicate across multiple departments.
Provides strategic/visionary recommendations.
Establishes methods and procedures for the team.
Initiates and owns process improvements and convey changes to others gain organizational support for making changes.
Extensive knowledge of key Client systems and processes.
Required education and certifications
Bachelors degree from an accredited institution.
Microsoft sql server administration(preferred)
Additional requirements
Experience with backup technologies such as IBM TSM Avamar and DELL ddboost
Experience in working on ITSM tool BMC Remedy
About Us Infosys 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.
EEO 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. 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.
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.