**Responsibilities**:
Database Management:
- Install, configure, maintain, and provide support assistance and administration for the database technology stack (IBM DB2/MSSQL/MySQL/Azure PaaS), ensuring availability, efficiency, reliability, data integrity, security, retention, and recoverability.
- Perform script maintenance and batch job processing as a critical element of data import management.
- Monitor database performance, promptly respond to alerts, identify and resolve bottlenecks or other issues to ensure smooth operations.
- Utilize your curiosity and desire to learn new technologies to recommend functionality and capabilities that meet the company's product and operations objectives.
Security and Access Control:
- Implement and enforce security measures to protect sensitive data from unauthorized access or breaches.
- Manage user access and permissions to databases, adhering to the principle of least privilege.
- Ensure compliance with data protection and privacy regulations.
- Suggest and enforce standards on database security.
Database Optimization and Performance Tuning:
- Continuously evaluate and optimize database performance to minimize response times and maximize efficiency.
- Analyze query execution plans and identify opportunities for query optimization.
- Conduct regular performance tuning, database reorganization, and index maintenance.
Backup and Recovery:
- Create and maintain backup and recovery strategies to prevent data loss and expedite data recovery.
- Regularly test backup and recovery procedures to verify their effectiveness.
Data Migration and Integration:
- Manage data migration between systems and maintain data integrity during the process.
- Support the implementation and release of database changes submitted by development teams.
Troubleshooting and Support:
- Respond to and resolve database-related incidents and issues reported by users or automated monitoring systems.
Documentation and Reporting:
- Maintain comprehensive documentation of database configurations and changes.
- Generate regular reports on database performance, usage, and growth.
- Assist with the development and documentation of database standards, guidelines and processes as required.
Qualifications:
- Bachelor's degree in computer science, Information Technology, or a related field
- Minimum 4 years' experience in database administration
- Hands-on experience and proficiency in database administration with IBM DB2, MSSQL, MySQL, and Azure database PaaS in a corporate environment
- Proficiency in writing SQL queries and stored procedures
- Understanding of database security best practices and access control mechanisms
- Experience with performance tuning, query optimization, and indexing.
- Familiarity with data migration and integration techniques
- Excellent problem-solving and analytical skills
- Excellent communication and interpersonal skills
- Ability to detect and troubleshoot database server performance and utilization issues related to CPU, memory, I/O, disk space and other resource contention contributors.
- Experience with Linux and Windows server platforms.
- Scripting experience (PowerShell, Perl, Python) desired
- Knowledge of database backups/restores, recovery models, High Availability, Disaster Recovery
- Self-motivator, who can work independently as well as part of a team, able to learn quickly, prioritize effectively and meet deadlines.
- Strong writing skills to provide documentation of database infrastructure and processes.
- Ability to work on call as needed to support business needs.
