Sql Database Administrator

Role & Responsibilities:

• Administer and maintain MSSQL, PostgreSQL, and MySQL database environments with 3+ years of hands-on experience.
• Perform core DBA administrative tasks with a strong grasp of database engine architecture.
• Implement and maintain robust database security protocols.
• Manage cloud-based database hosting, preferably on Google Cloud Platform (GCP).
• Work with in-memory databases such as Redis and Memcached.
• Set up monitoring and alert systems for critical database metrics and performance.
• Conduct performance analysis and optimization for databases under various workloads.
• Execute post-deployment configurations following best practices.
• Automate database installations using tools like Ansible.
• Configure and manage CI/CD pipelines to streamline DBA-related workflows (advantageous).
• Develop PowerShell scripts for automating MSSQL administrative tasks.
• Perform database migrations across heterogeneous environments (e.g., MSSQL to PostgreSQL).
• Navigate Linux systems to manage MySQL and PostgreSQL databases.
• Design and implement disaster recovery and high-availability solutions.
• Configure replication and load balancing for optimized database performance and availability.
• Manage database backup strategies and periodic recovery testing.
• Stay updated with the latest database features and industry trends.
• Maintain accurate documentation including inventory, installation, and maintenance procedures.
• Communicate effectively with internal teams and external clients to resolve issues and manage expectations.