BE/ B.Tech/ MCA in computer science

Key Requirement for the Position

Maintain database server health across all environments for multiple projects
• Maintain and report on queries needing optimization and formulate solutions
• SQL jobs setup and execution
• Work with Development team to troubleshoot issues and optimize T-SQL code
• Deploying new T-SQL code deployments in conjunction with development team code deployments
• Continually look for automation opportunities and organize a plan to feed future projects
• Ensure all system security requirements are met
• Assist Infrastructure and/or IT staff with projects as needed
• Be available for on-call support as needed
• Maintain, manage, and report on SQL backups across different projects
• Maintain the integrity and accuracy of system backups
• Maintain and report on growth trending of all databases forecasting for future needs
• Perform scheduled maintenance and support release deployment activities after hours
• Ensure proper management and maintenance of network infrastructure per policy and management directive



Job Description

  • 8+ years of Microsoft SQL Server experience (2017 and higher) as a Database Administrator with equal mix of a development DBA and a production DBA
    • MCTS, MCITP, and/or MVP certifications a plus
    • Solid grasp of database design concepts and techniques
    • Experience in MS SQL Server performance tuning along with SQL Profiler, client/server connectivity, query optimization, Database Maintenance plans, Database Consistency Checker using DBCC.
    • Skilled with TSQL, query tuning, relational database design and PowerShell scripting
    • Experience working with software architects on database system design
    • Experience of High Availability (HA) and Disaster Recovery (DR) options for SQL Server
    • Experience with Windows server, including Active Directory
    • Experience in installing Service Packs, patches and hotfix for SQL Server and OS.
    • Experience in monitoring SQL Server logs to ensure the backup operations, batch commands, or other scripts and processes have completed successfully.
    • Expert in using tools like Bulk Copy BCP, Data Transformation Services DTS in SSIS
    • Experience in configuring and managing Linked Servers, data transfer between SQL Server and other heterogeneous relational databases.
    • Familiarity with working on large datasets
    • Passionate about building high-quality database systems with industry standard best practices
    • Solid documentation skills
    • Customer-centric approach to finding solutions
    • Excellent communication skills, in person and through phone/email
    • Able to learn new concepts and adapt quickly to an existing, complex environment
    • Professional experience with project lifecycle planning such as Agile/Scrum
    • Experience using Team Foundation Server (TFS) or Azure DevOps
    • Experience with cloud services (AWS, Microsoft

Location: India
Categories: Technology

Apply for this position

Allowed Type(s): .pdf, .doc, .docx
Contact Us