Senior Database Administrator at IntouchCX

Job description

About the Job We are seeking an experienced Senior Database Administrator (DBA) to manage and maintain our database systems, ensuring their performance, availability, and security. The ideal candidate will have advanced knowledge of Microsoft SQL Server (MSSQL), MySQL, and MongoDB, along with strong problem-solving skills and the ability to work in a fast-paced environment. As Senior Database Administrator, You Will… Design, implement, and maintain database structures and schemas for MSSQL, MySQL, and MongoDB. Write reusable, testable, and efficient stored procedures code. Design and implementation of low-latency and high-availability stored procedures, functions, triggers & jobs. Monitor and optimize database performance, including query tuning and index optimization. Ensure database security by implementing user roles, permissions, and auditing practices. Perform regular database backups, restores, and disaster recovery planning. Collaborate with development teams to optimize database queries and support application performance. Provide database support for production and development environments, troubleshooting issues as they arise. Assist in data modeling, data migration, and integration tasks. Maintain documentation related to database architecture, processes, and procedures. Stay current with industry trends and best practices in database management. Report generation is required. As Senior Database Administrator, You Need… A graduate with a minimum of 6 years experience as a DBA. Strong understanding of database design principles and best practices. Knowledge in developing dynamic-looking graphs/reports. Knowledge of database backup and recovery techniques and policies. Experience with database performance tuning, indexing, and query optimization. Familiarity with cloud database services (e.g., AWS RDS, Azure SQL Database) is a plus. Experience with automation and scripting (e.g., PowerShell, Bash, Python) for database management tasks. Effective communication, technical understanding, and teamwork skills. Excellent problem-solving and analytical skills. Knowledge of the following: MSSQL MySQL Mongo Powershell Bash Python Writing Stored Procedures Stored Functions MSSQL Job Agent AWS RDS Azure SQL Database

Requirements

Must-haves

As Senior Database Administrator, You Will…
Design, implement, and maintain database structures and schemas for MSSQL, MySQL, and MongoDB.
Write reusable, testable, and efficient stored procedures code.
Design and implementation of low-latency and high-availability stored procedures, functions, triggers & jobs.
Monitor and optimize database performance, including query tuning and index optimization.
Ensure database security by implementing user roles, permissions, and auditing practices.
Perform regular database backups, restores, and disaster recovery planning.
Collaborate with development teams to optimize database queries and support application performance.
Provide database support for production and development environments, troubleshooting issues as they arise.
Assist in data modeling, data migration, and integration tasks.
Maintain documentation related to database architecture, processes, and procedures.
Stay current with industry trends and best practices in database management.
Report generation is required.
As Senior Database Administrator, You Need…
A graduate with a minimum of 6 years experience as a DBA.
Strong understanding of database design principles and best practices.
Knowledge in developing dynamic-looking graphs/reports.
Knowledge of database backup and recovery techniques and policies.
Experience with database performance tuning, indexing, and query optimization.
Experience with automation and scripting (e.g., PowerShell, Bash, Python) for database management tasks.
Effective communication, technical understanding, and teamwork skills.
Excellent problem-solving and analytical skills.
Writing Stored Procedures

Nice-to-haves

Familiarity with cloud database services (e.g., AWS RDS, Azure SQL Database) is a plus.

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

sqlawsazurepython

Platform: dayforce
Effort: medium