Database Solutions Specialist SQL

Database Solutions Specialist SQL– Job Profile
About Us
GKN Automotive is the market leader in conventional, all-wheel and electrified drive systems and solutions. With a comprehensive global footprint, we design, develop, manufacture and integrate an extensive range of driveline technologies for over 90% of the world’s car manufacturers.

Role purpose
The Database Solutions Specialist is responsible for the design, implementation, maintenance, and administration of Microsoft SQL Server databases. This role ensures the optimal performance, security, and availability of databases to support organizational objectives and business needs. The DSS will work closely with development teams, system administrators, and other IT professionals to optimize database performance, implement best practices, and troubleshoot issues.

Key responsibilities
Database Design and Implementation
Plan and execute database installations, upgrades, and migrations including cloud ones.
Centralize management and standardization to simplify system administration, improve redundancy and operational efficiency. Collaborate with application developers to design and optimize database schemas, queries, and indexing strategies.
System Administration
Optimize existing infrastructure to improve performance, scalability, and cost-efficiency.
Implement and maintain monitoring tools to proactively detect and address performance issues. Identify and resolve performance bottlenecks and other database-related issues.
Monitor database performance and tune queries, indexes, and configurations to ensure optimal performance.
Security and Compliance
Implement and enforce database security policies to protect sensitive data.
Ensure compliance with data privacy regulations and organizational policies.

Perform regular system updates, patches, and security configurations.
Maintenance and Support
Provide support for database-related issues and incidents, including on-call support as needed. Monitor database growth and plan for future capacity needs.
Optimize storage and resource usage to maximize efficiency.
Provide technical support and troubleshooting assistance to internal teams.
Document database configurations, procedures, and troubleshooting steps.
Values & Behaviours
Ingenious: Effective decision making
Makes good and timely decisions that keep the organization moving forward. For example, knows when to act independently and when to escalate issues. Integrates various inputs, decision criteria, and trade-offs to make effective decisions. Typically makes good independent decisions.
Ingenious: Driving continuous improvement
Knows the most effective and efficient processes to get things done, with a focus on continuous improvement. For example, generally follows defined and communicated standards, methods, and procedures. Seeks advice and finds ways to work better within processes. Makes some reasonable suggestions to improve work methods.
Ingenious: Innovative thinking
Creates new and better ways for the organization to be successful. For example, demonstrates openness to new ideas and ways of looking at things; suggests new and useful ideas or solutions. Learns innovative methods, tools, and technology and applies them to work tasks.
Collaborative: Builds relationships
Builds partnerships and works collaboratively with others to meet shared objectives. For example, readily involves others to accomplish goals; stays in touch and shares information; discourages "us versus them" thinking; shows appreciation for others' ideas and input.
Principled: Accountability
Holds self and others accountable to meet commitments. For example, accepts
 responsibility for own work, both successes and failures. Handles fair share and does not make excuses for problems. Usually meets commitments to others.
Principled: Communicates effectively

Develops and delivers multi-mode communications that convey a clear understanding of the unique needs of different audiences. For example, pays attention to others' insights, advice, or instruction, grasping the main elements. Promptly shares relevant information with the right amount of detail.
Driven: Early technical adopter
Anticipates and adopts innovations in business-building digital and technology applications.
For example, investigates technologies to learn some cutting-edge best practices. Uses digital/social media to benefit the team and add value to the work being done; understands how to avoid misuse of these tools.
Driven: Action oriented
Takes on new opportunities and tough challenges with a sense of urgency, high energy, and enthusiasm. For example, identifies what needs to be done and acts quickly. Shows optimism and enthusiasm that affects others positively. Works independently, but knows when to ask for help.

Skills
Professional Experience
Proven experience as an MS SQL Database Administrator or in a similar role.
Technical Expertise
Strong knowledge of SQL Server architecture, administration, and performance tuning.
Experience with Database as a Service and cloud solutions.Experience with backup and recovery strategies, disaster recovery planning, and database security best practices.
Proficiency in T-SQL and experience with database development. Experience in query tuning, index optimization, and performance troubleshooting. Familiarity with tools and techniques for monitoring and enhancing database performance.
Cloud Migrations and Centralizations:
Knowledge of cloud-based database services, architecture, and best practices for scalability and performance. Proven experience in migrating databases to cloud platforms. Ability to plan and execute database centralization projects.

Certifications and Additional Skills
ITIL Certification (highly desirable)
Microsoft Certified: SQL Server Database Administrator
Microsoft Certified: Azure Database Administrator Associate
Education
Bachelor's degree in Computer Science, Information Technology, or a related field (or equivalent work experience).