Senior Database Specialist

Responsibilities:Create and manage multiple databases and assist in capacity planning.Monitor, maintain database systems and troubleshoot problems that may arise.Maintain data integrity and security (manage roles and permissions of database users).Use tools like SQL Profiler for database tuning. Generate traces, execution plans, identify performance issues, deadlocks/contention and resolve them.Develop strategies and implement solutions for managing back-ups, restoration, and replication.Create and manage constraints and indexes.Support software developers with database operations including the development of complex SQL, tuning of DML, and the creation of stored procedures.Proactive housekeeping/archiving and shrinking of databases.Manage production, QA, and development database environments.Create detailed documentation including diagrams of database infrastructure.Learn relevant business processes and understand the data flow, criticality, and dependencies.Effectively coordinate and communicate with all stakeholders.Manage backup and restore operations for databases.Set up and maintain database infrastructure for the CHI needs.Knowledge in Cloud Infrastructure.Knowledge in open-source database technologies.Familiar with Database monitoring solutions.Experience in SQL Server Clustering and HA technologies including mirroring, log shipping, failover cluster and various replication technologies.Implement, manage, and maintain Oracle Data Guard and Oracle RAC for high availability and disaster recovery to ensure scalability and performance.Plan and execute Oracle database upgrades and patching activities to maintain system stability and compliance.Implement and manage database encryption to ensure data confidentiality and compliance with security standards.Qualifications:Bachelor’s degree in MIS, Information Systems, Computer Science, or equivalent majors.5 to 10 years of experience in administering Microsoft SQL Server and Oracle databases.Strong interpersonal and presentation techniques.