Description

Key Skills: MySQL, SQL Server, T-SQL, Database Administration, Performance Tuning, Backup Recovery, High Availability, PowerShell, Python, ITIL

Good to Have Skills: SSMS, SSRS, SSIS, Always On Clustering, InnoDB, MyISAM, Replication, Query Optimization, Windows Server, Linux Unix operating systems, Data Modeling, database design principles, Azure Database Administrator Associate certification, Oracle Certified Professional MySQL certification, scripting and automation capabilities.

Roles & Responsibilities:

• Install, configure, and maintain database software across multiple environments for both MS SQL Server and MySQL.
• Proactively monitor database system performance, identify bottlenecks, and implement solutions for performance tuning including query optimization and index management.
• Implement and manage High Availability and Disaster Recovery solutions such as SQL Server Always On Availability Groups and MySQL Replication.
• Define, implement, and test robust backup and recovery strategies for all databases to ensure data integrity.
• Plan, schedule, and execute database software patching, upgrades, and migrations with minimal downtime.
• Implement and manage database security including user accounts, roles, permissions, and auditing to protect sensitive data.
• Diagnose and resolve complex database-related issues including connection problems, data corruption, and application errors.
• Write, modify, and optimize stored procedures and functions, and use scripting languages to automate routine DBA tasks.
• Work closely with developers, system administrators, and application teams to assist with database design and deployment processes.
• Create and maintain comprehensive documentation for database procedures, configurations, standards, and troubleshooting guides.

Experience Required: 4-6+ years of experience as a Database Administrator supporting production environments with demonstrable experience administering both Microsoft SQL Server and MySQL databases.

Education: Bachelor's degree in Computer Science, Information Technology, or a related field (or equivalent work experience)

Key Skills

Education

Any Graduate