Seeking MSSQL Database Administrator with good technical knowledge in MSSQL Server for implementation, configuration, maintenance and performance tuning of SQL Server RDMS system. Main goal is to ensure high availability and consistent performance of various Bank’s applications. Responsibilities include ongoing support and administration of MSSQL database, providing technical assistance and consulting to end-users and application developers, developing and maintaining tools for managing the server infrastructure and troubleshooting high-profile performance issues utilizing root-cause analysis and implement appropriate plan for problem resolution.
- Degree in Computer Science or equivalent
- Proficiency in MSSQL database management
- Experience setting up Master-Slave replication, multi-Master replication, High Availability and disaster recovery in production environment
- Experience on Maxscale HA proxy implementation
- Hands On Experience with MSSQL database and query performance tuning
- Familiarity with other SQL / NoSQL database such as MongDB server will be added advantage
- Good knowledge in Unix command
- Able to work extended hours
- Good analytic skills, troubleshooting and problem identificationResponsibilities for MSSQL
- Strong knowledge and experience in installing, configuring, and upgrading MSSQL databases.
- Analyze the data stored in the database and to make recommendations relating to performance and efficiency of that data storage
- Establish standards and best practices for SQL
- Proactively monitor systems for optimum performance and capacity constraints
- Administer existing enterprise databases, and analyze, design and create new databases
- Familiar with database backup and recovery strategies
- Experience in setting up and handling SQL server AlwaysON solution
- Familiar with AlwaysON Readonly routing
- Handling database security, roles and privileges
- Implement, Administer and maintain the partitioned tables in SQL server
- Good knowledge on query tuning and query execution plan analysis
- Provide 24x7 support