SQL Database Administrator at Games Global

Responsibilities

What will you do?

• Database Management:
• Install, configure, and maintain SQL Server instances to support business applications.
• Monitor the health and performance of database systems, identifying and resolving issues to maintain uptime and efficiency.
• Implement automation for routine maintenance tasks to enhance system performance and reduce manual effort.
• Database Development and Optimization:
• Develop complex SQL queries, stored procedures, and functions to support various business requirements.
• Collaborate with software developers to integrate database functions into applications and to provide SQL-related support.
• Conduct code reviews and provide feedback to ensure high-quality database solutions.
• Security and Compliance:
• Implement security measures to protect sensitive data and database systems.
• Ensure adherence to data protection regulations and internal policies through regular audits and assessments.
• Develop and maintain documentation for security practices and procedures.
• Performance Tuning:
• Analyze and troubleshoot database performance issues, implementing solutions to optimize system performance.
• Adjust database configurations and optimize SQL queries to enhance responsiveness and efficiency.
• Utilize indexing and other optimization techniques to improve query execution times.
• Backup and Recovery Planning:
• Develop and execute comprehensive backup strategies to ensure data protection and availability.
• Conduct regular recovery tests to validate backup processes and minimize potential data loss.
• Maintain data integrity through consistent monitoring and validation of backup processes.
• Collaboration and Communication:
• Work with various teams to understand their data needs and provide appropriate database solutions.
• Communicate effectively with stakeholders to keep them informed of database-related updates and issues.
• Document database configurations, processes, and policies to maintain clear and accessible records.
• Cloud Integration (Preferred):
• Manage SQL Server databases within AWS cloud environments, utilizing services such as RDS and EC2.
• Assist in planning and executing the migration of databases from on-premises systems to the cloud.
• Optimize database performance in cloud settings and ensure effective integration with cloud-based applications.
• Operational Requirement:
• In-Hours Hotseat:
• Serve as the primary point of contact for urgent database-related issues during regular business hours.
• Respond promptly to high-priority incidents and coordinate with other team members to ensure swift resolution.
• Monitor database systems closely and proactively address potential problems to minimize disruptions.
• After-Hours Standby:
• Be available on a rotational basis for after-hours support to address critical database incidents that may arise outside regular working hours.
• Provide timely and effective responses to after-hours alerts to maintain system availability and performance.
• Coordinate with the IT team and other stakeholders to manage and resolve after-hours issues as required.
• This requirement ensures that our database infrastructure remains reliable and available, supporting the continuous operation of the organization’s critical business processes.

Qualifications

Who are we looking for?

• Education: Bachelor’s degree in Computer Science, Information Technology, or a related field.
• Experience: 3-5 years as a Database Administrator with expertise in SQL Server.
• Technical Proficiency:
• In-depth knowledge of SQL Server versions 2014 through 2019.
• Knowledge of working with "Availability groups" and "Recovery Models"
• Advanced skills in T-SQL and experience with database performance tuning and optimization.
• Familiarity with database development and scripting practices.
• Understanding of database security protocols, backup strategies, and disaster recovery processes.
• Experience with AWS or Azure cloud services is highly advantageous.
• RDS, EC2, and S3,

Key Competencies:

• Strong analytical and problem-solving capabilities.
• Effective communication and interpersonal skills.
• Detail-oriented with a strong focus on organization and process.
• Ability to manage multiple priorities and projects concurrently.
• Willingness to continuously learn and adapt to evolving technologies and methodologies.