Senior Database Administrator – Oracle
Summary: Database Administrators are responsible for providing operational support and maintenance in project and hosted environments. They work closely with development, project and hosting teams to support these environments.
Description of the role
This is what our database administrators working day may look like;
- Managing and resolving database requests.
- Can take ownership of database-related tasks, working closely with teams across the company, and be involved in hands-on tasks ranging from server setup to administration and troubleshooting
- Installation, configuration management, maintenance and support of the database environments.
- Creating and maintaining database documentation – standards, policies and procedures.
- Coordinating with development and production teams to ensure standards and policies are agreed upon and enforced.
- Assisting in the tuning of SQL code and database migrations.
- Supporting teams by providing stable database environments.
- Monitoring database environments and respond to alerts.
- Monitoring database performance, troubleshoot, and recommend tuning measures as required.
- Recommending and managing databases and user security.
- Performing periodic health checks on database environments.
- Database maintenance functions – backup and restore, start-up and shutdown, troubleshoot connection and system failures, index and statistic maintenance and optimization
- Developing procedures and scripts that can be used by operational teams to perform routine backups, create users and monitor database issues.
- Performing routine environment refreshes and configuration as and when required.
- Offer advice and support on the design and planning of new and existing database objects, scripts and functionality.
- Advising on development coding standards.
- Creating lightweight, portable scripts for automation of complex functions such as monitoring, database upgrades, database maintenance, data migration, metrics collection, analysis, audit evidence collection and data denormalization.
- Identifying and analysing performance issues; suggest resolutions through database design improvement, indexing strategies and refactoring.
- Collaborating with developers on database design and participate in database capacity planning.
- Reviewing SQL code and recommend optimizations while enforcing best practices.
- Evaluating and recommend database tools.
Requirements of the role
- 5+ years of hands-on Oracle Server DBA experience
- Linux, Windows, SQL, RMAN (Recovery Manager)
- Experience in performance tuning and troubleshooting – query tuning, indexing, locking.
- Extensive experience performing RDBMS software installation, database creation, database sizing, the establishment of backup and recovery procedures and scripts, database performance tuning.
- Capable of working with minimal supervision, prioritizing, and meeting deadlines
- Strong time management, organization, analytical skills, and the ability to identify opportunities for optimization and process improvement
- Outstanding interpersonal skills (both oral & written) and the ability to work closely with various technical teams of all skill levels.
- Experience working in a fast-paced and evolving environment and able to demonstrate the ability to be proactive without minimal supervision.
- Knowledge of scripting languages, PL/SQL, AWS, Amazon RDS for Oracle
- SQL Server database administration
White Clarke Group are committed to welcoming people with disabilities with respect to recruitment, employment, training, career development and career progression and welcomes and encourages applications from people with disabilities. Accommodations are available upon request for candidates taking part in all aspects of the selection process.