Sr. Database Administrator

Database Administrator III

The Database Administrator III is responsible for all activities related to the administration of databases. The DBA III works independently and within a team and will be responsible for tracking the work assigned to database administration team members, resolve technical issues and estimate and schedule tasks. Business matters will be treated with the utmost urgency and focus on results and deadlines until each task or project is completed is key. The qualified candidate will display excellent problem solving, analytical, communication, coordination and task management skills. Confers with and advises the team on administrative policies and procedures, technical problems, priorities, and methods. Daily activities will include monitoring database environments, participating in planning meetings, providing estimates, handling ad-hoc requests, and tracking and communicating daily progress on projects and initiatives. This position will also take on various responsibilities throughout the department as assigned. Our DBA III will perform modern DBA task in AWS Redshift and AWS RDS instances.

Essential Functions

• Work with engineers to determine where the databases will reside in multi-tier distributed/shared applications, comparing hardware/infrastructure alternatives in conjunction with cost, use, growth, supportability, etc.
• Planning and executing database monitoring, maintenance, patching and upgrades, and work with infrastructure teams for scheduled maintenance and upgrades
• Work with Information Security team to define and implement standards, controls and security; adhere to IT audit requirements
• Track the work assigned to database administration team members, resolve technical issues and help estimate and schedule tasks
• Define database authorization rules, perform security audit, and perform platform assessment regarding proper support for the selected databases. Read and implement entity-relationship diagrams
• Handle multiple projects simultaneously and engage in problem solving on these projects
• Collaborate with application architects, product managers, business analysts and technical management team to design, develop and document databases, schemas, tables, functions, triggers, procedures, relationships and other necessary aspects of the database
• Design and develop complex database design from high level business requirements. Must be able to provide database design options, alternatives and recommendations based on experience and best practices for database design
• Establish standards for documentation and ensure that all designs are documented.
• Other tasks as assigned

Qualifications

• Bachelor’s Degree or higher strongly preferred in Computer Science or a related discipline and typically 5-7 years of experience
• 5+ years of SQL database technology experience.
• 2+ years of database management experience.
• Prefer AWS experienced
• AWS certifications are a plus
• In depth experience with database installation, configuration and upgrade.
• Excellent knowledge of Database backup and recovery of very large databases, typically multi terabytes.
• Expert level of performance and tuning skills.
• Excellent knowledge of SQL database/instance tuning, optimizing complex SQL statements for best possible performance.
• Proven leadership skills and ability to manage instances with multiple operating system platform.