Job: Senior MySQL Database Administrator

Jobing Description

Description:
- Senior MySQL Database Administrator (RES000001OY)

Job Description

Senior MySQL Database Administrator-RES000001OY

Description

Job Description

The Senior DBA is responsible for designing and deploying database infrastructures in support of high volume, complex data transactions for specific services or groups of services. Specifically this position will support MySQL and MSSQL Server databases. The position will report to the Head of Database Services.

The Role

This role will primarily work with R&D, Architects, System Engineers, and Project Managers in a virtual team and focus on designing, building and deploying high availability, robust, resilient and supportable database solutions to support large volumes of data transactions. With a focus on the infrastructure and operational elements of designing and deploying a database solution, the Senior DBA must ensure the databases are highly available, have sufficient capacity in place and are fully resilient across multiple data centers.

Essential requirements include a proven track record of deploying and supporting database systems in a large consumer facing internet organization.

This role will also work very closely with key stakeholders from R&D teams, Technology Strategy Architecture teams to ensure we are deploying and evaluating appropriate database technologies and that the systems adhere to 99.9% or higher uptime.

Key Responsibilities

* Work as part of a database operations team to design, deploy and support 24x7x365 operations.
* Manage database systems in Development/QA/Production environments including installation, configuration, backup, recovery, replication, upgrades, schema changes, etc.
* Perform database health monitoring and diagnostics.
* Integrate monitoring, auditing, and alert systems for databases with existing monitoring infrastructure.
* Design, implement, maintain and automate the appropriate backup and recovery architecture required.
* Occasional off-shift availability to resolve Production issues or assist in Production deployments. On-call duties will be shared within the DBA Team.
* Work closely with other members of the DBA Team, mentor others in your areas of expertise, and be an active contributing member of the company as a whole
* Responsible for system performance and reliability.
* Responsible for databases dealing with overall operating system.
* Responsible for developing backup and recovery procedures for database environments.
* Maintains up-to-date knowledge of database administration and applies these developments to major NOKIA projects and initiatives
* Meticulous attention to detail with an appreciation for the relationship between database/system reliability and company success.
* Ensure proactive engagement in Incident Management process, working with Operational teams to minimize the impact of database outages.
* Work with Service Support teams to drive knowledge in to the Operations Center to improve 'First Contact' resolution and reduce Mean Time To Resolve (MTTR) for database incidents
* Builds positive working relationships across departments and with own team members.
* Presents or makes recommendations on best practices regarding data management, data architecture, and data design.

Qualifications

Qualifications

A successful candidate meets the following:

* Degree in Computing Science or equivalent
* 8+ years of production DBA experience
* Experience working in production environments requiring 99.9% availability.
* MySQL 5.0, 5.1, 5.5 experience
* MSSQL Server 2005 and 2008 experience
* Experience deploying and managing MySQL Cluster on Redhat Linux, CentOS, and other platforms
* Experience deploying and managing MSSQL Server clusters
* Scripting/Programming experience preferred
* Previous experience in other database technologies, such as Oracle, Sybase, and Postgres, is a major plus.
* Solid experience in database tuning, design, security, backup, recovery, and archival concepts and procedures.
* Familiarity with ETL processes and operations
* Understand the interaction between the database and the SAN. Knowledge of SAN specific database tuning techniques. Experience with hot backups through SAN snapshot technology.
* Experience with Nagios monitoring software.
* Used to working with Enterprise ticketing systems. BMC Remedy experience a plus.
* Ability to communicate effectively with technical and non-technical employees and with vendors of system related products.
* Strong problem solving, testing, and network troubleshooting skills.
* Meticulous attention to detail with an appreciation for the relationship between system reliability and company success.
* Comfort working in a truly international company and with teams in remote geographic locations.

* Strong technical background in three or more of the following technologies (must include database administration):
* Operating Systems: Red Hat Linux, CentOS, Windows Server
* Application Servers and Open Source Components: Linux, JBoss. Apache Lucene, PHP
* Storage Engineering: Network storage (NAS, SAN & Virtualized), Cluster
* Database Admin : MySQL, MySQL Cluster, MSSQL (Other RDBMs technologies)
* Deployment Tools: CVS, Subversion, Clearcase and Puppet (at least one tool)
* Monitoring Tools: Nagios Professional, Cacti
* Security : Encryption; Network security; Network topology; Cellular Network Connectivity

Protocols: HTTP, SSL/TLS, RTP&RTSP, TCP, UDP, IP inc. v6, DNS, Samba, CIFS, SOAP and REST; Peer-to-Peer Networking, Edge Computing

Job
Research & Development

Primary Location
US-Burlington

Other Locations
US-Alpharetta

Organization
Location & Commerce

Schedule
Full-time

Job Level
Individual Contributor

Education Level
Bachelor's Degree ( 16 years)

Job Type
Experienced

Employee Status
Regular

Travel
Yes, 25% of the time

Ongoing

Contact Name - External

Matthew Janda

Contact Email - External

matt.janda@nokia.com