Job Description
Job Description
• Perform day to day operational management and administration of existing MSSQL databases and Servers
• Interface with existing IT departments to ensure OLTP ATM switches are online, available and performing optimally with a ++.++++% required uptime
• Proactively monitor the enterprise database systems to ensure secure, reliable service with minimum downtime
• Perform day to day backup management as well as file management of MSSQL databases
• Availability for 24/7 on call support.
• Monitor, evaluate, tune and optimize MSSQL databases and Servers
• Work with the Application Development team to ensure code is performant on databases, table structures are well designed and index performance is considered
• Manage and maintain database Security; including Active Directory and MSSQL role based security models
• Responsible for implementation all changes to the Production environment and ensure proper Change Management policies are followed
• Research and implement Windows/SQL patches and Service Packs
• Documentation of all SQL Servers and Databases within the Enterprise
• Ensure resolutions to issues are completed rather than repetitive repairs
Core Competencies and Skills
• MSSQL Server 2012 - 2016 Enterprise/Professional
• Excellent planning and organizational skills
• Excellent analytical skills
• Ability to multi-task
• Initiative & innovation
• Detail orientated
• Strong interpersonal skills
• Team player
Education
• Post-Secondary Education
• IT related degree
• Relevant IT related training/certifications (MCDBA, etc.)
Experience
• 2 to 8 years of progressive experience as a MSSQL DBS in OLTP/OLAP
• Experience in monitoring, maintaining and supporting highly available MSSQL databases
• Experience in MSSQL Built-in tools such as SQL Profiler, SQL Database Tuning Advisor, Query Execution Plan, etc. as well as third party tools; Quest Spotlight/Foglight
• Experience in creating and maintaining SQL Agent Jobs and Maintenance Plans
• Experience in adhering to a Change Management process
• Experience maintaining multiple environments, Production, Staging, Quality Assurance, Development, etc.
• Experience in implementing Windows/SQL patches.
• Experience solving complex support issues within SQL Server and Databases.
• Knowledge on SAN technologies, I/O subsystems
• Experience installing and configuring MSSQL Servers
• Knowledge on SSIS and SSRS development preferred
• Experience in a Financial based transaction processing environments such as Banking, Payments, etc. preferred
• Experience in Database high availability technologies preferred
• PCI, PHI, HIPPA experience preferred
Job Classification
Industry: IT Services & ConsultingFunctional Area: Role Category: DBA / Data warehousingRole: DBA / Data warehousingEmployement Type: Full timeEducation
Under Graduation: Any GraduatePost Graduation: Any PostgraduateDoctorate: Doctorate Not RequiredContact Details:
Company: NCR CorporationLocation(s): Kolkata
• Perform day to day operational management and administration of existing MSSQL databases and Servers
• Interface with existing IT departments to ensure OLTP ATM switches are online, available and performing optimally with a ++.++++% required uptime
• Proactively monitor the enterprise database systems to ensure secure, reliable service with minimum downtime
• Perform day to day backup management as well as file management of MSSQL databases
• Availability for 24/7 on call support.
• Monitor, evaluate, tune and optimize MSSQL databases and Servers
• Work with the Application Development team to ensure code is performant on databases, table structures are well designed and index performance is considered
• Manage and maintain database Security; including Active Directory and MSSQL role based security models
• Responsible for implementation all changes to the Production environment and ensure proper Change Management policies are followed
• Research and implement Windows/SQL patches and Service Packs
• Documentation of all SQL Servers and Databases within the Enterprise
• Ensure resolutions to issues are completed rather than repetitive repairs
Core Competencies and Skills
• MSSQL Server 2012 - 2016 Enterprise/Professional
• Excellent planning and organizational skills
• Excellent analytical skills
• Ability to multi-task
• Initiative & innovation
• Detail orientated
• Strong interpersonal skills
• Team player
Education
• Post-Secondary Education
• IT related degree
• Relevant IT related training/certifications (MCDBA, etc.)
Experience
• 2 to 8 years of progressive experience as a MSSQL DBS in OLTP/OLAP
• Experience in monitoring, maintaining and supporting highly available MSSQL databases
• Experience in MSSQL Built-in tools such as SQL Profiler, SQL Database Tuning Advisor, Query Execution Plan, etc. as well as third party tools; Quest Spotlight/Foglight
• Experience in creating and maintaining SQL Agent Jobs and Maintenance Plans
• Experience in adhering to a Change Management process
• Experience maintaining multiple environments, Production, Staging, Quality Assurance, Development, etc.
• Experience in implementing Windows/SQL patches.
• Experience solving complex support issues within SQL Server and Databases.
• Knowledge on SAN technologies, I/O subsystems
• Experience installing and configuring MSSQL Servers
• Knowledge on SSIS and SSRS development preferred
• Experience in a Financial based transaction processing environments such as Banking, Payments, etc. preferred
• Experience in Database high availability technologies preferred
• PCI, PHI, HIPPA experience preferred
Job Classification
Industry: IT Services & ConsultingFunctional Area: Role Category: DBA / Data warehousingRole: DBA / Data warehousingEmployement Type: Full timeEducation
Under Graduation: Any GraduatePost Graduation: Any PostgraduateDoctorate: Doctorate Not RequiredContact Details:
Company: NCR CorporationLocation(s): Kolkata
💡 Quick Summary
Seeking a career-building opportunity? The SQL Server DBA position is now open for candidates interested in the Database Administrator sector. This role in Kolkata offers a professional environment and growth potential.
Requirement Snapshot: Candidates should possess basic communication skills, a proactive attitude, and the ability to work in a team. Experience in Database Administrator is a plus.
