The Sr. DBA role is responsible for improving the performance, reliability, and architecture of the database clusters.
Must be able to design, implement, and maintain database clusters. Responsible for the installation, configuration, maintenance, analysis and tuning of the database servers and related systems required to support the O'Reilly computing environment.
Essential Job Functions
Architect redundancy in the system to minimize Mean Time Between
Provide data recovery systems and tools to minimize Mean Time to
Collaborate with engineers to develop deployment and maintenance automation for existing and new services
Analyze and troubleshoot problems with the database, network, storage, servers and underlying VMware hosts
Assist with scheme migrations, currently using FlywayDB.
Manages the creation and modification of database objects to ensure any changes have been reviewed and approved before installing in production environment.
Provide leadership to the DBA team.
Works with development teams to optimize design of databases and access from applications.
Develops a methodology for the ongoing assessment of database performance and the identification of problem areas.
Researches available technology solutions. Evaluates and recommends options to improve database server environment.
Reviews database backup and disaster recovery resources to ensure company data is adequately protected.
Installs new software releases, system upgrades, evaluates and installs OS patches and resolves software related issues.
Develops a security scheme for the database environment and performs user account and group administration for database server when needed. Performs periodic review of accounts per audit requirements.
Works with IT Management and Internal Audit department to ensure server software and security configuration complies with audit requirements.
Provides database support assistance to the IT department and log support calls to vendor when required.
Responds to operational needs which may involve working after hours and/or travel to resolve issues.
Performs other duties as assigned.
Work with other IT Teams to troubleshoot errors and exceptions if needed.
Provide on call support for Database area.
Bachelor's Degree in Computer Information Systems or equivalent experience.
At least 5+ years in Database Administration including large scale server hardware and software systems.
Exceptional problem-solving skills.
Above average oral and written communications skills.
Willingness to work flexible schedule including nights/weekends.
Must work well in a team environment.
Must be able to learn independently.
Knowledge of Linux platforms (Ubuntu preferred), Windows, and AS/400 platforms
Knowledge of Database server software in O'Reilly computing environment including but not limited to ETL, BitBucket (GIT), PostgreSQL (EnterpriseDB preferred), Oracle, MySQL (Percona preferred), MSSQL, exposure to NoSQL (MongoDB preferred), and DB2.
Knowledge of FlywayDB, Hibernate ORM and Dynatrace