Position Type: Computer and Information Technology
Title:
Cloud Database Engineer III
Job Code:
UltiPro Job Code
FLSA Status:
Exempt
Reports To:
Director, IT Engineering and DevOps
Direct Reports:
No
Department:
Infr & Ops
Location:
MLK
Date Last Revised:
1/14/2021
Title IV Position:
No
Purpose of the Position:
The Cloud Database Engineer III leads in the systems implementation and management of UMA cloud and on-prem data systems in support of day to day 24x7 IT operations. The Cloud Database Engineer III leads in the requirements gathering, designing, testing, implementation, operational support, and re-engineering evaluation for enterprise data solutions at UMA. This position operates as a key member of UMA's DevOps initiative.
The Cloud Database Engineer III reports to the Director, IT Engineering and DevOps.
Key Responsibilities:
Functional:
Effectively communicate with both technical and non-technical staff as appropriate
Efficient in quickly accessing and appropriately escalating technical concerns
Provides technical leadership, hands-on implementation skills, and extensive troubleshooting skills for complex cloud and on-prem data systems and day to day IT operations support of operating system and application issues.
Participate within the DevOps team with the implementation of CI/CD pipelines and deployments for cloud-based data systems.
Responsible for the mentoring and guidance of other Cloud Database Engineers within the team.
Partner with IT Engineering and DevOps by providing guidance on alerting metrics and escalation paths for cloud and on-prem data systems.
Utilize and demonstrate advanced troubleshooting skills systemically, documentation of issues and working problems proactively out of the environment.
Proactively troubleshoots and implements solutions to ensure that all information systems products and services meet organization standards and end-user requirements.
Responsible for providing trend analysis to management team to enable them to make informed decisions regarding resource management.
Develop and enforce database administration, user standards, and procedures.
Establish best practices and policies for installing, configuring, maintaining, and troubleshooting end user access and usage of database applications
Develop IT standards and procedures for the organization.
Participates in IT Security assessments, risk analysis and reporting
Document the company's database environment.
Responds to requests for information on IT company policies, practices, guidelines and standards.
Design and implement an appropriate database backup and recovery strategy based on data volatility and application availability requirements.
Ensure the structural integrity of the databases and that only accurate and appropriate data is entered and maintained in the databases.
Proactively monitor the database environment and to make changes to data structures, SQL, application logic or the DBMS subsystem to optimize performance.
Ensure data availability using non-disruptive administration tactics.
Ensure that only authorized users have access to the data.
Assist with predicting growth based on application and data usage patterns and implementing the necessary database changes to accommodate the growth.
Responsible for resolving system issues.
May provide system or security awareness related training
Ensure the safety of Information Systems Assets and to protect systems from intentional or inadvertent access or destruction.
Weighs business needs against other concerns and articulates issues to management.
Develop and document standard configurations, build and support processes and FAQs.
Serves as a liaison or technical resource for others in IT or to partners within other business units.
Participate in On-Call rotation for after-hours support and troubleshooting
Perform other duties as assigned.
Technical:
Ensure overall performance, reliability, stability, and availability of UMA's Cloud and on-prem database systems and infrastructure.
Lead the configuration, management, and implantation of cloud and on-prem data systems.
Perform proactive maintenance, monitoring, and troubleshooting of SQL and all other database systems.
Troubleshoot SQL Server service outages as they occur, including after-hours and weekends.
Create documentation on database recovery and architecture effective provisioning, installation/configuration, operation, and maintenance of systems hardware and software and related infrastructure.
Work to ensure that the associated hardware resources allocated to the databases are configured for high resilience and are tuned for optimum performance.
When performance issues arise, determine the most effective way to increase performance including hardware purchases, server configuration changes, or index/query changes.
Identify and partner with developers to remediate inefficient or suboptimal performance of queries, processes, or data structures.
Guide complex and critical data/database management initiatives that typically involve multiple disciplines and multiple business groups, including responsibility for database architecture, design, integration, and/or data modeling.
Responsible for improvement and maintenance of the databases to include rollout and upgrades.
Work with IT Engineering and DevOps to ensure all database systems are backed up in a way that meets the business's Recovery Point Objectives (RPO).
Test backups to ensure we can meet the business' Recovery Time Objectives (RTO).
Lead architectural decisions for cloud and on-prem data system implementations and upgrades including clustering, log shipping, mirroring, SQL Database servers, Azure SQL Databases, Datalakes, Data Factory, Databricks, or other technologies.
Lead the configuration, tuning, and management SQL Always-On Availability Groups.
Deploy database change scripts provided by third party vendors.
Perform load and execution testing.
Develop and deploy methodologies for testing database performance and providing performance statistics and reports.
Responsible for assisting developers in creating stored procedures and SQL commands to properly query databases.
Continued development of database administration skills; keep abreast of latest techniques, best practices and trends and able to apply to project work.
Lead developing SQL queries/scripts and similar artifacts to validate the completeness, integrity and accuracy of data within data load/refresh, backup and recovery processes.
Lead in data analysis efforts to resolve complex database performance issues.
Lead with the design and development of automated solutions (scripts, functions, programs, processes) to increase the efficiency of the database administration and monitoring processes
Document designs and specifications that adhere to company practices.
Communicate needs as well as deployment and operations standards to Infrastructure Services.
Support Institutional Initiatives:
Keep current on institutional goals, objectives, and progress
Engage in institutional sponsored activities and initiatives as appropriate
Lead with courage in support of change initiatives that impact organization
Manages and assists in coordinating efforts between departments within UMA
Compliance:
Demonstrates knowledge of, and carefully follows all applicable federal and state compliance requirements and regulations including those prescribed by the Department of Education, accrediting agencies, CIE, and internal UMA policies and procedures.
Effectively communicates compliance requirements to students and other staff as appropriate and quickly escalates any compliance concerns to the Compliance department.
Work Experience, Skills & Abilities:
Minimum Requirements:
Bachelor's degree or equivalent combination of education and experience.
5 years of experience with database design and administration experience with Microsoft SQL Server databases
5 years of experience with Microsoft Azure cloud data services such as Azure SQL Databases, DataLake, DataBricks, SQL Server Stretch Databases, Power BI, and Data Factory.
5 years of experience writing T-SQL and stored procedures and query tuning on high transaction systems.
5 years of experience with Microsoft SQL Server in a high availability environment including Failover Clusters, Availability Groups and Transactional Replication.
Possess in-depth SQL knowledge to understand and review SQL and host language programs and to recommend changes for optimization.
Proficient experience with SQL Source control tools such as RedGate or VSTS.
Advanced working knowledge of SQL, Stored Procedures and SSIS packages.
Proficient in Database Administration and Data Replication techniques, processes and best practices and able to provide guidance to other development teams (BI, ETL, Software Engineering, etc.).
3 years of experience leading IT projects including requirements gathering, prioritization, and implementation
Ability to prioritize in the face of demanding time frames.
Proficient experience with Database monitoring tool sets such as SolarWinds DPA.
Proficient experience with Database Modeling and Design Tools (e.g., Erwin, Oracle Designer, ER Studio, etc.).
Proficient at collecting, storing, and managing the ability to query the organization's metadata.
Ability to translate a data model or logical database design into an actual physical database implementation and to manage that database once it has been implemented.
Possess procedural skills to help design, debug, implement, and maintain stored procedures, triggers, and user-defined functions that are stored in the DBMS.
Possess understanding of the advanced tenets of relational database technology and be able to accurately communicate them to others.
Able to integrate database administration requirements and tasks with general systems management requirements and tasks (such as job scheduling, network management, transaction processing, etc.).
Able to professionally communicate fluently in verbal and written English and effectively communicate with all level of the organization
Able to work in a team focused environment
Excellent customer service mindset and approach
Self-motivated; strong work ethic
Proficient in MS Office (Word, Excel, PowerPoint) and other business tools such as Skype and Microsoft Teams
Able to support a diverse and inclusive work environment
Preferred Requirements:
Bachelor's degree in computer science or another related major
Microsoft Certified: Azure Data Engineer Associate
Microsoft Certified: Azure Database Administrator Associate
MCSA: Microsoft SQL Server 2014 or 2016
3 - 5 years of experience in data warehouse concepts, practices, and procedures
2 - 5 years of experience working in a DevOps environment
Microsoft Certified: Azure Fundamentals
3 - 5 years of experience with ETL tools or ETL programming.
Expert level experience with relational database concepts (required), service-oriented architecture (SOA), ESB, and portal technologies.
Knowledge of other databases like Oracle and MySQL
Working Environment:
Office Environment - Must be able to work in the UMA Office
Up to 10% of travel required - Valid Driver's License required
Flexibility to work during non-standard hours for project implementations and troubleshooting
Flexibility to work evenings and weekends as needed.
Physical Demands:
Requires long periods of sitting at a desk working on a computer
Requires ability to travel
Requires occasional bending, stooping and squatting
Requires occasional lifting of up to 25 lbs or more at times.
OUR VALUES
Our institutional values are shaped and validated by our team members. They describe how we strive to operate and are the standards of behavior we look to embody.
ACT WITH INTEGRITY
We operate honestly and ethically in an industry-compliant fashion. We are fair and trustworthy in our interactions with all we serve. Our team members, at all levels, lead by example and strive to do the right thing for our students and for each other. We are disciplined professionals who strive to be straightforward and dependable.
CHAMPION STUDENT OUTCOMES
We live by a strong commitment to our students and are passionate about preparing them for meaningful careers. We are deeply dedicated to ensuring students' educational and career success. We excel at building our students' confidence and empowering them to reach their full potential.
COMMIT TO TEAM MEMBER SUCCESS
We are committed to our team members' success and to each other's success. We strive to create an environment that attracts and retains the best talent while offering continuous learning, professional development and career growth opportunities. We recognize and reward our team members for their contributions to the organization and to our students.
PURSUE RESULTS WITH PURPOSE
We pursue results with a sense of urgency and purpose. We take responsibility for achieving ambitious, measurable results and hold each other accountable. We think strategically and critically, greet new ideas and challenges openly, and look for innovative solutions to challenges.
HAVE FUN. BUILD ENERGY
Enjoying what we do is central to achieving our goals. Building energy, having fun, being optimistic and creating a positive working environment are all critical to our success and that of our students. We strive to be inspired and to inspire others. We consistently show appreciation and celebrate our successes, both large and small.
WORK AS ONE
We believe that diverse, inclusive teams produce breakthrough results. We strive to build and maintain positive relationships with colleagues from all types of backgrounds by showing respect and humility when interacting with each other and resolving conflicts in a constructive manner. By working together, we win together - as one - ensuring that the goals of the company are the focal point of our efforts.
Acknowledgment
This job description is intended to be an accurate reflection of the current position. It may not include every job responsibility. Job duties may fluctuate based on needs of the business. UMA reserves the right to revise the job or require that additional or different tasks be performed.
I have read and understand all the responsibilities and accountabilities in my job description. This job description is a tool used by me and management to help assess, evaluate and provide guidelines and expectations for the position named herein. I understand that it is not a contract and it does not constitute any guarantee of future employment.
