Job Description /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.
Skills / 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.