Qualifications
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
Experience
7 TO 9 YEARS
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