Database Administrator II

**About the Role**

We are seeking a highly skilled Database Administrator II to join our team at Transaction Network Services. As a key member of our IT department, you will be responsible for the support, maintenance, and development of our databases, which are critical to our business operations.

Key Responsibilities

• Provide database administration and day-to-day support for our databases, including Oracle, MariaDB, MongoDB, and SQL Server.
• Implement and support administration tasks such as backup and recovery procedures, database utilities, and data replication technologies.
• Troubleshoot and provide technical support for database-related issues, including effective communication with internal and external customers.
• Manage organizational data definitions and process-flows to ensure consistency, security, and accuracy of transactional data.
• Provide technical services to monitor and maintain environments, including periodic software upgrades, vulnerability patching, and migration of databases.
• Document operational or newly engineered solutions to educate and inform the IT Support staff.
• Create and maintain Linux and SQL scripts to automate scheduled tasks and monitor database alerts.
• Log, schedule, and track all changes using change management system tools.
• Provide 24x7 on-call support in rotation for production databases.

Requirements

• 4+ years of advanced database administration experience with large-scale Oracle, MySQL, SQL Server in multi-node clustered environments, including replication and security.
• 3+ years of database administration experience in MongoDB and MariaDB with development experience.
• Strong knowledge of SQL maintenance, backup, SQL stored procedures, high-availability, performance tuning, and future architecture design and expansion.
• Working knowledge of data modeling, database administration problems and requirements, and database analysis and design procedures, techniques, and implementation.
• Experience with database warehousing, decision support, and OLTP.
• 4+ years' experience in reviewing, writing, and debugging complex SQL stored procedures, functions, and triggers.
• Experience with advanced SQL Server network connectivity and protocols.
• Strong working experience using various database tools and SQL performance analyzer.
• Highly motivated with a commitment to quality service.
• Strong knowledge of managing projects and excellent communication skills.
• Ability to communicate orally and in writing clearly and straightforwardly.
• Ability to handle multiple projects and tasks.

Qualifications

We are an equal opportunity employer and welcome applications from qualified candidates. We evaluate qualified applicants without regard to race, color, religion, gender, national origin, age, sexual orientation, gender identity or expression, protected veteran status, disability/handicap status, or any other legally protected characteristic.