Database Automation Administrator III at Cambia Health Solutions in Seattle, WA

Primary Job Purpose

The Database Automation Administrator III is responsible for the design, development, implementation, integration, and maintenance of multiple premium and core database management technologies, tools and utilities. This position provides technical, interpersonal and administrative skills in performing day to day work.

General Functions and Outcomes

• Understands data modeling concepts and methodologies.
• Works with a team to deliver and maintain database systems. Responsible for the design, development, implementation, integration, and maintenance of multiple premium and core database management technologies, tools and utilities. This position provides technical, interpersonal and administrative skills in performing day to day work.
• Responsible for, but are not limited to: requirements analysis, system design, implementation, testing, troubleshooting, patching, monitoring, tuning, securing, recovery and documentation of database management technologies, tools and utilities.
• Must adhere to IT departmental policies, standards and procedures. Those include, but are not limited to; technical and architecture standards, production and operational processes, and software license compliance.
• Able to perform the following basic database administrator functions with one or more core and preferred database technologies such as plan and communicate server and storage capacity requirements; install and configure database software, install and configure appropriate or necessary software patch or upgrades, design and configure database operational structures per application functional and operational requirements, configure database backups per operational requirements, configure database with application and user security per policy and standards, monitor and tune databases to meet operational performance and capacity requirements, monitor and tune databases to meet backup and security requirements, develops and maintains database operational support documentation, work with software vendors to resolve technical issues with database functionality and follow all established policies, procedures, processes, standards, or guidelines
• Designs and implements low-medium complex database systems or solutions. Includes architecting the design of software, backup & recovery, security, capacity, performance, or replication as it pertains database solutions.
• Plans, coordinates, and facilitates low-medium complex changes to production environments and systems within approved maintenance windows and with no unapproved impact to customers.
• Recognizes need to improve personal, interpersonal, and increase technical and leadership skills/behavior. Seeks new knowledge independently, creatively crafts own development. Is personally committed to and actively works to continuously improve him/herself. Works on compensating for weakness and limits.
• Participates in a team environment for the delivery and maintenance of data and/or database management systems.
• Meets established deadlines while maintaining a high level of quality.
• Takes initiative and seeks out work.
• Provides development and operational support services to two or more core and preferred database technologies.
• Designs and implements highly complex database systems or solutions. Includes architecting the design of networks, hardware, software, backup & recovery, security, capacity, performance, or replication as it pertains database solutions.
• Performs regular review of database environments, systems or applications to ensure system recoverability, performance, security and capacity adequately supports defined system requirements.
• Develops clear, quality and maintainable data management policies, standards, processes, procedures, methodologies, guidelines and system support guides. Seeks to improve policies, standards, processes and procedures.
• Provides consulting and communication to co-workers, customers and partners regarding appropriate use of established departmental policies, standards, practices and appropriate use and compliance with software licenses.
• Maintains inventory of departmental assets.
• Maintains knowledge of departmental software license inventory and utilization agreements.
• Participate in the evaluation of departmental tools or utilities used to provide automation or operational efficiencies. Able to provide recommendation and justification for purchase or utilization.
• Plans, coordinates and facilitates highly complex changes to production environments and systems within approved maintenance windows and with no unapproved impact to customers.
• Assists the manager in performing technical interviews, assessing technical abilities and personal behaviors, and provides recommendation for hiring.
• Provides consulting support for IT and Business partners by researching, identifying and resolving complex technical problems.
• Develops, tracks and executes quality work plans.
• Understands, directs and participates in deliverables required by approved IT Development Lifecycle.
• Provides leadership, training and mentoring on departmental technologies, standards and processes to co-workers.

Minimum Requirements

• Demonstrated experience with several of the following technologies, tools, utilities or methodologies such as MS SQL Server RDBMS, Windows, Clustering, Replication, Always-On, CDC
• Demonstrated experience writing stored procedures, functions, scripts using SQL Server, Transact SQL, Powershell, Windows cmd, Python Shell scripting.
• Demonstrated experience using automation tools such as Git, GitLab, GitLab Runners, and ideally with Ansible and Jenkins
• Ability to effectively adapt to rapidly changing technologies and methodologies and apply them to technological and/or business needs of limited scope.
• Ability to analyze, diagnose and resolve minor technical problems and system coordination issues.
• Ability to work well with business customers and IT partners.
• Demonstrated understanding of application development concepts and methodologies.
• Demonstrated ability to communicate clearly in a timely manner in both verbal and written communication. Develop and maintains effective relationships within the team and across teams.
• Ability to effectively adapt to rapidly changing technologies and methodologies and apply them to technological and/or business needs of mid-level scope.
• Basic understanding of data modeling concepts and methodologies.
• Ability to analyze, diagnose and resolve mid-level technical problems and system coordination issues.
• Ability to plan and manage his/her own work.
• Ability to analyze, diagnose and resolve complex technical problems and system coordination issues.
• Ability to plan
• and manage his/her own work, as well as 1-2 other team members.
• Ability to lead and collaborate with multi-discipline teams for work efforts which includes estimating, coordinating, tracking progress, inspiring others to complete tasks on time, assisting with resolving issues and creating status reports.
• Ability to interact comfortably with more senior managers and executives, without display of overt tension and nervousness.
• Ability to effectively adapt to rapidly changing technologies and methodologies and apply them to technological and/or business needs of significant scope.

Normally to be proficient in the competencies listed above

The Database Automation Administrator III would have a Bachelor’s degree in Computer Science, Mathematics, Business Administration, Engineering or a related field with six years’ experience in information systems/technology and four years relevant experience with support or management of multiple relational database technologies or an equivalent combination of education and experience.