Database Administrator

About Us:

At apexanalytix, we’re lifelong innovators! Since the date of our founding nearly four decades ago we’ve been consistently growing, profitable, and delivering the best procure-to-pay solutions to the world.   We’re the perfect balance of established company and start-up.  You will find a unique home here. 

And you’ll recognize the names of our clients. Most of them are on The Global 2000. They trust us to give them the latest in controls, audit and analytics software every day.  Industry analysts consistently rank us as a top supplier management solution, and you’ll be helping build that reputation.

Read more about apexanalytix - https://www.apexanalytix.com/about/

Job Details

The Role

QUICK TAKE -

We are seeking a skilled and experienced Database Administrator (DBA) with expertise in Microsoft SQL Server (MSSQL) to join our dynamic IT team. The ideal candidate will be responsible for the design, implementation, maintenance, and performance of our MSSQL databases. The successful candidate will work closely with other IT professionals, system administrators, and developers to ensure the integrity, security, and availability of our database systems.

THE WORK -

1. Database Design and Implementation:

• Design, implement, and maintain MSSQL databases that meet organizational needs.
• Collaborate with application developers to define database structures, tables, and relationships.

1. High Availability Management:

• Implement and manage high availability solutions such as database clustering, mirroring, and AlwaysOn Availability Groups to ensure continuous database access.

1. Monitoring and Alerting

• Set up monitoring systems to track database performance metrics.
• Respond to alerts promptly and proactively address potential issues.

1. Capacity Planning

• Monitor database usage trends and plan for capacity needs.
• Scale resources as necessary to accommodate growing data and user requirements.

1. Backup and Recovery Operations:

• Execute regular database backups and validate their integrity.
• Conduct periodic recovery drills to ensure a quick and effective response in case of data loss.

1. Performance Tuning and Optimization:

• Monitor database performance and optimize queries for maximum efficiency.
• Implement best practices for performance and scalability.
• Identify and resolve performance bottlenecks through query optimization, index tuning, and other performance-enhancing techniques.

1. Security Management:

• Conduct security audits and implement measures to address vulnerabilities.
• Regularly review and update security protocols to protect against unauthorized access.

1. Upgrades and Patch Management:

• Stay informed about the latest MSSQL patches and updates.
• Plan and execute patch deployments in a timely and organized manner.
• Stay current with MSSQL releases and features.

1. Incident Response:

• Respond to and resolve database-related incidents promptly.
• Document incident details and implement preventive measures to avoid future occurrences.

1. Automation and Scripting:

• Develop and implement scripts for routine tasks, automation, and monitoring.
• Explore opportunities for process automation to improve efficiency.

Documentation:

• Create and maintain documentation for database configurations, processes, and procedures.
• Ensure that documentation is up-to-date and accessible to the team.

Collaboration:

• Work collaboratively with cross-functional teams, includ