Job Description

This is MSSQL database developer and admin role (Application DBA), and the engineer will work closely with Senior Application DBA and application teams on managing and implementing databases deliverab This is MSSQL database developer and admin role (Application DBA), and the engineer will work closely with Senior Application DBA and application teams on managing and implementing databases deliverables. Responsibilities: Work closely with the application development teams to design and implement database related deliverables. Review database scripts prepared by application developers, to ensure scripts are optimized and following database best practices. Perform MS SQL database support, which includes monitoring of performance and database availability, database sizing, database maintenance, query/configuration tuning, and database migration. Resolve database related incidents , reviewing service related reports (e.g. database backups, maintenance, monitoring) on a daily basis to ensure service related issues are identified and resolved within established SLAs. Respond to database related alerts and working with application developers to fix problems. Perform other database related tasks which include generation of ad-hoc queries/reports, database creation and restoration among others. Implement database automation tools to continuously improve delivery and operations. Involve in troubleshooting database related production issues. Organize regular sessions to review and fine tune database queries. Requirements Minimum 5 years of experience in Microsoft SQL Server (2012 and above) Administration and/or Development. Good knowledge on SQL server architecture and design. Technical understanding of software build and deployment together with relevant tools (i.e. PowerShell, Git, DevOps etc.). Knowledge on infrastructure components (i.e. Virtualization, Network, Load Balancers, SAN), and commercial cloud AWS. Experience supporting a 24x7 high-availability production systems will be advantageous. Software development experience ( any programming language) will be advantageous. Good analytical and problem-solving skills. Have service excellence attitude. Ability to work independently, as well as in a team with minimal supervision. Must have strong verbal and written communications skills to interact with team members and functional analysts on a daily basis.