Job Overview
The primary role of this position is to oversee the management of SQL server and Oracle databases across multiple product lifecycle environments, from development to mission-critical production systems. This includes monitoring, fixing, and tuning performance issues in Production/UAT/Dev environments.
Key Responsibilities:
* Establish and enforce security mechanisms
* Collaborate with teams to implement clustering environments on Windows level and install SQL Server 2008, 2012, 2016 R2 Failover Clustering in testing servers & production servers
* Design, develop, and maintain high-availability solutions using Always On in high-performance mode as standard DR strategy
* Perform database maintenance plans for consistency and optimization
* Backup and Recovery of databases and process improvements
Required Skills and Qualifications:
* Minimum 3 years experience in managing SQL server and Oracle databases
* Proficiency in writing SQL, Packages, Stored procedures, functions, and triggers in Oracle and SQL Server
* Experience in implementing or configuring ORACLE 11g solution is a plus
* Knowledge of eSolutions MASTER-SLAVE replication in MYSQL 5.1
* Health check and improvement suggestions related to DB parameters, Sizing, PL-SQL and SQL script analysis, profile creation, and improvements, partitioning, and statistics management
Benefits:
* Flexible hours available
* More than 3 years of relevant work experience required for this role
* Working rights required for this role
Requirements
Minimal experience: Unspecified
Gender: Indistinct
Positions available: 1