Systems Engineer - DBA
Sanderson Recruitment
Dublin City Centre
Outstanding opportunity to work with a top class team in a global organisation. Senior Database Administrator required on a daily rate contract (DRC). The contract will be six months initially with the possibility to extend. In this role you will provide DBA support to the database development engineers, addressing design and performance issues as well as working with other database engineers to come up with strategic solutions to recurring problems. This DBA role requires a service oriented mentality, high sense of ownership of the problems and requests assigned, focus on managing and resolving issues in a prompt and efficient manor, establishing and maintaining communication to ensure the smooth transition of database changes from development to production environments in adherence with the development lifecycle. Position Requirements: SQL Server. Advanced knowledge of SQL Server data stores: row store and column store, optimisations. Advanced knowledge of indexes, index management, index design, index optimisations and index statistics. Advanced knowledge of SQL Server partitioning and file and filegroup design. Advanced Knowledge of SQL Server performance tuning, especially around stored procedures. Advanced knowledge of SQL Server database upgrades (DB Engines & Compatibility levels. Advanced knowledge of SQL Server H/A Solutions. Good knowledge of query and query parallelism in SQL Server. Good knowledge of Change Data CaptureGood knowledge of Column Store index and Column Store query optimisations. Good knowledge of SQL Server DMO’s especially around statistics, data store and performance. Good knowledge of SQL Server settings and database setting and the impact on performance. Experience with Database Administration in general for MSSQL Server on both om-premise & cloud platforms (AWS preferred. Experience in troubleshooting and resolving general database problems in a high transaction VLDB platform. Experience with database design & data modelling (experience with Erwin or similar data modeller tools is an advantage. Experience in database source control and deployments. Examples: SVN, CVS, Git, TFS. Experience in testing/validating database components. Experience with monitoring either native or via 3rd party. PostgreSQL. Good knowledge of provisioning environments in AWS on RDS Aurora PostgreSQL using automation. Good knowledge of PostgreSQL Monitoring & Alerting. Good knowledge of troubleshooting & performance reviewing issues with PgSQL. Experience in up-skilling/training team members is a considerable advantage. MySQL. Good knowledge of provisioning environments in AWS on RDS Native & Aurora MySQL using. Automation. Good experience in Partitioning & Partition Maintenance on RDS MySQL. Good knowledge of MySQL Monitoring & Alerting. Good knowledge of troubleshooting & performance reviewing issues with MySQL. Preferred Qualifications: BSc computer science/engineering or similar. Excellent communications skills to clearly articulate complex technical issues to all levels of the organization (both technical and non-technical.
1200 days ago