Database Administrator (MSSQL) - Apex Analytix : Job Details

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 - Job Details 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 -

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.

High Availability Management:

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

Monitoring and Alerting

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

Capacity Planning

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

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.

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.

Security Management:

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

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.

Incident Response:

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

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, including developers, system administrators, and network engineers.
• Provide technical support and guidance to team members.

THE MUST-HAVES -

• Bachelor's degree in computer science, Information Technology, or a related field
• Proven 8-10 years' experience as a Database Administrator with a focus on MSSQL.
• Experience in database design, implementation, performance tuning, and troubleshooting.
• Proficiency in MSSQL administration, including installations, configurations, and upgrades.
• Strong knowledge of database security best practices.
• Excellent problem-solving and analytical skills.
• Familiarity with backup and recovery processes.
• Microsoft Certified: Azure Database Administrator Associate (optional but preferred).
• Strong verbal and written communication skills.
• Ability to communicate technical information to non-technical stakeholders.

Over the years, we've discovered that the most effective and successful associates at apexanalytix are people who have a specific combination of values, skills, and behaviors that we call The apex Way . Read more about The apex Way - Benefits At apexanalytix we know that our associates are the reason behind our successes. We truly value you as an associate and part of our professional family. Our goal is to offer the very best benefits possible to you and your loved ones. When it comes to benefits, whether for yourself or your family the most important aspect is choice. And we get that. apexanalytix offers competitive benefits for the countries that we serve, in addition to our BeWell@apex initiative that encourages employees' growth in six key wellness areas: Emotional, Physical, Community, Financial, Social, and Intelligence. With resources such as a strong Mentor Program, Internal Training Portal, plus Education, Tuition, and Certification Assistance, we provide tools for our associates to grow and develop.