SQL DBA

Job description

Job Description

: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 R2, ,,, and 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 + Sql db servers( to ) 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 • Provide escalation support for database related issues• Share knowledge and mentor junior team members as needed• Develop administration automation and monitoring scripts as neededRequired industry experience:5 to 7 years’ experience in SqlServer and knowledge on other RDBMS db’s Required functional experienceExcellent communication ,interpersonal ,analytical skillsPlanning and Co-ordination skillsExperience with project managementExperience in vendor managementExperience ITIL Incident, change, Problem, Release management processExperience and desire to work in a management consulting environmentExperience resolving more complex technical problems through a defined escalation processExcellent written and verbal communications skills.Strong time management, process improvement, and scheduling skillsAble 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 certificationsBachelor's degree from an accredited institution.Microsoft sql server administration(preferred) Additional requirementsExperience with backup technologies such as IBM TSM, Avamar and DELL ddboostExperience in working on ITSM tool BMC Remedy EEOInfosys 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.

Required Skill Profession

Computer Occupations