Database Administrator

To administer and maintain databases, ensuring their availability, security, and optimal performance, while supporting other teams with data management and recovery needs.Job RequirementsBachelor's degree in Computer Science, or closely related field.4+ years of IT experience in MS SQL Server Database Administration.ResponsibilitiesInstallation, Configuration and upgrade of MS SQL Server.Designing, implementation and configuration of SQL Server Replication.Applying SQL patching.Plan, execute and support implementations so the applications are deployed with minimal disruption to the production environment and meet established standards.Perform and review health checks, identify and elevate trends. Act on all DBs level alerts and assist with service restoration.Troubleshooting & investigating. Assisting with root cause analysis and remediation via review of logs & code logic.Designing the architecture of the database and can forecast the future requirements and demands.Prepare detailed documentation including diagrams of database infrastructure.Monitor all DBs execution and sustain full proof processes in line with business needs.SkillsKnowledge about Linux OS and Windows OS.Experience with backups, restores and recovery models.Experience in troubleshooting and resolving performance issues, blocking and deadlocking etc.Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.Ability to write and troubleshoot SQL queries and codes (stored procedures, functions, tables, views, triggers, indexes, constraints).Knowledge of implementing DR and SQL failover solutions.Knowledge about SSIS packages.Experience in SQL Server Clustering and HA technologies including mirroring, log shipping, failover cluster and various replication technologies would be an advantage.Knowledge about OpenSources PostgreSQL, MySQL – Preferred.#J-18808-Ljbffr